You don’t want to have to SCP the file to your desktop, load the file, save it in the requisite format, and then SCP the file back to the server. You want to be efficient. Hence, csvkit.

A script might, for example, automate the creation of EC2 VM instances, and look to a JSON file to provide information such as the instance name, the guest OS, and the instance size. It's also worth ...

The file will be saved using the JSON Canvas extension '.canvas'. When you open it in a text editor, you can see that it has been saved in JSON Canvas format, as shown below.

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.