It’s possible to read and write CSV (Comma Separated Values) files using Python 2.4 Distribution. Like most languages, file operations can be done with Python. This can be done with Python by importing the CSV module and creating a write object that will be used with the WriteRow Method. Reading a CSV file can be done in a similar way by creating a reader object and by using the print method to read the file. As file operations require advanced concepts, some knowledge of programming with Python is required to read and write the CSV.
Python 2.4 supports CSV format.
The Reference Library is very helpful when learning to use Python. Here are some additional tips to get started.
import csv
We will define an object "writer" (called c) which can later be used to write the CSV file:
c = csv.writer(open("MYFILE.csv", "wb"))
Now we will apply the method to write a row. Writerow (method) takes one argument - this argument must be a list and each list item is equivalent to a column. Here, we try to make an address book:
c.writerow(["Name","Address","Telephone","Fax","E-mail","Others"])
cr = csv.reader(open("MYFILE.csv","rb"))
for row in cr: print row
for row in reader: print row[2], row[-2]