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

The issue with the tutorial is regarding the addHero function and determining the source of the new id

Exploring JSON data in real-time

Changing the time in Angular while converting a string to a date object has proven to be

Tips for creating ternary operator logic that account for numerous conditions and optional parameters:

Troubleshooting form submission issues in Angular 4

Unable to globally override the default font in MUI theme

Navigating through different components in Angular 4 using a service for routing

Error encountered following the upgrade of Angular and RxJS 5 to 6: Compilation failed

When we mention TypeScript and CDK, we are actually talking about the very foundation

How to Set Focus on an Input Field in an Angular 2 Modal

Navigating through Objects in Angular 9

What is the best way to duplicate a Typescript class object while making changes to specific properties?

Object autofill - Typescript utilizing Angular 5

What are the steps to troubleshoot server-side TypeScript code in NextJS with WebStorm?

Restricting enum type to only one member

Ensuring a Generic Type in Typescript is a Subset of JSON: Best Practices

Safeguarding user data across all components is facilitated by Angular 2

Navigating back to the login page in your Ionic V2 application can be achieved by utilizing the `this.nav

What is the method for utilizing string interpolation in Angular/Typescript in order to retrieve a value from a variable?

Extract the JSON array data from the Service and process it within the Component