Monthly Archives: April 2020

JSON to CSV Converter

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’t handle the spatial data I’m working with (almost 1GB/file). And I have multiple of them. Sure, need to add 💵💰 for this for larger files. Then I’ve 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!