Skip to content

Instantly share code, notes, and snippets.

DRIVER_NAME DRIVER_COUNTRY DRIVER_NUMBER_2015 TEAM_NAME_2015 RACE_ID_2015 DRIVER_NUMBER_2014 TEAM_NAME_2014 RACE_ID_2014
Sebastian Vettel Germany 5 Ferrari 1 1 Red Bull 2
Kimi Raikkonen Finland 7 Ferrari 1 7 Ferrari 2
Lewis Hamilton United Kindom 44 Mercedes 1 44 Mercedes 2
Nico Rosberg Germany 6 Mercedes 1 6 Mercedes 2
Fernando Alonso Spain 14 McLaren 1 14 Ferrari 2
Jenson Button United Kindom 22 McLaren 1 22 McLaren 2
Kevin Magnussen Spain 0 NULL 0 20 McLaren 2
Felipe Massa Brasil 19 Williams 1 19 Williams 2
Valtteri Bottas Finland 77 Williams 1 77 Williams 2
TEAM_ID TEAM_NAME TEAM_COUNTRY PRIMO_ANNO SECONDO_ANNO
1 Ferrari Italy 2015 2014
2 Mercedes Germany 2015 2014
3 McLaren United Kindom 2015 2014
4 Williams United Kindom 2015 2014
5 Lotus United Kindom 2015 2014
6 Sauber Switzerland 2015 2014
7 Red Bull Austria 2015 2014
8 Toro Rosso Italy 2015 2014
9 Force India India 2015 2014
RACE_ID RACE_NAME RACE_YEAR RACE_FROM RACE_TO RACE_NUMBER_OF_GRAND_PRIX RACE_EDITION
1 F1 2015 2015 15/03/2015 29/11/2015 19 66
2 F1 2014 2014 16/03/2014 23/11/2014 19 65
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 13 columns, instead of 9 in line 9.
GRAND_PRIX_NAME,GRAND_PRIX_CITY,GRAND_PRIX_COUNTRY,RACE_ID_2015,GRAND_PRIX_NUMBER_2015,GRAND_PRIX_DATE_2015,GRAND_PRIX_DISTANCE_2015,GRAND_PRIX_LAP_2015,RACE_ID_2014,GRAND_PRIX_NUMBER_2014,GRAND_PRIX_DATE_2014,GRAND_PRIX_DISTANCE_2014,GRAND_PRIX_LAP_2014
Australian Grand Prix,Melbourne,Australia,1,1,15/3/2015,307.57,58,2,1,16/03/2014,302.27,57
Malaysia Gran Prix,Kuala Lumpur,Malaysia,1,2,29/3/2015,310.4,56,2,2,30/03/2014,310.4,56
Chinese Grand Prix,Shanghai,China,1,3,12/4/2015,305.06,56,2,3,20/04/2014,294.16,54
Bharain Grand Prix,Sakhir,Bahrain,1,4,19/4/2015,308.23,57,2,4,6/4/2014,308.23,57
Grand Premio de Espana,Barcelone,Spain,1,5,10/5/2015,307.1,66,2,5,11/5/2014,307.1,66
Grand Prix Automobile de Monaco,Monaco,Monaco,1,6,24/5/2015,260.28,78,2,6,25/05/2014,260.52,78
Grand Prix du Canada,Montreal,Canada,1,7,7/6/2015,305.27,70,2,7,8/6/2014,305.27,70
Grosser Preis von Osterreich,Spielberg,Austria,1,8,21/6/2015,307.02,71,2,8,22/6/2014,307.02,71
British Grand Prix,Silverstone,United Kindom,1,9,5/7/2015,306.19,52,
RACE_ID GRAND_PRIX_NUMBER RISULTATO PUNTI DRIVER_NUMBER
1 1 1ST 25 44
1 1 2ND 18 6
1 1 3RD 15 5
1 1 4TH 12 19
1 1 5TH 10 12
1 1 6TH 8 3
1 1 7TH 6 27
1 1 8TH 4 9
1 1 9TH 2 55
DRIVER_NAME DRIVER_COUNTRY DRIVER_NUMBER_2015 TEAM_NAME_2015 RACE_ID_2015 DRIVER_NUMBER_2014 TEAM_NAME_2014 RACE_ID_2014 DRIVER_NUMBER_2013 TEAM_NAME_2013 RACE_ID_2013 DRIVER_NUMBER_2012 TEAM_NAME_2012 RACE_ID_2012 DRIVER_NUMBER_2011 TEAM_NAME_2011 RACE_ID_2011
Sebastian Vettel Germany 5 Ferrari 1 1 Red Bull 2 1 Red Bull 3 1 Red Bull 4 1 Red Bull 5
Kimi Raikkonen Finland 7 Ferrari 1 7 Ferrari 2 7 Lotus 3 9 Lotus 4 0 NULL 0
Lewis Hamilton United Kindom 44 Mercedes 1 44 Mercedes 2 10 Mercedes 3 4 McLaren 4 3 McLaren 5
Nico Rosberg Germany 6 Mercedes 1 6 Mercedes 2 9 Mercedes 3 8 Mercedes 4 8 Mercedes 5
Fernando Alonso Spain 14 McLaren 1 14 Ferrari 2 3 Ferrari 3 5 Ferrari 4 5 Ferrari 5
Jenson Button United Kindom 22 McLaren 1 22 McLaren 2 5 McLaren 3 3 McLaren 4 4 McLaren 5
Kevin Magnussen Spain 0 NULL 0 20 McLaren 2 0 NULL 0 0 NULL 0 0 NULL 0
Felipe Massa Brasil 19 Williams 1 19 Williams 2 4 Ferrari 3 6 Ferrari 4 6 Ferrari 5
Valtteri Bottas Finland 77 Williams 1 77 Williams 2 17 Williams 3 0 NULL 0 0 NULL 0
TEAM_ID TEAM_NAME TEAM_COUNTRY PRIMO_ANNO SECONDO_ANNO TERZO_ANNO QUARTO_ANNO QUINTO_ANNO
1 Ferrari Italy 2015 2014 2013 2012 2011
2 Mercedes Germany 2015 2014 2013 2012 2011
3 McLaren United Kindom 2015 2014 2013 2012 2011
4 Williams United Kindom 2015 2014 2013 2012 2011
5 Lotus United Kindom 2015 2014 2013 2012 2011
6 Sauber Switzerland 2015 2014 2013 2012 2011
7 Red Bull Austria 2015 2014 2013 2012 2011
8 Toro Rosso Italy 2015 2014 2013 2012 2011
9 Force India India 2015 2014 2013 2012 2011
RACE_ID RACE_NAME RACE_YEAR RACE_FROM RACE_TO RACE_NUMBER_OF_GRAND_PRIX RACE_EDITION
1 F1 2015 2015 15/03/2015 29/11/2015 19 66
2 F1 2014 2014 16/03/2014 23/11/2014 19 65
3 F1 2013 2013 17/03/2013 24/11/2013 19 64
4 F1 2012 2012 18/03/2012 25/11/2012 20 63
5 F1 2011 2011 27/03/2011 27/11/2011 19 62
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 28 columns, instead of 26 in line 3.
GRAND_PRIX_NAME,GRAND_PRIX_CITY,GRAND_PRIX_COUNTRY,RACE_ID_2015,GRAND_PRIX_NUMBER_2015,GRAND_PRIX_DATE_2015,GRAND_PRIX_DISTANCE_2015,GRAND_PRIX_LAP_2015,RACE_ID_2014,GRAND_PRIX_NUMBER_2014,GRAND_PRIX_DATE_2014,GRAND_PRIX_DISTANCE_2014,GRAND_PRIX_LAP_2014,RACE_ID_2013,GRAND_PRIX_NUMBER_2013,GRAND_PRIX_DATE_2013,GRAND_PRIX_DISTANCE_2013,GRAND_PRIX_LAP_2013,RACE_ID_2012,GRAND_PRIX_NUMBER_2012,GRAND_PRIX_DATE_2012,GRAND_PRIX_DISTANCE_2012,GRAND_PRIX_LAP_2012,RACE_ID_2011,GRAND_PRIX_NUMBER_2011,GRAND_PRIX_DATE_2011,GRAND_PRIX_DISTANCE_2011,GRAND_PRIX_LAP_2011
Australian Grand Prix,Melbourne,Australia,1,1,15/3/2015,307.57,58,2,1,16/03/2014,302.27,57,3,1,17/03/2013,307.57,58,4,1,18/3/2012,307.57,58,5,1,27/03/2011,307.57,58
Malaysia Gran Prix,Kuala Lumpur,Malaysia,1,2,29/3/2015,310.4,56,2,2,30/03/2014,310.4,56,3,2,24/03/2013,310.4,56,4,2,25/3/2012,310.4,56,5,2,10/4/2011,310.4,56
Chinese Grand Prix,Shanghai,China,1,3,12/4/2015,305.06,56,2,3,20/04/2014,294.16,54,3,3,14/4/2013,305.06,56,4,3,15/4/2012,305.06,56,5,3,17/04
RACE_ID GRAND_PRIX_NUMBER RISULTATO PUNTI DRIVER_NUMBER
1 1 1ST 25 44
1 1 2ND 18 6
1 1 3RD 15 5
1 1 4TH 12 19
1 1 5TH 10 12
1 1 6TH 8 3
1 1 7TH 6 27
1 1 8TH 4 9
1 1 9TH 2 55