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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
