How do I group data based on multiple conditions in JavaScript?

Question

How do I group data based on multiple conditions in JavaScript?

I have the data structured as follows:

[
  {
    "Id": 1,
    "Title": "Title_1",
    "Positive": 5,
    "CreateTs": 1674231433428
  },
  {
    "Id": 2,
    "Title": "Title_1",
    "Positive": 8,
    "CreateTs": 1674288139000
  },
  {
    "Id": 3,
    "Title": "Title_2",
    "Positive": 5,
    "CreateTs": 1674633970000
  },
  
  {
    "Id": 4,
    "Title": "Title_1",
    "Positive": 12,
    "CreateTs": 1674649613000
  },
  
  {
    "Id": 5,
    "Title": "Title_1",
    "Positive": 10,
    "CreateTs": 1674649741000
  }
  ]

Desired result:

  [
    // group by Title, and CreateTs in current week
    // Sum up the grouped number of Positive
    {
      "Title": "Title_1",
      "Positive_sum": 22
    },
    
    {
      "Title": "Title_2",
      "Positive_sum": 5
    }
  ]

Although I found a similar question, I couldn't fully comprehend it due to its complexity...

I attempted to use the array.slice method to extract initial terms, but since the data order varies each time, this was not effective. After researching different methods online with no success, I'm seeking assistance here.

javascript arrays group-by

Answer 1

Answer №1

function findMonday(d) {
    d = new Date(d);
    let dayOfWeek = d.getDay(),
        difference = d.getDate() - dayOfWeek + (dayOfWeek === 0 ? -6:1); // adjust when the day is Sunday
    return new Date(d.setDate(difference));
}


let dataResults = [{"Title": "Title_A", "Total": 0}, {"Title": "Title_B", "Total": 0}];
let currentTimestamp = Math.floor(new Date(findMonday(new Date())).getTime() / 1000);
data.forEach(obj => {
    if (obj.Title === dataResults[0].Title && obj.CreatedAt > currentTimestamp) {
        dataResults[0].Total += obj.PositiveCount;
    }
    if (obj.Title === dataResults[1].Title && obj.CreatedAt > currentTimestamp) {
        dataResults[1].Total += obj.PositiveCount;
    }
});

This code can validate the title of an object and determine if the timestamp exceeds Monday of the current week.

Answer 2

function findMonday(d) {
    d = new Date(d);
    let dayOfWeek = d.getDay(),
        difference = d.getDate() - dayOfWeek + (dayOfWeek === 0 ? -6:1); // adjust when the day is Sunday
    return new Date(d.setDate(difference));
}


let dataResults = [{"Title": "Title_A", "Total": 0}, {"Title": "Title_B", "Total": 0}];
let currentTimestamp = Math.floor(new Date(findMonday(new Date())).getTime() / 1000);
data.forEach(obj => {
    if (obj.Title === dataResults[0].Title && obj.CreatedAt > currentTimestamp) {
        dataResults[0].Total += obj.PositiveCount;
    }
    if (obj.Title === dataResults[1].Title && obj.CreatedAt > currentTimestamp) {
        dataResults[1].Total += obj.PositiveCount;
    }
});

This code can validate the title of an object and determine if the timestamp exceeds Monday of the current week.

Answer 3

Answer №2

To start, we must filter to obtain the current week's start timestamp and end timestamp and then apply this filter to CreateTs.

Next, we can utilize the reduce method to group our objects using an object instead of an array for ease of use. Afterwards, we will convert the object into an array using values().

const now = new Date();
const currentWeekStart = new Date(now.getFullYear(), now.getMonth(), now.getDate() - now.getUTCDay());
const currentWeekEnd = new Date(now.getFullYear(), now.getMonth(), now.getDate() + (6 - now.getUTCDay()));

const result = data
    .filter((item) => {
        const date = new Date(item.CreateTs);
        return date >= currentWeekStart && date <= currentWeekEnd;
    })
    .reduce((acc, item) => {
        const { Title, Positive } = item;
        if (!acc[Title]) {
            acc[Title] = { Title, Positive_sum: Positive };
        } else {
            acc[Title].Positive_sum += Positive;
        }
        return acc;
    }, {});

console.log(Object.values(result));

Answer 4

To start, we must filter to obtain the current week's start timestamp and end timestamp and then apply this filter to CreateTs.

Next, we can utilize the reduce method to group our objects using an object instead of an array for ease of use. Afterwards, we will convert the object into an array using values().

const now = new Date();
const currentWeekStart = new Date(now.getFullYear(), now.getMonth(), now.getDate() - now.getUTCDay());
const currentWeekEnd = new Date(now.getFullYear(), now.getMonth(), now.getDate() + (6 - now.getUTCDay()));

const result = data
    .filter((item) => {
        const date = new Date(item.CreateTs);
        return date >= currentWeekStart && date <= currentWeekEnd;
    })
    .reduce((acc, item) => {
        const { Title, Positive } = item;
        if (!acc[Title]) {
            acc[Title] = { Title, Positive_sum: Positive };
        } else {
            acc[Title].Positive_sum += Positive;
        }
        return acc;
    }, {});

console.log(Object.values(result));

How do I group data based on multiple conditions in JavaScript?

Answer №1

Answer №2

Similar questions

Stranger things happening when incorporating a generator function in React

Exploring JavaScript-based navigation with Python and Selenium

What could be causing my node server's REST endpoints to not function properly?

Build a flexible Yup validation schema using JSON data

Attempted to display a Google Map within a lightbox, but encountered difficulties in getting it to

Utilizing dropbox.js in combination with OAuth 1: A step-by-step guide

Retrieve the file name (as well as other properties) when clicking on an image in dropzone.js

Acquire a JSON response from a web address by utilizing JavaScript

Sending DOM values to React components as properties

To address the issue of input values not persisting in a Selenium iframe element, I am implementing a custom JavaScript event to

Generating a download link with an expiration feature in node.js or express for both frontend and backend operations

Tips for ensuring the CSRF token functions properly on the browser when utilizing Django and React

The argument type 'string' does not match the parameter type 'keyof Chainable' in Cypress JavaScript

Exploring the depths of an array in PHP/Symfony

The overlay div is not displaying over my main div as intended

How to delete the last item of an array in AngularJS using scope

Hiding the filelist on antd-Upload when the URL is not provided

What is causing the result of this code to be 111111?

The error callback in Jquery ajax is triggered despite receiving a 200 status code in the response

Guide to converting a D3js Bar Chart race into an MP4 or video file