Attempting to condense an array of objects into a consolidated and combined array of objects

Question

Attempting to condense an array of objects into a consolidated and combined array of objects

My array of objects is structured like this:

dataArray = [
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 10, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 1, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"},
    {Revenue: 4, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
]

I am looking to condense this array into another set of objects that appear as follows:

reducedDataArray = [
    {Revenue: 20, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 5, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
]

The goal is to aggregate the revenue for entries with the same date. Limited by our version of TypeScript, I lack access to newer functionalities like ES6 features. Although I have attempted using methods like reduce(), I am struggling to navigate its intricacies in this context.

If you have any suggestions or insights on how to accomplish this task, your input would be greatly valued!

javascript typescript reduce

Answer 1

Answer №1

To create an object with date keys and then convert it back to an array, you can utilize the reduce method.

let dataArray = [
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 10, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 1, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"},
    {Revenue: 4, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
]
// It is important to explicitly specify the type parameter since it will not be inferred from the initial value 
let valuesObj = dataArray.reduce<{ [date: string]: typeof dataArray[number] }>((p, v) => {
    const existing = p[v.Date];
    if (existing) {
        existing.Revenue += v.Revenue
    } else {
        p[v.Date] = Object.assign({}, v); //Creating a copy prevents changing the original during summing 
    }
    return p;
}, {});


// If available, you can use Object.values(valuesObj) 
let values = Object.keys(valuesObj).map(k => valuesaObj[k]);

Check out the playground here

Answer 2

To create an object with date keys and then convert it back to an array, you can utilize the reduce method.

let dataArray = [
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 10, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Revenue: 1, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"},
    {Revenue: 4, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
]
// It is important to explicitly specify the type parameter since it will not be inferred from the initial value 
let valuesObj = dataArray.reduce<{ [date: string]: typeof dataArray[number] }>((p, v) => {
    const existing = p[v.Date];
    if (existing) {
        existing.Revenue += v.Revenue
    } else {
        p[v.Date] = Object.assign({}, v); //Creating a copy prevents changing the original during summing 
    }
    return p;
}, {});


// If available, you can use Object.values(valuesObj) 
let values = Object.keys(valuesObj).map(k => valuesaObj[k]);

Check out the playground here

Answer 3

Answer №2

Experimented with some loops and successfully implemented it

dataset = [
    {Sales: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 10, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 1, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"},
    {Sales: 4, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
];

const findUniqueEntries=array=>{
  return array.filter((value, index, self)=> { 
      return self.indexOf(value) === index;
  });
}

let dates=[];
let result=[];

for(const entry of dataset) dates.push(entry.Date);
for(const date of findUniqueEntries(dates)){

  let total=0,date=date,dateString;
  for(const record of dataset){
    if(record.Date==date) total+=record.Sales;
    dateString=record.DateString;
  }

  result.push({
    Sales:total,
    Date:date,
    DateString:dateString
  });

}

console.log(result);

Additional jsfiddle reference

Answer 4

Experimented with some loops and successfully implemented it

dataset = [
    {Sales: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 10, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 5, Date: "2018-06-05T00:00:00", DateString: "6/5/2018"},
    {Sales: 1, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"},
    {Sales: 4, Date: "2018-06-13T00:00:00", DateString: "6/13/2018"}
];

const findUniqueEntries=array=>{
  return array.filter((value, index, self)=> { 
      return self.indexOf(value) === index;
  });
}

let dates=[];
let result=[];

for(const entry of dataset) dates.push(entry.Date);
for(const date of findUniqueEntries(dates)){

  let total=0,date=date,dateString;
  for(const record of dataset){
    if(record.Date==date) total+=record.Sales;
    dateString=record.DateString;
  }

  result.push({
    Sales:total,
    Date:date,
    DateString:dateString
  });

}

console.log(result);

Additional jsfiddle reference

Attempting to condense an array of objects into a consolidated and combined array of objects

Answer №1

Answer №2

Similar questions

exploring CORS settings in fetch API for secure GET requests

Unable to globally override the default font in MUI theme

Is there a way to verify if a FormData file has no content?

Utilize JavaScript to extract information from an HTTP Response and insert both values into a <div> element

"Changing the size of the ArrowHelper in three.js: A step-by-step guide

Caution: flattenKids(): Two children with identical keys, `false`, have been detected in the ReactJS environment

Every time I try to request something on my localhost, NextJS console throws a TypeError, saying it cannot read the properties of undefined, specifically '_owner'

"Can you tell me the method for obtaining an array within an Angular

Finding the duration of an audio file in a React/Typescript environment

An Alternative Approach to Implementing the Ternary Operator in JavaScript

Tips for validating multiple inputs of the same type with identical names in JavaScript

tips for accessing data attributes in ajax request

Tips for resolving text center alignment problems along with other elements when hovering

Align the date input field to the center for better visual appeal

What is the most efficient way to transmit an HTML document element from a client to a server in Node JS

A step-by-step guide on how to insert an image URL into the src attribute using the

How is it that in TypeScript, a potential numeric value in an interface can be transformed into an impossible numeric value in a class implementation?

Why are other elements not appearing on the index.html page when <app-root> is not included?

What is the best way to dynamically convert a lodash object (specifically a filter object) into jQuery's listview component?

Exploring the integration of methods in Vue.js components