How can I group array data in object using lodash javascript

Question

I want to group data using lodash javscript. first I try to use groupBy machine_id then I sum the total value

Here is my data

const data = [
  {
    id: 1,
    machine_id: 1,
    work_id: 1,
    total: 10
  },
  {
    id: 2,
    machine_id: 1,
    work_id: 2,
    total: 15
  },
  {
    id: 3,
    machine_id: 2,
    work_id: 3,
    total: 10
  },
  {
    id: 4,
    machine_id: 1,
    work_id: 1,
    total: 15
  },
]

I want to group machine_id then I want to sum by machine_id and after that I want to sum total each work_id

I want to output like this

[
  {
      "machine_id": 1,
      "sum_total": 25
      "work_group": [
        // In this work group I want to sum total each work_id 
        {
          work_id: 1
          sum_total: 25
        },
          {
          work_id: 2
          sum_total: 15
        }
      ]
    },
    {
      "machine_id": 2,
      "sum_total": 10
      "work_group": [
        {
          work_id: 3
          sum_total: 10
        }
      ]
    },
]

This is what I try

let groupData = _(data)
.groupBy("machine_id")
.map((data, machine_id) => ({
    machine_id,
    sum_total: _.sumBy(data, item => Number(item.total_time))
}))
.value();

my output look like this :

[
  {
      "machine_id": 1,
      "sum_total": 25

    },
    {
      "machine_id": 2,
      "sum_total": 10

    },
]

How can I drill down sum by work_id

Siva Kondapi Venkata · Accepted Answer · 2020-02-11 06:12:33Z

2

User reduce and Object.values will simplify

const data = [
  {
    id: 1,
    machine_id: 1,
    work_id: 1,
    total: 10
  },
  {
    id: 2,
    machine_id: 1,
    work_id: 2,
    total: 15
  },
  {
    id: 3,
    machine_id: 2,
    work_id: 3,
    total: 10
  },
  {
    id: 4,
    machine_id: 1,
    work_id: 1,
    total: 15
  }
];

const updated = Object.values(
  data.reduce((acc, curr) => {
    if (curr.machine_id in acc) {
      const work_group = [
        ...acc[curr.machine_id].work_group,
        { work_id: curr.work_id, sum_total: curr.total }
      ].reduce((wg_acc, wg_curr) => {
        wg_acc[wg_curr.work_id] =
          wg_curr.work_id in wg_acc
            ? {
                ...wg_acc[wg_curr.work_id],
                sum_total: wg_acc[wg_curr.work_id].sum_total + wg_curr.sum_total
              }
            : { ...wg_curr };
        return wg_acc;
      }, {});
      acc[curr.machine_id] = {
        ...acc[curr.machine_id],
        sum_total: acc[curr.machine_id].sum_total + curr.total,
        work_group: Object.values(work_group)
      };
    } else {
      acc[curr.machine_id] = {
        machine_id: curr.machine_id,
        sum_total: curr.total,
        work_group: [{ work_id: curr.work_id, sum_total: curr.total }]
      };
    }

    return acc;
  }, {})
);

console.log(updated);

edited Feb 11, 2020 at 6:12

answered Feb 11, 2020 at 5:06

Siva Kondapi Venkata

11.1k2 gold badges20 silver badges32 bronze badges

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

9 Comments

Ach Over a year ago

Hey sorry my bad I want to sum_total in work_group too can U update ans please I already update my data variable

Siva Kondapi Venkata Over a year ago

@Ach, you want the cumulative value in work_group as well?

Ach Over a year ago

yes I want to cumulative value in work_group too In case if work_id are same

Ach Over a year ago

Can you explain more a bit this line code acc[curr.machine_id] = curr.machine_id in acc Sry Im new for Js and never used it before where can I read more about this line code

Siva Kondapi Venkata Over a year ago

@Ach, while going thru element with reduce, Check the unique key curr.machine_id is already exist in acc (accumulator object). If exists you need to update the existing values and if not available that means, you can just add that element.

|

Harish · Accepted Answer · 2020-02-11 05:02:27Z

1

You can try below approach

const data = [
  {
    id: 1,
    machine_id: 1,
    work_id: 1,
    total: 10
  },
  {
    id: 2,
    machine_id: 1,
    work_id: 2,
    total: 15
  },
  {
    id: 2,
    machine_id: 2,
    work_id: 3,
    total: 10
  }
]

const res = data.reduce((acc = [], obj) => {
    const data = acc.findIndex(d => d.machine_id === obj.machine_id)
    if(data > -1) {
      acc[data] = { ...data, sum_total: acc[data].sum_total + obj.total, work_group: [...acc[data].work_group, obj] }
    } else {
      acc.push({
          machine_id: obj.machine_id,
          sum_total: obj.total,
          work_group:[obj]
      })
    }
 return acc;

}, [])

console.log(res)

answered Feb 11, 2020 at 5:02

Harish

1,9111 gold badge15 silver badges26 bronze badges

1 Comment

Ach Over a year ago

Hey sorry my bad I want to sum_total in work_group too can U update ans please I already update my data variable

Collectives™ on Stack Overflow

How can I group array data in object using lodash javascript

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related