pandas在包含数字和字符串的列中应用小数

import pandas as pd

# 创建包含数字和字符串的列的DataFrame
data = {'col1': [1, 2, 3, '4', '5.5'],
        'col2': ['6', '7.7', '8', 9, 10]}
df = pd.DataFrame(data)

# 将列的数据类型转换为字符串类型
df['col1'] = df['col1'].astype(str)
df['col2'] = df['col2'].astype(str)

# 应用小数
df['col1'] = df['col1'].apply(lambda x: float(x) if x.replace('.', '', 1).isdigit() else x)
df['col2'] = df['col2'].apply(lambda x: float(x) if x.replace('.', '', 1).isdigit() else x)

print(df)

  col1  col2
0    1   6.0
1    2   7.7
2    3   8.0
3    4   9.0
4  5.5  10.0