CSV list cleaner

This recipe cleans a contact list before a CRM import or a transactional send. It reads a CSV, removes duplicates, checks each distinct value once and writes the rows back with a verdict. The full script is clean_list.py.

#How does it work?

1. It finds a phone, number, mobile, msisdn or e164 column and/or an email column.
2. It sends each distinct value once: one lookup for up to 100 values, otherwise a bulk job.
3. It writes cleaned.csv with three new columns: verdict, reachable_on and suggestion.

from mobilevalidate import MobileValidate

mv = MobileValidate()  # reads MOBILEVALIDATE_API_KEY; MobileValidate(sandbox=True) for the test values
job = mv.jobs.create(numbers=numbers, emails=emails, checks=["whatsapp", "email"])
job = mv.jobs.wait(job["id"], wait_timeout=600)
for row in mv.jobs.results(job["id"]):  # pages through all results
    registered = row.get("checks", {}).get("whatsapp.registered", {}).get("registered")  # True / False / None

#What verdicts can a row get?

#How do I try it?

pip install -r requirements.txt
python clean_list.py list.csv cleaned.csv

The sample list.csv contains only test values, so it runs with the public sandbox key. Sandbox jobs are limited to 10 rows; for bigger files, use a personal test key or a live key.

The script prints counts only. It never prints numbers or addresses.