How to merge duplicates in an array of objects and sum a specific property?

Question

I have this array of objects:

var arr = [
    {
        name: 'John',
        contributions: 2
    },
    {
        name: 'Mary',
        contributions: 4
    },
    {
        name: 'John',
        contributions: 1
    },
    {
        name: 'Mary',
        contributions: 1
    }
];

... and I want to merge duplicates but sum their contributions. The result would be like the following:

var arr = [
    {
        name: 'John',
        contributions: 3
    },
    {
        name: 'Mary',
        contributions: 5
    }
];

How could I achieve that with JavaScript?

In my case, `cosnt res = new Set(array1, array2)` works perfect. — U.A, Sep 22 '19 at 11:59

score 29 · Accepted Answer · answered Jul 10 '16 at 17:52

29

You could use a hash table and generate a new array with the sums, you need.

var arr = [{ name: 'John', contributions: 2 }, { name: 'Mary', contributions: 4 }, { name: 'John', contributions: 1 }, { name: 'Mary', contributions: 1 }],
    result = [];

arr.forEach(function (a) {
    if (!this[a.name]) {
        this[a.name] = { name: a.name, contributions: 0 };
        result.push(this[a.name]);
    }
    this[a.name].contributions += a.contributions;
}, Object.create(null));

console.log(result);

answered Jul 10 '16 at 17:52

Nina Scholz

376,160
25
347
392

2

You can use the brand new ES6 Map object : `var result = new Map(); arr.forEach((element) => { if (result.get(element.name)) result.set(element.name, result.get(element.name) + element.contributions); else result.set(element.name, element.contributions); }); console.log(result);` – kevin ternet Jul 10 '16 at 18:32
10

Reduce: https://jsfiddle.net/mplungjan/Lr84keqy/ – mplungjan Jan 02 '19 at 13:06
2

@mplungjan I liked your approach – Saumay Paul Nov 20 '19 at 09:37
@mplungjan it worked thanks – Miyas Mohammed Nov 04 '20 at 07:20

score -1 · Answer 2 · answered Jul 10 '16 at 18:11

You could also do this using linq framework which is provided by linq.js

here is my code using linq.js and this is nearly look like sql statement.

var arr = [
    {
        name: 'John',
        contributions: 2
    },
    {
        name: 'Mary',
        contributions: 4
    },
    {
        name: 'John',
        contributions: 1
    },
    {
        name: 'Mary',
        contributions: 1
    }
];


var aggregatedObject = Enumerable.From(arr)
        .GroupBy("$.name", null,
                 function (key, g) {
                     return {
                       name: key,
                       contributions: g.Sum("$.contributions")
                     }
        })
        .ToArray();

console.log(aggregatedObject);

<script src="http://cdnjs.cloudflare.com/ajax/libs/linq.js/2.2.0.2/linq.min.js"></script>

How to merge duplicates in an array of objects and sum a specific property?

2 Answers2

Linked

Related