1. Learn
    2. /
  2. Courses
    3. /
  3. Streamlined Data Ingestion with pandas

Exercise

Load entire tables

In the last exercise, you saw that data.db has two tables. weather has historical weather data for New York City. hpd311calls is a subset of call records made to the city's 311 help line about housing issues.

In this exercise, you'll use the read_sql() function in pandas to load both tables. read_sql() accepts a string of either a SQL query to run, or a table to load. It also needs a way to connect to the database, like the engine in the provided code.

Instructions 1/2

undefined XP
  • 1

    Use read_sql() to load the hpd311calls table by name, without any SQL.

  • 2

    Use read_sql() and a SELECT * ... SQL query to load the entire weather table.