How to change the structure of my json object using Javascript

Question

I have a json object which stores all the vehicle models with their brand. 

[{
"brand":"Audi","model":"A4"
},
{
"brand":"Audi","model":"A6"
},
{
"brand":"BMW","model":"Z4"
},
{
"brand":"Audi","model":"R8"
},
{
"brand":"Volvo","model":"v40"
},
{
"brand":"BMW","model":"5 Series"
}]

But the problem is , If I have 3 models for Audi, then the list is repeating the brand again and again thus filling my list with duplicate values. So I need to make a json object something like this: I just want to make a json object as follows using javascript or angularjs:

 [ {"brand":"Audi","models":["A4","A6","R8"]},
    {"brand":"BMW","models":["Z4","5 Series"]},
    {"brand":"Volvo","models":["v40"]}]

you could do groupBy on brand, refer this answer stackoverflow.com/a/24879563/2435473 — Pankaj Parkar
– Pankaj Parkar, Commented Oct 12, 2015 at 8:51
@PankajParkar I don't need to group it in UI side, I want to store it in another variable using code. — J.Joseph
– J.Joseph, Commented Oct 12, 2015 at 8:53
a correction on your terminology. You have an object - nothing to do with JSON — Jaromanda X
– Jaromanda X, Commented Oct 12, 2015 at 8:54
looking again, if that's a files contents, then, yes, it is JSON — Jaromanda X
– Jaromanda X, Commented Oct 12, 2015 at 9:00

jahller · Accepted Answer · 2015-10-12 11:02:44Z

1

you can make the JSON easily using both angular js or javascript. You can use following method in angular js . In javascript just use same type of loop like 'for'.

var model = {};
var brandList = [];
var returnObject = [];

var data = [
  {
    "brand": "Audi", "model": "A4"
  },
  {
    "brand": "Audi", "model": "A6"
  },
  {
    "brand": "BMW", "model": "Z4"
  },
  {
    "brand": "Audi", "model": "R8"
  },
  {
    "brand": "Volvo", "model": "v40"
  },
  {
    "brand": "BMW", "model": "5 Series"
  }
]

angular.forEach(data, function (dat, index) {
  if (brandList.indexOf(dat.brand) == -1) {
    brandList.push(dat.brand);
    model[dat.brand] = [];
    model[dat.brand].push(dat.model);
  } else {
    model[dat.brand].push(dat.model);
  }
});

angular.forEach(brandList, function (val, index) {
  var obj = {};
  obj.brand = val;
  obj.models = model[val];
  returnObject.push(obj);
});

Now returnObject will hold your desired JSON object.

edited Oct 12, 2015 at 11:02

jahller

2,9911 gold badge30 silver badges30 bronze badges

answered Oct 12, 2015 at 9:06

Manij Rai - ITH

592 bronze badges

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

6 Comments

Jaromanda X Over a year ago

Are you sure about that? - your code results in returnObject with only the last model for each brand

Jaromanda X Over a year ago

you need to swap model[dat.brand].push(dat.model); and model[dat.brand] = [dat.model];

Jaromanda X Over a year ago

You're also want to declare var brandList = [], model = {}, returnObject = []; - I think that's all the extra variables you use.

Jaromanda X Over a year ago

yeah, we all make mistakes

J.Joseph Over a year ago

@ManijRai-ITH I got this result [{"brand":"Audi","models":["R8"]},{"brand":"BMW","models":["5 Series"]},{"brand":"Volvo","models":["v40"]}]

|

Jaromanda X · Accepted Answer · 2015-10-12 09:49:01Z

1

Given your input:

var input = [{
    "brand": "Audi",
    "model": "A4"
}, {
    "brand": "Audi",
    "model": "A6"
}, {
    "brand": "BMW",
    "model": "Z4"
}, {
    "brand": "Audi",
    "model": "R8"
}, {
    "brand": "Volvo",
    "model": "v40"
}, {
    "brand": "BMW",
    "model": "5 Series"
}];

you can achieve your desired result using Array.reduce -

