Analyze a CSV of expenses and produce charts and insights.
Difficulty: Intermediate · Technology: Python, pandas, Matplotlib
Features to build
- Data cleaning
- Monthly summaries
- Charts
- Written findings
Step-by-step build plan
- Choose a public expenses CSV or create sample data
- Clean missing values and dates
- Group by month and category
- Chart the trends
- Write three findings and one recommendation
The part most people find hard
Cleaning inconsistent category names.
How to test it
Check your totals against a manual calculation.
Suggested extensions
Add user accounts, better error handling, automated tests and a README with screenshots. Each extension is a new talking point in interviews.
How to describe it on your resume
Analyzed spending data with pandas and presented insights with visualizations.
Portfolio tip
Deploy it, link both the live version and the code, and write two paragraphs about what you learned and what you would improve.