import vincent
import pandas as pd
from pandas import DataFrame, Series
vincent.core.initialize_notebook()
pd.set_option('display.max_columns', None)

columns = ['Rk','G','Date','Age','Tm','Home/Away','Opp','Win/Lose','GS','MP','FG','FGA','FG%','3P','3PA','3P%','FT','FTA','FT%','ORB','DRB','TRB','AST','STL','BLK','TOV','PF','PTS','GmSc','+/-']
data = pd.read_csv('kevin.csv', names=columns)
#data.head(10)
data[data.Opp =='ATL'].head()

del data['Rk']
del data['Home/Away']
del data['Tm']
del data['Opp']
del data['GS']
del data['Win/Lose']
data.head()

temp = data[['MP', 'FG', 'FGA']]
temp.head()

import time
import datetime

def str_to_minutes(minutes):
    minutes = str(minutes)
    minutes = time.strptime(minutes, '%M:%S')
    return datetime.timedelta(minutes=minutes.tm_min, seconds=minutes.tm_sec).total_seconds()/60
    
    

temp['MP'] = temp['MP'].map(str_to_minutes)

temp.head()

temp['FGA/M'] = temp['FGA'] / temp['MP']
temp['FG/M'] = temp['FG'] / temp['MP']
temp.head()
temp.describe()

data.head()

group_by_opp = data.groupby('Opp')

field_goal_per_team = group_by_opp.sum()[['FGA', 'FG']]

data[data.Opp == 'ATL']

field_goal_per_team
stacked = vincent.StackedBar(field_goal_per_team)
stacked.legend(title="Field Goals")
stacked.scales['x'].padding = 0.1
print stacked.to_json()