How to group an array of objects

Question

I have an array of objects in the below format

const Employer = [{'company': 'ABC','location': 'Phase 1','year': '2012'}, 
    {'company': 'ABC','location': 'Phase2', 'year': '2013'}, 
    {'company': 'XYZ','location': 'Phase3','year': '2012'}];

And expected output is

  {
      'ABC':{
        'company': 'ABC',
         data:[
          {'location':'Phase1','year':2012},
          {'location':'Phase2', 'year':2013}]
         },
      'XYZ':{
        'company': 'ABC',
         data:[
          {'location':'Phase3','year':2012}]
      }           
    }

What I have tried is

name = 'Angular';
  groupedData:any;
  
  ngOnInit(){
    const Employer = [{'company': 'ABC','location': 'Phase 1','year': '2012'}, 
    {'company': 'ABC','location': 'Phase2', 'year': '2013'}, 
    {'company': 'XYZ','location': 'Phase3','year': '2012'}];
  
    this.groupedData = _.mapValues(_.groupBy(Employer, 'company'))    
    console.log(this.groupedData)
}
}

Output:
{
  "ABC": [
    {
      "company": "ABC",
      "location": "Phase 1",
      "year": "2012"
    },
    {
      "company": "ABC",
      "location": "Phase2",
      "year": "2013"
    }
  ],
  "XYZ": [
    {
      "company": "XYZ",
      "location": "Phase3",
      "year": "2012"
    }
  ]
}

Here again I need to group the data. Can anyone help me to get the expected output

zainhassan · Accepted Answer · 2022-02-05 20:19:19Z

1

    const Employers = [{ 'company': 'ABC', 'location': 'Phase 1', 'year': '2012' },
    { 'company': 'ABC', 'location': 'Phase2', 'year': '2013' },
    { 'company': 'XYZ', 'location': 'Phase3', 'year': '2012' }];

    const output: any = {};
    for (const e of Employers) {
        if (output[e.company]) {
            output[e.company].data.push({ location: e.location, year: e.year });
        } else {
            output[e.company] = { company: e.company, data: [{ location: e.location, year: e.year }] };
        }
    }

    console.log(output);

answered Feb 5, 2022 at 20:19

zainhassan

1,7929 silver badges12 bronze badges

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

Comments

Kartik Malik · Accepted Answer · 2022-02-05 20:20:08Z

1

A very basic approach to do so is below

const Employers = [{'company': 'ABC','location': 'Phase 1','year': '2012'}, 
    {'company': 'ABC','location': 'Phase2', 'year': '2013'}, 
    {'company': 'XYZ','location': 'Phase3','year': '2012'}];
   
const result = {};

Employers.forEach(employer=>{
    const employerTemp = {...employer}
    delete employerTemp.company
    if(!result[employer.company]){
    result[employer.company] = {
         company: employer.company,
         data: [employerTemp]
      }
    } else {
         result[employer.company].data.push(employerTemp)
    }
})

console.log(result)

You can achieve the same thing using reduce also

answered Feb 5, 2022 at 20:20

Kartik Malik

5055 silver badges11 bronze badges

Comments

Yimin · Accepted Answer · 2022-02-05 20:32:15Z

0

Edit: Fixed Answer

const Employer = [
  { company: "ABC", location: "Phase 1", year: "2012" },
  { company: "ABC", location: "Phase2", year: "2013" },
  { company: "XYZ", location: "Phase3", year: "2012" },
];

const groupedData = Employer.reduce((prev, current) => {
  if (!prev[current.company]) {
    prev[current.company] = { company: current.company, data: [] };
  }

  const currentTemp = { ...current };
  delete currentTemp.company;

  prev[current.company].data.push(currentTemp);
  return prev;
}, {});

console.dir(groupedData, { depth: null });

edited Feb 5, 2022 at 20:32

answered Feb 5, 2022 at 20:13

Yimin

3652 silver badges9 bronze badges

2 Comments

Irfan Anwar Over a year ago

nice but, this output she has already done you can read her question again

Irfan Anwar Over a year ago

@Yirmin good job, but I did not vote down your answer, someone else did

JaivBhup · Accepted Answer · 2022-02-05 20:36:59Z

-1

const Employer = [{'company': 'ABC','location': 'Phase 1','year': '2012'}, 
    {'company': 'ABC','location': 'Phase2', 'year': '2013'}, 
    {'company': 'XYZ','location': 'Phase3','year': '2012'}];
    
    
 var obj = {};
 
 for(let a of Employer){
  if(obj[a.company]){
   obj[a.company].data.push({location:a.location,year:a.year})
  }else{
   obj[a.company] = {
    company:a.company,
    data:[{location:a.location,year:a.year}]
   }
  }
 }
 
 console.log(obj)

answered Feb 5, 2022 at 20:36

JaivBhup

8655 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to group an array of objects

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related