Learn

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
nameemail
Katja Obinger[email protected]
Alison Hendrix[email protected]
Cosima Niehaus[email protected]
Rachel Duncan[email protected]
df2
nameemail
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:

nameemail
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

1.

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.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?