python - 数据列值未更改为 float

Question

我有一个数据框，

df,
    Name    Stage   Description
0   sri      1      sri is one of the good singer in this two
1   nan      2      thanks for reading
2   ram      1      ram is two of the good cricket player
3   ganesh   1      one driver
4   nan      2      good buddies

tried df["Stage"]=pd.to_numeric(df["Stage"],downcast="float")

但值仍然相同

Answer 1

我想你需要astype :

df["Stage"]=df["Stage"].astype(float)

如果第一个解决方案因为某些非数字数据而失败，请使用 to_numeric使用参数 errors='coerce' 将错误数据替换为 NaNs，因此输出为 float :

df["Stage"]=pd.to_numeric(df["Stage"],errors="coerce")