A production-ready Python script for validating, cleaning, and geocoding client data from CSV files.
Includes email validation, name checks, address formatting, and latitude/longitude enrichment using OpenStreetMap's Nominatim API.
- Validate email format.
- Validate first and last names (basic alphabetic check).
- Remove rows with missing or invalid data.
- Fetch latitude & longitude for residential and postal addresses.
- Export cleaned data to a new CSV file.
- Python 3.8+
- Libraries:
pip install pandas