How to sum nested array

Question

I have an array like this

var dataSheet = [
    [{price: 200}, {price: 200}, {price: 200}],
    [{price: 200}, {price: 200}],
    [{price: 200}],
]

I would like to sum all the price and a result like this

result = [[600], [400], [200]]

Any help would be appreciated, thanks

Yes, but I was talkinng about the expected result, not about the dataSheet. — Roko C. Buljan
– Roko C. Buljan, Commented Jul 7, 2020 at 11:44

Artem Arkhipov · Accepted Answer · 2020-07-07 11:15:35Z

Principle is the same for both nested and flat arrays: just use reduce to get sum of values in array. In your case you just need to apply this mechanism to each nested array in your dataSheet and receive new array of values. Method map is designed exactly creating new array based on values from the source array.

So the correct answer would be to use combination of map and reduce.

var dataSheet = [
    [{price: 200}, {price: 200}, {price: 200}],
    [{price: 200}, {price: 200}],
    [{price: 200}],
]

var result = dataSheet.map(data => data.reduce((acc, obj) => acc += obj.price,0));
console.log(result); // [600, 400, 200]

If you really need to have result like [[600],[400],[200]] (embedded arrays instead of just values, you just need to wrap returned values in [], like this:

var dataSheet = [
    [{price: 200}, {price: 200}, {price: 200}],
    [{price: 200}, {price: 200}],
    [{price: 200}],
]

var result = dataSheet.map(data => [data.reduce((acc, obj) => acc += obj.price,0)]);
console.log(result); // [[600], [400], [200]]

Yousaf · Accepted Answer · 2020-07-07 11:03:13Z

1

You could use .map() along with .forEach() function.

var dataSheet = [
    [{price: 200}, {price: 200}, {price: 200}],
    [{price: 200}, {price: 200}],
    [{price: 200}],
]

const res = dataSheet.map(arr => {
  let sum = 0;
  arr.forEach(obj => sum += obj.price);
  return [sum];
});

console.log(res);

answered Jul 7, 2020 at 11:03

Yousaf

29.5k6 gold badges54 silver badges78 bronze badges

Comments

ikos23 · Accepted Answer · 2020-07-07 11:05:07Z

0

I guess map + reduce is what you are looking for :)

const res = dataSheet.map(el => el.reduce((acc, curr) => acc + curr.price, 0));

Or flatMap if you need result as [600, 400, 200]:

const res = dataSheet.flatMap(el => el.reduce((acc, curr) => acc + curr.price, 0));

answered Jul 7, 2020 at 11:05

ikos23

5,48212 gold badges46 silver badges65 bronze badges

Comments

Siva Kondapi Venkata · Accepted Answer · 2020-07-07 11:15:24Z

0

Use map, reduce and destructuring.

var dataSheet = [
  [{ price: 200 }, { price: 200 }, { price: 200 }],
  [{ price: 200 }, { price: 200 }],
  [{ price: 200 }],
];

const result = dataSheet.map((arr) =>
  Object.values(
    arr.reduce(({ price: acc }, { price }) => ({ price: acc + price }))
  )
);

console.log(result)

answered Jul 7, 2020 at 11:15

Siva Kondapi Venkata

11.1k2 gold badges20 silver badges32 bronze badges

Comments

triihim · Accepted Answer · 2020-07-07 11:15:39Z

0

var dataSheet = [
    [{price: 200}, {price: 200}, {price: 200}],
    [{price: 200}, {price: 200}],
    [{price: 200}],
];

var res = dataSheet.reduce((result, row) => 
  result.concat([[row.reduce((sum, element) => 
    sum + element.price, 0)]]), []);

console.log(res);

answered Jul 7, 2020 at 11:15

triihim

624 bronze badges

Collectives™ on Stack Overflow

How to sum nested array

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related