6: Wrangling 2

Data isn’t always stored in a single table. This week we’ll join multiple tables together.

Objectives:

• Explain relational data
• Identify an appropriate type of join to merge data from multiple tables
• Validate and fix data formatting issues

Data rarely comes to us in the nice clean formats we’ve been using so far. This week we focus on how to make the structure of our data work for us.

• Determine the layout of data appropriate for a desired plot or analysis
• Restructure a dataset using pivoting operations
• Identify and fix data representation issues using type conversion operations