\n", " | distance_overtaker | \n", "distance_stationary | \n", "direction | \n", "way_id | \n", "course | \n", "speed | \n", "time | \n", "geometry | \n", "portal | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.82 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.913791 | \n", "4.611111 | \n", "2022-05-09 15:22:33+00:00 | \n", "POINT (13.42786 52.47392) | \n", "bbb | \n", "
1 | \n", "0.71 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.927347 | \n", "1.666667 | \n", "2022-05-09 15:22:48+00:00 | \n", "POINT (13.42766 52.47430) | \n", "bbb | \n", "
2 | \n", "1.57 | \n", "0.50 | \n", "-1 | \n", "849599088.0 | \n", "1.934648 | \n", "4.500000 | \n", "2022-05-09 15:23:26+00:00 | \n", "POINT (13.42738 52.47485) | \n", "bbb | \n", "
3 | \n", "1.26 | \n", "0.74 | \n", "-1 | \n", "568336446.0 | \n", "1.878984 | \n", "4.138889 | \n", "2022-05-09 15:23:33+00:00 | \n", "POINT (13.42746 52.47528) | \n", "bbb | \n", "
4 | \n", "2.05 | \n", "NaN | \n", "-1 | \n", "816236476.0 | \n", "2.021442 | \n", "4.083333 | \n", "2022-05-09 15:23:44+00:00 | \n", "POINT (13.42769 52.47581) | \n", "bbb | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2102 | \n", "1.29 | \n", "2.41 | \n", "1 | \n", "93245513.0 | \n", "0.794396 | \n", "3.916667 | \n", "2022-11-01 05:42:58+00:00 | \n", "POINT (8.00970 52.26666) | \n", "os | \n", "
2103 | \n", "1.69 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.721962 | \n", "2.361111 | \n", "2022-11-01 05:43:05+00:00 | \n", "POINT (8.01000 52.26678) | \n", "os | \n", "
2104 | \n", "1.39 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.536645 | \n", "2.138889 | \n", "2022-11-01 05:43:08+00:00 | \n", "POINT (8.01010 52.26682) | \n", "os | \n", "
2105 | \n", "1.52 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.930771 | \n", "2.750000 | \n", "2022-11-01 05:43:16+00:00 | \n", "POINT (8.01051 52.26698) | \n", "os | \n", "
2106 | \n", "1.51 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.880807 | \n", "2.694444 | \n", "2022-11-01 05:43:20+00:00 | \n", "POINT (8.01073 52.26707) | \n", "os | \n", "
108461 rows × 9 columns
\n", "\n", " | distance_overtaker | \n", "distance_stationary | \n", "direction | \n", "way_id | \n", "course | \n", "speed | \n", "time | \n", "geometry | \n", "portal | \n", "
---|---|---|---|---|---|---|---|---|---|
9911 | \n", "0.60 | \n", "NaN | \n", "-1 | \n", "39624415.0 | \n", "2.961233 | \n", "5.111111 | \n", "2022-09-09 14:32:10+00:00 | \n", "POINT (14.34543 51.51476) | \n", "bbb | \n", "
6777 | \n", "1.68 | \n", "NaN | \n", "-1 | \n", "999880944.0 | \n", "3.475565 | \n", "4.555556 | \n", "2022-08-23 05:23:16+00:00 | \n", "POINT (13.69015 51.63364) | \n", "bbb | \n", "
5567 | \n", "2.12 | \n", "NaN | \n", "1 | \n", "999880944.0 | \n", "0.304145 | \n", "4.083333 | \n", "2022-08-18 15:11:09+00:00 | \n", "POINT (13.69064 51.63369) | \n", "bbb | \n", "
6802 | \n", "1.56 | \n", "NaN | \n", "1 | \n", "48869301.0 | \n", "0.173665 | \n", "4.638889 | \n", "2022-08-23 15:09:37+00:00 | \n", "POINT (13.69265 51.63397) | \n", "bbb | \n", "
5914 | \n", "1.36 | \n", "NaN | \n", "-1 | \n", "15404302.0 | \n", "2.837079 | \n", "5.861111 | \n", "2022-08-22 11:32:16+00:00 | \n", "POINT (13.54767 51.56413) | \n", "bbb | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
15005 | \n", "1.04 | \n", "NaN | \n", "-1 | \n", "246509766.0 | \n", "4.735163 | \n", "2.888889 | \n", "2022-10-23 11:55:35+00:00 | \n", "POINT (13.04605 52.44711) | \n", "bbb | \n", "
3273 | \n", "2.24 | \n", "NaN | \n", "1 | \n", "269437458.0 | \n", "1.710760 | \n", "4.694444 | \n", "2022-08-07 12:50:39+00:00 | \n", "POINT (11.87009 52.91371) | \n", "bbb | \n", "
3274 | \n", "1.42 | \n", "NaN | \n", "1 | \n", "42075595.0 | \n", "0.716848 | \n", "3.888889 | \n", "2022-08-07 13:54:00+00:00 | \n", "POINT (11.90584 52.93102) | \n", "bbb | \n", "
3275 | \n", "0.83 | \n", "NaN | \n", "-1 | \n", "25486949.0 | \n", "6.183428 | \n", "4.555556 | \n", "2022-08-07 14:03:39+00:00 | \n", "POINT (11.93233 52.94099) | \n", "bbb | \n", "
3276 | \n", "1.16 | \n", "NaN | \n", "1 | \n", "25486932.0 | \n", "1.323250 | \n", "4.805556 | \n", "2022-08-07 14:07:31+00:00 | \n", "POINT (11.94161 52.94522) | \n", "bbb | \n", "
16312 rows × 9 columns
\n", "\n", " | distance_overtaker_binned_25 | \n", "counts | \n", "
---|---|---|
0 | \n", "<25 | \n", "20 | \n", "
1 | \n", "25-50 | \n", "122 | \n", "
2 | \n", "50-75 | \n", "446 | \n", "
3 | \n", "75-100 | \n", "1262 | \n", "
4 | \n", "100-125 | \n", "2364 | \n", "
5 | \n", "125-150 | \n", "3272 | \n", "
6 | \n", "150-175 | \n", "2959 | \n", "
7 | \n", "175-200 | \n", "2082 | \n", "
8 | \n", "200-225 | \n", "1419 | \n", "
9 | \n", "225-250 | \n", "725 | \n", "
10 | \n", ">250 | \n", "402 | \n", "
\n", " | distance_overtaker_binned_25 | \n", "counts | \n", "
---|---|---|
0 | \n", "<25 | \n", "193 | \n", "
1 | \n", "25-50 | \n", "1146 | \n", "
2 | \n", "50-75 | \n", "3609 | \n", "
3 | \n", "75-100 | \n", "9515 | \n", "
4 | \n", "100-125 | \n", "17627 | \n", "
5 | \n", "125-150 | \n", "22879 | \n", "
6 | \n", "150-175 | \n", "20069 | \n", "
7 | \n", "175-200 | \n", "13884 | \n", "
8 | \n", "200-225 | \n", "8544 | \n", "
9 | \n", "225-250 | \n", "4350 | \n", "
10 | \n", ">250 | \n", "2590 | \n", "
\n", " | distance_overtaker | \n", "distance_stationary | \n", "direction | \n", "way_id | \n", "course | \n", "speed | \n", "time | \n", "geometry | \n", "portal | \n", "distance_overtaker_binned | \n", "distance_overtaker_binned_25 | \n", "month | \n", "year | \n", "year_month | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "182.0 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.913791 | \n", "4.611111 | \n", "2022-05-09 15:22:33+00:00 | \n", "POINT (13.42786 52.47392) | \n", "bbb | \n", "150-200 | \n", "175-200 | \n", "5 | \n", "2022 | \n", "2022_5 | \n", "
1 | \n", "71.0 | \n", "NaN | \n", "-1 | \n", "28496022.0 | \n", "1.927347 | \n", "1.666667 | \n", "2022-05-09 15:22:48+00:00 | \n", "POINT (13.42766 52.47430) | \n", "bbb | \n", "50-100 | \n", "50-75 | \n", "5 | \n", "2022 | \n", "2022_5 | \n", "
2 | \n", "157.0 | \n", "50.0 | \n", "-1 | \n", "849599088.0 | \n", "1.934648 | \n", "4.500000 | \n", "2022-05-09 15:23:26+00:00 | \n", "POINT (13.42738 52.47485) | \n", "bbb | \n", "150-200 | \n", "150-175 | \n", "5 | \n", "2022 | \n", "2022_5 | \n", "
3 | \n", "126.0 | \n", "74.0 | \n", "-1 | \n", "568336446.0 | \n", "1.878984 | \n", "4.138889 | \n", "2022-05-09 15:23:33+00:00 | \n", "POINT (13.42746 52.47528) | \n", "bbb | \n", "100-150 | \n", "125-150 | \n", "5 | \n", "2022 | \n", "2022_5 | \n", "
4 | \n", "205.0 | \n", "NaN | \n", "-1 | \n", "816236476.0 | \n", "2.021442 | \n", "4.083333 | \n", "2022-05-09 15:23:44+00:00 | \n", "POINT (13.42769 52.47581) | \n", "bbb | \n", "200-250 | \n", "200-225 | \n", "5 | \n", "2022 | \n", "2022_5 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2102 | \n", "129.0 | \n", "241.0 | \n", "1 | \n", "93245513.0 | \n", "0.794396 | \n", "3.916667 | \n", "2022-11-01 05:42:58+00:00 | \n", "POINT (8.00970 52.26666) | \n", "os | \n", "100-150 | \n", "125-150 | \n", "11 | \n", "2022 | \n", "2022_11 | \n", "
2103 | \n", "169.0 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.721962 | \n", "2.361111 | \n", "2022-11-01 05:43:05+00:00 | \n", "POINT (8.01000 52.26678) | \n", "os | \n", "150-200 | \n", "150-175 | \n", "11 | \n", "2022 | \n", "2022_11 | \n", "
2104 | \n", "139.0 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.536645 | \n", "2.138889 | \n", "2022-11-01 05:43:08+00:00 | \n", "POINT (8.01010 52.26682) | \n", "os | \n", "100-150 | \n", "125-150 | \n", "11 | \n", "2022 | \n", "2022_11 | \n", "
2105 | \n", "152.0 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.930771 | \n", "2.750000 | \n", "2022-11-01 05:43:16+00:00 | \n", "POINT (8.01051 52.26698) | \n", "os | \n", "150-200 | \n", "150-175 | \n", "11 | \n", "2022 | \n", "2022_11 | \n", "
2106 | \n", "151.0 | \n", "NaN | \n", "1 | \n", "93245513.0 | \n", "0.880807 | \n", "2.694444 | \n", "2022-11-01 05:43:20+00:00 | \n", "POINT (8.01073 52.26707) | \n", "os | \n", "150-200 | \n", "150-175 | \n", "11 | \n", "2022 | \n", "2022_11 | \n", "
106657 rows × 14 columns
\n", "