Question: what is the difference between merge and join in pandas?
Answer: If you are joining on index, you may wish to use DataFrame. join to save yourself some typing. One of the difference is that merge is creating a new index, and join is keeping the left side index.