AI Micro-Internship · ~180 min · low-code

Merge two messy real-world lists into one clean dataset

The hardest part of real data work isn’t analysis — it’s that "Govt. ITI Mumbai" and "Government I.T.I., Mumbai" are the same place. Take two real overlapping lists, merge them into one clean dataset, and document every judgement call.

Steps

01Find two real overlapping lists: two college/coaching lists, two price lists, exam centre lists from different sites, or two years of the same report.
02Standardise both: consistent columns, formats, spellings. Use AI to help match near-duplicate names — but verify its matches; it will be confidently wrong.
03Merge them, marking for each row: matched, only-in-A, only-in-B, or conflict (and how you resolved it).
04Report the mess honestly: match rate, worst conflicts, and 2 things the merged data reveals that neither list showed alone.

Tools: Two real data sources, Google Sheets or ChatGPT data analysis

Your submission

Submit both sources, the merged CSV with match-status column, and your merge report. Judgement calls are the point — document them.

Your two sources: what they are, where from, how they overlap *The merged dataset as CSV, including a match-status column *Merge report: match rate, hardest conflicts and your calls, where AI matching failed *2 things the merged data shows that neither source showed alone *