Combining numerical values with similar string values in a multi-dimensional array to calculate the sum

Question

Combining numerical values with similar string values in a multi-dimensional array to calculate the sum

I'm currently creating a JavaScript cash register application that calculates the exact change based on the available funds in the register. This project is part of a challenge on freeCodeCamp: https://www.freecodecamp.org/challenges/exact-change

Although I've made progress, I've hit a roadblock.

The key function in my program is addResult(), which accepts two parameters: name and val.

var result = [];
function addResult(name, val){
    result.push([name, val]);
}

For instance, if an $18 change is required, the function constructs an array like this:

[["ONE", 1.00], ["ONE", 1.00], ["ONE", 1.00], ["FIVE", 5.00], ["TEN", 10.00]]

However, I want the resulting array to look like this instead:

[["ONE", 3.00], ["FIVE", 5.00], ["TEN", 10.00]]

My goal is to have unique string names but aggregate the numbers together, yet I can't seem to figure out how to achieve this.

If anyone is willing to examine the complete code, here it is:

...

javascript arrays multidimensional-array

Answer 1

Answer №1

A simple solution might involve modifying the addResult function to first check if the specified name already exists in the list of results, and if it does, then add the provided value to it.

function addResult(name, val){
    let entry = result.find(e => e[0] === name);
    if (entry) {
        entry[1] += val;
    } else {
        result.push([name, val]);
    }
}

let result = [
  ["ONE", 1.00],
  ["FIVE", 5.00],
  ["TEN", 10.00]
];

function addResult(name, val) {
  let entry = result.find(e => e[0] === name);
  if (entry) {
    entry[1] += val;
  } else {
    result.push([name, val]);
  }
}

addResult("ONE", 1);
console.log(result);

Answer 2

A simple solution might involve modifying the addResult function to first check if the specified name already exists in the list of results, and if it does, then add the provided value to it.

function addResult(name, val){
    let entry = result.find(e => e[0] === name);
    if (entry) {
        entry[1] += val;
    } else {
        result.push([name, val]);
    }
}

let result = [
  ["ONE", 1.00],
  ["FIVE", 5.00],
  ["TEN", 10.00]
];

function addResult(name, val) {
  let entry = result.find(e => e[0] === name);
  if (entry) {
    entry[1] += val;
  } else {
    result.push([name, val]);
  }
}

addResult("ONE", 1);
console.log(result);

Answer 3

Answer №2

Another method to calculate total cash:

function CalculateCash(current,add) {
var holder = {};
current.forEach(function (d) {
    if(holder.hasOwnProperty(d.name)) {
       holder[d.name] = holder[d.name] + d.value;
    } else {       
       holder[d.name] = d.value;
    }
});
add.forEach(function (d) {
    if(holder.hasOwnProperty(d.name)) {
       holder[d.name] = holder[d.name] + d.value;
    } else {       
       holder[d.name] = d.value;
    }
});
var obj2 = [];
for(var prop in holder) {
    obj2.push({name: prop, value: holder[prop]});   
}
    console.log(obj2);
    return obj2;
}

    var current = [
        {name: 'PENNY',       value: 1},
        {name: 'NICKEL',      value: 5},
        {name: 'DIME',        value: 10},
        {name: 'QUARTER',     value: 25},
        {name: 'ONE',         value: 100},
        {name: 'FIVE',        value: 500},
        {name: 'TEN',         value: 1000},
        {name: 'TWENTY',      value: 2000},
        {name: 'ONE HUNDRED', value: 10000}
    ];
    
    var add = [
        {name: 'PENNY',       value: 1},
        {name: 'NICKEL',      value: 5},
        {name: 'DIME',        value: 10},
    ];

CalculateCash(current,add);

Answer 4

Another method to calculate total cash:

function CalculateCash(current,add) {
var holder = {};
current.forEach(function (d) {
    if(holder.hasOwnProperty(d.name)) {
       holder[d.name] = holder[d.name] + d.value;
    } else {       
       holder[d.name] = d.value;
    }
});
add.forEach(function (d) {
    if(holder.hasOwnProperty(d.name)) {
       holder[d.name] = holder[d.name] + d.value;
    } else {       
       holder[d.name] = d.value;
    }
});
var obj2 = [];
for(var prop in holder) {
    obj2.push({name: prop, value: holder[prop]});   
}
    console.log(obj2);
    return obj2;
}

    var current = [
        {name: 'PENNY',       value: 1},
        {name: 'NICKEL',      value: 5},
        {name: 'DIME',        value: 10},
        {name: 'QUARTER',     value: 25},
        {name: 'ONE',         value: 100},
        {name: 'FIVE',        value: 500},
        {name: 'TEN',         value: 1000},
        {name: 'TWENTY',      value: 2000},
        {name: 'ONE HUNDRED', value: 10000}
    ];
    
    var add = [
        {name: 'PENNY',       value: 1},
        {name: 'NICKEL',      value: 5},
        {name: 'DIME',        value: 10},
    ];

CalculateCash(current,add);

Combining numerical values with similar string values in a multi-dimensional array to calculate the sum

Answer №1

Answer №2

Similar questions

How to Use an Array to Filter Another Array in AngularJS

Different method for navigating in JavaScript

Updating a data with a JavaScript browser script

Incorporate an additional column into a table using AngularJS

Exploring ES6 Property Assignment

Tips on using Ajax to post in HTML

Is there a way to pass a c struct pointer into javascript using ffi?

Waiting for an API call to complete before loading a specific path in REACT - how can this be achieved?

Error: myFunction has not been declared

Discovering the amount of time a section of a webpage remains in view on a browser

The function $(...) does not recognize tablesorter

What is the process for syncing ng-model with external data sources?

Organizing arrays of doubles in increasing sequence

Which method of loading website images is quicker: sequential or parallel, utilizing Javascript?

Deliver search findings that are determined by matching criteria, rather than by identification numbers

Designing a personalized mat-icon using the Github SVG

Apple Automation: Extract a targeted string from text and transfer it to a different spot within the page

Is there a way to automatically close the Foundation topbar menu when a link is selected?

The div block containing the table is experiencing horizontal overlap as additional elements are inserted

Analyzing the Accuracy of Data Between Ground Truth and Predicted Values Stored in N