Skip to main content
Webinar

Live Training: Exploring Astronaut Activities in SQL


Slides — including links to notebooks

Dataset


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

Follow along with this training in Workspace.

Justin Saddlemyer Headshot
Justin Saddlemyer

Workspace Architect at DataCamp

Recommended Content

Live Training: Analyzing Streaming Service Content in SQL

Learn to join data from multiple sources, and create no-code visualizations.

Webinars

PySpark SQL Basics Cheat Sheet

Your handy companion to Apache Spark DataFrames in Python with code samples.

Cheatsheets

Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.

Webinars

Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.