from plotly.tools import embed
from IPython.display import VimeoVideo, HTML

from glue import qglue
import pandas as pd

states = pd.read_csv('state_crime.csv')
qglue(states=states)

VimeoVideo('97436621', width=700)

embed('ChrisBeaumont', 36)

embed('ChrisBeaumont', 37)

embed('ChrisBeaumont', 38)

embed('ChrisBeaumont', 39)

embed('ChrisBeaumont', 40)

murder_change = (states.sort('Year')
                 .groupby('State').Murder
                 .agg({'first':'first', 'last':'last'}))
murder_change['change'] = murder_change['last'] - murder_change['first']
murder_change = murder_change.sort('change', ascending=False)

print 'Largest Increases in Murder Rate (change per 100,000)'
murder_change.head(10)

#This makes everything pretty

def css_styling():
    styles = open('custom.css', 'r').read()
    return HTML(styles)
css_styling()