In [1]:

    

%matplotlib inline
#import packages
import matplotlib.pyplot as plt
import numpy as np
import plotly
plotly.tools.set_credentials_file(username='jlwang233', api_key='hBFucEx4GrL7V9xxFhx0')
import plotly.plotly as py
import plotly.graph_objs as go
from plotly.graph_objs import *


    

In [2]:

    

import csv        
fn1 = "amt.csv"
with open(fn1, "r") as f:
    reader1 = csv.reader(f)
    header1 = next(reader1)
    data1 = {}
    for column1 in header1:
        data1[column1] = []
    for row1 in reader1:
        for column1, value1 in zip(header1, row1):
            data1[column1].append(value1)
            
fn2 = "GeoFRED_Total_Gross_Domestic_Product_by_State_Millions_of_Dollars.csv"
with open(fn2, "r") as f:
    reader2 = csv.reader(f)
    header2 = next(reader2)
    data2 = {}
    for column2 in header2:
        data2[column2] = []
    for row2 in reader2:
        for column2, value2 in zip(header2, row2):
            data2[column2].append(value2)


    

In [3]:

    

states =data2['InstState']
AWT1997=data1['1997']
GDP1997=data2['1997']
AWT1998=data1['1998']
GDP1998=data2['1998']
AWT1999=data1['1999']
GDP1999=data2['1999']
AWT2000=data1['2000']
GDP2000=data2['2000']
AWT2001=data1['2001']
GDP2001=data2['2001']
AWT2002=data1['2002']
GDP2002=data2['2002']
AWT2003=data1['2003']
GDP2003=data2['2003']
AWT2004=data1['2004']
GDP2004=data2['2004']
AWT2005=data1['2005']
GDP2005=data2['2005']
AWT2006=data1['2006']
GDP2006=data2['2006']
AWT2007=data1['2007']
GDP2007=data2['2007']
AWT2008=data1['2008']
GDP2008=data2['2008']
AWT2009=data1['2009']
GDP2009=data2['2009']
AWT2010=data1['2010']
GDP2010=data2['2010']
AWT2011=data1['2011']
GDP2011=data2['2011']
AWT2012=data1['2012']
GDP2012=data2['2012']
AWT2013=data1['2013']
GDP2013=data2['2013']


trace11 = go.Scatter(
    x = states,
    y = AWT1997,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace12 = go.Scatter(
    x = states,
    y = GDP1997,
    mode = 'lines+markers',
    name = 'GDP'
)
trace21 = go.Scatter(
    x = states,
    y = AWT1998,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace22 = go.Scatter(
    x = states,
    y = GDP1998,
    mode = 'lines+markers',
    name = 'GDP'
)
trace31 = go.Scatter(
    x = states,
    y = AWT1999,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace32 = go.Scatter(
    x = states,
    y = GDP1999,
    mode = 'lines+markers',
    name = 'GDP'
)
trace41 = go.Scatter(
    x = states,
    y = AWT2000,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace42 = go.Scatter(
    x = states,
    y = GDP2000,
    mode = 'lines+markers',
    name = 'GDP'
)
trace51 = go.Scatter(
    x = states,
    y = AWT2001,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace52 = go.Scatter(
    x = states,
    y = GDP2001,
    mode = 'lines+markers',
    name = 'GDP'
)
trace61 = go.Scatter(
    x = states,
    y = AWT2002,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace62 = go.Scatter(
    x = states,
    y = GDP2002,
    mode = 'lines+markers',
    name = 'GDP'
)
trace71 = go.Scatter(
    x = states,
    y = AWT2003,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace72 = go.Scatter(
    x = states,
    y = GDP2003,
    mode = 'lines+markers',
    name = 'GDP'
)
trace81 = go.Scatter(
    x = states,
    y = AWT2004,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace82 = go.Scatter(
    x = states,
    y = GDP2004,
    mode = 'lines+markers',
    name = 'GDP'
)
trace91 = go.Scatter(
    x = states,
    y = AWT2005,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace92 = go.Scatter(
    x = states,
    y = GDP2005,
    mode = 'lines+markers',
    name = 'GDP'
)
trace101 = go.Scatter(
    x = states,
    y = AWT2006,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace102 = go.Scatter(
    x = states,
    y = GDP2006,
    mode = 'lines+markers',
    name = 'GDP'
)
trace111 = go.Scatter(
    x = states,
    y = AWT2007,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace112 = go.Scatter(
    x = states,
    y = GDP2007,
    mode = 'lines+markers',
    name = 'GDP'
)
trace121 = go.Scatter(
    x = states,
    y = AWT2008,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace122 = go.Scatter(
    x = states,
    y = GDP2008,
    mode = 'lines+markers',
    name = 'GDP'
)
trace131 = go.Scatter(
    x = states,
    y = AWT2009,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace132 = go.Scatter(
    x = states,
    y = GDP2009,
    mode = 'lines+markers',
    name = 'GDP'
)
trace141 = go.Scatter(
    x = states,
    y = AWT2010,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace142 = go.Scatter(
    x = states,
    y = GDP2010,
    mode = 'lines+markers',
    name = 'GDP'
)
trace151 = go.Scatter(
    x = states,
    y = AWT2011,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace152 = go.Scatter(
    x = states,
    y = GDP2011,
    mode = 'lines+markers',
    name = 'GDP'
)
trace161 = go.Scatter(
    x = states,
    y = AWT2012,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace162 = go.Scatter(
    x = states,
    y = GDP2012,
    mode = 'lines+markers',
    name = 'GDP'
)
trace171 = go.Scatter(
    x = states,
    y = AWT2013,
    mode = 'lines+markers',
    name = 'Awarded Amount'
)
trace172 = go.Scatter(
    x = states,
    y = GDP2013,
    mode = 'lines+markers',
    name = 'GDP'
)

mydata = [trace11,trace12,trace21,trace22,trace31,trace32,trace41,trace42,
         trace51,trace52,trace61,trace62,trace71,trace72,trace81,trace82,
         trace91,trace92,trace101,trace102,trace111,trace112,trace121,trace122,
         trace131,trace132,trace141,trace142,trace151,trace152,trace161,trace162,
         trace171,trace172]
layout = Layout(
    title='Total State Amount vs GDP by State Per Year',
    updatemenus=list([
        dict(
            x=-0.05,
            y=1,
            yanchor='top',
            buttons=list([
                dict(
                    args=['visible', [True,True, False, False,False, False, False, False,
                                      False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='1997',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, True,True,False, False, False, False,
                                      False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='1998',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, True,True,False, False,
                                      False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='1999',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,True,True,
                                      False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2000',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      True,True,False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2001',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,True,True,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2002',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, True,True,False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2003',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,True,True,
                                     False, False, False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2004',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      True,True,False, False,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2005',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,True,True,False, False, False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2006',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, True,True,False, False,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2007',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,True,True,
                                     False, False, False, False,False, False, False, False,
                                     False, False]],
                    label='2008',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      True,True,False, False,False, False, False, False,
                                     False, False]],
                    label='2009',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,True,True,False, False, False, False,
                                     False, False]],
                    label='2010',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, True,True,False, False,
                                     False, False]],
                    label='2011',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,True,True,
                                     False, False]],
                    label='2012',
                    method='restyle'
                ),
                dict(
                    args=['visible', [False, False, False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False, 
                                      False, False,False, False, False, False,False, False,
                                      True,True]],
                    label='2013',
                    method='restyle'
                ),
                
            ]),
        )
    ]),
)
fig = Figure(data=mydata, layout=layout)
py.iplot(fig)


    

    
Out[3]: