你好,我有一个数据框,如下所示,我需要替换每个组中的列值,基于使用Pandas 的条件.请帮帮忙
输入数据:
Name Thing type flag
Steve Car High NULL
Steve Car Low NULL
Steve Bike Low NULL
Steve Bike Avg X
Steve Plane High NULL
Steve Plane Low NULL
条件是:
1. for a given name and thing if type is Low,Avg update the flag as X
2. for a given name and thing if type is High,Avg update the flag as X
预期输出:
Name Thing type flag
Steve Car High NULL
Steve Car Low NULL
Steve Bike Low X
Steve Bike Avg X
Steve Plane High NULL
Steve Plane Low NULL
到目前为止已try :
df['flag'] = df['flag'].mask((df['type'] == 'Low') | (df['type'] == 'Avg'), 'X').groupby(df(['name','thing'])).transform('any')