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 data frame from multiple smaller data frames, we can use the dplyr bind_rows()
method. This method only works if all of the columns are the same in all of the data frames.
For instance, suppose that we have two data frames:
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 data frames, we can use the following command:
concatenated_dfs <- df1 %>% bind_rows(df2)
That would result in the following data frame:
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 data frame bakery
, and the ice cream parlor’s menu is stored in the data frame ice_cream
.
Create their new menu by concatenating the two data frames into a data frame called menu
.