What is the process for converting monthly data into an array?

Question

What is the process for converting monthly data into an array?

I am working with an array of daily data that looks like this:

var data = [{x: '2017-01-01', y: 100}, {x: '2017-01-02', y: 99}, /* entire year. */];

Each element in the array has an x field for date and a y field for a number. This array contains data for an entire year.

I am looking to generate an output array where each element is the sum of y values for every month, like so:

var output = [10000, 9999, ...]

I am unsure if JavaScript has a function similar to 'GROUP BY' in SQL. If it does, perhaps I can use a reduce method to accumulate data for each month. Can you please provide assistance?

javascript

Answer 1

Answer №1

An efficient way to handle this would be to create a result set for each month, including those with zero values, and then iterate through the data. By using the month as an index adjusted to zero-based, you can easily add up the values for each item.

var data = [{ x: '2017-01-01', y: 100 }, { x: '2017-01-02', y: 99 }, { x: '2017-01-02', y: 99 }, { x: '2017-02-02', y: 10 }, { x: '2017-04-02', y: 42 }],
    result = Array.apply(null, { length: 12 }).map(function () { return 0; });

data.forEach(function (o) {
    result[o.x.slice(5, 7) - 1] += o.y;
});

console.log(result);

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

Answer 2

An efficient way to handle this would be to create a result set for each month, including those with zero values, and then iterate through the data. By using the month as an index adjusted to zero-based, you can easily add up the values for each item.

var data = [{ x: '2017-01-01', y: 100 }, { x: '2017-01-02', y: 99 }, { x: '2017-01-02', y: 99 }, { x: '2017-02-02', y: 10 }, { x: '2017-04-02', y: 42 }],
    result = Array.apply(null, { length: 12 }).map(function () { return 0; });

data.forEach(function (o) {
    result[o.x.slice(5, 7) - 1] += o.y;
});

console.log(result);

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

What is the process for converting monthly data into an array?

Answer №1

Similar questions

Designing a versatile DIV that sorts through components with the power of HTML, CSS, and JavaScript

The fetch API is being restricted, however, AJAX and XHR are still operational

Transform a javascript object with class attributes into a simple object while keeping the methods

Tips for inserting an element into every tier of a multi-layered array

What is a memory-saving method to clear an object in JavaScript?

Having trouble sending a prop to an API function from UseEffect in React with Next.js

Having difficulty completing the text field and submitting it automatically

Get the values of var1 and var2 from the URL in PHP, for example: `example.php?var1

Avoiding memory leaks in Node.js with Express framework

Error with infiniteCarousel in Internet Explorer versions 7 and 8 when using jQuery

Having trouble sending a JSON object from Typescript to a Web API endpoint via POST request

How do you vertically span a grid element across 3 rows using Material UI?

Exploring ES6 classes in Java Script: accessing prototype properties

Mastering the art of iterating through arrays using node.js request()

Troubleshooting Angular directives and the complications of closures

An unconventional way to display an image using the :before pseudo-element and a data attribute in CSS

Getting rid of the backslash from a JSON object in an Axios POST request

Acquire information from a Card using Oracle Apex

Using JavaScript's Regex to match sentences, while ensuring any full stops within quotes are ignored

Enhancing Image Source URLs with Dynamic Content Using HTML and JavaScript