Question 1.2. Draw a line plot with years on the horizontal axis and murder rates on the vertical axis. Include two lines: one for Alaska
murder rates and one for Minnesota murder rates. Create this plot using a single call, ak_mn. plot('Year').
Hint: To create two lines, you will need create the table ak_mn with two columns of murder rates, in addition to a column
of years. This table will have the following structure:
Year Murder rate in Alaska Murder rate in Minnesota
1960
10.2
1.2
1961
11.5
1
1962
4.5
0.9
(41 rows omitted)
In [7]: # The next lines are provided for you. They create a table
# containing only the Alaska information and one containing
# only the Minnesota information.
ak = murder_rates. where( 'State', 'Alaska').drop('State', 'Population').relabeled (1, 'Murder
mn = murder_rates. where('State', 'Minnesota').drop('State', 'Population').relabeled (1, 'Murd
# Fill in this line to make a table like the one pictured above.
ak_mn = ak. join("Year", mn, "Year")
ak_mn. plot(Year')