str.split() for splitting in Pandas - Step-by-Step Execution

Concept Flow - str.split() for splitting

Start with a pandas Series

↓

Call str.split() method

↓

Specify separator (default whitespace)

↓

Split each string into list of substrings

↓

Return Series of lists

↓

Use or analyze the split results

The str.split() method splits each string in a pandas Series into lists of substrings based on a separator.

Execution Sample

Pandas

import pandas as pd
s = pd.Series(['apple orange', 'banana', 'grape lemon lime'])
s_split = s.str.split()
print(s_split)

This code splits each string in the Series by whitespace into lists of words.

Execution Table

Step	Input String	Separator	Split Result	Output Type
1	'apple orange'	default (whitespace)	['apple', 'orange']	list
2	'banana'	default (whitespace)	['banana']	list
3	'grape lemon lime'	default (whitespace)	['grape', 'lemon', 'lime']	list
4	All strings processed	-	Series of lists	pandas Series

💡 All strings in the Series are split by whitespace, producing a Series of lists.

Variable Tracker

Variable	Start	After str.split()
s	['apple orange', 'banana', 'grape lemon lime']	unchanged
s_split	not defined	[['apple', 'orange'], ['banana'], ['grape', 'lemon', 'lime']]

Key Moments - 3 Insights

Why does str.split() return a Series of lists instead of a Series of strings?

Because each original string can split into multiple parts, str.split() returns a list of substrings for each element, so the output is a Series where each element is a list (see execution_table rows 1-3).

What happens if the separator is not specified?

The default separator is whitespace, so strings are split at spaces or tabs. This is shown in the execution_table where separator is 'default (whitespace)'.

Can str.split() handle different separators?

Yes, you can specify a separator like ',' or '-' as an argument to str.split(). This changes how strings are split but the output remains a Series of lists.

Visual Quiz - 3 Questions

Look at the execution_table, what is the split result for the string 'banana' at step 2?

A ['banana']

B ['b', 'a', 'n', 'a', 'n', 'a']

C ['banana', '']

D []

💡 Hint

Check the 'Split Result' column at step 2 in the execution_table.

At which step does the method finish processing all strings?

A Step 2

B Step 3

C Step 4

D Step 1

💡 Hint

Look for the row where 'All strings processed' is mentioned in the 'Input String' column.

If we change the separator to ',', how would the split result for 'apple orange' change?

A ['apple orange', '']

B ['apple orange']

C ['apple', 'orange']

D ['apple', ' orange']

💡 Hint

Since there is no comma in 'apple orange', splitting by ',' returns the whole string as one element list.

Concept Snapshot

pandas Series.str.split(separator=null)
Splits each string in the Series by separator (default whitespace).
Returns a Series of lists of substrings.
Useful to break text into parts for analysis.
Specify separator to split by other characters.

Full Transcript

This visual execution shows how pandas Series.str.split() works. Starting with a Series of strings, calling str.split() splits each string into a list of words using whitespace by default. Each step shows the input string, the separator used, and the resulting list of substrings. The output is a Series where each element is a list. Variables s and s_split track the original and split Series. Key moments clarify why the output is lists and how separators affect splitting. The quiz tests understanding of split results and method behavior.