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:
df1
| name | |
|---|---|
| Katja Obinger | [email protected] |
| Alison Hendrix | [email protected] |
| Cosima Niehaus | [email protected] |
| Rachel Duncan | [email protected] |
df2
| name | |
|---|---|
| Jean Gray | [email protected] |
| Scott Summers | [email protected] |
| Kitty Pryde | [email protected] |
| Charles Xavier | [email protected] |
If we want to combine these two DataFrames, we can use the following command:
That would result in the following DataFrame:
| name | |
|---|---|
| Katja Obinger | [email protected] |
| Alison Hendrix | [email protected] |
| Cosima Niehaus | [email protected] |
| Rachel Duncan | [email protected] |
| Jean Gray | [email protected] |
| Scott Summers | [email protected] |
| Kitty Pryde | [email protected] |
| Charles Xavier | [email protected] |
Instructions
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 ice_cream.
Create their new menu by concatenating the two DataFrames into a DataFrame called menu.
Display menu using print.