I want to read only first column from csv file. I tried the below code but didn't got the result from available solution.

data = open('data.csv')

reader = csv.reader(data)

interestingrows = [i[1] for i in reader]'

The error I got is:

Traceback (most recent call last):

File "G:/Setups/Python/pnn-3.py", line 12, in

interestingrows = [i[1] for i in reader]

File "G:/Setups/Python/pnn-3.py", line 12, in

interestingrows = [i[1] for i in reader]

IndexError: list index out of range

解决方案

You can also use DictReader to access columns by their header

For example: If you had a file called "stackoverflow.csv" with the headers ("Oopsy", "Daisy", "Rough", and "Tumble")

You could access the first column with this script:

import csv

with open(stackoverflow.csv) as csvFile:

#Works if the file is in the same folder,

# Otherwise include the full path

reader = csv.DictReader(csvFile)

for row in reader:

print(row["Oopsy"])