Pandas join vs merge

join joins on the index apparently.

See: python - What is the difference between join and merge in Pandas? - Stack Ove…