StatWiseAI/Alcohol-Forcasting-in-Africa

# 🥃 Whisky & Spirits Sales Forecasting Dashboard A professional Streamlit application for exploratory data analysis, statistical inference, and machine learning-based forecasting of whisky and spirits sales across African countries. ## 🎯 Features ### 1. **Data Upload & Validation** - Upload CSV or Excel files - Automatic schema validation - Data preview and summary statistics - Comprehensive error messaging ### 2. **Data Preprocessing** - 4 missing value imputation strategies (mean, median, forward-fill, drop) - Outlier detection and removal (IQR method) - Data quality assessment - Detailed preprocessing reports ### 3. **Descriptive Analytics** - Key performance indicators (KPIs) - Summary statistics (mean, median, std, quartiles, CV) - Distribution analysis with visualizations - Correlation matrices with hierarchical clustering - Country clustering and market segmentation - Time series trends ### 4. **Inferential Statistics** - Pearson correlation testing with p-values - Shapiro-Wilk and D'Agostino-Pearson normality tests - ANOVA for group comparisons - Confidence intervals - Effect sizes and statistical interpretation ### 5. **Predictive Modeling** - Random Forest and XGBoost regression models - Automatic lag feature engineering - Train/test evaluation (R², RMSE, MAE) - 10-year rolling forecasts per country - Feature importance visualization ### 6. **Professional Visualizations** - Correlation heatmaps - Time series plots - 3D scatter plots - Distribution plots - Country clustering charts - Forecast comparison visualizations - Feature importance bars ### 7. **Downloadable Outputs** - Cleaned dataset (CSV) - Summary statistics table - Model predictions and forecasts - Variable importance rankings --- ## 📊 Expected Input Data Structure ### Required Columns | Column | Type | Description | |--------|------|-------------| | **Country** | Text | Country name (e.g., "Kenya", "Nigeria") | | **Year** | Integer | Calendar year (e.g., 2015, 2024) | ### Dependent …