Project Information
- Category: Django Web Application
- Client: Ancap
- Date: 2024
- Technologies: Django, PostgreSQL, Pandas
- Role: Full-Stack Developer
Admin/Excel Automation for Ancap
A Django web app built for a gas station chain in Uruguay to automate their mini market operations — replacing a manual Excel-based workflow that took hours each semester.
What it does
Staff upload their semester sales and purchase Excel files through the app. The system processes and joins the data using Pandas, runs the calculations automatically, and surfaces the results in a clean dashboard — showing best and worst performing products, margins, and purchase patterns. What used to take hours now takes minutes.
Features
- Excel file upload and automated processing with Pandas
- Joins sales and purchase data across multiple sources
- Identifies underperforming and top-selling products
- Calculates margins and profitability per product
- Export results to Excel or CSV
- Django admin interface for managing data and users