Working With Strings In Pandas

Learn how to work with strings in pandas.


  • 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


Course Info:

Data Cleaning and Analysis


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.


Take a Look Inside