def gather_picks():
mocks = pd.read_csv(MOCK_PATH)
drafts = pd.read_csv(DRAFT_PATH)
new = pd.merge(drafts, mocks, left_on='Name', right_on='name', how='left',suffixes=('', '_M'))
new['pick_est'] = new.pick_M.fillna(new.pick)
new['year'] = new.year.fillna(new.year_M).astype('int')
new['from_mock'] = new.year >= 2007
new = drop_unnamed(new.drop(['name','pick', 'pick.1','pick_M', 'year_M', 'age_M'], 1)).sort('year', ascending=False)
new = order(new[DRAFT_ORDER],DRAFT_ORDER)
new.to_csv(DRAFT_MIX_PATH)
return new
def gather_picks():
mocks = pd.read_csv(MOCK_PATH)
drafts = pd.read_csv(DRAFT_PATH)
new = pd.merge(drafts,
mocks,
left_on='Name',
right_on='name',
how='left',
suffixes=('', '_M'))
new['pick_est'] = new.pick_M.fillna(new.pick)
new['year'] = new.year.fillna(new.year_M).astype('int')
new['from_mock'] = new.year >= 2007
new = drop_unnamed(
new.drop(['name', 'pick', 'pick.1', 'pick_M', 'year_M', 'age_M'],
1)).sort('year', ascending=False)
new = order(new[DRAFT_ORDER], DRAFT_ORDER)
new.to_csv(DRAFT_MIX_PATH)
return new
def clean_colpro(colpro):
return order(colpro[column_order], column_order)
def clean_colpro(colpro):
return order(colpro[column_order], column_order)