Print only second row

Question

I have CSV File named as names.csv:

F_Name | L_Name
Sashi  | Thakur
Rup    | Chand
Nirmal | Kumar

Trying to print only L_Name:

import csv
with open('names.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        #print(row['first_name'], row['last_name'])
        print(row[1])

Gave me:

KeyError: 2

Thankyou

@your question title is misleading if you wanted to just print second row remove for loop and do `next(reader) #skip first row` `print(next(reader))#print 2nd row` but clearly this not what you wanted to do — Tanmay jain, Sep 01 '18 at 13:31
Possible duplicate of https://stackoverflow.com/questions/43555819/python-reading-specific-column-from-csv-file — Proteeti Prova, Sep 01 '18 at 13:40

Tanmay jain · Accepted Answer · 2018-09-01T13:37:07.397

1

As per your latest comment you want to print last name which are in second column(index 1)

If fieldnames are not present then you should not use DictReader as it will take whatever in first row as key

import csv
with open('cs.csv', newline='') as csvfile:
reader = csv.reader(csvfile)
for row in reader:
    print(row[1])


#--------------------------------------------------
# fieldnames are present

import csv
with open('cs.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    #print(reader.fieldnames) 
    look_for = reader.fieldnames[1] #since L_name is at index 1
    for row in reader:
        print(row[look_for])

'''
csv file contents
F_Name,L_Name
Sherlock,Holmes
Bruce,Wayne

OrderedDict([('F_Name', 'Sherlock'), ('L_Name', 'Holmes')])
Holmes
OrderedDict([('F_Name', 'Bruce'), ('L_Name', 'Wayne')])
Wayne

['F_Name', 'L_Name']
Holmes
Wayne
'''

edited Sep 01 '18 at 13:37

answered Sep 01 '18 at 13:16

Tanmay jain

814
6
11

What if heading is not given? – Grass Sep 01 '18 at 13:20
@Grass updated the answer if key name is not known but position is – Tanmay jain Sep 01 '18 at 13:26
And what if fieldnames are also not there...? – Grass Sep 01 '18 at 13:31
@Grass so you want to print second column ? – Tanmay jain Sep 01 '18 at 13:32
I'll be thankfull if you could help me at https://stackoverflow.com/questions/52121506 – Grass Sep 01 '18 at 13:49
Any updates @TanmayJain with the above question link? – Grass Sep 05 '18 at 11:26
@Grass I have not work with selenium, so I am sorry can't help you with that question. – Tanmay jain Sep 05 '18 at 15:30

score 0 · Answer 2 · answered Sep 01 '18 at 13:10

0

Indices start at 0! So to get the the second column you have to access row[1]

answered Sep 01 '18 at 13:10

Michael K.

2,392
4
22
35

score 0 · Answer 3 · answered Sep 01 '18 at 15:47

You can user the argument fieldnames to give columns key names, then print each column by the key name.

import csv with open('names.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile, fieldnames=['fname', 'lname'])
    for row in reader:
        print(row['lname'])

reference: https://docs.python.org/2/library/csv.html

Print only second row

3 Answers3