lab11 Download #Census Data into #Python

Objectives:
• To learn how to download data from real data resources
• To learn how to compare data in #JSON format

Data:
• Collect data from Census at https://www.census.gov/data/developers/data-sets/acs-1year.html
Steps:
1. Start the Jupyter Notebook instance in SageMaker. In JupyterLab, update the local repository.
2. Create a new notebook, name it lab11.
3. Create your Census API Key from https://api.census.gov/data/key_signup.html
4. Based on this code (https://github.com/xbwei/Data-Mining-on-Social-Media/blob/master/Census/Collect_Census_Data ), design your codes to collect population from VA, and find out:
4.1. The county that has the most total population (B01001_001E). Use string format to report the county name and the total population.
4.2. The county that has the most male population (B01001_002E). Use string format to report the county name and the male population.
4.3. The county that has the highest male population/total population ratio. Use string format to report the county name and the ratio.
• Hint: understand the Census variables from https://api.census.gov/data/2016/acs/acs1/variables.html
5. Close your Notebook, open the JupyterLab. In JupyterLab, upload your Notebook to your GitHub
6. Check your Notebook on GitHub.
7. Stop the Notebook instance after you submitted your lab on Canvas.