Sometimes, a dataset is broken into multiple tables. For instance, data is often split into multiple CSV files so that each download is smaller.
When we need to reconstruct a single DataFrame from multiple smaller DataFrames, we can use the method
pd.concat([df1, df2, df2, ...]). This method only works if all of the columns are the same in all of the DataFrames.
For instance, suppose that we have two DataFrames:
If we want to combine these two DataFrames, we can use the following command:
That would result in the following DataFrame:
An ice cream parlor and a bakery have decided to merge.
The bakery’s menu is stored in the DataFrame
bakery, and the ice cream parlor’s menu is stored in DataFrame
Create their new menu by concatenating the two DataFrames into a DataFrame called