我需要按多个列分组&然后在一个新列中获得包含添加的If条件的求和。我尝试了下一段代码,它在按单列分组时效果很好:
df['new column'] = (
df['value'].where(df['value'] > 0).groupby(df['column1']).transform('sum')
)但是,当我尝试按多个列分组时,会出现一个错误。
df['new_column'] = (
df['value'].where(df['value'] > 0).groupby(df['column1', 'column2']).transform('sum')
)错误:
->return self._engine.get_loc(casted_key)
The above exception was the direct cause of the following exception:
->indexer = self.columns.get_loc(key)
->raise KeyError(key) from err
->if is_scalar(key) and isna(key) and not self.hasnans: ('column1', 'column2')您能建议我如何更改代码以获得相同的结果,但按多列分组吗?
谢谢
发布于 2022-05-15 08:08:09
错误原因
df['column1', 'column2']是错误的。这应该是df[['column1', 'column2']]df[['column1', 'column2']]做groupby,熊猫会引起另一个错误,抱怨石斑鱼应该是one dimensional。这是因为df[['column1', 'column2']]返回一个数据帧,这是一个二维对象.如何修正错误?
艰难的道路:
将每个分组列作为一维系列传递给groupby
df['new_column'] = (
df['value']
.where(df['value'] > 0)
.groupby([df['column1'], df['column2']]) # Notice the change
.transform('sum')
)简单的方法:
首先将蒙面列值分配给目标列,然后按照通常的做法执行groupby + transform
df['new_column'] = df['value'].where(df['value'] > 0)
df['new_column'] = df.groupby(['column1', 'column2'])['new_column'].transform('sum')https://stackoverflow.com/questions/72246392
复制相似问题