{"id":1414,"date":"2020-04-19T11:41:55","date_gmt":"2020-04-19T03:41:55","guid":{"rendered":"https:\/\/people.utm.my\/mduznir\/?p=1414"},"modified":"2020-04-19T11:41:55","modified_gmt":"2020-04-19T03:41:55","slug":"json-to-csv-converter","status":"publish","type":"post","link":"https:\/\/people.utm.my\/mduznir\/2020\/04\/19\/json-to-csv-converter\/","title":{"rendered":"JSON to CSV Converter"},"content":{"rendered":"<p class=\"p1\"><span class=\"s1\">While doing my spatial data mining, I stumbled upon this situation where I need to translate my JavaScript Object Notation files (JSON) to another format, which in my case is Comma Separated Values format (CSV). Trying to find online converters, but somehow most of the converters are limited like file size should be less than 1MB or 100MB maximum, which definitely can\u2019t handle the spatial data I\u2019m working with (almost 1GB\/file). And I have multiple of them. Sure, need to add <\/span><span class=\"s2\">&#x1f4b5;&#x1f4b0;<\/span><span class=\"s1\"> for this for larger files. Then I\u2019ve decided to write this 10 lines Python code to read, filter, format and convert and store it to CSV file. This video (series of images instead) shows how it goes and voila!<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1408\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330-1024x809.jpeg\" alt=\"\" width=\"584\" height=\"461\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330-1024x809.jpeg 1024w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330-300x237.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330-768x607.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330-380x300.jpeg 380w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/A9C32C41-C2FD-40BF-A11C-C34B526F5330.jpeg 1125w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1409\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331-1024x839.jpeg\" alt=\"\" width=\"584\" height=\"478\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331-1024x839.jpeg 1024w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331-300x246.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331-768x629.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331-366x300.jpeg 366w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F7AF2550-3EA7-4D1B-8D63-66A953EEA331.jpeg 1125w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1410\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/BA53D847-C6A2-4707-AD40-D303E12B956E.jpeg\" alt=\"\" width=\"1003\" height=\"840\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/BA53D847-C6A2-4707-AD40-D303E12B956E.jpeg 1003w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/BA53D847-C6A2-4707-AD40-D303E12B956E-300x251.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/BA53D847-C6A2-4707-AD40-D303E12B956E-768x643.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/BA53D847-C6A2-4707-AD40-D303E12B956E-358x300.jpeg 358w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1411\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C-1024x813.jpeg\" alt=\"\" width=\"584\" height=\"464\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C-1024x813.jpeg 1024w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C-300x238.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C-768x610.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C-378x300.jpeg 378w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/FBE1DE1E-C299-48BC-9963-1A52F579165C.jpeg 1091w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1412\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2-1024x806.jpeg\" alt=\"\" width=\"584\" height=\"460\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2-1024x806.jpeg 1024w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2-300x236.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2-768x604.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2-381x300.jpeg 381w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/F5213B8F-F281-4541-98FD-FCBBB3566EC2.jpeg 1125w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1413\" src=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608-1024x805.jpeg\" alt=\"\" width=\"584\" height=\"459\" srcset=\"https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608-1024x805.jpeg 1024w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608-300x236.jpeg 300w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608-768x603.jpeg 768w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608-382x300.jpeg 382w, https:\/\/people.utm.my\/mduznir\/wp-content\/uploads\/sites\/881\/2020\/04\/65537A21-0704-4902-BC53-FEE52C5A7608.jpeg 1125w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While doing my spatial data mining, I stumbled upon this situation where I need to translate my JavaScript Object Notation files (JSON) to another format, which in my case is Comma Separated Values format (CSV). Trying to find online converters, but somehow most of the converters are limited like file size should be less than [&hellip;]<\/p>\n","protected":false},"author":6924,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,5],"tags":[],"class_list":["post-1414","post","type-post","status-publish","format-standard","hentry","category-research","category-teaching"],"_links":{"self":[{"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/posts\/1414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/users\/6924"}],"replies":[{"embeddable":true,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/comments?post=1414"}],"version-history":[{"count":1,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/posts\/1414\/revisions"}],"predecessor-version":[{"id":1415,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/posts\/1414\/revisions\/1415"}],"wp:attachment":[{"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/media?parent=1414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/categories?post=1414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.utm.my\/mduznir\/wp-json\/wp\/v2\/tags?post=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}