data attribute grouped by value calculate sum of other data attribute

Question

I am trying to calculate all the huishoudens that are in each provincie. For this question I created a fiddle which can be found here: http://jsfiddle.net/Lyf1sak3/1/

With this sample data:

And this code:

var provincies = {},
    provincie;
    sum = 0;
$('*[data-provincie]').each(function(i, el){
    provincie = $(el).data('provincie');
    
    if (provincies.hasOwnProperty(provincie)) {

        provincies[provincie] += 1;
        sum += $(this).data('huishoudens');

    }
    else {
        provincies[provincie] = 1;
    }
});

// print results
$('#result').append('');
for(var key in provincies){
    $('#result').append(key + ' (' + provincies[key] + '|' + sum + ')
');
}

I am grouping each provincie by its own property and now I just need to calculate the other data attribute, but I am completely stuck here. I am getting either the result 675 which is the last div in the sample data or I get 2462 and I have no clue how it gets that number.

What do I need to modify to get this result:

Noord-Holland (2|1352)
Zuid-Holland (2|1191)
Groningen (3|797)
Utrecht (2|798)

Whatever answer you give it is really appreciated but please don't post answers where it requires to hard code the names of provincie like $('*[data-provincie="Noord-Holland"]');

user_10606400 · Answer

If you know provincie before only you can create an array with all provincie and then you can use this as a key to compare it with all the div if matches you can add same to sum variable and finally append final result to your result div.

Demo Code :

//all data provinces
//var json_ = ["Noord-Holland", "Zuid-Holland", "Groningen", "Utrecht"]
var json_ = [];
$('*[data-provincie]').each(function(i, el) {
//check if in array or not
  if ($.inArray($(this).data('provincie'), json_) < 0) {
    json_.push($(this).data('provincie'));//push same
  }

});
console.log(json_)
sum = 0;
count = 0;
//loop through keys
for (var key in json_) {
  $('*[data-provincie]').each(function(i, el) {
    var provincie = $(el).data('provincie');
    //if key matches
    if (json_[key] == provincie) {
      sum += $(el).data('huishoudens');
      count++;
    }
  });
  //append result
  $('#result').append(count + ' (' + json_[key] + '|' + sum + ')
')
  count = 0;
  sum = 0 //change sum to 0 again
}

user_7785337 · Answer

You could modify the function like,

Get the count attributes like,

var count = parseInt($(this).data('huishoudens'));

Then inside the condition assign it like,

if (provincies.hasOwnProperty(provincie)) {
  provincies[provincie]["sum"] += count;
}
else {
  provincies[provincie] = {"sum": count};
}

Working Snippet:

var provincies = {},
    provincie;
    sum = 0;
$('*[data-provincie]').each(function(i, el){
    provincie = $(el).data('provincie');
    var count = parseInt($(this).data('huishoudens'));
    if (provincies.hasOwnProperty(provincie)) {
        provincies[provincie]["sum"] += count;
        provincies[provincie]["provinceCount"] += 1;
    }
    else {
       provincies[provincie] = {"sum": count, "provinceCount": 1};
    }
});

// print results
$('#result').append('');
for(var key in provincies){
    $('#result').append(key + ' (' + provincies[key].provinceCount + '|' +  provincies[key].sum + ')
');
}






  Course example

data attribute grouped by value calculate sum of other data attribute

2 Answers