Lab 10

Lab 10#

General notebook information

We are going to look at the population count of different community districts over time.

Step 0#

Read the data from the New York City Population By Community Districts data set into a DataFrame called pop_by_cd. To get the URL:

  1. Visit the page linked above.

  2. Click Export.

  3. Right-click CSV.

  4. Click Copy Link Address (or Location, depending on your browser).

# your code here

Step 1#

Prepare the data. Use the following code to reshape the DataFrame to have one row per community district per Census year.

# turn the population columns into rows
populations = pd.melt(
    pop_by_cd,
    id_vars=["Borough", "CD Number", "CD Name"],
    var_name="year",
    value_name="population",
)

# turn the years into numbers
populations.year = populations.year.str.replace(" Population", "").astype(int)

populations

Step 2#

Create a line chart of the population over time for each community district in Manhattan. There should be one line for each.

# your code here

Step 3#

Starting with the same dataset, create a line chart of the population over time for each Borough. There should be one line for each.

# your code here

Step 4#

Submit.

Contents