Reduce array based on common values on object level

Question

I have an array such as

let array = [
    {
        id: 1,
        name: "Name A",
        expenseAmount: 100
    },
    {
        id: 1,
        name: "Name A",
        expenseAmount: 50
    },
    {
        id: 3,
        name: "Name B",
        expenseAmount: 10
    },
    {
        id: 3,
        name: "Name B",
        expenseAmount: 20
    }
];

And I am looking for a solution, which condenses that array in such a manner, that all objects with the same id and name get summed by their expenseAmount, so that it results in:

let array_goal = [
    {
        id: 1,
        name: "Name A",
        expenseAmount: 150
    },
    {
        id: 3,
        name: "Name B",
        expenseAmount: 30
    }
];

Could you please help? Thanks!

Does this answer your question? merge object & sum a single property javascript — aerial
– aerial, Commented Jan 31, 2022 at 7:08

Samathingamajig · Accepted Answer · 2022-01-31 07:04:23Z

3

Array.prototype.reduce is your friend for tasks like these.

Find a preexisting object with the same id and add to the expense amount, if you can't find it, make it yourself and add it to the output array.

let array = [{
    id: 1,
    name: "Name A",
    expenseAmount: 100
  },
  {
    id: 1,
    name: "Name A",
    expenseAmount: 50
  },
  {
    id: 3,
    name: "Name B",
    expenseAmount: 10
  },
  {
    id: 3,
    name: "Name B",
    expenseAmount: 20
  }
];

const condenseArray = (arr) => {
  return arr.reduce((out, {id, name, expenseAmount}) => {
    let data = out.find(({id: _id}) => _id === id);
    if (!data) {
      const newData = {id, name, expenseAmount: 0};
      out = [...out, newData];
      data = newData;
    }
    data.expenseAmount += expenseAmount;
    return out;
  }, []);
};

console.log(condenseArray(array));

answered Jan 31, 2022 at 7:04

Samathingamajig

13.5k3 gold badges19 silver badges46 bronze badges

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

Comments

jsN00b · Accepted Answer · 2022-01-31 08:36:23Z

This is one possible solution:

const mergeIdSumExpenses = (arr = array) => (
  Object.values(arr.reduce(
    (fin, itm) => ({
        ...fin,
      [itm.id]: {
        ...itm,
        expenseAmount: (fin[itm.id]?.expenseAmount || 0) + itm.expenseAmount
      }
    }), {}
  ))
);

Explanation

Use .reduce to iterate through the array & generate result as an object
If current element itm's id already exists in the aggregator fin,
then, add itm.expenseAmount to existing prop (key: itm.id)
else, create a new prop (key: itm.id)
Finally, use Object.values() to extract only the values from resultant object

Code Snippet

let array = [{
    id: 1,
    name: "Name A",
    expenseAmount: 100
  },
  {
    id: 1,
    name: "Name A",
    expenseAmount: 50
  },
  {
    id: 3,
    name: "Name B",
    expenseAmount: 10
  },
  {
    id: 3,
    name: "Name B",
    expenseAmount: 20
  }
];

const mergeIdSumExpenses = (arr = array) => (
    Object.values(arr.reduce(
    (fin, itm) => ({
        ...fin,
      [itm.id]: {
        ...itm,
        expenseAmount: (fin[itm.id]?.expenseAmount || 0) + itm.expenseAmount
      }
    }), {}
  ))
);

console.log(mergeIdSumExpenses());

Ian · Accepted Answer · 2022-01-31 09:00:03Z

0

First step

Use filter to group by id and name

Second step

Use map, filter, reduce to calculate expenseAmount

const array = [
  {id:1,name:"Name A",expenseAmount:100},
  {id:1,name:"Name A",expenseAmount:50},
  {id:1,name:"Name B",expenseAmount:100},
  {id:3,name:"Name B",expenseAmount:10},
  {id:3,name:"Name B",expenseAmount:20}
];

const unique = array
  .filter((element, index, arr) => index === arr.findIndex(e => e.id == element.id && e.name == element.name))
  .map(u => {
    u.expenseAmount = 
      array
        .filter(a => a.id == u.id && a.name == u.name)
        .reduce((n, {expenseAmount}) => n + expenseAmount, 0);
    return u;
  });

console.log(unique);

edited Jan 31, 2022 at 9:00

answered Jan 31, 2022 at 8:46

Ian

1,1921 gold badge7 silver badges16 bronze badges

Comments

Niveth Saran · Accepted Answer · 2022-01-31 07:46:47Z

-1

If you don't have a problem using a library for this purpose, you can use lodash

// const _ = require('lodash') // use in source code if not using CDN

let array = [
    {
        id: 1,
        name: "Name A",
        expenseAmount: 100
    },
    {
        id: 1,
        name: "Name A",
        expenseAmount: 50
    },
    {
        id: 3,
        name: "Name B",
        expenseAmount: 10
    },
    {
        id: 3,
        name: "Name B",
        expenseAmount: 20
    }
];

const ans = _(array)
    .groupBy('name')
    .map((data, value) => ({
        id: data[0].id,
        name: data[0].name,
        expenseAmount: _.sumBy(data, 'expenseAmount')
    }))
    .value()

console.log(ans);

<script src="https://cdn.jsdelivr.net/npm/[email protected]/lodash.min.js" integrity="sha256-qXBd/EfAdjOA2FGrGAG+b3YBn2tn5A6bhz+LSgYD96k=" crossorigin="anonymous"></script>

edited Jan 31, 2022 at 7:46

answered Jan 31, 2022 at 7:11

Niveth Saran

1802 silver badges6 bronze badges

1 Comment

Samathingamajig Over a year ago

If you run your code, you can see that it outputs the sum of all expenseAmounts, not on a per-id basis. Can be fixed by _.sumBy(data, 'expenseAmount')

Collectives™ on Stack Overflow

Reduce array based on common values on object level

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related