如何在Pandas中合并包含数字数据的多列，但忽略空单元格

import pandas as pd

# 创建示例数据
data1 = {'A': [1, 2, 3, None, 5],
         'B': [None, 6, 7, 8, 9]}
data2 = {'C': [10, None, 12, 13, 14],
         'D': [15, 16, None, 18, 19]}

df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)

# 填充空单元格为特定值（例如0）
df1_filled = df1.fillna(0)
df2_filled = df2.fillna(0)

# 使用concat函数按列合并
merged_df = pd.concat([df1_filled, df2_filled], axis=1)

# 或者使用merge函数按列合并
# merged_df = pd.merge(df1_filled, df2_filled, left_index=True, right_index=True)

print(merged_df)

     A    B     C     D
0  1.0  0.0  10.0  15.0
1  2.0  6.0   0.0  16.0
2  3.0  7.0  12.0   0.0
3  0.0  8.0  13.0  18.0
4  5.0  9.0  14.0  19.0