Merging two Pandas dataframes without a primary keys but using latest dates instead I have two pandas dataframes that looks like: