aaif-clean-data

Normalize and fix data quality in the AAIF Community Intake Ops sheet — canonicalize LinkedIn URLs, fix name/city casing & whitespace, derive each person's city from the form's free-text answer (City > Extracted, capital when only a country is given), flag bad/missing emails and duplicates, and surface broken rows in bright red. Reports & proposes by default; only writes on explicit approval. Use when asked to clean up / normalize / fix the intake data.

Compatibility

Requires Python 3, authenticated gws with Google Sheets access, and network access.