MISSION 346

Working With Strings In Pandas

Learn how to work with strings in pandas.

Objectives

  • Practice manipulating strings with pandas.
  • Learn how to use regular expressions.
  • How to insert and update data in database tables.

Mission Outline

1. Introduction
2. Using Apply to Transform Strings
3. Vectorized String Methods Overview
4. Exploring Missing Values with Vectorized String Methods
5. Finding Specific Words in Strings
6. Finding Specific Words in Strings Continued
7. Extracting Substrings from a Series
8. Extracting Substrings from a Series Continued
9. Extracting All Matches of a Pattern from a Series
10. Extracting More Than One Group of Patterns from a Series
11. Challenge: Clean a String Column, Aggregate the Data, and Plot the Results
12. Next steps
13. Takeaways

python-datacleaning

Course Info:

Data Cleaning and Analysis

Beginner

The median completion time for this course is 7.2 hours

This course requires a basic subscription and includes five missions and one guided project.  It is the sixth course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside