Why string operations matter in Pandas - See It in Action

Why string operations matter

📖 Scenario: You work in a company that collects customer feedback. The feedback data includes customer names and their comments. However, the data is messy: some names have extra spaces, inconsistent capitalization, and some comments have unwanted characters. You want to clean this data to make it easier to analyze.

🎯 Goal: Clean the customer names by removing extra spaces and making them all lowercase. Also, extract only the first word from each comment to get a quick idea of the feedback.

📋 What You'll Learn

Create a pandas DataFrame with customer names and comments

Create a configuration variable for the number of words to extract from comments

Use pandas string methods to clean names and extract words from comments

Print the cleaned DataFrame

💡 Why This Matters

🌍 Real World

Cleaning and preparing text data is a common task in data science, especially when working with customer feedback, reviews, or social media data.

💼 Career

Knowing how to clean and manipulate text data using pandas string methods is essential for data analysts and data scientists to prepare data for analysis and build accurate models.

1

Create the initial DataFrame

Create a pandas DataFrame called df with two columns: 'Name' and 'Comment'. Use these exact values: ' Alice ', 'Great product!'; 'BOB', 'Could be better.'; 'Charlie ', 'Loved it!'.

Pandas

# Create the DataFrame df with columns 'Name' and 'Comment' and the exact values
# Your code here

Need a hint?

Use pd.DataFrame with a dictionary containing the columns and their values.

2

Set the number of words to extract

Create a variable called num_words and set it to 1. This will control how many words to extract from each comment.

Pandas

import pandas as pd

df = pd.DataFrame({
    'Name': ['  Alice  ', 'BOB', 'Charlie '],
    'Comment': ['Great product!', 'Could be better.', 'Loved it!']
})

# Create num_words variable and set it to 1
# Your code here

Need a hint?

Just assign the number 1 to the variable num_words.

3

Clean names and extract words from comments

Use pandas string methods to clean the 'Name' column by stripping spaces and converting to lowercase. Then, create a new column called 'FirstWord' that contains the first num_words words from the 'Comment' column.

Pandas

import pandas as pd

df = pd.DataFrame({
    'Name': ['  Alice  ', 'BOB', 'Charlie '],
    'Comment': ['Great product!', 'Could be better.', 'Loved it!']
})

num_words = 1

# Clean the 'Name' column and create 'FirstWord' column
# Your code here

Need a hint?

Use str.strip() and str.lower() on the 'Name' column. Use str.split(), slice with [:num_words], and str.join(' ') on the 'Comment' column.

4

Print the cleaned DataFrame

Print the DataFrame df to see the cleaned names and the first word of each comment.

Pandas

import pandas as pd

df = pd.DataFrame({
    'Name': ['  Alice  ', 'BOB', 'Charlie '],
    'Comment': ['Great product!', 'Could be better.', 'Loved it!']
})

num_words = 1

df['Name'] = df['Name'].str.strip().str.lower()
df['FirstWord'] = df['Comment'].str.split().str[:num_words].str.join(' ')

# Print the DataFrame df
# Your code here

Need a hint?

Use print(df) to display the DataFrame.