I'm trying to get a python script working to convert my csv file to the correct json format. I'm not a programmer...but I am lazy.

And there you have it: now you know how to open CSV files in Python! And with that, you’ve dabbled in your first bit of JSON development and even a bit of data science.

Geary made a Python script that processes election data and converts it JSON. A Ruby script is then used to upload the JSON files to an Amazon S3 storage space.

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.