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

Course Info:

Data Cleaning and Analysis


Beginner

The average completion time for this course is 10-hours.

This course requires a basic subscription and includes six paid missions, which includes one guided project.  It is the 6th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit