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