Combine JSON data into groups based on two keys and calculate the overall count

Question

Combine JSON data into groups based on two keys and calculate the overall count

Searching for a way to organize the JSON Array with 2 keys and calculate the counts of grouped object key using Javascript.

Seeking a solution specifically in Javascript.

Link to Reference

Desired Outcome: the length of the counts object should be limited to 5, showing the total sum of all grouped keys combined.

[
  {
    "totalCount": 3,
    "counts": [0,0,3,0,0],
    "productID": "tea1",
    "keyVal": "key5",
    "trend": "0"
  },
    {
    "totalCount": 4,
    "counts": [2,2,0,0,0],
    "productID": "tea1",
    "keyVal": "key1",
    "trend": "0"
  },
  {
    "totalCount": 11,
    "counts": [0,5,6,0,0],
    "productID": "group1",
    "keyVal": "key2",
    "trend": "0"
  },
  {
    "totalCount": 616,
    "counts": [101,507,8,0,0],
    "productID": "group1",
    "keyVal": "key1",
    "trend": "0"
 },
]

javascript arrays json group-by grouping

Answer 1

Answer №1

UPDATE: I inadvertently overlooked the second key

Here is the revised solution:

temp1 = the json data provided in the pasteBin

Adjust the trend variable as the calculation method was not specified.

function groupBy(array, f) {
    var groups = {};
    array.forEach(function(o) {
        var group = JSON.stringify(f(o));
        groups[group] = groups[group] || [];
        groups[group].push(o);
    });
    return Object.keys(groups).map(function(group) {
        return groups[group];
    })
}

var result = groupBy(temp1, function(item) {
    return [item.keyVal, item.productID];
});

var output = [];
result.forEach(grouped => {
    var count = [0, 0, 0, 0, 0];
    var totalCount = 0;
    var trend = 0;
    var productID = grouped[0].productID;
    var keyVal = grouped[0].keyVal;
    grouped.forEach(value => {
        totalCount += value.totalCount;
        value.counts.forEach((x, i) => count[i] += x)
    })
    console.log(count);
    output.push({
        counts: count,
        keyVal: keyVal,
        totalCount: totalCount,
        productID: productID,
        trend: trend
    });
})

Answer 2

UPDATE: I inadvertently overlooked the second key

Here is the revised solution:

temp1 = the json data provided in the pasteBin

Adjust the trend variable as the calculation method was not specified.

function groupBy(array, f) {
    var groups = {};
    array.forEach(function(o) {
        var group = JSON.stringify(f(o));
        groups[group] = groups[group] || [];
        groups[group].push(o);
    });
    return Object.keys(groups).map(function(group) {
        return groups[group];
    })
}

var result = groupBy(temp1, function(item) {
    return [item.keyVal, item.productID];
});

var output = [];
result.forEach(grouped => {
    var count = [0, 0, 0, 0, 0];
    var totalCount = 0;
    var trend = 0;
    var productID = grouped[0].productID;
    var keyVal = grouped[0].keyVal;
    grouped.forEach(value => {
        totalCount += value.totalCount;
        value.counts.forEach((x, i) => count[i] += x)
    })
    console.log(count);
    output.push({
        counts: count,
        keyVal: keyVal,
        totalCount: totalCount,
        productID: productID,
        trend: trend
    });
})

Combine JSON data into groups based on two keys and calculate the overall count

Answer №1

Similar questions

Is it possible to create a single-page Codeigniter website utilizing both jQuery and AJAX?

Setting up Type ORM configuration with a .env file in Nest.JS: A step-by-step guide

Create a full duplication of every field and array within an object using AngularJs with the deepCopy method

Pending status persists for Axios post request

Using a series of functions that make use of (theID)

Avoid having the browser automatically move focused elements that are navigated to using the tab key

The array is displaying unexpected numerical values

Hey there! Is there a way to detect in React when the page is rendering due to a ctrl+shift+t command?

What could be the reason for the empty value of driver_execute?

Implementing popup alert for multiple tabs when Javascript session times out

How can I create an efficient Java class to model a basic JSON document and handle deserialization effectively?

Tips on implementing {% csrf_token %} with javascript

React: Incorporating .map for nested arrays. Ensure each child component within the list is assigned a distinct "key" property

Transform a collection of dates and times into a string separated by commas, showing the range of values with hyphens

Learn the method for automatically checking a checkbox when a page is loaded in Angular

JavaScript: Perform multiplication and addition on two arrays

Save data from localStorage to clipboard with a click of a button

Query for looping through JavaScript: what is the technique for extracting only number elements to create a fresh array?

Using a string as a key for an object's property

Encountered a CPU-side conversion issue causes Browser to crash when attempting to load an object using threejs