imp.reload(header)
import utils
imp.reload(utils)
members_name = '../data/2016/Membership/2016-09-06 Members Hudson Mohawk Road Runners Club.csv'
race_name = '../data/2016/Stockade/stockade2.csv'
race_out_base = '../data/2016/Stockade/stockade_scored'
race_out_name = race_out_base + '.csv'
race_out_males = race_out_base + '_males.csv'
race_out_females = race_out_base + '_females.csv'
members = pd.read_csv(members_name)
members["age"] = members['Birthdate (e.g., 01 Jun 1954)'].apply(
lambda x: utils.datestring_to_age(x))
members["gender"] = members['Gender'].apply(lambda x: utils.parse_gender(x))
print(members.head())
racers = readers.parse_general(pd.read_csv(race_name),
header.RaceHeader.headers, 1)
#racers=pd.read_csv(race_name)
print(racers.head())
matchmember.match(members, racers, 4.5, 5.5)
print(racers.head())
hmrrc = racers[racers['member'] == 'yes']
hmrrc = hmrrc[['place', 'first_name', 'last_name', 'gender', 'age']]
import header #reload(header) import utils reload(utils) members_name='../data/2020/Membership/2020-05-03 Members Hudson Mohawk Road Runners Club.csv' race_name='../data/2020/3_ROTG/rotg.csv' race_out_base='../data/2020/3_ROTG/' race_out_name=race_out_base+'ROTG.csv' race_out_males=race_out_base+'ROTG_males.csv' race_out_females=race_out_base+'ROTG_females.csv' members=pd.read_csv(members_name) members["age"]=members['Birthdate (e.g., 01 Jun 1954)'].apply(lambda x:utils.datestring_to_age(x)) members["gender"]=members['Gender'].apply(lambda x:utils.parse_gender(x)) print (members.head()) racers=readers.parse_general(pd.read_csv(race_name), header.RaceHeader.headers, 1) #racers=readers.parse_general(pd.read_csv(race_name), header.RaceHeader.headers, 1) racers.gender=racers.gender.str.strip() print (racers.head()) #matchmember.match(members, racers, 4.5, 5.5) #print (racers.head()) #hmrrc=racers[racers['member']=='yes'] #hmrrc=hmrrc[['place', 'mfname','mlname','gender','age']] hmrrc=racers