Do you need to parse a delimited string in Python? Is you string comma-delimited? Are there several strings in a column of data in a pandas DataFrame? As a data professional you may encounter a column of data that needs to be split into multiple columns for better processing. A row may contain a column that classifies the row into categories or types by providing a few categories separated by commas.

Suppose you have a pandas DataFrame of music CDs that has a column called genre. Some music fits neatly into one genre while other CDs are a mix of two or three genres.

A Simple Example Using Split

First, let’s look at the function split(). I created a simple Python example called Split a String.