Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

traffic_dataproc/nb_012_reorient.ipynb

Go to file
 
 
Cannot retrieve contributors at this time
4520 lines (4520 sloc) 144 KB
Raw Blame
Open in GitHub Desktop
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# nb 012 - Reorient\n",
"\n",
"Let's go over what we've got so far and our current goals.\n",
"\n",
"***WARNING*** that this will take a bunch of RAM. (4GB or so)"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"from math import floor, ceil\n",
"from matplotlib import path\n",
"\n",
"# Some useful tools/numbers we have of the time\n",
"start_time = 1404360000\n",
"end_time = 1405828798\n",
"\n",
"def time_to_index(tt, st = 1404360000, divisor=60):\n",
" return floor((tt-st)/divisor)\n",
"\n",
"NN = ceil((end_time - start_time)/60)\n",
"\n",
"# Our combined dataframes\n",
"# Index on `id`. For a given DataFrame.loc[id], the values will be sorted by time / pickup time\n",
"\n",
"OD = pd.read_pickle(\"./data/OD_combined.pkl\")\n",
"GPS = pd.read_pickle(\"./data/GPS_combined.pkl\")"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>ptime</th>\n",
" <th>dtime</th>\n",
" <th>plon</th>\n",
" <th>plat</th>\n",
" <th>dlon</th>\n",
" <th>dlat</th>\n",
" <th>pRID</th>\n",
" <th>dRID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>粤B000H6</th>\n",
" <td>1404362015</td>\n",
" <td>1404362351</td>\n",
" <td>113.945236</td>\n",
" <td>22.523884</td>\n",
" <td>113.922867</td>\n",
" <td>22.522551</td>\n",
" <td>139</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B000H6</th>\n",
" <td>1404364493</td>\n",
" <td>1404364882</td>\n",
" <td>114.067917</td>\n",
" <td>22.523817</td>\n",
" <td>114.086533</td>\n",
" <td>22.540051</td>\n",
" <td>58</td>\n",
" <td>283</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B000H6</th>\n",
" <td>1404385673</td>\n",
" <td>1404386603</td>\n",
" <td>114.122681</td>\n",
" <td>22.578699</td>\n",
" <td>114.126518</td>\n",
" <td>22.543716</td>\n",
" <td>200</td>\n",
" <td>177</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B000H6</th>\n",
" <td>1404387410</td>\n",
" <td>1404388549</td>\n",
" <td>114.106186</td>\n",
" <td>22.553267</td>\n",
" <td>114.131104</td>\n",
" <td>22.579533</td>\n",
" <td>212</td>\n",
" <td>191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B000H6</th>\n",
" <td>1404388859</td>\n",
" <td>1404390022</td>\n",
" <td>114.123848</td>\n",
" <td>22.579384</td>\n",
" <td>114.140366</td>\n",
" <td>22.557983</td>\n",
" <td>200</td>\n",
" <td>179</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>1405734575</td>\n",
" <td>1405734981</td>\n",
" <td>113.923698</td>\n",
" <td>22.507500</td>\n",
" <td>113.944298</td>\n",
" <td>22.507299</td>\n",
" <td>231</td>\n",
" <td>112</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>1405735137</td>\n",
" <td>1405735733</td>\n",
" <td>113.943604</td>\n",
" <td>22.507500</td>\n",
" <td>113.921097</td>\n",
" <td>22.518400</td>\n",
" <td>112</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>1405735782</td>\n",
" <td>1405736113</td>\n",
" <td>113.921501</td>\n",
" <td>22.514601</td>\n",
" <td>113.921303</td>\n",
" <td>22.497299</td>\n",
" <td>4</td>\n",
" <td>232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>1405737321</td>\n",
" <td>1405737696</td>\n",
" <td>113.894501</td>\n",
" <td>22.508499</td>\n",
" <td>113.909203</td>\n",
" <td>22.523100</td>\n",
" <td>228</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>1405738517</td>\n",
" <td>1405739654</td>\n",
" <td>113.919899</td>\n",
" <td>22.501900</td>\n",
" <td>113.920700</td>\n",
" <td>22.548100</td>\n",
" <td>232</td>\n",
" <td>133</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5893689 rows × 8 columns</p>\n",
"</div>"
],
"text/plain": [
" ptime dtime plon plat dlon dlat \\\n",
"id \n",
"粤B000H6 1404362015 1404362351 113.945236 22.523884 113.922867 22.522551 \n",
"粤B000H6 1404364493 1404364882 114.067917 22.523817 114.086533 22.540051 \n",
"粤B000H6 1404385673 1404386603 114.122681 22.578699 114.126518 22.543716 \n",
"粤B000H6 1404387410 1404388549 114.106186 22.553267 114.131104 22.579533 \n",
"粤B000H6 1404388859 1404390022 114.123848 22.579384 114.140366 22.557983 \n",
"... ... ... ... ... ... ... \n",
"粤BZ9Z49 1405734575 1405734981 113.923698 22.507500 113.944298 22.507299 \n",
"粤BZ9Z49 1405735137 1405735733 113.943604 22.507500 113.921097 22.518400 \n",
"粤BZ9Z49 1405735782 1405736113 113.921501 22.514601 113.921303 22.497299 \n",
"粤BZ9Z49 1405737321 1405737696 113.894501 22.508499 113.909203 22.523100 \n",
"粤BZ9Z49 1405738517 1405739654 113.919899 22.501900 113.920700 22.548100 \n",
"\n",
" pRID dRID \n",
"id \n",
"粤B000H6 139 4 \n",
"粤B000H6 58 283 \n",
"粤B000H6 200 177 \n",
"粤B000H6 212 191 \n",
"粤B000H6 200 179 \n",
"... ... ... \n",
"粤BZ9Z49 231 112 \n",
"粤BZ9Z49 112 4 \n",
"粤BZ9Z49 4 232 \n",
"粤BZ9Z49 228 3 \n",
"粤BZ9Z49 232 133 \n",
"\n",
"[5893689 rows x 8 columns]"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"OD"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lon</th>\n",
" <th>lat</th>\n",
" <th>time</th>\n",
" <th>speed</th>\n",
" <th>RID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.961098</td>\n",
" <td>22.553101</td>\n",
" <td>1404360002</td>\n",
" <td>17</td>\n",
" <td>158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962303</td>\n",
" <td>22.547001</td>\n",
" <td>1404360108</td>\n",
" <td>21</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962997</td>\n",
" <td>22.547001</td>\n",
" <td>1404360138</td>\n",
" <td>0</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963799</td>\n",
" <td>22.546400</td>\n",
" <td>1404360168</td>\n",
" <td>11</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963997</td>\n",
" <td>22.544399</td>\n",
" <td>1404360232</td>\n",
" <td>8</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>114.023399</td>\n",
" <td>22.620399</td>\n",
" <td>1405828297</td>\n",
" <td>20</td>\n",
" <td>301</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>114.022102</td>\n",
" <td>22.620100</td>\n",
" <td>1405828327</td>\n",
" <td>0</td>\n",
" <td>301</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>114.020599</td>\n",
" <td>22.620100</td>\n",
" <td>1405828384</td>\n",
" <td>0</td>\n",
" <td>301</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>114.013603</td>\n",
" <td>22.608601</td>\n",
" <td>1405828731</td>\n",
" <td>31</td>\n",
" <td>290</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤BZ9Z49</th>\n",
" <td>114.009903</td>\n",
" <td>22.605499</td>\n",
" <td>1405828774</td>\n",
" <td>35</td>\n",
" <td>297</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>17649212 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" lon lat time speed RID\n",
"id \n",
"粤B0AA56 113.961098 22.553101 1404360002 17 158\n",
"粤B0AA56 113.962303 22.547001 1404360108 21 311\n",
"粤B0AA56 113.962997 22.547001 1404360138 0 311\n",
"粤B0AA56 113.963799 22.546400 1404360168 11 311\n",
"粤B0AA56 113.963997 22.544399 1404360232 8 311\n",
"... ... ... ... ... ...\n",
"粤BZ9Z49 114.023399 22.620399 1405828297 20 301\n",
"粤BZ9Z49 114.022102 22.620100 1405828327 0 301\n",
"粤BZ9Z49 114.020599 22.620100 1405828384 0 301\n",
"粤BZ9Z49 114.013603 22.608601 1405828731 31 290\n",
"粤BZ9Z49 114.009903 22.605499 1405828774 35 297\n",
"\n",
"[17649212 rows x 5 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"GPS"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Data processing\n",
"\n",
"We want to get:\n",
"\n",
" * `Demand[region ID][timeslot]` = number of pickups in that region at that time.\n",
" * `Supply[region ID][timeslot]` = number of charging --> vacant transitions at that time.\n",
"\n",
"We have `Demand`, we now need `Supply`.\n",
"\n",
"This requires:\n",
"\n",
" 1. We generate a timeline for each ID of pickup/dropoff data and GPS data\n",
" 2. We extract charging events from this data for each algorithm.\n",
" 3. We have occupied <--> vacant <--> low battery / charging.\n",
" 4. This means that a car can't go from occupied to low-battery / charging in a timestep. (How to handle? This might not even occur.)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### IDs and exploration -- We find that there are few GPS IDs, and most OD IDs are not represented in GPS data!"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'粤B0BB42',\n",
" '粤B0BX16',\n",
" '粤B0BX35',\n",
" '粤B24764',\n",
" '粤B39605',\n",
" '粤B4BS21',\n",
" '粤B4BY31',\n",
" '粤B5BB26',\n",
" '粤B5BB79',\n",
" '粤B6BW07',\n",
" '粤B8BA76',\n",
" '粤BH3E47',\n",
" '粤BH4Q46',\n",
" '粤BH8L49',\n",
" '粤BH8Q18',\n",
" '粤BW5Z47',\n",
" '粤BX4S40',\n",
" '粤BY4Z31',\n",
" '粤BY8V47'}"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Question - are the set of IDs in the OD df and the GPS df the same?\n",
"\n",
"GPS_IDs = set(GPS.index)\n",
"OD_IDs = set(OD.index)\n",
"GPS_IDs.difference(OD_IDs)\n",
"\n",
"# All elements in GPS_IDs but not in OD_IDs"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'粤B8HS47',\n",
" '粤BL1H23',\n",
" '粤B1MS03',\n",
" '粤B0MU42',\n",
" '粤B746U9',\n",
" '粤B279G2',\n",
" '粤BK0Z71',\n",
" '粤BL4Q06',\n",
" '粤B2HX47',\n",
" '粤B9HL90',\n",
" '粤BW8N32',\n",
" '粤BK4X42',\n",
" '粤B718U1',\n",
" '粤B491F5',\n",
" '粤BA2G94',\n",
" '粤BN3F72',\n",
" '粤B282Y2',\n",
" '粤BW4A52',\n",
" '粤B285Y8',\n",
" '粤BW4E72',\n",
" '粤B4HS50',\n",
" '粤B546W0',\n",
" '粤B388Q2',\n",
" '粤BW9D60',\n",
" '粤B1WK31',\n",
" '粤B840U9',\n",
" '粤BF7755',\n",
" '粤B292Y7',\n",
" '粤B961U9',\n",
" '粤B9HT06',\n",
" '粤B3367D',\n",
" '粤B473WZ',\n",
" '粤BCH726',\n",
" '粤B047ZC',\n",
" '粤B4HQ76',\n",
" '粤B735YU',\n",
" '粤B7BV41',\n",
" '粤B7620D',\n",
" '粤BL3E43',\n",
" '粤BJ68E2',\n",
" '粤B204F0',\n",
" '粤BK4V26',\n",
" '粤B4789B',\n",
" '粤B776ZD',\n",
" '粤BK9V12',\n",
" '粤B3NP30',\n",
" '粤B540S9',\n",
" '粤B1MQ99',\n",
" '粤B2FQ12',\n",
" '粤B3MS41',\n",
" '粤BA4B54',\n",
" '粤B3WK83',\n",
" '粤BU3L76',\n",
" '粤B464P0',\n",
" '粤B6WQ40',\n",
" '粤B4H575',\n",
" '粤B2VU75',\n",
" '粤BA6P15',\n",
" '粤B165YN',\n",
" '粤B576ZK',\n",
" '粤BK4W63',\n",
" '粤B093YS',\n",
" '粤B4MV61',\n",
" '粤BD1S84',\n",
" '粤B715U2',\n",
" '粤BM03M1',\n",
" '粤B267Z3',\n",
" '粤B7443A',\n",
" '粤B97U25',\n",
" '粤B1835D',\n",
" '粤B6MP51',\n",
" '粤B707U9',\n",
" '粤B4HL15',\n",
" '粤B6447E',\n",
" '粤BK9V15',\n",
" '粤B926F6',\n",
" '粤BA2A14',\n",
" '粤B551E0',\n",
" '粤B199H1',\n",
" '粤B7FS90',\n",
" '粤B1HL12',\n",
" '粤BL9H37',\n",
" '粤B214H7',\n",
" '粤B4920B',\n",
" '粤BL4E87',\n",
" '粤B4MN41',\n",
" '粤B544U1',\n",
" '粤B074U5',\n",
" '粤BQ9M52',\n",
" '粤BL0H80',\n",
" '粤B2BV12',\n",
" '粤B0FU70',\n",
" '粤BJ4T54',\n",
" '粤BD2S24',\n",
" '粤B4MV35',\n",
" '粤B9WJ90',\n",
" '粤BD9P63',\n",
" '粤B498S0',\n",
" '粤B0325D',\n",
" '粤B0HQ43',\n",
" '粤B359Q9',\n",
" '粤B438E7',\n",
" '粤B9WR67',\n",
" '粤B1FU75',\n",
" '粤B1ZU32',\n",
" '粤B501ZK',\n",
" '粤B7NN16',\n",
" '粤B8WK47',\n",
" '粤BU8L52',\n",
" '粤B019ZB',\n",
" '粤B312H8',\n",
" '粤B283Z3',\n",
" '粤B834W1',\n",
" '粤B767YP',\n",
" '粤B4HU00',\n",
" '粤B574T7',\n",
" '粤B357Z8',\n",
" '粤B094W7',\n",
" '粤B0HQ53',\n",
" '粤B362R5',\n",
" '粤B4WW18',\n",
" '粤B175YS',\n",
" '粤B909W0',\n",
" '粤BL0M48',\n",
" '粤B383P9',\n",
" '粤BK9Y46',\n",
" '粤B244G0',\n",
" '粤BK7V22',\n",
" '粤BL0X41',\n",
" '粤B0MX50',\n",
" '粤B5292B',\n",
" '粤B451ZB',\n",
" '粤B4WV13',\n",
" '粤B8MP05',\n",
" '粤B347S2',\n",
" '粤B258G2',\n",
" '粤B70U45',\n",
" '粤BM14M1',\n",
" '粤B6VU01',\n",
" '粤BL2G45',\n",
" '粤B0HC67',\n",
" '粤B5WK98',\n",
" '粤BB0E69',\n",
" '粤B8SU95',\n",
" '粤B328YW',\n",
" '粤BW9Q73',\n",
" '粤BL2G47',\n",
" '粤B0MS40',\n",
" '粤BL0H47',\n",
" '粤B1HL50',\n",
" '粤B4BS42',\n",
" '粤BD3P64',\n",
" '粤BL7J46',\n",
" '粤BZ5Q41',\n",
" '粤BA00F2',\n",
" '粤B3YY47',\n",
" '粤B8VW31',\n",
" '粤B953U6',\n",
" '粤B2HU27',\n",
" '粤B1BU42',\n",
" '粤B4SM19',\n",
" '粤BM2G05',\n",
" '粤B4MZ29',\n",
" '粤B571W8',\n",
" '粤B4VW56',\n",
" '粤B1NH49',\n",
" '粤BL4S07',\n",
" '粤B6HP50',\n",
" '粤B464S6',\n",
" '粤B244G2',\n",
" '粤B473WY',\n",
" '粤B5WW48',\n",
" '粤B6WT68',\n",
" '粤B786Z3',\n",
" '粤B3CS47',\n",
" '粤B0BS20',\n",
" '粤B0WK13',\n",
" '粤B544G7',\n",
" '粤B7HX18',\n",
" '粤BC1P24',\n",
" '粤BDV142',\n",
" '粤B1HQ13',\n",
" '粤B835E0',\n",
" '粤B6589E',\n",
" '粤B405YP',\n",
" '粤B757U1',\n",
" '粤B805E5',\n",
" '粤B719U0',\n",
" '粤B1802D',\n",
" '粤BX1Y33',\n",
" '粤B1HQ57',\n",
" '粤B448S5',\n",
" '粤B4VU31',\n",
" '粤BQ6P32',\n",
" '粤B77U17',\n",
" '粤B5HX45',\n",
" '粤B9424G',\n",
" '粤B419ZC',\n",
" '粤B783Z1',\n",
" '粤B0563D',\n",
" '粤B069U8',\n",
" '粤B3HR70',\n",
" '粤B494G3',\n",
" '粤B8NA12',\n",
" '粤BK8X90',\n",
" '粤B5WR93',\n",
" '粤B92U87',\n",
" '粤B1FU17',\n",
" '粤B2NS53',\n",
" '粤B985YZ',\n",
" '粤B4HL52',\n",
" '粤B320F0',\n",
" '粤B047W1',\n",
" '粤BD2G41',\n",
" '粤B587U7',\n",
" '粤B8BU87',\n",
" '粤B407YU',\n",
" '粤BA5F40',\n",
" '粤BN5A47',\n",
" '粤BU1L72',\n",
" '粤BK3W49',\n",
" '粤BK2F15',\n",
" '粤B2NK27',\n",
" '粤B2NS12',\n",
" '粤B9HW50',\n",
" '粤B336Y8',\n",
" '粤BW8E41',\n",
" '粤B4NJ52',\n",
" '粤BN4B47',\n",
" '粤B898F0',\n",
" '粤BG0Y42',\n",
" '粤B6WK75',\n",
" '粤B301Y0',\n",
" '粤B1878D',\n",
" '粤BK4W92',\n",
" '粤BL4Q62',\n",
" '粤B0HU79',\n",
" '粤B7HX36',\n",
" '粤B6110E',\n",
" '粤B4BG47',\n",
" '粤BK5F94',\n",
" '粤BK4X97',\n",
" '粤B4HX20',\n",
" '粤BU9K96',\n",
" '粤B070YP',\n",
" '粤B776S3',\n",
" '粤B5NC38',\n",
" '粤B3MX56',\n",
" '粤B404U2',\n",
" '粤BC1P77',\n",
" '粤B7NP29',\n",
" '粤B381R7',\n",
" '粤B7FP79',\n",
" '粤B7WK32',\n",
" '粤B913E6',\n",
" '粤B7SM09',\n",
" '粤B241C5',\n",
" '粤B896F6',\n",
" '粤BL0R35',\n",
" '粤B3187E',\n",
" '粤BJ46C1',\n",
" '粤B812E3',\n",
" '粤B551U5',\n",
" '粤B4405D',\n",
" '粤B3382U',\n",
" '粤B196Y3',\n",
" '粤B5374K',\n",
" '粤B7BU67',\n",
" '粤B242U7',\n",
" '粤B046B7',\n",
" '粤B4MX28',\n",
" '粤B766Z6',\n",
" '粤B5FT76',\n",
" '粤B5MP77',\n",
" '粤B2848B',\n",
" '粤B416YU',\n",
" '粤B547ZC',\n",
" '粤B999ZB',\n",
" '粤B706G0',\n",
" '粤B087U2',\n",
" '粤BX2X10',\n",
" '粤B6526E',\n",
" '粤B2BS01',\n",
" '粤B431ZC',\n",
" '粤B5HR88',\n",
" '粤B7NH18',\n",
" '粤B912YU',\n",
" '粤BC0P78',\n",
" '粤B352ZB',\n",
" '粤B271ZD',\n",
" '粤BDV848',\n",
" '粤B424R7',\n",
" '粤B649F5',\n",
" '粤B7ZU08',\n",
" '粤B1HR43',\n",
" '粤B3DY47',\n",
" '粤B499YP',\n",
" '粤B689F0',\n",
" '粤B055V0',\n",
" '粤B4WT26',\n",
" '粤B392W0',\n",
" '粤B3ZU82',\n",
" '粤B074F1',\n",
" '粤B316F5',\n",
" '粤B439YN',\n",
" '粤B093E8',\n",
" '粤B1HL16',\n",
" '粤BN2Z17',\n",
" '粤BL4H30',\n",
" '粤BA7M74',\n",
" '粤B3053B',\n",
" '粤B8NQ70',\n",
" '粤B1MX75',\n",
" '粤B6681H',\n",
" '粤BW4Q40',\n",
" '粤B3HQ61',\n",
" '粤B4HX21',\n",
" '粤B020G7',\n",
" '粤B308F0',\n",
" '粤BD9P55',\n",
" '粤B358R0',\n",
" '粤B681U5',\n",
" '粤BA5E66',\n",
" '粤B990YZ',\n",
" '粤B1NW09',\n",
" '粤B067Z3',\n",
" '粤B378T7',\n",
" '粤B439YP',\n",
" '粤BL1H00',\n",
" '粤BG9X11',\n",
" '粤B2ZY19',\n",
" '粤B4906B',\n",
" '粤B6HX07',\n",
" '粤B0FU78',\n",
" '粤B6SU79',\n",
" '粤B46793',\n",
" '粤B096Y7',\n",
" '粤BD3N46',\n",
" '粤B9CD47',\n",
" '粤B9FM40',\n",
" '粤B256Y9',\n",
" '粤B246ZE',\n",
" '粤B4CQ70',\n",
" '粤BK4V63',\n",
" '粤B9HG45',\n",
" '粤B890W6',\n",
" '粤B449W7',\n",
" '粤BX3Y29',\n",
" '粤BL3J40',\n",
" '粤B1490D',\n",
" '粤BL5G47',\n",
" '粤B227Y5',\n",
" '粤B7MT92',\n",
" '粤BD8N54',\n",
" '粤BH2E64',\n",
" '粤BZ3P40',\n",
" '粤B913YZ',\n",
" '粤B8FS37',\n",
" '粤B928F6',\n",
" '粤BL9G91',\n",
" '粤BL1R13',\n",
" '粤BA2C57',\n",
" '粤BDS325',\n",
" '粤B3VW40',\n",
" '粤BA5E26',\n",
" '粤BL3R41',\n",
" '粤B340YY',\n",
" '粤B393ZB',\n",
" '粤B403U1',\n",
" '粤B471YP',\n",
" '粤BX9R55',\n",
" '粤B24775',\n",
" '粤B3CP40',\n",
" '粤B2HX17',\n",
" '粤BA6G30',\n",
" '粤B2ZU69',\n",
" '粤B3MS77',\n",
" '粤B473T6',\n",
" '粤B060YU',\n",
" '粤B0WW33',\n",
" '粤B4AJ71',\n",
" '粤BM09M1',\n",
" '粤B045U0',\n",
" '粤BA4A79',\n",
" '粤B274R5',\n",
" '粤B6NP65',\n",
" '粤BZ4V17',\n",
" '粤B715YP',\n",
" '粤BN0A80',\n",
" '粤BX0X35',\n",
" '粤BL4H51',\n",
" '粤B1533D',\n",
" '粤B397Z0',\n",
" '粤B160Y3',\n",
" '粤B5WK11',\n",
" '粤BA3B24',\n",
" '粤BM4G30',\n",
" '粤B3542B',\n",
" '粤BQ7N73',\n",
" '粤BA6E67',\n",
" '粤B850F0',\n",
" '粤BK2W97',\n",
" '粤BS1Q89',\n",
" '粤B4BS19',\n",
" '粤B708U0',\n",
" '粤B9NA22',\n",
" '粤BL0H50',\n",
" '粤BL4M27',\n",
" '粤BA94L5',\n",
" '粤BK6V72',\n",
" '粤B414U1',\n",
" '粤B457H7',\n",
" '粤B0FQ97',\n",
" '粤B5NX86',\n",
" '粤B741U2',\n",
" '粤B1WR83',\n",
" '粤B589W7',\n",
" '粤B539YU',\n",
" '粤B515S0',\n",
" '粤B993W5',\n",
" '粤BCU301',\n",
" '粤B730YP',\n",
" '粤B908F6',\n",
" '粤BD2D45',\n",
" '粤B7CR41',\n",
" '粤BL4P17',\n",
" '粤B083R8',\n",
" '粤BDS492',\n",
" '粤B440G5',\n",
" '粤B1162D',\n",
" '粤B4HR20',\n",
" '粤B274Y1',\n",
" '粤B6NP28',\n",
" '粤B7WQ69',\n",
" '粤B6SU57',\n",
" '粤BK2Z35',\n",
" '粤B5ND83',\n",
" '粤BM06M1',\n",
" '粤B4HX30',\n",
" '粤BCB771',\n",
" '粤BK2F51',\n",
" '粤BK4Y13',\n",
" '粤BK1U62',\n",
" '粤B427WZ',\n",
" '粤B259G1',\n",
" '粤B4HL27',\n",
" '粤B392H6',\n",
" '粤B841E8',\n",
" '粤B256YW',\n",
" '粤BK1X29',\n",
" '粤B073P5',\n",
" '粤B4WW63',\n",
" '粤BG9W85',\n",
" '粤BS9P95',\n",
" '粤B141G9',\n",
" '粤B1HL51',\n",
" '粤B841YY',\n",
" '粤B9996B',\n",
" '粤B840Y0',\n",
" '粤B6WK35',\n",
" '粤BJ74B8',\n",
" '粤B1HY28',\n",
" '粤BK8P59',\n",
" '粤B7961D',\n",
" '粤B2NP29',\n",
" '粤B2HL60',\n",
" '粤B687U5',\n",
" '粤B2761B',\n",
" '粤B8MP31',\n",
" '粤B846Z9',\n",
" '粤BV7W53',\n",
" '粤B383ZB',\n",
" '粤BE9646',\n",
" '粤BK1X59',\n",
" '粤BX1Y35',\n",
" '粤B0BV65',\n",
" '粤B0HK46',\n",
" '粤B2FQ17',\n",
" '粤BG1V40',\n",
" '粤BK4Y47',\n",
" '粤B9BT47',\n",
" '粤B0HL61',\n",
" '粤B417ZC',\n",
" '粤BK0Z95',\n",
" '粤BF4411',\n",
" '粤B3301B',\n",
" '粤B0HY37',\n",
" '粤B437ZB',\n",
" '粤B614W7',\n",
" '粤B045H0',\n",
" '粤B864W2',\n",
" '粤B7FP73',\n",
" '粤B7SU16',\n",
" '粤B7MU55',\n",
" '粤B258G6',\n",
" '粤B1MS92',\n",
" '粤B3WT37',\n",
" '粤BA1B41',\n",
" '粤B484U2',\n",
" '粤B785E1',\n",
" '粤B1WT95',\n",
" '粤B4HR72',\n",
" '粤BM05M0',\n",
" '粤B9WL70',\n",
" '粤B3944G',\n",
" '粤B9NF11',\n",
" '粤B653Z2',\n",
" '粤B465YP',\n",
" '粤B934G3',\n",
" '粤B0143D',\n",
" '粤B9BT72',\n",
" '粤B6123D',\n",
" '粤BK4P16',\n",
" '粤B0FU08',\n",
" '粤B2BY47',\n",
" '粤B832E7',\n",
" '粤BL1Q47',\n",
" '粤B903YZ',\n",
" '粤B146G1',\n",
" '粤BD7Q43',\n",
" '粤B3NS03',\n",
" '粤B44724',\n",
" '粤B8UE09',\n",
" '粤B043ZE',\n",
" '粤B430R3',\n",
" '粤BC9159',\n",
" '粤BK3V47',\n",
" '粤B1WT37',\n",
" '粤BA1K01',\n",
" '粤BN2A97',\n",
" '粤B487YP',\n",
" '粤B4HR05',\n",
" '粤BK3X40',\n",
" '粤BK2X90',\n",
" '粤BV2R45',\n",
" '粤BCG342',\n",
" '粤BL4C02',\n",
" '粤B706U9',\n",
" '粤B3256B',\n",
" '粤B901W3',\n",
" '粤B152ZD',\n",
" '粤BV0X76',\n",
" '粤B9UU38',\n",
" '粤B7UF37',\n",
" '粤BX4X33',\n",
" '粤B422R2',\n",
" '粤B389P6',\n",
" '粤B862Y7',\n",
" '粤B0937D',\n",
" '粤B4HY01',\n",
" '粤B910G2',\n",
" '粤B7BT92',\n",
" '粤BL3R02',\n",
" '粤B964R6',\n",
" '粤B256Y7',\n",
" '粤B5ZU30',\n",
" '粤B1HQ45',\n",
" '粤BK1Z99',\n",
" '粤B533S1',\n",
" '粤B1ND59',\n",
" '粤BL2C46',\n",
" '粤BK3F60',\n",
" '粤BV1P21',\n",
" '粤B4HS87',\n",
" '粤B292G7',\n",
" '粤B944F0',\n",
" '粤BX4Y70',\n",
" '粤BX2X83',\n",
" '粤B2BJ47',\n",
" '粤B798S6',\n",
" '粤B305H1',\n",
" '粤B7FP07',\n",
" '粤BL2H09',\n",
" '粤BL7Z40',\n",
" '粤B0BS03',\n",
" '粤BK5T32',\n",
" '粤B059U1',\n",
" '粤BK5V70',\n",
" '粤B5MV62',\n",
" '粤B445S7',\n",
" '粤B4CP41',\n",
" '粤B14953',\n",
" '粤B311R9',\n",
" '粤BW9L57',\n",
" '粤B502V0',\n",
" '粤BL7G41',\n",
" '粤B072Y3',\n",
" '粤B857E6',\n",
" '粤BA5N44',\n",
" '粤BS9N63',\n",
" '粤BJ9W74',\n",
" '粤BA3E04',\n",
" '粤B999YZ',\n",
" '粤BJ24B0',\n",
" '粤B8HY39',\n",
" '粤B977W9',\n",
" '粤BD7K36',\n",
" '粤B184Y5',\n",
" '粤B300Y1',\n",
" '粤B4BS79',\n",
" '粤B8MP11',\n",
" '粤B4NK20',\n",
" '粤B105S8',\n",
" '粤B2MQ86',\n",
" '粤B043T7',\n",
" '粤BA0K61',\n",
" '粤BD4S90',\n",
" '粤BK0X01',\n",
" '粤B2WQ35',\n",
" '粤BJ47B0',\n",
" '粤B1709D',\n",
" '粤BJ2P53',\n",
" '粤B0HL72',\n",
" '粤BK3T72',\n",
" '粤B723ZD',\n",
" '粤B7HZ45',\n",
" '粤B033ZD',\n",
" '粤B3342V',\n",
" '粤B528YU',\n",
" '粤B748Z5',\n",
" '粤B1MQ55',\n",
" '粤B377Q5',\n",
" '粤B7HT27',\n",
" '粤B745R1',\n",
" '粤B1MX26',\n",
" '粤B884W5',\n",
" '粤B561G3',\n",
" '粤B095V5',\n",
" '粤BK9V07',\n",
" '粤B058V2',\n",
" '粤BK2Z08',\n",
" '粤B6823H',\n",
" '粤BK3Y47',\n",
" '粤B225P8',\n",
" '粤B7NN62',\n",
" '粤BW4C47',\n",
" '粤BN2A18',\n",
" '粤B2HL18',\n",
" '粤BK1F17',\n",
" '粤B1FU05',\n",
" '粤B144V7',\n",
" '粤B6FU49',\n",
" '粤B457ZD',\n",
" '粤BD8D15',\n",
" '粤BW1C46',\n",
" '粤B480ZE',\n",
" '粤B012U5',\n",
" '粤B669Z8',\n",
" '粤B568G3',\n",
" '粤B2MX85',\n",
" '粤B729U0',\n",
" '粤B7HR48',\n",
" '粤B5ZU43',\n",
" '粤B063Y0',\n",
" '粤B794S7',\n",
" '粤B907U1',\n",
" '粤B063R3',\n",
" '粤BJ30K8',\n",
" '粤B3HU78',\n",
" '粤B472YZ',\n",
" '粤BK6W92',\n",
" '粤B8MP79',\n",
" '粤B3ND47',\n",
" '粤B428YP',\n",
" '粤B181F7',\n",
" '粤B294G9',\n",
" '粤BG9X88',\n",
" '粤B0HX67',\n",
" '粤B4254H',\n",
" '粤B2MX12',\n",
" '粤B4WJ62',\n",
" '粤B6WK71',\n",
" '粤B861ZK',\n",
" '粤BV4W53',\n",
" '粤B905ZB',\n",
" '粤BL4S42',\n",
" '粤B920W5',\n",
" '粤B847R9',\n",
" '粤BJ7Y64',\n",
" '粤BL5P41',\n",
" '粤B168Y2',\n",
" '粤B241W5',\n",
" '粤B280Y6',\n",
" '粤B894U1',\n",
" '粤B3WT20',\n",
" '粤BK9W25',\n",
" '粤B6FT70',\n",
" '粤B4937D',\n",
" '粤B9617K',\n",
" '粤BK0Z20',\n",
" '粤BV0Y41',\n",
" '粤BX4Y21',\n",
" '粤B0WK67',\n",
" '粤B369H8',\n",
" '粤B4NA00',\n",
" '粤B1CP02',\n",
" '粤B6MN87',\n",
" '粤B4HK18',\n",
" '粤B006V9',\n",
" '粤B28074',\n",
" '粤B472Z7',\n",
" '粤B586VX',\n",
" '粤B7407D',\n",
" '粤B2HL75',\n",
" '粤BD8Q09',\n",
" '粤B2VW47',\n",
" '粤BK4X65',\n",
" '粤B280Y9',\n",
" '粤BK6X27',\n",
" '粤B065H3',\n",
" '粤BQ3P96',\n",
" '粤B898F2',\n",
" '粤B6WW42',\n",
" '粤B3WR27',\n",
" '粤B091U3',\n",
" '粤B4730E',\n",
" '粤B4MX39',\n",
" '粤B2CL47',\n",
" '粤B827E9',\n",
" '粤BL0H62',\n",
" '粤B1WK52',\n",
" '粤B009H9',\n",
" '粤BA0464',\n",
" '粤B432W1',\n",
" '粤B346G3',\n",
" '粤B086U0',\n",
" '粤B916F9',\n",
" '粤BD7K22',\n",
" '粤BX4W38',\n",
" '粤B442G6',\n",
" '粤BX4X67',\n",
" '粤BM05M9',\n",
" '粤B5FU87',\n",
" '粤BN6F75',\n",
" '粤BV4X77',\n",
" '粤B7MQ07',\n",
" '粤B1CP45',\n",
" '粤B3VW23',\n",
" '粤BK4V97',\n",
" '粤B1MQ83',\n",
" '粤B5WT33',\n",
" '粤B1HD12',\n",
" '粤B268G8',\n",
" '粤B2ZU21',\n",
" '粤B25482',\n",
" '粤BZ5V47',\n",
" '粤B1VU41',\n",
" '粤B2FZ45',\n",
" '粤B590W7',\n",
" '粤BA22H6',\n",
" '粤B344U1',\n",
" '粤B413U1',\n",
" '粤BC7N92',\n",
" '粤B474Q1',\n",
" '粤B7118H',\n",
" '粤B0HQ45',\n",
" '粤B8MU00',\n",
" '粤B1091D',\n",
" '粤BEB610',\n",
" '粤B474U3',\n",
" '粤B473ZB',\n",
" '粤B3MX58',\n",
" '粤B907W7',\n",
" '粤B2FU16',\n",
" '粤B572W1',\n",
" '粤B664Z9',\n",
" '粤B914R9',\n",
" '粤B931W6',\n",
" '粤B291Z6',\n",
" '粤B461ZC',\n",
" '粤BB0K34',\n",
" '粤B038Y7',\n",
" '粤B3WW49',\n",
" '粤B519V2',\n",
" '粤B506E2',\n",
" '粤B837E2',\n",
" '粤B2WT76',\n",
" '粤B3NQ47',\n",
" '粤B012YS',\n",
" '粤B92U53',\n",
" '粤B6MQ03',\n",
" '粤B0MX87',\n",
" '粤B516W7',\n",
" '粤B1NW60',\n",
" '粤B0HL01',\n",
" '粤BL0H58',\n",
" '粤B314U0',\n",
" '粤B477W6',\n",
" '粤BK1Z33',\n",
" '粤B547YT',\n",
" '粤B6HS41',\n",
" '粤B1HX13',\n",
" '粤BW9B46',\n",
" '粤B031U0',\n",
" '粤BEA502',\n",
" '粤B057ZE',\n",
" '粤BK1X31',\n",
" '粤B7HX80',\n",
" '粤B37999',\n",
" '粤B7KK93',\n",
" '粤B339U1',\n",
" '粤BJ43L5',\n",
" '粤BK2X17',\n",
" '粤BL5Q42',\n",
" '粤BK7U20',\n",
" '粤B1591D',\n",
" '粤B4CT71',\n",
" '粤B4WT68',\n",
" '粤B6BU95',\n",
" '粤B326Y9',\n",
" '粤B7VW19',\n",
" '粤BA3J94',\n",
" '粤B1768D',\n",
" '粤B4MX38',\n",
" '粤B4CT27',\n",
" '粤BW6N75',\n",
" '粤BJ2N74',\n",
" '粤B925W1',\n",
" '粤B7VW15',\n",
" '粤B4DS30',\n",
" '粤B0WT51',\n",
" '粤BW4P07',\n",
" '粤BQ6N87',\n",
" '粤B4HL55',\n",
" '粤B7VW75',\n",
" '粤BG3802',\n",
" '粤B1276A',\n",
" '粤B260G3',\n",
" '粤B3WS26',\n",
" '粤B477W3',\n",
" '粤B695U2',\n",
" '粤BK9V02',\n",
" '粤B388H0',\n",
" '粤B9BS43',\n",
" '粤B793S0',\n",
" '粤BD4S49',\n",
" '粤B6FB86',\n",
" '粤B484T0',\n",
" '粤B451ZE',\n",
" '粤B7CR46',\n",
" '粤BJ31K9',\n",
" '粤B7HB23',\n",
" '粤B310W7',\n",
" '粤B0ZU92',\n",
" '粤B7KK49',\n",
" '粤B0MS21',\n",
" '粤B3ND52',\n",
" '粤B998ZB',\n",
" '粤B0NH43',\n",
" '粤B446G5',\n",
" '粤B5WW92',\n",
" '粤BJ69E7',\n",
" '粤B880F2',\n",
" '粤B3HL59',\n",
" '粤B065R0',\n",
" '粤B2WK89',\n",
" '粤B3DS30',\n",
" '粤B265G8',\n",
" '粤B7HS48',\n",
" '粤B0HQ17',\n",
" '粤B6WK40',\n",
" '粤BK1U96',\n",
" '粤B359ZK',\n",
" '粤B8FT80',\n",
" '粤BA5G68',\n",
" '粤B494T0',\n",
" '粤B1UF97',\n",
" '粤B9VU10',\n",
" '粤BK4X92',\n",
" '粤B418R5',\n",
" '粤BEB040',\n",
" '粤B3994V',\n",
" '粤B7907D',\n",
" '粤B932ZB',\n",
" '粤B3HL10',\n",
" '粤B535ZB',\n",
" '粤B97U81',\n",
" '粤B1058D',\n",
" '粤B002Y1',\n",
" '粤B4HQ57',\n",
" '粤B074W2',\n",
" '粤BL4H45',\n",
" '粤BW4V47',\n",
" '粤B800E3',\n",
" '粤B859Y2',\n",
" '粤B4HL82',\n",
" '粤B0MJ91',\n",
" '粤BK3U77',\n",
" '粤B818E2',\n",
" '粤BK5W68',\n",
" '粤B1HS52',\n",
" '粤B9285A',\n",
" '粤B7CN47',\n",
" '粤B7HX78',\n",
" '粤B7HS52',\n",
" '粤B4ZX38',\n",
" '粤B1WK83',\n",
" '粤BA6N17',\n",
" '粤B36354',\n",
" '粤B065U6',\n",
" '粤B641R2',\n",
" '粤B4BR47',\n",
" '粤B555W6',\n",
" '粤B2HQ37',\n",
" '粤B0DS95',\n",
" '粤B1WQ05',\n",
" '粤B3ZU47',\n",
" '粤B839E9',\n",
" '粤B31147',\n",
" '粤B265G2',\n",
" '粤B5WQ46',\n",
" '粤B2ZU42',\n",
" '粤BK7X63',\n",
" '粤B194Z0',\n",
" '粤B6NP83',\n",
" '粤BK4X30',\n",
" '粤B414S9',\n",
" '粤B7NG29',\n",
" '粤B2MS42',\n",
" '粤B5WT23',\n",
" '粤B2FT97',\n",
" '粤B2BS40',\n",
" '粤B605ZK',\n",
" '粤B72U31',\n",
" '粤B284Y9',\n",
" '粤B764Q2',\n",
" '粤B6WQ46',\n",
" '粤B7057D',\n",
" '粤B2MX76',\n",
" '粤BZ3U47',\n",
" '粤BL7Z95',\n",
" '粤BC5948',\n",
" '粤BJ38K0',\n",
" '粤BA7C94',\n",
" '粤B4MQ23',\n",
" '粤B6CP05',\n",
" '粤B9MN67',\n",
" '粤B9WS45',\n",
" '粤B841U9',\n",
" '粤B8931A',\n",
" '粤B4547D',\n",
" '粤BL4G70',\n",
" '粤B512V2',\n",
" '粤BA3G34',\n",
" '粤B3305U',\n",
" '粤B8HS02',\n",
" '粤B0MQ57',\n",
" '粤B2BV22',\n",
" '粤B7WK78',\n",
" '粤B33146',\n",
" '粤BC5587',\n",
" '粤B7378B',\n",
" '粤B901F5',\n",
" '粤BL1H56',\n",
" '粤B5FY47',\n",
" '粤BK3F81',\n",
" '粤B040R3',\n",
" '粤B1MQ65',\n",
" '粤B4HW23',\n",
" '粤B267G2',\n",
" '粤B405ZE',\n",
" '粤B6VU75',\n",
" '粤BA5G00',\n",
" '粤B1MX65',\n",
" '粤B477V0',\n",
" '粤B1MQ75',\n",
" '粤B3HL70',\n",
" '粤BW1C42',\n",
" '粤B6FU46',\n",
" '粤B467ZB',\n",
" '粤B292U7',\n",
" '粤B452ZD',\n",
" '粤B543D0',\n",
" '粤B3376V',\n",
" '粤B0CP30',\n",
" '粤B624W7',\n",
" '粤B634W6',\n",
" '粤B7MP15',\n",
" '粤B997W9',\n",
" '粤BN5P35',\n",
" '粤B7ZU28',\n",
" '粤B524U1',\n",
" '粤B694Z3',\n",
" '粤BM04T0',\n",
" '粤B0ND96',\n",
" '粤B546E9',\n",
" '粤B0MQ62',\n",
" '粤B4HR45',\n",
" '粤B141ZB',\n",
" '粤BU5K13',\n",
" '粤B1NH82',\n",
" '粤BS2R75',\n",
" '粤BL1H99',\n",
" '粤B374W9',\n",
" '粤B880E0',\n",
" '粤BQ5Q17',\n",
" '粤B084H0',\n",
" '粤B410U9',\n",
" '粤B501S1',\n",
" '粤B1BV28',\n",
" ...}"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Ah, they are not the same.\n",
"\n",
"OD_IDs.difference(GPS_IDs)\n",
"# All elements in OD_IDs but not in GPS_IDs"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Number of GPS IDs: 664\n",
"Number of OD IDs: 13398\n",
"Number of GPS IDs not in OD IDs: 19\n",
"Number of OD IDs not in GPS IDs: 12753\n",
"Number of IDs in both GPS and OD: 645\n"
]
}
],
"source": [
"print(\"Number of GPS IDs:\", len(GPS_IDs))\n",
"print(\"Number of OD IDs:\", len(OD_IDs))\n",
"print(\"Number of GPS IDs not in OD IDs:\", len(GPS_IDs.difference(OD_IDs)))\n",
"print(\"Number of OD IDs not in GPS IDs:\", len(OD_IDs.difference(GPS_IDs)))\n",
"print(\"Number of IDs in both GPS and OD:\", len(GPS_IDs.intersection(OD_IDs)))"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"ID_to_size_of_dataframe = {}\n",
"\n",
"for ID in list(GPS_IDs.intersection(OD_IDs)):\n",
" ID_to_size_of_dataframe[ID] = {\"OD\" : len(OD.loc[ID]),\n",
" \"GPS\" : len(GPS.loc[ID])}\n",
"\n",
"# We want to see how many entries each ID has in the respective dataframes."
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": true,
"jupyter": {
"outputs_hidden": true
}
},
"outputs": [
{
"data": {
"text/plain": [
"{'粤BZ4Y57': {'OD': 274, 'GPS': 27253},\n",
" '粤B4AK45': {'OD': 399, 'GPS': 26529},\n",
" '粤B6BW37': {'OD': 346, 'GPS': 26485},\n",
" '粤B1BX98': {'OD': 404, 'GPS': 26977},\n",
" '粤B4AH10': {'OD': 260, 'GPS': 27037},\n",
" '粤B4BX37': {'OD': 369, 'GPS': 26480},\n",
" '粤BZ3V47': {'OD': 389, 'GPS': 26300},\n",
" '粤B6AF47': {'OD': 407, 'GPS': 26945},\n",
" '粤B3BB28': {'OD': 515, 'GPS': 26834},\n",
" '粤B4AA92': {'OD': 361, 'GPS': 27139},\n",
" '粤B7BW90': {'OD': 78, 'GPS': 15312},\n",
" '粤BX4W27': {'OD': 460, 'GPS': 27155},\n",
" '粤BH8L69': {'OD': 304, 'GPS': 29094},\n",
" '粤BW2L47': {'OD': 382, 'GPS': 27012},\n",
" '粤B6BV77': {'OD': 366, 'GPS': 26594},\n",
" '粤B6AE42': {'OD': 348, 'GPS': 27440},\n",
" '粤B39179': {'OD': 436, 'GPS': 29654},\n",
" '粤B24621': {'OD': 486, 'GPS': 29562},\n",
" '粤B4AH01': {'OD': 72, 'GPS': 15359},\n",
" '粤B4BA73': {'OD': 160, 'GPS': 17662},\n",
" '粤BH1Q23': {'OD': 476, 'GPS': 28914},\n",
" '粤BH6G04': {'OD': 423, 'GPS': 30047},\n",
" '粤BH6H84': {'OD': 410, 'GPS': 29133},\n",
" '粤B4BX38': {'OD': 355, 'GPS': 26734},\n",
" '粤B7AH41': {'OD': 379, 'GPS': 26541},\n",
" '粤B8BW49': {'OD': 404, 'GPS': 26159},\n",
" '粤BH4Q54': {'OD': 463, 'GPS': 29302},\n",
" '粤B9BV53': {'OD': 400, 'GPS': 26916},\n",
" '粤B4BX62': {'OD': 391, 'GPS': 29264},\n",
" '粤BH2K04': {'OD': 332, 'GPS': 29386},\n",
" '粤B6BB67': {'OD': 495, 'GPS': 64268},\n",
" '粤B7BW12': {'OD': 7, 'GPS': 19285},\n",
" '粤B8BW48': {'OD': 449, 'GPS': 36640},\n",
" '粤BZ9Z37': {'OD': 380, 'GPS': 25918},\n",
" '粤B6BW51': {'OD': 362, 'GPS': 26284},\n",
" '粤BH7K43': {'OD': 401, 'GPS': 28535},\n",
" '粤BY7Z41': {'OD': 383, 'GPS': 29161},\n",
" '粤BH4Q47': {'OD': 388, 'GPS': 28303},\n",
" '粤B8BA42': {'OD': 284, 'GPS': 26469},\n",
" '粤B2BX35': {'OD': 379, 'GPS': 29435},\n",
" '粤B5BV73': {'OD': 347, 'GPS': 26916},\n",
" '粤BZ6Z61': {'OD': 397, 'GPS': 27293},\n",
" '粤B1BA50': {'OD': 331, 'GPS': 27042},\n",
" '粤B3AJ41': {'OD': 91, 'GPS': 16902},\n",
" '粤B4BX00': {'OD': 374, 'GPS': 29269},\n",
" '粤B4BX90': {'OD': 278, 'GPS': 26561},\n",
" '粤BG6J14': {'OD': 332, 'GPS': 28899},\n",
" '粤B3BX25': {'OD': 358, 'GPS': 26794},\n",
" '粤B6BB91': {'OD': 304, 'GPS': 37240},\n",
" '粤B2AA39': {'OD': 105, 'GPS': 15425},\n",
" '粤B8BW86': {'OD': 390, 'GPS': 28494},\n",
" '粤BH5Q45': {'OD': 442, 'GPS': 26954},\n",
" '粤BW5L47': {'OD': 407, 'GPS': 28194},\n",
" '粤B0BA49': {'OD': 347, 'GPS': 27209},\n",
" '粤BH3K74': {'OD': 319, 'GPS': 29537},\n",
" '粤BH4Q87': {'OD': 474, 'GPS': 29032},\n",
" '粤B0BY49': {'OD': 480, 'GPS': 29712},\n",
" '粤B4BA27': {'OD': 385, 'GPS': 26992},\n",
" '粤B35794': {'OD': 464, 'GPS': 29588},\n",
" '粤BZ7Z81': {'OD': 294, 'GPS': 26159},\n",
" '粤B4AE67': {'OD': 105, 'GPS': 15427},\n",
" '粤B4AH15': {'OD': 272, 'GPS': 27509},\n",
" '粤B0BB53': {'OD': 86, 'GPS': 16602},\n",
" '粤B0BY23': {'OD': 458, 'GPS': 27000},\n",
" '粤B9AD47': {'OD': 158, 'GPS': 12269},\n",
" '粤BY5W42': {'OD': 429, 'GPS': 28174},\n",
" '粤BY9Z47': {'OD': 359, 'GPS': 27256},\n",
" '粤BZ4Z29': {'OD': 366, 'GPS': 26444},\n",
" '粤BH2L47': {'OD': 443, 'GPS': 29933},\n",
" '粤BZ4R71': {'OD': 375, 'GPS': 26387},\n",
" '粤B6BW02': {'OD': 250, 'GPS': 23275},\n",
" '粤B7BY86': {'OD': 405, 'GPS': 26593},\n",
" '粤B28149': {'OD': 370, 'GPS': 28690},\n",
" '粤B2BB25': {'OD': 348, 'GPS': 21068},\n",
" '粤B4AA57': {'OD': 143, 'GPS': 27759},\n",
" '粤B4BA76': {'OD': 464, 'GPS': 28246},\n",
" '粤B0BX06': {'OD': 423, 'GPS': 29300},\n",
" '粤B7BB36': {'OD': 87, 'GPS': 19187},\n",
" '粤BH4Q55': {'OD': 377, 'GPS': 29095},\n",
" '粤B8BB02': {'OD': 392, 'GPS': 26324},\n",
" '粤BH4Q50': {'OD': 404, 'GPS': 29179},\n",
" '粤B8AK71': {'OD': 235, 'GPS': 21165},\n",
" '粤B0AB41': {'OD': 30, 'GPS': 26892},\n",
" '粤B5BW79': {'OD': 370, 'GPS': 27028},\n",
" '粤B9BW12': {'OD': 382, 'GPS': 26241},\n",
" '粤B4AK25': {'OD': 353, 'GPS': 27054},\n",
" '粤B8BX40': {'OD': 326, 'GPS': 27092},\n",
" '粤B6AE41': {'OD': 265, 'GPS': 24533},\n",
" '粤B5BW05': {'OD': 508, 'GPS': 26983},\n",
" '粤B9BX40': {'OD': 566, 'GPS': 30128},\n",
" '粤B9BB70': {'OD': 97, 'GPS': 16834},\n",
" '粤B9BW15': {'OD': 335, 'GPS': 26532},\n",
" '粤B1BX97': {'OD': 435, 'GPS': 27602},\n",
" '粤B5BB22': {'OD': 411, 'GPS': 28227},\n",
" '粤BZ9Z39': {'OD': 350, 'GPS': 27272},\n",
" '粤BH8L82': {'OD': 373, 'GPS': 29311},\n",
" '粤B0AD42': {'OD': 430, 'GPS': 29108},\n",
" '粤B6BW59': {'OD': 354, 'GPS': 26554},\n",
" '粤B4BB03': {'OD': 422, 'GPS': 27785},\n",
" '粤B5BW43': {'OD': 302, 'GPS': 23498},\n",
" '粤B24170': {'OD': 432, 'GPS': 29166},\n",
" '粤B4BX82': {'OD': 449, 'GPS': 26777},\n",
" '粤B24797': {'OD': 391, 'GPS': 29193},\n",
" '粤B2BB52': {'OD': 352, 'GPS': 29102},\n",
" '粤B0BA45': {'OD': 381, 'GPS': 28973},\n",
" '粤BZ6Z07': {'OD': 384, 'GPS': 26400},\n",
" '粤B0BY32': {'OD': 383, 'GPS': 27126},\n",
" '粤BH6L94': {'OD': 469, 'GPS': 28991},\n",
" '粤BH5Q70': {'OD': 396, 'GPS': 28458},\n",
" '粤BZ4Z22': {'OD': 389, 'GPS': 26276},\n",
" '粤BZ6Z12': {'OD': 365, 'GPS': 26559},\n",
" '粤BH0Q24': {'OD': 459, 'GPS': 29590},\n",
" '粤BH9A54': {'OD': 377, 'GPS': 28771},\n",
" '粤B5BW70': {'OD': 247, 'GPS': 26364},\n",
" '粤BG0Y14': {'OD': 354, 'GPS': 29083},\n",
" '粤BH6H47': {'OD': 415, 'GPS': 28896},\n",
" '粤B7BA82': {'OD': 162, 'GPS': 26887},\n",
" '粤B7BX26': {'OD': 37, 'GPS': 3730},\n",
" '粤BZ4R27': {'OD': 313, 'GPS': 27222},\n",
" '粤BZ2S41': {'OD': 387, 'GPS': 28998},\n",
" '粤B4BB50': {'OD': 264, 'GPS': 26949},\n",
" '粤BH6H44': {'OD': 371, 'GPS': 29069},\n",
" '粤B24495': {'OD': 424, 'GPS': 29451},\n",
" '粤BH6L20': {'OD': 426, 'GPS': 29051},\n",
" '粤B4BA77': {'OD': 422, 'GPS': 27203},\n",
" '粤B4BX40': {'OD': 371, 'GPS': 26358},\n",
" '粤B8BV70': {'OD': 373, 'GPS': 26607},\n",
" '粤B5BW17': {'OD': 421, 'GPS': 28910},\n",
" '粤B14732': {'OD': 463, 'GPS': 29838},\n",
" '粤B34034': {'OD': 376, 'GPS': 29026},\n",
" '粤B3BX12': {'OD': 319, 'GPS': 27065},\n",
" '粤BH7G24': {'OD': 433, 'GPS': 29460},\n",
" '粤BH7L48': {'OD': 432, 'GPS': 29420},\n",
" '粤B6BY03': {'OD': 472, 'GPS': 29289},\n",
" '粤B0AC42': {'OD': 370, 'GPS': 26994},\n",
" '粤B38193': {'OD': 479, 'GPS': 29509},\n",
" '粤BZ3Z47': {'OD': 355, 'GPS': 21903},\n",
" '粤BZ5Z73': {'OD': 329, 'GPS': 26651},\n",
" '粤B9BB82': {'OD': 435, 'GPS': 27290},\n",
" '粤B5BB01': {'OD': 384, 'GPS': 26490},\n",
" '粤B8BW30': {'OD': 393, 'GPS': 26374},\n",
" '粤BH5Q34': {'OD': 471, 'GPS': 29242},\n",
" '粤B2BX47': {'OD': 12, 'GPS': 11038},\n",
" '粤BH7Q09': {'OD': 455, 'GPS': 29135},\n",
" '粤B1BB15': {'OD': 359, 'GPS': 26358},\n",
" '粤B6BW46': {'OD': 366, 'GPS': 26280},\n",
" '粤BH4Q67': {'OD': 428, 'GPS': 29341},\n",
" '粤BH1C74': {'OD': 444, 'GPS': 29640},\n",
" '粤B34940': {'OD': 494, 'GPS': 29573},\n",
" '粤BZ4Q70': {'OD': 98, 'GPS': 16552},\n",
" '粤BE5M14': {'OD': 351, 'GPS': 23831},\n",
" '粤B4BA47': {'OD': 432, 'GPS': 30260},\n",
" '粤BH1C04': {'OD': 419, 'GPS': 29120},\n",
" '粤B4BA98': {'OD': 341, 'GPS': 27916},\n",
" '粤B8BW43': {'OD': 287, 'GPS': 27390},\n",
" '粤B0BX43': {'OD': 273, 'GPS': 29060},\n",
" '粤B8BW12': {'OD': 391, 'GPS': 26069},\n",
" '粤BZ1Y47': {'OD': 388, 'GPS': 26583},\n",
" '粤B6BB73': {'OD': 304, 'GPS': 27029},\n",
" '粤BZ4P41': {'OD': 451, 'GPS': 28953},\n",
" '粤B7BB17': {'OD': 369, 'GPS': 26125},\n",
" '粤BH4L04': {'OD': 410, 'GPS': 29082},\n",
" '粤BZ4Z20': {'OD': 381, 'GPS': 26726},\n",
" '粤B4BX31': {'OD': 365, 'GPS': 26720},\n",
" '粤B7AK40': {'OD': 408, 'GPS': 28695},\n",
" '粤BW7T45': {'OD': 366, 'GPS': 29085},\n",
" '粤B9BB62': {'OD': 221, 'GPS': 21280},\n",
" '粤B6BW57': {'OD': 367, 'GPS': 26376},\n",
" '粤BH0H54': {'OD': 401, 'GPS': 29937},\n",
" '粤BW4U37': {'OD': 406, 'GPS': 28051},\n",
" '粤B7BW29': {'OD': 71, 'GPS': 15848},\n",
" '粤BZ1P42': {'OD': 263, 'GPS': 26887},\n",
" '粤BH0G64': {'OD': 395, 'GPS': 29219},\n",
" '粤B9BB02': {'OD': 362, 'GPS': 26009},\n",
" '粤B0BX48': {'OD': 376, 'GPS': 26924},\n",
" '粤B0BY70': {'OD': 367, 'GPS': 26300},\n",
" '粤BZ7Z79': {'OD': 316, 'GPS': 26908},\n",
" '粤B0BX76': {'OD': 124, 'GPS': 16533},\n",
" '粤B7BX90': {'OD': 339, 'GPS': 29016},\n",
" '粤B4AK03': {'OD': 220, 'GPS': 21380},\n",
" '粤B9AH43': {'OD': 331, 'GPS': 27417},\n",
" '粤BZ2Z40': {'OD': 333, 'GPS': 26187},\n",
" '粤BZ5Z49': {'OD': 363, 'GPS': 26886},\n",
" '粤BH6Q02': {'OD': 386, 'GPS': 28766},\n",
" '粤B29449': {'OD': 331, 'GPS': 29014},\n",
" '粤BZ6Z27': {'OD': 259, 'GPS': 28747},\n",
" '粤B4BX50': {'OD': 409, 'GPS': 29508},\n",
" '粤BW4D47': {'OD': 316, 'GPS': 26128},\n",
" '粤BZ2R40': {'OD': 43, 'GPS': 6181},\n",
" '粤BZ4Z21': {'OD': 335, 'GPS': 26482},\n",
" '粤B5BX37': {'OD': 369, 'GPS': 26802},\n",
" '粤B33745': {'OD': 382, 'GPS': 28278},\n",
" '粤BH0Q67': {'OD': 473, 'GPS': 29486},\n",
" '粤B2BX29': {'OD': 319, 'GPS': 27213},\n",
" '粤B6BB72': {'OD': 392, 'GPS': 27988},\n",
" '粤B6BW72': {'OD': 374, 'GPS': 26099},\n",
" '粤BZ6Z20': {'OD': 353, 'GPS': 27358},\n",
" '粤B7BX41': {'OD': 386, 'GPS': 27272},\n",
" '粤B7BY37': {'OD': 439, 'GPS': 27623},\n",
" '粤BH4Q15': {'OD': 454, 'GPS': 29025},\n",
" '粤B4AE17': {'OD': 441, 'GPS': 27666},\n",
" '粤B2BX12': {'OD': 352, 'GPS': 28576},\n",
" '粤B9BW11': {'OD': 358, 'GPS': 26860},\n",
" '粤B2AA73': {'OD': 85, 'GPS': 16741},\n",
" '粤B3AD47': {'OD': 424, 'GPS': 26980},\n",
" '粤BH2B04': {'OD': 462, 'GPS': 29425},\n",
" '粤B1BA41': {'OD': 68, 'GPS': 17048},\n",
" '粤B7BY66': {'OD': 427, 'GPS': 30033},\n",
" '粤BH1Q46': {'OD': 415, 'GPS': 29432},\n",
" '粤BW7P43': {'OD': 430, 'GPS': 28042},\n",
" '粤B6BW12': {'OD': 395, 'GPS': 27035},\n",
" '粤BH4L43': {'OD': 451, 'GPS': 28843},\n",
" '粤BH4L71': {'OD': 429, 'GPS': 29130},\n",
" '粤B9AC47': {'OD': 79, 'GPS': 16157},\n",
" '粤BZ6Y73': {'OD': 387, 'GPS': 26602},\n",
" '粤BH3Q51': {'OD': 416, 'GPS': 28607},\n",
" '粤B19147': {'OD': 428, 'GPS': 27767},\n",
" '粤BW4U42': {'OD': 400, 'GPS': 27243},\n",
" '粤B2BX56': {'OD': 425, 'GPS': 27812},\n",
" '粤BZ8Z17': {'OD': 383, 'GPS': 26011},\n",
" '粤B8BW45': {'OD': 416, 'GPS': 26660},\n",
" '粤BH4L05': {'OD': 366, 'GPS': 28966},\n",
" '粤B14337': {'OD': 459, 'GPS': 29424},\n",
" '粤BH1Q88': {'OD': 147, 'GPS': 11576},\n",
" '粤BZ5Z09': {'OD': 174, 'GPS': 19379},\n",
" '粤BZ9Z49': {'OD': 364, 'GPS': 26830},\n",
" '粤B5BW35': {'OD': 333, 'GPS': 27193},\n",
" '粤BH4Q07': {'OD': 487, 'GPS': 28824},\n",
" '粤BW7E42': {'OD': 296, 'GPS': 26110},\n",
" '粤BZ4R77': {'OD': 313, 'GPS': 27365},\n",
" '粤B2BY28': {'OD': 382, 'GPS': 29248},\n",
" '粤B9BX42': {'OD': 359, 'GPS': 27185},\n",
" '粤BH5L63': {'OD': 428, 'GPS': 30465},\n",
" '粤B5BA17': {'OD': 406, 'GPS': 29406},\n",
" '粤B5BA49': {'OD': 367, 'GPS': 29115},\n",
" '粤B4AA99': {'OD': 424, 'GPS': 26194},\n",
" '粤B8BA25': {'OD': 397, 'GPS': 28657},\n",
" '粤B2BB72': {'OD': 373, 'GPS': 26273},\n",
" '粤B5BB29': {'OD': 96, 'GPS': 16623},\n",
" '粤B7BB38': {'OD': 225, 'GPS': 27758},\n",
" '粤BZ3Z95': {'OD': 392, 'GPS': 27511},\n",
" '粤BZ0Z75': {'OD': 251, 'GPS': 26973},\n",
" '粤B4BV13': {'OD': 372, 'GPS': 29405},\n",
" '粤BH7K45': {'OD': 427, 'GPS': 29381},\n",
" '粤B5BW77': {'OD': 347, 'GPS': 26614},\n",
" '粤B7BW25': {'OD': 439, 'GPS': 29002},\n",
" '粤B2AJ41': {'OD': 344, 'GPS': 26650},\n",
" '粤BZ7Z39': {'OD': 386, 'GPS': 27613},\n",
" '粤B3BV62': {'OD': 425, 'GPS': 26808},\n",
" '粤BH2H94': {'OD': 192, 'GPS': 13684},\n",
" '粤B3BX18': {'OD': 356, 'GPS': 29538},\n",
" '粤B0BB60': {'OD': 233, 'GPS': 20836},\n",
" '粤B39305': {'OD': 468, 'GPS': 29414},\n",
" '粤BH9G47': {'OD': 415, 'GPS': 28911},\n",
" '粤BH0Q97': {'OD': 347, 'GPS': 28609},\n",
" '粤B4AB49': {'OD': 292, 'GPS': 24497},\n",
" '粤B6BW13': {'OD': 338, 'GPS': 27070},\n",
" '粤B4AK47': {'OD': 62, 'GPS': 18697},\n",
" '粤B5BW71': {'OD': 347, 'GPS': 26365},\n",
" '粤B7BW01': {'OD': 374, 'GPS': 27515},\n",
" '粤BX7R42': {'OD': 83, 'GPS': 19842},\n",
" '粤B0BB65': {'OD': 353, 'GPS': 26638},\n",
" '粤B7BB50': {'OD': 345, 'GPS': 26560},\n",
" '粤BZ4U70': {'OD': 411, 'GPS': 28478},\n",
" '粤BZ5Z26': {'OD': 349, 'GPS': 26527},\n",
" '粤B5BW97': {'OD': 309, 'GPS': 26599},\n",
" '粤B7AH42': {'OD': 370, 'GPS': 26468},\n",
" '粤B5BB32': {'OD': 76, 'GPS': 16059},\n",
" '粤B28794': {'OD': 419, 'GPS': 29254},\n",
" '粤BH9E24': {'OD': 461, 'GPS': 34917},\n",
" '粤B1BA20': {'OD': 498, 'GPS': 29715},\n",
" '粤B0AF47': {'OD': 480, 'GPS': 27735},\n",
" '粤BZ8Z96': {'OD': 336, 'GPS': 26304},\n",
" '粤B4BB29': {'OD': 82, 'GPS': 16801},\n",
" '粤B6BB08': {'OD': 427, 'GPS': 28003},\n",
" '粤BZ7Z77': {'OD': 381, 'GPS': 26352},\n",
" '粤B8BW67': {'OD': 468, 'GPS': 28549},\n",
" '粤B6BX43': {'OD': 359, 'GPS': 27055},\n",
" '粤BH2Q42': {'OD': 445, 'GPS': 30036},\n",
" '粤B5AD47': {'OD': 128, 'GPS': 15870},\n",
" '粤B2BW93': {'OD': 432, 'GPS': 29376},\n",
" '粤B7BB83': {'OD': 363, 'GPS': 26804},\n",
" '粤BH3Q52': {'OD': 389, 'GPS': 28818},\n",
" '粤B2AF40': {'OD': 427, 'GPS': 29333},\n",
" '粤B39340': {'OD': 372, 'GPS': 29521},\n",
" '粤B4BW52': {'OD': 461, 'GPS': 29858},\n",
" '粤BZ7Z89': {'OD': 399, 'GPS': 26311},\n",
" '粤B37349': {'OD': 401, 'GPS': 29502},\n",
" '粤BH7G84': {'OD': 353, 'GPS': 28970},\n",
" '粤BH3F14': {'OD': 218, 'GPS': 14347},\n",
" '粤B2BB13': {'OD': 338, 'GPS': 26974},\n",
" '粤B6BV06': {'OD': 365, 'GPS': 27129},\n",
" '粤BH7L45': {'OD': 360, 'GPS': 29184},\n",
" '粤BF3R74': {'OD': 375, 'GPS': 29265},\n",
" '粤BH1K24': {'OD': 218, 'GPS': 13796},\n",
" '粤BH4K24': {'OD': 344, 'GPS': 29321},\n",
" '粤B4BY00': {'OD': 402, 'GPS': 29308},\n",
" '粤B1BB10': {'OD': 325, 'GPS': 26425},\n",
" '粤BW7U43': {'OD': 199, 'GPS': 20900},\n",
" '粤B4BA97': {'OD': 358, 'GPS': 26458},\n",
" '粤B9BV49': {'OD': 213, 'GPS': 29229},\n",
" '粤B5BB10': {'OD': 344, 'GPS': 27108},\n",
" '粤B7BW35': {'OD': 438, 'GPS': 27737},\n",
" '粤B6BB46': {'OD': 378, 'GPS': 29282},\n",
" '粤B5BB67': {'OD': 406, 'GPS': 26265},\n",
" '粤BH3Q05': {'OD': 395, 'GPS': 29281},\n",
" '粤B16442': {'OD': 297, 'GPS': 29380},\n",
" '粤B1BX03': {'OD': 471, 'GPS': 29455},\n",
" '粤B2AD47': {'OD': 357, 'GPS': 26252},\n",
" '粤B0BB31': {'OD': 356, 'GPS': 26042},\n",
" '粤BW4D37': {'OD': 431, 'GPS': 26670},\n",
" '粤B0BW56': {'OD': 387, 'GPS': 29342},\n",
" '粤BH4Q60': {'OD': 266, 'GPS': 28961},\n",
" '粤B3AK40': {'OD': 310, 'GPS': 26007},\n",
" '粤B7AC47': {'OD': 220, 'GPS': 21635},\n",
" '粤BZ7Z28': {'OD': 334, 'GPS': 26117},\n",
" '粤BH5K43': {'OD': 376, 'GPS': 29220},\n",
" '粤B8BW37': {'OD': 406, 'GPS': 29013},\n",
" '粤B39417': {'OD': 467, 'GPS': 28425},\n",
" '粤B3BX97': {'OD': 361, 'GPS': 29565},\n",
" '粤BH8J54': {'OD': 361, 'GPS': 29456},\n",
" '粤B6BW61': {'OD': 373, 'GPS': 26396},\n",
" '粤BH6L67': {'OD': 378, 'GPS': 28983},\n",
" '粤BZ4Z75': {'OD': 265, 'GPS': 27023},\n",
" '粤B5BW42': {'OD': 424, 'GPS': 26882},\n",
" '粤B9BB93': {'OD': 359, 'GPS': 23458},\n",
" '粤B4BX12': {'OD': 344, 'GPS': 26875},\n",
" '粤B7BX80': {'OD': 357, 'GPS': 29231},\n",
" '粤B7BW88': {'OD': 384, 'GPS': 27150},\n",
" '粤BH4L67': {'OD': 452, 'GPS': 28801},\n",
" '粤BW0C47': {'OD': 160, 'GPS': 12549},\n",
" '粤BG7X49': {'OD': 411, 'GPS': 29699},\n",
" '粤BH4J47': {'OD': 376, 'GPS': 28655},\n",
" '粤B9BV41': {'OD': 335, 'GPS': 30223},\n",
" '粤B3BB75': {'OD': 277, 'GPS': 32888},\n",
" '粤BZ8Z61': {'OD': 349, 'GPS': 26339},\n",
" '粤BH5Q23': {'OD': 378, 'GPS': 28953},\n",
" '粤B4AC41': {'OD': 283, 'GPS': 26018},\n",
" '粤B6BY72': {'OD': 88, 'GPS': 17459},\n",
" '粤B7BW06': {'OD': 392, 'GPS': 26546},\n",
" '粤B4BB90': {'OD': 309, 'GPS': 26551},\n",
" '粤BH4C64': {'OD': 445, 'GPS': 29601},\n",
" '粤B6BB16': {'OD': 183, 'GPS': 21246},\n",
" '粤B1BY07': {'OD': 348, 'GPS': 27193},\n",
" '粤B27042': {'OD': 353, 'GPS': 29465},\n",
" '粤BH4L19': {'OD': 408, 'GPS': 29825},\n",
" '粤B9BB40': {'OD': 141, 'GPS': 17298},\n",
" '粤B8BW17': {'OD': 389, 'GPS': 26959},\n",
" '粤B4AA66': {'OD': 275, 'GPS': 27220},\n",
" '粤BZ4X51': {'OD': 429, 'GPS': 26616},\n",
" '粤BZ8Z20': {'OD': 388, 'GPS': 27006},\n",
" '粤BH3Q81': {'OD': 354, 'GPS': 28927},\n",
" '粤B43090': {'OD': 471, 'GPS': 27941},\n",
" '粤B5BY60': {'OD': 357, 'GPS': 29557},\n",
" '粤BH8L84': {'OD': 467, 'GPS': 29491},\n",
" '粤BH5Q55': {'OD': 365, 'GPS': 28328},\n",
" '粤B2BY52': {'OD': 419, 'GPS': 29316},\n",
" '粤BX0T47': {'OD': 99, 'GPS': 18498},\n",
" '粤BZ7Z82': {'OD': 352, 'GPS': 27129},\n",
" '粤B8BW27': {'OD': 333, 'GPS': 27045},\n",
" '粤B5BB46': {'OD': 487, 'GPS': 29234},\n",
" '粤B5BA45': {'OD': 418, 'GPS': 26028},\n",
" '粤B1AE40': {'OD': 313, 'GPS': 27055},\n",
" '粤BZ4Z01': {'OD': 382, 'GPS': 26849},\n",
" '粤B2BA42': {'OD': 334, 'GPS': 27104},\n",
" '粤BY4W41': {'OD': 448, 'GPS': 26975},\n",
" '粤BZ7Z03': {'OD': 281, 'GPS': 27725},\n",
" '粤BZ1Z07': {'OD': 344, 'GPS': 27106},\n",
" '粤B3BX62': {'OD': 383, 'GPS': 29195},\n",
" '粤B6BB28': {'OD': 414, 'GPS': 28894},\n",
" '粤BE2P74': {'OD': 382, 'GPS': 29768},\n",
" '粤B6BA43': {'OD': 295, 'GPS': 27311},\n",
" '粤B4BX43': {'OD': 269, 'GPS': 21384},\n",
" '粤BZ5Y07': {'OD': 396, 'GPS': 26541},\n",
" '粤B4BV61': {'OD': 372, 'GPS': 27295},\n",
" '粤B1BX25': {'OD': 358, 'GPS': 29115},\n",
" '粤B2BY67': {'OD': 429, 'GPS': 28276},\n",
" '粤B6BY20': {'OD': 285, 'GPS': 25847},\n",
" '粤BL5289': {'OD': 252, 'GPS': 16620},\n",
" '粤B1AH49': {'OD': 359, 'GPS': 36155},\n",
" '粤BZ7Z40': {'OD': 400, 'GPS': 26180},\n",
" '粤B2AA75': {'OD': 334, 'GPS': 26836},\n",
" '粤BZ3Y49': {'OD': 78, 'GPS': 14747},\n",
" '粤BZ7Z10': {'OD': 388, 'GPS': 26927},\n",
" '粤B43059': {'OD': 446, 'GPS': 29651},\n",
" '粤B4BB62': {'OD': 435, 'GPS': 26840},\n",
" '粤BL5082': {'OD': 144, 'GPS': 37458},\n",
" '粤BH4Q59': {'OD': 138, 'GPS': 28876},\n",
" '粤BZ1W41': {'OD': 395, 'GPS': 26812},\n",
" '粤B9BW80': {'OD': 280, 'GPS': 26624},\n",
" '粤B9BB87': {'OD': 140, 'GPS': 18005},\n",
" '粤B7BW53': {'OD': 366, 'GPS': 28731},\n",
" '粤B4AK17': {'OD': 379, 'GPS': 28814},\n",
" '粤B0BX68': {'OD': 86, 'GPS': 14618},\n",
" '粤B9BW67': {'OD': 313, 'GPS': 26453},\n",
" '粤B5BY57': {'OD': 101, 'GPS': 13544},\n",
" '粤B8BW66': {'OD': 372, 'GPS': 27009},\n",
" '粤BH4L31': {'OD': 344, 'GPS': 28754},\n",
" '粤B39428': {'OD': 427, 'GPS': 29611},\n",
" '粤BL8398': {'OD': 224, 'GPS': 31506},\n",
" '粤BH4L06': {'OD': 452, 'GPS': 28554},\n",
" '粤BH0L47': {'OD': 527, 'GPS': 29553},\n",
" '粤B3BB70': {'OD': 125, 'GPS': 18156},\n",
" '粤B1AK40': {'OD': 403, 'GPS': 26521},\n",
" '粤BH8L63': {'OD': 450, 'GPS': 29033},\n",
" '粤BZ7Z35': {'OD': 300, 'GPS': 36326},\n",
" '粤B3BX32': {'OD': 335, 'GPS': 26256},\n",
" '粤B6BY76': {'OD': 384, 'GPS': 26485},\n",
" '粤B7BW21': {'OD': 424, 'GPS': 26711},\n",
" '粤BH2Q27': {'OD': 371, 'GPS': 29494},\n",
" '粤BZ1Z48': {'OD': 440, 'GPS': 27342},\n",
" '粤B1BX70': {'OD': 468, 'GPS': 29652},\n",
" '粤B4AB75': {'OD': 304, 'GPS': 25622},\n",
" '粤BG7T94': {'OD': 383, 'GPS': 29660},\n",
" '粤BZ7W41': {'OD': 257, 'GPS': 28888},\n",
" '粤B7AE42': {'OD': 326, 'GPS': 26926},\n",
" '粤B4BX16': {'OD': 397, 'GPS': 27855},\n",
" '粤B0BA42': {'OD': 217, 'GPS': 22896},\n",
" '粤BH7L11': {'OD': 439, 'GPS': 29206},\n",
" '粤B6BB81': {'OD': 378, 'GPS': 26147},\n",
" '粤B6BW00': {'OD': 371, 'GPS': 26217},\n",
" '粤BY4V41': {'OD': 487, 'GPS': 27330},\n",
" '粤B6BW05': {'OD': 79, 'GPS': 17495},\n",
" '粤B2BA45': {'OD': 323, 'GPS': 19656},\n",
" '粤B3AB47': {'OD': 385, 'GPS': 29897},\n",
" '粤B5BW45': {'OD': 57, 'GPS': 26115},\n",
" '粤B4AJ25': {'OD': 234, 'GPS': 22660},\n",
" '粤B4BA49': {'OD': 431, 'GPS': 27231},\n",
" '粤BL5048': {'OD': 247, 'GPS': 30332},\n",
" '粤BH3Q59': {'OD': 517, 'GPS': 29352},\n",
" '粤BY0X41': {'OD': 358, 'GPS': 27866},\n",
" '粤B5BW21': {'OD': 350, 'GPS': 26264},\n",
" '粤BZ7Z61': {'OD': 374, 'GPS': 27317},\n",
" '粤B1AA50': {'OD': 334, 'GPS': 27529},\n",
" '粤B7BA07': {'OD': 391, 'GPS': 28716},\n",
" '粤B8BV37': {'OD': 317, 'GPS': 27851},\n",
" '粤B4BS90': {'OD': 423, 'GPS': 29502},\n",
" '粤B3BY25': {'OD': 364, 'GPS': 29336},\n",
" '粤BL8488': {'OD': 239, 'GPS': 38275},\n",
" '粤B6BW91': {'OD': 419, 'GPS': 27304},\n",
" '粤B7BW95': {'OD': 354, 'GPS': 28636},\n",
" '粤B9BW37': {'OD': 358, 'GPS': 29235},\n",
" '粤B4BB01': {'OD': 269, 'GPS': 28965},\n",
" '粤BH1Q91': {'OD': 461, 'GPS': 29892},\n",
" '粤BV7R41': {'OD': 401, 'GPS': 26513},\n",
" '粤BG2Y54': {'OD': 239, 'GPS': 14494},\n",
" '粤BH3G24': {'OD': 395, 'GPS': 29165},\n",
" '粤BZ6Z76': {'OD': 346, 'GPS': 26581},\n",
" '粤B38434': {'OD': 324, 'GPS': 29490},\n",
" '粤BZ6Z79': {'OD': 356, 'GPS': 26915},\n",
" '粤B2BB57': {'OD': 91, 'GPS': 18007},\n",
" '粤B7BA43': {'OD': 406, 'GPS': 26995},\n",
" '粤B7BW10': {'OD': 492, 'GPS': 29472},\n",
" '粤BH4Q09': {'OD': 385, 'GPS': 28273},\n",
" '粤B8BX71': {'OD': 448, 'GPS': 29297},\n",
" '粤B4BX69': {'OD': 433, 'GPS': 29022},\n",
" '粤B9BW18': {'OD': 318, 'GPS': 26825},\n",
" '粤BZ7Z26': {'OD': 359, 'GPS': 29415},\n",
" '粤BZ4W63': {'OD': 381, 'GPS': 27289},\n",
" '粤B8BW91': {'OD': 404, 'GPS': 26891},\n",
" '粤B7BW20': {'OD': 387, 'GPS': 25020},\n",
" '粤B4BA92': {'OD': 297, 'GPS': 27156},\n",
" '粤BH1Q51': {'OD': 424, 'GPS': 27096},\n",
" '粤B6BW47': {'OD': 406, 'GPS': 26586},\n",
" '粤B3AA71': {'OD': 37, 'GPS': 28928},\n",
" '粤BH8H74': {'OD': 417, 'GPS': 28834},\n",
" '粤B4AA83': {'OD': 355, 'GPS': 27312},\n",
" '粤B7BB40': {'OD': 354, 'GPS': 28049},\n",
" '粤B8BW65': {'OD': 475, 'GPS': 26751},\n",
" '粤B1BB45': {'OD': 318, 'GPS': 25945},\n",
" '粤B39203': {'OD': 411, 'GPS': 29577},\n",
" '粤B9BB53': {'OD': 90, 'GPS': 16566},\n",
" '粤B4BY70': {'OD': 364, 'GPS': 25997},\n",
" '粤B38455': {'OD': 338, 'GPS': 29605},\n",
" '粤B5BV77': {'OD': 431, 'GPS': 26956},\n",
" '粤BY9W47': {'OD': 359, 'GPS': 26204},\n",
" '粤BH7L27': {'OD': 339, 'GPS': 32004},\n",
" '粤B7BW07': {'OD': 197, 'GPS': 21208},\n",
" '粤B5BB78': {'OD': 415, 'GPS': 26967},\n",
" '粤BV4X37': {'OD': 326, 'GPS': 26814},\n",
" '粤BH6Q43': {'OD': 341, 'GPS': 28537},\n",
" '粤BH8L53': {'OD': 416, 'GPS': 29252},\n",
" '粤BH1Q28': {'OD': 440, 'GPS': 28856},\n",
" '粤B9BW56': {'OD': 349, 'GPS': 26649},\n",
" '粤B1BB19': {'OD': 460, 'GPS': 26761},\n",
" '粤BW4L47': {'OD': 320, 'GPS': 26367},\n",
" '粤B5BY80': {'OD': 250, 'GPS': 18613},\n",
" '粤BW4Z73': {'OD': 367, 'GPS': 26865},\n",
" '粤BH7L77': {'OD': 432, 'GPS': 29061},\n",
" '粤B1BX41': {'OD': 247, 'GPS': 23171},\n",
" '粤B4AK79': {'OD': 405, 'GPS': 29083},\n",
" '粤B2BY31': {'OD': 339, 'GPS': 27107},\n",
" '粤B4BX45': {'OD': 352, 'GPS': 26506},\n",
" '粤B5BX75': {'OD': 415, 'GPS': 37531},\n",
" '粤B9BB51': {'OD': 120, 'GPS': 17345},\n",
" '粤B1AE42': {'OD': 434, 'GPS': 28424},\n",
" '粤B5BY81': {'OD': 376, 'GPS': 29376},\n",
" '粤BH3Q10': {'OD': 455, 'GPS': 29392},\n",
" '粤B0AF42': {'OD': 426, 'GPS': 27361},\n",
" '粤B9BW88': {'OD': 471, 'GPS': 28881},\n",
" '粤B6BW52': {'OD': 313, 'GPS': 26783},\n",
" '粤B1BX73': {'OD': 415, 'GPS': 29433},\n",
" '粤B2CF28': {'OD': 365, 'GPS': 26933},\n",
" '粤B0BA47': {'OD': 96, 'GPS': 15841},\n",
" '粤B4BX07': {'OD': 450, 'GPS': 29495},\n",
" '粤BZ4Z00': {'OD': 143, 'GPS': 12779},\n",
" '粤B7BB98': {'OD': 392, 'GPS': 26621},\n",
" '粤B7BA76': {'OD': 381, 'GPS': 29144},\n",
" '粤B3AA83': {'OD': 283, 'GPS': 28564},\n",
" '粤BZ0Z46': {'OD': 373, 'GPS': 26496},\n",
" '粤B0BB43': {'OD': 55, 'GPS': 14273},\n",
" '粤B0BX91': {'OD': 448, 'GPS': 28197},\n",
" '粤B9BB52': {'OD': 381, 'GPS': 27486},\n",
" '粤BH2Q89': {'OD': 382, 'GPS': 29087},\n",
" '粤BH2L84': {'OD': 405, 'GPS': 29647},\n",
" '粤BH0Q83': {'OD': 451, 'GPS': 29823},\n",
" '粤BZ0Y57': {'OD': 370, 'GPS': 27807},\n",
" '粤B7BX03': {'OD': 422, 'GPS': 28047},\n",
" '粤B7BB75': {'OD': 45, 'GPS': 17385},\n",
" '粤BZ4Q21': {'OD': 391, 'GPS': 26496},\n",
" '粤B7BA16': {'OD': 388, 'GPS': 26771},\n",
" '粤B7BW87': {'OD': 379, 'GPS': 27238},\n",
" '粤BZ8Z87': {'OD': 290, 'GPS': 27117},\n",
" '粤B2BY50': {'OD': 498, 'GPS': 27917},\n",
" '粤B34245': {'OD': 356, 'GPS': 29524},\n",
" '粤B7BB26': {'OD': 83, 'GPS': 14779},\n",
" '粤B9BB86': {'OD': 287, 'GPS': 27443},\n",
" '粤BW7N41': {'OD': 83, 'GPS': 17299},\n",
" '粤B2BY43': {'OD': 472, 'GPS': 29661},\n",
" '粤B7BY00': {'OD': 347, 'GPS': 29295},\n",
" '粤B3BX86': {'OD': 288, 'GPS': 26057},\n",
" '粤B4AE51': {'OD': 105, 'GPS': 15959},\n",
" '粤B7BA71': {'OD': 231, 'GPS': 21689},\n",
" '粤B6AE47': {'OD': 77, 'GPS': 16538},\n",
" '粤BH6J47': {'OD': 353, 'GPS': 28738},\n",
" '粤BH4K73': {'OD': 261, 'GPS': 15322},\n",
" '粤B3BX07': {'OD': 459, 'GPS': 29302},\n",
" '粤B6NR46': {'OD': 329, 'GPS': 26924},\n",
" '粤BH1Q50': {'OD': 473, 'GPS': 29812},\n",
" '粤B13274': {'OD': 403, 'GPS': 30252},\n",
" '粤B8BW33': {'OD': 362, 'GPS': 25266},\n",
" '粤B9BW69': {'OD': 369, 'GPS': 26374},\n",
" '粤BZ4X31': {'OD': 289, 'GPS': 29623},\n",
" '粤B0BX67': {'OD': 439, 'GPS': 29727},\n",
" '粤BZ4S71': {'OD': 388, 'GPS': 26957},\n",
" '粤BH2Q19': {'OD': 303, 'GPS': 28281},\n",
" '粤B2BB61': {'OD': 365, 'GPS': 28883},\n",
" '粤B7BW37': {'OD': 251, 'GPS': 26717},\n",
" '粤BZ2Z41': {'OD': 295, 'GPS': 26799},\n",
" '粤B9BW71': {'OD': 441, 'GPS': 26764},\n",
" '粤B8BB37': {'OD': 422, 'GPS': 29005},\n",
" '粤B5BW59': {'OD': 123, 'GPS': 17418},\n",
" '粤B5BA31': {'OD': 361, 'GPS': 27358},\n",
" '粤B9AK41': {'OD': 116, 'GPS': 27683},\n",
" '粤B0BX40': {'OD': 343, 'GPS': 26497},\n",
" '粤B5BW73': {'OD': 287, 'GPS': 26461},\n",
" '粤BZ4Z95': {'OD': 369, 'GPS': 27330},\n",
" '粤B4AF61': {'OD': 395, 'GPS': 27353},\n",
" '粤BH4L12': {'OD': 431, 'GPS': 29543},\n",
" '粤B9BW13': {'OD': 425, 'GPS': 28883},\n",
" '粤B1AJ47': {'OD': 80, 'GPS': 16135},\n",
" '粤B7BW42': {'OD': 415, 'GPS': 26636},\n",
" '粤BH8L19': {'OD': 377, 'GPS': 29147},\n",
" '粤B3BB55': {'OD': 235, 'GPS': 21443},\n",
" '粤B2BX71': {'OD': 452, 'GPS': 29553},\n",
" '粤BZ3Z70': {'OD': 278, 'GPS': 26170},\n",
" '粤B6BB75': {'OD': 59, 'GPS': 17528},\n",
" '粤B4BX08': {'OD': 402, 'GPS': 26917},\n",
" '粤B3BA72': {'OD': 124, 'GPS': 16731},\n",
" '粤B5BW48': {'OD': 359, 'GPS': 27113},\n",
" '粤B38267': {'OD': 336, 'GPS': 29537},\n",
" '粤BW7L47': {'OD': 386, 'GPS': 27670},\n",
" '粤B1BA76': {'OD': 173, 'GPS': 22191},\n",
" '粤B3BB52': {'OD': 85, 'GPS': 17063},\n",
" '粤BH0F47': {'OD': 519, 'GPS': 29658},\n",
" '粤B7BA49': {'OD': 137, 'GPS': 27148},\n",
" '粤BZ3X41': {'OD': 345, 'GPS': 27728},\n",
" '粤BH9J24': {'OD': 362, 'GPS': 28937},\n",
" '粤B3BX19': {'OD': 340, 'GPS': 27436},\n",
" '粤B3BX13': {'OD': 368, 'GPS': 26175},\n",
" '粤BH1Q14': {'OD': 207, 'GPS': 14681},\n",
" '粤BZ8Z46': {'OD': 306, 'GPS': 27097},\n",
" '粤BW2T47': {'OD': 323, 'GPS': 26651},\n",
" '粤B9BW42': {'OD': 418, 'GPS': 29221},\n",
" '粤B3AK46': {'OD': 427, 'GPS': 29164},\n",
" '粤BH6L54': {'OD': 437, 'GPS': 28572},\n",
" '粤B7BW57': {'OD': 451, 'GPS': 26864},\n",
" '粤BH4Q77': {'OD': 458, 'GPS': 27857},\n",
" '粤B9AH41': {'OD': 278, 'GPS': 26234},\n",
" '粤B9BW01': {'OD': 314, 'GPS': 25354},\n",
" '粤BH4Q99': {'OD': 500, 'GPS': 29572},\n",
" '粤BH3Q50': {'OD': 363, 'GPS': 27752},\n",
" '粤BH8L99': {'OD': 378, 'GPS': 30230},\n",
" '粤B0AA56': {'OD': 374, 'GPS': 26870},\n",
" '粤B7BW48': {'OD': 353, 'GPS': 26122},\n",
" '粤BW7C43': {'OD': 137, 'GPS': 20387},\n",
" '粤BZ1Z67': {'OD': 410, 'GPS': 29251},\n",
" '粤BH7Q64': {'OD': 107, 'GPS': 29114},\n",
" '粤BZ6Z46': {'OD': 409, 'GPS': 26706},\n",
" '粤B2BB91': {'OD': 369, 'GPS': 26611},\n",
" '粤BZ1W40': {'OD': 327, 'GPS': 26383},\n",
" '粤B6BY29': {'OD': 341, 'GPS': 27595},\n",
" '粤B1AJ43': {'OD': 375, 'GPS': 26418},\n",
" '粤BH4J50': {'OD': 486, 'GPS': 28966},\n",
" '粤BZ2X47': {'OD': 428, 'GPS': 27362},\n",
" '粤B3BY71': {'OD': 346, 'GPS': 27249},\n",
" '粤B4AK60': {'OD': 396, 'GPS': 27176},\n",
" '粤BH4L20': {'OD': 394, 'GPS': 29972},\n",
" '粤B7BB96': {'OD': 479, 'GPS': 27940},\n",
" '粤B9BW50': {'OD': 86, 'GPS': 18949},\n",
" '粤BH2J40': {'OD': 407, 'GPS': 29320},\n",
" '粤BH4Q89': {'OD': 438, 'GPS': 29193},\n",
" '粤BH3Q75': {'OD': 366, 'GPS': 29086},\n",
" '粤B2BB32': {'OD': 347, 'GPS': 27207},\n",
" '粤B9BA46': {'OD': 401, 'GPS': 26268},\n",
" '粤BH4Q66': {'OD': 407, 'GPS': 28532},\n",
" '粤B24714': {'OD': 392, 'GPS': 28623},\n",
" '粤B2BB97': {'OD': 37, 'GPS': 33899},\n",
" '粤B7BY87': {'OD': 394, 'GPS': 29853},\n",
" '粤B8AH42': {'OD': 397, 'GPS': 26758},\n",
" '粤BH4J45': {'OD': 397, 'GPS': 30227},\n",
" '粤B9AJ41': {'OD': 312, 'GPS': 26646},\n",
" '粤BH4Q12': {'OD': 378, 'GPS': 28311},\n",
" '粤BZ4W12': {'OD': 378, 'GPS': 28628},\n",
" '粤B37895': {'OD': 353, 'GPS': 29001},\n",
" '粤B5BY68': {'OD': 454, 'GPS': 29411},\n",
" '粤BZ7T42': {'OD': 352, 'GPS': 26111},\n",
" '粤B0BX55': {'OD': 448, 'GPS': 28906},\n",
" '粤BZ7Z29': {'OD': 347, 'GPS': 26647},\n",
" '粤B4BA72': {'OD': 72, 'GPS': 16652},\n",
" '粤BH8L04': {'OD': 438, 'GPS': 29237},\n",
" '粤B5AK39': {'OD': 377, 'GPS': 26286},\n",
" '粤B6BB10': {'OD': 89, 'GPS': 17088},\n",
" '粤BH0Q08': {'OD': 366, 'GPS': 29655},\n",
" '粤B4BB16': {'OD': 88, 'GPS': 17275},\n",
" '粤BF1P74': {'OD': 383, 'GPS': 29617},\n",
" '粤BH7Q50': {'OD': 385, 'GPS': 29212},\n",
" '粤B39140': {'OD': 493, 'GPS': 30135},\n",
" '粤B6BW50': {'OD': 325, 'GPS': 26261},\n",
" '粤BZ3S47': {'OD': 383, 'GPS': 26130},\n",
" '粤B3BX16': {'OD': 342, 'GPS': 28960},\n",
" '粤B5BW16': {'OD': 394, 'GPS': 27108},\n",
" '粤BH9K44': {'OD': 416, 'GPS': 32451},\n",
" '粤B7BB81': {'OD': 358, 'GPS': 26998},\n",
" '粤BH5L58': {'OD': 478, 'GPS': 29289}}"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ID_to_size_of_dataframe\n",
"\n",
"# This is good, each of these overlapping IDs have hundreds of OD entries, and thousands of GPS entries"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'粤BW5Z47': 26226,\n",
" '粤B4BS21': 25871,\n",
" '粤B24764': 5606,\n",
" '粤B8BA76': 15994,\n",
" '粤BY8V47': 3377,\n",
" '粤B5BB79': 26333,\n",
" '粤BH8Q18': 29057,\n",
" '粤B0BB42': 26730,\n",
" '粤B6BW07': 27146,\n",
" '粤BY4Z31': 27732,\n",
" '粤BH4Q46': 13806,\n",
" '粤B5BB26': 26577,\n",
" '粤B0BX16': 26676,\n",
" '粤BH8L49': 28850,\n",
" '粤BX4S40': 26823,\n",
" '粤B39605': 28403,\n",
" '粤BH3E47': 29334,\n",
" '粤B4BY31': 26956,\n",
" '粤B0BX35': 29333}"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# But now GPS entries exist for IDs only in the GPS set?\n",
"\n",
"size_of_GPS_only_entries = {}\n",
"\n",
"for ID in list(GPS_IDs.difference(OD_IDs)):\n",
" size_of_GPS_only_entries[ID] = len(GPS.loc[ID])\n",
"\n",
"size_of_GPS_only_entries\n",
"\n",
"# The magnitude is large, but there are not many entries."
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": true,
"jupyter": {
"outputs_hidden": true
}
},
"outputs": [
{
"data": {
"text/plain": [
"{'粤B8HS47': 684,\n",
" '粤BL1H23': 393,\n",
" '粤B1MS03': 693,\n",
" '粤B0MU42': 320,\n",
" '粤B746U9': 620,\n",
" '粤B279G2': 596,\n",
" '粤BK0Z71': 433,\n",
" '粤BL4Q06': 380,\n",
" '粤B2HX47': 662,\n",
" '粤B9HL90': 661,\n",
" '粤BW8N32': 425,\n",
" '粤BK4X42': 592,\n",
" '粤B718U1': 665,\n",
" '粤B491F5': 395,\n",
" '粤BA2G94': 545,\n",
" '粤BN3F72': 357,\n",
" '粤B282Y2': 223,\n",
" '粤BW4A52': 23,\n",
" '粤B285Y8': 467,\n",
" '粤BW4E72': 655,\n",
" '粤B4HS50': 149,\n",
" '粤B546W0': 159,\n",
" '粤B388Q2': 20,\n",
" '粤BW9D60': 571,\n",
" '粤B1WK31': 513,\n",
" '粤B840U9': 260,\n",
" '粤BF7755': 601,\n",
" '粤B292Y7': 454,\n",
" '粤B961U9': 398,\n",
" '粤B9HT06': 431,\n",
" '粤B3367D': 463,\n",
" '粤B473WZ': 555,\n",
" '粤BCH726': 478,\n",
" '粤B047ZC': 340,\n",
" '粤B4HQ76': 469,\n",
" '粤B735YU': 628,\n",
" '粤B7BV41': 325,\n",
" '粤B7620D': 224,\n",
" '粤BL3E43': 567,\n",
" '粤BJ68E2': 557,\n",
" '粤B204F0': 621,\n",
" '粤BK4V26': 537,\n",
" '粤B4789B': 514,\n",
" '粤B776ZD': 319,\n",
" '粤BK9V12': 540,\n",
" '粤B3NP30': 423,\n",
" '粤B540S9': 62,\n",
" '粤B1MQ99': 491,\n",
" '粤B2FQ12': 478,\n",
" '粤B3MS41': 541,\n",
" '粤BA4B54': 518,\n",
" '粤B3WK83': 666,\n",
" '粤BU3L76': 278,\n",
" '粤B464P0': 543,\n",
" '粤B6WQ40': 605,\n",
" '粤B4H575': 517,\n",
" '粤B2VU75': 611,\n",
" '粤BA6P15': 506,\n",
" '粤B165YN': 541,\n",
" '粤B576ZK': 392,\n",
" '粤BK4W63': 431,\n",
" '粤B093YS': 684,\n",
" '粤B4MV61': 621,\n",
" '粤BD1S84': 552,\n",
" '粤B715U2': 518,\n",
" '粤BM03M1': 513,\n",
" '粤B267Z3': 447,\n",
" '粤B7443A': 579,\n",
" '粤B97U25': 210,\n",
" '粤B1835D': 552,\n",
" '粤B6MP51': 540,\n",
" '粤B707U9': 338,\n",
" '粤B4HL15': 513,\n",
" '粤B6447E': 374,\n",
" '粤BK9V15': 455,\n",
" '粤B926F6': 453,\n",
" '粤BA2A14': 234,\n",
" '粤B551E0': 393,\n",
" '粤B199H1': 619,\n",
" '粤B7FS90': 162,\n",
" '粤B1HL12': 478,\n",
" '粤BL9H37': 392,\n",
" '粤B214H7': 383,\n",
" '粤B4920B': 286,\n",
" '粤BL4E87': 594,\n",
" '粤B4MN41': 526,\n",
" '粤B544U1': 551,\n",
" '粤B074U5': 587,\n",
" '粤BQ9M52': 511,\n",
" '粤BL0H80': 403,\n",
" '粤B2BV12': 619,\n",
" '粤B0FU70': 385,\n",
" '粤BJ4T54': 374,\n",
" '粤BD2S24': 474,\n",
" '粤B4MV35': 63,\n",
" '粤B9WJ90': 346,\n",
" '粤BD9P63': 601,\n",
" '粤B498S0': 544,\n",
" '粤B0325D': 17,\n",
" '粤B0HQ43': 801,\n",
" '粤B359Q9': 615,\n",
" '粤B438E7': 391,\n",
" '粤B9WR67': 19,\n",
" '粤B1FU75': 169,\n",
" '粤B1ZU32': 148,\n",
" '粤B501ZK': 419,\n",
" '粤B7NN16': 653,\n",
" '粤B8WK47': 529,\n",
" '粤BU8L52': 550,\n",
" '粤B019ZB': 271,\n",
" '粤B312H8': 438,\n",
" '粤B283Z3': 486,\n",
" '粤B834W1': 508,\n",
" '粤B767YP': 25,\n",
" '粤B4HU00': 319,\n",
" '粤B574T7': 380,\n",
" '粤B357Z8': 328,\n",
" '粤B094W7': 552,\n",
" '粤B0HQ53': 180,\n",
" '粤B362R5': 538,\n",
" '粤B4WW18': 268,\n",
" '粤B175YS': 728,\n",
" '粤B909W0': 509,\n",
" '粤BL0M48': 714,\n",
" '粤B383P9': 465,\n",
" '粤BK9Y46': 442,\n",
" '粤B244G0': 370,\n",
" '粤BK7V22': 356,\n",
" '粤BL0X41': 477,\n",
" '粤B0MX50': 564,\n",
" '粤B5292B': 197,\n",
" '粤B451ZB': 573,\n",
" '粤B4WV13': 246,\n",
" '粤B8MP05': 818,\n",
" '粤B347S2': 96,\n",
" '粤B258G2': 255,\n",
" '粤B70U45': 332,\n",
" '粤BM14M1': 453,\n",
" '粤B6VU01': 5,\n",
" '粤BL2G45': 552,\n",
" '粤B0HC67': 419,\n",
" '粤B5WK98': 550,\n",
" '粤BB0E69': 548,\n",
" '粤B8SU95': 608,\n",
" '粤B328YW': 747,\n",
" '粤BW9Q73': 540,\n",
" '粤BL2G47': 362,\n",
" '粤B0MS40': 525,\n",
" '粤BL0H47': 328,\n",
" '粤B1HL50': 553,\n",
" '粤B4BS42': 564,\n",
" '粤BD3P64': 483,\n",
" '粤BL7J46': 492,\n",
" '粤BZ5Q41': 638,\n",
" '粤BA00F2': 551,\n",
" '粤B3YY47': 23,\n",
" '粤B8VW31': 74,\n",
" '粤B953U6': 445,\n",
" '粤B2HU27': 326,\n",
" '粤B1BU42': 515,\n",
" '粤B4SM19': 627,\n",
" '粤BM2G05': 293,\n",
" '粤B4MZ29': 122,\n",
" '粤B571W8': 242,\n",
" '粤B4VW56': 561,\n",
" '粤B1NH49': 483,\n",
" '粤BL4S07': 493,\n",
" '粤B6HP50': 598,\n",
" '粤B464S6': 558,\n",
" '粤B244G2': 436,\n",
" '粤B473WY': 694,\n",
" '粤B5WW48': 659,\n",
" '粤B6WT68': 268,\n",
" '粤B786Z3': 375,\n",
" '粤B3CS47': 535,\n",
" '粤B0BS20': 531,\n",
" '粤B0WK13': 460,\n",
" '粤B544G7': 519,\n",
" '粤B7HX18': 598,\n",
" '粤BC1P24': 608,\n",
" '粤BDV142': 22,\n",
" '粤B1HQ13': 121,\n",
" '粤B835E0': 529,\n",
" '粤B6589E': 554,\n",
" '粤B405YP': 357,\n",
" '粤B757U1': 621,\n",
" '粤B805E5': 614,\n",
" '粤B719U0': 525,\n",
" '粤B1802D': 163,\n",
" '粤BX1Y33': 386,\n",
" '粤B1HQ57': 595,\n",
" '粤B448S5': 399,\n",
" '粤B4VU31': 531,\n",
" '粤BQ6P32': 560,\n",
" '粤B77U17': 124,\n",
" '粤B5HX45': 233,\n",
" '粤B9424G': 230,\n",
" '粤B419ZC': 740,\n",
" '粤B783Z1': 52,\n",
" '粤B0563D': 205,\n",
" '粤B069U8': 411,\n",
" '粤B3HR70': 359,\n",
" '粤B494G3': 602,\n",
" '粤B8NA12': 535,\n",
" '粤BK8X90': 469,\n",
" '粤B5WR93': 472,\n",
" '粤B92U87': 241,\n",
" '粤B1FU17': 503,\n",
" '粤B2NS53': 498,\n",
" '粤B985YZ': 345,\n",
" '粤B4HL52': 426,\n",
" '粤B320F0': 549,\n",
" '粤B047W1': 419,\n",
" '粤BD2G41': 233,\n",
" '粤B587U7': 579,\n",
" '粤B8BU87': 528,\n",
" '粤B407YU': 723,\n",
" '粤BA5F40': 470,\n",
" '粤BN5A47': 425,\n",
" '粤BU1L72': 612,\n",
" '粤BK3W49': 464,\n",
" '粤BK2F15': 456,\n",
" '粤B2NK27': 617,\n",
" '粤B2NS12': 585,\n",
" '粤B9HW50': 593,\n",
" '粤B336Y8': 431,\n",
" '粤BW8E41': 63,\n",
" '粤B4NJ52': 580,\n",
" '粤BN4B47': 461,\n",
" '粤B898F0': 560,\n",
" '粤BG0Y42': 521,\n",
" '粤B6WK75': 679,\n",
" '粤B301Y0': 187,\n",
" '粤B1878D': 530,\n",
" '粤BK4W92': 501,\n",
" '粤BL4Q62': 459,\n",
" '粤B0HU79': 600,\n",
" '粤B7HX36': 602,\n",
" '粤B6110E': 583,\n",
" '粤B4BG47': 455,\n",
" '粤BK5F94': 568,\n",
" '粤BK4X97': 534,\n",
" '粤B4HX20': 842,\n",
" '粤BU9K96': 478,\n",
" '粤B070YP': 39,\n",
" '粤B776S3': 470,\n",
" '粤B5NC38': 477,\n",
" '粤B3MX56': 567,\n",
" '粤B404U2': 432,\n",
" '粤BC1P77': 565,\n",
" '粤B7NP29': 461,\n",
" '粤B381R7': 500,\n",
" '粤B7FP79': 542,\n",
" '粤B7WK32': 697,\n",
" '粤B913E6': 623,\n",
" '粤B7SM09': 539,\n",
" '粤B241C5': 595,\n",
" '粤B896F6': 653,\n",
" '粤BL0R35': 402,\n",
" '粤B3187E': 469,\n",
" '粤BJ46C1': 691,\n",
" '粤B812E3': 543,\n",
" '粤B551U5': 198,\n",
" '粤B4405D': 411,\n",
" '粤B3382U': 369,\n",
" '粤B196Y3': 598,\n",
" '粤B5374K': 435,\n",
" '粤B7BU67': 344,\n",
" '粤B242U7': 653,\n",
" '粤B046B7': 488,\n",
" '粤B4MX28': 382,\n",
" '粤B766Z6': 237,\n",
" '粤B5FT76': 480,\n",
" '粤B5MP77': 505,\n",
" '粤B2848B': 564,\n",
" '粤B416YU': 352,\n",
" '粤B547ZC': 456,\n",
" '粤B999ZB': 76,\n",
" '粤B706G0': 161,\n",
" '粤B087U2': 537,\n",
" '粤BX2X10': 461,\n",
" '粤B6526E': 471,\n",
" '粤B2BS01': 221,\n",
" '粤B431ZC': 512,\n",
" '粤B5HR88': 449,\n",
" '粤B7NH18': 277,\n",
" '粤B912YU': 627,\n",
" '粤BC0P78': 477,\n",
" '粤B352ZB': 537,\n",
" '粤B271ZD': 215,\n",
" '粤BDV848': 415,\n",
" '粤B424R7': 221,\n",
" '粤B649F5': 534,\n",
" '粤B7ZU08': 690,\n",
" '粤B1HR43': 406,\n",
" '粤B3DY47': 533,\n",
" '粤B499YP': 24,\n",
" '粤B689F0': 570,\n",
" '粤B055V0': 694,\n",
" '粤B4WT26': 577,\n",
" '粤B392W0': 516,\n",
" '粤B3ZU82': 581,\n",
" '粤B074F1': 544,\n",
" '粤B316F5': 549,\n",
" '粤B439YN': 15,\n",
" '粤B093E8': 47,\n",
" '粤B1HL16': 564,\n",
" '粤BN2Z17': 634,\n",
" '粤BL4H30': 317,\n",
" '粤BA7M74': 307,\n",
" '粤B3053B': 584,\n",
" '粤B8NQ70': 490,\n",
" '粤B1MX75': 148,\n",
" '粤B6681H': 197,\n",
" '粤BW4Q40': 577,\n",
" '粤B3HQ61': 618,\n",
" '粤B4HX21': 233,\n",
" '粤B020G7': 451,\n",
" '粤B308F0': 648,\n",
" '粤BD9P55': 291,\n",
" '粤B358R0': 460,\n",
" '粤B681U5': 470,\n",
" '粤BA5E66': 260,\n",
" '粤B990YZ': 333,\n",
" '粤B1NW09': 556,\n",
" '粤B067Z3': 646,\n",
" '粤B378T7': 111,\n",
" '粤B439YP': 204,\n",
" '粤BL1H00': 502,\n",
" '粤BG9X11': 495,\n",
" '粤B2ZY19': 667,\n",
" '粤B4906B': 213,\n",
" '粤B6HX07': 473,\n",
" '粤B0FU78': 374,\n",
" '粤B6SU79': 591,\n",
" '粤B46793': 675,\n",
" '粤B096Y7': 625,\n",
" '粤BD3N46': 413,\n",
" '粤B9CD47': 548,\n",
" '粤B9FM40': 518,\n",
" '粤B256Y9': 346,\n",
" '粤B246ZE': 348,\n",
" '粤B4CQ70': 634,\n",
" '粤BK4V63': 562,\n",
" '粤B9HG45': 24,\n",
" '粤B890W6': 506,\n",
" '粤B449W7': 462,\n",
" '粤BX3Y29': 405,\n",
" '粤BL3J40': 324,\n",
" '粤B1490D': 482,\n",
" '粤BL5G47': 543,\n",
" '粤B227Y5': 335,\n",
" '粤B7MT92': 450,\n",
" '粤BD8N54': 563,\n",
" '粤BH2E64': 526,\n",
" '粤BZ3P40': 669,\n",
" '粤B913YZ': 184,\n",
" '粤B8FS37': 468,\n",
" '粤B928F6': 593,\n",
" '粤BL9G91': 514,\n",
" '粤BL1R13': 616,\n",
" '粤BA2C57': 449,\n",
" '粤BDS325': 543,\n",
" '粤B3VW40': 445,\n",
" '粤BA5E26': 344,\n",
" '粤BL3R41': 278,\n",
" '粤B340YY': 89,\n",
" '粤B393ZB': 670,\n",
" '粤B403U1': 555,\n",
" '粤B471YP': 208,\n",
" '粤BX9R55': 669,\n",
" '粤B24775': 565,\n",
" '粤B3CP40': 593,\n",
" '粤B2HX17': 539,\n",
" '粤BA6G30': 567,\n",
" '粤B2ZU69': 296,\n",
" '粤B3MS77': 454,\n",
" '粤B473T6': 326,\n",
" '粤B060YU': 22,\n",
" '粤B0WW33': 472,\n",
" '粤B4AJ71': 547,\n",
" '粤BM09M1': 405,\n",
" '粤B045U0': 409,\n",
" '粤BA4A79': 521,\n",
" '粤B274R5': 483,\n",
" '粤B6NP65': 642,\n",
" '粤BZ4V17': 74,\n",
" '粤B715YP': 384,\n",
" '粤BN0A80': 473,\n",
" '粤BX0X35': 447,\n",
" '粤BL4H51': 392,\n",
" '粤B1533D': 217,\n",
" '粤B397Z0': 608,\n",
" '粤B160Y3': 487,\n",
" '粤B5WK11': 399,\n",
" '粤BA3B24': 457,\n",
" '粤BM4G30': 402,\n",
" '粤B3542B': 463,\n",
" '粤BQ7N73': 546,\n",
" '粤BA6E67': 370,\n",
" '粤B850F0': 506,\n",
" '粤BK2W97': 690,\n",
" '粤BS1Q89': 391,\n",
" '粤B4BS19': 127,\n",
" '粤B708U0': 643,\n",
" '粤B9NA22': 451,\n",
" '粤BL0H50': 584,\n",
" '粤BL4M27': 414,\n",
" '粤BA94L5': 272,\n",
" '粤BK6V72': 641,\n",
" '粤B414U1': 216,\n",
" '粤B457H7': 6,\n",
" '粤B0FQ97': 279,\n",
" '粤B5NX86': 582,\n",
" '粤B741U2': 568,\n",
" '粤B1WR83': 661,\n",
" '粤B589W7': 384,\n",
" '粤B539YU': 586,\n",
" '粤B515S0': 557,\n",
" '粤B993W5': 501,\n",
" '粤BCU301': 566,\n",
" '粤B730YP': 280,\n",
" '粤B908F6': 651,\n",
" '粤BD2D45': 416,\n",
" '粤B7CR41': 612,\n",
" '粤BL4P17': 629,\n",
" '粤B083R8': 636,\n",
" '粤BDS492': 322,\n",
" '粤B440G5': 397,\n",
" '粤B1162D': 443,\n",
" '粤B4HR20': 287,\n",
" '粤B274Y1': 567,\n",
" '粤B6NP28': 449,\n",
" '粤B7WQ69': 594,\n",
" '粤B6SU57': 647,\n",
" '粤BK2Z35': 370,\n",
" '粤B5ND83': 398,\n",
" '粤BM06M1': 468,\n",
" '粤B4HX30': 552,\n",
" '粤BCB771': 18,\n",
" '粤BK2F51': 564,\n",
" '粤BK4Y13': 690,\n",
" '粤BK1U62': 408,\n",
" '粤B427WZ': 524,\n",
" '粤B259G1': 170,\n",
" '粤B4HL27': 459,\n",
" '粤B392H6': 643,\n",
" '粤B841E8': 550,\n",
" '粤B256YW': 624,\n",
" '粤BK1X29': 495,\n",
" '粤B073P5': 530,\n",
" '粤B4WW63': 79,\n",
" '粤BG9W85': 273,\n",
" '粤BS9P95': 481,\n",
" '粤B141G9': 365,\n",
" '粤B1HL51': 659,\n",
" '粤B841YY': 154,\n",
" '粤B9996B': 367,\n",
" '粤B840Y0': 380,\n",
" '粤B6WK35': 263,\n",
" '粤BJ74B8': 570,\n",
" '粤B1HY28': 576,\n",
" '粤BK8P59': 450,\n",
" '粤B7961D': 383,\n",
" '粤B2NP29': 10,\n",
" '粤B2HL60': 456,\n",
" '粤B687U5': 490,\n",
" '粤B2761B': 532,\n",
" '粤B8MP31': 352,\n",
" '粤B846Z9': 433,\n",
" '粤BV7W53': 270,\n",
" '粤B383ZB': 661,\n",
" '粤BE9646': 614,\n",
" '粤BK1X59': 409,\n",
" '粤BX1Y35': 160,\n",
" '粤B0BV65': 2,\n",
" '粤B0HK46': 636,\n",
" '粤B2FQ17': 552,\n",
" '粤BG1V40': 563,\n",
" '粤BK4Y47': 444,\n",
" '粤B9BT47': 629,\n",
" '粤B0HL61': 594,\n",
" '粤B417ZC': 609,\n",
" '粤BK0Z95': 391,\n",
" '粤BF4411': 649,\n",
" '粤B3301B': 481,\n",
" '粤B0HY37': 525,\n",
" '粤B437ZB': 719,\n",
" '粤B614W7': 119,\n",
" '粤B045H0': 630,\n",
" '粤B864W2': 410,\n",
" '粤B7FP73': 388,\n",
" '粤B7SU16': 168,\n",
" '粤B7MU55': 382,\n",
" '粤B258G6': 185,\n",
" '粤B1MS92': 222,\n",
" '粤B3WT37': 643,\n",
" '粤BA1B41': 453,\n",
" '粤B484U2': 496,\n",
" '粤B785E1': 581,\n",
" '粤B1WT95': 513,\n",
" '粤B4HR72': 433,\n",
" '粤BM05M0': 546,\n",
" '粤B9WL70': 644,\n",
" '粤B3944G': 408,\n",
" '粤B9NF11': 481,\n",
" '粤B653Z2': 451,\n",
" '粤B465YP': 317,\n",
" '粤B934G3': 714,\n",
" '粤B0143D': 325,\n",
" '粤B9BT72': 527,\n",
" '粤B6123D': 395,\n",
" '粤BK4P16': 604,\n",
" '粤B0FU08': 459,\n",
" '粤B2BY47': 499,\n",
" '粤B832E7': 539,\n",
" '粤BL1Q47': 422,\n",
" '粤B903YZ': 328,\n",
" '粤B146G1': 680,\n",
" '粤BD7Q43': 606,\n",
" '粤B3NS03': 555,\n",
" '粤B44724': 516,\n",
" '粤B8UE09': 600,\n",
" '粤B043ZE': 99,\n",
" '粤B430R3': 397,\n",
" '粤BC9159': 512,\n",
" '粤BK3V47': 486,\n",
" '粤B1WT37': 546,\n",
" '粤BA1K01': 472,\n",
" '粤BN2A97': 690,\n",
" '粤B487YP': 7,\n",
" '粤B4HR05': 542,\n",
" '粤BK3X40': 599,\n",
" '粤BK2X90': 580,\n",
" '粤BV2R45': 423,\n",
" '粤BCG342': 27,\n",
" '粤BL4C02': 408,\n",
" '粤B706U9': 595,\n",
" '粤B3256B': 345,\n",
" '粤B901W3': 482,\n",
" '粤B152ZD': 365,\n",
" '粤BV0X76': 320,\n",
" '粤B9UU38': 489,\n",
" '粤B7UF37': 632,\n",
" '粤BX4X33': 342,\n",
" '粤B422R2': 668,\n",
" '粤B389P6': 464,\n",
" '粤B862Y7': 390,\n",
" '粤B0937D': 423,\n",
" '粤B4HY01': 576,\n",
" '粤B910G2': 488,\n",
" '粤B7BT92': 643,\n",
" '粤BL3R02': 587,\n",
" '粤B964R6': 411,\n",
" '粤B256Y7': 450,\n",
" '粤B5ZU30': 585,\n",
" '粤B1HQ45': 251,\n",
" '粤BK1Z99': 416,\n",
" '粤B533S1': 651,\n",
" '粤B1ND59': 622,\n",
" '粤BL2C46': 433,\n",
" '粤BK3F60': 600,\n",
" '粤BV1P21': 58,\n",
" '粤B4HS87': 607,\n",
" '粤B292G7': 221,\n",
" '粤B944F0': 565,\n",
" '粤BX4Y70': 191,\n",
" '粤BX2X83': 496,\n",
" '粤B2BJ47': 531,\n",
" '粤B798S6': 424,\n",
" '粤B305H1': 440,\n",
" '粤B7FP07': 408,\n",
" '粤BL2H09': 528,\n",
" '粤BL7Z40': 476,\n",
" '粤B0BS03': 118,\n",
" '粤BK5T32': 404,\n",
" '粤B059U1': 268,\n",
" '粤BK5V70': 556,\n",
" '粤B5MV62': 143,\n",
" '粤B445S7': 352,\n",
" '粤B4CP41': 529,\n",
" '粤B14953': 487,\n",
" '粤B311R9': 194,\n",
" '粤BW9L57': 443,\n",
" '粤B502V0': 554,\n",
" '粤BL7G41': 440,\n",
" '粤B072Y3': 549,\n",
" '粤B857E6': 491,\n",
" '粤BA5N44': 507,\n",
" '粤BS9N63': 481,\n",
" '粤BJ9W74': 488,\n",
" '粤BA3E04': 388,\n",
" '粤B999YZ': 340,\n",
" '粤BJ24B0': 412,\n",
" '粤B8HY39': 17,\n",
" '粤B977W9': 493,\n",
" '粤BD7K36': 376,\n",
" '粤B184Y5': 446,\n",
" '粤B300Y1': 417,\n",
" '粤B4BS79': 583,\n",
" '粤B8MP11': 638,\n",
" '粤B4NK20': 559,\n",
" '粤B105S8': 454,\n",
" '粤B2MQ86': 458,\n",
" '粤B043T7': 464,\n",
" '粤BA0K61': 414,\n",
" '粤BD4S90': 563,\n",
" '粤BK0X01': 515,\n",
" '粤B2WQ35': 116,\n",
" '粤BJ47B0': 536,\n",
" '粤B1709D': 635,\n",
" '粤BJ2P53': 559,\n",
" '粤B0HL72': 455,\n",
" '粤BK3T72': 478,\n",
" '粤B723ZD': 253,\n",
" '粤B7HZ45': 638,\n",
" '粤B033ZD': 560,\n",
" '粤B3342V': 300,\n",
" '粤B528YU': 778,\n",
" '粤B748Z5': 340,\n",
" '粤B1MQ55': 491,\n",
" '粤B377Q5': 601,\n",
" '粤B7HT27': 556,\n",
" '粤B745R1': 458,\n",
" '粤B1MX26': 396,\n",
" '粤B884W5': 542,\n",
" '粤B561G3': 565,\n",
" '粤B095V5': 483,\n",
" '粤BK9V07': 363,\n",
" '粤B058V2': 232,\n",
" '粤BK2Z08': 446,\n",
" '粤B6823H': 516,\n",
" '粤BK3Y47': 437,\n",
" '粤B225P8': 594,\n",
" '粤B7NN62': 349,\n",
" '粤BW4C47': 658,\n",
" '粤BN2A18': 386,\n",
" '粤B2HL18': 529,\n",
" '粤BK1F17': 436,\n",
" '粤B1FU05': 315,\n",
" '粤B144V7': 494,\n",
" '粤B6FU49': 479,\n",
" '粤B457ZD': 258,\n",
" '粤BD8D15': 599,\n",
" '粤BW1C46': 576,\n",
" '粤B480ZE': 347,\n",
" '粤B012U5': 428,\n",
" '粤B669Z8': 300,\n",
" '粤B568G3': 626,\n",
" '粤B2MX85': 469,\n",
" '粤B729U0': 528,\n",
" '粤B7HR48': 260,\n",
" '粤B5ZU43': 513,\n",
" '粤B063Y0': 435,\n",
" '粤B794S7': 510,\n",
" '粤B907U1': 526,\n",
" '粤B063R3': 361,\n",
" '粤BJ30K8': 421,\n",
" '粤B3HU78': 352,\n",
" '粤B472YZ': 623,\n",
" '粤BK6W92': 482,\n",
" '粤B8MP79': 629,\n",
" '粤B3ND47': 472,\n",
" '粤B428YP': 274,\n",
" '粤B181F7': 45,\n",
" '粤B294G9': 354,\n",
" '粤BG9X88': 350,\n",
" '粤B0HX67': 530,\n",
" '粤B4254H': 422,\n",
" '粤B2MX12': 470,\n",
" '粤B4WJ62': 512,\n",
" '粤B6WK71': 293,\n",
" '粤B861ZK': 350,\n",
" '粤BV4W53': 614,\n",
" '粤B905ZB': 642,\n",
" '粤BL4S42': 405,\n",
" '粤B920W5': 339,\n",
" '粤B847R9': 521,\n",
" '粤BJ7Y64': 388,\n",
" '粤BL5P41': 147,\n",
" '粤B168Y2': 572,\n",
" '粤B241W5': 135,\n",
" '粤B280Y6': 433,\n",
" '粤B894U1': 430,\n",
" '粤B3WT20': 397,\n",
" '粤BK9W25': 548,\n",
" '粤B6FT70': 465,\n",
" '粤B4937D': 480,\n",
" '粤B9617K': 326,\n",
" '粤BK0Z20': 436,\n",
" '粤BV0Y41': 475,\n",
" '粤BX4Y21': 286,\n",
" '粤B0WK67': 453,\n",
" '粤B369H8': 376,\n",
" '粤B4NA00': 613,\n",
" '粤B1CP02': 559,\n",
" '粤B6MN87': 792,\n",
" '粤B4HK18': 489,\n",
" '粤B006V9': 620,\n",
" '粤B28074': 397,\n",
" '粤B472Z7': 260,\n",
" '粤B586VX': 433,\n",
" '粤B7407D': 341,\n",
" '粤B2HL75': 193,\n",
" '粤BD8Q09': 248,\n",
" '粤B2VW47': 729,\n",
" '粤BK4X65': 462,\n",
" '粤B280Y9': 323,\n",
" '粤BK6X27': 506,\n",
" '粤B065H3': 470,\n",
" '粤BQ3P96': 542,\n",
" '粤B898F2': 498,\n",
" '粤B6WW42': 369,\n",
" '粤B3WR27': 123,\n",
" '粤B091U3': 409,\n",
" '粤B4730E': 517,\n",
" '粤B4MX39': 399,\n",
" '粤B2CL47': 588,\n",
" '粤B827E9': 646,\n",
" '粤BL0H62': 566,\n",
" '粤B1WK52': 450,\n",
" '粤B009H9': 612,\n",
" '粤BA0464': 216,\n",
" '粤B432W1': 471,\n",
" '粤B346G3': 111,\n",
" '粤B086U0': 378,\n",
" '粤B916F9': 572,\n",
" '粤BD7K22': 195,\n",
" '粤BX4W38': 440,\n",
" '粤B442G6': 355,\n",
" '粤BX4X67': 323,\n",
" '粤BM05M9': 501,\n",
" '粤B5FU87': 510,\n",
" '粤BN6F75': 503,\n",
" '粤BV4X77': 553,\n",
" '粤B7MQ07': 502,\n",
" '粤B1CP45': 290,\n",
" '粤B3VW23': 447,\n",
" '粤BK4V97': 503,\n",
" '粤B1MQ83': 501,\n",
" '粤B5WT33': 311,\n",
" '粤B1HD12': 455,\n",
" '粤B268G8': 200,\n",
" '粤B2ZU21': 573,\n",
" '粤B25482': 286,\n",
" '粤BZ5V47': 575,\n",
" '粤B1VU41': 678,\n",
" '粤B2FZ45': 445,\n",
" '粤B590W7': 401,\n",
" '粤BA22H6': 389,\n",
" '粤B344U1': 233,\n",
" '粤B413U1': 693,\n",
" '粤BC7N92': 537,\n",
" '粤B474Q1': 465,\n",
" '粤B7118H': 514,\n",
" '粤B0HQ45': 519,\n",
" '粤B8MU00': 464,\n",
" '粤B1091D': 415,\n",
" '粤BEB610': 27,\n",
" '粤B474U3': 665,\n",
" '粤B473ZB': 574,\n",
" '粤B3MX58': 573,\n",
" '粤B907W7': 558,\n",
" '粤B2FU16': 515,\n",
" '粤B572W1': 492,\n",
" '粤B664Z9': 470,\n",
" '粤B914R9': 409,\n",
" '粤B931W6': 414,\n",
" '粤B291Z6': 404,\n",
" '粤B461ZC': 121,\n",
" '粤BB0K34': 503,\n",
" '粤B038Y7': 441,\n",
" '粤B3WW49': 506,\n",
" '粤B519V2': 371,\n",
" '粤B506E2': 332,\n",
" '粤B837E2': 576,\n",
" '粤B2WT76': 368,\n",
" '粤B3NQ47': 523,\n",
" '粤B012YS': 688,\n",
" '粤B92U53': 91,\n",
" '粤B6MQ03': 582,\n",
" '粤B0MX87': 345,\n",
" '粤B516W7': 116,\n",
" '粤B1NW60': 484,\n",
" '粤B0HL01': 484,\n",
" '粤BL0H58': 429,\n",
" '粤B314U0': 479,\n",
" '粤B477W6': 372,\n",
" '粤BK1Z33': 460,\n",
" '粤B547YT': 535,\n",
" '粤B6HS41': 621,\n",
" '粤B1HX13': 732,\n",
" '粤BW9B46': 619,\n",
" '粤B031U0': 416,\n",
" '粤BEA502': 53,\n",
" '粤B057ZE': 151,\n",
" '粤BK1X31': 394,\n",
" '粤B7HX80': 580,\n",
" '粤B37999': 237,\n",
" '粤B7KK93': 418,\n",
" '粤B339U1': 187,\n",
" '粤BJ43L5': 338,\n",
" '粤BK2X17': 487,\n",
" '粤BL5Q42': 653,\n",
" '粤BK7U20': 534,\n",
" '粤B1591D': 433,\n",
" '粤B4CT71': 470,\n",
" '粤B4WT68': 403,\n",
" '粤B6BU95': 555,\n",
" '粤B326Y9': 396,\n",
" '粤B7VW19': 593,\n",
" '粤BA3J94': 541,\n",
" '粤B1768D': 8,\n",
" '粤B4MX38': 499,\n",
" '粤B4CT27': 343,\n",
" '粤BW6N75': 511,\n",
" '粤BJ2N74': 414,\n",
" '粤B925W1': 485,\n",
" '粤B7VW15': 444,\n",
" '粤B4DS30': 388,\n",
" '粤B0WT51': 747,\n",
" '粤BW4P07': 638,\n",
" '粤BQ6N87': 633,\n",
" '粤B4HL55': 381,\n",
" '粤B7VW75': 29,\n",
" '粤BG3802': 519,\n",
" '粤B1276A': 131,\n",
" '粤B260G3': 424,\n",
" '粤B3WS26': 464,\n",
" '粤B477W3': 301,\n",
" '粤B695U2': 312,\n",
" '粤BK9V02': 588,\n",
" '粤B388H0': 666,\n",
" '粤B9BS43': 519,\n",
" '粤B793S0': 515,\n",
" '粤BD4S49': 446,\n",
" '粤B6FB86': 518,\n",
" '粤B484T0': 380,\n",
" '粤B451ZE': 193,\n",
" '粤B7CR46': 517,\n",
" '粤BJ31K9': 495,\n",
" '粤B7HB23': 461,\n",
" '粤B310W7': 573,\n",
" '粤B0ZU92': 561,\n",
" '粤B7KK49': 500,\n",
" '粤B0MS21': 634,\n",
" '粤B3ND52': 638,\n",
" '粤B998ZB': 721,\n",
" '粤B0NH43': 610,\n",
" '粤B446G5': 633,\n",
" '粤B5WW92': 672,\n",
" '粤BJ69E7': 646,\n",
" '粤B880F2': 558,\n",
" '粤B3HL59': 505,\n",
" '粤B065R0': 631,\n",
" '粤B2WK89': 329,\n",
" '粤B3DS30': 473,\n",
" '粤B265G8': 519,\n",
" '粤B7HS48': 301,\n",
" '粤B0HQ17': 555,\n",
" '粤B6WK40': 301,\n",
" '粤BK1U96': 465,\n",
" '粤B359ZK': 340,\n",
" '粤B8FT80': 365,\n",
" '粤BA5G68': 523,\n",
" '粤B494T0': 570,\n",
" '粤B1UF97': 526,\n",
" '粤B9VU10': 585,\n",
" '粤BK4X92': 614,\n",
" '粤B418R5': 619,\n",
" '粤BEB040': 55,\n",
" '粤B3994V': 135,\n",
" '粤B7907D': 569,\n",
" '粤B932ZB': 406,\n",
" '粤B3HL10': 499,\n",
" '粤B535ZB': 244,\n",
" '粤B97U81': 365,\n",
" '粤B1058D': 35,\n",
" '粤B002Y1': 278,\n",
" '粤B4HQ57': 371,\n",
" '粤B074W2': 513,\n",
" '粤BL4H45': 17,\n",
" '粤BW4V47': 676,\n",
" '粤B800E3': 493,\n",
" '粤B859Y2': 376,\n",
" '粤B4HL82': 481,\n",
" '粤B0MJ91': 606,\n",
" '粤BK3U77': 490,\n",
" '粤B818E2': 587,\n",
" '粤BK5W68': 512,\n",
" '粤B1HS52': 396,\n",
" '粤B9285A': 546,\n",
" '粤B7CN47': 536,\n",
" '粤B7HX78': 473,\n",
" '粤B7HS52': 339,\n",
" '粤B4ZX38': 584,\n",
" '粤B1WK83': 653,\n",
" '粤BA6N17': 116,\n",
" '粤B36354': 126,\n",
" '粤B065U6': 346,\n",
" '粤B641R2': 384,\n",
" '粤B4BR47': 599,\n",
" '粤B555W6': 144,\n",
" '粤B2HQ37': 807,\n",
" '粤B0DS95': 333,\n",
" '粤B1WQ05': 205,\n",
" '粤B3ZU47': 551,\n",
" '粤B839E9': 517,\n",
" '粤B31147': 242,\n",
" '粤B265G2': 444,\n",
" '粤B5WQ46': 480,\n",
" '粤B2ZU42': 636,\n",
" '粤BK7X63': 554,\n",
" '粤B194Z0': 289,\n",
" '粤B6NP83': 533,\n",
" '粤BK4X30': 489,\n",
" '粤B414S9': 446,\n",
" '粤B7NG29': 8,\n",
" '粤B2MS42': 526,\n",
" '粤B5WT23': 267,\n",
" '粤B2FT97': 385,\n",
" '粤B2BS40': 259,\n",
" '粤B605ZK': 263,\n",
" '粤B72U31': 138,\n",
" '粤B284Y9': 428,\n",
" '粤B764Q2': 481,\n",
" '粤B6WQ46': 455,\n",
" '粤B7057D': 596,\n",
" '粤B2MX76': 346,\n",
" '粤BZ3U47': 608,\n",
" '粤BL7Z95': 591,\n",
" '粤BC5948': 570,\n",
" '粤BJ38K0': 494,\n",
" '粤BA7C94': 508,\n",
" '粤B4MQ23': 448,\n",
" '粤B6CP05': 586,\n",
" '粤B9MN67': 489,\n",
" '粤B9WS45': 150,\n",
" '粤B841U9': 44,\n",
" '粤B8931A': 565,\n",
" '粤B4547D': 628,\n",
" '粤BL4G70': 411,\n",
" '粤B512V2': 452,\n",
" '粤BA3G34': 550,\n",
" '粤B3305U': 217,\n",
" '粤B8HS02': 312,\n",
" '粤B0MQ57': 276,\n",
" '粤B2BV22': 527,\n",
" '粤B7WK78': 338,\n",
" '粤B33146': 397,\n",
" '粤BC5587': 184,\n",
" '粤B7378B': 403,\n",
" '粤B901F5': 541,\n",
" '粤BL1H56': 632,\n",
" '粤B5FY47': 304,\n",
" '粤BK3F81': 366,\n",
" '粤B040R3': 546,\n",
" '粤B1MQ65': 593,\n",
" '粤B4HW23': 373,\n",
" '粤B267G2': 12,\n",
" '粤B405ZE': 335,\n",
" '粤B6VU75': 356,\n",
" '粤BA5G00': 524,\n",
" '粤B1MX65': 546,\n",
" '粤B477V0': 500,\n",
" '粤B1MQ75': 562,\n",
" '粤B3HL70': 147,\n",
" '粤BW1C42': 462,\n",
" '粤B6FU46': 333,\n",
" '粤B467ZB': 101,\n",
" '粤B292U7': 208,\n",
" '粤B452ZD': 597,\n",
" '粤B543D0': 29,\n",
" '粤B3376V': 231,\n",
" '粤B0CP30': 555,\n",
" '粤B624W7': 174,\n",
" '粤B634W6': 122,\n",
" '粤B7MP15': 409,\n",
" '粤B997W9': 559,\n",
" '粤BN5P35': 491,\n",
" '粤B7ZU28': 515,\n",
" '粤B524U1': 418,\n",
" '粤B694Z3': 440,\n",
" '粤BM04T0': 496,\n",
" '粤B0ND96': 570,\n",
" '粤B546E9': 378,\n",
" '粤B0MQ62': 422,\n",
" '粤B4HR45': 608,\n",
" '粤B141ZB': 652,\n",
" '粤BU5K13': 360,\n",
" '粤B1NH82': 298,\n",
" '粤BS2R75': 491,\n",
" '粤BL1H99': 577,\n",
" '粤B374W9': 76,\n",
" '粤B880E0': 553,\n",
" '粤BQ5Q17': 547,\n",
" '粤B084H0': 511,\n",
" '粤B410U9': 492,\n",
" '粤B501S1': 387,\n",
" '粤B1BV28': 476,\n",
" ...}"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Finally, how many OD entries exist for IDs only in the OD set?\n",
"\n",
"size_of_OD_only_entries = {}\n",
"\n",
"for ID in list(OD_IDs.difference(GPS_IDs)):\n",
" size_of_OD_only_entries[ID] = len(OD.loc[ID])\n",
"\n",
"size_of_OD_only_entries\n",
"\n",
"# Oh no, this is significant."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Let's create dict of ID to Series\n",
"\n",
"#### First, a sample"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lon</th>\n",
" <th>lat</th>\n",
" <th>time</th>\n",
" <th>speed</th>\n",
" <th>RID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.961098</td>\n",
" <td>22.553101</td>\n",
" <td>1404360002</td>\n",
" <td>17</td>\n",
" <td>158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962303</td>\n",
" <td>22.547001</td>\n",
" <td>1404360108</td>\n",
" <td>21</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962997</td>\n",
" <td>22.547001</td>\n",
" <td>1404360138</td>\n",
" <td>0</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963799</td>\n",
" <td>22.546400</td>\n",
" <td>1404360168</td>\n",
" <td>11</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963997</td>\n",
" <td>22.544399</td>\n",
" <td>1404360232</td>\n",
" <td>8</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.015900</td>\n",
" <td>22.531000</td>\n",
" <td>1405828340</td>\n",
" <td>40</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.021004</td>\n",
" <td>22.532200</td>\n",
" <td>1405828370</td>\n",
" <td>33</td>\n",
" <td>251</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.025902</td>\n",
" <td>22.530899</td>\n",
" <td>1405828400</td>\n",
" <td>33</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.026703</td>\n",
" <td>22.529900</td>\n",
" <td>1405828430</td>\n",
" <td>18</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.034698</td>\n",
" <td>22.554600</td>\n",
" <td>1405828758</td>\n",
" <td>18</td>\n",
" <td>304</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>26870 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" lon lat time speed RID\n",
"id \n",
"粤B0AA56 113.961098 22.553101 1404360002 17 158\n",
"粤B0AA56 113.962303 22.547001 1404360108 21 311\n",
"粤B0AA56 113.962997 22.547001 1404360138 0 311\n",
"粤B0AA56 113.963799 22.546400 1404360168 11 311\n",
"粤B0AA56 113.963997 22.544399 1404360232 8 311\n",
"... ... ... ... ... ...\n",
"粤B0AA56 114.015900 22.531000 1405828340 40 265\n",
"粤B0AA56 114.021004 22.532200 1405828370 33 251\n",
"粤B0AA56 114.025902 22.530899 1405828400 33 265\n",
"粤B0AA56 114.026703 22.529900 1405828430 18 265\n",
"粤B0AA56 114.034698 22.554600 1405828758 18 304\n",
"\n",
"[26870 rows x 5 columns]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ID = \"粤B0AA56\"\n",
"\n",
"df = GPS.loc[ID]\n",
"\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [],
"source": [
"s = df.set_index(keys=\"time\")"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lon</th>\n",
" <th>lat</th>\n",
" <th>speed</th>\n",
" <th>RID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>time</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1404360002</th>\n",
" <td>113.961098</td>\n",
" <td>22.553101</td>\n",
" <td>17</td>\n",
" <td>158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404360108</th>\n",
" <td>113.962303</td>\n",
" <td>22.547001</td>\n",
" <td>21</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404360138</th>\n",
" <td>113.962997</td>\n",
" <td>22.547001</td>\n",
" <td>0</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404360168</th>\n",
" <td>113.963799</td>\n",
" <td>22.546400</td>\n",
" <td>11</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404360232</th>\n",
" <td>113.963997</td>\n",
" <td>22.544399</td>\n",
" <td>8</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405828340</th>\n",
" <td>114.015900</td>\n",
" <td>22.531000</td>\n",
" <td>40</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405828370</th>\n",
" <td>114.021004</td>\n",
" <td>22.532200</td>\n",
" <td>33</td>\n",
" <td>251</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405828400</th>\n",
" <td>114.025902</td>\n",
" <td>22.530899</td>\n",
" <td>33</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405828430</th>\n",
" <td>114.026703</td>\n",
" <td>22.529900</td>\n",
" <td>18</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405828758</th>\n",
" <td>114.034698</td>\n",
" <td>22.554600</td>\n",
" <td>18</td>\n",
" <td>304</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>26870 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" lon lat speed RID\n",
"time \n",
"1404360002 113.961098 22.553101 17 158\n",
"1404360108 113.962303 22.547001 21 311\n",
"1404360138 113.962997 22.547001 0 311\n",
"1404360168 113.963799 22.546400 11 311\n",
"1404360232 113.963997 22.544399 8 311\n",
"... ... ... ... ...\n",
"1405828340 114.015900 22.531000 40 265\n",
"1405828370 114.021004 22.532200 33 251\n",
"1405828400 114.025902 22.530899 33 265\n",
"1405828430 114.026703 22.529900 18 265\n",
"1405828758 114.034698 22.554600 18 304\n",
"\n",
"[26870 rows x 4 columns]"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lon</th>\n",
" <th>lat</th>\n",
" <th>time</th>\n",
" <th>speed</th>\n",
" <th>RID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.961098</td>\n",
" <td>22.553101</td>\n",
" <td>1404360002</td>\n",
" <td>17</td>\n",
" <td>158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962303</td>\n",
" <td>22.547001</td>\n",
" <td>1404360108</td>\n",
" <td>21</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.962997</td>\n",
" <td>22.547001</td>\n",
" <td>1404360138</td>\n",
" <td>0</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963799</td>\n",
" <td>22.546400</td>\n",
" <td>1404360168</td>\n",
" <td>11</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>113.963997</td>\n",
" <td>22.544399</td>\n",
" <td>1404360232</td>\n",
" <td>8</td>\n",
" <td>311</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.015900</td>\n",
" <td>22.531000</td>\n",
" <td>1405828340</td>\n",
" <td>40</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.021004</td>\n",
" <td>22.532200</td>\n",
" <td>1405828370</td>\n",
" <td>33</td>\n",
" <td>251</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.025902</td>\n",
" <td>22.530899</td>\n",
" <td>1405828400</td>\n",
" <td>33</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.026703</td>\n",
" <td>22.529900</td>\n",
" <td>1405828430</td>\n",
" <td>18</td>\n",
" <td>265</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B0AA56</th>\n",
" <td>114.034698</td>\n",
" <td>22.554600</td>\n",
" <td>1405828758</td>\n",
" <td>18</td>\n",
" <td>304</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>26870 rows × 5 columns</p>\n",
"</div>"
],
"text/plain": [
" lon lat time speed RID\n",
"id \n",
"粤B0AA56 113.961098 22.553101 1404360002 17 158\n",
"粤B0AA56 113.962303 22.547001 1404360108 21 311\n",
"粤B0AA56 113.962997 22.547001 1404360138 0 311\n",
"粤B0AA56 113.963799 22.546400 1404360168 11 311\n",
"粤B0AA56 113.963997 22.544399 1404360232 8 311\n",
"... ... ... ... ... ...\n",
"粤B0AA56 114.015900 22.531000 1405828340 40 265\n",
"粤B0AA56 114.021004 22.532200 1405828370 33 251\n",
"粤B0AA56 114.025902 22.530899 1405828400 33 265\n",
"粤B0AA56 114.026703 22.529900 1405828430 18 265\n",
"粤B0AA56 114.034698 22.554600 1405828758 18 304\n",
"\n",
"[26870 rows x 5 columns]"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"GPS.loc[ID]"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [],
"source": [
"def _from_traffic_dataframe_get_dict_of_ids_to_dataframe(DF, time_key=\"time\"):\n",
" # old; see below.\n",
" IDs = list(set(DF.index))\n",
" \n",
" dict_of_ids_to_dataframe = {}\n",
" \n",
" for key in IDs:\n",
" try:\n",
" dict_of_ids_to_dataframe[key] = DF.loc[key].set_index(keys=time_key)\n",
" except:\n",
" print(type(DF.loc[key]))\n",
" print(key)\n",
" dict_of_ids_to_dataframe[key] = DF.loc[key]\n",
" \n",
" return dict_of_ids_to_dataframe"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"GPS_dict_of_series = _from_traffic_dataframe_get_dict_of_ids_to_dataframe(GPS)"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": true,
"jupyter": {
"outputs_hidden": true
}
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.series.Series'>\n",
"粤B1768D\n",
"<class 'pandas.core.series.Series'>\n",
"粤BL4F48\n",
"<class 'pandas.core.series.Series'>\n",
"粤B0NW32\n",
"<class 'pandas.core.series.Series'>\n",
"粤B057YP\n",
"<class 'pandas.core.series.Series'>\n",
"粤B214G9\n",
"<class 'pandas.core.series.Series'>\n",
"粤B769YP\n",
"<class 'pandas.core.series.Series'>\n",
"粤BG4P31\n",
"<class 'pandas.core.series.Series'>\n",
"粤B9NF80\n",
"<class 'pandas.core.series.Series'>\n",
"粤B7VU87\n",
"<class 'pandas.core.series.Series'>\n",
"粤BL1G45\n",
"<class 'pandas.core.series.Series'>\n",
"粤BG4M70\n",
"<class 'pandas.core.series.Series'>\n",
"粤BK6Y18\n",
"<class 'pandas.core.series.Series'>\n",
"粤BA8H68\n",
"<class 'pandas.core.series.Series'>\n",
"粤BJ14J9\n",
"<class 'pandas.core.series.Series'>\n",
"粤BL4F30\n",
"<class 'pandas.core.series.Series'>\n",
"粤B754D7\n",
"<class 'pandas.core.series.Series'>\n",
"粤B37905\n",
"<class 'pandas.core.series.Series'>\n",
"粤B481YZ\n",
"<class 'pandas.core.series.Series'>\n",
"粤BL4F96\n",
"<class 'pandas.core.series.Series'>\n",
"粤B9WJ61\n",
"<class 'pandas.core.series.Series'>\n",
"粤B7ZT41\n",
"<class 'pandas.core.series.Series'>\n",
"粤B0WK22\n",
"<class 'pandas.core.series.Series'>\n",
"粤B268G5\n",
"<class 'pandas.core.series.Series'>\n",
"粤B7VU02\n",
"<class 'pandas.core.series.Series'>\n",
"粤B3AF41\n",
"<class 'pandas.core.series.Series'>\n",
"粤BK7Y37\n"
]
}
],
"source": [
"OD_dict_of_series = _from_traffic_dataframe_get_dict_of_ids_to_dataframe(OD, time_key=\"ptime\")\n",
"\n",
"# What?? Apparently some of these are series... Ah, because it only has one value it seems?"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {
"jupyter": {
"source_hidden": true
}
},
"outputs": [
{
"data": {
"text/plain": [
"pandas.core.frame.DataFrame"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"type(OD.loc[ID])"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"ptime 1.404942e+09\n",
"dtime 1.404943e+09\n",
"plon 1.142385e+02\n",
"plat 2.271117e+01\n",
"dlon 1.142819e+02\n",
"dlat 2.273182e+01\n",
"pRID 1.300000e+02\n",
"dRID 1.410000e+02\n",
"Name: 粤B1768D, dtype: float64"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"OD.loc[\"粤B1768D\"]\n",
"# Ah, it seems the original data, there's only one value to this ID anyways."
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"pandas.core.series.Series"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"type(OD.loc[\"粤B1768D\"])\n",
"# And so if there is one value, it gets saved as a series."
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"ptime 1.404942e+09\n",
"dtime 1.404943e+09\n",
"plon 1.142385e+02\n",
"plat 2.271117e+01\n",
"dlon 1.142819e+02\n",
"dlat 2.273182e+01\n",
"pRID 1.300000e+02\n",
"dRID 1.410000e+02\n",
"Name: 粤B1768D, dtype: float64"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"OD_dict_of_series[\"粤B1768D\"]"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>dtime</th>\n",
" <th>plon</th>\n",
" <th>plat</th>\n",
" <th>dlon</th>\n",
" <th>dlat</th>\n",
" <th>pRID</th>\n",
" <th>dRID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>ptime</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1404360675</th>\n",
" <td>1404360959</td>\n",
" <td>114.250397</td>\n",
" <td>22.728767</td>\n",
" <td>114.241653</td>\n",
" <td>22.728416</td>\n",
" <td>135</td>\n",
" <td>130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404360988</th>\n",
" <td>1404361607</td>\n",
" <td>114.242531</td>\n",
" <td>22.728468</td>\n",
" <td>114.259850</td>\n",
" <td>22.714634</td>\n",
" <td>130</td>\n",
" <td>137</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404362214</th>\n",
" <td>1404362468</td>\n",
" <td>114.256203</td>\n",
" <td>22.722366</td>\n",
" <td>114.262848</td>\n",
" <td>22.733400</td>\n",
" <td>137</td>\n",
" <td>136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404362651</th>\n",
" <td>1404363795</td>\n",
" <td>114.261299</td>\n",
" <td>22.733368</td>\n",
" <td>114.325951</td>\n",
" <td>22.703617</td>\n",
" <td>136</td>\n",
" <td>89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1404364639</th>\n",
" <td>1404364780</td>\n",
" <td>114.364166</td>\n",
" <td>22.747999</td>\n",
" <td>114.364151</td>\n",
" <td>22.754816</td>\n",
" <td>79</td>\n",
" <td>92</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405737938</th>\n",
" <td>1405738498</td>\n",
" <td>114.233002</td>\n",
" <td>22.732018</td>\n",
" <td>114.239197</td>\n",
" <td>22.762266</td>\n",
" <td>127</td>\n",
" <td>126</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405739346</th>\n",
" <td>1405740146</td>\n",
" <td>114.267082</td>\n",
" <td>22.736782</td>\n",
" <td>114.232300</td>\n",
" <td>22.712317</td>\n",
" <td>136</td>\n",
" <td>131</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405740223</th>\n",
" <td>1405740688</td>\n",
" <td>114.234764</td>\n",
" <td>22.714684</td>\n",
" <td>114.238815</td>\n",
" <td>22.738567</td>\n",
" <td>130</td>\n",
" <td>127</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405740855</th>\n",
" <td>1405741172</td>\n",
" <td>114.235733</td>\n",
" <td>22.732117</td>\n",
" <td>114.232353</td>\n",
" <td>22.719233</td>\n",
" <td>127</td>\n",
" <td>130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1405741402</th>\n",
" <td>1405741836</td>\n",
" <td>114.235313</td>\n",
" <td>22.715017</td>\n",
" <td>114.249649</td>\n",
" <td>22.724051</td>\n",
" <td>130</td>\n",
" <td>135</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>684 rows × 7 columns</p>\n",
"</div>"
],
"text/plain": [
" dtime plon plat dlon dlat pRID \\\n",
"ptime \n",
"1404360675 1404360959 114.250397 22.728767 114.241653 22.728416 135 \n",
"1404360988 1404361607 114.242531 22.728468 114.259850 22.714634 130 \n",
"1404362214 1404362468 114.256203 22.722366 114.262848 22.733400 137 \n",
"1404362651 1404363795 114.261299 22.733368 114.325951 22.703617 136 \n",
"1404364639 1404364780 114.364166 22.747999 114.364151 22.754816 79 \n",
"... ... ... ... ... ... ... \n",
"1405737938 1405738498 114.233002 22.732018 114.239197 22.762266 127 \n",
"1405739346 1405740146 114.267082 22.736782 114.232300 22.712317 136 \n",
"1405740223 1405740688 114.234764 22.714684 114.238815 22.738567 130 \n",
"1405740855 1405741172 114.235733 22.732117 114.232353 22.719233 127 \n",
"1405741402 1405741836 114.235313 22.715017 114.249649 22.724051 130 \n",
"\n",
" dRID \n",
"ptime \n",
"1404360675 130 \n",
"1404360988 137 \n",
"1404362214 136 \n",
"1404362651 89 \n",
"1404364639 92 \n",
"... ... \n",
"1405737938 126 \n",
"1405739346 131 \n",
"1405740223 127 \n",
"1405740855 130 \n",
"1405741402 135 \n",
"\n",
"[684 rows x 7 columns]"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"OD_dict_of_series[\"粤B8HS47\"]\n",
"# Whereas we have IDs associated with multiple rows, such as this one..."
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>ptime</th>\n",
" <th>dtime</th>\n",
" <th>plon</th>\n",
" <th>plat</th>\n",
" <th>dlon</th>\n",
" <th>dlat</th>\n",
" <th>pRID</th>\n",
" <th>dRID</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1404360675</td>\n",
" <td>1404360959</td>\n",
" <td>114.250397</td>\n",
" <td>22.728767</td>\n",
" <td>114.241653</td>\n",
" <td>22.728416</td>\n",
" <td>135</td>\n",
" <td>130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1404360988</td>\n",
" <td>1404361607</td>\n",
" <td>114.242531</td>\n",
" <td>22.728468</td>\n",
" <td>114.259850</td>\n",
" <td>22.714634</td>\n",
" <td>130</td>\n",
" <td>137</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1404362214</td>\n",
" <td>1404362468</td>\n",
" <td>114.256203</td>\n",
" <td>22.722366</td>\n",
" <td>114.262848</td>\n",
" <td>22.733400</td>\n",
" <td>137</td>\n",
" <td>136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1404362651</td>\n",
" <td>1404363795</td>\n",
" <td>114.261299</td>\n",
" <td>22.733368</td>\n",
" <td>114.325951</td>\n",
" <td>22.703617</td>\n",
" <td>136</td>\n",
" <td>89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1404364639</td>\n",
" <td>1404364780</td>\n",
" <td>114.364166</td>\n",
" <td>22.747999</td>\n",
" <td>114.364151</td>\n",
" <td>22.754816</td>\n",
" <td>79</td>\n",
" <td>92</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1405737938</td>\n",
" <td>1405738498</td>\n",
" <td>114.233002</td>\n",
" <td>22.732018</td>\n",
" <td>114.239197</td>\n",
" <td>22.762266</td>\n",
" <td>127</td>\n",
" <td>126</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1405739346</td>\n",
" <td>1405740146</td>\n",
" <td>114.267082</td>\n",
" <td>22.736782</td>\n",
" <td>114.232300</td>\n",
" <td>22.712317</td>\n",
" <td>136</td>\n",
" <td>131</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1405740223</td>\n",
" <td>1405740688</td>\n",
" <td>114.234764</td>\n",
" <td>22.714684</td>\n",
" <td>114.238815</td>\n",
" <td>22.738567</td>\n",
" <td>130</td>\n",
" <td>127</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1405740855</td>\n",
" <td>1405741172</td>\n",
" <td>114.235733</td>\n",
" <td>22.732117</td>\n",
" <td>114.232353</td>\n",
" <td>22.719233</td>\n",
" <td>127</td>\n",
" <td>130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>粤B8HS47</th>\n",
" <td>1405741402</td>\n",
" <td>1405741836</td>\n",
" <td>114.235313</td>\n",
" <td>22.715017</td>\n",
" <td>114.249649</td>\n",
" <td>22.724051</td>\n",
" <td>130</td>\n",
" <td>135</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>684 rows × 8 columns</p>\n",
"</div>"
],
"text/plain": [
" ptime dtime plon plat dlon dlat \\\n",
"id \n",
"粤B8HS47 1404360675 1404360959 114.250397 22.728767 114.241653 22.728416 \n",
"粤B8HS47 1404360988 1404361607 114.242531 22.728468 114.259850 22.714634 \n",
"粤B8HS47 1404362214 1404362468 114.256203 22.722366 114.262848 22.733400 \n",
"粤B8HS47 1404362651 1404363795 114.261299 22.733368 114.325951 22.703617 \n",
"粤B8HS47 1404364639 1404364780 114.364166 22.747999 114.364151 22.754816 \n",
"... ... ... ... ... ... ... \n",
"粤B8HS47 1405737938 1405738498 114.233002 22.732018 114.239197 22.762266 \n",
"粤B8HS47 1405739346 1405740146 114.267082 22.736782 114.232300 22.712317 \n",
"粤B8HS47 1405740223 1405740688 114.234764 22.714684 114.238815 22.738567 \n",
"粤B8HS47 1405740855 1405741172 114.235733 22.732117 114.232353 22.719233 \n",
"粤B8HS47 1405741402 1405741836 114.235313 22.715017 114.249649 22.724051 \n",
"\n",
" pRID dRID \n",
"id \n",
"粤B8HS47 135 130 \n",
"粤B8HS47 130 137 \n",
"粤B8HS47 137 136 \n",
"粤B8HS47 136 89 \n",
"粤B8HS47 79 92 \n",
"... ... ... \n",
"粤B8HS47 127 126 \n",
"粤B8HS47 136 131 \n",
"粤B8HS47 130 127 \n",
"粤B8HS47 127 130 \n",
"粤B8HS47 130 135 \n",
"\n",
"[684 rows x 8 columns]"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"OD.loc[\"粤B8HS47\"]\n",
"# And this is how it looks before being modified to include ptime."
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [],
"source": [
"def _from_traffic_dataframe_get_dict_of_ids_to_dataframe(DF, time_key=\"time\"):\n",
" IDs = list(set(DF.index))\n",
" \n",
" dict_of_ids_to_dataframe = {}\n",
" \n",
" for key in IDs:\n",
" try:\n",
" dict_of_ids_to_dataframe[key] = DF.loc[key].set_index(keys=time_key)\n",
" except:\n",
" # If it doesn't work, it means the key is only associated with one entry.\n",
" # So, just don't include it.\n",
" pass\n",
" \n",
" return dict_of_ids_to_dataframe"
]
},
{
"cell_type": "code",
"execution_count": 37,
"metadata": {},
"outputs": [],
"source": [
"# Let's reprocess this dict now\n",
"OD_dict_of_series = _from_traffic_dataframe_get_dict_of_ids_to_dataframe(OD, time_key=\"ptime\")"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [],
"source": [
"import pickle"
]
},
{
"cell_type": "code",
"execution_count": 39,
"metadata": {},
"outputs": [],
"source": [
"with open(\"./data/GPS_dict-of-df.pkl\", \"wb\") as handle:\n",
" pickle.dump(GPS_dict_of_series, handle)"
]
},
{
"cell_type": "code",
"execution_count": 40,
"metadata": {},
"outputs": [],
"source": [
"with open(\"./data/OD_dict-of-df.pkl\", \"wb\") as handle:\n",
" pickle.dump(OD_dict_of_series, handle)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"# open as pickle.load(handle)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.5"
}
},
"nbformat": 4,
"nbformat_minor": 4
}