尝试合并2个数据帧，但收到合并object和int32列的值错误

import pandas as pd

# 创建示例数据帧
df1 = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
df2 = pd.DataFrame({'A': [4, 5, 6], 'B': [7, 8, 9]})

# 检查列名差异
column_diff = set(df1.columns).difference(set(df2.columns))
if column_diff:
    # 重命名列名
    df2.rename(columns={col: col for col in column_diff}, inplace=True)

# 检查数据类型差异
dtypes_diff = df1.dtypes != df2.dtypes
if dtypes_diff.any():
    # 将数据类型转换为一致
    for col in dtypes_diff[dtypes_diff].index:
        if df1[col].dtype != df2[col].dtype:
            try:
                df2[col] = df2[col].astype(df1[col].dtype)
            except ValueError:
                pass

# 合并数据帧
merged_df = pd.concat([df1, df2], ignore_index=True)