Download (right-click, save target as ...) this page as a jupyterlab notebook from: Lab11

---

Laboratory 11: Dataframes (Continued)

LAST NAME, FIRST NAME

R00000000

ENGR 1330 Laboratory 11 - In-Lab

Preamble script block to identify host, user, and kernel

import sys
! hostname
! whoami
print(sys.executable)
print(sys.version)
print(sys.version_info)

---

Exercise 1: Population Lines

Use pandas to read a dataframe from the file http://54.243.252.9/engr-1330-webroot/4-Databases/census_18.csv.
Then produce a line plot of the counts by age for the 2010 census, x-axis will be the series age, y-axis will be the census values for 2010.

# get the file (using requests, or just download to your computer by hand)
import requests # Module to process http/https requests
#
remote_url="http://54.243.252.9/engr-1330-webroot/4-Databases/census_18.csv"  # set the url
rget = requests.get(remote_url, allow_redirects=True)  # get the remote resource, follow imbedded links
#
junk = open('census_18.csv','wb').write(rget.content) # extract from the remote the contents, assign to a local file same name

# read the file into a dataframe
import pandas as pd
df = pd.read_csv('census_18.csv')
df.head() # Examine dataframe layout

# plotting calls here
df.plot.line(x="", y="", label="", c="")# Make a plot fill in the parameters

---

Exercise 2:

Using your dataframe from above, plot both the 2010 and 2014 census values by age. Plot the 2010 distribution in blue and the 2014 distribution in red.

ax = df.plot.line(x="", y="", label="", c="blue") # fill in the parameters
df.plot.line(x="", y="", label="", c="red", ax=ax)

Exercise 3.

1. What is population for age = 9 for the 2010 census?
2. What is population for age = 9 for the 2014 census?
3. Is the portion of population over 9 years old increasing? decreasing? staying the same?

# use pandas/numpy functions to answer questions