In this live training you will use string cleaning to process and analyze a database containing information on astronaut extra vehicular activities (EVAs).
You will start by exploring the data, identifying potential issues with the columns that contain text. Next, Justin will take you through the steps necessary to clean up the data so you can draw insights the types and participants of EVAs!
Key learnings
Identify potential issues with text data using SQL
Reformat and clean up messy text data
Basics of regular expressions and how they can be used to categorize data