How to convert object containing Objects into array of arrays?

Question

How can I transform this data structure:

const data = {
            0: {
                campaign_lead_id: 2,
                date: "2017-11-11T22:19:33.538000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            },
            1: {
                campaign_lead_id: 1,
                date: "2017-11-09T20:43:26.953000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            }
        }

to array of arrays, where first array contains key names, and other arrays contain key values, like this:

const CSVdata = [ 
            ['campaign_lead_id', 'date', 'campaign_name', 'influencer_name', 'influencer_email'],
            ['2', '2017-11-11T22:19:33.538000+00:00', 'IOT course fall 2017', null, '[email protected]'],
            ['1', '2017-11-09T20:43:26.953000+00:00', 'IOT course fall 2017', null, '[email protected]']
        ];

I've tried to do it with forEach and map methods, but unsuccessfully — Roman Shevchenko
– Roman Shevchenko, Commented Feb 12, 2018 at 18:49
Nothing to share, I just tried to use those methods, but I don't think that they can help me in this particular case — Roman Shevchenko
– Roman Shevchenko, Commented Feb 12, 2018 at 19:07

amar_1995 · Accepted Answer · 2018-02-12 19:20:53Z

Below is the code I think you might looking for.
Pass object to the makeArray function it will return the required array.

const data = {
            0: {
                campaign_lead_id: 2,
                date: "2017-11-11T22:19:33.538000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            },
            1: {
                campaign_lead_id: 1,
                date: "2017-11-09T20:43:26.953000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            }
        };
function makeArray(data){
var initialKeys = Object.keys(data);
var answer = [Object.keys(data[initialKeys[0]])];
      for(let i=0;i<initialKeys.length;i++) {
      answer.push(Object.values(data[i]));
}
return answer;
}
const CSVdata = makeArray(data);
console.log(CSVdata);

Note : Only valid for object of objects.

Harun Diluka Heshan · Accepted Answer · 2018-02-12 18:51:34Z

0

User this code snippet: Object.keys() function return an array containing names of the keys of the object. Object.values() return an array of values of the object.

var arraysOfarray = [
    Object.keys(data[0]),
    Object.values(data[0])
];

console.log(arraysOfarray);

answered Feb 12, 2018 at 18:51

Harun Diluka Heshan

1,2463 gold badges19 silver badges30 bronze badges

2 Comments

Roman Shevchenko Over a year ago

Thank you, but I need to build arrays of values dynamically, I mean instead of Object.values(data[0]) I need somehow to loop through all object of data

Harun Diluka Heshan Over a year ago

Yea, i show you key areas of the solution. can't you do it by your self because once you know main areas, it so much simple.

Ele · Accepted Answer · 2018-02-12 18:56:15Z

As you said: Using forEach

Get the keys using Object.keys method.
For each iteration use Object.values function.

const data = {
  '0': {
    campaign_lead_id: 2,
    date: "2017-11-11T22:19:33.538000+00:00",
    campaign_name: "IOT course fall 2017",
    influencer_name: null,
    influencer_email: "test_user_1@key"
  },
  '1': {
    campaign_lead_id: 1,
    date: "2017-11-09T20:43:26.953000+00:00",
    campaign_name: "IOT course fall 2017",
    influencer_name: null,
    influencer_email: "test_user_1@key"
  }
};

var array = [['campaign_lead_id', 'date', 'campaign_name', 'influencer_name', 'influencer_email']];
Object.keys(data).forEach((k) => array.push(Object.values(data[k])));

console.log(array);

.as-console-wrapper {
  max-height: 100% !important
}

Resources

baao · Accepted Answer · 2018-02-12 19:18:58Z

Just use reduce like below

const data = {
  0: {
    campaign_lead_id: 2,
    date: "2017-11-11T22:19:33.538000+00:00",
    campaign_name: "IOT course fall 2017",
    influencer_name: null,
    influencer_email: "test_user_1@key"
  },
  1: {
    campaign_lead_id: 1,
    date: "2017-11-09T20:43:26.953000+00:00",
    campaign_name: "IOT course fall 2017",
    influencer_name: null,
    influencer_email: "test_user_1@key"
  }
}

let arr = Object.keys(data).sort().reduce((a, b) => {
  a.push(Object.values(data[b]));
  return a;
}, [Object.keys(data[0])]);

console.log(arr);

Radu Luncasu · Accepted Answer · 2018-02-12 19:19:25Z

const data = {
    0: {
        campaign_lead_id: 2,
        date: "2017-11-11T22:19:33.538000+00:00",
        campaign_name: "IOT course fall 2017",
        influencer_name: null,
        influencer_email: "test_user_1@key"
    },
    1: {
        campaign_lead_id: 1,
        date: "2017-11-09T20:43:26.953000+00:00",
        campaign_name: "IOT course fall 2017",
        influencer_name: null,
        influencer_email: "test_user_1@key"
    }
}

const csvData = (data) => {
    const docs = Object.values(data);
    return [Object.keys(docs[0])].concat(docs.map(d => Object.values(d)))
};

console.log(csvData(data));

score 0 · Accepted Answer · 2018-02-12 22:08:06Z

I find papa parse quite helpful for this sort of thing. If you can restructure your data so that it's a list of objects within an array (notice how i use [ rather than { to create the const data ), then I think it can be done with a single line of code:

const data = [
             {
                campaign_lead_id: 2,
                date: "2017-11-11T22:19:33.538000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            },
            {
                campaign_lead_id: 1,
                date: "2017-11-09T20:43:26.953000+00:00",
                campaign_name: "IOT course fall 2017",
                influencer_name: null,
                influencer_email: "test_user_1@key"
            }
        ]
        
var new_data = Papa.parse(Papa.unparse(data,{header:true}))["data"];

console.dir(new_data);

<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/4.3.7/papaparse.min.js"></script>

Kirill Simonov · Accepted Answer · 2018-02-13 05:05:51Z

Try this example. It will work even if properties are in different order.

const data = {
    0: {
        campaign_lead_id: 2,
        date: "2017-11-11T22:19:33.538000+00:00",
        campaign_name: "IOT course fall 2017",
        influencer_name: null,
        influencer_email: "test_user_1@key"
    },
    1: {
        date: "2017-11-09T20:43:26.953000+00:00",
        campaign_name: "IOT course fall 2017",
        campaign_lead_id: 1,
        influencer_name: null,
        influencer_email: "test_user_1@key"
    }
};

let csv = Object.values(data).reduce((acc, cur) => {
    acc.push(acc[0].map(title => cur[title]));
    return acc;
}, [Object.keys(data[0])]);

console.log(csv);

Collectives™ on Stack Overflow

How to convert object containing Objects into array of arrays?

7 Answers 7

Comments

2 Comments

Resources

Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

2 Comments

Resources

Comments

Comments

Comments

Comments

Comments

Related