Why string operations matter in Pandas - Challenge Your Understanding

Challenge - 5 Problems

❓ Predict Output

intermediate

Output of pandas string split and expand

What is the output of this code snippet that splits a column of full names into first and last names?

Pandas

import pandas as pd

df = pd.DataFrame({'Name': ['Alice Smith', 'Bob Jones', 'Carol Lee']})
df[['First', 'Last']] = df['Name'].str.split(' ', expand=True)
df

A

       Name  First   Last
0  Alice Smith  Alice  Smith
1    Bob Jones    Bob  Jones
2   Carol Lee  Carol   Lee

B

       Name  First
0  Alice Smith  Alice
1    Bob Jones    Bob
2   Carol Lee  Carol

C [['Alice', 'Smith'], ['Bob', 'Jones'], ['Carol', 'Lee']]

D

       Name
0  Alice Smith
1    Bob Jones
2   Carol Lee

💡 Hint

Look at how the split with expand=True creates new columns in the DataFrame.

The str.split with expand=True splits the string into separate columns. Here, 'Name' is split into 'First' and 'Last' columns.

❓ data_output

intermediate

Count of rows containing a substring

Given this DataFrame, how many rows contain the substring 'cat' in the 'Animal' column?

Pandas

import pandas as pd

df = pd.DataFrame({'Animal': ['cat', 'dog', 'caterpillar', 'bird', 'scatter']})
count = df['Animal'].str.contains('cat').sum()
count

A 3

B 2

C 4

D 1

💡 Hint

Check which strings have 'cat' anywhere inside them.

The strings 'cat', 'caterpillar', and 'scatter' all contain 'cat', so the count is 3.

🔧 Debug

advanced

Identify the error in string replacement

What error does this code raise when trying to replace 'dog' with 'cat' in the 'Animal' column?

Pandas

import pandas as pd

df = pd.DataFrame({'Animal': ['dog', 'dogfish', 'hotdog']})
df['Animal'].str.replace('dog')

A ValueError: pattern not found

B TypeError: replace() missing 1 required positional argument: 'repl'

C AttributeError: 'Series' object has no attribute 'str'

D No error, returns replaced strings

💡 Hint

Check the required arguments for str.replace method.

The str.replace method requires two arguments: the pattern to replace and the replacement string. Here only one argument is given, causing a TypeError.

❓ visualization

advanced

Visualizing string length distribution

Which option produces a histogram of the lengths of strings in the 'Words' column?

Pandas

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame({'Words': ['apple', 'banana', 'pear', 'kiwi', 'grape']})

lengths = df['Words'].str.len()
plt.hist(lengths)
plt.xlabel('Length of word')
plt.ylabel('Frequency')
plt.title('Histogram of word lengths')
plt.show()

A A line plot of word lengths over index

B A bar chart of word counts

C A scatter plot of word lengths vs words

D A histogram showing word lengths with bars at lengths 4, 5, 6

💡 Hint

Histogram groups numeric values into bins and shows frequency.

The code calculates string lengths and plots a histogram showing how many words have each length.

🧠 Conceptual

expert

Why string operations are crucial in data science

Which statement best explains why string operations matter in data science?

A String operations are mainly used to speed up numerical calculations in datasets.

B String operations are only useful for formatting output and have little impact on data analysis.

C String operations allow cleaning and transforming text data, which is often messy and unstructured, enabling better analysis.

D String operations replace the need for statistical methods in data science.

💡 Hint

Think about the role of text data in real-world datasets.

Text data is common and often messy. String operations help clean, extract, and transform this data for meaningful analysis.