Changing JSON Structure in Javascript/Jquery

Question

I have an object coming from the server via JSON which is in the below format. I want to rearrange it to another format.

{
    visits: [{
        week: 1,
        count: 3
    }, {
        week: 2,
        count: 3
    }, {
        week: 3,
        count: 4
    }, {
        week: 4,
        count: 3
    }, {
        week: 5,
        count: 1
    }],
    visitors: [{
        week: 1,
        count: 3
    }, {
        week: 2,
        count: 3
    }, {
        week: 3,
        count: 4
    }, {
        week: 4,
        count: 3
    }, {
        week: 5,
        count: 1
    }]
}

I want to change its structure and want this format below:

{
    week1: {
        visits: 3
        visitors: 1
    }
    week2: {
        visits: 3
        visitors: 3
    }
    week3: {
        visits: 4
        visitors: 4
    }
    week4: {
        visits: 3
        visitors: 3
    }
    week5: {
        visits: 4
        visitors: 4
    }
}

That's not JSON, and even if you get the data as JSON, it's irrelevant for the problem. — Felix Kling
– Felix Kling, Commented Sep 10, 2016 at 14:50

Bartłomiej Gładys · Accepted Answer · 2016-09-10 14:49:10Z

1

try this:

var newObj = {}

$.each(a.visits, function(key,obj){ newObj['week'+obj.week] ={visits: obj.count} });

$.each(a.visitors, function(key,obj){ newObj['week'+obj.week].visitors = obj.count});

answered Sep 10, 2016 at 14:49

Bartłomiej Gładys

4,6151 gold badge17 silver badges25 bronze badges

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

Comments

Abdennour TOUMI · Accepted Answer · 2016-09-10 14:42:30Z

0

so use groupBy feature :

var groupBy=function(jsonArray,key) {
      return jsonArray.reduce(function(rv, x) {
        (rv[x[key]] = rv[x[key]] || []).push(x);
        return rv;
      }, {});
   };

Then :

var groupedByWeeks=groupBy(yourJsonArray.visits,'week')

then map the object 1->week1, .. n->weekn

Object.keys(groupedByWeeks).map((k)=>
     groupedByWeeks['week'+k]=groupedByWeeks[k];
)

answered Sep 10, 2016 at 14:42

Abdennour TOUMI

94.5k42 gold badges271 silver badges274 bronze badges

Collectives™ on Stack Overflow

Changing JSON Structure in Javascript/Jquery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related