在Python中将列中的数字相加不能正常工作？

import pandas as pd

# 示例数据
data = {'A': ['1', '2', '3'], 'B': [4, 5, 6]}
df = pd.DataFrame(data)

# 将列'A'转换为数字类型
df['A'] = pd.to_numeric(df['A'])

# 相加
result = df['A'] + df['B']
print(result)

import pandas as pd
import numpy as np

# 示例数据
data = {'A': [1, 2, np.nan], 'B': [4, 5, 6]}
df = pd.DataFrame(data)

# 填充缺失值
df['A'].fillna(0, inplace=True)

# 相加
result = df['A'] + df['B']
print(result)

import pandas as pd

# 示例数据
data = {'A': [1, 2.0, 3], 'B': [4, 5, 6]}
df = pd.DataFrame(data)

# 确保列'A'的数据类型一致
df['A'] = df['A'].astype(float)

# 相加
result = df['A'] + df['B']
print(result)

import pandas as pd

# 示例数据
data = {'A': [1, 2, 3], 'B': [4, 5, 6]}
df = pd.DataFrame(data)

# 确保列名正确
if 'A' in df.columns and 'B' in df.columns:
    result = df['A'] + df['B']
    print(result)
else:
    print("列名错误")