Aggregate data using Javascript or Underscore

Question

I have a raw data like this:

{
    "Team1": [
        {
            "priority": "P0",
            "status": "Open",
            "teamName": "Team1"
        },
        {
            "priority": "P1",
            "status": "Closed",
            "teamName": "Team1"
        },
        {
            "priority": "P0",
            "status": "Closed",
            "teamName": "Team1"
        }
    ],
    "Team2": [
        {
            "priority": "P1",
            "status": "Open",
            "teamName": "Team2"
        }
    ]
}

I would like to transform the data as follows:

{
    "Team1": {
        "teamName": "Team1",
        "Open": {
            "P0": 1,
            "P1": 0
        },
        "Closed": {
            "P0": 1,
            "P1": 1
        }
    },
    "Team2": {
        "teamName": "Team2",
        "Open": {
            "P0": 0,
            "P1": 1
        },
        "Closed": {
            "P0": 0,
            "P1": 1
        }
    }
}

I'm trying with Underscore.js, but not very successful since I'm novice in this.

I am till here:

_.groupBy(data, function(element) {
    element.teamName + '#' + element.status
});

But I'm clueless on how to proceed.

This isn't a code writing service. Show what you tried so people can help fix code you wrote — charlietfl
– charlietfl, Commented Sep 20, 2016 at 13:46
Have you tried anything already? I would say the easiest way would be to simply loop through the original structure, and build the new structure from that. It shouldn't be to hard for you to give it a go. — DBS
– DBS, Commented Sep 20, 2016 at 13:46
@charlietfl: Thanks for the advise. I accept SO is not a code writing service, at least, it will help me to learn something new. I've learnt lot from SO and gave back to the community as far as I can. This is something which I don't even know how to proceed, that is why I'm here. I'm here to find a way. IMHO. — Vimalraj Selvam
– Vimalraj Selvam, Commented Sep 20, 2016 at 14:00
@DBS: Yes, if I don't find any way to perform this using Underscore, then I'm only left with that option. — Vimalraj Selvam
– Vimalraj Selvam, Commented Sep 20, 2016 at 14:02

Nina Scholz · Accepted Answer · 2016-09-20 14:02:57Z

1

You could first iterate the object's keys and the arrays and get the included properties and then the same for the count.

var data = { "Team1": [{ "priority": "P0", "status": "Open" }, { "priority": "P1", "status": "Closed" }, { "priority": "P0", "status": "Closed" }], "Team2": [{ "priority": "P1", "status": "Open" }] },
    keys = Object.keys(data),
    priorities = new Set(),
    grouped = {};

keys.map(k => data[k].forEach(a => priorities.add(a.priority)));

keys.map(k => {
    grouped[k] = grouped[k] || {};
    data[k].forEach(a => {
        grouped[k][a.status] = grouped[k][a.status] || [...priorities].reduce((r, b) => (r[b] = 0, r), {});
        grouped[k][a.status][a.priority]++;
    });
});

console.log(grouped);

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

answered Sep 20, 2016 at 14:02

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

Collectives™ on Stack Overflow

Aggregate data using Javascript or Underscore

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related