将两列数据连接到新列中

import pandas as pd

# 创建两个数据列
column1 = [1, 2, 3, 4, 5]
column2 = ['A', 'B', 'C', 'D', 'E']

# 将两列数据连接到新列中
df = pd.DataFrame({'Column1': column1, 'Column2': column2})
df['NewColumn'] = df['Column1'].astype(str) + df['Column2']

# 打印结果
print(df)

   Column1 Column2 NewColumn
0        1       A        1A
1        2       B        2B
2        3       C        3C
3        4       D        4D
4        5       E        5E