Clean messy city names from a CRM export

Question

A CRM export has arrived with inconsistent city names — stray spaces, SHOUTING CAPS and lowercase entries. Before the team can group revenue by city, the values need to be standardised.

Write a function `clean_city(name)` that returns the city name with leading and trailing whitespace removed and e

Accepted Answer

Step 1: `name.strip()` removes leading and trailing whitespace only — spaces *inside* the string are left alone, which is what we want. Step 2: `.title()` upper-cases the first letter of every word and lower-cases the rest, so both `BENGALURU` and `hyderabad` normalise correctly. Step 3: Chaining the two calls keeps the function a single expression. Strings are immutable in Python, so each call returns a new string rather than editing in place.

Clean messy city names from a CRM export

More Strings & Text Cleaning questions

Asked at Zomato