Activity 6.01 – Series data selection
In this activity, you will read some US population data for large cities for the years 2010 and 2019 and analyze it. The goal is to determine the population growth for the top three cities compared to all the top 20 from 2010 to 2019. To do this, you must compute the population of the three largest cities for 2010 and 2019, as well as the population of the 20 largest cities for both years. Using these values, you can compute the growth rates and compare them.
Follow these steps to complete this activity:
- For this activity, all you will need is the
pandaslibrary. Load it into the first cell of the notebook. - Read in a pandas Series from the
US_Census_SUB-IP-EST2019-ANNRNK_top_20_2010.csvfile. This data is from the US Census Bureau (source: https://www2.census.gov/programs-surveys/popest/datasets/2010/2010-eval-estimates/). The city names are in the first column, so read them so that they are used as the indexes. List the resulting...
