python - 替换 Pandas 细胞中的一个字符

Question

我有以下数据框:

df = pd.DataFrame(columns=["a","b","c"])
df.loc[1] = [1,2,3]
df.loc[2] = ["123.12", "3455,435",0]
df.loc[3] = [23.2, 55.5,0.1]
df.loc[4] = ["1,3","3,5","7.8"]

我想将所有逗号 (",") 替换为点 (".")，结果如下所示:

df = pd.DataFrame(columns=["a","b","c"])
df.loc[1] = [1,2,3]
df.loc[2] = ["123.12", "3455.435",0]
df.loc[3] = [23.2, 55.5,0.1]
df.loc[4] = ["1.3","3.5","7.8"]

我该怎么做？到目前为止，我已经使用了 pandas replace 功能，但它没有用。

Answer 1

使用replace使用 regex=True 进行子字符串替换:

df = df.replace(',','.', regex=True)
print (df)
        a         b    c
1       1         2    3
2  123.12  3455.435    0
3    23.2      55.5  0.1
4     1.3       3.5  7.8