{
"metadata": {
"name": "",
"signature": "sha256:ad9669b711b35b55304dd2e66a9a08e444f8d98651fabf0ca3a489354fcfdc06"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "heading",
"level": 1,
"metadata": {},
"source": [
"Examples of working with the data files"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"!ls data"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Basic Timing Data Protocol Overview.pdf F1 Qualifying.txt\r\n",
"F1 Practice.txt\t\t\t\t F1 Race.txt\r\n"
]
}
],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"!head -n 3 data/F1\\ Practice.txt"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"
\n", " | timestamp | \n", "time | \n", "classpos | \n", "classpos_colour | \n", "racingNumber | \n", "racingNumber_colour | \n", "name | \n", "name_colour | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "11:05:52.876 | \n", "11:05:52.876000 | \n", "1 | \n", "CYAN | \n", "20 | \n", "WHITE | \n", "K. MAGNUSSEN | \n", "WHITE | \n", "
1 | \n", "11:03:25.727 | \n", "11:03:25.727000 | \n", "2 | \n", "CYAN | \n", "25 | \n", "RED | \n", "J. VERGNE | \n", "WHITE | \n", "
2 | \n", "11:03:25.737 | \n", "11:03:25.737000 | \n", "3 | \n", "CYAN | \n", "4 | \n", "RED | \n", "M. CHILTON | \n", "WHITE | \n", "
3 | \n", "11:03:25.747 | \n", "11:03:25.747000 | \n", "4 | \n", "CYAN | \n", "27 | \n", "RED | \n", "N. HULKENBERG | \n", "WHITE | \n", "
4 | \n", "11:05:31.807 | \n", "11:05:31.807000 | \n", "5 | \n", "CYAN | \n", "99 | \n", "WHITE | \n", "A. SUTIL | \n", "WHITE | \n", "
5 | \n", "11:06:03.228 | \n", "11:06:03.228000 | \n", "6 | \n", "CYAN | \n", "9 | \n", "WHITE | \n", "M. ERICSSON | \n", "WHITE | \n", "
6 | \n", "11:03:25.779 | \n", "11:03:25.779000 | \n", "7 | \n", "CYAN | \n", "17 | \n", "RED | \n", "J. BIANCHI | \n", "WHITE | \n", "
7 | \n", "11:03:25.788 | \n", "11:03:25.788000 | \n", "8 | \n", "CYAN | \n", "26 | \n", "RED | \n", "D. KVYAT | \n", "WHITE | \n", "
8 | \n", "11:06:15.133 | \n", "11:06:15.133000 | \n", "9 | \n", "CYAN | \n", "8 | \n", "WHITE | \n", "R. GROSJEAN | \n", "WHITE | \n", "
9 | \n", "11:03:25.807 | \n", "11:03:25.807000 | \n", "10 | \n", "CYAN | \n", "77 | \n", "RED | \n", "V. BOTTAS | \n", "WHITE | \n", "
10 | \n", "11:03:25.816 | \n", "11:03:25.816000 | \n", "11 | \n", "CYAN | \n", "21 | \n", "RED | \n", "E. GUTIERREZ | \n", "WHITE | \n", "
11 | \n", "11:06:12.290 | \n", "11:06:12.290000 | \n", "12 | \n", "CYAN | \n", "1 | \n", "WHITE | \n", "S. VETTEL | \n", "WHITE | \n", "
12 | \n", "11:05:18.258 | \n", "11:05:18.258000 | \n", "13 | \n", "CYAN | \n", "10 | \n", "WHITE | \n", "K. KOBAYASHI | \n", "WHITE | \n", "
13 | \n", "11:03:25.855 | \n", "11:03:25.855000 | \n", "14 | \n", "CYAN | \n", "7 | \n", "RED | \n", "K. RAIKKONEN | \n", "WHITE | \n", "
14 | \n", "11:03:25.864 | \n", "11:03:25.864000 | \n", "15 | \n", "CYAN | \n", "22 | \n", "RED | \n", "J. BUTTON | \n", "WHITE | \n", "
15 | \n", "11:03:25.874 | \n", "11:03:25.874000 | \n", "16 | \n", "CYAN | \n", "13 | \n", "RED | \n", "P. MALDONADO | \n", "WHITE | \n", "
16 | \n", "11:03:25.881 | \n", "11:03:25.881000 | \n", "17 | \n", "CYAN | \n", "11 | \n", "RED | \n", "S. PEREZ | \n", "WHITE | \n", "
17 | \n", "11:03:25.906 | \n", "11:03:25.906000 | \n", "18 | \n", "CYAN | \n", "6 | \n", "RED | \n", "N. ROSBERG | \n", "WHITE | \n", "
18 | \n", "11:03:25.920 | \n", "11:03:25.920000 | \n", "19 | \n", "CYAN | \n", "14 | \n", "RED | \n", "F. ALONSO | \n", "WHITE | \n", "
19 | \n", "11:03:25.935 | \n", "11:03:25.935000 | \n", "20 | \n", "CYAN | \n", "44 | \n", "RED | \n", "L. HAMILTON | \n", "WHITE | \n", "
20 | \n", "11:03:25.945 | \n", "11:03:25.945000 | \n", "21 | \n", "CYAN | \n", "3 | \n", "RED | \n", "D. RICCIARDO | \n", "WHITE | \n", "
21 | \n", "11:00:06.703 | \n", "11:00:06.703000 | \n", "22 | \n", "CYAN | \n", "19 | \n", "RED | \n", "F. MASSA | \n", "WHITE | \n", "
22 | \n", "10:49:56.290 | \n", "10:49:56.290000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
23 | \n", "10:49:56.291 | \n", "10:49:56.291000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
24 | \n", "10:49:56.291 | \n", "10:49:56.291000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
25 | \n", "10:49:56.291 | \n", "10:49:56.291000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
26 | \n", "10:49:56.291 | \n", "10:49:56.291000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
27 | \n", "10:49:56.292 | \n", "10:49:56.292000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
28 | \n", "10:49:56.292 | \n", "10:49:56.292000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
29 | \n", "10:49:56.292 | \n", "10:49:56.292000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
30 | \n", "10:49:56.293 | \n", "10:49:56.293000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
31 | \n", "10:49:56.293 | \n", "10:49:56.293000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
32 | \n", "10:49:56.293 | \n", "10:49:56.293000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
33 | \n", "10:49:56.294 | \n", "10:49:56.294000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
34 | \n", "10:49:56.294 | \n", "10:49:56.294000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
35 | \n", "10:49:56.294 | \n", "10:49:56.294000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
36 | \n", "10:49:56.295 | \n", "10:49:56.295000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
37 | \n", "10:49:56.295 | \n", "10:49:56.295000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
38 | \n", "10:49:56.295 | \n", "10:49:56.295000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
39 | \n", "10:49:56.296 | \n", "10:49:56.296000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
40 | \n", "10:49:56.296 | \n", "10:49:56.296000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
41 | \n", "10:49:56.296 | \n", "10:49:56.296000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
42 | \n", "10:49:56.297 | \n", "10:49:56.297000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
43 | \n", "10:49:56.297 | \n", "10:49:56.297000 | \n", "\n", " | CYAN | \n", "\n", " | WHITE | \n", "\n", " | WHITE | \n", "
44 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
45 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
46 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
47 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
48 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
49 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "