44
unique clients after merging
15
rows needing manual review
Before vs after
A 70-record client master, the same person recorded under different spellings, cities and GSTINs.
Before (raw CSV)
- 59 distinct name variants for ~44 people
- "lucknow ", "LUCKNOW", "Lucknow" as different cities
- GSTINs with XXXX placeholders
- Names missing spaces ("Nehaverma")
- Same client appearing up to 3 times
After (cleaned master)
- 44 unique client records, IDs preserved
- City names standardized (5 cities)
- 10 malformed GSTINs quarantined
- 5 possible duplicates left for human review
- 26-row merge log: every merge traceable
- No person deleted without a trail
Clients by city
Unique clients after standardization.
Merge log
26 duplicate rows folded into their canonical records: nothing silently removed.
| Merged ID | Client name | Action |
|---|
| C1035 | Arjun Chauhan | merged into C1034 |
| C1037 | Sunita Chauhan | merged into C1036 |
| C1011 | Vikash Verma | merged into C1012 |
| C1040 | Vikash Sharma | merged into C1039 |
| C1032 | Suresh Yadav | merged into C1031 |
| C1024 | Vikash Singh | merged into C1023 |
| C1008 | Rohit Agarwal | merged into C1009 |
| C1043 | Arjun Sharma | merged into C1042 |
| C1048 | Nitin Singh | merged into C1046 |
| C1061 | Suresh Mishra | merged into C1060 |
| C1015 | Neha Pandey | merged into C1016 |
| C1045 | Kavita Pandey | merged into C1044 |
| C1003 | Neha Verma | merged into C1002 |
| C1025 | Manoj Agarwal | merged into C1027 |
| C1058 | Suresh Mishra | merged into C1057 |
| C1056 | Vikash Yadav | merged into C1055 |
| C1007 | Amit Agarwal | merged into C1006 |
| C1028 | Rohit Tiwari | merged into C1029 |
| C1062 | Suresh Mishra | merged into C1060 |
| C1047 | Nitin Singh | merged into C1046 |
| C1051 | Sunita Gupta | merged into C1052 |
| C1020 | Pooja Verma | merged into C1021 |
| C1050 | Nitin Verma | merged into C1049 |
| C1026 | Manoj Agarwal | merged into C1027 |
| C1022 | Pooja Verma | merged into C1021 |
| C1014 | Neha Pandey | merged into C1016 |
Needs manual review
15 rows we refused to decide alone: malformed GSTINs and possible duplicates for a human to confirm.
| ID | Name | Phone | GSTIN | City | Reason |
|---|
| C1031 | Suresh Yadav | +91 9571177774 | 09KIJAX910XXXX3 | Lucknow | Malformed GSTIN |
| C1039 | Vikash Sharma | +91 7353799075 | 09REURC264XXXX0 | Kanpur | Malformed GSTIN |
| C1011 | Vikash Verma | +91 9948757491 | 09OIMGG191XXXXQ | Kanpur | Malformed GSTIN |
| C1004 | Rohit Mishra | +91 9318609139 | 09CEMSB6044UOZF | Agra | Possible duplicate of C1005: name needs review |
| C1040 | Vikash Sharma | +91 7353799075 | 09NNAYZ536XXXX1 | Kanpur | Malformed GSTIN |
| C1008 | Rohit Agarwal | +91 8219935181 | 09CIHXY337XXXX4 | Lucknow | Malformed GSTIN |
| C1033 | Rohit Verma | +91 9472803852 | 09HNCUB788XXXXG | Jhansi | Malformed GSTIN |
| C1015 | Neha Pandey | +91 7971147104 | 09NAZYU688XXXXD | Bareilly | Malformed GSTIN |
| C1059 | Shalini Verma | +91 9427316723 | 09HXGFX536XXXXY | Lucknow | Malformed GSTIN |
| C1001 | Nehaverma | +91 9181590830 | 09GHKGW2650EAZE | Agra | Possible duplicate of C1002: name needs review |
| C1003 | Neha Verma | +91 9181590830 | 09RKHBJ3520KYZF | Agra | Possible duplicate of C1001: name needs review |
| C1068 | Rajesh Yadav | +91 9083124023 | 09FMUHO2899UCZW | Bareilly | Possible duplicate of C1067: name needs review |
| C1018 | Kavitaagarwal | +91 9650752917 | 09ERGHC2581KPZX | Agra | Possible duplicate of C1017: name needs review |
| C1020 | Pooja Verma | +91 8465632122 | 09HMMUO640XXXX4 | Agra | Malformed GSTIN |
| C1070 | Amit Gupta | +91 8838737167 | 09EXEHX598XXXXU | Jhansi | Malformed GSTIN |
Before / after files
The exact files behind this dashboard: download them and check every number yourself.
Sample dashboard demonstrating our process. Your client list gets the same treatment, ask for a free data audit.