Email aur Pata Safai

Заказчик: AI | Опубликовано: 23.03.2026

Mere paas customer data ki ek spreadsheet hai jisme email addresses aur mailing addresses mein galtiyaan, duplication aur inconsistent formatting maujood hai. Main chaahta hoon ki yeh data poori tarah clean, deduplicate aur standardise kiya jaaye. Kaam ki zaroori baatein: • Galat ya adhoore email addresses identify karke correct/flag karo. • Duplicate records merge ya remove karo. • Email formatting ko RFC-standard banao. • Mailing addresses ko pin code ke saath standard postal format mein normalise karo. • Final deliverables: – Cleaned Excel/CSV file – Ek alag error log jisme badle gaye ya delete kiye gaye records ki details ho. Main 99 %+ accuracy expect karta hoon aur data confidentiality par zor deta hoon. OpenRefine, Excel Power Query, Google Sheets scripts ya Python pandas jaise tools ka upyog karna swagat-yogya hai, par zaroori nahin. Timeline teen din ka hai. Shuru mein 100 records ka sample bhej kar quality confirm karwao; final file uske baad ready karo. Similar projects ka experience hai to apni approach aur examples batana.