INFO 101 – Homework 3

There are two parts to this assignment: one asks you to find information in a file and the other asks to find information online

FILE

  • Use one of two files in D2l Content: milk_production_csv.csv or milk_production_xls.xls
  • Open and read the file to find this information:
    • The difference in the production numbers in South Dakota for 1972 and 1982
    • Find the average of all the amounts in the Delta States.
    • Find and print the three lowest numbers in Georgia.
    • Graph the results from Georgia. Use your choice of a line graph, bar graph, or pie chart.

WEB

  • Open the website that gives access to ebooks. The url will be in this format: http://www.gutenberg.org/2000/2000.txt The number 2000 is the place where the actual number of the book is located. Search through the site looking for book numbers. When you find a valid book, print the first 300 characters.

    Since you don’t know what the valid book numbers are, you could use random numbers for the book numbers. If you do not find a book with a certain random number, you could do one of two things: not print anything or print a message that that number is not valid.

    Ask the user how many books they want to look for. Supply that many random numbers. As an example, if you search for five books and you find three non-valid numbers, ignore the three and make sure you find five that you wanted.

Both parts can be in one program. Use any tools you need to find your information (loops, if statements, functions, modules, Pandas, Numpy).

General Requirements

  • Comment header
  • Comments throughout
  • Use variables
  • No unhandled exceptions
  • Obviously, the correct answers. They can be printed in any manner you like.

The assignment is due on Monday, May 8.

Sample Output:

THE MILK PRODUCTION SECTION

South Dakota’s 1982 total is 1,821,000 pounds greater than the 1972 total.

The average production in the Delta States is 11,245.20 pounds.

The three lowest amounts in Georgia are 8096 8137 8517

THE GUTENBERG SECTION

How many books would you like to print? 3

BOOD ID 7456

This ID number does not exist. Trying another.

************************************************************

BOOD ID 6085

The Project Gutenberg EBook of The Code of Honor, by John Lyde Wilson

This eBook is for the use of anyone anywhere at no cost and with

almost no restrictions whatsoever. You may copy it, give it away or

re-use it under the terms of the Project Gutenberg License included

with this eBook or onl

************************************************************

BOOD ID 5549

The Project Gutenberg EBook In The Fire Of The Forge, by Georg Ebers, v7

#110 in our series by Georg Ebers

Copyright laws are changing all over the world. Be sure to check the

copyright laws for your country before downloading or redistributing

this or any other Project Gutenberg eBook.

Thi

************************************************************

BOOD ID 8981

This ID number does not exist. Trying another.

************************************************************

BOOD ID 4558

The Project Gutenberg EBook of Barry Lyndon, by William Makepeace Thackeray

This eBook is for the use of anyone anywhere at no cost and with

almost no restrictions whatsoever. You may copy it, give it away or

re-use it under the terms of the Project Gutenberg License included

with this eBook

************************************************************

Subscribe For Latest Updates
Let us notify you each time there is a new assignment, book recommendation, assignment resource, or free essay and updates