Python reading specific csv column into list

Question

I have a csv file with 3 columns. I'd like to read the file and put column number 2 into a list.

I currently have it reading the file and putting all three columns as tuples into a list:

    import csv


    with open ('list.csv', 'rb') as f:
           reader = csv.reader(f)
           the_list = map(tuple, reader)


    print the_list

output = [('1', 'bob', '23'), ('2', 'jane', '21')]

whereas I want the output list to be [('bob'), ('jane')] and I'm uncertain of how to do it. Thanks

Avinash Raj · Accepted Answer · 2015-11-16 11:13:12Z

1

Use list comprehension.

reader = csv.reader(f)
print [i[1] for i in reader]

answered Nov 16, 2015 at 11:13

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

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

Comments

pfnuesel · Accepted Answer · 2017-01-19 13:46:00Z

0

import csv

with open('jjon.csv', 'rU') as infile:

    reader = csv.reader(infile)
    print [i[0] for i in reader]

edited Jan 19, 2017 at 13:46

pfnuesel

15.5k14 gold badges63 silver badges74 bronze badges

answered Jan 19, 2017 at 13:38

Annie

212 bronze badges

Collectives™ on Stack Overflow

Python reading specific csv column into list

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related