Pandas >> How to Convert a Multi-Value Column to Multiple Rows

In this article, we will talk about how to split one column in which contents are concatenated with a delimiter like a comma to a list. And convert the list column to multiple rows with other columns duplicated.

• Use str.split() to split one column to a list
• Convert the column with a list type value to multiple rows using explode() method

Preparing data

Use str.split() to split a column to a list

df["hobbies"] = df["hobbies"].str.split(",") 
df

Convert the column with a list-type value to multiple rows

You can use explode() method of Pandas to convert a column with list-type values to multiple rows with other columns that are duplicated.

df = df.explode("hobbies") 
df

Conclusion

We used str.split() to split one column into a list and used explode() method to convert it to multiple rows.

For more str methods, you can read the article below.

Pandas “ How to Process a Whole Column Like String https://thats-it-code.com/pandas/pandas__how-to-process-a-whole-column-like-string/

Originally published at https://thats-it-code.com on March 25, 2022.