Manipulating Arrays with Conditions in JavaScript

Question

Manipulating Arrays with Conditions in JavaScript

Here is an array I need to work with:


0: {productid: "001", containersize: "20", ContCount: 10}
1: {productid: "002", containersize: "20", ContCount: 9}
2: {productid: "001", containersize: "40", ContCount: 4}
3: {productid: "001", containersize: "20", ContCount: 20}
4: {productid: "003", containersize: "20", ContCount: 18}
5: {productid: "001", containersize: "40", ContCount: 7}
6: {productid: "003", containersize: "40", ContCount: 25}

I aim to transform this data into a new array like so:


0: {productid: "001", containersize20: 30, containersize40: 11, total: 41}
1: {productid: "002", containersize20: 9, containersize40: 0, total: 9}
2: {productid: "003", containersize20: 18, containersize40: 25, total: 43}

The purpose is to sum up the counts of containers based on product type and container size.

Initially, I used the following code snippet:


var group_to_values = data.reduce(function (obj, item) {
            obj[item.productid] = obj[item.productid] || [];
            obj[item.productid].push(item.ContCount);
            return obj;
        }, {});

        var groups = Object.keys(group_to_values).map(function (key) {
            return {productid: key, ContCount: group_to_values[key]};
        });

At this stage, I am facing difficulty in proceeding further with the transformation process.

javascript arrays json

Answer 1

Answer №1

Utilizing the reduce method is an ideal solution for this scenario. By iterating through the structure and creating a result object with keys based on specific criteria, you can then extract the values array:

const data = [
  {productid: "001", containersize: "20", ContCount: 10},
  {productid: "002", containersize: "20", ContCount: 9},
  {productid: "001", containersize: "40", ContCount: 4},
  {productid: "001", containersize: "20", ContCount: 20},
  {productid: "003", containersize: "20", ContCount: 18},
  {productid: "001", containersize: "40", ContCount: 7},
  {productid: "003", containersize: "40", ContCount: 25}
];

const res = Object.values(data.reduce((a, e) => {
  if (!(e.productid in a)) {
    a[e.productid] = {
      productid: e.productid, 
      containersize20: 0,
      containersize40: 0,
      total: 0
    };
  }
  
  a[e.productid].containersize20 += e.containersize === "20" ? e.ContCount : 0;
  a[e.productid].containersize40 += e.containersize === "40" ? e.ContCount : 0;
  a[e.productid].total += e.ContCount;
  return a;
}, {}));

console.log(res);

Answer 2

Utilizing the reduce method is an ideal solution for this scenario. By iterating through the structure and creating a result object with keys based on specific criteria, you can then extract the values array:

const data = [
  {productid: "001", containersize: "20", ContCount: 10},
  {productid: "002", containersize: "20", ContCount: 9},
  {productid: "001", containersize: "40", ContCount: 4},
  {productid: "001", containersize: "20", ContCount: 20},
  {productid: "003", containersize: "20", ContCount: 18},
  {productid: "001", containersize: "40", ContCount: 7},
  {productid: "003", containersize: "40", ContCount: 25}
];

const res = Object.values(data.reduce((a, e) => {
  if (!(e.productid in a)) {
    a[e.productid] = {
      productid: e.productid, 
      containersize20: 0,
      containersize40: 0,
      total: 0
    };
  }
  
  a[e.productid].containersize20 += e.containersize === "20" ? e.ContCount : 0;
  a[e.productid].containersize40 += e.containersize === "40" ? e.ContCount : 0;
  a[e.productid].total += e.ContCount;
  return a;
}, {}));

console.log(res);

Answer 3

Answer №2

You're making progress in the right direction, consider condensing your code using a single `.reduce` function to create an object indexed by `productid`. Then, you can extract the values from this object and transform them back into an array. Remember to convert the `containersize` string to a number for proper addition:

const input = [
  {productid: "001", containersize: "20", ContCount: 10},
  {productid: "002", containersize: "20", ContCount: 9},
  {productid: "001", containersize: "40", ContCount: 4},
  {productid: "001", containersize: "20", ContCount: 20},
  {productid: "003", containersize: "20", ContCount: 18},
  {productid: "001", containersize: "40", ContCount: 7},
  {productid: "003", containersize: "40", ContCount: 25}
];
const output = Object.values(input.reduce((a, { productid, containersize, ContCount }) => {
  if (!a[productid]) a[productid] = {
    productid,
    total: 0,
    containersize20: 0,
    containersize40: 0,
  };
  a[productid]['containersize' + containersize] += ContCount;
  a[productid].total += ContCount;
  return a;
}, {}));
console.log(output);

It's important to note that this implementation is pure JavaScript, not jQuery. Often, built-in JavaScript functionalities can be just as effective as jQuery.

Answer 4

You're making progress in the right direction, consider condensing your code using a single `.reduce` function to create an object indexed by `productid`. Then, you can extract the values from this object and transform them back into an array. Remember to convert the `containersize` string to a number for proper addition:

const input = [
  {productid: "001", containersize: "20", ContCount: 10},
  {productid: "002", containersize: "20", ContCount: 9},
  {productid: "001", containersize: "40", ContCount: 4},
  {productid: "001", containersize: "20", ContCount: 20},
  {productid: "003", containersize: "20", ContCount: 18},
  {productid: "001", containersize: "40", ContCount: 7},
  {productid: "003", containersize: "40", ContCount: 25}
];
const output = Object.values(input.reduce((a, { productid, containersize, ContCount }) => {
  if (!a[productid]) a[productid] = {
    productid,
    total: 0,
    containersize20: 0,
    containersize40: 0,
  };
  a[productid]['containersize' + containersize] += ContCount;
  a[productid].total += ContCount;
  return a;
}, {}));
console.log(output);

It's important to note that this implementation is pure JavaScript, not jQuery. Often, built-in JavaScript functionalities can be just as effective as jQuery.

Manipulating Arrays with Conditions in JavaScript

Answer №1

Answer №2

Similar questions

What is the method in Java to extract the name of the oldest individual by utilizing split strings and arrays?

Solving the problem of 'json mime-type on 2003 server

The positioning of the JQueryUI menu is experiencing some issues

Have you ever wondered how to disable a tooltip in React Material UI after clicking on it? Let

Express.js not redirecting to Angular route, app not starting

Creating a button that redirects to an external link in CodeIgniter:

Assigning a value to an integer from a compatible integer data type

Building an Array in C++ Containing Class and Derived Objects

(C) Procedure involving a two-dimensional array

Challenges with ioException within the Sudoku algorithm

Create a custom definition for the useSelector function within a separate TypeScript file in a React

Why does the click on the download link result in the image opening instead?

Is there a way for me to retrieve the data returned from a worker thread?

In my approach to locating the subarray with the largest sum modulo x, I employ an iterative search method utilizing Binary Search

Checking the Json response with Java

Trouble with the installation of pg-native dependency

Obtain a specific element in Puppeteer JS by utilizing the waitForSelector function to detect when its class name changes

Developing a new webpage component in Selenium using C# and retrieving the corresponding feedback

The Bootstrap modal window refuses to shut down

Why isn't my watch function functioning properly within Vue?