What’s the difference between join and merge in Python Pandas?
• join combines based on the indexes. Perfect when both data frames refer to the same person IDs, product names, or dates
• merge combines based on *any* two columns — but you must specify which ones.