This is a Python Dash web app that can show the latest prices for each product. Makes use of DuckDB SQL database management system to query prices from CSV data
Note: The above screenshot is taken on a Macbook using Brave Browser. The web app may look differently depending on the device and the web browser used
On initial setup, the CSV price data is copied to a table in the SQL database. Then the SQL queries are executed on the table to show the latest price changes and product availability. The results are obtained as a dataframe and displayed to the user using a Dash datatable on the web app
It's simple. Just type part of the name of the product and you will get the list of products matching your input and their prices. Now you can compare prices and potentially save money on groceries