无法将字符串列转换为浮点型

import pandas as pd

# 示例数据
data = {'col1': ['1.23', '4.56a', '7.89', '10.11b']}
df = pd.DataFrame(data)

# 使用正则表达式去除非数字字符
df['col1'] = df['col1'].str.replace(r'[^0-9.]', '', regex=True)

# 转换为浮点型
df['col1'] = pd.to_numeric(df['col1'], errors='coerce')

print(df)

# 去除空格和换行符
df['col1'] = df['col1'].str.strip()

# 转换为浮点型
df['col1'] = pd.to_numeric(df['col1'], errors='coerce')

print(df)

# 示例数据
data = {'col1': ['1.23e+02', '4.56', '7.89e-01', '10.11']}
df = pd.DataFrame(data)

# 转换为浮点型
df['col1'] = pd.to_numeric(df['col1'], errors='coerce')

print(df)

# 示例数据
data = {'col1': ['1.23', '4.56ä', '7.89', '10.11']}
df = pd.DataFrame(data)

# 统一编码
df['col1'] = df['col1'].str.encode('utf-8').str.decode('utf-8')

# 转换为浮点型
df['col1'] = pd.to_numeric(df['col1'], errors='coerce')

print(df)