json to key value array

Question

I have some json data, that looks like :

[{
"key": "Jan",
  "value": "400"
}, {
  "key": "Apr",
  "value": "500"
}, {
  "key": "Aug",
  "value": "24058.635"
}, {
  "key": "Sep",
  "value": "2160"
}, {
  "key": "Nov",
  "value": "115425"
}, {
  "key": "Dec",
  "value": "32570"
}]

I need to convert this to a key value pair array that should be like

[
  [Jan, 400],
  [Apr, 500],
  [Aug, 24058.635],
  [Sep, 2160],
  [Nov, 115425],
  [Dec, 32570]
]

Somebody please help me with Jquery or Javascript code to do this conversion.

Basically an exact duplicate of How to use jQuery.map() on array of objects to return array of arrays, but jQuery is weird. — Felix Kling
– Felix Kling, Commented Dec 14, 2016 at 7:20
You should definitely read Access / process (nested) objects, arrays or JSON — Felix Kling
– Felix Kling, Commented Dec 14, 2016 at 7:35

Suren Srapyan · Accepted Answer · 2016-12-14 07:15:14Z

3

You can use map() function to iterate on them and return an array you want.

let json =  [{"key":"Jan","value":"400"},{"key":"Apr","value":"500"},{"key":"Aug","value":"24058.635"},{"key":"Sep","value":"2160"},{"key":"Nov","value":"115425"},{"key":"Dec","value":"32570"}];

let obj = json.map(item => [item['key'], item['value']]);

console.log(obj);

answered Dec 14, 2016 at 7:15

Suren Srapyan

68.9k14 gold badges128 silver badges119 bronze badges

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

7 Comments

AJIN Over a year ago

console is showing json.map is not a function(…)

Suren Srapyan Over a year ago

@AJIN, What look does your json obj has? In my case it is an array. If you have it like a string, then do let json = JSON.parse(yourString) and after that use map function

AJIN Over a year ago

I am processing the response from an ajax method.

AJIN Over a year ago

after parsing output is showing like [Array[2], Array[2], Array[2], Array[2], Array[2], Array[2]]

Suren Srapyan Over a year ago

Create a fiddle and show your code.Or for first make sure you get the json object as mine

|

Sreekanth · Accepted Answer · 2016-12-14 07:20:52Z

1

You could do something like this.

var input = [{
  "key": "Jan",
  "value": "400"
}, {
  "key": "Apr",
  "value": "500"
}, {
  "key": "Aug",
  "value": "24058.635"
}, {
  "key": "Sep",
  "value": "2160"
}, {
  "key": "Nov",
  "value": "115425"
}, {
  "key": "Dec",
  "value": "32570"
}];

var output = input.map(function(obj) {
  return [obj.key, obj.value]
});
console.log(output);

answered Dec 14, 2016 at 7:20

Sreekanth

3,13014 silver badges22 bronze badges

4 Comments

AJIN Over a year ago

output is showing as [Array[2], Array[2], Array[2], Array[2], Array[2], Array[2]]

Sreekanth Over a year ago

if you would like to display it, you could use JSON.stringify(output).

Sreekanth Over a year ago

If you need to access, you should use output[someIndex][0] for Key and output[someIndex][1] for Value

AJIN Over a year ago

i am not accessing the data at any index. I am passing this output on to a function where a graph will be generated with this data.

Mahi · Accepted Answer · 2016-12-14 07:21:04Z

1

with forEach method .

var a= [{"key":"Jan","value":"400"},{"key":"Apr","value":"500"},{"key":"Aug","value":"24058.635"},{"key":"Sep","value":"2160"},{"key":"Nov","value":"115425"},{"key":"Dec","value":"32570"}];
var ans=[];
a.forEach(function(a){
ans.push([a["key"],a["value"]]);
})
console.log(ans);

with map method .

var a= [{"key":"Jan","value":"400"},{"key":"Apr","value":"500"},{"key":"Aug","value":"24058.635"},{"key":"Sep","value":"2160"},{"key":"Nov","value":"115425"},{"key":"Dec","value":"32570"}];

var ans=a.map(function(a){
return [a["key"],a["value"]];
})
console.log(ans);

edited Dec 14, 2016 at 7:21

answered Dec 14, 2016 at 7:18

Mahi

1,72513 silver badges22 bronze badges

2 Comments

AJIN Over a year ago

both methods are showing output as : [Array[2], Array[2], Array[2], Array[2], Array[2], Array[2]]

Mahi Over a year ago

@AJIN JSON.stringify(output) only to show output as string . but keep output as it it . output is correct.

Rohìt Jíndal · Accepted Answer · 2016-12-14 17:04:25Z

Using Array map() method :

var jsonObj = [{
"key": "Jan",
  "value": "400"
}, {
  "key": "Apr",
  "value": "500"
}, {
  "key": "Aug",
  "value": "24058.635"
}, {
  "key": "Sep",
  "value": "2160"
}, {
  "key": "Nov",
  "value": "115425"
}, {
  "key": "Dec",
  "value": "32570"
}];

var newArr = jsonObj.map(function(item) {
  return [item['key'],item['value']];
});

console.log(newArr);

Using JavaScript for...in loop :

var jsonObj = [{
"key": "Jan",
  "value": "400"
}, {
  "key": "Apr",
  "value": "500"
}, {
  "key": "Aug",
  "value": "24058.635"
}, {
  "key": "Sep",
  "value": "2160"
}, {
  "key": "Nov",
  "value": "115425"
}, {
  "key": "Dec",
  "value": "32570"
}];

var newArr = [];
for (var i in jsonObj) {
  newArr.push([jsonObj[i].key,jsonObj[i].value]);
}

console.log(newArr);

Collectives™ on Stack Overflow

json to key value array

4 Answers 4

7 Comments

4 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

4 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related