Get startedGet started for free

Splitting columns

Good work on all the data-cleaning steps you've taken so far; the final step to get our data ready for analysis is splitting out the full address column into two columns: street address and city.

You'll use Python to carry out this final transformation task. Use CleanerBot3000 to understand how to split these columns and apply a Pandas function to the dataset.

What is the correct Pandas function to approach splitting these columns?

This exercise is part of the course

Cleaning Data with Generative AI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise