Skip to content

BerylOdoyo/kenya_coffee_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

2 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Kenya Coffee Production Analysis (1990-2018) β˜•πŸ“Š

A comprehensive data analysis project examining Kenya's coffee production decline and regional competitive positioning in East Africa. This project reveals how political instability and policy failures contributed to a 37% production decline and loss of market position.

Excel Data Analysis Status


πŸ“‹ Project Overview

This analysis investigates Kenya's coffee sector decline from 1990 to 2018, examining production trends, regional competitive dynamics, and the correlation between political events and agricultural output. Through data-driven analysis, the project identifies root causes and proposes strategic recovery pathways.

Central Finding: Kenya's coffee production fell 37% over three decades, and the country lost its #3 position in East African production to Tanzania in 2004, highlighting the devastating impact of political instability on agricultural sectors.


🎯 Key Findings

Production Decline

  • 1990 Production: 1,485 thousand 60kg bags
  • 2018 Production: 930 thousand bags
  • Total Decline: 37% over 28 years
  • Peak Year: 1995 (1,664 thousand bags)
  • Lowest Point: 2008 (541 thousand bags - 67% below peak)

Regional Competitive Position

  • Historical Ranking: 3rd in East Africa (1990-2003)
  • Current Ranking: 4th place (2004-2018)
  • Overtaken By: Tanzania in 2004
  • Current Gap: Only 200 tonnes behind Tanzania
  • Market Share: 7% of East African production (down from historical ~12%)

Political Correlation

  • 2003-2004: Sharp decline following end of Moi era and unfulfilled reform expectations
  • 2007-2008: Production collapsed to historic low during post-election violence
  • 2011: Government policy reforms yielded 8.3% production increase
  • Pattern: Political instability = production collapse; policy support = recovery

Regional Rankings (2018)

  1. Ethiopia: 7,000+ thousand bags (54% regional share)
  2. Uganda: 4,000+ thousand bags (31% regional share)
  3. Tanzania: 1,100+ thousand bags (8% regional share)
  4. Kenya: 930 thousand bags (7% regional share)
  5. Rwanda: 200 thousand bags (1.5% regional share)
  6. Burundi: 100 thousand bags (0.8% regional share)

πŸ’‘ Business Insights

Critical Discoveries

The Overtaking (2004): Kenya held a 554-tonne advantage over Tanzania in 1990 but fell behind by 28 tonnes in 2004β€”a stunning 582-tonne reversal. This shift marked not just statistical change but fundamental transformation in regional coffee dynamics.

The Recovery Opportunity: With only a 200-tonne gap to third place, Kenya could reclaim its historical position through targeted policy intervention. This represents a 22% production increaseβ€”achievable given that 2011 reforms alone produced 8.3% growth.

Political Stability Premium: Comparison with Tanzania reveals a stark lesson: while Kenya's production collapsed during political crises (2007-2008), Tanzania's stability enabled steady growth. The data proves political stability is not merely beneficial but essential for agricultural sector health.


πŸ“Š Visualizations

Production Trend Analysis

Kenya Production Trend

Kenya's production declined 37% from 1990-2018, with catastrophic drops during political crises

Regional Competitive Analysis

East Africa Coffee Production Trend

Kenya ranks 4th among East African producers, dominated by Ethiopia and Uganda

The Overtaking

Kenya vs Tanzania Coffee Production Trend

Tanzania surpassed Kenya in 2004, with the gap narrowing to 200 tonnes by 2018


πŸ› οΈ Tools & Methodology

Tools Used

  • Microsoft Excel - Data analysis, calculations, and visualization
  • Microsoft Word - Report compilation and documentation
  • Data Analysis Techniques - Trend analysis, comparative analysis, correlation studies

Data Sources

  • International Coffee Organization (ICO) - Historical production data (1990-2018)
  • Agriculture and Food Authority (AFA), Kenya - Export and market data
  • Kenya National Bureau of Statistics (KNBS) - Supplementary production statistics

Analysis Approach

  1. Trend Analysis - Examined 29-year production trajectory
  2. Comparative Analysis - Benchmarked Kenya against 5 East African producers
  3. Historical Contextualization - Correlated data with political and economic events
  4. Gap Analysis - Assessed competitive positioning and recovery feasibility
  5. Policy Impact Assessment - Evaluated 2011 reform outcomes

πŸ“ Project Structure

kenya-coffee-analysis/
β”‚
β”œβ”€β”€ README.md                                             # Project documentation
β”œβ”€β”€ data/
β”‚   └── ICO_Coffee_Production.xlsx                        # Source data (1990-2018)
β”œβ”€β”€ analysis/
β”‚   └── Kenya_Coffee_Analysis.xlsx                        # Excel workbook with analysis
β”œβ”€β”€ report/
β”‚   └── Kenya_Coffee_Report.md                            # Full written report
└── images/
    β”œβ”€β”€ kenya_trend.png                                   # Production trend chart
    β”œβ”€β”€ east_africa_coffee_production_comparison.png      # Regional ranking chart
    └── kenya_vs_tanzania_coffee_production.png           # Competitive analysis chart

πŸ” Analysis Highlights

Root Causes Identified

