Converting Data Into An Array Of Arrays

Question

I currently have data returning in the format from the backend of an application done in PHP (Laravel):

data [
   {
     "Jan": 120,
     "Feb": 283.5,
     "Mar": 10,
     "Apr": 233.92,
     "May": 327.78,
     "Jun": 190.74,
     "Jul": 10,
     "Aug": 10,
     "Sep": 10,
     "Oct": 10,
     "Nov": 10,
     "Dec": 10
   }
]

I want to then graph this data, which is the average order values of a specific company by month, in the front-end using JavaScript (Vue). Though for it to work it needs to be in the format:

new_data [
  ["Jan", 120],
  ["Feb", 283.5],
  ["Mar", 10],
  ["Apr", 233.92],
  ["May", 327.78],
  ["Jun", 190.74],
  ["Jul", 10],
  ["Aug", 10],
  ["Sep", 10],
  ["Oct", 10],
  ["Nov", 10],
  ["Dec", 10]
]

I have seen how to do this for similar things on Stack Overflow (i.e. Object to Array (an array of arrays)) but none fit this exact example.

Ori Drori · Accepted Answer · 2018-04-03 09:08:44Z

6

Array.map() to Object.entries() and flatten by spreading into Array.concat():

const data = [{"Jan":120,"Feb":283.5,"Mar":10,"Apr":233.92,"May":327.78,"Jun":190.74,"Jul":10,"Aug":10,"Sep":10,"Oct":10,"Nov":10,"Dec":10}]

const result = [].concat(...data.map(Object.entries))

console.log(result)

answered Apr 3, 2018 at 9:08

Ori Drori

196k32 gold badges243 silver badges233 bronze badges

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

3 Comments

Alex Over a year ago

He isn't asking for a flattened structure? So I guess data.map(Object.entries) will do? Still a valid enough answer if you ask me, so upvoted.

Ori Drori Over a year ago

Indeed. However, in the question the result is flattened as it doesn't contain a subarray wrapping the items.

Alex Over a year ago

Oh right, I missed that. So he actually is asking for a flattened structure.

Jayanth · Accepted Answer · 2018-04-03 09:47:29Z

0

Classic way to do this is:

var data = [
   {
     "Jan": 120,
     "Feb": 283.5,
     "Mar": 10,
     "Apr": 233.92,
     "May": 327.78,
     "Jun": 190.74,
     "Jul": 10,
     "Aug": 10,
     "Sep": 10,
     "Oct": 10,
     "Nov": 10,
     "Dec": 10
   }
];
var dataArry = new Array();
for(month in data[0]){
  dataArry[dataArry.length] = [month,data[0][month]];
}

In the above code, dataArry hold the object data in a Array format.

answered Apr 3, 2018 at 9:47

Jayanth

8269 silver badges18 bronze badges

Comments

Marvin K · Accepted Answer · 2018-04-03 12:40:00Z

0

Since you get an object and not an array from the backend, I find no other solution than looping over the propertys of the object and push the values in a new array. Would look like this:

var newData = [];
Object.keys(data[0]).forEach(function(month) {
    newData.push[month, data[0][month]];
});

edited Apr 3, 2018 at 12:40

answered Apr 3, 2018 at 9:11

Marvin K

3441 gold badge3 silver badges16 bronze badges

2 Comments

Jayanth Over a year ago

I guess Object.keys(data[0]) works instead of Object.keys(data). Not sure though.

Marvin K Over a year ago

For this case you're right. Updated. The solution from Ori Drori is a little bit more elegant

Collectives™ on Stack Overflow

Converting Data Into An Array Of Arrays

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related