下面是我正在工作的数据框。我想使用“国家”和“部门”列中的值替换“分数”列中的 NaN 值
Country Sectors Score
0 USA MECH NaN
1 IND ELEC 10.0
2 USA CHEM NaN
3 RUS ENT 34.0
4 PAK MATH 45.0
5 SL LAN 23.0
6 USA CHEM 56.0
7 IND ELEC 32.0
8 USA CHEM NaN
9 RUS ENT 45.0
10 PAK MATH 45.0
下面是我试过的代码
import pandas as pd
import numpy as np
df = pd.read_csv('../Data/Data.csv')
df['Score'] = df[(df['Country'] == 'USA') & (df['Sectors'] == 'CHEM') & (df['Score'].isnull())]['Score'].fillna(10)
print(df)
```but I am getting below result```
Country Sectors Score
0 USA MECH NaN
1 IND ELEC NaN
2 USA CHEM 10.0
3 RUS ENT NaN
4 PAK MATH NaN
5 SL LAN NaN
6 USA CHEM NaN
7 IND ELEC NaN
8 USA CHEM 10.0
9 RUS ENT NaN
10 PAK MATH NaN
我只想替换特定于 country == 'USA' 和 Sectors == 'CHEM' 的 NaN 值,并保持所有值不变。有人可以帮忙吗?```
您可以使用np.where
:
>>> df = pd.DataFrame({'Country':['USA', 'IND','USA'], 'Sectors':['MECH', 'ELEC','CHEM'], 'Score':[45.0, 30.0, np.NaN]})
>>> df["Score"] = np.where((df["Country"]=='USA') & (df['Sectors'] == 'CHEM'), 10, df["Score"])
>>> df
Country Sectors Score
0 USA MECH 45.0
1 IND ELEC 30.0
2 USA CHEM 10.0
如果df["Country"]=='USA'
和df['Sectors'] == 'CHEM'
,df['Score']
则设置为10
,否则设置为的原始值df['Score']
。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句