A Python Program with 10 menu choices. program could answer 1. Which states did not present data?2. What are the top five states in number of colonies, or pounds, or dollars.3. What are the top 5 states with the most prolific hives (defines as highest pounds/colony? Orby dollars/colony? Or both? )4. Which state gets the most money per pound of honey?5. Check for low outliers. States that are not prolific.6. Like are there more hives in states with higher average temperatures? Or days ofrainfall? Or some weather relation? 7. the average retail honey price and see what the mark up is.    BEE data - There is a line for each state that reported the presence of colonies in this given year state,# colonies,Pounds,DollarsAlabama,8000,112000,1917000Arizona,26000,368000,2434000Arkansas,17000,255000,1760000California,290000,1627000,22968000Colorado,29000,232000,3225000Florida,193000,849000,20551000Georgia,96000,261000,8911000Hawaii,15000,56000,3083000Idaho,100000,270000,7110000Illinois,10000,115000,2682000Indiana,10000,177000,2023000Iowa,38000,502000,5141000Kansas,7000,144000,806000Kentucky,7000,73000,1191000Louisiana,37000,205000,5365000Maine,11000,60000,1189000Michigan,101000,1957000,15298000Minnesota,125000,285000,16530000Mississippi,25000,71000,4917000Missouri,8000,92000,1117000Montana,117000,1934000,14472000Nebraska,39000,550000,3978000NewJersey,15000,158000,1717000NewYork,57000,665000,12537000NorthCarolina,13000,104000,3468000NorthDakota,515000,2266000,62032000Ohio,16000,389000,3789000Oregon,86000,693000,5705000Pennsylvania,20000,336000,2856000SouthCarolina,16000,67000,3575000SouthDakota,250000,5268000,27808000Tennessee,8000,81000,2240000Texas,137000,384000,17646000Utah,31000,92000,2230000Vermont,7000,76000,1079000Virginia,6000,79000,1975000Washington,96000,1206000,7741000WestVirginia,6000,136000,1238000Wisconsin,42000,750000,5547000Wyoming,38000,242000,4562000

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

A Python Program with 10 menu choices.

program could answer 
1. Which states did not present data?
2. What are the top five states in number of colonies, or pounds, or dollars.
3. What are the top 5 states with the most prolific hives (defines as highest pounds/colony? Or
by dollars/colony? Or both? )
4. Which state gets the most money per pound of honey?
5. Check for low outliers. States that are not prolific.
6. Like are there more hives in states with higher average temperatures? Or days of
rainfall? Or some weather relation? 
7. the average retail honey price and see what the mark up is. 

 

BEE data - There is a line for each state that reported the presence of colonies in this given year

state,# colonies,Pounds,Dollars
Alabama,8000,112000,1917000
Arizona,26000,368000,2434000
Arkansas,17000,255000,1760000
California,290000,1627000,22968000
Colorado,29000,232000,3225000
Florida,193000,849000,20551000
Georgia,96000,261000,8911000
Hawaii,15000,56000,3083000
Idaho,100000,270000,7110000
Illinois,10000,115000,2682000
Indiana,10000,177000,2023000
Iowa,38000,502000,5141000
Kansas,7000,144000,806000
Kentucky,7000,73000,1191000
Louisiana,37000,205000,5365000
Maine,11000,60000,1189000
Michigan,101000,1957000,15298000
Minnesota,125000,285000,16530000
Mississippi,25000,71000,4917000
Missouri,8000,92000,1117000
Montana,117000,1934000,14472000
Nebraska,39000,550000,3978000
NewJersey,15000,158000,1717000
NewYork,57000,665000,12537000
NorthCarolina,13000,104000,3468000
NorthDakota,515000,2266000,62032000
Ohio,16000,389000,3789000
Oregon,86000,693000,5705000
Pennsylvania,20000,336000,2856000
SouthCarolina,16000,67000,3575000
SouthDakota,250000,5268000,27808000
Tennessee,8000,81000,2240000
Texas,137000,384000,17646000
Utah,31000,92000,2230000
Vermont,7000,76000,1079000
Virginia,6000,79000,1975000
Washington,96000,1206000,7741000
WestVirginia,6000,136000,1238000
Wisconsin,42000,750000,5547000
Wyoming,38000,242000,4562000

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Operators
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education