键错误('%s不在索引'%objarr[mask]中)

2024-06-16 19:21:24 发布

您现在位置:Python中文网/ 问答频道 /正文

正在修复一个数据帧-这是错误所在

def group_analytics(df):
    """
    *prints various stats to the console for a dataframe created in the 
    'group_trips' function*
    """
df_fp = df[['freeplay_redeemed','cash_in', 'actual_win', 'theo_win']]

df_fp['cash_to_fp'] = df_fp['cash_in'].astype(float) / df_fp['freeplay_redeemed'].astype(float) 
df_fp['w_above_fp'] = df_fp['actual_win'].astype(float) - df_fp['freeplay_redeemed'].astype(float) 
df_fp['tw_above_fp'] = df_fp['theo_win'].astype(float) - df_fp['freeplay_redeemed'].astype(float) 
df_fp = df_fp.replace([np.inf, -np.inf], np.nan).dropna()
df_fp['amt_above_fp'] = df_fp[['w_above_fp', 'tw_above_fp']].max(axis=1)

print('\nCash in :',df_fp['cash_in'].astype(float).sum())
print ('\n# trips: ', df_fp['freeplay_redeemed'].count())
print ('\nActual Win: ', df_fp['actual_win'].sum())
print ('\nTheo Win: ', df_fp['theo_win'].sum())
print ('\nFreePlay Redeemed: ', df_fp['freeplay_redeemed'].sum())
print ('\nCash to Freeplay Stats \n')
print(df_fp['cash_to_fp'].describe(percentiles=[.1,.2,.3,.4,.5,.6,.7,.8,.9]))
print ('\nAmount Above Freeplay Stats \n')
print(df_fp['amt_above_fp'].describe(percentiles=[.1,.2,.3,.4,.5,.6,.7,.8,.9]))

这里是关键错误:

^{pr2}$

Tags: toindfcashfloattheowinabove