Reading only specific rows from a CSV file using Python 3

Question

I am learning how to read CSV files using Python 3, and have been playing around with my code and have managed to read either the whole document or certain columns, however I am trying to now read only certain records that contain a certain value.

For example I want to read all records where the car is blue, how would I make it read only those records? I can't figure this out and would be grateful for any help or guidance!

import csv

with open('cars.csv') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row['ID'], row['Make'], row['Colour'])

Possible duplicate of How do I read and write CSV files with Python? — Martin Thoma
– Martin Thoma, Commented Jan 11, 2017 at 7:47

Kevin · Accepted Answer · 2016-01-02 17:56:49Z

33

A simple "if" statement should suffice. See control flow docs.

import csv

with open('Cars.csv') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        if row['Colour'] == 'blue':
            print(row['ID'] ,row ['Make'],row ['Colour'])

answered Jan 2, 2016 at 17:56

Kevin

8,2275 gold badges39 silver badges58 bronze badges

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

Comments

Danny_ds · Accepted Answer · 2016-01-02 17:56:48Z

3

You can check the values while reading the rows.

with open('Cars.csv') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
     // check your values here - if car = blue 
     // do something with blue cars.
     print(row['ID'] ,row ['Make'],row ['Colour'])

answered Jan 2, 2016 at 17:56

Danny_ds

11.4k1 gold badge26 silver badges48 bronze badges

Comments

Csene · Accepted Answer · 2016-01-02 17:53:43Z

-1

You read each row one by one and use an explicit check to filter those that you want to deal with. Then add them to an array for example, or process it in place.

answered Jan 2, 2016 at 17:53

Csene

594 bronze badges

1 Comment

user5508371 Over a year ago

How would I do this?

Collectives™ on Stack Overflow

Reading only specific rows from a CSV file using Python 3

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related