Class 18, Wednesday, October 9

CSV Chrestomathics

Make sure what you know — Be sure you know what you know — Know now that you know

Look both ways

• Back and ahead

Agenda

• CSV chrestomathics

Aesthetics

• Be cool

Downloads

• Program where_is_it.py

• Program what_day_is_it.py

• Homework mins_and_maxes.py

To do

• Homework

• Review artifacts

Datasets de jeur

• continental-usa.csv

Zipcode, Town, State, Latitude, Longitude

00210, Portsmouth, NH, 43.005895, -71.013202

00211, Portsmouth, NH, 43.005895, -71.013202

00212, Portsmouth, NH, 43.005895, -71.013202

00213, Portsmouth, NH, 43.005895, -71.013202

00214, Portsmouth, NH, 43.005895, -71.013202

00215, Portsmouth, NH, 43.005895, -71.013202

00501, Holtsville, NY, 40.922326, -72.637078

00544, Holtsville, NY, 40.922326, -72.637078

01001, Agawam, MA, 42.07061, -72.62029

01002, Amherst, MA, 42.377651, -72.50323

01003, Amherst, MA, 42.369562, -72.63599

01004, Amherst, MA, 42.384494, -72.513191

01005, Barre, MA, 42.412094, -72.10443

....

• wdii.csv

ID, State, GWBD, Comment

AK, Alaska, Presidents' Day, 3rd Monday in February

AL, Alabama, George Washington-Thomas Jefferson Day, 3rd Monday in February

AR, Arkansas, George Washington's Birthday and Daisy Gatson Bates Day, 3rd Monday in February

AZ, Arizona, Lincoln-Washington-President's Day, 3rd Monday in February

CA, California, President's Day, 3rd Monday in February

CO, Colorado, Presidents' Day, 3rd Monday in February

CT, Connecticut, Washington's Birthday, 3rd Monday in February

DE, Delaware, No holiday observed, Non-applicable

FL, Florida, No holiday observed, Non-applicable

GA, Georgia, Washington's Birthday, Day before Christmas

....

Examples

• where_is_it.py

• Determines a rough estimate of the center of continental USA by making use of CSV dataset continental-usa.csv.

What are some ways to determine the estimate?

• ???

• what_day_is_it.py

• For a user-specified web source dataset counts the number of rows, where for a user-specied column of interest label, the column value equals a user-specified value key

Algorithm

• What should it be?

Two sample program runs

Enter name of dataset: wdii.csv

Enter column of interest: GWBD

Enter column value of interest: No holiday observed

9

Enter name of dataset: wdii.csv

Enter column of interest: When

Enter column value of interest: 3rd Monday in February

37

---

Lebanon, KS, 66952, 39°48′38″N 98°33′22″W

---

Test 1 histogram

---

Where am I

 

---

 

 

 
   
   
   
 

© 2019 Jim Cohoon

Resources from previous semesters are available.