Turn a messy billing export into a clear monthly report: totals, best sellers, slow movers and a chart.
Skills: Python, pandas, data cleaning, charts
Most small shops can export their billing data to Excel or CSV
A medical store exports its billing software data as a CSV file every month: date, bill number, item, quantity, rate, payment mode. The owner wants to know what is selling and what is not, but opens the file and gives up.
The file is messy: some dates are in different formats, some item names have extra spaces or different capitalisation, and a few rows are blank.
Create a free student account to submit your work, get mentor feedback and unlock the reference solution.
