Jack
Jack

Reputation: 181

Mergining excel sheet in pandas

Having an two excel sheet as follows:

img1sheet2

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.

new

Upvotes: 0

Views: 39

Answers (1)

Dejene T.
Dejene T.

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

Related Questions