晚上好
是否可以简单地将特定列中的所有空单元格(空字符串,而不是nan)替换为给定的字符串或整数?
假设…
我添加了一个NaN来演示它的工作原理:
df
name age
0 john doe 27.0
1 jane doe 29.0
2 marianne mustermann
3 max mustermann 23.0
4 jean dupont
5 final NaN
df['age'] = df['age'].replace('',0)
df
name age
0 john doe 27.0
1 jane doe 29.0
2 marianne mustermann 0.0
3 max mustermann 23.0
4 jean dupont 0.0
5 final NaN
df.dropna()
name age
0 john doe 27.0
1 jane doe 29.0
2 marianne mustermann 0.0
3 max mustermann 23.0
4 jean dupont 0.0