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"
Let's see the steps for this recipe:
- First of all, we will see how to write the specified table:
import csv with open('/tmp/table.csv', 'w', encoding='utf-8') as f: writer = csv.writer(f, quoting=csv.QUOTE_NONNUMERIC) writer.writerow(("ID","Name","Surname","Language")) writer.writerow((1,"Alessandro","Molina","Italian")) writer...