无法拆分pandas数据报中的列

import pandas as pd

# 示例数据
data = {'col': ['a,b,c', 'd,e,f', 'g,h,i', 123]}
df = pd.DataFrame(data)

# 尝试拆分
try:
    df[['col1', 'col2', 'col3']] = df['col'].str.split(',', expand=True)
except Exception as e:
    print(f"Error: {e}")

# 填充缺失值
df['col'] = df['col'].fillna('')

# 删除包含缺失值的行
df = df.dropna(subset=['col'])

import re

# 示例数据
data = {'col': ['a,b,c', 'd;e;f', 'g,h,i']}
df = pd.DataFrame(data)

# 使用正则表达式拆分
df[['col1', 'col2', 'col3']] = df['col'].apply(lambda x: pd.Series(re.split(r'[;,]', x)))

# 示例数据
data = {'col': ['a,b,c', 'd,e,f!', 'g,h,i']}
df = pd.DataFrame(data)

# 处理特殊字符
df['col'] = df['col'].str.replace(r'[!]', '', regex=True)

# 拆分
df[['col1', 'col2', 'col3']] = df['col'].str.split(',', expand=True)