Count the number of elements with specific properties inside JSON

Question

I have some JSON data:

{"humans": [
    { "firstName" : "Paul", "lastName" : "Taylor", "hairs": 2 },
    { "firstName" : "Sharon", "lastName" : "Mohan", "hairs": 3 },
    { "firstName" : "Mohan", "lastName" : "Harris", "hairs": 3 },
    { "firstName" : "Deborah", "lastName" : "Goldman", "hairs": 4 },
    { "firstName" : "Mark", "lastName" : "Young", "hairs": 4 },
    { "firstName" : "Tom", "lastName" : "Perez", "hairs": 4 }
    //and so on...
]}

I want to be able to count all people with two hairs, three hairs, etc. Right now I am using a jQuery.each()plus incrementing counting array that works great. But I was wondering if there is an easier way to do this.

UPDATE: Extra code saying what I'm doing right now:

var results = eval(data.humans);
var count_array = [0, 0, 0, 0, 0, 0, 0];
$(results).each(function() {
    if (this.hairs == 1) {
        count_array[0]++;
    }
    if (this.hairs == 2) {
        count_array[1]++
    }
    if (this.hairs == 3) {
        count_array[2]++
    }
    if (this.hairs == 4) {
        count_array[3]++
    }
    if (this.hairs == 5) {
        count_array[4]++
    }
    if (this.hairs == 6) {
        count_array[5]++
    }
    if (this.hairs == 7) {
        count_array[6]++
    }
});

Answer 1

You can use the filterfunction to filter an array of objects:

var data = {...}

data.humans.filter(function(o) { return o.hairs == 2 }).length
//Return the number of humans who have 2 hairs

Look fiddle

Answer 2

My solution may be what you want

var data = {
                "humans": [
                    { "firstName" : "Paul", "lastName" : "Taylor", "hairs": 2 },
                    { "firstName" : "Sharon", "lastName" : "Mohan", "hairs": 3 },
                    { "firstName" : "Mohan", "lastName" : "Harris", "hairs": 3 },
                    { "firstName" : "Deborah", "lastName" : "Goldman", "hairs": 4 },
                    { "firstName" : "Mark", "lastName" : "Young", "hairs": 4 },
                    { "firstName" : "Tom", "lastName" : "Perez", "hairs": 4 },
                    { "firstName" : "Joseph", "lastName" : "Goldman", "hairs": 5 },
                    { "firstName" : "Mary", "lastName" : "White", "hairs": 5 },
                    { "firstName" : "Matthew", "lastName" : "Garcia", "hairs": 5 },
                    { "firstName" : "Patricia", "lastName" : "Allen", "hairs": 5 },
                    { "firstName" : "Larry", "lastName" : "Robinson", "hairs": 6 },
                    { "firstName" : "Manb", "lastName" : "Lopez", "hairs": 6 },
                    { "firstName" : "Jose", "lastName" : "Martinez", "hairs": 6 },
                    { "firstName" : "Deborah", "lastName" : "Walker", "hairs": 6 },
                    { "firstName" : "Joseph", "lastName" : "Lopez", "hairs": 6 },
                    { "firstName" : "Tinman", "lastName" : "Moore", "hairs": 7 },
                    { "firstName" : "Jose", "lastName" : "Jackson", "hairs": 7 },
                    { "firstName" : "Karen", "lastName" : "Goldman", "hairs": 7 },
                    { "firstName" : "Paul", "lastName" : "Taylor", "hairs": 7 },
                    { "firstName" : "Amy", "lastName" : "Gonzalez", "hairs": 7 },
                    { "firstName" : "Richard", "lastName" : "Martinez", "hairs": 7 }
                ]
            };
var counterList = [];
$.each(data.humans,function(i,item){
    counterList.push(item.hairs);
});

$.extend({
    distinct : function(anArray) {
       var result = [];
       $.each(anArray, function(i,v){
           if ($.inArray(v, result) == -1) result.push(v);
       });
       return result;
    }
});

var uniqueCounterList= $.distinct(counterList);
var html = "";
$.each(uniqueCounterList,function(j,itemUnique){
    html += "<div>Hair "+itemUnique+": "+(data.humans.filter(function(o) { return o.hairs == itemUnique }).length)+"</div>";
});
$("#count").html(html);

Or http://jsfiddle.net/8g5ggfeh/

Answer 3

javascript for :

var counter = 0;

for (var i = 0; i < data.humans.length; i++) {
   if (data.humans[i].hairs === 2) {
      counter++;
   }
}

Answer 4

:

var data = {
            "humans": [
                { "firstName" : "Paul", "lastName" : "Taylor", "hairs": 2 },
                { "firstName" : "Sharon", "lastName" : "Mohan", "hairs": 3 },
                { "firstName" : "Mohan", "lastName" : "Harris", "hairs": 3 },
                { "firstName" : "Deborah", "lastName" : "Goldman", "hairs": 4 },
                { "firstName" : "Mark", "lastName" : "Young", "hairs": 4 },
                { "firstName" : "Tom", "lastName" : "Perez", "hairs": 4 },
                { "firstName" : "Joseph", "lastName" : "Goldman", "hairs": 5 },
                { "firstName" : "Mary", "lastName" : "White", "hairs": 5 },
                { "firstName" : "Matthew", "lastName" : "Garcia", "hairs": 5 },
                { "firstName" : "Patricia", "lastName" : "Allen", "hairs": 5 },
                { "firstName" : "Larry", "lastName" : "Robinson", "hairs": 6 },
                { "firstName" : "Manb", "lastName" : "Lopez", "hairs": 6 },
                { "firstName" : "Jose", "lastName" : "Martinez", "hairs": 6 },
                { "firstName" : "Deborah", "lastName" : "Walker", "hairs": 6 },
                { "firstName" : "Joseph", "lastName" : "Lopez", "hairs": 6 },
                { "firstName" : "Tinman", "lastName" : "Moore", "hairs": 7 },
                { "firstName" : "Jose", "lastName" : "Jackson", "hairs": 7 },
                { "firstName" : "Karen", "lastName" : "Goldman", "hairs": 7 },
                { "firstName" : "Paul", "lastName" : "Taylor", "hairs": 7 },
                { "firstName" : "Amy", "lastName" : "Gonzalez", "hairs": 7 },
                { "firstName" : "Richard", "lastName" : "Martinez", "hairs": 7 }
            ]
        };

function groupByHair(array, groupOf) {
 var groups = {};
  array.forEach(function(element) {
  var groupName = groupOf(element);
   if (groupName in groups)
     groups[groupName].push(element);
   else
     groups[groupName] = [element];
  });
  return groups;
}

var byHairs = groupByHair(data.humans , function(h) {
  return h.hairs;
 });

for (var hairs in byHairs) {
 var hairsN = byHairs[hairs].length;
 console.log('in '+ hairs +'hairs-group you have: ' +hairsN+' people');
}

fiddle

Answer 5

You can try? He will group your data, and you will receive an invoice for it.

var groupedData = _.groupBy(YourJsonName, function(d){return d.hairs});