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

Answer 1

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

Answer 2

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