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


Aesthetics


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

  • How should we determine the estimate?

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


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

...