Pandas String Operations

import pandas as pd

df = pd.DataFrame({'raw': ['  Alice Smith ', 'bob@EXAMPLE.com', 'New York, NY 10001', None]})

df['clean']    = df['raw'].str.strip().str.lower()
df['has_at']   = df['raw'].str.contains('@', na=False)
df['city']     = df['raw'].str.extract(r'^([^,]+),')[0]
df['zip']      = df['raw'].str.extract(r'(\d{5})$')[0]
df['replaced'] = df['raw'].str.replace(r'\s+', ' ', regex=True)
print(df)