datetime-handling code snippets in python

you are trying to merge on datetime64[ns] and object columns. if you wish to proceed you should use pd.concat in python