Pandas Joins for Spreadsheet Users
John Miller
Principal Data Scientist
pd.merge_ordered(cleveland, dallas, on='Game_Date',
suffixes=['_CLE', '_DAL'])
pd.merge_ordered(cleveland, dallas, on='Game_Date',
suffixes=['_CLE', '_DAL'])
pd.merge_ordered(tc2, td2, on='Game_Date',
suffixes=['_CLE', '_DAL'], fill_method='ffill')
pd.merge_ordered(tc2, td2, on='Game_Date',
suffixes=['_CLE', '_DAL'], fill_method='ffill')
pd.merge_asof(left_df, right_df,
direction='backward')
Directions
"backward": closest date that is earlier
"forward": closest date equal or later
"nearest": closest date regardless
pd.merge_asof(temps, impacts,
left_on='Game_Date', right_index=True, direction='backward')
Pandas Joins for Spreadsheet Users