javascript utilizing underscorejs to categorize and aggregate information

Question

javascript utilizing underscorejs to categorize and aggregate information

Here is the data I have:

var dates = [
    {date: "2000-01-01", total: 120}, 
    {date: "2000-10-10", total: 100}, 
    {date: "2010-02-08", total: 100},
    {date: "2010-02-09", total: 300}
];

My goal is to group and sum the totals by year like this.

var grouped = [
    {date: "2000", total: 220}, 
    {date: "2010", total: 100}
];

I tried using underscorejs but couldn't find a suitable function.

var byYear = _.map(dates, function(item){ 
    var year = new Date(Date.parse(item.date)).getFullYear();

    return {date: year, total: item.total}; 
});

You can see the working code here.

javascript group-by underscore.js

Answer 1

Answer №1

Utilizing the reduce method. I noticed that this question had already been answered right before I could submit my response. Despite that, I had invested time in coding it so I will share it here anyway. It's worth noting that this solution involves chaining.

var byYear = _.chain(dates)
            .map(function(item){ 
                var year = new Date(Date.parse(item.date)).getFullYear();
                return {date: year, total: item.total}; 
            })
            .groupBy('date')
            .map(function (value,key) { 
                            var reduceVal = _.reduce(value, function (acc, val)
                                                            { 
                                                                return acc + val.total;
                                                            },0 ); 
                            return {'year':key,'total' :reduceVal};
                })
            .value();


alert(JSON.stringify(byYear));

Answer 2

Utilizing the reduce method. I noticed that this question had already been answered right before I could submit my response. Despite that, I had invested time in coding it so I will share it here anyway. It's worth noting that this solution involves chaining.

var byYear = _.chain(dates)
            .map(function(item){ 
                var year = new Date(Date.parse(item.date)).getFullYear();
                return {date: year, total: item.total}; 
            })
            .groupBy('date')
            .map(function (value,key) { 
                            var reduceVal = _.reduce(value, function (acc, val)
                                                            { 
                                                                return acc + val.total;
                                                            },0 ); 
                            return {'year':key,'total' :reduceVal};
                })
            .value();


alert(JSON.stringify(byYear));

Answer 3

Answer №2

It appears that you are in need of the reduce function:

var dates = [
    {date: "2000-01-01", total: 120}, 
    {date: "2000-10-10", total: 100}, 
    {date: "2010-02-08", total: 100}
];

var byYear = _.map(dates, function(item){ 
    var year = new Date(Date.parse(item.date)).getFullYear();        
    return {date: year, total: item.total}; 
});

var grouped = _.reduce(byYear, function(memo, item) {
    memo[item.date] = (memo[item.date] || 0) + item.total;
    return memo;
}, {});

Answer 4

It appears that you are in need of the reduce function:

var dates = [
    {date: "2000-01-01", total: 120}, 
    {date: "2000-10-10", total: 100}, 
    {date: "2010-02-08", total: 100}
];

var byYear = _.map(dates, function(item){ 
    var year = new Date(Date.parse(item.date)).getFullYear();        
    return {date: year, total: item.total}; 
});

var grouped = _.reduce(byYear, function(memo, item) {
    memo[item.date] = (memo[item.date] || 0) + item.total;
    return memo;
}, {});

javascript utilizing underscorejs to categorize and aggregate information

Answer №1

Answer №2

Similar questions

Generating unique spreadsheet identifiers in an HTML file

Unable to activate function when closing Vuetify v-alert

There seems to be an issue with the accurate calculation of the screen width while utilizing the scrollbar-gutter

Executing a function on the window object in JavaScript

Error: ReactJs unable to find location

Unlocking the Potential of NextJS with Dynamic Page Export - Say Goodbye to Static HTML!

Arranging objects in an array using jQuery for optimal organization

Javascript: regular expression to validate alphanumeric and special characters

What is the best way to hide a custom contextmenu in AngularJs?

Display data in Highchart legend only if it has values

Tips for maintaining interactivity after a page refresh

Issues arise in Ionic 3 when attempting to use scripts or external custom jQuery plugins within inner pages

Javascript - accessing a local file (located in the same directory as the HTML file, not an uploaded file)

Is it really necessary to import React from 'react' in the index.js file when importing react is no longer required?

Error in jQuery: Null property causing TypeError when reading 'text'

Expanding Headers with JavaScript

Reverse the text alteration when the user leaves the field without confirming

How can I set a condition to open a specific page in ReactJs?

Is there a way to create a header that fades out or disappears when scrolling down and reappears when scrolling up?

"Enhance your website with Express.js and eliminate the need for full