what is the difference between merge and join in pandas?
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.