javascript - Nested JSON to CSV format Node.js -


i new programming , working on project received nested json response api using node.js. hoping find simple method convert json csv export. have searched around bit have tried jsonexport , nestedcsv2json packages, have not been able format quite right , unable iterate though json response.

basically json response follows:

{ '2016-01-31': { chats: 0, missed_chats: 5 }, '2016-02-01': { chats: 60, missed_chats: 7 }, '2016-02-02': { chats: 56, missed_chats: 1 }, '2016-02-03': { chats: 46, missed_chats: 0 }, '2016-02-04': { chats: 63, missed_chats: 2 }, '2016-02-05': { chats: 59, missed_chats: 4 }, '2016-02-06': { chats: 0, missed_chats: 1 } }

the issue having size of can vary depending on date range user enters. need iterate through returned dates , extract nested json. 1 date or 100 dates.

i looking make csv format headers can export:

   date         chats    missed chats 2016-02-02        60            7

this should quick , easy, struggling quite right. tips or appreciated. thanks!

this outputs semicolon separated csv-string. edit separator (for example replace tab \t) suit needs:

var json = { '2016-01-31': { chats: 0, missed_chats: 5 }, '2016-02-01': { chats: 60, missed_chats: 7 }, '2016-02-02': { chats: 56, missed_chats: 1 }, '2016-02-03': { chats: 46, missed_chats: 0 }, '2016-02-04': { chats: 63, missed_chats: 2 }, '2016-02-05': { chats: 59, missed_chats: 4 }, '2016-02-06': { chats: 0, missed_chats: 1 } };  var headers = 'date;chats;missed chats';  var csv = headers + '\r\n'; for(key in json){     csv += key + ';' + json[key].chats + ';' + json[key].missed_chats + '\r\n' } console.log(csv)

the output is:

date;chats;missed chats 2016-01-31;0;5 2016-02-01;60;7 2016-02-02;56;1 2016-02-03;46;0 2016-02-04;63;2 2016-02-05;59;4 2016-02-06;0;1

you can find working example here: https://jsfiddle.net/owd8zsa0/


Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

Swift game error message -

i following ios game tutorial. cannot figure out wrong here. error on these 2 lines. let newangle = percent * 180 - 180 cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi); 180.0 //error "use of unresolved identifier 'percent'" the tutorial uses: cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi)/ 180.0 but changed error suggested import spritekit class gamescene: skscene { var cannon: skspritenode! var touchlocation:cgpoint = cgpointzero override func didmovetoview(view: skview) { /* setup scene here */ cannon = self.childnodewithname("cannon") as! skspritenode } override func touchesbegan(touches: set<uitouch>, withevent event: uievent?) { /* called when touch begins */ touchlocation = touches.first!.locationinnode(self) } override func touchesmoved(touches: set<uitouch>, withevent event: uievent?) { touchlocation = touches.first!.locationinn...
Read more