Comp 151 Project 5

Description:

write a program that will count all of the institutions of higher education in each US state, then display these as a choropleth map of the US.

Use this US government generated file of higher ed institutions: CollegeData.xlsx 

First go look at the data and understand what you have - a decent sized 6000 row excel file.

Be aware: this file will take about 2 minutes to open and read in. If your program appears to hang, give it a couple of minutes.

Lets assume this data is reasonable, it often lists multiple campuses of the same institution as separate rows. To make life easier, we'll go with the assumption that each campus/row is its own institution.

then count up how many institutions are in each state, and map those onto a US map.

state_names_Pandas = pandas.Series(state_names)
change_in_income_Pandas = pandas.Series(change_in_income)

data = [dict(
    type='choropleth',
    colorscale="BlueRed",
    autocolorscale=False,
    locations=state_names_Pandas,
    z=change_in_income_Pandas,
    locationmode='USA-states',
     colorbar=dict(
         title="Median Income Change in Dollars")
)]

layout = dict(
    title='Change in median income for each state',
    geo=dict(
        scope='usa',
        projection=dict(type='albers usa'),
        showlakes=True,)
)
fig = dict(data=data, layout=layout)
plotly.offline.plot(fig, filename='comp151-map.html')