Merge two data frames in pandas based on two columns

Asked Feb 24 '20 at 18:43

Active Feb 24 '20 at 18:44

Viewed 19 times

I have two dataframes: Weather and Guest Counts. To simplify they look like these:

I was trying to merge two data frames based on the "date" and "time_period" columns. The ideal result looks like something like this:

I did this but nothing came out. I am not sure what the issue is.

f = pd.merge(left=df2,right=dp2, left_on=['date','time_period'], right_on=['date','time_period'])

Result:

edited Feb 24 '20 at 18:44

asked Feb 24 '20 at 18:43

LLL

Can you post the actual data instead of picture of it – Chris Feb 24 '20 at 18:44
Can you create a concatenated column of those two, merge on that, then drop the column? – Kyle Feb 24 '20 at 18:45
@Chris I can't post the actual one since it's confidential – LLL Feb 24 '20 at 18:47
@Kyle That works. Thanks! – LLL Feb 24 '20 at 20:32

0 Answers0