Creating arrays that group timestamps into sets of three objects maximum per group, each group representing one day, can be achieved by

Question

Creating arrays that group timestamps into sets of three objects maximum per group, each group representing one day, can be achieved by

[Junior Dev !!] [Javascript] Hi !

How can I group timestamps into daily intervals with a maximum of 3 objects in each group?

I've seen examples of grouping by timestamp, but how do we both order and limit the array size at the same time?

I have:

const restuls= [
{date: "2022-10-14T21:14:41.000Z", id: "1"},
{date: "2022-10-14T21:15:48.000Z", id: "2"},
{date: "2022-09-20T18:16:01.000Z", id: "3"},
{date: "2022-09-20T18:16:48.000Z", id: "4"},
{date: "2022-09-20T21:14:52.000Z", id: "5"},
{date: "2022-09-20T21:14:15.000Z", id: "6"},
{date: "2022-09-20T21:14:03.000Z", id: "7"},
{date: "2022-09-18T10:09:33.000Z", id: "8"},
{date: "2022-09-18T10:08:12.000Z", id: "9"},
{date: "2022-09-18T10:07:50.000Z", id: "10"}
]

Expected output:

[
  [
   {date: "2022-10-14T21:14:41.000Z", id: "1"},
   {date: "2022-10-14T21:15:48.000Z", id: "2"}
  ],

  [
   {date: "2022-09-20T18:16:01.000Z", id: "3"},
   {date: "2022-09-20T18:16:48.000Z", id: "4"},
   {date: "2022-09-20T21:14:52.000Z", id: "5"}
  ],
  [
   {date: "2022-09-20T21:14:15.000Z", id: "6"},
   {date: "2022-09-20T21:14:03.000Z", id: "7"}
  ],
  [
   {date: "2022-09-18T10:09:33.000Z", id: "8"},
   {date: "2022-09-18T10:08:12.000Z", id: "9"},
   {date: "2022-09-18T10:07:50.000Z", id: "10"}
  ]
]

Thanks

javascript arrays algorithm datetime

Answer 1

Answer №1

Utilizing a simple function with modulo can efficiently solve the problem.

I quickly put together this code during work hours, but it may require some refactoring.

EDITED:

results = [{
    date: "2022-10-14T21:14:41.000Z",
    id: "1"
  },
  {
    date: "2022-10-14T21:15:48.000Z",
    id: "2"
  },
  {
    date: "2022-09-20T18:16:01.000Z",
    id: "3"
  },
  {
    date: "2022-09-20T18:16:48.000Z",
    id: "4"
  },
  {
    date: "2022-09-20T21:14:52.000Z",
    id: "5"
  },
  {
    date: "2022-09-20T21:14:15.000Z",
    id: "6"
  },
  {
    date: "2022-09-20T21:14:03.000Z",
    id: "7"
  },
  {
    date: "2022-09-18T10:09:33.000Z",
    id: "8"
  },
  {
    date: "2022-09-18T10:08:12.000Z",
    id: "9"
  },
  {
    date: "2022-09-18T10:07:50.000Z",
    id: "10"
  }
];

function groupByDateMaxThreeItems(array) {
  index = 0;
  arr = [];
  result = [];
  array = array.sort(function(a, b) {
    return new Date(b.date) - new Date(a.date);
  });

  for (item of array) {
    index = index + 1;
    if (index % 3 === 0 || !isSameDay(array[index - 1], item)) {
      result.push(arr);
      arr = [];
    }
    arr.push(item)
  }
  return result;
}

function isSameDay(item1, item2) {
  date1 = new Date(item1.date);
  date2 = new Date(item2.date);

  return (
    date1.getYear() + date1.getMonth() + date1.getDay() ==
    date2.getYear() + date2.getMonth() + date2.getDay()
  );
}

console.log(groupByDateMaxThreeItems(results));

Answer 2

Utilizing a simple function with modulo can efficiently solve the problem.

I quickly put together this code during work hours, but it may require some refactoring.

EDITED:

results = [{
    date: "2022-10-14T21:14:41.000Z",
    id: "1"
  },
  {
    date: "2022-10-14T21:15:48.000Z",
    id: "2"
  },
  {
    date: "2022-09-20T18:16:01.000Z",
    id: "3"
  },
  {
    date: "2022-09-20T18:16:48.000Z",
    id: "4"
  },
  {
    date: "2022-09-20T21:14:52.000Z",
    id: "5"
  },
  {
    date: "2022-09-20T21:14:15.000Z",
    id: "6"
  },
  {
    date: "2022-09-20T21:14:03.000Z",
    id: "7"
  },
  {
    date: "2022-09-18T10:09:33.000Z",
    id: "8"
  },
  {
    date: "2022-09-18T10:08:12.000Z",
    id: "9"
  },
  {
    date: "2022-09-18T10:07:50.000Z",
    id: "10"
  }
];

function groupByDateMaxThreeItems(array) {
  index = 0;
  arr = [];
  result = [];
  array = array.sort(function(a, b) {
    return new Date(b.date) - new Date(a.date);
  });

  for (item of array) {
    index = index + 1;
    if (index % 3 === 0 || !isSameDay(array[index - 1], item)) {
      result.push(arr);
      arr = [];
    }
    arr.push(item)
  }
  return result;
}

function isSameDay(item1, item2) {
  date1 = new Date(item1.date);
  date2 = new Date(item2.date);

  return (
    date1.getYear() + date1.getMonth() + date1.getDay() ==
    date2.getYear() + date2.getMonth() + date2.getDay()
  );
}

console.log(groupByDateMaxThreeItems(results));

Creating arrays that group timestamps into sets of three objects maximum per group, each group representing one day, can be achieved by

How can I group timestamps into daily intervals with a maximum of 3 objects in each group?

I have:

Expected output:

Answer №1

Similar questions

Vue.js: Utilizing anonymous functions within props object

Is there a way to retrieve JSON data with form.submit()?

After updating to Angular 7, an error was encountered: "TypeError: Unable to execute map function on ctorParameters"

Tips for transferring backend information to show up as options in a multiselect dropdown menu (Jsfiddle link included)

Execute a join operation on a dataset solely based on the matching of substrings

extract() of the incoming information

The Everyday Explanation of Same Origin Policy

Can you update the `runtime` property to `segment` in the export config?

When comparing TypeScript class functions with regular functions and variables, which one yields better performance?

I encountered a 404 error when attempting to execute the "npm publish" command

Encountering difficulty retrieving data upon initial click within an Android webview during server communication

Ways to add AJAX information to select2

Implementing ui-sref-active for intricate routing states

Running npm start in a React development environment on Linux without automatically opening a browser can be achieved by configuring

Extract data from a website with Python and selenium

Issue with data-ng-class function not being invoked

Sending the object context back to the controller callback from an AngularJS Directive

The use of the 'v-on' directive with the 'KeyboardEvent.keyCode' modifier is no longer recommended in Vue. It is now recommended to use 'KeyboardEvent.key' instead

What is the most effective way to modify a specific field within a MongoDB document - utilizing either the update or patch hook in FeathersJS?

Issue encountered while fetching data from SQL database in a Node.js application