dataframe的合并

Question

将DataFrame1和DataFrame2合并形成DataFame3。

Answer 1

import pandas as pd

df1 = pd.DataFrame({'aa': ['A', 'B', 'C', 'D'],})
df2 = pd.DataFrame({'bb': ['1-2', '2-3', '3-4', '4-5'],})

df1['t'] = '1'
df2['t'] = '1'
df3 = df1.merge(df2,on = 't')
del df3['t']
print(df3)