Example #1
0
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
Example #2
0
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
Example #3
0
def clean_colpro(colpro):
    return order(colpro[column_order], column_order)
Example #4
0
def clean_colpro(colpro):
    return order(colpro[column_order], column_order)