group objects in array based on value of key in object

Question

I have the following data that I want to sort based on the date - not including the timestamp.

NOTE: I have access to moment for this task.

My data looks like the following:

const data = [
   {
     "fixture": "AC v Inter",
     "kickOffTime": "2018-06-14T15:00:00Z",
   },
   {
     "fixture": "DC v NYC",
     "kickOffTime": "2018-06-15T12:00:00Z",
   },
   {
     "fixture": "AFC v LPC",
     "kickOffTime": "2018-06-15T15:00:00Z",
   },
   {
      "fixture": "DTA v MC",
      "kickOffTime": "2018-06-15T18:00:00Z",
    },
    {
       "fixture": "LAC v GC",
       "kickOffTime": "2018-06-16T18:00:00Z",
    }
];

I have tried a number of approaches. The final result I am hoping to achieve is the following data structure.

const updatedDataStructure = [
   {
     date: "2018-06-14",
     fixtures: [{
        "fixture": "AC v Inter",
        "kickOffTime": "2018-06-14T15:00:00Z",
      }]
   },
   {
     date: "2018-06-15",
     fixtures: [
      {
        "fixture": "DC v NYC",
        "kickOffTime": "2018-06-15T12:00:00Z",
       }, 
      {
        "fixture": "AFC v LPC",
       "kickOffTime": "2018-06-15T15:00:00Z",
      },
      {
        "fixture": "DTA v MC",
        "kickOffTime": "2018-06-15T18:00:00Z",
       },
     ]
   }, 
   {
     date: "2018-06-16",
     fixtures: [{
         "fixture": "LAC v GC",
         "kickOffTime": "2018-06-16T18:00:00Z",
     }]
   },
];

Here was my latest attempt which NEARLY worked:

const result = fixtures.reduce(function (r, a) {
  r[moment(a.kickOffTime).format('ddd Do MMM')] = r[moment(a.kickOffTime).format('ddd Do MMM')] || [];
  r[moment(a.kickOffTime).format('ddd Do MMM')].push(a);
  return r;
}, Object.create(null));

Eddie · Accepted Answer · 2018-06-13 13:46:23Z

4

You can group the array using reduce into an object. Using Object.values you can convert the object into array.

const data = [{
    "fixture": "AC v Inter",
    "kickOffTime": "2018-06-14T15:00:00Z",
  },
  {
    "fixture": "DC v NYC",
    "kickOffTime": "2018-06-15T12:00:00Z",
  },
  {
    "fixture": "AFC v LPC",
    "kickOffTime": "2018-06-15T15:00:00Z",
  },
  {
    "fixture": "DTA v MC",
    "kickOffTime": "2018-06-15T18:00:00Z",
  },
  {
    "fixture": "LAC v GC",
    "kickOffTime": "2018-06-16T18:00:00Z",
  }
];

const result = Object.values(data.reduce((c, v) => {
  let t = v['kickOffTime'].split('T', 1)[0];
  c[t] = c[t] || {date: t,fixtures: []}
  c[t].fixtures.push(v);
  return c;
}, {}));

console.log(result);

answered Jun 13, 2018 at 13:46

Eddie

26.8k6 gold badges39 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

peter flanagan Over a year ago

other answer got there first so I will give it to the other user, but gave you a +1 too, great answer!

Eddie Over a year ago

@peterflanagan No worries. Thanks :)

peter flanagan Over a year ago

I am actually using your solution too - it is a bit tidier :-D

Nina Scholz · Accepted Answer · 2018-06-13 13:46:33Z

You could take just a slice from the date and later take the entries of the object and map new key/values.

 const
     data = [{ fixture: "AC v Inter", kickOffTime: "2018-06-14T15:00:00Z" }, { fixture: "DC v NYC", kickOffTime: "2018-06-15T12:00:00Z" }, { fixture: "AFC v LPC", kickOffTime: "2018-06-15T15:00:00Z" }, { fixture: "DTA v MC", kickOffTime: "2018-06-15T18:00:00Z" }, { fixture: "LAC v GC", kickOffTime: "2018-06-16T18:00:00Z" }];
     result = Object
        .entries(data.reduce((r, a) => {
            var key = a.kickOffTime.slice(0, 10);
            r[key] = r[key] || [];
            r[key].push(a);
            return r;
        }, Object.create(null)))
        .map(([date, fixtures]) => ({ date, fixtures }));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Collectives™ on Stack Overflow

group objects in array based on value of key in object

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related