Fazestar01/Avocado-Exports-from-Kenya

This source provides 2023 export data of avocados from Kenya, broken down by destination country including both quantity and value. # Avocado Exports From Kenya Analysis ### Data Analyst: Faiza Abdulqadir **Avocado Exports from Kenya analysis** is a project focused on the ETL (Extract, Transform, Load) pipeline in Jupyter Notebook and visualisations in Tableau. The project examines Kenya's avocado export patterns, trading relationships, and market dynamics to assess competitiveness in the global avocado industry. ## Navigation * Data Investigations * Raw Data * Cleaned Data * Dashboard ## Dataset Content * Data was acquried from a dataset on a software that includes several databases from various international organisation WITS, the data includes avocado export information from 2023 from Kenya showing weight, quantity and trade value. ## Business Requirements The avocado industry is growing at a rapid rate with increasing international markets. With that being said, Kenya is amongst one of the new kids on the block when it comes to being an avocado exporter. * This is being carried out by an Agricultual Analyst for the exporting company, Globalwema which is based in both the UK and Kenya. The purpose is to give this company insight on the potential produce they wish to embark on. * The requirement is to look into which countries are Kenyas top trading partners. As countries like Mexico and South Africa have been in the running, it is vital to know if Kenya is part of the running. * In addition, are export volumes and values increasing over time and how is the pricing per tonne varying across the markets and years. This is worth looking into as although Kenya is now exporting avocados, does it mean it's a sustainable country in the long run. * In terms of future projective predictions, its worth looking at what is happening now and whether Kenya can compete with the more seasoned players in the avocado exporting world or if this is a short term matter. ## Hypothesis and how to validate? The following hypotheses reflect the initial expectations and goals of the project. However, as t …