Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

group dates by week javascript

I have the array of Persian dates and I want to group dates by the week. for example, I have the following array:

[
    "1396-10-11 09:07:21",
    "1396-10-10 10:03:51",
    "1396-10-07 02:07:02",
    "1396-11-27 08:02:45",
    "1396-11-19 01:02:32",
    "1396-12-01 22:13:21",
    "1396-02-12 09:07:21",
    "1396-05-18 04:02:29",
    "1396-05-21 14:01:42",
    "1396-07-11 01:16:29"
]

and I want to groupBy dates by the week.

I wrote following code but not working good:

Array.prototype.groupBy = function(prop) {
  return this.reduce(function(groups, item) {
    var val = item[prop];
    groups[val] = groups[val] || [];
    groups[val].push(item);
    return groups;
  }, {});
}

const formatted = dates.map(elem => {
  return { 
    numberOfWeek: moment(elem.date, 'jYYYY-jMM-jDD').startOf('jMonth').jWeek(),
    date: moment(elem.date, 'jYYYY-jMM-jDD').format('jYYYY-jMM-jDD'), 
    score: elem.score 
  };
});
like image 361
Omid Nikrah Avatar asked Jan 03 '18 19:01

Omid Nikrah


2 Answers

You can use moment().week() to get the week number of the year and then group by it, here is a working example, I used array.reduce to create a new object of dates grouped by the week number:

const dates = [
  "1396-10-11 09:07:21",
  "1396-10-10 10:03:51",
  "1396-10-07 02:07:02",
  "1396-11-27 08:02:45",
  "1396-11-19 01:02:32",
  "1396-12-01 22:13:21",
  "1396-02-12 09:07:21",
  "1396-05-18 04:02:29",
  "1396-05-21 14:01:42",
  "1396-07-11 01:16:29"
];

const groups = dates.reduce((acc, date) => {

  // create a composed key: 'year-week' 
  const yearWeek = `${moment(date).year()}-${moment(date).week()}`;
  
  // add this key as a property to the result object
  if (!acc[yearWeek]) {
    acc[yearWeek] = [];
  }
  
  // push the current date that belongs to the year-week calculated befor
  acc[yearWeek].push(date);

  return acc;

}, {});

console.log(groups);
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.20.1/moment.min.js"></script>
like image 155
YouneL Avatar answered Nov 11 '22 17:11

YouneL


Another simple way of achieving the same with Lodash would be as follows:

const groupBy = require('lodash/groupBy');
const moment = require('moment');
const data = [
   "1396-10-11 09:07:21",
   "1396-10-10 10:03:51",
   "1396-10-07 02:07:02",
   "1396-11-27 08:02:45",
   "1396-11-19 01:02:32",
   "1396-12-01 22:13:21",
   "1396-02-12 09:07:21",
   "1396-05-18 04:02:29",
   "1396-05-21 14:01:42",
   "1396-07-11 01:16:29"
];

groupBy(data, (dt) => moment(dt).week());

Result is as follows:

{ 
  '7': [ '1396-02-12 09:07:21' ],
  '21': [ '1396-05-18 04:02:29', '1396-05-21 14:01:42' ],
  '29': [ '1396-07-11 01:16:29' ],
  '41': [ '1396-10-07 02:07:02' ],
  '42': [ '1396-10-11 09:07:21', '1396-10-10 10:03:51' ],
  '47': [ '1396-11-19 01:02:32' ],
  '49': [ '1396-11-27 08:02:45', '1396-12-01 22:13:21' ] 
}
like image 23
Sohail Avatar answered Nov 11 '22 18:11

Sohail