Python - Reading Specific column from csv file

Question

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 <module>
         interestingrows = [i[1] for i in reader]
    File "G:/Setups/Python/pnn-3.py", line 12, in <listcomp>
         interestingrows = [i[1] for i in reader]
IndexError: list index out of range

i[1] will give you the second column not the first. You should try i[0] — Kasravnd
– Kasravnd, Commented Apr 22, 2017 at 6:03

Nuageux · Accepted Answer · 2017-07-03 10:55:00Z

3

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"])

edited Jul 3, 2017 at 10:55

Nuageux

1,6861 gold badge18 silver badges29 bronze badges

answered Jul 3, 2017 at 9:39

kosherdiah

338 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

kosherdiah Over a year ago

Apologies, I'm new to all this. I've added code, how's it looking?

Nuageux Over a year ago

Try to be careful with the indentation as it won't work if it is not indented well. (I fix it with edit)

Nuageux Over a year ago

Useful tip: In question or answer (but not comment), select your code (in text or outside of it) and press Ctrl+K

kosherdiah Over a year ago

I just had a try, that makes it so much easier to copy code from notepad onto the site! Thanks!

Kasravnd · Accepted Answer · 2017-04-22 06:06:46Z

0

If you want the first item from an indexable iterable you should use 0 as the index. But in this case you can simply use zip() in order to get an iterator of columns and since the csv.reader returns an iterator you can use next() to get the first column.

with open('data.csv') as data:
    reader = csv.reader(data)
    first_column  = next(zip(*reader))

answered Apr 22, 2017 at 6:06

Kasravnd

108k19 gold badges167 silver badges195 bronze badges

Collectives™ on Stack Overflow

Python - Reading Specific column from csv file

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related