What is the most efficient way to find the sum of duplicates in an array based on two different properties and then return the

Question

What is the most efficient way to find the sum of duplicates in an array based on two different properties and then return the

var data = 

[
  {
    "amount": 270,
    "xlabel": "25-31/10",
    "datestatus": "past",
    "color": "#E74C3C",
    "y": 270,
    "date": "2020-10-31T00:00:00Z",
    "entityId": 1,
    "entityName": "Lenovo HK",
    "bankName": "BNP Paribas Bank",
    "buyerName": "Microsoft",
    "currency": "USD"
  },
  {
    "amount": 100,
    "xlabel": "25-31/10",
    "datestatus": "past",
    "color": "#E74C3C",
    "y": 100,
    "date": "2020-10-30T00:00:00Z",
    "entityId": 1,
    "entityName": "Lenovo HK",
    "bankName": "BNP Paribas Bank",
    "buyerName": "Microsoft",
    "currency": "USD"
  },
  ...
]

function getFormationgData(data) {
    var sum = [];
    let counts = data.reduce((prev, curr) => {
      let amount = prev.get(curr.xlabel) || 0;
      prev.set(curr.xlabel, curr.amount + amount, curr.entityId, curr.entityName);
      return prev;
    }, new Map());

    // then, map your counts object back to an array
    let reducedObjArr = [...counts].map(([xlabel, amount, entityId,
      entityName]) => ({
       xlabel, amount,
        entityId,
        entityName
      }))
    //let reducedObjArr = [...counts].map(data => data)
    return reducedObjArr;
}
  
var pastData = getFormationgData(data.filter(w=>w.datestatus == 'past'));
var futureData = getFormationgData(data.filter(w=>w.datestatus == 'future'));

console.log(pastData, 'pastData', pastData.length)
console.log(futureData, 'futureData', futureData.length)

I'm attempting to calculate the sum of duplicate amounts in an array based on two other properties and retrieve separate arrays for past and future data.

The current dataset is as follows:

Assuming today's date is November 3, 2020

 [
{
    "amount": 270,
    "xlabel": "01-07/11", 
    "datestatus": "past",
    "color": "#E74C3C",
    "y": 270,
    "date": "2020-02-11T00:00:00Z",
    "entityId": 1,
    "entityName": "Lenovo HK",
    "bankName": "BNP Paribas Bank",
    "buyerName": "Microsoft",
    "currency": "USD"
  },

...
]

I am trying to organize this data based on `xlabel`, status, and entity. The expected result should contain separate arrays for past and future entries with all corresponding properties intact.

Although I've made some progress, I'm facing difficulties returning all properties in the object. Any assistance would be greatly appreciated!

javascript arrays typescript

Answer 1

Answer №1

I trust that I have correctly understood the task at hand.

I. Identifying Duplicate Sums

Here is a breakdown of what the algorithm accomplishes:

The values from amount are sorted into two distinct arrays, one for past values and one for future values.
Unique values are removed from both arrays.
The total sum of the remaining values in the array is calculated.

// JavaScript data objects
var data = [
  {
    // Data object details here
  },
  // Additional data objects
];

//////////////////////////////////////////////

function calculateTotal(data, z) {

    var filteredValues = [];
    for (var i = 0; i < data.length; i++) {
      if (data[i].datestatus === z) {
        filteredValues.push(data[i].amount);
      }
    }

    function findDuplicates(array) {
      var map = new Map();
      array.forEach(a => map.set(a, (map.get(a) || 0) + 1));
      return array.filter(a => map.get(a) > 1);
    }

    var duplicates = findDuplicates(filteredValues);
    
    var result = duplicates.reduce((a, b) => a + b, 0);
    
    return result;

}

console.log(calculateTotal(data, 'past'));
console.log(calculateTotal(data, 'future'));

II. Separating Future and Past Values into Different Arrays

This function generates an array containing only future or past values from the provided data set.

function sortData(data, z) {

    var filteredData = [];
    for (var i = 0; i < data.length; i++) {
      if (data[i].datestatus === z) {
        filteredData.push(data[i]);
      }
    }

    return filteredData;

}

console.log(sortData(data, 'past'));
console.log(sortData(data, 'future'));

Answer 2

I trust that I have correctly understood the task at hand.

I. Identifying Duplicate Sums

Here is a breakdown of what the algorithm accomplishes:

The values from amount are sorted into two distinct arrays, one for past values and one for future values.
Unique values are removed from both arrays.
The total sum of the remaining values in the array is calculated.

// JavaScript data objects
var data = [
  {
    // Data object details here
  },
  // Additional data objects
];

//////////////////////////////////////////////

function calculateTotal(data, z) {

    var filteredValues = [];
    for (var i = 0; i < data.length; i++) {
      if (data[i].datestatus === z) {
        filteredValues.push(data[i].amount);
      }
    }

    function findDuplicates(array) {
      var map = new Map();
      array.forEach(a => map.set(a, (map.get(a) || 0) + 1));
      return array.filter(a => map.get(a) > 1);
    }

    var duplicates = findDuplicates(filteredValues);
    
    var result = duplicates.reduce((a, b) => a + b, 0);
    
    return result;

}

console.log(calculateTotal(data, 'past'));
console.log(calculateTotal(data, 'future'));

II. Separating Future and Past Values into Different Arrays

This function generates an array containing only future or past values from the provided data set.

function sortData(data, z) {

    var filteredData = [];
    for (var i = 0; i < data.length; i++) {
      if (data[i].datestatus === z) {
        filteredData.push(data[i]);
      }
    }

    return filteredData;

}

console.log(sortData(data, 'past'));
console.log(sortData(data, 'future'));

What is the most efficient way to find the sum of duplicates in an array based on two different properties and then return the

Answer №1

Similar questions

Using React Bootstrap: Passing an array to options in Form.Control

React components multiplying with every click, tripling or even quadrupling in number

The menu is about to receive some custom styling

typescript: define the type of an object that behaves like a map

When triggering the fireEvent.mouseOver event, it seems that document.createRange is not a valid

The Jqueryui image link is not displaying the image despite no error being reported

Javascript puzzle - I have 99 obstacles

Steps for connecting an external .otf file in p5.js

Include a new route in the Vue.js router dynamically during runtime

An easy method for declaring a 2D array in C++

Resolving the Enigma: Querying jQuery for Real-Time Validation and

What is the best way to add a hyperlink to a cell in an Angular Grid column

What is the best way to send a Rails AJAX form upon clicking?

Deleting and inserting an element in the Document Object Model

Code activates the wrong function

extracting both the value and ID attributes from a RadioButtonGroup component in React MaterialUI

What is the best way to assign the selected attribute to my mat-option element?

What steps can be taken to convert this function into a more concise, dry function?

Switching players every two turns in a JavaScript AngularJS game

Can anyone help me with integrating a search functionality inside a select tag?