Missing Values#
Missing values occur when no data value is stored for the variable in an observation and are most often represented with a NULL or None. Not handling them can lead to unexpected results (for example, some ML algorithms can’t handle missing values at all) and worse, it can lead to incorrect conclusions.
There are 3 main types of missing values:
MCAR (Missing Completely at Random) : The events that lead to any particular data-item being missing occur entirely at random. For example, in IOT, we can lose sensory data in transmission.
MAR (Missing {Conditionally} at Random) : Missing data doesn’t happen at random and is instead related to some of the observed data. For example, some students may have not answered to some specific questions of a test because they were absent during the relevant lesson.
MNAR (Missing not at Random) : The value of the variable that’s missing is related to the reason it’s missing. For example, if someone didn’t subscribe to a loyalty program, we can leave the cell empty.
Different types of missing values tend to suggest different methods for imputing them. For example, when dealing with MCAR values, you can use mathematical aggregations to impute the missing values. For MNAR values, we can simply create another category. MAR values, however, we’ll need to do some more investigation before deciding how to impute the data.
To see how to handle missing values in VerticaPy, we’ll use the well-known ‘Titanic’ dataset.
[64]:
from verticapy.datasets import load_titanic
vdf = load_titanic()
display(vdf)
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc home.destVarchar(100) | |
1 | 1 | 0 | female | 2.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | |
2 | 1 | 0 | male | 30.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | 135 | Montreal, PQ / Chesterville, ON | |
3 | 1 | 0 | female | 25.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | |
4 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | Belfast, NI | |
5 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | Montevideo, Uruguay | |
6 | 1 | 0 | male | 47.0 | 1 | 0 | PC 17757 | 227.525 | C62 C64 | C | [null] | 124 | New York, NY | |
7 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | New York, NY | |
8 | 1 | 0 | male | 24.0 | 0 | 1 | PC 17558 | 247.5208 | B58 B60 | C | [null] | [null] | Montreal, PQ | |
9 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | Winnipeg, MN | |
10 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | San Francisco, CA | |
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | Trenton, NJ | |
12 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | London / Winnipeg, MB | |
13 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | Pomeroy, WA | |
14 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | Omaha, NE | |
15 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | Philadelphia, PA | |
16 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | Washington, DC | |
17 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | [null] | |
18 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | New York, NY | |
19 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | |
20 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | |
21 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | Ascot, Berkshire / Rochester, NY | |
22 | 1 | 0 | male | 36.0 | 1 | 0 | 19877 | 78.85 | C46 | S | [null] | 172 | Little Onn Hall, Staffs | |
23 | 1 | 0 | male | 46.0 | 1 | 0 | W.E.P. 5734 | 61.175 | E31 | S | [null] | [null] | Amenia, ND | |
24 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | Liverpool, England / Belfast | |
25 | 1 | 0 | male | 27.0 | 1 | 0 | 13508 | 136.7792 | C89 | C | [null] | [null] | Los Angeles, CA | |
26 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | Stoughton, MA | |
27 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | Victoria, BC | |
28 | 1 | 0 | male | 37.0 | 1 | 1 | PC 17756 | 83.1583 | E52 | C | [null] | [null] | Lakewood, NJ | |
29 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | Roachdale, IN | |
30 | 1 | 0 | male | 70.0 | 1 | 1 | WE/P 5735 | 71.0 | B22 | S | [null] | 269 | Milwaukee, WI | |
31 | 1 | 0 | male | 39.0 | 1 | 0 | PC 17599 | 71.2833 | C85 | C | [null] | [null] | New York, NY | |
32 | 1 | 0 | male | 31.0 | 1 | 0 | F.C. 12750 | 52.0 | B71 | S | [null] | [null] | Montreal, PQ | |
33 | 1 | 0 | male | 50.0 | 1 | 0 | PC 17761 | 106.425 | C86 | C | [null] | 62 | Deephaven, MN / Cedar Rapids, IA | |
34 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | Philadelphia, PA | |
35 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | New York, NY | |
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | [null] | |
37 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | New York, NY | |
38 | 1 | 0 | male | 19.0 | 3 | 2 | 19950 | 263.0 | C23 C25 C27 | S | [null] | [null] | Winnipeg, MB | |
39 | 1 | 0 | male | 64.0 | 1 | 4 | 19950 | 263.0 | C23 C25 C27 | S | [null] | [null] | Winnipeg, MB | |
40 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | Westcliff-on-Sea, Essex | |
41 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | [null] | |
42 | 1 | 0 | male | 37.0 | 1 | 0 | 113803 | 53.1 | C123 | S | [null] | [null] | Scituate, MA | |
43 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | St Anne's-on-Sea, Lancashire | |
44 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | [null] | |
45 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | New York, NY | |
46 | 1 | 0 | male | 38.0 | 0 | 1 | PC 17582 | 153.4625 | C91 | S | [null] | 147 | Winnipeg, MB | |
47 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | New York, NY | |
48 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | [null] | |
49 | 1 | 0 | male | 45.0 | 1 | 0 | 36973 | 83.475 | C83 | S | [null] | [null] | New York, NY | |
50 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | [null] | |
51 | 1 | 0 | male | 55.0 | 1 | 1 | 12749 | 93.5 | B69 | S | [null] | 307 | Montreal, PQ | |
52 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | London / Middlesex | |
53 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | Brighton, MA | |
54 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | London / Birmingham | |
55 | 1 | 0 | male | 42.0 | 1 | 0 | 113789 | 52.0 | [null] | S | [null] | 38 | New York, NY | |
56 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | New York, NY | |
57 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | Paris, France New York, NY | |
58 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | Bennington, VT | |
59 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | London | |
60 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | [null] | |
61 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | Buffalo, NY | |
62 | 1 | 0 | male | 41.0 | 1 | 0 | 17464 | 51.8625 | D21 | S | [null] | [null] | Southington / Noank, CT | |
63 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | Portland, OR | |
64 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | Chicago, IL | |
65 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | Springfield, MA | |
66 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | London / New York, NY | |
67 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | Brockton, MA | |
68 | 1 | 0 | male | 19.0 | 1 | 0 | 113773 | 53.1 | D30 | S | [null] | [null] | New York, NY | |
69 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | Vancouver, BC | |
70 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | Dorchester, MA | |
71 | 1 | 0 | male | 28.0 | 1 | 0 | PC 17604 | 82.1708 | [null] | C | [null] | [null] | New York, NY | |
72 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | East Bridgewater, MA | |
73 | 1 | 0 | male | 44.0 | 2 | 0 | 19928 | 90.0 | C78 | Q | [null] | 230 | Fond du Lac, WI | |
74 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | Montreal, PQ | |
75 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | Washington, DC | |
76 | 1 | 0 | male | 37.0 | 0 | 1 | PC 17596 | 29.7 | C118 | C | [null] | [null] | Brooklyn, NY | |
77 | 1 | 0 | male | 58.0 | 0 | 2 | 35273 | 113.275 | D48 | C | [null] | 122 | Lexington, MA | |
78 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | Isle of Wight, England | |
79 | 1 | 0 | male | 65.0 | 0 | 1 | 113509 | 61.9792 | B30 | C | [null] | 234 | Providence, RI | |
80 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | ?Havana, Cuba | |
81 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | Belfast | |
82 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | Surbiton Hill, Surrey | |
83 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | Montreal, PQ | |
84 | 1 | 0 | male | 29.0 | 1 | 0 | 113776 | 66.6 | C2 | S | [null] | [null] | Isleworth, England | |
85 | 1 | 0 | male | 18.0 | 1 | 0 | PC 17758 | 108.9 | C65 | C | [null] | [null] | Madrid, Spain | |
86 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | Worcester, MA | |
87 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | Rotterdam, Netherlands | |
88 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | [null] | |
89 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | [null] | |
90 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | Trenton, NJ | |
91 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | Seattle, WA | |
92 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | Winnipeg, MB | |
93 | 1 | 0 | male | 55.0 | 1 | 0 | PC 17603 | 59.4 | [null] | C | [null] | [null] | New York, NY | |
94 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | London | |
95 | 1 | 0 | male | 61.0 | 1 | 3 | PC 17608 | 262.375 | B57 B59 B63 B66 | C | [null] | [null] | Haverford, PA / Cooperstown, NY | |
96 | 1 | 0 | male | 50.0 | 1 | 0 | 13507 | 55.9 | E44 | S | [null] | [null] | Duluth, MN | |
97 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | New York, NY | |
98 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | St James, Long Island, NY | |
99 | 1 | 0 | male | 24.0 | 1 | 0 | 13695 | 60.0 | C31 | S | [null] | [null] | Huntington, WV | |
100 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | Streatham, Surrey |
We can examine the missing values with the ‘count’ method.
[66]:
vdf.count_percent()
[66]:
count | percent | |
"pclass" | 1234.0 | 100.0 |
"survived" | 1234.0 | 100.0 |
"name" | 1234.0 | 100.0 |
"sex" | 1234.0 | 100.0 |
"sibsp" | 1234.0 | 100.0 |
"parch" | 1234.0 | 100.0 |
"ticket" | 1234.0 | 100.0 |
"fare" | 1233.0 | 99.919 |
"embarked" | 1232.0 | 99.838 |
"age" | 997.0 | 80.794 |
"home.dest" | 706.0 | 57.212 |
"boat" | 439.0 | 35.575 |
"cabin" | 286.0 | 23.177 |
"body" | 118.0 | 9.562 |
The missing values for ‘boat’ are MNAR; missing values simply indicate that the passengers didn’t pay for a lifeboat. We can replace all the missing values with a new category ‘No Lifeboat’ using the ‘fillna’ method.
[67]:
vdf["boat"].fillna("No Lifeboat")
vdf["boat"]
795 elements were filled.
[67]:
Abc boatVarchar(100) | |
1 | No Lifeboat |
2 | No Lifeboat |
3 | No Lifeboat |
4 | No Lifeboat |
5 | No Lifeboat |
6 | No Lifeboat |
7 | No Lifeboat |
8 | No Lifeboat |
9 | A |
10 | No Lifeboat |
11 | No Lifeboat |
12 | No Lifeboat |
13 | No Lifeboat |
14 | No Lifeboat |
15 | No Lifeboat |
16 | No Lifeboat |
17 | No Lifeboat |
18 | No Lifeboat |
19 | No Lifeboat |
20 | No Lifeboat |
21 | No Lifeboat |
22 | No Lifeboat |
23 | No Lifeboat |
24 | No Lifeboat |
25 | No Lifeboat |
26 | No Lifeboat |
27 | No Lifeboat |
28 | No Lifeboat |
29 | No Lifeboat |
30 | No Lifeboat |
31 | No Lifeboat |
32 | No Lifeboat |
33 | No Lifeboat |
34 | No Lifeboat |
35 | No Lifeboat |
36 | No Lifeboat |
37 | No Lifeboat |
38 | No Lifeboat |
39 | No Lifeboat |
40 | No Lifeboat |
41 | No Lifeboat |
42 | No Lifeboat |
43 | No Lifeboat |
44 | No Lifeboat |
45 | No Lifeboat |
46 | No Lifeboat |
47 | No Lifeboat |
48 | No Lifeboat |
49 | No Lifeboat |
50 | No Lifeboat |
51 | No Lifeboat |
52 | No Lifeboat |
53 | No Lifeboat |
54 | No Lifeboat |
55 | No Lifeboat |
56 | 14 |
57 | No Lifeboat |
58 | No Lifeboat |
59 | No Lifeboat |
60 | No Lifeboat |
61 | No Lifeboat |
62 | No Lifeboat |
63 | No Lifeboat |
64 | No Lifeboat |
65 | No Lifeboat |
66 | No Lifeboat |
67 | No Lifeboat |
68 | No Lifeboat |
69 | No Lifeboat |
70 | No Lifeboat |
71 | No Lifeboat |
72 | No Lifeboat |
73 | No Lifeboat |
74 | No Lifeboat |
75 | No Lifeboat |
76 | No Lifeboat |
77 | No Lifeboat |
78 | No Lifeboat |
79 | No Lifeboat |
80 | No Lifeboat |
81 | No Lifeboat |
82 | No Lifeboat |
83 | No Lifeboat |
84 | No Lifeboat |
85 | No Lifeboat |
86 | No Lifeboat |
87 | No Lifeboat |
88 | No Lifeboat |
89 | No Lifeboat |
90 | No Lifeboat |
91 | No Lifeboat |
92 | No Lifeboat |
93 | No Lifeboat |
94 | No Lifeboat |
95 | No Lifeboat |
96 | No Lifeboat |
97 | No Lifeboat |
98 | No Lifeboat |
99 | No Lifeboat |
100 | No Lifeboat |
Missing values for ‘age’ seem to be MCAR, so the best way to impute them is with mathematical aggregations. Let’s impute the age using the average age of passengers of the same sex and class.
[68]:
vdf["age"].fillna(method = "avg",
by = ["pclass", "sex"])
vdf["age"]
237 elements were filled.
[68]:
123 ageFloat | |
1 | 36.0 |
2 | 31.0 |
3 | 21.0 |
4 | 50.0 |
5 | 45.0 |
6 | 31.0 |
7 | 55.0 |
8 | 60.0 |
9 | 35.0 |
10 | 37.2635658914729 |
11 | 39.0 |
12 | 37.2635658914729 |
13 | 39.0 |
14 | 18.0 |
15 | 48.0 |
16 | 62.0 |
17 | 52.0 |
18 | 43.0 |
19 | 37.2635658914729 |
20 | 40.0 |
21 | 23.0 |
22 | 18.0 |
23 | 39.0 |
24 | 40.0 |
25 | 30.0 |
26 | 35.0 |
27 | 24.0 |
28 | 48.0 |
29 | 18.0 |
30 | 54.0 |
31 | 33.0 |
32 | 33.0 |
33 | 43.0 |
34 | 56.0 |
35 | 30.0 |
36 | 17.0 |
37 | 22.0 |
38 | 22.0 |
39 | 39.0 |
40 | 19.0 |
41 | 23.0 |
42 | 31.0 |
43 | 37.0 |
44 | 33.0 |
45 | 37.2635658914729 |
46 | 18.0 |
47 | 16.0 |
48 | 15.0 |
49 | 58.0 |
50 | 21.0 |
51 | 51.0 |
52 | 16.0 |
53 | 55.0 |
54 | 49.0 |
55 | 30.0 |
56 | 39.0 |
57 | 45.0 |
58 | 37.2635658914729 |
59 | 38.0 |
60 | 35.0 |
61 | 35.0 |
62 | 51.0 |
63 | 44.0 |
64 | 16.0 |
65 | 52.0 |
66 | 24.0 |
67 | 35.0 |
68 | 49.0 |
69 | 25.0 |
70 | 45.0 |
71 | 58.0 |
72 | 19.0 |
73 | 37.2635658914729 |
74 | 45.0 |
75 | 22.0 |
76 | 35.0 |
77 | 35.0 |
78 | 48.0 |
79 | 22.0 |
80 | 37.2635658914729 |
81 | 30.0 |
82 | 60.0 |
83 | 23.0 |
84 | 28.0 |
85 | 24.0 |
86 | 37.2635658914729 |
87 | 37.2635658914729 |
88 | 54.0 |
89 | 38.0 |
90 | 23.0 |
91 | 48.0 |
92 | 27.0 |
93 | 54.0 |
94 | 17.0 |
95 | 27.0 |
96 | 33.0 |
97 | 38.0 |
98 | 64.0 |
99 | 36.0 |
100 | 55.0 |
The features ‘embarked’ and ‘fare’ have a couple missing values. Instead of using a technique to impute them, we can just drop them with the ‘dropna’ method.
[69]:
vdf["fare"].dropna()
vdf["embarked"].dropna()
1 element was filtered.
2 elements were filtered.
[69]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | |
1 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17760 | 135.6333 | C32 | C | 8 | [null] | ||
2 | 1 | 1 | female | 31.0 | 0 | 0 | 16966 | 134.5 | E39 E41 | C | 3 | [null] | ||
3 | 1 | 1 | female | 21.0 | 0 | 0 | 113795 | 26.55 | [null] | S | 8 10 | [null] | ||
4 | 1 | 1 | female | 50.0 | 1 | 1 | 113503 | 211.5 | C80 | C | 4 | [null] | ||
5 | 1 | 1 | female | 45.0 | 1 | 1 | 36928 | 164.8667 | [null] | S | 8 | [null] | ||
6 | 1 | 1 | female | 31.0 | 0 | 2 | 36928 | 164.8667 | C7 | S | 8 | [null] | ||
7 | 1 | 1 | female | 55.0 | 0 | 0 | PC 17760 | 135.6333 | C32 | C | 8 | [null] | ||
8 | 1 | 1 | female | 60.0 | 1 | 0 | 110813 | 75.25 | D37 | C | 5 | [null] | ||
9 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17755 | 512.3292 | [null] | C | 3 | [null] | ||
10 | 1 | 1 | female | 37.2635658914729 | 0 | 0 | PC 17585 | 79.2 | [null] | C | D | [null] | ||
11 | 1 | 1 | female | 39.0 | 1 | 1 | 17421 | 110.8833 | C68 | C | 4 | [null] | ||
12 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | 19996 | 52.0 | C126 | S | 5 7 | [null] | ||
13 | 1 | 1 | female | 39.0 | 1 | 1 | 110413 | 79.65 | E67 | S | 8 | [null] | ||
14 | 1 | 1 | female | 18.0 | 0 | 2 | 110413 | 79.65 | E68 | S | 8 | [null] | ||
15 | 1 | 1 | female | 48.0 | 0 | 0 | 17466 | 25.9292 | D17 | S | 8 | [null] | ||
16 | 1 | 1 | female | 52.0 | 1 | 0 | 36947 | 78.2667 | D20 | C | 4 | [null] | ||
17 | 1 | 1 | female | 43.0 | 1 | 0 | 11778 | 55.4417 | C116 | C | 5 | [null] | ||
18 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | PC 17569 | 146.5208 | B78 | C | 6 | [null] | ||
19 | 1 | 1 | female | 40.0 | 1 | 1 | 16966 | 134.5 | E34 | C | 3 | [null] | ||
20 | 1 | 1 | female | 23.0 | 1 | 0 | 21228 | 82.2667 | B45 | S | 7 | [null] | ||
21 | 1 | 1 | female | 18.0 | 1 | 0 | 13695 | 60.0 | C31 | S | 6 | [null] | ||
22 | 1 | 1 | female | 39.0 | 1 | 0 | 13507 | 55.9 | E44 | S | 11 | [null] | ||
23 | 1 | 1 | female | 40.0 | 0 | 0 | PC 17582 | 153.4625 | C125 | S | 3 | [null] | ||
24 | 1 | 1 | female | 30.0 | 0 | 0 | 113798 | 31.0 | [null] | C | 4 | [null] | ||
25 | 1 | 1 | female | 35.0 | 1 | 0 | 13236 | 57.75 | C28 | C | 11 | [null] | ||
26 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | ||
27 | 1 | 1 | female | 48.0 | 1 | 3 | PC 17608 | 262.375 | B57 B59 B63 B66 | C | 4 | [null] | ||
28 | 1 | 1 | female | 18.0 | 2 | 2 | PC 17608 | 262.375 | B57 B59 B63 B66 | C | 4 | [null] | ||
29 | 1 | 1 | female | 54.0 | 1 | 0 | PC 17603 | 59.4 | [null] | C | 6 | [null] | ||
30 | 1 | 1 | female | 33.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | ||
31 | 1 | 1 | female | 33.0 | 0 | 0 | PC 17613 | 27.7208 | A11 | C | 11 | [null] | ||
32 | 1 | 1 | female | 43.0 | 0 | 1 | 24160 | 211.3375 | B3 | S | 2 | [null] | ||
33 | 1 | 1 | female | 56.0 | 0 | 1 | 11767 | 83.1583 | C50 | C | 7 | [null] | ||
34 | 1 | 1 | female | 30.0 | 0 | 0 | 12749 | 93.5 | B73 | S | 3 | [null] | ||
35 | 1 | 1 | female | 17.0 | 1 | 0 | PC 17758 | 108.9 | C65 | C | 8 | [null] | ||
36 | 1 | 1 | female | 22.0 | 1 | 0 | 113776 | 66.6 | C2 | S | 8 | [null] | ||
37 | 1 | 1 | female | 22.0 | 0 | 1 | 113509 | 61.9792 | B36 | C | 5 | [null] | ||
38 | 1 | 1 | female | 39.0 | 0 | 0 | PC 17758 | 108.9 | C105 | C | 8 | [null] | ||
39 | 1 | 1 | female | 19.0 | 0 | 2 | 11752 | 26.2833 | D47 | S | 5 | [null] | ||
40 | 1 | 1 | female | 23.0 | 1 | 0 | 35273 | 113.275 | D36 | C | 6 | [null] | ||
41 | 1 | 1 | female | 31.0 | 1 | 0 | 35273 | 113.275 | D36 | C | 6 | [null] | ||
42 | 1 | 1 | female | 37.0 | 1 | 0 | 19928 | 90.0 | C78 | Q | 14 | [null] | ||
43 | 1 | 1 | female | 33.0 | 1 | 0 | 19928 | 90.0 | C78 | Q | 14 | [null] | ||
44 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | PC 17604 | 82.1708 | [null] | C | 6 | [null] | ||
45 | 1 | 1 | female | 18.0 | 1 | 0 | 113773 | 53.1 | D30 | S | 10 | [null] | ||
46 | 1 | 1 | female | 16.0 | 0 | 0 | 110152 | 86.5 | B79 | S | 8 | [null] | ||
47 | 1 | 1 | female | 15.0 | 0 | 1 | 24160 | 211.3375 | B5 | S | 2 | [null] | ||
48 | 1 | 1 | female | 58.0 | 0 | 0 | PC 17569 | 146.5208 | B80 | C | No Lifeboat | [null] | ||
49 | 1 | 1 | female | 21.0 | 0 | 0 | 13502 | 77.9583 | D9 | S | 10 | [null] | ||
50 | 1 | 1 | female | 51.0 | 0 | 1 | PC 17592 | 39.4 | D28 | S | 9 | [null] | ||
51 | 1 | 1 | female | 16.0 | 0 | 1 | PC 17592 | 39.4 | D28 | S | 9 | [null] | ||
52 | 1 | 1 | female | 55.0 | 0 | 0 | 112377 | 27.7208 | [null] | C | 6 | [null] | ||
53 | 1 | 1 | female | 49.0 | 0 | 0 | 17465 | 25.9292 | D17 | S | 8 | [null] | ||
54 | 1 | 1 | female | 30.0 | 0 | 0 | PC 17761 | 106.425 | [null] | C | 2 | [null] | ||
55 | 1 | 1 | female | 39.0 | 0 | 0 | 24160 | 211.3375 | [null] | S | 2 | [null] | ||
56 | 1 | 1 | female | 45.0 | 1 | 0 | 11753 | 52.5542 | D19 | S | 5 | [null] | ||
57 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | 17464 | 51.8625 | D21 | S | 8 | [null] | ||
58 | 1 | 1 | female | 35.0 | 1 | 0 | 19943 | 90.0 | C93 | S | D | [null] | ||
59 | 1 | 1 | female | 35.0 | 1 | 0 | 113789 | 52.0 | [null] | S | 8 | [null] | ||
60 | 1 | 1 | female | 51.0 | 1 | 0 | 13502 | 77.9583 | D11 | S | 10 | [null] | ||
61 | 1 | 1 | female | 44.0 | 0 | 1 | 111361 | 57.9792 | B18 | C | 4 | [null] | ||
62 | 1 | 1 | female | 16.0 | 0 | 1 | 111361 | 57.9792 | B18 | C | 4 | [null] | ||
63 | 1 | 1 | female | 52.0 | 1 | 1 | 12749 | 93.5 | B69 | S | 3 | [null] | ||
64 | 1 | 1 | female | 24.0 | 0 | 0 | 11767 | 83.1583 | C54 | C | 7 | [null] | ||
65 | 1 | 1 | female | 35.0 | 1 | 0 | 36973 | 83.475 | C83 | S | D | [null] | ||
66 | 1 | 1 | female | 49.0 | 1 | 0 | PC 17572 | 76.7292 | D33 | C | 3 | [null] | ||
67 | 1 | 1 | female | 25.0 | 1 | 0 | 11765 | 55.4417 | E50 | C | 5 | [null] | ||
68 | 1 | 1 | female | 45.0 | 0 | 1 | PC 17759 | 63.3583 | D10 D12 | C | 7 | [null] | ||
69 | 1 | 1 | female | 58.0 | 0 | 1 | PC 17582 | 153.4625 | C125 | S | 3 | [null] | ||
70 | 1 | 1 | female | 19.0 | 0 | 0 | 112053 | 30.0 | B42 | S | 3 | [null] | ||
71 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | 17453 | 89.1042 | C92 | C | 5 | [null] | ||
72 | 1 | 1 | female | 45.0 | 0 | 1 | 112378 | 59.4 | [null] | C | 7 | [null] | ||
73 | 1 | 1 | female | 22.0 | 0 | 1 | 112378 | 59.4 | [null] | C | 7 | [null] | ||
74 | 1 | 1 | female | 35.0 | 0 | 0 | 113503 | 211.5 | C130 | C | 4 | [null] | ||
75 | 1 | 1 | female | 35.0 | 1 | 0 | 113803 | 53.1 | C123 | S | D | [null] | ||
76 | 1 | 1 | female | 48.0 | 1 | 1 | 13567 | 79.2 | B41 | C | 5 | [null] | ||
77 | 1 | 1 | female | 22.0 | 0 | 2 | 13568 | 49.5 | B39 | C | 5 | [null] | ||
78 | 1 | 1 | female | 37.2635658914729 | 1 | 0 | PC 17611 | 133.65 | [null] | S | 5 | [null] | ||
79 | 1 | 1 | female | 30.0 | 0 | 0 | PC 17485 | 56.9292 | E36 | C | 1 | [null] | ||
80 | 1 | 1 | female | 60.0 | 1 | 4 | 19950 | 263.0 | C23 C25 C27 | S | 10 | [null] | ||
81 | 1 | 1 | female | 23.0 | 3 | 2 | 19950 | 263.0 | C23 C25 C27 | S | 10 | [null] | ||
82 | 1 | 1 | female | 28.0 | 3 | 2 | 19950 | 263.0 | C23 C25 C27 | S | 10 | [null] | ||
83 | 1 | 1 | female | 24.0 | 3 | 2 | 19950 | 263.0 | C23 C25 C27 | S | 10 | [null] | ||
84 | 1 | 1 | female | 37.2635658914729 | 0 | 0 | 17421 | 110.8833 | [null] | C | 4 | [null] | ||
85 | 1 | 1 | female | 37.2635658914729 | 0 | 0 | PC 17598 | 31.6833 | [null] | S | 7 | [null] | ||
86 | 1 | 1 | female | 54.0 | 1 | 0 | 36947 | 78.2667 | D20 | C | 4 | [null] | ||
87 | 1 | 1 | female | 38.0 | 0 | 0 | PC 17757 | 227.525 | C45 | C | 4 | [null] | ||
88 | 1 | 1 | female | 23.0 | 0 | 1 | 11767 | 83.1583 | C54 | C | 7 | [null] | ||
89 | 1 | 1 | female | 48.0 | 1 | 0 | PC 17761 | 106.425 | C86 | C | 2 | [null] | ||
90 | 1 | 1 | female | 27.0 | 1 | 1 | PC 17558 | 247.5208 | B58 B60 | C | 6 | [null] | ||
91 | 1 | 1 | female | 54.0 | 1 | 1 | 33638 | 81.8583 | A34 | S | 5 | [null] | ||
92 | 1 | 1 | female | 17.0 | 1 | 0 | 17474 | 57.0 | B20 | S | 3 | [null] | ||
93 | 1 | 1 | female | 27.0 | 1 | 2 | F.C. 12750 | 52.0 | B71 | S | 3 | [null] | ||
94 | 1 | 1 | female | 33.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 8 | [null] | ||
95 | 1 | 1 | female | 38.0 | 1 | 0 | PC 17599 | 71.2833 | C85 | C | 4 | [null] | ||
96 | 1 | 1 | female | 64.0 | 1 | 1 | 112901 | 26.55 | B26 | S | 7 | [null] | ||
97 | 1 | 1 | female | 36.0 | 0 | 2 | WE/P 5735 | 71.0 | B22 | S | 7 | [null] | ||
98 | 1 | 1 | female | 55.0 | 2 | 0 | 11770 | 25.7 | C101 | S | 2 | [null] | ||
99 | 1 | 1 | female | 64.0 | 0 | 2 | PC 17756 | 83.1583 | E45 | C | 14 | [null] | ||
100 | 1 | 1 | female | 39.0 | 1 | 1 | PC 17756 | 83.1583 | E49 | C | 14 | [null] |
The ‘fillna’ method offers many options. Let’s use the ‘help’ method to view its parameters.
[70]:
help(vdf["embarked"].fillna)
Help on method fillna in module verticapy.vcolumn:
fillna(val=None, method:str='auto', expr:str='', by:list=[], order_by:list=[]) method of verticapy.vcolumn.vColumn instance
---------------------------------------------------------------------------
Fills missing elements in the vColumn with a user-specified rule.
Parameters
----------
val: int/float/str, optional
Value to use to impute the vColumn.
method: dict, optional
Method to use to impute the missing values.
auto : Mean for the numerical and Mode for the categorical vColumns.
bfill : Back Propagation of the next element (Constant Interpolation).
ffill : Propagation of the first element (Constant Interpolation).
mean : Average.
median : median.
mode : mode (most occurent element).
0ifnull : 0 when the vColumn is null, 1 otherwise.
expr: str, optional
SQL expression.
by: list, optional
vColumns used in the partition.
order_by: list, optional
List of the vColumns to use to sort the data when using TS methods.
Returns
-------
vDataFrame
self.parent
See Also
--------
vDataFrame[].dropna : Drops the vColumn missing values.
[72]:
print(vdf.current_relation())
(
SELECT
*
FROM
(
SELECT
"pclass",
"survived",
"name",
"sex",
COALESCE("age", AVG("age") OVER (PARTITION BY "pclass", "sex")) AS "age",
"sibsp",
"parch",
"ticket",
"fare",
"cabin",
"embarked",
COALESCE("boat", 'No Lifeboat') AS "boat",
"body",
"home.dest"
FROM
"public"."titanic")
VERTICAPY_SUBTABLE WHERE ("fare" IS NOT NULL) AND ("embarked" IS NOT NULL))
VERTICAPY_SUBTABLE
Depending on the circumstances, we’ll need to investigate to find the most suitable solution. Let’s take the following dataset as an example.
[7]:
import verticapy as vp
accidents = vp.read_csv("data/accidents.csv")
display(Accidents)
010 damage_infrastructureBoolean | 123 lonFloat | Abc information_sourceVarchar(30) | 📅 date_agentTimestamp | Abc location_detailVarchar(50) | 📅 dateTimestamp | 📅 date_ambulanceTimestamp | 123 latFloat | Abc lightingVarchar(40) | Abc causeVarchar(46) | 123 index_nullInt | Abc traveling_reasonVarchar(54) | 123 autoroute_position_kmInt | Abc weatherVarchar(24) | Abc Varchar(74) | 123 autoroute_idInt | 123 traffic_directionInt | 📅 date_gendarmeTimestamp | 📅 date_fmTimestamp | Abc pavementVarchar(34) | Abc locationVarchar(32) | Abc visibilityVarchar(20) | Abc equipmentVarchar(20) | Abc information_centerVarchar(20) | 123 idInt | 📅 date_tow_truckTimestamp | |
1 | -8.0075506538 | Usager | 2015-01-28 07:40:00 | ITPC | 2015-01-28 07:38:00 | 2015-01-28 08:13:00 | 33.3434970408 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 127 | Brouillard | 1 | 1 | 2015-01-28 08:25:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 21728 | 2015-01-28 07:50:00 | ||
2 | -7.7395617143 | Usager | 2015-04-02 06:59:00 | BAU | 2015-04-02 06:46:00 | [null] | 33.4558199012 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 98 | Brouillard | 1 | 2 | [null] | [null] | Mouillée | Section courante | Mauvaise | MAT | CEJ | 22742 | 2015-04-02 07:33:00 | ||
3 | -7.5729650459 | Usager | 2015-04-02 07:12:00 | ITPC | 2015-04-02 06:50:00 | [null] | 33.523943665 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 80 | Brouillard | 1 | 2 | [null] | [null] | Mouillée | Section courante | Mauvaise | MAT | CEJ | 22743 | 2015-04-02 07:14:00 | ||
4 | -7.5722580755 | Usager | 2015-11-09 00:15:00 | BAU | 2015-11-09 00:00:00 | [null] | 33.2314580349 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 34 | Brouillard | 3 | 2 | [null] | [null] | Mouillée | Section courante | Mauvaise | MAT | CEBS | 25983 | 2015-11-09 01:40:00 | ||
5 | -7.6063929587 | Usager | 2015-11-09 23:10:00 | BAU | 2015-11-09 23:00:00 | [null] | 33.3247608645 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 20 | Brouillard | 3 | 1 | [null] | [null] | Mouillée | Section courante | Mauvaise | MAT | CEBS | 25982 | 2015-11-09 23:25:00 | ||
6 | -7.3977465763 | Usager | 2015-11-11 01:00:00 | BAU | 2015-11-11 00:40:00 | [null] | 33.666896915 | Eblouissement | Faute de conduite | 0 | Utilisation professionnelle | 57 | Brouillard | 1 | 1 | 2015-11-11 01:05:00 | [null] | Mouillée | Section courante | Mauvaise | MAT | CEB | 26038 | 2015-11-11 01:05:00 | ||
7 | -8.1401754578 | Patrouilleur | 2016-10-20 08:09:00 | Pleine voie | 2016-10-20 08:00:00 | [null] | 33.3002125822 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 140 | Brouillard | 1 | 2 | 2016-10-20 08:50:00 | [null] | Mouillée | Section courante | Mauvaise | MAT | CEJ | 30750 | 2016-10-20 09:30:00 | ||
8 | -8.3907879245 | Usager | 2017-02-17 06:41:00 | Pleine voie | 2017-02-17 06:25:00 | 2017-02-17 07:24:00 | 33.2437285251 | Eblouissement | Faute de conduite | 1 | Domicile-Travail | 189 | Brouillard | 1 | 1 | 2017-02-17 07:46:00 | 2017-02-17 09:30:00 | Mouillée | Section courante | Mauvaise | M | CEJ | 32110 | 2017-02-17 08:00:00 | ||
9 | -8.2235298826 | Patrouilleur | 2017-04-06 07:40:00 | Pleine voie | 2017-04-06 07:36:00 | 2017-04-06 08:10:00 | 33.2952454539 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 148 | Brouillard | 1 | 2 | 2017-04-06 08:22:00 | [null] | Sèche | Section courante | Mauvaise | NM | CEJ | 33118 | 2017-04-06 08:40:00 | ||
10 | -7.6838664798 | Usager | 2018-02-19 07:05:00 | Pleine voie | 2018-02-19 06:50:00 | [null] | 32.8619206464 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 80 | Brouillard | 3 | 2 | [null] | [null] | Sèche | Section courante | Mauvaise | MAT | CEBS | 37804 | 2018-02-19 07:00:00 | ||
11 | -7.51827511688312 | Agent ADM | 2018-09-22 05:03:00 | BAU | 2018-09-22 05:00:00 | [null] | 33.2261007012987 | Eblouissement | Défaillance mécanique | 1 | Promenade-Loisirs | 8 | Brouillard | 4 | 1 | 2018-09-22 06:00:00 | [null] | Sèche | Section courante | Mauvaise | MAT | CEBB | 44536 | 2018-09-22 06:05:00 | ||
12 | -7.5482675753 | Centre d'appel | 2018-09-22 08:15:00 | Pleine voie | 2018-09-22 08:05:00 | [null] | 33.2888205214 | Eblouissement | Faute de conduite | 0 | Utilisation professionnelle | 27 | Brouillard | 3 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 44733 | [null] | ||
13 | -7.5482675753 | Patrouilleur | 2018-09-22 08:30:00 | Pleine voie | 2018-09-22 08:20:00 | [null] | 33.2888205214 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 27 | Brouillard | 3 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 44734 | 2018-09-22 08:50:00 | ||
14 | -7.5482675753 | Patrouilleur | 2018-09-22 08:30:00 | Pleine voie | 2018-09-22 08:25:00 | [null] | 33.2888205214 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 27 | Brouillard | 3 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 44735 | 2018-09-22 08:30:00 | ||
15 | -7.6276308131 | Usager | 2018-12-20 06:20:00 | ITPC | 2018-12-20 06:19:00 | [null] | 33.4297833642 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 8 | Brouillard | 3 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 46082 | 2018-12-20 07:20:00 | ||
16 | -6.5434801584 | Centre d'appel | 2019-02-13 08:15:00 | Pleine voie | 2019-02-13 08:06:00 | 2019-02-13 08:30:00 | 34.2234209056 | Eblouissement | Faute de conduite | 0 | Utilisation professionnelle | 233 | Brouillard | 5 | 2 | 2019-02-13 08:30:00 | 2019-02-13 09:20:00 | Mouillée | Section courante | Mauvaise | M | CEK | 46799 | 2019-02-13 08:20:00 | ||
17 | -7.5845240285 | Usager | 2019-03-18 08:00:00 | Pleine voie | 2019-03-18 07:42:00 | [null] | 33.0987899286 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 49 | Brouillard | 3 | 1 | 2019-03-18 08:20:00 | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 48233 | 2019-03-18 08:30:00 | ||
18 | -5.6491627456 | Centre d'appel | 2019-05-06 07:57:00 | Pleine voie | 2019-05-06 05:50:00 | [null] | 33.874369618 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 115 | Brouillard | 2 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEM | 48810 | 2019-05-06 07:40:00 | ||
19 | -7.8437597785 | Centre d'appel | 2019-06-03 05:09:00 | Pleine voie | 2019-06-03 04:51:00 | 2019-06-03 05:41:00 | 33.3972462238 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 110 | Brouillard | 1 | 2 | 2019-06-03 05:44:00 | [null] | Mouillée | Section courante | Mauvaise | NM | CEJ | 49500 | 2019-06-03 06:01:00 | ||
20 | -8.3952503827 | Centre d'appel | 2019-10-27 08:05:00 | BAU | 2019-10-27 07:35:00 | [null] | 33.2415617419 | Eblouissement | Obstacle sur chaussée | 1 | Promenade-Loisirs | 189 | Brouillard | 1 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEJ | 51671 | 2019-10-27 09:00:00 | ||
21 | -8.203703749 | Centre d'appel | 2019-12-07 07:34:00 | Pleine voie | 2019-12-07 07:19:00 | 2019-12-07 08:20:00 | 33.2991800036 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 146 | Brouillard | 1 | 1 | 2019-12-07 08:45:00 | [null] | Mouillée | Section courante | Mauvaise | NM | CEJ | 51735 | 2019-12-07 08:50:00 | ||
22 | -7.4793410533 | Gendarmerie | 2015-01-20 08:44:00 | BAU | 2015-01-20 08:30:00 | [null] | 33.566024253 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 71 | Pluie | 1 | 2 | 2015-01-20 08:30:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 21718 | 2015-01-20 09:00:00 | ||
23 | -6.6347539755 | Usager | 2015-03-19 03:06:00 | Pleine voie | 2015-03-19 02:58:00 | [null] | 34.1937920174 | Eblouissement | Défaillance physique | 0 | Utilisation professionnelle | 243 | Pluie | 5 | 2 | 2015-03-19 03:05:00 | [null] | Mouillée | Section courante | Bonne | MAT | CEK | 21847 | 2015-03-19 03:40:00 | ||
24 | -5.2218037048 | Usager | 2015-03-23 18:45:00 | Pleine voie | 2015-03-23 18:36:00 | [null] | 33.8916679546 | Eblouissement | Faute de conduite | 0 | Utilisation professionnelle | 158 | Pluie | 2 | 1 | [null] | [null] | Mouillée | Section courante | Mauvaise | MAT | CEM | 22062 | 2015-03-23 20:25:00 | ||
25 | -5.7152702554 | Centre d'appel | 2015-04-14 19:35:00 | BAU | 2015-04-14 19:15:00 | [null] | 35.6841777647 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 27 | Pluie | 5 | 1 | 2015-04-14 19:32:00 | [null] | Premièrepluie | Section courante | Moyenne | MAT | CET | 22581 | 2015-04-14 19:40:00 | ||
26 | -7.6828673023 | Centre d'appel | 2016-05-13 07:42:00 | ITPC | 2016-05-13 07:36:00 | [null] | 33.4994004833 | Eblouissement | Défaillance mécanique | 0 | Domicile-Travail | 91 | Pluie | 1 | 2 | [null] | [null] | Premièrepluie | Section courante | Moyenne | MAT | CEJ | 28419 | 2016-05-13 08:37:00 | ||
27 | -7.7458342283 | Usager | 2016-08-25 13:20:00 | ITPC | 2016-08-25 13:07:00 | 2016-08-25 13:41:00 | 33.4507431113 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 99 | Pluie | 1 | 2 | 2016-08-25 13:30:00 | [null] | Sèche | Section courante | Moyenne | NM | CEJ | 29697 | 2016-08-25 13:41:00 | ||
28 | -7.9034661679 | Centre d'appel | 2016-11-24 16:00:00 | BAU | 2016-11-24 15:44:00 | 2016-11-24 16:35:00 | 33.3771052953 | Eblouissement | Défaillance mécanique | 0 | Domicile-Travail | 116 | Pluie | 1 | 1 | 2016-11-24 17:16:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 31346 | 2016-11-24 16:20:00 | ||
29 | -6.6660673505 | Centre d'appel | 2016-11-24 19:50:00 | Pleine voie | 2016-11-24 19:25:00 | [null] | 34.1688602904 | Eblouissement | Défaillance physique | 0 | Domicile-Travail | 247 | Pluie | 5 | 1 | 2016-11-24 20:00:00 | [null] | Mouillée | Section courante | Mauvaise | MAT | CEK | 30973 | 2016-11-24 20:05:00 | ||
30 | -6.0138228037 | Centre d'appel | 2016-11-27 06:10:00 | ITPC | 2016-11-27 06:00:00 | [null] | 35.3424157461 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 89 | Pluie | 5 | 2 | 2016-11-27 07:00:00 | [null] | Mouillée | Section courante | Mauvaise | MAT | CET | 31065 | 2016-11-27 08:30:00 | ||
31 | -7.5551807089 | Patrouilleur | 2016-11-27 06:26:00 | BAU | 2016-11-27 06:26:00 | 2016-11-27 06:55:00 | 33.2954028556 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 26 | Pluie | 3 | 1 | 2016-11-27 08:14:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEBS | 31144 | 2016-11-27 07:15:00 | ||
32 | -8.3665018836 | Usager | 2016-12-02 17:10:00 | ITPC | 2016-12-02 17:08:00 | 2016-12-02 17:35:00 | 33.2514592282 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 163 | Pluie | 1 | 1 | 2016-12-02 17:40:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 31681 | 2016-12-02 17:44:00 | ||
33 | -8.3907879245 | Patrouilleur | 2016-12-03 11:30:00 | Pleine voie | 2016-12-03 11:20:00 | [null] | 33.2437285251 | Eblouissement | Défaillance physique | 1 | Domicile-Travail | 260 | Pluie | 1 | 1 | 2016-12-03 12:32:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 31682 | 2016-12-03 12:45:00 | ||
34 | -6.0171664998 | Centre d'appel | 2016-12-16 17:40:00 | ITPC | 2016-12-16 17:20:00 | 2016-12-16 17:35:00 | 35.3606466946 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 87 | Pluie | 5 | 1 | 2016-12-16 17:45:00 | [null] | Mouillée | Section courante | Mauvaise | NM | CET | 31089 | 2016-12-16 18:00:00 | ||
35 | -7.8149073878 | Centre d'appel | 2017-01-27 14:36:00 | ITPC | 2017-01-27 14:30:00 | 2017-01-27 14:42:00 | 33.4200875999 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 106 | Pluie | 1 | 2 | 2017-01-27 15:05:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 32088 | 2017-01-27 14:40:00 | ||
36 | -7.6334558722 | Usager | 2017-11-29 20:15:00 | BAU | 2017-11-29 19:00:00 | [null] | 33.4739691854 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 3 | Pluie | 3 | 1 | 2017-11-29 19:00:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEBS | 36752 | 2017-11-29 19:20:00 | ||
37 | -7.6334730984 | Usager | 2017-11-29 20:24:00 | BAU | 2017-11-29 19:07:00 | [null] | 33.468599891 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 4 | Pluie | 3 | 1 | 2017-11-29 19:07:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEBS | 36753 | 2017-11-29 20:30:00 | ||
38 | -8.3775347055 | Usager | 2018-01-10 11:05:00 | ITPC | 2018-01-09 11:10:00 | [null] | 33.250726804 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 164 | Pluie | 1 | 2 | 2018-01-09 11:35:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 37398 | 2018-01-09 11:40:00 | ||
39 | -7.6463910244 | Patrouilleur | 2018-02-06 09:04:00 | Pleine voie | 2018-02-06 09:03:00 | [null] | 32.9177039001 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 72 | Pluie | 3 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEBS | 37786 | [null] | ||
40 | -2.8924316416 | Centre d'appel | 2018-02-06 17:27:00 | Pleine voie | 2018-02-06 17:22:00 | [null] | 34.5485762877 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 411 | Pluie | 2 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEO | 37584 | 2018-02-06 18:20:00 | ||
41 | -7.900683708 | Usager | 2018-03-01 12:45:00 | BAU | 2018-03-01 12:20:00 | [null] | 33.3785090651 | Eblouissement | Obstacle sur chaussée | 1 | Domicile-Travail | 116 | Pluie | 1 | 2 | 2018-03-01 15:00:00 | [null] | Premièrepluie | Section courante | Moyenne | MAT | CEJ | 39212 | 2018-03-01 13:00:00 | ||
42 | -7.5742567675 | Usager | 2018-03-16 05:20:00 | Parking | 2018-03-16 05:15:00 | 2018-03-16 05:30:00 | 33.2228256231 | Eblouissement | Défaillance mécanique | 0 | Domicile-Travail | 35 | Pluie | 3 | 1 | 2018-03-16 05:35:00 | [null] | Mouillée | Aire de service | Bonne | MAT | CEBS | 39623 | 2018-03-16 05:50:00 | ||
43 | -7.6277890591 | Usager | 2018-05-07 06:33:00 | BAU | 2018-05-07 06:23:00 | [null] | 33.4317444412 | Eblouissement | Défaillance physique | 0 | Domicile-Travail | 8 | Pluie | 3 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEBS | 42920 | [null] | ||
44 | -4.6836746109 | Centre d'appel | 2018-10-16 07:25:00 | Pleine voie | 2018-10-16 07:08:00 | [null] | 33.9981796398 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 219 | Pluie | 2 | 1 | 2018-10-16 07:59:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEF | 44849 | 2018-10-16 08:22:00 | ||
45 | -4.6836746109 | Centre d'appel | 2018-10-16 07:25:00 | Pleine voie | 2018-10-16 07:08:00 | [null] | 33.9981796398 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 219 | Pluie | 2 | 1 | 2018-10-16 07:59:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEF | 44848 | [null] | ||
46 | -7.0261839292 | Patrouilleur | 2018-10-30 08:42:00 | BAU | 2018-10-30 08:40:00 | [null] | 33.862817808 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 18 | Pluie | 1 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEB | 44962 | 2018-10-30 08:50:00 | ||
47 | -8.0102202735 | Usager | 2018-11-12 10:23:00 | Pleine voie | 2018-11-12 10:02:00 | 2018-11-12 10:10:00 | 33.3413252373 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 127 | Pluie | 1 | 1 | 2018-11-12 10:12:00 | [null] | Premièrepluie | Section courante | Moyenne | NM | CEJ | 45683 | 2018-11-12 10:18:00 | ||
48 | -7.9172858847 | Centre d'appel | 2018-11-12 12:56:00 | BAU | 2018-11-12 12:30:00 | [null] | 33.3720620821 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 117 | Pluie | 1 | 1 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 45684 | 2018-11-12 13:00:00 | ||
49 | -7.820720842 | Centre d'appel | 2018-11-12 20:40:00 | Pleine voie | 2018-11-12 20:03:00 | [null] | 33.4159212077 | Eblouissement | Obstacle sur chaussée | 0 | Domicile-Travail | 107 | Pluie | 1 | 2 | 2018-11-12 20:55:00 | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 45685 | [null] | ||
50 | -8.3952503827 | Usager | 2018-11-18 11:01:00 | BAU | 2018-11-18 10:05:00 | [null] | 33.2415617419 | Eblouissement | Faute de conduite | 1 | Promenade-Loisirs | 186 | Pluie | 1 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 45688 | 2018-11-18 11:03:00 | ||
51 | -4.4385892196 | Usager | 2019-01-24 08:37:00 | BAU | 2019-01-24 07:54:00 | [null] | 34.1146356078 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 247 | Pluie | 2 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEF | 46371 | 2019-01-24 08:41:00 | ||
52 | -7.9342691262 | Centre d'appel | 2019-04-05 16:04:00 | BAU | 2019-04-05 15:45:00 | 2019-04-05 16:22:00 | 32.3834942702 | Eblouissement | Défaillance physique | 0 | Utilisation professionnelle | 141 | Pluie | 3 | 1 | 2019-04-05 16:23:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEMA | 49103 | 2019-04-05 16:22:00 | ||
53 | -8.3770075528 | Agent ADM | 2019-04-19 07:03:00 | BAU | 2019-04-19 06:57:00 | [null] | 33.2508963579 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 164 | Pluie | 1 | 2 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 48039 | 2019-04-19 08:00:00 | ||
54 | -8.3952503827 | Centre d'appel | 2019-04-19 07:53:00 | Pleine voie | 2019-04-19 07:44:00 | 2019-04-19 08:00:00 | 33.2415617419 | Eblouissement | Faute de conduite | 1 | Domicile-Travail | 178 | Pluie | 1 | 2 | 2019-04-19 08:40:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 48040 | 2019-04-19 08:46:00 | ||
55 | -7.747006126 | Centre d'appel | 2019-11-11 14:29:00 | ITPC | 2019-11-11 14:13:00 | [null] | 33.4492014806 | Eblouissement | Défaillance mécanique | 0 | Promenade-Loisirs | 99 | Pluie | 1 | 1 | [null] | [null] | Mouillée | Section courante | Moyenne | MAT | CEJ | 51696 | 2019-11-11 14:45:00 | ||
56 | -8.1272300397 | Centre d'appel | 2019-11-15 08:13:00 | BAU | 2019-11-15 07:50:00 | 2019-11-15 08:13:00 | 33.3015990298 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 139 | Pluie | 1 | 2 | 2019-11-15 08:41:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 51704 | 2019-11-15 09:20:00 | ||
57 | -7.722759619 | Centre d'appel | 2019-12-01 19:24:00 | BAU | 2019-12-01 19:21:00 | 2019-12-01 20:03:00 | 33.467238838 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 96 | Pluie | 1 | 2 | 2019-12-01 20:11:00 | [null] | Mouillée | Section courante | Moyenne | NM | CEJ | 51725 | 2019-12-01 20:11:00 | ||
58 | -6.9122279982 | Dépannage | [null] | BAU | 2015-09-05 23:35:00 | [null] | 33.9555924396 | Eblouissement | Défaillance mécanique | 0 | Promenade-Loisirs | 4 | Temps normal | 1 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEB | 25463 | [null] | ||
59 | -7.6205574483 | Usager | [null] | Pleine voie | 2019-08-27 23:57:00 | [null] | 33.3854881184 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 13 | Temps normal | 3 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 51361 | [null] | ||
60 | -7.629918409 | Usager | [null] | Pleine voie | 2019-08-29 23:30:00 | [null] | 33.4394118237 | Eblouissement | Défaillance mécanique | 0 | Domicile-Travail | 7 | Temps normal | 3 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 51364 | 2019-08-30 23:22:00 | ||
61 | -8.101455636 | Gendarmerie | 2015-01-09 17:08:00 | ITPC | 2015-01-09 16:45:00 | [null] | 33.3184053906 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 136 | Temps normal | 1 | 2 | 2015-01-09 16:50:00 | [null] | Sèche | Section courante | Bonne | MAT | CEJ | 21710 | 2015-01-09 18:02:00 | ||
62 | -6.024556336 | Centre d'appel | 2015-01-10 07:20:00 | ITPC | 2015-01-10 07:00:00 | 2015-01-10 07:30:00 | 35.44361106 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 78 | Temps normal | 5 | 2 | 2015-01-10 07:20:00 | [null] | Sèche | Section courante | Moyenne | NM | CET | 22267 | 2015-01-10 09:30:00 | ||
63 | -6.1999057635 | Centre d'appel | 2015-01-15 17:07:00 | ITPC | 2015-01-15 16:50:00 | 2015-01-15 17:17:00 | 34.9698555071 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 138 | Temps normal | 5 | 2 | 2015-01-15 17:20:00 | [null] | Sèche | Section courante | Moyenne | NM | CET | 22268 | 2015-01-15 17:25:00 | ||
64 | -4.1180130116 | Centre d'appel | 2015-01-26 06:05:00 | BAU | 2015-01-26 05:57:00 | [null] | 34.2207513471 | Eblouissement | Obstacle sur chaussée | 0 | Promenade-Loisirs | 282 | Temps normal | 2 | 2 | [null] | [null] | Sèche | Section courante | Bonne | MAT | CEF | 22505 | [null] | ||
65 | -3.3398268888 | Gendarmerie | 2015-01-27 17:58:00 | Pleine voie | 2015-01-27 17:30:00 | 2015-01-27 17:58:00 | 34.3308930076 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 362 | Temps normal | 2 | 2 | 2015-01-27 17:58:00 | [null] | Sèche | Section courante | Moyenne | NM | CEO | 22193 | 2015-01-27 18:14:00 | ||
66 | -6.4780026557 | Usager | 2015-02-25 22:14:00 | Pleine voie | 2015-02-25 21:49:00 | [null] | 34.5076871414 | Eblouissement | Défaillance mécanique | 0 | Utilisation professionnelle | 198 | Temps normal | 5 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEK | 21830 | 2015-02-25 22:55:00 | ||
67 | -2.134858833 | Patrouilleur | 2015-03-03 06:20:00 | BAU | 2015-03-03 06:20:00 | 2015-03-03 06:48:00 | 34.6589713105 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 487 | Temps normal | 2 | 1 | 2015-03-03 06:48:00 | [null] | Sèche | Section courante | Moyenne | NM | CEO | 22207 | 2015-03-03 07:15:00 | ||
68 | -6.2023244929 | Usager | 2015-03-13 06:20:00 | BAU | 2015-03-13 05:45:00 | 2015-03-13 06:15:00 | 34.9333596492 | Eblouissement | Obstacle sur chaussée | 0 | Promenade-Loisirs | 142 | Temps normal | 5 | 2 | 2015-03-13 06:50:00 | [null] | Sèche | Section courante | Moyenne | NM | CET | 22319 | 2015-03-13 05:50:00 | ||
69 | -5.8665251556 | Patrouilleur | 2015-03-29 19:40:00 | Pleine voie | 2015-03-29 19:40:00 | [null] | 33.8067139654 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 90 | Temps normal | 2 | 1 | 2015-03-29 21:32:00 | [null] | Sèche | Section courante | Moyenne | MAT | CEM | 22068 | 2015-03-29 20:40:00 | ||
70 | -5.9652956574 | Usager | 2015-03-31 20:05:00 | Pleine voie | 2015-03-31 19:50:00 | [null] | 33.7814601664 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 80 | Temps normal | 2 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEM | 22072 | 2015-03-31 20:25:00 | ||
71 | -6.9773676484 | Centre d'appel | 2015-04-12 05:32:00 | ITPC | 2015-04-12 05:25:00 | 2015-04-12 06:00:00 | 33.9012632859 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 12 | Temps normal | 1 | 1 | 2015-04-12 05:50:00 | [null] | Sèche | Section courante | Moyenne | NM | CEB | 23631 | 2015-04-12 05:33:00 | ||
72 | -5.9393973744 | Dépannage | 2015-04-18 20:30:00 | BAU | 2015-04-18 19:45:00 | [null] | 35.6689824797 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 50 | Temps normal | 5 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CET | 22585 | 2015-04-18 20:20:00 | ||
73 | -5.816660424 | Usager | 2015-05-12 19:40:00 | Pleine voie | 2015-05-12 19:20:00 | 2015-05-12 20:13:00 | 33.844419875 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 97 | Temps normal | 2 | 2 | 2015-05-12 20:07:00 | [null] | Sèche | Section courante | Moyenne | NM | CEM | 23346 | 2015-05-12 20:10:00 | ||
74 | -5.8665251556 | Centre d'appel | 2015-05-17 20:15:00 | Pleine voie | 2015-05-17 20:14:00 | 2015-05-17 20:40:00 | 33.8067139654 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 90 | Temps normal | 2 | 1 | 2015-05-17 20:25:00 | [null] | Sèche | Section courante | Moyenne | NM | CEM | 23350 | 2015-05-17 20:30:00 | ||
75 | -8.0397545886 | Centre d'appel | 2015-05-23 06:25:00 | BAU | 2015-05-23 06:25:00 | [null] | 33.3309506342 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 130 | Temps normal | 1 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEJ | 23378 | 2015-05-23 07:15:00 | ||
76 | -3.0520238648 | Centre d'appel | 2015-05-26 20:08:00 | Pleine voie | 2015-05-26 20:02:00 | 2015-05-26 20:30:00 | 34.4492022688 | Eblouissement | Défaillance mécanique | 0 | Promenade-Loisirs | 391 | Temps normal | 2 | 1 | 2015-05-26 20:18:00 | [null] | Sèche | Section courante | Moyenne | NM | CEO | 23618 | 2015-05-26 21:00:00 | ||
77 | -6.7111672331 | Patrouilleur | 2015-06-07 03:10:00 | Pleine voie | 2015-06-07 03:00:00 | [null] | 34.0629254145 | Eblouissement | Défaillance physique | 0 | Utilisation professionnelle | 260 | Temps normal | 5 | 1 | 2015-06-07 03:33:00 | [null] | Sèche | Section courante | Moyenne | MAT | CEK | 23735 | 2015-06-07 04:00:00 | ||
78 | -7.6016012262 | Usager | 2015-06-15 19:40:00 | BAU | 2015-06-15 19:38:00 | [null] | 33.316796236 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 21 | Temps normal | 3 | 1 | [null] | [null] | Sèche | Section courante | Bonne | MAT | CEBS | 23994 | 2015-06-15 20:30:00 | ||
79 | -7.7297975528 | Centre d'appel | 2015-06-29 05:00:00 | ITPC | 2015-06-29 04:35:00 | [null] | 33.4616580321 | Eblouissement | Défaillance physique | 0 | Domicile-Travail | 97 | Temps normal | 1 | 2 | 2015-06-29 04:54:00 | [null] | Sèche | Section courante | Moyenne | MAT | CEJ | 23922 | 2015-06-29 05:45:00 | ||
80 | -5.7456257139 | Patrouilleur | 2015-07-08 05:18:00 | Pleine voie | 2015-07-08 05:18:00 | [null] | 33.8844301971 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 105 | Temps normal | 2 | 1 | 2015-07-08 05:50:00 | [null] | Sèche | Section courante | Bonne | MAT | CEM | 24117 | 2015-07-08 05:55:00 | ||
81 | -5.72157525 | Patrouilleur | 2015-07-08 05:32:00 | Pleine voie | 2015-07-08 05:32:00 | [null] | 33.8894102483 | Eblouissement | Défaillance physique | 0 | Promenade-Loisirs | 107 | Temps normal | 2 | 1 | [null] | [null] | Sèche | Section courante | Bonne | MAT | CEM | 24118 | 2015-07-08 06:10:00 | ||
82 | -6.1880871275 | Centre d'appel | 2015-07-14 20:45:00 | BAU | 2015-07-14 20:00:00 | [null] | 35.0160583311 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 133 | Temps normal | 5 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CET | 24342 | 2015-07-14 21:15:00 | ||
83 | -7.5821575015 | Patrouilleur | 2015-07-28 06:28:00 | ITPC | 2015-07-28 06:00:00 | [null] | 33.1075039855 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 48 | Temps normal | 3 | 2 | 2015-07-28 06:35:00 | [null] | Sèche | Section courante | Bonne | MAT | CEBS | 24315 | 2015-07-28 07:00:00 | ||
84 | -5.9548489118 | Patrouilleur | 2015-08-09 20:34:00 | Pleine voie | 2015-08-08 20:43:00 | [null] | 33.7793510784 | Eblouissement | Obstacle sur chaussée | 0 | Utilisation professionnelle | 81 | Temps normal | 2 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEM | 24511 | 2015-08-08 21:15:00 | ||
85 | -4.4190361756 | Centre d'appel | 2015-08-21 06:02:00 | BAU | 2015-08-21 05:32:00 | [null] | 34.1213858187 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 249 | Temps normal | 2 | 1 | [null] | [null] | Sèche | Section courante | Bonne | MAT | CEF | 25012 | 2015-08-21 06:45:00 | ||
86 | -7.6276308131 | Usager | 2015-09-20 20:40:00 | Pleine voie | 2015-09-20 20:30:00 | [null] | 33.4297833642 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 8 | Temps normal | 3 | 2 | 2015-09-20 21:10:00 | [null] | Sèche | Section courante | Bonne | MAT | CEBS | 25442 | 2015-09-20 21:00:00 | ||
87 | -3.1870352548 | Patrouilleur | 2015-10-07 06:10:00 | Bretelle entrée | 2015-10-07 06:10:00 | [null] | 34.4026264052 | Eblouissement | Défaillance mécanique | 0 | Domicile-Travail | 377 | Temps normal | 2 | 1 | [null] | [null] | Sèche | Aire de service | Moyenne | MAT | CEO | 25651 | 2015-10-07 06:50:00 | ||
88 | -4.4721635057 | Centre d'appel | 2015-10-15 06:56:00 | BAU | 2015-10-15 06:34:00 | [null] | 34.0925936508 | Eblouissement | Défaillance mécanique | 0 | Utilisation professionnelle | 243 | Temps normal | 2 | 2 | 2015-10-15 08:05:00 | [null] | Sèche | Section courante | Bonne | MAT | CEF | 25537 | 2015-10-15 08:33:00 | ||
89 | -6.2020550133 | Patrouilleur | 2015-10-18 10:35:00 | ITPC | 2015-10-18 05:00:00 | [null] | 34.933805703 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 142 | Temps normal | 5 | 1 | 2015-10-18 10:50:00 | [null] | Sèche | Section courante | Bonne | NM | CET | 25794 | 2015-10-18 10:45:00 | ||
90 | -7.8644432924 | Agent ADM | 2015-10-20 19:02:00 | ITPC | 2015-10-20 18:45:00 | [null] | 33.391943724 | Eblouissement | Défaillance physique | 0 | Domicile-Travail | 112 | Temps normal | 1 | 1 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEJ | 25685 | 2015-10-20 19:10:00 | ||
91 | -7.8080459366 | Usager | 2015-10-27 06:53:00 | Pleine voie | 2015-10-27 06:40:00 | [null] | 33.4227982784 | Eblouissement | Défaillance physique | 0 | Domicile-Travail | 106 | Temps normal | 1 | 1 | 2015-10-27 08:15:00 | [null] | Sèche | Section courante | Moyenne | NM | CEJ | 25689 | 2015-10-27 08:08:00 | ||
92 | -7.9833315436 | Patrouilleur | 2015-11-03 19:06:00 | ITPC | 2015-11-03 19:00:00 | [null] | 33.3532930927 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 124 | Temps normal | 1 | 2 | [null] | [null] | Sèche | Section courante | Moyenne | MAT | CEJ | 25906 | 2015-11-03 19:20:00 | ||
93 | -4.6291796253 | Centre d'appel | 2015-11-08 06:48:00 | Pleine voie | 2015-11-08 05:32:00 | 2015-11-08 06:30:00 | 34.0183926548 | Eblouissement | Défaillance mécanique | 0 | Promenade-Loisirs | 225 | Temps normal | 2 | 2 | 2015-11-08 06:15:00 | [null] | Sèche | Section courante | Bonne | NM | CEF | 25891 | 2015-11-08 07:55:00 | ||
94 | -7.2481144256 | Centre d'appel | 2015-11-10 00:40:00 | BAU | 2015-11-10 00:12:00 | 2015-11-10 01:10:00 | 33.768452734 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 40 | Temps normal | 1 | 1 | 2015-11-10 01:00:00 | [null] | Sèche | Section courante | Mauvaise | NM | CEB | 26034 | [null] | ||
95 | -7.6332807131 | Usager | 2015-12-01 18:15:00 | Pleine voie | 2015-12-01 18:00:00 | [null] | 33.4560929375 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 5 | Temps normal | 3 | 2 | 2015-12-01 18:20:00 | [null] | Sèche | Section courante | Moyenne | MAT | CEBS | 26355 | 2015-12-01 18:45:00 | ||
96 | -4.1480827366 | Centre d'appel | 2016-01-02 06:30:00 | Pleine voie | 2016-01-02 06:17:00 | 2016-01-02 07:05:00 | 34.2252802359 | Eblouissement | Défaillance physique | 0 | Utilisation professionnelle | 279 | Temps normal | 2 | 1 | 2016-01-02 06:49:00 | [null] | Sèche | Section courante | Moyenne | NM | CEF | 27029 | 2016-01-02 07:02:00 | ||
97 | -3.5167267043 | Agent ADM | 2016-01-17 17:30:00 | BAU | 2016-01-17 17:18:00 | [null] | 34.3283924767 | Eblouissement | Faute de conduite | 0 | Promenade-Loisirs | 344 | Temps normal | 2 | 2 | [null] | [null] | Sèche | Section courante | Bonne | MAT | CEO | 27159 | 2016-01-17 18:20:00 | ||
98 | -3.4689562533 | Centre d'appel | 2016-03-09 06:39:00 | BAU | 2016-03-09 06:15:00 | [null] | 34.3182985499 | Eblouissement | Obstacle sur chaussée | 0 | Promenade-Loisirs | 349 | Temps normal | 2 | 2 | 2016-03-09 08:20:00 | [null] | Sèche | Section courante | Bonne | MAT | CEO | 27775 | [null] | ||
99 | -7.5883010689 | Agent ADM | 2016-03-10 11:02:00 | BAU | 2016-03-10 10:45:00 | 2016-03-10 11:30:00 | 33.5168611975 | Eblouissement | Faute de conduite | 0 | Domicile-Travail | 82 | Temps normal | 1 | 2 | 2016-03-10 11:30:00 | [null] | Sèche | Section courante | Moyenne | NM | CEJ | 27583 | 2016-03-10 11:50:00 | ||
100 | -6.1500946599 | Patrouilleur | 2016-04-15 06:30:00 | Pleine voie | 2016-04-15 06:30:00 | 2016-04-15 06:54:00 | 33.8187719328 | Eblouissement | Défaillance physique | 0 | Utilisation professionnelle | 61 | Temps normal | 2 | 1 | 2016-04-15 06:45:00 | [null] | Sèche | Section courante | Bonne | NM | CEM | 27838 | 2016-04-15 07:25:00 |
Rows: 1-100 of 23550 | Columns: 26
This dataset contains the latitude and longitude of car accidents in Morocco.
[12]:
accidents.count_percent()
count | percent | |
"id" | 23550.0 | 100.0 |
"date" | 23550.0 | 100.0 |
"highway_id" | 23550.0 | 100.0 |
"traffic_direction" | 23550.0 | 100.0 |
"highway_position_km" | 23550.0 | 100.0 |
"information_center" | 23550.0 | 100.0 |
"equipment" | 23550.0 | 100.0 |
"cause" | 23550.0 | 100.0 |
"cause_detail" | 23550.0 | 100.0 |
"weather" | 23550.0 | 100.0 |
"lighting" | 23550.0 | 100.0 |
"pavement" | 23550.0 | 100.0 |
"visibility" | 23550.0 | 100.0 |
"location" | 23529.0 | 99.911 |
"location_detail" | 23529.0 | 99.911 |
"damage_infrastructure" | 23359.0 | 99.189 |
"traveling_reason" | 23289.0 | 98.892 |
"information_source" | 23246.0 | 98.709 |
"date_agent" | 22953.0 | 97.465 |
"lon" | 20708.0 | 87.932 |
"lat" | 20708.0 | 87.932 |
"date_tow_truck" | 18908.0 | 80.289 |
"date_gendarme" | 14226.0 | 60.408 |
"date_ambulance" | 7505.0 | 31.868 |
"date_fm" | 607.0 | 2.577 |
[12]:
This dataset is missing a lot of longitude and latitude values. However, we also know the Highway ID and the position of the car in the given highway. Knowing this, we can use interpolation to impute the missing values.
[14]:
# First Propagation
accidents["lat"].fillna(method = "ffill",
by = ["highway_id"],
order_by = ["highway_position_km"])
accidents["lon"].fillna(method = "ffill",
by = ["highway_id"],
order_by = ["highway_position_km"])
# Back Propagation
accidents["lat"].fillna(method = "bfill",
by = ["highway_id"],
order_by = ["highway_position_km"])
accidents["lon"].fillna(method = "bfill",
by = ["highway_id"],
order_by = ["highway_position_km"])
1135 element(s) was/were filled
1135 element(s) was/were filled
1154 element(s) was/were filled
1154 element(s) was/were filled
123 idInt 100% | 📅 dateTimestamp 100% | Abc lonVarchar(100) 97% | 123 latFloat 97% | 123 highway_idInt 100% | 123 traffic_directionInt 100% | 123 highway_position_kmInt 100% | Abc locationVarchar(32) 99% | Abc location_detailVarchar(50) 99% | Abc information_sourceVarchar(34) 98% | Abc information_centerVarchar(20) 100% | Abc damage_infrastructureVarchar(20) 99% | Abc equipmentVarchar(20) 100% | 📅 date_tow_truckTimestamp 80% | 📅 date_ambulanceTimestamp 31% | 📅 date_gendarmeTimestamp 60% | 📅 date_agentTimestamp 97% | 📅 date_fmTimestamp 2% | Abc causeVarchar(46) 100% | Abc Varchar(74) 100% | Abc weatherVarchar(54) 100% | Abc lightingVarchar(54) 100% | Abc pavementVarchar(54) 100% | Abc traveling_reasonVarchar(54) 98% | Abc visibilityVarchar(54) 100% | |
1 | 26033 | 2015-11-09 16:14:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2015-11-09 16:35:00 | 2015-11-09 16:35:00 | 2015-11-09 17:05:00 | 2015-11-09 16:25:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
2 | 26041 | 2015-11-13 08:22:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | ITPC | Patrouilleur | CEB | Non | NM | 2015-11-13 08:40:00 | 2015-11-13 08:35:00 | 2015-11-13 08:25:00 | 2015-11-13 08:22:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
3 | 27305 | 2016-02-20 23:45:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
4 | 30477 | 2016-09-15 20:15:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Agent ADM | CEB | Non | NM | 2016-09-15 20:19:00 | 2016-09-15 20:22:00 | 2016-09-15 20:28:00 | 2016-09-15 20:31:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
5 | 31645 | 2016-11-14 08:30:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2016-11-14 09:07:00 | [null] | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
6 | 32595 | 2017-04-21 13:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2017-04-21 13:59:00 | [null] | [null] | 2017-04-21 13:50:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
7 | 33356 | 2017-06-04 17:21:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | NM | [null] | 2017-06-04 17:43:00 | 2017-06-04 17:43:00 | 2017-06-04 17:45:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
8 | 37053 | 2017-12-09 21:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-12-09 21:15:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
9 | 39945 | 2018-04-09 00:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-04-09 00:40:00 | 2018-04-09 00:30:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
10 | 40629 | 2018-05-27 15:50:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
11 | 41014 | 2018-06-10 12:45:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Oui | NM | 2018-06-10 13:32:00 | 2018-06-10 13:11:00 | 2018-06-10 13:00:00 | 2018-06-10 13:00:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
12 | 41975 | 2018-08-01 07:55:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-08-01 07:58:00 | [null] | [null] | 2018-08-01 08:02:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
13 | 42015 | 2018-08-08 16:28:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Agent ADM | CEB | Non | NM | [null] | 2018-08-08 16:38:00 | 2018-08-08 16:40:00 | 2018-08-08 17:05:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
14 | 42487 | 2018-07-03 19:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-07-03 19:20:00 | [null] | [null] | 2018-07-03 19:20:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
15 | 42495 | 2018-07-05 05:57:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-07-05 06:00:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Bonne | |
16 | 42502 | 2018-07-06 18:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2018-07-06 18:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
17 | 42533 | 2018-07-14 21:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-07-14 21:20:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
18 | 44903 | 2018-10-06 01:05:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-10-06 01:19:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
19 | 46023 | 2018-12-27 20:10:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | [null] | [null] | [null] | 2018-12-27 20:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
20 | 46419 | 2019-01-08 03:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-01-08 04:36:00 | [null] | [null] | 2019-01-08 03:52:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
21 | 46485 | 2019-01-28 15:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | NM | 2019-01-28 16:00:00 | 2019-01-28 16:15:00 | 2019-01-28 16:10:00 | 2019-01-28 15:45:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
22 | 49772 | 2019-05-09 10:10:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2019-05-09 11:45:00 | 2019-05-09 10:25:00 | 2019-05-09 10:35:00 | 2019-05-09 10:14:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
23 | 52393 | 2019-09-15 23:54:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Usager | CEB | Non | NM | [null] | 2019-09-16 00:02:00 | [null] | 2019-09-16 00:02:00 | 2019-09-16 00:21:00 | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
24 | 52437 | 2019-09-30 20:35:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | [null] | 2019-09-30 21:00:00 | [null] | 2019-09-30 21:00:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
25 | 52478 | 2019-10-14 01:03:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | [null] | [null] | [null] | 2019-10-15 00:55:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
26 | 52742 | 2019-12-30 22:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | 2019-12-30 23:04:00 | [null] | [null] | 2019-12-30 23:04:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
27 | 23050 | 2015-01-17 14:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2015-01-17 14:47:00 | [null] | [null] | 2015-01-17 14:05:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
28 | 24434 | 2015-07-09 12:34:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Gendarmerie | CEB | Non | NM | 2015-07-09 13:15:00 | 2015-07-09 12:45:00 | 2015-07-09 13:35:00 | 2015-07-09 13:06:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
29 | 25054 | 2015-08-09 09:05:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Oui | M | 2015-08-09 09:07:00 | 2015-08-09 09:30:00 | 2015-08-09 09:35:00 | 2015-08-09 09:28:00 | 2015-08-09 11:20:00 | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
30 | 25707 | 2015-10-23 21:23:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Gendarmerie | CEB | Non | MAT | 2015-10-23 21:25:00 | [null] | 2015-10-23 21:25:00 | 2015-10-23 21:31:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
31 | 26042 | 2015-11-13 19:37:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Gendarmerie | CEB | Non | MAT | 2015-11-13 19:44:00 | [null] | 2015-11-13 19:40:00 | 2015-11-13 20:00:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
32 | 26139 | 2015-12-04 08:48:00 | -6.8844819035 | 33.9676199607 | 1 | 1 | 1 | Section courante | ITPC | Usager | CEB | Non | MAT | 2015-12-04 09:00:00 | [null] | 2015-12-04 09:00:00 | 2015-12-04 09:04:00 | [null] | Faute de conduite | Brouillard | Plein jour | Sèche | Utilisation professionnelle | Moyenne | |
33 | 26154 | 2015-12-17 07:38:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Patrouilleur | CEB | Non | MAT | 2015-12-17 07:55:00 | [null] | 2015-12-17 07:46:00 | 2015-12-17 07:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Moyenne | |
34 | 27294 | 2016-02-13 21:50:00 | -6.8833770213 | 33.9679229111 | 1 | 1 | 1 | Section courante | BAU | Gendarmerie | CEB | Oui | MAT | 2016-02-13 22:00:00 | [null] | 2016-02-13 22:00:00 | 2016-02-13 22:15:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
35 | 27300 | 2016-02-16 15:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | 2016-02-16 15:15:00 | [null] | [null] | 2016-02-16 15:45:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
36 | 29301 | 2016-07-09 13:32:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Gendarmerie | CEB | Oui | MAT | 2016-07-09 14:04:00 | [null] | 2016-07-09 13:52:00 | 2016-07-09 13:56:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
37 | 31631 | 2016-11-04 03:07:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | NM | 2016-11-04 03:15:00 | 2016-11-04 03:20:00 | 2016-11-04 04:06:00 | 2016-11-04 04:06:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
38 | 31675 | 2016-11-29 07:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2016-11-29 07:35:00 | [null] | 2016-11-29 07:30:00 | 2016-11-29 07:40:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Moyenne | |
39 | 32592 | 2017-04-19 11:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | NM | 2017-04-19 11:40:00 | [null] | 2017-04-19 11:45:00 | 2017-04-19 12:00:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
40 | 33501 | 2017-05-17 18:33:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2017-05-17 19:25:00 | 2017-05-17 18:46:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
41 | 34744 | 2017-07-12 07:35:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | NM | 2017-07-12 08:11:00 | 2017-07-12 08:21:00 | 2017-07-12 09:09:00 | 2017-07-12 07:49:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
42 | 34879 | 2017-08-17 02:27:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Oui | MAT | 2017-08-17 03:00:00 | [null] | 2017-08-17 03:00:00 | 2017-08-17 02:39:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Mauvaise | |
43 | 36145 | 2017-10-06 00:58:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2017-10-06 01:35:00 | [null] | 2017-10-06 01:22:00 | 2017-10-06 01:01:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
44 | 36173 | 2017-10-15 02:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-10-15 02:20:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
45 | 36177 | 2017-10-16 19:25:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2017-10-16 19:40:00 | 2017-10-16 19:35:00 | 2017-10-16 19:48:00 | 2017-10-16 19:48:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
46 | 36182 | 2017-10-21 04:10:00 | -6.8867695337 | 33.9671831312 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | M | 2017-10-21 04:50:00 | 2017-10-21 04:35:00 | 2017-10-21 04:20:00 | 2017-10-21 05:18:00 | 2017-10-21 05:48:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
47 | 36619 | 2017-11-23 23:44:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | MAT | 2017-11-24 00:34:00 | [null] | 2017-11-24 00:27:00 | 2017-11-24 00:05:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
48 | 37071 | 2017-12-15 16:04:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-12-15 16:04:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
49 | 37117 | 2017-12-31 07:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2017-12-31 08:50:00 | 2017-12-31 08:33:00 | 2017-12-31 08:16:00 | 2017-12-31 07:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
50 | 37536 | 2018-01-16 22:05:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2018-01-16 22:25:00 | [null] | 2018-01-16 22:20:00 | 2018-01-16 22:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Domicile-Travail | Bonne | |
51 | 37566 | 2018-01-25 23:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-01-26 00:39:00 | [null] | [null] | Faute de conduite | Pluie | Nuit sans éclairage | Mouillée | Utilisation professionnelle | Moyenne | |
52 | 39040 | 2018-03-05 13:41:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | NM | 2018-03-05 14:20:00 | 2018-03-05 14:10:00 | 2018-03-05 13:52:00 | 2018-03-05 13:59:00 | [null] | Faute de conduite | Pluie | Plein jour | Mouillée | Utilisation professionnelle | Moyenne | |
53 | 39070 | 2018-03-16 13:55:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-03-16 14:15:00 | 2018-03-16 14:00:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
54 | 40588 | 2018-05-13 00:50:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
55 | 40631 | 2018-05-28 20:04:00 | -6.8867695337 | 33.9671831312 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Centre d'appel | CEB | Non | MAT | 2018-05-28 21:10:00 | [null] | [null] | 2018-05-28 20:23:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Domicile-Travail | Bonne | |
56 | 41018 | 2018-06-11 13:48:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2018-06-11 14:20:00 | [null] | 2018-06-11 14:10:00 | 2018-06-11 13:52:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
57 | 42026 | 2018-08-10 12:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-08-10 12:16:00 | [null] | 2018-08-10 12:34:00 | 2018-08-10 12:14:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
58 | 42058 | 2018-08-16 21:14:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2018-08-16 21:20:00 | 2018-08-16 21:45:00 | 2018-08-16 21:45:00 | 2018-08-16 21:23:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
59 | 42094 | 2018-08-29 16:17:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | NM | 2018-08-29 17:05:00 | [null] | 2018-08-29 17:11:00 | 2018-08-29 17:20:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
60 | 42479 | 2018-07-01 23:11:00 | -6.8848234835 | 33.968028127 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Centre d'appel | CEB | Non | MAT | [null] | [null] | [null] | 2018-07-02 21:30:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
61 | 44468 | 2018-09-08 22:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-09-08 22:06:00 | [null] | 2018-09-08 22:04:00 | 2018-09-08 22:00:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
62 | 44472 | 2018-09-09 23:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
63 | 45480 | 2018-11-19 05:45:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | 2018-11-19 07:00:00 | [null] | 2018-11-19 06:29:00 | 2018-11-19 06:15:00 | [null] | Défaillance physique | Pluie | Nuit sans éclairage | Mouillée | Utilisation professionnelle | Moyenne | |
64 | 46408 | 2019-01-05 17:14:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-01-05 17:35:00 | [null] | 2019-01-05 17:40:00 | 2019-01-05 17:29:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
65 | 46411 | 2019-01-05 19:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Dépanneur agrée | CEB | Non | MAT | 2019-01-05 19:15:00 | [null] | 2019-01-05 19:20:00 | 2019-01-05 19:30:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
66 | 46450 | 2019-01-19 15:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-01-19 16:05:00 | [null] | 2019-01-19 16:08:00 | 2019-01-19 15:35:00 | [null] | Faute de conduite | Pluie | Plein jour | Mouillée | Promenade-Loisirs | Bonne | |
67 | 46891 | 2019-02-23 00:34:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | M | [null] | [null] | 2019-02-23 00:40:00 | 2019-02-23 00:40:00 | 2019-02-23 00:50:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
68 | 47422 | 2019-03-04 00:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Oui | MAT | 2019-03-04 00:20:00 | [null] | [null] | 2019-03-04 00:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
69 | 47424 | 2019-03-04 07:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-03-04 08:12:00 | [null] | 2019-03-04 08:04:00 | 2019-03-04 08:46:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
70 | 47448 | 2019-03-10 21:37:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-03-10 21:45:00 | [null] | 2019-03-10 21:40:00 | 2019-03-10 21:52:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
71 | 49710 | 2019-06-16 19:04:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | [null] | 2019-06-16 20:08:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
72 | 49749 | 2019-06-29 16:18:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-06-29 16:31:00 | [null] | [null] | 2019-06-29 16:19:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
73 | 49808 | 2019-05-22 10:00:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Oui | MAT | 2019-05-22 10:15:00 | [null] | 2019-05-22 10:02:00 | 2019-05-22 10:29:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
74 | 49831 | 2019-05-30 13:38:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | 2019-05-30 13:58:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
75 | 50174 | 2019-07-06 19:45:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | ITPC | [null] | CEB | Oui | M | 2019-07-06 20:00:00 | 2019-07-06 19:50:00 | [null] | 2019-07-06 20:08:00 | 2019-07-06 21:34:00 | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
76 | 50189 | 2019-07-11 10:38:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Echangeur | Bretelle entrée | [null] | CEB | Oui | MAT | 2019-07-11 11:00:00 | [null] | [null] | 2019-07-11 10:40:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
77 | 50385 | 2019-08-31 14:03:00 | -6.8844819035 | 33.9676199607 | 1 | 1 | 1 | Echangeur | Bretelle sortie | [null] | CEB | Non | M | [null] | 2019-08-31 14:18:00 | [null] | 2019-08-31 14:22:00 | 2019-08-31 14:31:00 | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
78 | 52477 | 2019-10-13 21:31:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | 2019-10-13 22:36:00 | 2019-10-13 21:51:00 | [null] | 2019-10-13 21:54:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
79 | 52519 | 2019-10-24 21:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | [null] | 2019-10-24 22:06:00 | [null] | 2019-10-24 21:47:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
80 | 52560 | 2019-11-09 03:10:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Oui | NM | 2019-11-09 04:46:00 | [null] | [null] | 2019-11-09 03:22:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
81 | 52569 | 2019-11-11 12:08:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | [null] | [null] | [null] | 2019-11-11 12:20:00 | [null] | Obstacle sur chaussée | Brouillard | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
82 | 52611 | 2019-11-20 15:38:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | MAT | [null] | [null] | [null] | 2019-11-20 16:03:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
83 | 52614 | 2019-11-20 23:33:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Oui | MAT | 2019-11-21 00:41:00 | [null] | [null] | [null] | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
84 | 52661 | 2019-12-04 22:16:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Non | NM | 2019-12-04 22:37:00 | 2019-12-04 22:20:00 | [null] | 2019-12-04 22:23:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
85 | 23057 | 2015-01-24 11:20:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Gendarmerie | CEB | Non | NM | 2015-01-24 11:40:00 | 2015-01-24 11:25:00 | 2015-01-24 11:20:00 | 2015-01-24 11:30:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
86 | 23065 | 2015-02-08 21:10:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | M | [null] | [null] | [null] | 2015-02-08 21:23:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
87 | 23069 | 2015-02-11 16:18:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Usager | CEB | Non | MAT | 2015-02-11 16:45:00 | [null] | 2015-02-11 16:50:00 | 2015-02-11 16:34:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
88 | 23098 | 2015-03-23 20:15:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Usager | CEB | Non | M | [null] | [null] | 2015-03-23 20:25:00 | 2015-03-23 20:26:00 | 2015-03-23 20:41:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | [null] | Bonne | |
89 | 23628 | 2015-04-09 16:55:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | NM | [null] | 2015-04-09 17:15:00 | 2015-04-09 17:00:00 | 2015-04-09 17:10:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
90 | 23643 | 2015-04-26 06:50:00 | -6.8877363667 | 33.9665854217 | 1 | 1 | 2 | Section courante | Pleine voie | Usager | CEB | Non | NM | 2015-04-27 06:15:00 | 2015-04-27 06:30:00 | 2015-04-27 06:15:00 | 2015-04-27 06:20:00 | [null] | Faute de conduite | Temps normal | Nuit avec éclairage | Sèche | Promenade-Loisirs | Moyenne | |
91 | 23925 | 2015-06-01 09:00:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2015-06-01 09:15:00 | [null] | 2015-06-01 09:38:00 | 2015-06-01 09:05:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
92 | 24429 | 2015-07-04 00:15:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2015-07-04 00:45:00 | 2015-07-04 00:55:00 | 2015-07-04 00:15:00 | 2015-07-04 00:40:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
93 | 24443 | 2015-07-14 10:30:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | MAT | 2015-07-14 10:45:00 | [null] | 2015-07-14 10:35:00 | 2015-07-14 11:00:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
94 | 25477 | 2015-09-12 01:07:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2015-09-12 01:09:00 | 2015-09-12 01:22:00 | 2015-09-12 01:09:00 | 2015-09-12 01:35:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
95 | 26043 | 2015-11-14 18:05:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2015-11-15 18:03:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
96 | 26058 | 2015-11-28 13:40:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Gendarmerie | CEB | Oui | MAT | 2015-11-28 13:43:00 | [null] | 2015-11-28 13:43:00 | 2015-11-28 13:49:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
97 | 26147 | 2015-12-09 22:17:00 | -6.89795183 | 33.9648743097 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2015-12-09 22:18:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
98 | 26161 | 2015-12-25 12:00:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | BAU | Usager | CEB | Non | MAT | 2015-12-25 12:10:00 | [null] | 2015-12-25 12:27:00 | 2015-12-25 12:09:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
99 | 27911 | 2016-04-09 21:25:00 | -6.8923316129 | 33.9659345487 | 1 | 2 | 2 | Section courante | Pleine voie | Agent ADM | CEB | Non | M | 2016-04-09 21:45:00 | 2016-04-09 21:45:00 | 2016-04-09 21:35:00 | 2016-04-09 21:40:00 | 2016-04-09 22:00:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
100 | 29332 | 2016-07-23 16:00:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | ITPC | Patrouilleur | CEB | Oui | MAT | 2016-07-23 16:08:00 | [null] | 2016-07-23 16:10:00 | 2016-07-23 16:10:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne |
[14]:
Rows: 1-100 of 23550 | Columns: 25
We still have some missing values because we don’t have a longitude or latitude for certain highways.
[16]:
Accidents.count_percent()
count | percent | |
"id" | 23550.0 | 100.0 |
"date" | 23550.0 | 100.0 |
"highway_id" | 23550.0 | 100.0 |
"traffic_direction" | 23550.0 | 100.0 |
"highway_position_km" | 23550.0 | 100.0 |
"information_center" | 23550.0 | 100.0 |
"equipment" | 23550.0 | 100.0 |
"cause" | 23550.0 | 100.0 |
"cause_detail" | 23550.0 | 100.0 |
"weather" | 23550.0 | 100.0 |
"lighting" | 23550.0 | 100.0 |
"pavement" | 23550.0 | 100.0 |
"visibility" | 23550.0 | 100.0 |
"location" | 23529.0 | 99.911 |
"location_detail" | 23529.0 | 99.911 |
"damage_infrastructure" | 23359.0 | 99.189 |
"traveling_reason" | 23289.0 | 98.892 |
"information_source" | 23246.0 | 98.709 |
"lon" | 22997.0 | 97.65180467091295 |
"lat" | 22997.0 | 97.65180467091295 |
"date_agent" | 22953.0 | 97.465 |
"date_tow_truck" | 18908.0 | 80.289 |
"date_gendarme" | 14226.0 | 60.408 |
"date_ambulance" | 7505.0 | 31.868 |
"date_fm" | 607.0 | 2.577 |
[16]:
We can still investigate this on our own and find the longitude and latitude of the highways in question and then use interpolation to fill the missing values.
Here’s what we found:
Autoroute A4 Berrechid - Beni Mellal (Berrechid - Khouribga - Beni Mellal)
Beni Mellal: lat = 32.339444 lon = -6.360833
Khouribga: lat = 32.886023 lon = -6.9208655
Berrechid: lat = 33.26553 lon = -7.58754
Route 103 El Jadida information
El Jadida: lat = 33.233334 lon = -8.500000
Let’s do the interpolations.
[18]:
import verticapy.stats as st
accidents["lat"] = st.case_when((accidents["highway_id"] == 4) &
(accidents["highway_id"] <= 77),
33.26553 * (1 - accidents["highway_position_km"] / 77)
+ 32.886023 * (accidents["highway_position_km"] / 77),
(accidents["highway_id"] == 4) &
(accidents["highway_id"] >= 77),
32.886023 * (1 - (accidents["highway_position_km"] - 77) / 95)
+ 32.339444 * ((accidents["highway_position_km"] - 77) / 95),
(accidents["highway_id"] == 103),
33.2415617419 * (1 - (accidents["highway_position_km"] / 5)
+ 33.233334 * (accidents["highway_position_km"] / 5)))
accidents["lon"] = st.case_when((accidents["highway_id"] == 4) &
(accidents["highway_id"] <= 77),
-7.58754 * (1 - accidents["highway_position_km"] / 77)
- 6.9208655 * (accidents["highway_position_km"] / 77),
(accidents["highway_id"] == 4) &
(accidents["highway_id"] >= 77),
-6.9208655 * (1 - (accidents["highway_position_km"] - 77) / 95)
- 6.360833 * ((accidents["highway_position_km"] - 77) / 95),
(accidents["highway_id"] == 103),
- 8.3952503827 * (1 - (accidents["highway_position_km"] / 5)
- 8.500000 * (accidents["highway_position_km"] / 5)))
123 idInt 100% | 📅 dateTimestamp 100% | Abc lonVarchar(100) 97% | 123 latFloat 97% | 123 highway_idInt 100% | 123 traffic_directionInt 100% | 123 highway_position_kmInt 100% | Abc locationVarchar(32) 99% | Abc location_detailVarchar(50) 99% | Abc information_sourceVarchar(34) 98% | Abc information_centerVarchar(20) 100% | Abc damage_infrastructureVarchar(20) 99% | Abc equipmentVarchar(20) 100% | 📅 date_tow_truckTimestamp 80% | 📅 date_ambulanceTimestamp 31% | 📅 date_gendarmeTimestamp 60% | 📅 date_agentTimestamp 97% | 📅 date_fmTimestamp 2% | Abc causeVarchar(46) 100% | Abc Varchar(74) 100% | Abc weatherVarchar(54) 100% | Abc lightingVarchar(54) 100% | Abc pavementVarchar(54) 100% | Abc traveling_reasonVarchar(54) 98% | Abc visibilityVarchar(54) 100% | |
1 | 26033 | 2015-11-09 16:14:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2015-11-09 16:35:00 | 2015-11-09 16:35:00 | 2015-11-09 17:05:00 | 2015-11-09 16:25:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
2 | 26041 | 2015-11-13 08:22:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | ITPC | Patrouilleur | CEB | Non | NM | 2015-11-13 08:40:00 | 2015-11-13 08:35:00 | 2015-11-13 08:25:00 | 2015-11-13 08:22:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
3 | 27305 | 2016-02-20 23:45:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
4 | 30477 | 2016-09-15 20:15:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Agent ADM | CEB | Non | NM | 2016-09-15 20:19:00 | 2016-09-15 20:22:00 | 2016-09-15 20:28:00 | 2016-09-15 20:31:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
5 | 31645 | 2016-11-14 08:30:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2016-11-14 09:07:00 | [null] | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
6 | 32595 | 2017-04-21 13:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2017-04-21 13:59:00 | [null] | [null] | 2017-04-21 13:50:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
7 | 33356 | 2017-06-04 17:21:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | NM | [null] | 2017-06-04 17:43:00 | 2017-06-04 17:43:00 | 2017-06-04 17:45:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
8 | 37053 | 2017-12-09 21:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-12-09 21:15:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
9 | 39945 | 2018-04-09 00:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-04-09 00:40:00 | 2018-04-09 00:30:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
10 | 40629 | 2018-05-27 15:50:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | 2018-05-27 15:50:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
11 | 41014 | 2018-06-10 12:45:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Centre d'appel | CEB | Oui | NM | 2018-06-10 13:32:00 | 2018-06-10 13:11:00 | 2018-06-10 13:00:00 | 2018-06-10 13:00:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
12 | 41975 | 2018-08-01 07:55:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-08-01 07:58:00 | [null] | [null] | 2018-08-01 08:02:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
13 | 42015 | 2018-08-08 16:28:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Agent ADM | CEB | Non | NM | [null] | 2018-08-08 16:38:00 | 2018-08-08 16:40:00 | 2018-08-08 17:05:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
14 | 42487 | 2018-07-03 19:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-07-03 19:20:00 | [null] | [null] | 2018-07-03 19:20:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
15 | 42495 | 2018-07-05 05:57:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-07-05 06:00:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Bonne | |
16 | 42502 | 2018-07-06 18:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2018-07-06 18:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
17 | 42533 | 2018-07-14 21:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-07-14 21:20:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
18 | 44903 | 2018-10-06 01:05:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2018-10-06 01:19:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
19 | 46023 | 2018-12-27 20:10:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | [null] | [null] | [null] | 2018-12-27 20:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
20 | 46419 | 2019-01-08 03:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-01-08 04:36:00 | [null] | [null] | 2019-01-08 03:52:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
21 | 46485 | 2019-01-28 15:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | BAU | Patrouilleur | CEB | Non | NM | 2019-01-28 16:00:00 | 2019-01-28 16:15:00 | 2019-01-28 16:10:00 | 2019-01-28 15:45:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
22 | 49772 | 2019-05-09 10:10:00 | -6.883341788 | 33.969118676 | 1 | 2 | 0 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2019-05-09 11:45:00 | 2019-05-09 10:25:00 | 2019-05-09 10:35:00 | 2019-05-09 10:14:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
23 | 52393 | 2019-09-15 23:54:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | BAU | Usager | CEB | Non | NM | [null] | 2019-09-16 00:02:00 | [null] | 2019-09-16 00:02:00 | 2019-09-16 00:21:00 | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
24 | 52437 | 2019-09-30 20:35:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | [null] | 2019-09-30 21:00:00 | [null] | 2019-09-30 21:00:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
25 | 52478 | 2019-10-14 01:03:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | [null] | [null] | [null] | 2019-10-15 00:55:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
26 | 52742 | 2019-12-30 22:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 0 | Section courante | Pleine voie | Usager | CEB | Non | MAT | 2019-12-30 23:04:00 | [null] | [null] | 2019-12-30 23:04:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
27 | 23050 | 2015-01-17 14:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2015-01-17 14:47:00 | [null] | [null] | 2015-01-17 14:05:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
28 | 24434 | 2015-07-09 12:34:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Gendarmerie | CEB | Non | NM | 2015-07-09 13:15:00 | 2015-07-09 12:45:00 | 2015-07-09 13:35:00 | 2015-07-09 13:06:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
29 | 25054 | 2015-08-09 09:05:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Oui | M | 2015-08-09 09:07:00 | 2015-08-09 09:30:00 | 2015-08-09 09:35:00 | 2015-08-09 09:28:00 | 2015-08-09 11:20:00 | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
30 | 25707 | 2015-10-23 21:23:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Gendarmerie | CEB | Non | MAT | 2015-10-23 21:25:00 | [null] | 2015-10-23 21:25:00 | 2015-10-23 21:31:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
31 | 26042 | 2015-11-13 19:37:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Gendarmerie | CEB | Non | MAT | 2015-11-13 19:44:00 | [null] | 2015-11-13 19:40:00 | 2015-11-13 20:00:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
32 | 26139 | 2015-12-04 08:48:00 | -6.8844819035 | 33.9676199607 | 1 | 1 | 1 | Section courante | ITPC | Usager | CEB | Non | MAT | 2015-12-04 09:00:00 | [null] | 2015-12-04 09:00:00 | 2015-12-04 09:04:00 | [null] | Faute de conduite | Brouillard | Plein jour | Sèche | Utilisation professionnelle | Moyenne | |
33 | 26154 | 2015-12-17 07:38:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Patrouilleur | CEB | Non | MAT | 2015-12-17 07:55:00 | [null] | 2015-12-17 07:46:00 | 2015-12-17 07:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Moyenne | |
34 | 27294 | 2016-02-13 21:50:00 | -6.8833770213 | 33.9679229111 | 1 | 1 | 1 | Section courante | BAU | Gendarmerie | CEB | Oui | MAT | 2016-02-13 22:00:00 | [null] | 2016-02-13 22:00:00 | 2016-02-13 22:15:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
35 | 27300 | 2016-02-16 15:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | 2016-02-16 15:15:00 | [null] | [null] | 2016-02-16 15:45:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
36 | 29301 | 2016-07-09 13:32:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Gendarmerie | CEB | Oui | MAT | 2016-07-09 14:04:00 | [null] | 2016-07-09 13:52:00 | 2016-07-09 13:56:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
37 | 31631 | 2016-11-04 03:07:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | NM | 2016-11-04 03:15:00 | 2016-11-04 03:20:00 | 2016-11-04 04:06:00 | 2016-11-04 04:06:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
38 | 31675 | 2016-11-29 07:20:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2016-11-29 07:35:00 | [null] | 2016-11-29 07:30:00 | 2016-11-29 07:40:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Moyenne | |
39 | 32592 | 2017-04-19 11:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | NM | 2017-04-19 11:40:00 | [null] | 2017-04-19 11:45:00 | 2017-04-19 12:00:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
40 | 33501 | 2017-05-17 18:33:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2017-05-17 19:25:00 | 2017-05-17 18:46:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
41 | 34744 | 2017-07-12 07:35:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | NM | 2017-07-12 08:11:00 | 2017-07-12 08:21:00 | 2017-07-12 09:09:00 | 2017-07-12 07:49:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
42 | 34879 | 2017-08-17 02:27:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Oui | MAT | 2017-08-17 03:00:00 | [null] | 2017-08-17 03:00:00 | 2017-08-17 02:39:00 | [null] | Défaillance physique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Mauvaise | |
43 | 36145 | 2017-10-06 00:58:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2017-10-06 01:35:00 | [null] | 2017-10-06 01:22:00 | 2017-10-06 01:01:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
44 | 36173 | 2017-10-15 02:15:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-10-15 02:20:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
45 | 36177 | 2017-10-16 19:25:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Non | NM | 2017-10-16 19:40:00 | 2017-10-16 19:35:00 | 2017-10-16 19:48:00 | 2017-10-16 19:48:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
46 | 36182 | 2017-10-21 04:10:00 | -6.8867695337 | 33.9671831312 | 1 | 2 | 1 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | M | 2017-10-21 04:50:00 | 2017-10-21 04:35:00 | 2017-10-21 04:20:00 | 2017-10-21 05:18:00 | 2017-10-21 05:48:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
47 | 36619 | 2017-11-23 23:44:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | MAT | 2017-11-24 00:34:00 | [null] | 2017-11-24 00:27:00 | 2017-11-24 00:05:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
48 | 37071 | 2017-12-15 16:04:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | [null] | [null] | [null] | 2017-12-15 16:04:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
49 | 37117 | 2017-12-31 07:30:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2017-12-31 08:50:00 | 2017-12-31 08:33:00 | 2017-12-31 08:16:00 | 2017-12-31 07:40:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
50 | 37536 | 2018-01-16 22:05:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | MAT | 2018-01-16 22:25:00 | [null] | 2018-01-16 22:20:00 | 2018-01-16 22:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Domicile-Travail | Bonne | |
51 | 37566 | 2018-01-25 23:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-01-26 00:39:00 | [null] | [null] | Faute de conduite | Pluie | Nuit sans éclairage | Mouillée | Utilisation professionnelle | Moyenne | |
52 | 39040 | 2018-03-05 13:41:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | NM | 2018-03-05 14:20:00 | 2018-03-05 14:10:00 | 2018-03-05 13:52:00 | 2018-03-05 13:59:00 | [null] | Faute de conduite | Pluie | Plein jour | Mouillée | Utilisation professionnelle | Moyenne | |
53 | 39070 | 2018-03-16 13:55:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | MAT | [null] | [null] | 2018-03-16 14:15:00 | 2018-03-16 14:00:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
54 | 40588 | 2018-05-13 00:50:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
55 | 40631 | 2018-05-28 20:04:00 | -6.8867695337 | 33.9671831312 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Centre d'appel | CEB | Non | MAT | 2018-05-28 21:10:00 | [null] | [null] | 2018-05-28 20:23:00 | [null] | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Domicile-Travail | Bonne | |
56 | 41018 | 2018-06-11 13:48:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2018-06-11 14:20:00 | [null] | 2018-06-11 14:10:00 | 2018-06-11 13:52:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
57 | 42026 | 2018-08-10 12:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-08-10 12:16:00 | [null] | 2018-08-10 12:34:00 | 2018-08-10 12:14:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
58 | 42058 | 2018-08-16 21:14:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | 2018-08-16 21:20:00 | 2018-08-16 21:45:00 | 2018-08-16 21:45:00 | 2018-08-16 21:23:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
59 | 42094 | 2018-08-29 16:17:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | NM | 2018-08-29 17:05:00 | [null] | 2018-08-29 17:11:00 | 2018-08-29 17:20:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
60 | 42479 | 2018-07-01 23:11:00 | -6.8848234835 | 33.968028127 | 1 | 2 | 1 | Echangeur | Bretelle sortie | Centre d'appel | CEB | Non | MAT | [null] | [null] | [null] | 2018-07-02 21:30:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
61 | 44468 | 2018-09-08 22:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2018-09-08 22:06:00 | [null] | 2018-09-08 22:04:00 | 2018-09-08 22:00:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
62 | 44472 | 2018-09-09 23:00:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | [null] | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
63 | 45480 | 2018-11-19 05:45:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Oui | MAT | 2018-11-19 07:00:00 | [null] | 2018-11-19 06:29:00 | 2018-11-19 06:15:00 | [null] | Défaillance physique | Pluie | Nuit sans éclairage | Mouillée | Utilisation professionnelle | Moyenne | |
64 | 46408 | 2019-01-05 17:14:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-01-05 17:35:00 | [null] | 2019-01-05 17:40:00 | 2019-01-05 17:29:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
65 | 46411 | 2019-01-05 19:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Dépanneur agrée | CEB | Non | MAT | 2019-01-05 19:15:00 | [null] | 2019-01-05 19:20:00 | 2019-01-05 19:30:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
66 | 46450 | 2019-01-19 15:20:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-01-19 16:05:00 | [null] | 2019-01-19 16:08:00 | 2019-01-19 15:35:00 | [null] | Faute de conduite | Pluie | Plein jour | Mouillée | Promenade-Loisirs | Bonne | |
67 | 46891 | 2019-02-23 00:34:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Centre d'appel | CEB | Non | M | [null] | [null] | 2019-02-23 00:40:00 | 2019-02-23 00:40:00 | 2019-02-23 00:50:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
68 | 47422 | 2019-03-04 00:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | Pleine voie | Patrouilleur | CEB | Oui | MAT | 2019-03-04 00:20:00 | [null] | [null] | 2019-03-04 00:10:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
69 | 47424 | 2019-03-04 07:10:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-03-04 08:12:00 | [null] | 2019-03-04 08:04:00 | 2019-03-04 08:46:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
70 | 47448 | 2019-03-10 21:37:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2019-03-10 21:45:00 | [null] | 2019-03-10 21:40:00 | 2019-03-10 21:52:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
71 | 49710 | 2019-06-16 19:04:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | [null] | [null] | [null] | 2019-06-16 20:08:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
72 | 49749 | 2019-06-29 16:18:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2019-06-29 16:31:00 | [null] | [null] | 2019-06-29 16:19:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
73 | 49808 | 2019-05-22 10:00:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Patrouilleur | CEB | Oui | MAT | 2019-05-22 10:15:00 | [null] | 2019-05-22 10:02:00 | 2019-05-22 10:29:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
74 | 49831 | 2019-05-30 13:38:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Echangeur | Bretelle entrée | Centre d'appel | CEB | Oui | MAT | [null] | [null] | [null] | 2019-05-30 13:58:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
75 | 50174 | 2019-07-06 19:45:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | ITPC | [null] | CEB | Oui | M | 2019-07-06 20:00:00 | 2019-07-06 19:50:00 | [null] | 2019-07-06 20:08:00 | 2019-07-06 21:34:00 | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
76 | 50189 | 2019-07-11 10:38:00 | -6.883341788 | 33.969118676 | 1 | 2 | 1 | Echangeur | Bretelle entrée | [null] | CEB | Oui | MAT | 2019-07-11 11:00:00 | [null] | [null] | 2019-07-11 10:40:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
77 | 50385 | 2019-08-31 14:03:00 | -6.8844819035 | 33.9676199607 | 1 | 1 | 1 | Echangeur | Bretelle sortie | [null] | CEB | Non | M | [null] | 2019-08-31 14:18:00 | [null] | 2019-08-31 14:22:00 | 2019-08-31 14:31:00 | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
78 | 52477 | 2019-10-13 21:31:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | 2019-10-13 22:36:00 | 2019-10-13 21:51:00 | [null] | 2019-10-13 21:54:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
79 | 52519 | 2019-10-24 21:40:00 | -6.8823455024 | 33.9683565063 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | [null] | 2019-10-24 22:06:00 | [null] | 2019-10-24 21:47:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
80 | 52560 | 2019-11-09 03:10:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Oui | NM | 2019-11-09 04:46:00 | [null] | [null] | 2019-11-09 03:22:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
81 | 52569 | 2019-11-11 12:08:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | NM | [null] | [null] | [null] | 2019-11-11 12:20:00 | [null] | Obstacle sur chaussée | Brouillard | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
82 | 52611 | 2019-11-20 15:38:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | BAU | Usager | CEB | Non | MAT | [null] | [null] | [null] | 2019-11-20 16:03:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
83 | 52614 | 2019-11-20 23:33:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Oui | MAT | 2019-11-21 00:41:00 | [null] | [null] | [null] | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
84 | 52661 | 2019-12-04 22:16:00 | -6.883341788 | 33.969118676 | 1 | 1 | 1 | Section courante | Pleine voie | Usager | CEB | Non | NM | 2019-12-04 22:37:00 | 2019-12-04 22:20:00 | [null] | 2019-12-04 22:23:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
85 | 23057 | 2015-01-24 11:20:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Gendarmerie | CEB | Non | NM | 2015-01-24 11:40:00 | 2015-01-24 11:25:00 | 2015-01-24 11:20:00 | 2015-01-24 11:30:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
86 | 23065 | 2015-02-08 21:10:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | M | [null] | [null] | [null] | 2015-02-08 21:23:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Bonne | |
87 | 23069 | 2015-02-11 16:18:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Usager | CEB | Non | MAT | 2015-02-11 16:45:00 | [null] | 2015-02-11 16:50:00 | 2015-02-11 16:34:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
88 | 23098 | 2015-03-23 20:15:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Usager | CEB | Non | M | [null] | [null] | 2015-03-23 20:25:00 | 2015-03-23 20:26:00 | 2015-03-23 20:41:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | [null] | Bonne | |
89 | 23628 | 2015-04-09 16:55:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | NM | [null] | 2015-04-09 17:15:00 | 2015-04-09 17:00:00 | 2015-04-09 17:10:00 | [null] | Obstacle sur chaussée | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
90 | 23643 | 2015-04-26 06:50:00 | -6.8877363667 | 33.9665854217 | 1 | 1 | 2 | Section courante | Pleine voie | Usager | CEB | Non | NM | 2015-04-27 06:15:00 | 2015-04-27 06:30:00 | 2015-04-27 06:15:00 | 2015-04-27 06:20:00 | [null] | Faute de conduite | Temps normal | Nuit avec éclairage | Sèche | Promenade-Loisirs | Moyenne | |
91 | 23925 | 2015-06-01 09:00:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Non | MAT | 2015-06-01 09:15:00 | [null] | 2015-06-01 09:38:00 | 2015-06-01 09:05:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Domicile-Travail | Bonne | |
92 | 24429 | 2015-07-04 00:15:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | Pleine voie | Patrouilleur | CEB | Non | NM | 2015-07-04 00:45:00 | 2015-07-04 00:55:00 | 2015-07-04 00:15:00 | 2015-07-04 00:40:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
93 | 24443 | 2015-07-14 10:30:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Dépanneur agrée | CEB | Non | MAT | 2015-07-14 10:45:00 | [null] | 2015-07-14 10:35:00 | 2015-07-14 11:00:00 | [null] | Défaillance physique | Temps normal | Plein jour | Sèche | Utilisation professionnelle | Bonne | |
94 | 25477 | 2015-09-12 01:07:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Centre d'appel | CEB | Non | MAT | 2015-09-12 01:09:00 | 2015-09-12 01:22:00 | 2015-09-12 01:09:00 | 2015-09-12 01:35:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Mauvaise | |
95 | 26043 | 2015-11-14 18:05:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2015-11-15 18:03:00 | [null] | Faute de conduite | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
96 | 26058 | 2015-11-28 13:40:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | Pleine voie | Gendarmerie | CEB | Oui | MAT | 2015-11-28 13:43:00 | [null] | 2015-11-28 13:43:00 | 2015-11-28 13:49:00 | [null] | Faute de conduite | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
97 | 26147 | 2015-12-09 22:17:00 | -6.89795183 | 33.9648743097 | 1 | 2 | 2 | Section courante | BAU | Patrouilleur | CEB | Oui | MAT | [null] | [null] | [null] | 2015-12-09 22:18:00 | [null] | Défaillance mécanique | Temps normal | Nuit sans éclairage | Sèche | Utilisation professionnelle | Moyenne | |
98 | 26161 | 2015-12-25 12:00:00 | -6.893413456 | 33.9655186707 | 1 | 1 | 2 | Section courante | BAU | Usager | CEB | Non | MAT | 2015-12-25 12:10:00 | [null] | 2015-12-25 12:27:00 | 2015-12-25 12:09:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne | |
99 | 27911 | 2016-04-09 21:25:00 | -6.8923316129 | 33.9659345487 | 1 | 2 | 2 | Section courante | Pleine voie | Agent ADM | CEB | Non | M | 2016-04-09 21:45:00 | 2016-04-09 21:45:00 | 2016-04-09 21:35:00 | 2016-04-09 21:40:00 | 2016-04-09 22:00:00 | Obstacle sur chaussée | Temps normal | Nuit sans éclairage | Sèche | Promenade-Loisirs | Moyenne | |
100 | 29332 | 2016-07-23 16:00:00 | -6.8934685812 | 33.9657153169 | 1 | 2 | 2 | Section courante | ITPC | Patrouilleur | CEB | Oui | MAT | 2016-07-23 16:08:00 | [null] | 2016-07-23 16:10:00 | 2016-07-23 16:10:00 | [null] | Défaillance mécanique | Temps normal | Plein jour | Sèche | Promenade-Loisirs | Bonne |
[18]:
Rows: 1-100 of 23550 | Columns: 25
Here’s the same map after we interpolated the missing values:
[18]:
from verticapy.datasets import load_world
# Filtering Morocco
morocco = load_world()
morocco = morocco[morocco["country"] == "Morocco"]
ax = morocco["geometry"].geo_plot(color = "white",
edgecolor='black',)
# Displaying Highways
accidents.scatter(["lon", "lat"],
by = "highway_id",
ax = ax)
[18]:
<AxesSubplot:xlabel='"lon"', ylabel='"lat"'>
In conclusion, before imputing missing data, you have to understand why it might be missing and how it relates to the rest of your dataset.