Separating data

Separate or unite values in columns

One of the key principles of tidy data is that each value has its own cell. To achieve that, you may need to split values in column into multiple columns or combine values across columns.

Learning objectives

• Separate values from single column into multiple columns
• Unite multiple columns into single column
• Coalesce multiple columns with missing data into single column
• Find all possible combinations of factors and all existing combinations
• Fill in missing data

Pre-meeting

To prepare for this class meeting, please do the following:

• Read R4DS1 12.4 - 12.5

Class meeting

• Separating data
• Uniting data
• Coalescing data
• Combinations of factors
• Filling missing data
• Slides and Code

Homework after the class meeting

Wrap up this lesson

• Complete the exercises

For next class meeting

• Read R4DS2 21.1 - 21.3.2