Analyzed 2016 export data of fruits and vegetables to global markets. Based on the provided Excel file containing 213 order records.
This dataset tracks exports from January to December 2016 across 6 products (Apple, Beans, Broccoli, Carrots, Mango, Orange) to 7 countries.
Key Questions Answered:
- Which product was exported the most? → Mango
- How many times was Apple ordered? → 40 times
- Which country ordered the most fruit? → United States (42 orders)
- What percentage of total export volume is Carrots? → 13.3%
- What’s the sales trend for Mango, Orange, and Apple?
| Insight | Value |
|---|---|
| Total Export Volume | 1,029,734 kg |
| Top Product by Volume | Mango (397,374 kg / 38.6%) |
| Top Product by Order Count | Mango (82 orders) |
| Carrots % of Total Volume | 13.3% (136,945 kg) |
| Apple Order Count | 40 orders |
| Top Fruit Market | United States (42 fruit orders) |
| Top Vegetable Market | Germany (20 vegetable orders) |
| Peak Month for Mango | May (19 orders) |
| Fruit vs Veg Orders | 146 Fruit |
✅ Mango dominates: It accounts for nearly 40% of total weight and over 38% of all orders — clearly the star product.
📈 Seasonality: High fruit demand in spring/summer (May peak), with a secondary spike in December.
🌎 Top 3 Fruit Markets (US, NZ, AU): Together account for 50.7% of all fruit orders.
data/Export Data for Pivot Table.xlsx: Original source data.analysis/*.ipynb: Jupyter notebooks showing step-by-step analysis using pandas and matplotlib.visuals/*.png: Generated charts from the analysis.docs/analysis_summary.md: Detailed breakdown of each pivot table task.
- Clone this repo:
git clone https://github.com/yourusername/export-data-analysis-2016.git cd export-data-analysis-2016