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 | k.obinger@gmail.com |
| Alison Hendrix | alisonH@yahoo.com |
| Cosima Niehaus | cosi.niehaus@gmail.com |
| Rachel Duncan | rachelduncan@hotmail.com |
df2
| name | |
|---|---|
| Jean Gray | jgray@netscape.net |
| Scott Summers | ssummers@gmail.com |
| Kitty Pryde | kitkat@gmail.com |
| Charles Xavier | cxavier@hotmail.com |
If we want to combine these two data frames, we can use the following command:
That would result in the following data frame:
| name | |
|---|---|
| Katja Obinger | k.obinger@gmail.com |
| Alison Hendrix | alisonH@yahoo.com |
| Cosima Niehaus | cosi.niehaus@gmail.com |
| Rachel Duncan | rachelduncan@hotmail.com |
| Jean Gray | jgray@netscape.net |
| Scott Summers | ssummers@gmail.com |
| Kitty Pryde | kitkat@gmail.com |
| Charles Xavier | cxavier@hotmail.com |
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.