Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Count particular key value from array of object

I have following JSON array I want to create object form status key count

[
  {
    "id": "65:0",    
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  },
  {
    "id": "65:0",
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "status": "YELLOW"
  },
  {
    "id": "65:0",
    "status": "RED"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  },
   {
    "id": "65:0",
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "status": "YELLOW"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  }
] 

Want to count status key value and create the following Object

{
 'ORANGE' : 3,
 'GREEN' : 4,
 'YELLOW' : 2,
 'RED' : 1,
}
like image 272
Mehul Mali Avatar asked Aug 01 '16 09:08

Mehul Mali


2 Answers

Use Array#reduce method

var res = data.reduce(function(obj, v) {
  // increment or set the property
  // `(obj[v.status] || 0)` returns the property value if defined
  // or 0 ( since `undefined` is a falsy value
  obj[v.status] = (obj[v.status] || 0) + 1;
  // return the updated object
  return obj;
  // set the initial value as an object
}, {})

var data = [{
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "YELLOW"
}, {
  "id": "65:0",
  "status": "RED"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "YELLOW"
}, {
  "id": "65:0",
  "status": "GREEN"
}];

var res = data.reduce(function(obj, v) {
  obj[v.status] = (obj[v.status] || 0) + 1;
  return obj;
}, {})

console.log(res);

Although you can use Array#forEach method with the same code.

var res = {};
data.forEach(function(v) {
  res[v.status] = (res[v.status] || 0) + 1;
})

var data = [{
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "YELLOW"
}, {
  "id": "65:0",
  "status": "RED"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "GREEN"
}, {
  "id": "65:0",
  "status": "ORANGE"
}, {
  "id": "65:0",
  "status": "YELLOW"
}, {
  "id": "65:0",
  "status": "GREEN"
}];

var res = {};
data.forEach(function(v) {
  res[v.status] = (res[v.status] || 0) + 1;
})

console.log(res);
like image 152
Pranav C Balan Avatar answered Oct 25 '22 09:10

Pranav C Balan


var obj = [
  {
    "id": "65:0",    
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "name": "BIU",
    "status": "GREEN"
  },
  {
    "id": "65:0",
    "name": "BIU",
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "status": "YELLOW"
  },
  {
    "id": "65:0",
    "status": "RED"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  },
   {
    "id": "65:0",
    "status": "ORANGE"
  },
  {
    "id": "65:0",
    "status": "YELLOW"
  },
  {
    "id": "65:0",
    "status": "GREEN"
  }
] ;

var rez={};
obj.forEach(function(item){
  rez[item.status] ? rez[item.status]++ :  rez[item.status] = 1;
});
console.log(rez);
like image 22
Vladu Ionut Avatar answered Oct 25 '22 10:10

Vladu Ionut