Skip to content

Instantly share code, notes, and snippets.

View captainelaine's full-sized avatar

Zhou Fang captainelaine

View GitHub Profile
@captainelaine
captainelaine / Drivertotal.csv
Created April 10, 2016 22:05
Questions of data nest
Drivername 2000 Team2000 2001 Team2001 2002 Team2002 2003 Team2003 2004 Team2004 2005 Team2005 2006 Team2006
Michael Schumacher 108 Ferrari 123 Ferrari 144 Ferrari 93 Ferrari 148 Ferrari 62 Ferrari 121 Ferrari
Mika H_kkinen 89 McLaren 37 McLaren 41 McLaren 51 McLaren 24 McLaren 24 Red Bull 24 Red Bull
David Coulthard 73 McLaren 65 MaLaren
Rubens Barrichello 62 Ferrari 56 Ferrari 77 Ferrari 65 Ferrari 114 Ferrari 38 Ferrari 30 Honda
Ralf Schumacher 24 Williams 49 Williams 42 Williams 58 Williams 24 Williams
Giancarlo Fisichella 18 Benetton 8 Benetton 7 Jordan 12 Jordan 22 Red Bull 58 Renault 72 Renault
Jacques Villeneuve 17 BAR 12 BAR
Jenson Button 12 Williams 2 Benetton 14 Renault 17 BAR 85 BAR 37 BAR 56 Honda
Heinz-Harald Frentzen 11 Jordan 6 Jordan 2 Arrows 13 Sauber
@captainelaine
captainelaine / 2000-2006teampoint.csv
Created April 4, 2016 19:17
Week11: Final project data collected
Teamname 2000 20001 2002 2003 2004 2005 2006
Ferrari 179 179 221 158 262 100 201
McLaren 152 102 65 142 69 182 110
Williams 36 80 92 144 88 66 11
Benetton 20 10
BAR 20 17 7 26 119 38 86
Jordan 17 19 9 13 5 12
Sauber 6 21 11 19 34 20 36
Arrows 7 1 2
Minardi 0 0 2 0 1 7
@captainelaine
captainelaine / 2000year.csv
Created April 4, 2016 19:13
Week11: Map
IS0 Country WinOrNot Winner2000 Team2000
AUS Australia Won by Ferrari Michael Schumacher Ferrari
BRA Brazil Won by Ferrari Michael Schumacher Ferrari
SMR San Marino Won by Ferrari Michael Schumacher Ferrari
GBR Britain Won by other teams David Coulthard McLaren
ESP Spain Won by other teams Mika Hakkinen McLaren
DEU Germany��Europe�� Won by Ferrari Michael Schumacher Ferrari
MCO Monaco Won by other teams David Coulthard McLaren
CAN Canada Won by Ferrari Michael Schumacher Ferrari
FRA France Won by other teams David Coulthard McLaren
@captainelaine
captainelaine / 2011-2015fullseason.csv
Created March 28, 2016 16:33
Week 10, Small Multiples.
Year Driver Australian Malaysia Chinese Spanish Monaco Canadian British Hungaroring Belgian Italian Singapore Japanese Brazil Abu Dhabi
2015 Lewis Hamilton 25 18 25 18 15 25 25 8 25 25 0 25 18 18
2014 Lewis Hamilton 0 25 25 25 18 0 25 15 0 25 25 25 18 25
2013 Lewis Hamilton 10 15 15 0 12 15 12 25 15 2 10 0 2 6
2012 Lewis Hamilton 15 15 15 4 10 25 4 25 0 25 0 10 0 0
2011 Lewis Hamilton 18 4 25 18 8 0 12 12 0 12 10 10 0 25
2015 Nico Rosberg 18 15 18 25 25 18 18 4 18 0 12 18 25 25
2014 Nico Rosberg 25 18 18 18 25 18 0 12 18 18 0 18 25 0
2013 Nico Rosberg 0 12 0 8 25 10 25 0 12 8 12 4 10 15
2012 Nico Rosberg 0 0 25 6 18 8 0 1 0 6 10 0 0 0
@captainelaine
captainelaine / 2015season.csv
Last active March 21, 2016 15:43
Week9: Stacked Transition.
Country Mercedes Ferrari Williams Sauber Red_Bull Force_India Toro_Rosso McLaren Lotus
Australian 43 15 12 14 8 7 2 0 0
Malaysian 33 37 18 0 3 0 10 0 0
Chinese 43 27 18 5 2 0 0 0 6
Bahrain 40 28 13 0 10 4 0 0 6
Spanish 43 25 20 0 7 0 2 0 4
Monaco 40 26 0 2 22 6 1 4 0
Canadian 43 22 23 0 2 4 0 0 7
Austrian 43 12 25 0 1 10 4 0 6
British 43 19 22 0 8 8 0 1 0
@captainelaine
captainelaine / co2_emissions.csv
Created March 21, 2016 15:39
Week 9: JS homework
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 54 columns, instead of 27. in line 2.
countryName,countryCode,indicatorName,indicatorCode,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010
Afghanistan,AFG,CO2 emissions (kt),EN.ATM.CO2E.KT,491.378,689.396,707.731,839.743,1008.425,1092.766,1283.45,1224.778,942.419,1672.152,1895.839,1532.806,1639.149,1917.841,2126.86,1987.514,2390.884,2159.863,2240.537,1760.16,1983.847,2101.191,2522.896,2830.924,3509.319,3142.619,3124.284,2867.594,2775.919,2676.91,2493.56,1426.463,1375.125,1320.12,1268.782,1199.109,1114.768,1056.096,832.409,781.071,645.392,359.366,583.053,733.4,1015.759,1338.455,1991.181,3927.357,6523.593,8236.082
Albania,ALB,CO2 emissions (kt),EN.ATM.CO2E.KT,2280.874,2464.224,2082.856,2016.85,2174.531,2552.232,2680.577,3072.946,3245.295,3744.007,4352.729,5643.513,5291.481,4345.395,4594.751,4950.45,5720.52,6494.257,7587.023,5170.47,7341.334,7308.331,7
@captainelaine
captainelaine / deaths_04yearsold_2013percent.csv
Created March 14, 2016 18:11
Finished Bar Chart
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 11 columns, instead of 8. in line 7.
Country,Meningitis_encephalitis,Respiratory_infections,Sepsis,Pertussis,Malaria,Measles,Congenital_anomalies,HIV_AIDS,Diarrhoeal_diseases,Asphyxia_trauma
India,0.042488278,0.233534888,0.145938913,0.007182025,0.009314662,0.046933792,0.123114044,0.00663867,0.184781579,0.200073149
Democratic Republic of the Congo,0.040686134,0.221728479,0.075842245,0.01386753,0.212434283,0.06908283,0.048008834,0.02005919,0.150790387,0.147500089
Indonesia,0.025829262,0.27277861,0.106128312,0.01262,0.030445137,0.076689828,0.185003315,0.017677822,0.092133369,0.180694346
Pakistan,0.042190621,0.28618202,0.163435643,0.021985945,0.001921226,0.020857808,0.075568204,0.000843982,0.175454966,0.211559586
Nigeria,0.043200357,0.207813651,0.071262349,0.016492104,0.287175958,0.007996224,0.044873945,0.042612526,0.133019132,0.145553754
Ethiopia,0.034238059,0.262054587,0.115549659,0.028521607,0.043578469,0.034427597,0.081432904,0.034783927,0.140515542,0.22489765
Afghanistan,0.052876527,0.315089385,0.112120879,0.01908775,9.43381E-05,0.061885819,0.0
@captainelaine
captainelaine / f1driverwage.csv
Last active March 14, 2016 17:57
My Update Plot
Driver wage2015 point2015 Age CareerPoint CareerYear
Fernando Alonso 350 11 35 1778 15
Kimi Raikkonen 180 150 37 1174 15
Sebastian Vettel 280 278 29 1896 9
Lewis Hamilton 250 381 31 1867 9
Jenson Button 100 16 36 1214 16
Nico Rosberg 135 322 31 1209.5 10
Felipe Massa 40 121 35 1071 14
Nico Hulkenberg 40 58 29 290 6
Sergio Perez 40 78 26 266 5
@captainelaine
captainelaine / f1driverpoint_timeline.csv
Created February 27, 2016 20:07
Dots on Lines
Driver 2007 2008 2009 2010 2011 2012 2013 2014 2015
Lewis Hamilton 109 98 49 240 227 190 189 384 381
Nico Rosberg 20 17 34.5 142 89 93 171 317 322
Sebastian Vettel 6 35 84 256 392 281 397 167 278
Kimi Raikkonen 110 75 48 207 183 55 150
Felipe Massa 94 97 22 144 118 122 112 134 121
Nico Hulkenberg 22 63 51 96 58
Romain Grosjean 0 96 132 8 51
Jenson Button 6 3 95 214 270 188 73 126 16
Fernando Alonso 109 61 26 252 257 278 242 161 11
@captainelaine
captainelaine / f1teampoint.csv
Created February 27, 2016 20:06
Transition Plot
team 2009 2010 2011 2012 2013 2014 2015
RedBull 153.5 498 650 460 596 405 187
Ferrari 70 396 375 400 354 216 428
McLaren 71 454 497 378 122 181 27
Williams 34.5 69 5 76 5 320 257
Mercedes 172 214 165 142 360 701 703