String Manipulation and Relational Data

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


  • How to use the SQLite shell to work with databases.
  • How to create and normalize database tables.
  • How to insert and update data in database tables.

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

Course Info:

Data Cleaning in R


The average completion time for this course is 10-hours.

This course is free. This course includes 4 missions and 1 guided project. It is the fourth course in the Data Analyst in R path.


Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit