Modern Python Standard Library Cookbook

Reading and writing CSV

CSV is considered one of the best exchange formats for tabular data; nearly all spreadsheet tools support reading and writing CSV, and it's easy to edit it with any plain text editor as it's easy for humans to understand.

Just split and set the values with a comma and you have practically written a CSV document.

Python has very good built-in support for reading CSV files, and we can easily write or read CSV data through the csv module.

We will see how it's possible to read and write a table:

"ID","Name","Surname","Language"
1,"Alessandro","Molina","Italian"
2,"Mika","Häkkinen","Suomi"
3,"Sebastian","Vettel","Deutsch"