From the course: Learning the R Tidyverse

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Separating columns into multiple columns

Separating columns into multiple columns - R Tutorial

From the course: Learning the R Tidyverse

Start my 1-month free trial

Separating columns into multiple columns

“

- [Instructor] Dplyr is a member of the tidyverse ecosystem designed for manipulating data with a variety of different verbs. Separate is a very useful verb for splitting columns that contain multiple pieces of information into distinct columns. For instance, you may have data where locations are stored as a string with the name of the country, a comma and then the name of a city. This is actually two pieces of data that would be great to be able to split into separate columns. Separate is flexible enough to handle complicated cases where the deliminator appears multiple times in a string. Let's look at some examples of that in our exercise files. So, in our exercise files, we have two folders, we have data and data-raw. Let's have a look at data. It's currently empty. Data-raw, that has an Excel file in it and a file called data-tidying.R. Let's open it up and see what we have. I'm not going to be playing with my environment very much, so I'm going to minimize that and I also no…

Contents