python dataframe union rows code example
Example 1: union df pandas
pd.concat([df1, df2])
Example 2: join tables pandas
In [99]: result = left.join(right, on=['key1', 'key2'], how='inner')
pd.concat([df1, df2])
In [99]: result = left.join(right, on=['key1', 'key2'], how='inner')