Create object from JSON response remove unwanted key-values

Question

I am getting JSON response as below :

bills : [
             {
                id: '111',
                date: '22 Jan 2020',
                amount: -250.00
            },
            {
                id: '222',
                date: '08 Jan 2020',
                amount: 700.00
            },
            {
                id: '333',
                date: '08 Feb 2020',
                amount: -250.00
            },
            {
                id: '788-609098-129169487',
                date: '08 Feb 2020',
                amount: 120.00
            }
    ]

I want to have object with only date and amount with month-wise total of amount like :

{
    "Jan" :
    {
        "month" : "Jan",
        "amount"  : 450.00
    },
    "Feb" :
    {
        "month" : "Feb",
        "amount"  : -130.00
    }

}

any help would be appreciated.

Does this answer your question? How do I remove a property from a JavaScript object? — Shiladitya
– Shiladitya, Commented Apr 6, 2020 at 16:19
Why do you use the month twice? Once as a key, once as a value? Why not using an array like : ``` [ { "month" : "Jan", "amount" : 450.00 }, { "month" : "Feb", "amount" : -130.00 } ] ``` — C.Champagne
– C.Champagne, Commented Apr 6, 2020 at 16:20
@Shiladitya I did checked that one but we're also adding the amounts' not just deleting. — Veey
– Veey, Commented Apr 6, 2020 at 16:24

random · Accepted Answer · 2020-04-06 16:31:38Z

2

const bills =  [
    {
       id: '111',
       date: '22 Jan 2020',
       amount: -250.00
   },
   {
       id: '222',
       date: '08 Jan 2020',
       amount: 700.00
   },
   {
       id: '333',
       date: '08 Feb 2020',
       amount: -250.00
   },
   {
       id: '788-609098-129169487',
       date: '08 Feb 2020',
       amount: 120.00
   }
];

const output = bills.reduce((a, {date, amount}) => {
    const month = date.slice(3, 6);

    if(!a[month]) { 
        a[month] = {"month": month, amount} 
    } else { 
        a[month].amount += amount ;
    }
    return a;
}, {});

console.log(output);

edited Apr 6, 2020 at 16:31

answered Apr 6, 2020 at 16:18

random

7,9093 gold badges21 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

LearningEveryday Over a year ago

Amount is wrong. The first value gets added twice. This should solve: if(!a[month]) { a[month] = {"month": month, amount} } else { a[month].amount += amount; }

random Over a year ago

@LearningEveryday - Thanks a lot.

Veey Over a year ago

@random Is it possible to return array of objects instead of object of objects ?

random Over a year ago

@Veey - Yes. Use Object.values() on the final result of reduce. i:e Object.values(output).

Collectives™ on Stack Overflow

Create object from JSON response remove unwanted key-values

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related