I have a CSV/Excel dataset that mixes numbers, text, and categorical fields. Before I can draw any meaningful insight from it, I need every duplicate record gone. Once the file is pristine I’d like to see the story in the data through clear, professional-looking visualisations. Here’s what I have in mind: you load the sheet, use whatever you prefer—Python (pandas), R (dplyr), Power Query, even good old Excel VBA—to locate and remove every duplicate row while preserving the first valid instance. After that, build a set of compelling visuals: charts, dashboards, or infographics that highlight trends you spot once the redundancies are out of the way. Deliverables • A cleaned CSV/XLSX with duplicates removed • A separate file (or interactive dashboard) containing the visuals, along with the code or steps you used so I can reproduce or tweak them later I’m sticking to duplicate removal for now, but if you notice missing-value or formatting issues during the process, flag them—there may be a chance to extend the brief. Let me know which tools you plan to use and roughly how long you’ll need, and we can kick off right away.