Reputation: 181
Having an two excel sheet as follows:
Need to merge these two excel sheet using pandas.Second sheet needs to be merge with the first excel. The output will be want in the following format.
Upvotes: 0
Views: 39
Reputation: 989
Let's assume you have df1 and df2 and you wanna merge the two dataframes together on the same start here is sample:
df = df1.merge(df2, how='outer', on='Start')
Upvotes: 2