Assignment – Advance Python [Major]

At Programming Homework Tutors, we believe in providing our students with practical, real-world examples of how to apply the concepts they learn in class. That’s why we’ve developed a variety of sample projects to help you see how our courses can be used to create impactful solutions in your field of study.

Topic: To visualize how honey production is changed over the years (1998-2021) in the United States.

Background

In 2006, global concern was raised over the rapid decline in the honeybee population, an integral component of American honey agriculture. Large numbers of hives were lost to Colony Collapse Disorder, a phenomenon of disappearing worker bees causing the remaining hive colony to collapse. Speculation as to the cause of this disorder points to hive diseases and pesticides harming the pollinators, though no overall consensus has been reached. The U.S. used to locally produce over half the honey it consumes per year. Now, honey mostly comes from overseas, with 350 of the 400 million pounds of honey consumed every year originating from imports. This

dataset provides insight into honey production supply and demand in America from 1998 to 2021.

Objective:

To visualize how honey production has changed over the years (1998-2021) in the United States.

Key questions to be answered:

How has honey production yield changed from 1998 to 2021?

Over time, what are the major production trends across the states?

Does the data show any trends in terms of the number of honey producing colonies and yield per colony before 2006, which was when concern over Colony Collapse Disorder spread nationwide?

Are there any patterns that can be observed between total honey production and value of production every year?

How has the value of production, which in some sense could be tied to demand, changed every year?

Constructs the related plots using Seaborn and Matplot apply customization and derive insights from the visualization.

Dataset:

state: Various states of the U.S.

numcol: Number of honey-producing colonies. Honey producing colonies are the maximum number of colonies from which honey was taken during the year. It is possible to take honey from colonies that did not survive the entire year yieldpercol: Honey yield per colony. Unit is pounds totalprod: Total production (numcol x yieldpercol). Unit is pounds stocks: Refers to stocks held by producers. Unit is pounds

priceperlb: Refers to average price per pound based on expanded sales. The unit is dollars.

prodvalue: Value of production (totalprod x priceperlb). The unit is dollars.

year: Year of production.