top of page

Reading a .csv file with Python's csv module

Here's a follow-up to the Tip of the Night for February 2, 2019, which explained how to read comma separated values in a text file. Python includes a .csv module which can be used to read a file with the .csv extension saved from Excel.

To activate the module enter this line:

>>> import csv

open the file and designate it with a name >>> with open ("C:\FooFolder\Python\cities.csv", newline="") as f:

. . . then specify the delimiter for the .csv file r = csv.reader(f, delimiter=",")

. . . finally display the contents in a delimited list: for row in r: print(row)

['Chicago', 'New York', 'Los Angeles', 'Houston'] ['Springfield', 'Buffalo', 'San Francisco', 'Austin'] ['Joliet', 'Albany', 'San Diego', 'El Paso'] >>>

The csv module has multiple functions and can also be used to write data to .csv files.

bottom of page