var output = input.reduce(function(work, datum) {
    var n = work.brands.indexOf(datum.brand);
    if (n < 0) {
        n = work.brands.push(datum.brand) - 1;
        work.result.push({brand: datum.brand, models: []});
    }
    work.result[n].models.push(datum.model);
    return work;
}, {brands:[], result:[]}).result;

edited Oct 12, 2015 at 9:49

answered Oct 12, 2015 at 8:59

Jaromanda X

57.1k6 gold badges82 silver badges96 bronze badges

4 Comments

fast Over a year ago

Wouldn't this result in an object instead of a array, as requested by the OP?!

Jaromanda X Over a year ago

indeed, well spotted :D

J.Joseph Over a year ago

I am getting this result: {"Audi":{"brand":"Audi","models":["A4","A6","R8"]},"BMW":{"brand":"BMW","models":["Z4","5 Series"]},"Volvo":{"brand":"Volvo","models":["v40"]}}. Can you please help me to make it in the format which I mentioned

Jaromanda X Over a year ago

I know other answers are easier to read - but alternatives can sometimes teach :p

fast · Accepted Answer · 2015-10-12 09:29:03Z

0

var input = [{
    "brand": "Audi",
    "model": "A4"
}, {
    "brand": "Audi",
    "model": "A6"
}, {
    "brand": "BMW",
    "model": "Z4"
}, {
    "brand": "Audi",
    "model": "R8"
}, {
    "brand": "Volvo",
    "model": "v40"
}, {
    "brand": "BMW",
    "model": "5 Series"
}];

// collect all brands models in a map
var brands_models = {};
for(var i=0; i < input.length; i++) {
 var dat = input[i];
 brands_models[dat.brand] = brands_models[dat.brand] || [];
 brands_models[dat.brand].push(dat.model);
}

// make array from map
var output = [];
foreach(var brand in brands_models) {
 output.push({
    "brand" : brand,
    "models": brands_models[brand]
  });
}

answered Oct 12, 2015 at 9:29

fast

8857 silver badges15 bronze badges

Comments

Nina Scholz · Accepted Answer · 2015-10-12 09:38:47Z

0

A proposal with only Array.prototype.forEach and Array.prototype.some.

var data = [{
        "brand": "Audi", "model": "A4"
    }, {
        "brand": "Audi", "model": "A6"
    }, {
        "brand": "BMW", "model": "Z4"
    }, {
        "brand": "Audi", "model": "R8"
    }, {
        "brand": "Volvo", "model": "v40"
    }, {
        "brand": "BMW", "model": "5 Series"
    }],
    combined = [];

data.forEach(function (a) {
    !combined.some(function (b) {
        if (a.brand === b.brand) {
            !~b.model.indexOf(a.model) && b.model.push(a.model);
            return true;
        }
    }) && combined.push({ brand: a.brand, model: [a.model] });
})
document.write('<pre>' + JSON.stringify(combined, 0, 4) + '</pre>');

edited Oct 12, 2015 at 9:38

answered Oct 12, 2015 at 9:30

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

Sherali Turdiyev · Accepted Answer · 2015-10-12 10:21:33Z

I suggest another optimum way:

var arr = [
    {
        "brand": "Audi", "model": "A4"
    },
    {
        "brand": "Audi", "model": "A6"
    },
    {
        "brand": "BMW", "model": "Z4"
    },
    {
        "brand": "Audi", "model": "R8"
    },
    {
        "brand": "Volvo", "model": "v40"
    },
    {
        "brand": "BMW", "model": "5 Series"
    }
];
var copy = arr.slice(0);
var res = [];
while (copy.length) {//it  stop when copy is empty
    var a = {models: []};//create object
    var item = copy.shift();//item = copy[0], then copy[0] has deleted
    a.brand = item.brand;//current brand
    a.models.push(item.model);//first model has added

    copy.forEach(function (e, i) {
        if (e.brand === a.brand) {//find other items which they equal current brand
            a.models.push(e.model);//another models have added to models
            copy.splice(i, 1);//copy[i] has deleted
        }
    });
    res.push(a);//current brand item has added
}
console.log(res);

Collectives™ on Stack Overflow

How to change the structure of my json object using Javascript

5 Answers 5

6 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related