MISSION 324

String Manipulation and Relational Data

Practice string manipulation and learn to work with relational data as you prepare six data frames for analysis.

Objectives

  • Practice manipulating strings to create new variables
  • Learn about relational data, joins, and keys
  • Use different types of joins to combine data frames

Mission Outline

1. Importing the Cleaned NYC Schools Data into R
2. Tidy Data and Efficient Analysis
3. Parsing Numbers from Strings
4. Extracting Numeric Data From Strings: Creating New Variables
5. Splitting Strings
6. Subsetting strings
7. Relational Data: Keys and Joins
8. Inner Joins
9. Outer Joins
10. Using Joins to Create A Single Data Frame
11. Next Steps
12. Takeaways

r-data-cleaning

Course Info:

Advanced

The median completion time for this course is 8.05 hours. View details

This course is free, and includes four missions and one guided project. It is the fourth course in the Data Analyst in R path.

START LEARNING FREE

Take a Look Inside