如何清理此数据类型对象并将其转换为float类型

Question

                             Hight
0                       
1               1,82 m (6 ft 0 in)
2        1,74 m (5 ft 9 in) metres
3               1,88 m (6 ft 2 in)
4                              NaN
5       1,80 m (5 ft 11 in) metres

如何将列High转换为数据类型float，并保持NaN值

                             Hight
0                              NaN
1                             1.82 
2                             1.74
3                             1.88
4                              NaN
5                             1.80

Answer 1

mask与inplace=True

df['column'].mask(df['column'].eq(0), inplace=True)

---

np.where

a = df['column'].to_numpy()
df['column'] = np.where(a, a, np.nan)

Answer 2

您可以使用：

 df.loc[df['column'] == 0.0, 'column'] = np.nan