flatten array of objects with dynamic keys and sum only values with "_abs" in key name

Question

I have an array of objects that looks like this:

[{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2, ...},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2, ...},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2, ...},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2, ...}]

There can be up to n elements in each object, each one consists of a _perc and an _abs value. I want to reduce the array to only 1 entry and sum each _abs value, the _perc can be anything else, like "-".

An expected result would be:

{"A_abs": 16, "A_perc": "-" "B_abs": 16, "B_perc": "-"  "C_abs": x, "C_perc": "-", ...}

The solution of this question does not fully statisfy me because I don't know how to adapt the function to only sum the "_abs" values.

How to adapt this function to only sum the _abs values, regardles of how many entries the object has?

var data = [{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2},{"A_abs":4,"A_perc":2, "B_abs":4,"B_perc":2}],
    result = data.reduce((r, o) => (Object.entries(o).forEach(([k, v]) => r[k] = (r[k] || 0) + v), r), {});

console.log(result);

What is the expected output? Do you want to sum up all the A_ABS? — 0stone0
– 0stone0, Commented Jun 8, 2022 at 12:21
The final object will have all the _abs keys, for ex: a_abs, b_abs, c_abs etc and all of them would have same value i.e. their sum? — Som Shekhar Mukherjee
– Som Shekhar Mukherjee, Commented Jun 8, 2022 at 12:25
@SSM, correct, the final object should have all _abs and their sums — toffler
– toffler, Commented Jun 8, 2022 at 12:27
@toffler Please check the answer below probably it does what you need. — Som Shekhar Mukherjee
– Som Shekhar Mukherjee, Commented Jun 8, 2022 at 12:29

Som Shekhar Mukherjee · Accepted Answer · 2022-06-08 12:28:29Z

3

You can check if the key ends with _abs and only if it does you add the values else you simply assign a value of -.

const data = [
    { A_abs: 4, A_perc: 2, B_abs: 4, B_perc: 2 },
    { A_abs: 4, A_perc: 2, B_abs: 4, B_perc: 2 },
    { A_abs: 4, A_perc: 2, B_abs: 4, B_perc: 2 },
    { A_abs: 4, A_perc: 2, B_abs: 4, B_perc: 2 },
  ],
  result = data.reduce(
    (r, o) => (
      Object.entries(o).forEach(([k, v]) =>
        k.endsWith("_abs") ? (r[k] = (r[k] || 0) + v) : (r[k] = "-")
      ),
      r
    ),
    {}
  );

console.log(result);

answered Jun 8, 2022 at 12:28

Som Shekhar Mukherjee

8,1982 gold badges16 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

flatten array of objects with dynamic keys and sum only values with "_abs" in key name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related