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?](http://stackoverflow.com/questions/41585078/how-do-i-read-and-write-csv-files-with-python) — Martin Thoma, Jan 11 '17 at 07:47

score 33 · Accepted Answer · answered Jan 02 '16 at 17:56

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

score 3 · Answer 2 · answered Jan 02 '16 at 17:56

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

score -1 · Answer 3 · answered Jan 02 '16 at 17:53

-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 02 '16 at 17:53

Csene

69
4

1

How would I do this? – user5508371 Jan 02 '16 at 17:55

Reading only specific rows from a CSV file using Python 3

3 Answers3

Linked