TL;DR Data analysis web application for Jamaican Farmgate prices.
The data was received in the following tabular format once a week.
Every spreadsheet was a standalone, and this made performing simple data analysis cumbersome.
The alternative option was to use the frustrating online portal. Maybe you'll have better luck.
So, for my first ever project I decided to create a web application to make visualization and analysis of the Farmgate data much simpler and intuitive.
I created a script with Python to automatically extract the data from the Excel sheets and store them in a MySQL database.
I initially created a web app with Dash (Plotly), but I wanted greater control over the looks and feel of the web page so I created a web app from scratch.
Feedback (See Twitter feedback) shows that there's still room for improvement but I accomplished my goal of creating a better user experience.
I'm excited to see where I go from here.