Concatenating pd.DataFrame objects
The term concatenation in pandas refers to the process of taking two or more pd.DataFrame
objects and stacking them in some manner. Most commonly, users in pandas perform what we would consider to be vertical concatenation, which places the pd.DataFrame
objects on top of one another:
Figure 7.1: Vertical concatenation of two pd.DataFrame objects
However, pandas also has the flexibility to take your pd.DataFrame
objects and stack them side by side, through a process called horizontal concatenation:
Figure 7.2: Vertical concatenation of two pd.DataFrame objects
These figures may provide you with a good grasp of what concatenation is all about, but there are some potential issues to consider. What should happen if we try to concatenate vertically, but our column labels are not the same across all of the objects? On the flip side, what should happen if we try to concatenate horizontally, and not all of the row labels are the...