PYTHON VS PANDAS

pyversuspandas1.py

def convert_to_bin_places(seq):
    rtn = ""
    if '>' in seq:
        '''remove > '''
        seq = seq.split('>')
    rtn = list(map(lambda x: '1' if x != '' and x == '1' else '0', seq))
    return "".join(rtn)


def convert_to_fs_places(seq):
    rtn = ""
    if '>' in seq:
        '''remove > '''
        seq = seq.split('>')
    rtn = list(map(lambda x: x if x != '' and int(x) <= 6 else '0', seq))
    return "".join(rtn)
    
    
# pandas
results = dictfetchall(cursor)
# list of runners

jsonarray = json.dumps(results,default=outputJSON)
print(jsonarray)
print(len(results))

# next add dates for this period 

alldates_idx = pd.date_range(start=startdate, end=enddate, freq='D') # default is calendar day
print(len(alldates_idx)) # 1242 days so far
res_df = pd.read_json(jsonarray, orient='records', convert_dates=['racedate',], dtype={'finalpos': 'string'})
res_df.set_index('racedatetime', inplace=True)

stats['runseq'] = res_df['finalpos'].str.cat(sep='|')
binary_runseq = res_df['finalpos'].apply(won_or_not).str.cat()
stats['binary_runseq']=binary_runseq