This repository contains the code, data, and analysis for the US Honey Production Case Study. The goal of this study is to explore and analyze the trends and patterns in the average honey price and production in the US over the years. The analysis addresses several key questions regarding state-wise production, average prices, contributions to honey production, and changes in honey prices over time.

The dataset provided contains information on US honey consumption, including the average price of honey over the years. The aim is to explore and analyze this data to identify trends and patterns in the average honey price and gain insights into its fluctuation over time.

Find the state-wise production and state-wise average price for the top 5 and bottom 5 states, and visualize all four categories in a single figure.

Identify states that rarely contributed to honey production over the last 27 years.

Determine the top 5 honey-producing states in the US.

Analyze the change in the mean average price of honey from 1995 to 2021.

Identify the year when honey production in the whole US was the highest.

Determine which state had the highest contribution to honey production in the year 2000.

Identify states with the highest number of colonies in the year 2000.

Filename: US_honey_dataset.csv

Columns:

US-Honey Production Case study.pdf: Detailed description and problem statement of the case study.

Case_Study_US_Honey.ipynb: Jupyter notebook containing the code for data analysis and visualization.

US_honey_dataset.csv: Dataset used for the analysis.

The Jupyter notebook (Case_Study_US_Honey.ipynb) contains the following analyses and visualizations:

State-wise Production and Average Price:

Rare Contributors to Honey Production:

Top 5 Honey Producing States:

Change in Mean Average Price:

Year with Highest Honey Production:

State Contribution in 2000:

States with Highest Number of Colonies in 2000:

The results of the analysis, including visualizations, can be found in the Jupyter notebook. The key findings provide insights into the trends and patterns in US honey production and prices over the years.