how to join 2 dataframe by matching one column code example
Example 1: combine dataframes with two matching columns
merged_df = DF2.merge(DF1, how = 'inner', on = ['date', 'hours'])
Example 2: how to join two dataframe in pandas based on two column
merged_df = left_df.merge(right_df, how='inner', left_on=["A", "B"], right_on=["A2","B2"])