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
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
- Review artifacts
Datasets de jeur
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
....
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
- 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?
- ???
- 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.