Sum value form array in object

Question

I've an object:

var stuffData = {
    'Fruit': [{
        'Name': 'Apple',
        'Price': '2'
    }, {
        'Name': 'Kiwi',
        'Price': '4'
    }],
    'Sport': [{
        'Name': 'Ball',
        'Price': '10'
    }, {
        'Name': 'Bike',
        'Price': '120'
    }],
    'Kitchen': [{
        'Name': 'Knife',
        'Price': '8'
    }, {
        'Name': 'Fork',
        'Price': '7'
    }]
}

Now i want to get sum from Price Column.

I thought about this

for (var key in stuffData)
   {
     // and for each key i have to add new array with sum of price or what?
     // But how will I display this sum then?
     // I haven't any idea how can I deal with this        
   }

You want the sum of all the Price values, regardless of category ? — adeneo
– adeneo, Commented Apr 25, 2016 at 17:36
Maybe you should post the result you want then, to show us the format etc. — adeneo
– adeneo, Commented Apr 25, 2016 at 17:40

adeneo · Accepted Answer · 2016-04-25 17:44:51Z

2

Something like this should work, mapping the objects, and reducing to sum each one

var stuffData = {
    'Fruit': [{
        'Name': 'Apple',
        'Price': '2'
    }, {
        'Name': 'Kiwi',
        'Price': '4'
    }],
    'Sport': [{
        'Name': 'Ball',
        'Price': '10'
    }, {
        'Name': 'Bike',
        'Price': '120'
    }],
    'Kitchen': [{
        'Name': 'Knife',
        'Price': '8'
    }, {
        'Name': 'Fork',
        'Price': '7'
    }]
}

var o = {};

Object.keys(stuffData).forEach(function(key) {
    o[key] = stuffData[key].map(function(item) {
    	return parseInt(item.Price, 10);
    }).reduce(function(a,b) {
    	return a + b;
    });
});

document.body.innerHTML = '<pre>' + JSON.stringify(o, 0, 4) + '</pre>';

The result would be

{
    Fruit: 6, 
    Sport: 130, 
    Kitchen: 15
}

answered Apr 25, 2016 at 17:44

adeneo

319k29 gold badges410 silver badges392 bronze badges

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

Comments

Wasiq Muhammad · Accepted Answer · 2016-04-25 17:50:38Z

0

Try like this

for (var key in stuffData) {
var totalSum =0;
    if(stuffData[key] = 'Fruit'{
        for(var i=0; i< stuffData[key].length ; i++){
            totalSum+=stuffData[key].price;
        }
    }

    if(stuffData[key] = 'Sport'{
        for(var i=0; i< stuffData[key].length ; i++){
            totalSum+=stuffData[key].price;
        }
    }

    if(stuffData[key] = 'Kitchen'{
        for(var i=0; i< stuffData[key].length ; i++){
            totalSum+=stuffData[key].price;
        }

    }
    console.log("TOTAL SUM",totalSum);
}

answered Apr 25, 2016 at 17:50

Wasiq Muhammad

3,1483 gold badges19 silver badges30 bronze badges

Comments

Retsam · Accepted Answer · 2016-04-25 17:50:49Z

0

You can use Array.prototype.reduce to sum over a list.

var categorySums = {};
for(category in stuffData) {
    var items = stuffData[category]; 
    categorySums[category] = items.reduce(function (sum, item) { 
         return sum + parseInt(item.Price);
    }, 0);
}

If you use the library lodash (or something similar, e.g. underscore or Ramda), they've got a mapValues utility that makes this simpler:

var categorySums = _.mapValues(stuffData, function(items) {
    return _.sum(items.map(function (item) {
        return parseInt(item.Price);
    }));
});

answered Apr 25, 2016 at 17:50

Retsam

33.8k11 gold badges73 silver badges94 bronze badges

Comments

DiPix · Accepted Answer · 2016-04-26 06:33:14Z

0

Thank you for every answer. The best solution is below:

   var sum = {};
    for (var k in stuffData)
    {
       sum[k] = 0;
       stuffData[k].forEach(function (e)
       {
          sum[k] += parseInt(e.price);
       });
    }

answered Apr 26, 2016 at 6:33

DiPix

6,08318 gold badges76 silver badges123 bronze badges

Collectives™ on Stack Overflow

Sum value form array in object

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related