How to output certain element from a row from CSV file, Python

Question

I am using python to parse CSV file but I face an issue how to extract "Davies" element from second row.

CSV looks like this

"_submissionusersID","_submissionresponseID","username","firstname","lastname","userid","phone","emailaddress","load_date"
"b838b35d-ca18-4c7c-874a-828298ae3345","e9cde2ff-33a7-477e-b3b9-12ceb0d214e0","DAVIESJO","John","Davies","16293","","[email protected]","2019-08-30 15:37:03"
"00ec3205-6fcb-4d6d-b806-25579b49911a","e9cde2ff-11a7-477e-b3b9-12ceb0d934e0","MORANJO","John","Moran","16972","+1 (425) 7404555","[email protected]","2019-08-30 15:37:03"
"cc44e6bb-af76-4165-8839-433ed8cf6036","e9cde2ff-33a7-477e-b3b9-12ceb0d934e0","TESTNAN","Nancy","Test","75791","+1 (412) 7402344","[email protected]","2019-08-30 15:37:03"
"a8ecd4db-6c8d-453c-a2a7-032553e2f0e6","e9cde2ff-33a7-477e-b3b9-12ceb0d234e0","SMITHJO","John","Smith","197448","+1 (415) 5940445","[email protected]","2019-08-30 15:37:03"

I'm stuck here:

with open('Docs/CSV/submis/submis.csv') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    for row in csv_reader:

Similar query is already answered here. stackoverflow.com/questions/37240535/… — Shreyas J
– Shreyas J, Commented Sep 12, 2019 at 7:04
yes it prints all names, but how to print only one name from a specific row? — JohnPix
– JohnPix, Commented Sep 12, 2019 at 7:04

Sundeep · Accepted Answer · 2019-09-12 07:19:14Z

1

You are absolutely correct with the code and each and every row is returned as a Dict so you need to parse the Dict and obtain the required results you want to, as shown below.

import csv
with open('/home/liferay172/Documents/Sundeep/stackoverflow/text.csv') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    for row in csv_reader:
        print(row)
        print("Username :: "+row['username'])
        print("Firstname :: "+row['firstname'])
        print("Lastname :: "+row['lastname'])

For a specific row

import csv
rowNumber = 1
with open('/home/liferay172/Documents/Sundeep/stackoverflow/text.csv') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    print(list(csv_reader)[rowNumber-1]['lastname']) # -1 as the index starts from 0

Returns > Davies

edited Sep 12, 2019 at 7:19

answered Sep 12, 2019 at 7:01

Sundeep

2,5053 gold badges23 silver badges48 bronze badges

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

Comments

Pitto · Accepted Answer · 2019-09-12 07:26:02Z

1

Here's how to put, for example, "Davies" record in result variable and also print its data if found.

import csv
with open('/home/liferay172/Documents/Sundeep/stackoverflow/text.csv') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    for row in csv_reader:
        if (row['username'] == "Davies"):
            match = row
            print("Username:\t" + row['username'])
            print("Firstname:\t" + row['firstname'])
            print("Lastname:\t" + row['lastname'])
            break
print(match)

edited Sep 12, 2019 at 7:26

answered Sep 12, 2019 at 7:16

Pitto

8,6993 gold badges51 silver badges54 bronze badges

Comments

Sundeep · Accepted Answer · 2019-09-12 07:56:03Z

1

You can convert the CSV reader object to a list and then it can be accessed by index.

import csv
with open('Docs/CSV/submis/submis.csv') as csv_file:
    csv_reader = list(csv.reader(csv_file))
    # 2nd row
    print(csv_reader[1])
    # 2nd row 3rd column
    print(csv_reader[1][2])

edited Sep 12, 2019 at 7:56

Sundeep

2,5053 gold badges23 silver badges48 bronze badges

answered Sep 12, 2019 at 7:12

Nitin_k29

3511 gold badge3 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to output certain element from a row from CSV file, Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related