Class 15, Monday, October 1
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
- Future criteria
Datasets de jeur
Name, Author, Language, Date, Sales
Don Quixote, de Cervantes, Spanish, 1605, 500000000
A Tale of Two Cities, Dickens, English, 1859, 200000000
The Lord of the Rings, Tolkien, English, 1954, 150000000
The Little Prince, de Saint-Exupery, French, 1943, 140000000
Harry Potter and the Philosopher's Stone, Rowling, English, 1997, 120000000
The Hobbit, Tolkien, English, 1937, 100000000
And Then There Were None, Christie, English, 1939, 100000000
Dream of the Red Chamber, Xueqin, Chinese, 1754, 100000000
Alice's Adventures in Wonderland, Carroll, English, 1865, 100000000
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.513183
01005, Barre, MA, 42.412094, -72.10443
....
Examples
- Determines a rough estimate of the center of continental USA by making use of CSV dataset continental-usa.csv.
- How should we determine the estimate?
- Presents the user-specified column of data from CSV dataset best-sellers.csv.
Two sample program runs
Enter column of interest: Language
Spanish
English
English
French
English
English
English
Chinese
English
Enter column of interest: sales
500000000
200000000
150000000
140000000
120000000
100000000
100000000
100000000
100000000
To do
- Review class artifacts
- Review standard documentation for built-in functions.
- Review course documentation for module str.
- Review course documentation for module list.
- Review course documentation for local module url.
- Review standard documentation for module math.
- Review ccourse documentation for module random.
- Epistle on syntax errors and exceptions.
- Epistle on accomplishments.
Another dataset
Name,Type,Population,Male,Female,Households,Housing Units,Owner-occupied
Accomack,County,38305,18590,19715,15299,19550,11482
Albemarle,County,79236,38002,41234,31876,33720,20991
Alleghany,County,12926,6450,6476,5149,5812,4369
Amelia,County,11400,5622,5778,4240,4609,3474
Amherst,County,31894,15208,16686,11941,12958,9325
Appomattox,County,13705,6671,7034,5322,5828,4315
Arlington,County,189453,95443,94010,86352,90426,37370
Augusta,County,65615,32995,32620,24818,26738,20628
...
© 2019 Jim Cohoon | Resources from previous semesters are available. |