1. Political Instability (Primary Driver)

  • 2002-2004: Regime transition uncertainty destroyed farmer confidence
  • 2007-2008: Post-election violence displaced farmers and disrupted operations
  • Clear correlation: Every major production drop followed political crisis

2. Policy and Institutional Failures

  • Weakened SACCO (cooperative) systems
  • Inadequate government support during crises
  • Delayed implementation of promised reforms
  • Inconsistent pricing and payment mechanisms

3. Economic Pressures

  • Competition from tea and horticulture (more reliable returns)
  • Global coffee price volatility
  • Rising input costs vs declining profit margins
  • Land subdivision reducing farm viability

4. Structural Challenges

  • Aging coffee trees requiring replacement investment
  • Aging farmer population with limited youth engagement
  • Climate variability affecting yields
  • Small farm sizes limiting economies of scale

πŸ’ͺ Strategic Recommendations

Immediate Actions

  1. Sustain Policy Support - 2011 reforms proved effective; expand and institutionalize
  2. Revitalize SACCO Systems - Restore cooperative reliability and farmer trust
  3. Quality Differentiation - Leverage Kenya's premium Arabica reputation

Strategic Goals

  1. Reclaim Third Position - Close 200-tonne gap with Tanzania (achievable 22% increase)
  2. Long-term Production Recovery - Target 1,200-1,500 thousand bags over 5-10 years
  3. Political Stability Protection - Depoliticize sector governance, create crisis buffers

Enabling Factors

  1. Youth Engagement - Modernize coffee farming, attract next generation
  2. Climate Adaptation - Introduce resilient varieties, support sustainable practices

πŸŽ“ Learning Outcomes

Through this project, I developed expertise in:

Analytical Skills:

  • Multi-year trend analysis and pattern recognition
  • Comparative benchmarking across countries
  • Root cause analysis using multiple data sources
  • Correlation studies between economic and political factors

Technical Skills:

  • Advanced Excel data manipulation and visualization
  • Statistical calculations (percentages, growth rates, comparisons)
  • Data cleaning and preparation
  • Professional report writing and documentation

Business Acumen:

  • Agricultural sector economics understanding
  • Policy impact assessment
  • Strategic recommendation development
  • Stakeholder communication (technical to non-technical)

Domain Knowledge:

  • East African coffee market dynamics
  • Kenya's political and economic history (1990-2018)
  • International commodity trading patterns
  • Agricultural policy frameworks

πŸ“ˆ Key Metrics

Metric Value
Years Analyzed 29 years (1990-2018)
Countries Compared 6 East African producers
Data Points 174+ production measurements
Total Decline -37% (555 thousand bags)
Largest Single-Year Drop -47% (1995-1997)
Deepest Crisis 2008 (67% below peak)
Policy Reform Impact +8.3% (2011)
Recovery Opportunity 200 tonnes to reclaim 3rd place

🌍 Project Impact

Real-World Applications

This analysis provides:

  • Evidence-based policy guidance for Kenya's coffee sector recovery
  • Comparative intelligence for understanding regional agricultural dynamics
  • Historical lessons on political stability's economic importance
  • Strategic roadmap with concrete, achievable recovery targets

Potential Audiences

  • Kenya government agricultural policymakers
  • Coffee industry stakeholders and cooperatives
  • Development organizations supporting agricultural sectors
  • Academic researchers studying political economy and agriculture
  • Investors evaluating East African commodity markets

πŸš€ Future Enhancements

Potential extensions of this analysis:

  1. Temporal Extension

    • Incorporate 2019-2024 data to assess recent trends
    • Analyze COVID-19 pandemic impact on production
  2. Deeper Granularity

    • Sub-county level production analysis
    • Varietal-specific performance (SL28, SL34, Ruiru 11, Batian)
    • Quality grade distribution trends
  3. Expanded Scope

    • Global coffee market integration analysis
    • Price correlation studies
    • Value chain analysis (farm gate to export)
    • Comparison with other commodity sectors (tea, horticulture)
  4. Predictive Modeling

    • Production forecasting based on policy scenarios
    • Climate impact projections
    • Recovery timeline modeling

πŸ‘€ About the Analyst

Beryl Achieng Odoyo

Data Analyst | Nairobi, Kenya

Other Projects:


πŸ“„ License & Usage

This project is open source and available for educational purposes.

Citation: If you use this analysis or methodology in your work, please cite:

Odoyo, B.A. (2026). Kenya Coffee Production Analysis (1990-2018): 
Understanding Decline and Regional Competitive Positioning. 
Data Analysis Portfolio Project.

πŸ™ Acknowledgments

  • International Coffee Organization for providing comprehensive historical production data
  • Agriculture and Food Authority (AFA), Kenya for market intelligence and export data
  • Kenya National Bureau of Statistics for supplementary economic data
  • Kaggle community for data accessibility and open data sharing

πŸ“ž Contact & Feedback

Questions, suggestions, or collaboration opportunities?


Project Status: βœ… Complete
Last Updated: February 2026
Documentation Version: 1.0


This analysis demonstrates data-driven storytelling, combining quantitative analysis with historical context to generate actionable insights for Kenya's coffee sector recovery.

About

Analysis of Kenya's coffee production decline and regional competitive positioning (1990-2018)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors