Answers for "merge two dataframes on datetime column"

2

pd combine date time

If df.Date and df.Time are of type str:
pd.to_datetime(df.Date + ' ' + df.Time)

If df.Date and df.Time are of type datetime.date and datetime.time respectively:
pd.to_datetime(df.Date.astype(str) + ' ' + df.Time.astype(str))
Posted by: Guest on April-28-2021
6

merge two dataframes based on column

df_outer = pd.merge(df1, df2, on='id', how='outer') #here id is common column

df_outer
Posted by: Guest on July-27-2020

Code answers related to "merge two dataframes on datetime column"

Python Answers by Framework

Browse Popular Code Answers by Language