akeDataAnalyst/ethiopian-specialty-lot-intelligence

Specialty Coffee Lot Intelligence System designed to support efficient sourcing, quality control, and commercial decision-making for Ethiopian specialty coffees # Ethiopian Specialty Lot Intelligence System **A Professional Sourcing & Quality Intelligence Platform for Ethiopian Specialty Coffee** --- ## Project Description This project is a comprehensive Specialty Coffee Lot Intelligence System designed to support efficient sourcing, quality control, and commercial decision-making for Ethiopian specialty coffees. The system helps bridge the gap between field-level suppliers (washing stations & cooperatives) and international buyers by providing real-time visibility, quality insights, and data-driven recommendations. --- ## Problem Statement In the Ethiopian coffee industry: - Lot information is often scattered across spreadsheets, emails, and WhatsApp messages. - Traceability and quality data (especially SCA scores, defects, and sustainability) are poorly centralized. - Sourcing teams struggle to quickly identify high-value specialty lots (80+ SCA) that meet ECX, ICO, and buyer standards. - Manual processes slow down decision-making on pricing, supplier selection, and client reporting. --- ## Solution A modern, interactive Lot Intelligence Dashboard that centralizes and analyzes Ethiopian specialty coffee data using industry standards. ### Key Features - Real-time Filtering & Search by region, processing method, SCA score, ECX grade, traceability. - Quality & Compliance Analysis (SCA CVA aligned, ECX defect rules, ICO moisture standards) - Regional Performance Insights (Yirgacheffe, Guji, Sidama) - Traceability & Sustainability Tracking (Verified, Organic, Rainforest Alliance) - Interactive Visualizations and professional reporting - Export Functionality (CSV & Excel) for client-ready reports --- ## Tech Stack - Language: Python 3.9+ - Core Libraries: Pandas, NumPy, Plotly - Frontend/Dashboard: Streamlit - Data Modeling: Pydantic - Project Structure: Modular `src/` architecture - Data Formats: CSV, Pickle, Excel - Visualization: Plotly Express ---