Add up the duplicate elements in two arrays

Question

Add up the duplicate elements in two arrays

I have dynamically created two arrays with the same number of cells (where array.length is the same, representing a key and value association). Below are the arrays:

barData.labels["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone"]

barData.datasets[0].data["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99"]

My goal is to identify duplicate values in barData.labels, then sum up the corresponding values in barData.datasets[0].data and remove the duplicates. For instance, if there are 2 entries for 'Food', I want to combine and delete one entry.

Is there a way to achieve this?

javascript jquery

Answer 1

Answer №1

Consider using a JavaScript object instead of utilizing two arrays in this scenario. It may be more efficient to do so at the time of creation.

An example implementation could look like this:

barData = {
  "Food": ["12", "6", "15", "100", "3", ...]
}

With this structure, if you need to add another Food category, you can easily verify whether it already exists within the barData object. If not, you can create it; otherwise, you simply append an element to the existing array for that specific Food key.

Answer 2

Consider using a JavaScript object instead of utilizing two arrays in this scenario. It may be more efficient to do so at the time of creation.

An example implementation could look like this:

barData = {
  "Food": ["12", "6", "15", "100", "3", ...]
}

With this structure, if you need to add another Food category, you can easily verify whether it already exists within the barData object. If not, you can create it; otherwise, you simply append an element to the existing array for that specific Food key.

Answer 3

Answer №2

Utilize an array and the filter method.

Take a look at this resource.

Finding unique elements in an array using jQuery

Answer 4

Utilize an array and the filter method.

Take a look at this resource.

Finding unique elements in an array using jQuery

Answer 5

Answer №3

By utilizing a map to keep track of duplicates, you can effectively determine when to add values and where to calculate sums.

Consider the following approach:

let ls = [ ... ];
let vs = [ ... ];
let dups = {};
let lls = [];
let vvs = [];
for(let i = 0, len = vs.length; i < len; i++) {
    let l = ls[i]; 
    let v = vs[i];
    if(dups.hasOwnProperty(l)) {
        let ii = dups[l];
        vvs += vs[ii];
    } else {
        let ii = vvs.length;
        dups[l] = ii;
        lls[ii] = l;
        vvs[ii] = v;
    }
}

Answer 6

By utilizing a map to keep track of duplicates, you can effectively determine when to add values and where to calculate sums.

Consider the following approach:

let ls = [ ... ];
let vs = [ ... ];
let dups = {};
let lls = [];
let vvs = [];
for(let i = 0, len = vs.length; i < len; i++) {
    let l = ls[i]; 
    let v = vs[i];
    if(dups.hasOwnProperty(l)) {
        let ii = dups[l];
        vvs += vs[ii];
    } else {
        let ii = vvs.length;
        dups[l] = ii;
        lls[ii] = l;
        vvs[ii] = v;
    }
}

Answer 7

Answer №4

Imagine you have two arrays set up like this:

var categories = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone", "Phone", "Status", "Status"];
var dataValues = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99", "1", "333", '77'];

Now your goal is to get an output similar to this:

var finalResult = {
  "Food": ["2","8","20","200","1","300","400","500","77","7"],
  "Phone": ["99","1"],
  "Status": ["333","77"]
}

The following code snippet accomplishes that:

var tempArr = []
var finalResult  = {};
for(index in categories){
   var category = categories[index];
   if(tempArr.indexOf(category) > -1){
      finalResult[category].push(dataValues[index])
   }
   else{
      tempArr.push(category);
      finalResult[category] = [dataValues[index]];
   }
}
console.log(finalResult);

If you want to sum the values, you can modify the code slightly like so:

var tempArr = []
var finalResult  = {};
for(index in categories){
   var category = categories[index];
   if(tempArr.indexOf(category) > -1){
      finalResult[category]= parseInt(dataValues[index]) + parseInt(finalResult[category]);
   }
   else{
      tempArr.push(category);
      finalResult[category] = dataValues[index];
   }
}
console.log(finalResult);

Answer 8

Imagine you have two arrays set up like this:

var categories = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone", "Phone", "Status", "Status"];
var dataValues = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99", "1", "333", '77'];

Now your goal is to get an output similar to this:

var finalResult = {
  "Food": ["2","8","20","200","1","300","400","500","77","7"],
  "Phone": ["99","1"],
  "Status": ["333","77"]
}

The following code snippet accomplishes that:

var tempArr = []
var finalResult  = {};
for(index in categories){
   var category = categories[index];
   if(tempArr.indexOf(category) > -1){
      finalResult[category].push(dataValues[index])
   }
   else{
      tempArr.push(category);
      finalResult[category] = [dataValues[index]];
   }
}
console.log(finalResult);

If you want to sum the values, you can modify the code slightly like so:

var tempArr = []
var finalResult  = {};
for(index in categories){
   var category = categories[index];
   if(tempArr.indexOf(category) > -1){
      finalResult[category]= parseInt(dataValues[index]) + parseInt(finalResult[category]);
   }
   else{
      tempArr.push(category);
      finalResult[category] = dataValues[index];
   }
}
console.log(finalResult);

Answer 9

Answer №5

