How to dynamically select the property by which my JSON object has to grouped by in Javascript

Question

I am trying to dynamically change the value of property by which the JSON object has to be grouped by . for example if my search criteria is location i want to display work location of employee as key and no of employees in that location as pair whereas the location is one of the property in JSON .

This is what i have done so far. i am able to group employees based on location and its count as key value pair.

 var rows = [
    {
      "empId": 1,
      "empName": "aaa",
      "skillSet": "JAVA",
      "location": "chennai"
    },
    {
        "empId": 2,
        "empName": "bbb",
        "skillSet": "Angular",
        "location": "chennai"
    },
    {
        "empId": 3,
        "empName": "ccc",
        "skillSet": "Angular",
        "location": "chennai"
    },
    {
        "empId": 4,
        "empName": "ddd",
        "skillSet": "JAVA",
        "location": "bangalore"
    },
    {
        "empId": 5,
        "empName": "eee",
        "skillSet": "JAVA",
        "location": "chennai"
    },
    {
        "empId": 6,
        "empName": "fff",
        "skillSet": "JAVA",
        "location": "bangalore"
    },
    {
        "empId": 7,
        "empName": "ggg",
        "skillSet": "oracle",
        "location": "chennai"
    },
    {
        "empId": 8,
        "empName": "hhh",
        "skillSet": "JAVA",
        "location": "hyderabad"
    },
    {
        "empId": 9,
        "empName": "iii",
        "skillSet": "JAVA",
        "location": "hyderabad"
    }
  ] 

        var occurences = rows.reduce(function (r, row) {
          r[row.location] = ++r[row.location] || 1;
          return r;
      }, {});

      var result = Object.keys(occurences).map(function (key) {
          return { key: key, value: occurences[key] };
      });

      console.log(result);

and my result is

[{
        "key": "chennai",
        "value": 5
    },
    {
        "key": "bangalore",
        "value": 2
    },
    {
        "key": "hyderabad",
        "value": 2
    }
]

As yo can see i have hardcoded the location directly

r[row.location] = ++r[row.location] || 1;

instead i want to make to dynamically like i can also should be able to group it using other attributes like skillSet also . But How do it .

Set the key you want to count by in a variable, eg `var countKey = 'location'` then use `row[countKey]` — Phil, Oct 23 '19 at 05:24
Possible duplicate of [JavaScript property access: dot notation vs. brackets?](https://stackoverflow.com/questions/4968406/javascript-property-access-dot-notation-vs-brackets) — Phil, Oct 23 '19 at 05:25
how about wrapping your `reduce` in another function which has a param of this dynamic property? — tanmay, Oct 23 '19 at 05:26

score 2 · Accepted Answer · edited Oct 23 '19 at 05:40

Create a function that takes argument keyName and use it as row[keyName]

var rows = [{"empId":1,"empName":"aaa","skillSet":"JAVA","location":"chennai"},{"empId":2,"empName":"bbb","skillSet":"Angular","location":"chennai"},{"empId":3,"empName":"ccc","skillSet":"Angular","location":"chennai"},{"empId":4,"empName":"ddd","skillSet":"JAVA","location":"bangalore"},{"empId":5,"empName":"eee","skillSet":"JAVA","location":"chennai"},{"empId":6,"empName":"fff","skillSet":"JAVA","location":"bangalore"},{"empId":7,"empName":"ggg","skillSet":"oracle","location":"chennai"},{"empId":8,"empName":"hhh","skillSet":"JAVA","location":"hyderabad"},{"empId":9,"empName":"iii","skillSet":"JAVA","location":"hyderabad"}]

  function groupBy(keyName) {
      console.log("Group By :: ", keyName)
  
      var occurences = rows.reduce(function (r, row) {
          r[row[keyName]] = ++r[row[keyName]] || 1;
          return r;
      }, {});

      var result = Object.keys(occurences).map(function (key)       {
          return { key: key, value: occurences[key] };
      });

      console.log(result);
  }     
  
  groupBy("location");
  groupBy("skillSet");

I edited your post so you could more easily see the important part of your answer. I hope that's ok — Phil, Oct 23 '19 at 05:41
Thanks @Phil for making data one-liner. I was also going to do that by the way :) — Bilal Siddiqui, Oct 23 '19 at 05:42

Abito Prakash · Answer 2 · 2019-10-23T05:37:28.757

0

You can do something like this

function groupEmployees(employees, grpKey) {
    const group = {};
    employees.forEach(emp => group[emp[grpKey]] = group[emp[grpKey]] ? group[emp[grpKey]] + 1 : 1);
    return group;
}
console.log(groupEmployees(rows, 'location')); // prints {chennai: 5, bangalore: 2, hyderabad: 2}
console.log(groupEmployees(rows, 'skillSet')); // prints {JAVA: 6, Angular: 2, oracle: 1}

edited Oct 23 '19 at 05:37

answered Oct 23 '19 at 05:31

Abito Prakash

4,368
2
13
26

How to dynamically select the property by which my JSON object has to grouped by in Javascript

2 Answers2