我有一个名为的数据框'df_main'
,其中的行数随着用户每次导入 csv 而变化。无论行数如何,“沙龙总数”行和列'Paid_BB_Percent'
将始终存在。我想从中复制数据df_main.loc['salon totals', 'Paid_BB_Percent]
并在数据框的末尾创建一个新列,称为'Store_BB_Percent'
该列中的每个单元格都包含此数据的副本。
这个想法是我将有另一个数据框,其中将包含一行df_manager = df_main[df_main['Employee'].str.contains(manager_name)]
,用于通过用户输入查找特定的管理器行,然后将添加一个新列,如下所示:df_manager['Manager_BB_Bonus'] = (df_manager['Service_Sales'] - df_manager['Service_Breakpoint']) * (df_manager['Store_BB_Percent']).round(2)
另一种更好的方法df_main.iloc['salon totals', 'Paid_BB_Percent']
是df_manager['Manager_Service_Diff']
像这样乘以:
df_manager['Manager_BB_Bonus'] = (df_main.loc['salon totals', 'Paid_BB_Percent'] * df_manager['Manager_Service_Diff'])
这个问题是当我运行时:
df_manager = df_main[df_main['Employee'].str.contains(manager_name)] df_manager['Service_Breakpoint'] = 1700 df_manager['Manager_Service_Diff'] = (df_manager['Service_Sales'] - df_manager['Service_Breakpoint']) df_manager['Manager_BB_Bonus'] = (df_main.loc['salon totals', 'Paid_BB_Percent'] * df_manager['Manager_Service_Diff']) df_manager
我收到错误消息:“KeyError:'标签 [沙龙总数] 不在 [索引] 中”
任何帮助表示赞赏。
如果您尝试将三个系列相乘。假设您正在尝试乘以第一个值
df_main['salon totals'][0]* df_main['Paid_BB_Percent'][0]* df_main['Manager_Service_Diff'][0]
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句