Tshidycodes/Climate-Change-Impact-on-Agriculture

This project compares the impact of climate change on agricultural economies of Nigeria and the United States. # A Comparative Climate Adaptation Study between Nigeria and the United States Climate change and extreme weather events pose a threat to global food security, leading to unstable crop yields and massive financial losses in agricultural sectors across the world. This project compares the impact of climate change on agricultural economies of Nigeria and the United States. These are two countries that have contrasting economies and environmental contexts. ## Objective This project aims to: - **Identify the key factor driving economic losses in agriculture** - **Determine which crops are most vulnerable to climatic changes.** - **Evaluate the effectiveness of various climate adaptation strategies (e.g., water management, drought-resistant crops)** - **Assess whether successful adaptation strategies in one country (e.g., Nigeria) can be effectively applied in another context (e.g., the United States)** --- ## Methodology ### 1. **Data Source and Import** The dataset used in this project contains climate and agricultural data of various countries. It was sourced from Kaggle and imported into Power Query from a locally stored Excel file. ### 2. **Data Preparation** Power Query was used to clean and transform the raw data. The dataset was filtered to contain the two countries central to the study: **Nigeria** and **the United States**. Additional filtering was applied to retain only the columns relevant to the project objectives: - Year - Country - Crop_Type - Average_Temperature_C - Crop_Yield_MT_per_HA - Extreme_Weather_Events - Adaptation_Strategies - Economic_Impact_Million_USD ### 3. **Data Analysis** DAX measures were created to support the analysis of crop performance, climate trends, and economic impacts across **Nigeria** and **the United States**. These measures calculate key metrics such as average crop yield, total economic losses, extreme weather event counts, and temperature insights. They form the foundation of the visualizations and enable meaningful c …