How to sum values in an array of objects in javascript

Question

I have an array of objects, like so:

[
    {
        Daypart: "G_POSTPEAK",
        day_of_week: "Monday",
        uplift: 1
    },
    {
        Daypart: "A_BREAKFAST",
        day_of_week: "Thursday",
        uplift: 1
    },
    {
        Daypart: "C_DAYTIME",
        day_of_week: "Sunday",
        uplift: 2
    },
    {
        Daypart: "G_POSTPEAK",
        day_of_week: "Monday",
        uplift: 2
    },
]

I have only shown a sample of objects in the array, I am working with a lot more. They all have the specified properties, the daypart property could be one of 8 values and the day of week value could be one of 7 (days of the week).

I want to return the sum of the uplift value for all the objects that have the same daypart and day_of_week value.

So the above should return something like:

{
    G_POSTPEAK_Monday: {
        Daypart: "G_POSTPEAK",
        day_of_week: "Monday",
        uplift: 3
    },
    A_BREAKFAST_Thursday: {
        Daypart: "A_BREAKFAST",
        day_of_week: "Thursday",
        uplift: 1
    },

    C_DAYTIME_Sunday: {
        Daypart: "C_DAYTIME",
        day_of_week: "Sunday",
        uplift: 2
    }
}

Appreciate any help

Looking at your profile, I'm wondering why you can't even seem to get started with this fairly simple problem. — ziggy wiggy
– ziggy wiggy, Commented Jun 18, 2019 at 11:29

Adarsh · Accepted Answer · 2019-06-18 11:34:31Z

1

The following function can be used. I have used ES6. The function takes inputs which will be your input object.

const sumIt = (inputs) => {
  const result = {};
  inputs.forEach((input) => {
    const key = `${input.Daypart}_${input.day_of_week}`;
    if (key in result) {
      result[key].uplift = result[key].uplift + input.uplift;
    } else {
      result[key] = { ...input };
    }
  });
  return result;
};

answered Jun 18, 2019 at 11:34

Adarsh

8279 silver badges23 bronze badges

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

Comments

Scott Sauyet · Accepted Answer · 2019-06-18 11:44:05Z

0

You can use ES6 reduce function to perform the sum in one line instead of using foreach.

let array = [
    {
        Daypart: "G_POSTPEAK",
        day_of_week: "Monday",
        uplift: 1
    },
    {
        Daypart: "A_BREAKFAST",
        day_of_week: "Thursday",
        uplift: 1
    },
    {
        Daypart: "C_DAYTIME",
        day_of_week: "Sunday",
        uplift: 2
    },
    {
        Daypart: "G_POSTPEAK",
        day_of_week: "Monday",
        uplift: 2
    },
];

const totalUplift = array.reduce((acc, array) => acc + array.uplift, 0);

console.log(totalUplift);

edited Jun 18, 2019 at 11:44

Scott Sauyet

50.9k5 gold badges57 silver badges111 bronze badges

answered Jun 18, 2019 at 11:38

Abu Bakar

651 silver badge8 bronze badges

4 Comments

Abu Bakar Over a year ago

Reduce can return a callback and initial value which I represent with acc. It will take array and calculate any field inside Javascript object.

Scott Sauyet Over a year ago

Note that your numeric result has nothing to do with the requested structure. A reduce is called for, I think, but it needs to be more sophisticated than this.

Abu Bakar Over a year ago

you can first use array.map to group similar elements and then perform reduce in next phase!

Abu Bakar Over a year ago

r[array.day_of_week] = r[array.day_of_week] || []; r[array.day_of_week].push(array); return r; you can also compare the object and used this for grouping inside the reduce!

Hassan Imam · Accepted Answer · 2019-06-18 11:53:45Z

0

You can use array#reduce to group data based on the Daypart and day_of_week in an object accumulator.

let data = [ { Daypart: "G_POSTPEAK", day_of_week: "Monday", uplift: 1 }, { Daypart: "A_BREAKFAST", day_of_week: "Thursday", uplift: 1 }, { Daypart: "C_DAYTIME", day_of_week: "Sunday", uplift: 2 }, { Daypart: "G_POSTPEAK", day_of_week: "Monday", uplift: 2 }],
    result = data.reduce((r,o) => {
      let key = `${o.Daypart}_${o.day_of_week}`;
      r[key] = r[key] || {...o, uplift: 0};
      r[key].uplift += o.uplift;
      return r;
    },{});
console.log(result);

.as-console-wrapper {max-height: 100% !important; top: 0;}

answered Jun 18, 2019 at 11:53

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

Comments

Scott Sauyet · Accepted Answer · 2019-06-18 12:06:01Z

0

A somewhat more functional version, using reduce like several other solutions.

const combine = inputs => Object .values (
  inputs .reduce ((a, {Daypart, day_of_week, uplift}) => {
    const key = `${Daypart}|${day_of_week}`
    return {...a, [key]: ({
      Daypart, 
      day_of_week, 
      uplift: (a[key] && a[key].uplift || 0) + uplift
    })}
  }, {})
)

let inputs = [
  {Daypart: "G_POSTPEAK", day_of_week: "Monday", uplift: 1},
  {Daypart: "A_BREAKFAST", day_of_week: "Thursday", uplift: 1},
  {Daypart: "C_DAYTIME", day_of_week: "Sunday", uplift: 2},
  {Daypart: "G_POSTPEAK", day_of_week: "Monday", uplift: 2},
]

console .log (
  combine (inputs)
)

answered Jun 18, 2019 at 12:06

Scott Sauyet

50.9k5 gold badges57 silver badges111 bronze badges

Comments

Abu Bakar · Accepted Answer · 2019-06-18 12:52:23Z

0

You can use loadash package to perform this in optimized way...

let _ = require('lodash');
let arrays = [
  {
    'name':'monday',
    vaue:1
  },
 {
    'name':'monday',
    vaue:2
 },
 {
    'name':'tuesday',
    vaue:3
 },
 {
   'name':'wednesday',
   vaue:11
 },
 {
   'name':'wednesday',
   vaue:11
 },
]

let newarray = _(arrays).groupBy("name").map(   (name) => ({
   name: name,
   value0: _.sumBy(name, 'vaue')
 }))
 .value()
console.log(newarray);

answered Jun 18, 2019 at 12:52

Abu Bakar

651 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to sum values in an array of objects in javascript

5 Answers 5

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related