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

CMPTR
3rd Edition
ISBN:9781337681872
Author:PINARD
Publisher:PINARD
Chapter6: Security And Privacy
Section: Chapter Questions
Problem 18QY
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
Recommended textbooks for you
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT