JavaScript storing JSON in 2D array

Question

I have JSON data that I am trying to store in a 2D array in the format:

[2009-01,324, 1075, 940, 441, 1040, 898, 1343]
[2009-02 295, 958, 904, 434, 1038, 793, 1246 ]

Apologies for the notation visual representation above. I have the JSON data and I am using a for loop to grab the key and its value but im not sure how to store this in a 2d array. I am struggling with this conceptually. Im a beginner and just really want some guidance with this. Thank you.

<script>
$.getJSON('data.json', function (data) {

var response = data;

var listOfTimes = new Array();
for(i = 0; i < 2; i++){ //number of rows...
 for(j = 0; j< 8; j++){ //number of columns

 for(key in response){
 ....not sure what to do here 
 }    
 } 
}

});
</script>

The JSON data is in the format below:

"2009-01": {
    "bbcfour": 324,
    "bbcnews24": 1075,
    "bbcone": 940,
    "bbcthree": 441,
    "bbctwo": 1040,
    "cbbc": 898,
    "cbeebies": 1343
  },
  "2009-02": {
    "bbcfour": 295,
    "bbcnews24": 958,
    "bbcone": 904,
    "bbcthree": 434,
    "bbctwo": 1038,
    "cbbc": 793,
    "cbeebies": 1246
  }

your example of a 2D array isn't a 2D array. It are just 2 arrays. Also your json example isn't a valid json string! — kasper Taeymans
– kasper Taeymans, Commented Feb 22, 2015 at 10:02

Shlomi Komemi · Accepted Answer · 2015-02-22 09:44:28Z

1

try to loop through all the dates & then inner loop on their properties

<script>
    $.getJSON('data.json', function (data) {
        var arr = [];

        for(var date in data){
            var items = [];
            for(var key in date){
                items.push(date[key]);
            }   
            arr.push(items);
        }    

        console.log(arr); // the requested array
    });
</script>

answered Feb 22, 2015 at 9:44

Shlomi Komemi

5,5453 gold badges31 silver badges43 bronze badges

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

Comments

kasper Taeymans · Accepted Answer · 2015-02-22 10:46:05Z

0

jsfiddle demo

var mainobj={
  "2009-01": {
    "bbcfour": 324,
    "bbcnews24": 1075,
    "bbcone": 940,
    "bbcthree": 441,
    "bbctwo": 1040,
    "cbbc": 898,
    "cbeebies": 1343
  },
  "2009-02": {
    "bbcfour": 295,
    "bbcnews24": 958,
    "bbcone": 904,
    "bbcthree": 434,
    "bbctwo": 1038,
    "cbbc": 793,
    "cbeebies": 1246
  }
};

var my2darray=[];

for (var date in mainobj) {
   var temparray=[date];
    for(val in mainobj[date]){
        temparray.push(mainobj[date][val]);
    }
   my2darray.push(temparray);
}
console.log(my2darray);

output:

[["2009-01", 324, 1075, 940, 441, 1040, 898, 1343],
["2009-02", 295, 958, 904, 434, 1038, 793, 1246 ]]

edited Feb 22, 2015 at 10:46

answered Feb 22, 2015 at 10:33

kasper Taeymans

7,0365 gold badges34 silver badges51 bronze badges

1 Comment

user2219097 Over a year ago

thank you so much, this is exactly what I was after. a 2d array to store all the JSON!

john Smith · Accepted Answer · 2015-02-22 09:42:09Z

0

var response = data;

var listOfTimes = new Array();
for(i = 0; i < 2; i++){ //number of rows...
 listOfTimes[i]=response[i];
 for(j = 0; j< 8; j++){ //number of columns
 listOfTimes[i]=repsonse[i][j];   
 } 
}

answered Feb 22, 2015 at 9:42

john Smith

18k12 gold badges80 silver badges124 bronze badges

1 Comment

user2219097 Over a year ago

thank you, im not entirely sure how the code listOfTimes[i]=response[i]; works? And response[i] returns an undefined object

Rofgar · Accepted Answer · 2015-02-22 09:55:03Z

0

I think you are looking for this, it will create an array of arrays based on your map. Not sure why can't you use the array data model. (Watch out for that $.each, it requires jQuery)

var resp =  {"2009-01": {
    "bbcfour": 324,
    "bbcnews24": 1075,
    "bbcone": 940,
    "bbcthree": 441,
    "bbctwo": 1040,
    "cbbc": 898,
    "cbeebies": 1343
  },
  "2009-02": {
    "bbcfour": 295,
    "bbcnews24": 958,
    "bbcone": 904,
    "bbcthree": 434,
    "bbctwo": 1038,
    "cbbc": 793,
    "cbeebies": 1246
  }};

var arrays = [];
for (mainKey in resp) { 
  var array = []; 
  arrays.push(array);  
  array.push(mainKey); 
  $.each(resp[mainKey], function(key, value) { 
    array.push(value) 
  }); 
};

answered Feb 22, 2015 at 9:55

Rofgar

3584 silver badges13 bronze badges

4 Comments

user2219097 Over a year ago

thank you, i think this works. But i dont think the main key is being pushed onto the array too? How would i get the mainKey from the array and the values that belong to it outside the for loop?

Rofgar Over a year ago

All the data stored in the arrays variable. It contains arrays generated from your map input parameter. First item in those arrays are the mainKey = your date.

user2219097 Over a year ago

the problem of this would be difficult access to each element i wanted e.g. i wanted to get the data for 2009-01": { "bbcfour": 324}. I could access the array[0] but in order to get to bbcfour's value?

Rofgar Over a year ago

Well ... For what you are asking for, you don't need to change the map into array. You could just get the item like resp["2009-01"]["bbcfour"].

Collectives™ on Stack Overflow

JavaScript storing JSON in 2D array

4 Answers 4

Comments

1 Comment

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related