search

bigdatahci2015 / forum

0 stars 4 forks source link

Converting JSON to Tableau ready (on OSX) #19

Open karisantos opened 9 years ago

karisantos commented 9 years ago

Hello - I've spent almost an hour looking around the web for how to convert the JSON file to something Tableau can use. This seems quite challenging to me, especially on a Mac. I am considering Apache Drill, but could use a hint or some reassurance. I see conflicting info on what works on Tableau Desktop for Mac - I think Tableau Data Extract API does not. And I'm not sure if Tableau ODBC works on Mac.

Anyone care to share a couple hints or useful sites? Anyone do this on a Mac yet?

Thanks, Kari

zhya215 commented 9 years ago

Google 'convert json into csv' You will find what you want.

bdmckean commented 9 years ago

Hi Kari, I have a Mac and adapted a python script that I found on the web for converting JSON to CSV. -Brian

-----Original Message----- From: karisantos notifications@github.com To: bigdatahci2015/forum forum@noreply.github.com Sent: Sun, Sep 20, 2015 2:03 pm Subject: [forum] Converting JSON to Tableau ready (on OSX) (#19)

Hello - I've spent almost an hour looking around the web for how to convert the JSON file to something Tableau can use. This seems quite challenging to me, especially on a Mac. I am considering Apache Drill, but could use a hint or some reassurance. I see conflicting info on what works on Tableau Desktop for Mac - I think Tableau Data Extract API does not. And I'm not sure if Tableau ODBC works on Mac.

Anyone care to share a couple hints or useful sites? Anyone do this on a Mac yet?

Thanks, Kari

— Reply to this email directly or view it on GitHub.

karisantos commented 9 years ago

Thanks for all the help. I tried https://www.npmjs.com/package/json-2-csv , which works, except it doesn't handle the Instructors array, leaving it just Object. Has anyone found a converter that can handle the "Instructors" array?

TheDataLeek commented 9 years ago

I just finished a custom python program that converts the json structure into a sqlite relational database. @doubleshow , am I allowed to post this?

doubleshow commented 9 years ago

yes. you are allowed to post the script. thanks. but please don't share the resulting output as your classmates who choose to use your script need to figure out how to run the script as a part of the learning exercise.

TheDataLeek commented 9 years ago

Here is my script.

https://gist.github.com/willzfarmer/f185c25c872a221cc3ca