If you want to consolidate your values and convert them back into the original array format, one approach is to store the values in a temporary object, summing them up as you iterate through the array. Then, you can rearrange the values to match the structure of the original array.

// Original array creation
var barData = {};
barData.labels = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone"];
barData.datasets = [];
barData.datasets[0] = {};
barData.datasets[0].data = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99"];
// Displaying original object
$("#original").text(JSON.stringify(barData));
var newBarData = {};
for (var i = 0; i < barData.labels.length; i++) {
  if (newBarData[barData.labels[i]] === undefined) {
    newBarData[barData.labels[i]] = {};
    newBarData[barData.labels[i]].labels = barData.labels[i];
    newBarData[barData.labels[i]].value = parseInt(barData.datasets[0].data[i]);
  } else
    newBarData[barData.labels[i]].value += parseInt(barData.datasets[0].data[i]);
}

// Convert back to original format
barData = {};
barData.labels = [];
barData.datasets = [];
barData.datasets[0] = {};
barData.datasets[0].data = [];
$.each(newBarData, function(index, me) {
  barData.labels.push(me.labels);
  barData.datasets[0].data.push(me.value);
});

$("#result").text(JSON.stringify(barData));

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<div id="original"></div>
<div id="result"></div>

Answer 10

If you want to consolidate your values and convert them back into the original array format, one approach is to store the values in a temporary object, summing them up as you iterate through the array. Then, you can rearrange the values to match the structure of the original array.

// Original array creation
var barData = {};
barData.labels = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone"];
barData.datasets = [];
barData.datasets[0] = {};
barData.datasets[0].data = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99"];
// Displaying original object
$("#original").text(JSON.stringify(barData));
var newBarData = {};
for (var i = 0; i < barData.labels.length; i++) {
  if (newBarData[barData.labels[i]] === undefined) {
    newBarData[barData.labels[i]] = {};
    newBarData[barData.labels[i]].labels = barData.labels[i];
    newBarData[barData.labels[i]].value = parseInt(barData.datasets[0].data[i]);
  } else
    newBarData[barData.labels[i]].value += parseInt(barData.datasets[0].data[i]);
}

// Convert back to original format
barData = {};
barData.labels = [];
barData.datasets = [];
barData.datasets[0] = {};
barData.datasets[0].data = [];
$.each(newBarData, function(index, me) {
  barData.labels.push(me.labels);
  barData.datasets[0].data.push(me.value);
});

$("#result").text(JSON.stringify(barData));

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<div id="original"></div>
<div id="result"></div>

Answer 11

Answer №6

To enhance efficiency, my recommendation is to construct an object that encapsulates the distribution of the items, followed by a recreation of the labels and counts.

var labels = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone"],
    data = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99"],
    distribution = labels.reduce(function (r, a, i) {
        r[a] = (r[a] || 0) + +data[i];
        return r;
    }, {});

Object.keys(distribution).forEach(function (k, i) {
    if (!i) {
        labels = [];
        data = [];
    }
    labels.push(k);
    data.push(distribution[k]);
});

document.write('<pre>' + JSON.stringify(labels, 0, 4) + '</pre>');
document.write('<pre>' + JSON.stringify(data, 0, 4) + '</pre>');

Answer 12

To enhance efficiency, my recommendation is to construct an object that encapsulates the distribution of the items, followed by a recreation of the labels and counts.

var labels = ["Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Food", "Phone"],
    data = ["2", "8", "20", "200", "1", "300", "400", "500", "77", "7", "99"],
    distribution = labels.reduce(function (r, a, i) {
        r[a] = (r[a] || 0) + +data[i];
        return r;
    }, {});

Object.keys(distribution).forEach(function (k, i) {
    if (!i) {
        labels = [];
        data = [];
    }
    labels.push(k);
    data.push(distribution[k]);
});

document.write('<pre>' + JSON.stringify(labels, 0, 4) + '</pre>');
document.write('<pre>' + JSON.stringify(data, 0, 4) + '</pre>');

Add up the duplicate elements in two arrays

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Answer №6

Similar questions

Using Javascript to access a website from a Windows Store application

Setting an HTML element ID on a material-ui component: A step-by-step guide

Design an interactive div element that allows users to modify its content, by placing a span

Error encountered due to an unhandled promise rejection of type

Improve the translation animation on an element containing numerous child nodes

Tips for properly formatting the sort_by parameter in Cloudinary to avoid errors

Displaying the format when entering a value with react-number-format

Is there a way to dynamically refresh the options in a select dropdown using jQuery?

Creating Seamless, Unified Shape-to-Shape (Containers) Transition with CSS and JavaScript - A Step-by-Step Guide

Adding array elements to a JavaScript object

Add an input element to a form fieldset by employing vue

Passing a JavaScript object that may be undefined to a pug template in Node.js

Is there a way to streamline the import process for material-ui components?

I found myself pondering the significance of the {blogs: blogs} in my code

Organize intricate JavaScript Arrays

How can one ensure that Discord waits for a script to complete running, and how can you prevent Discord from responding until all necessary data has been obtained?

Encountered a discrepancy with npm dependencies during the update or installation process on a legacy project

Sliding with JavaScript

Node.js has the ability to establish internal connections, however it cannot establish connections

Dealing with numerous promises simultaneously using AngularJS Factory