Merge , Join and Concat Operations on Pandas DataFrame.
When using sql, we have join operation. In Python, pandas.DataFrame also provides the similar table operations. However, pandas.DataFrame has join, merge, and concat. What’s the difference among them? In this post, I will summarise the code and illustration of these operations.
Concatenation:
Concatenation basically glues together DataFrames. Keep in mind that dimensions should match along the axis you are concatenating on. You can use pd.concat and pass in a list of DataFrames to concatenate together.
Merging:
The merge function allows you to merge DataFrames together using a similar logic as merging SQL Tables together.
Joining:
Joining is a convenient method for combining the columns of two potentially differently-indexed DataFrames into a single result DataFrame.