将数据框中多列的字符串转换为浮点型

import pandas as pd

# 获取需要转换的列的数据
col1_data = df['col1']
col2_data = df['col2']

# 遍历并转换每个列的数据
for i in range(len(col1_data)):
    try:
        col1_data[i] = float(col1_data[i])
    except ValueError:
        col1_data[i] = None  # 如果转换失败，可以将其设置为None或其他默认值

for i in range(len(col2_data)):
    try:
        col2_data[i] = float(col2_data[i])
    except ValueError:
        col2_data[i] = None

# 更新数据框中对应列的数据
df['col1'] = col1_data
df['col2'] = col2_data