Calculating the combined total and mean values within an object using JavaScript

Question

Calculating the combined total and mean values within an object using JavaScript

I have a set of data in the following format:

{
"Dates": ["January", "January", "March", "March", "March", "November", "November"],
"Values": [45.6, 0.5, 59.3, 46.56, 2.21, 48.59, 5.5]
}

My goal is to combine the values in "Values" (averaging) by month

The output I am aiming for:

{
"Dates":["January", "March", "November"],
"Values":[23.05, 36.02, 27]
}

I have come across various discussions on this topic, such as the one here. However, I am unsure how to implement it for an object with arrays. Any suggestions would be greatly appreciated. Thank you

javascript arrays javascript-objects

Answer 1

Answer №1

To achieve the desired outcome, follow these steps:

// Start by condensing the data into an object using dates as keys
const groupedData = data.Dates.reduce((accumulator, date, index) => {
  if (accumulator[date]) {
    accumulator[date].push(data.Values[index])
  } else {
    accumulator[date] = [data.Values[index]]
  }
  return accumulator
}, {});

// Next, transform the object into the required format
const finalResult = Object.keys(groupedData).reduce((accumulator, date) => {
  accumulator.Dates.push(date)
  accumulator.Values.push(groupedData[date].reduce((previous, current) => previous + current) / groupedData[date].length)
  return accumulator
}, {Dates: [], Values: []});

Answer 2

To achieve the desired outcome, follow these steps:

// Start by condensing the data into an object using dates as keys
const groupedData = data.Dates.reduce((accumulator, date, index) => {
  if (accumulator[date]) {
    accumulator[date].push(data.Values[index])
  } else {
    accumulator[date] = [data.Values[index]]
  }
  return accumulator
}, {});

// Next, transform the object into the required format
const finalResult = Object.keys(groupedData).reduce((accumulator, date) => {
  accumulator.Dates.push(date)
  accumulator.Values.push(groupedData[date].reduce((previous, current) => previous + current) / groupedData[date].length)
  return accumulator
}, {Dates: [], Values: []});

Answer 3

Answer №2

Here is a potential solution you can experiment with.

const data = {
  "Dates": ["January", "January", "March", "March", "March", "November", "November"],
  "Values": [45.6, 0.5, 59.3, 46.56, 2.21, 48.59, 5.5]
}

// Using Set to remove duplicate dates
const uniqueMonths = [...new Set(data.Dates)];

const result = {
  "Dates": uniqueMonths,
  "Values": uniqueMonths.map(month => {
    // Filter values for the current month
    const values = data.Values.filter((_, i) => data.Dates[i] === month);
    
    // Calculate the average value for the month
    return values.reduce((a, b) => a + b) / values.length;
  })
}

console.log(result);

Answer 4

Here is a potential solution you can experiment with.

const data = {
  "Dates": ["January", "January", "March", "March", "March", "November", "November"],
  "Values": [45.6, 0.5, 59.3, 46.56, 2.21, 48.59, 5.5]
}

// Using Set to remove duplicate dates
const uniqueMonths = [...new Set(data.Dates)];

const result = {
  "Dates": uniqueMonths,
  "Values": uniqueMonths.map(month => {
    // Filter values for the current month
    const values = data.Values.filter((_, i) => data.Dates[i] === month);
    
    // Calculate the average value for the month
    return values.reduce((a, b) => a + b) / values.length;
  })
}

console.log(result);

Answer 5

Answer №3

If you want to streamline your tasks, consider breaking them down into smaller segments and utilizing functions for different purposes:

Organizing data into groups,
Calculating the average of an array,
Producing a final result by creating an object of groups.

const
    getAverage = array => array.reduce((a, b) => a + b) / array.length,
    groupBy = (keys, values) => {
        const groups = {};

        for (let i = 0; i < keys.length; i++)
            (groups[keys[i]] ??= []).push(values[i]);

        return groups;
    },
    getAverages = groups => Object.entries(groups).reduce((r, [month, values]) => {
        r.Dates.push(month);
        r.Values.push(getAverage(values));
        return r;
    }, { Dates: [], Values: [] }),
    data = { Dates: ["January", "January", "March", "March", "March", "November", "November"], Values: [45.6, 0.5, 59.3, 46.56, 2.21, 48.59, 5.5] },
    result = getAverages(groupBy(data.Dates, data.Values));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Answer 6

If you want to streamline your tasks, consider breaking them down into smaller segments and utilizing functions for different purposes:

Organizing data into groups,
Calculating the average of an array,
Producing a final result by creating an object of groups.

const
    getAverage = array => array.reduce((a, b) => a + b) / array.length,
    groupBy = (keys, values) => {
        const groups = {};

        for (let i = 0; i < keys.length; i++)
            (groups[keys[i]] ??= []).push(values[i]);

        return groups;
    },
    getAverages = groups => Object.entries(groups).reduce((r, [month, values]) => {
        r.Dates.push(month);
        r.Values.push(getAverage(values));
        return r;
    }, { Dates: [], Values: [] }),
    data = { Dates: ["January", "January", "March", "March", "March", "November", "November"], Values: [45.6, 0.5, 59.3, 46.56, 2.21, 48.59, 5.5] },
    result = getAverages(groupBy(data.Dates, data.Values));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

Calculating the combined total and mean values within an object using JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

How can I integrate the jQuery Plugin Mapael with Angular 5?

Issue with passing parameter in Jquery AJAX request to controller function

Trouble with Material-UI Textfield Hinttext Functionality

JavaScript's inability to properly export CSV data containing the "#" character has been causing issues

Ways to update a div periodically with new data fetched from a file - Here's How!

Trouble with component not refreshing upon store modification in Vuex

"Extracting JSON data from a URL and loading it into a

Leveraging JSON for fetching distinct identifiers from a database

How to extract a particular value from a JSON object using AJAX?

Switch up the positioning of elements using jQuery

Is there a way to verify that all images have been successfully loaded following an

Execute a PHP script to modify a section of a PHP file

What could be the reason for the bottom edge of my central diagonal image having a darker border?

Potential 'undefined' object detected in Vuex mutation using TypeScript

Utilizing Subdirectories in a Command Manager

Experiencing difficulty adjusting the width of a Tumblr post with JavaScript or jQuery?

(Processing) Eliminating Previously Utilized Element from Array

unable to access objects in JavaScript due to an error

What is the most effective way to prevent JavaScript from running during page load or when the document is ready

Tips for inserting a DIV and SCRIPT from a single HTML template into a webpage