1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Databases in Python

Exercise

Filter data selected from a Table - Simple

Having connected to the database, it's now time to practice filtering your queries!

As mentioned in the video, a where() clause is used to filter the data that a statement returns. For example, to select all the records from the census table where the sex is Female (or 'F') we would do the following:

select([census]).where(census.columns.sex == 'F')

In addition to == we can use basically any python comparison operator (such as <=, !=, etc) in the where() clause.

Instructions

100 XP
  • Select all records from the census table by passing in census as a list to select().
  • Append a where clause to stmt to return only the records with a state of 'New York'.
  • Execute the statement stmt using .execute() on connection and retrieve the results using .fetchall().
  • Iterate over results and print the age, sex and pop2000 columns from each record. For example, you can print out the age of result with result.age.