The best way to join two DataFrame is by using the DataFrame.join() method.
Without specifying anything you will join the two DataFrames together by index.
You can specify the column on which you want your DataFrames to be joined together by passing the "on" parameter to the method.
Your DataFrames columns cannot have the same name otherwise Python will throw an error.
If your DataFrames have similar column names you will have to add a suffix with "rsuffix" parameter.
Here is the code
Here you are! You now know how to join two DataFrames by index with Pandas using Python.
More on DataFrames
If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :