Calculate the sum of values within an array of objects [duplicate]

Question

I am trying to find the total sum for each item sold inside an array, like so:

The array looks like this:

 [ 
  {
    'Some Title Item', '22', 'Apple'
  },
  {
    'Another Item', '12', 'Android'
  },
  {
    'Third Item', '15', 'Android'
  }, 
  {
    'Another Item', '6', 'Apple'
  },...
]

I already have a variable were I store all the titles/labels, and now need to find the sum of total items sold for each of those.

The example doesn't make much sense. Ignoring the invalid syntax... Where do the numbers in the "desired output" come from? And where did 'Apple' and 'Android' go? — Andreas
– Andreas, Commented Jul 27, 2021 at 10:24
If you want to group based on a column: Sum of same nested array data using jquery and Iterate over multi-dimensional array and return aggregated sum based on first index and Summing a 2D array by “group” — adiga
– adiga, Commented Jul 27, 2021 at 10:28
Thank you all for the time and suggestions! the below answer actually worked! — Jacopo
– Jacopo, Commented Jul 27, 2021 at 10:51

Nitheesh · Accepted Answer · 2021-07-27 10:32:49Z

1

Your input and output must be arrays.

Use array.reduce for achieve your desired result.

const data = [
  [
    'Some Title Item', '22', 'Apple'
  ],
  [
    'Another Item', '12', 'Android'
  ],
  [
    'Third Item', '15', 'Android'
  ],
  [
    'Another Item', '6', 'Apple'
  ]
];
let output = [];
output = data.reduce((acc, curr) => {
  const node = acc.find((node) => node[0] === curr[0]);
  if (node) {
    node[1] += Number(curr[1]);
  } else {
    acc.push([curr[0], Number(curr[1])]);
  }
  return acc;
}, []);
console.log(output);

answered Jul 27, 2021 at 10:32

Nitheesh

20.1k3 gold badges28 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Calculate the sum of values within an array of objects [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related