As McCombs students, we wanted to make a website relating to Finance that could benefit all students at UT Austin and even external parties. We are relative beginners with development and have intermediate knowledge in both Python, SQL, and ML. As such, we wanted to incorporate these skills into our project. To begin, we identified one main problem that students often struggle with: they do not have any experience with managing their revenue and expenses. As such, we decided to create a budget tracker to ensure that students can track their spend easily even when they are busy with life. This apps makes budget tracking easy and fun!
For our project, we created a SQL database using Supabase, a Postgres development platform, with two tables: transactions and categories. We then created three files in python: app.py, ml.py, and db.py with the help of Claude. The file db.py interacts with the database, handling all reads and writes. The file ml.py uses linear regression to predict next month's spend per category and Isolation Forest to flag anomalous individual transactions. The file app.py handles the front end to run the Streamlit app.
Built With
- postgresql
- python
- streamlit
- supabase
Log in or sign up for Devpost to join the conversation.