Skip to content

Instantly share code, notes, and snippets.

@rafaeldjsm

rafaeldjsm/starbuckslocations.ipynb

Created August 23, 2022 14:11
Show Gist options
  • Save rafaeldjsm/447146112b0ab0ad4c5b18c6629da531 to your computer and use it in GitHub Desktop.
Save rafaeldjsm/447146112b0ab0ad4c5b18c6629da531 to your computer and use it in GitHub Desktop.
Download ZIP
StarbucksLocations.ipynb
Display the source blob
Display the rendered blob
Raw
starbuckslocations.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "StarbucksLocations.ipynb",
"provenance": [],
"authorship_tag": "ABX9TyMFXVm/kGZIPIRk5NaLEp+7",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/rafaeldjsm/447146112b0ab0ad4c5b18c6629da531/starbuckslocations.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"id": "2MrZOpQW_GJA"
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"source": [
"df = pd.read_csv(\"https://raw.githubusercontent.com/chrismeller/StarbucksLocations/master/stores.csv\")\n",
"df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 676
},
"id": "lWZuvCrI_Jzp",
"outputId": "46cf520b-8160-4bbc-8c3c-09e7346d273e"
},
"execution_count": 2,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Id StarbucksId \\\n",
"0 1f2d204f-e773-4361-9158-0008307dbd5e 10357 \n",
"1 49455e22-49e9-461f-912c-00092386eaee 6557 \n",
"2 1316ebf8-ee4a-479d-a11d-000964af367b 1010600 \n",
"3 1b8b9007-4587-4942-bf29-000a0af78161 1014921 \n",
"4 072752df-b30b-4f3f-a9b8-000ae32f8666 14667 \n",
"... ... ... \n",
"25595 3d795b3d-5101-4bfa-8d4a-ffeac5ce30ad 1633 \n",
"25596 3ce8d70e-2eaf-4200-b6af-fff401167436 6300 \n",
"25597 f86b90e4-5423-4b6d-835f-fff87e08721c 1012298 \n",
"25598 62375258-a9f2-44fb-b98e-fff9c35670e7 1012848 \n",
"25599 e8fbdbbe-c086-44b7-a1b1-fffb38f17b1a 15585 \n",
"\n",
" Name BrandName StoreNumber PhoneNumber \\\n",
"0 Target Virginia T-847 Starbucks 76666-97597 218-741-6603 \n",
"1 PDX A 2 Starbucks 75916-104381 503-284-4008 \n",
"2 235 Bourke Street Starbucks 25294-240419 NaN \n",
"3 Oasis Al-Kharj Starbucks 27350-247327 NaN \n",
"4 Target Trumbull T-1956 Starbucks 76306-93245 203-455-0102 \n",
"... ... ... ... ... \n",
"25595 上海书城店 Starbucks 1396-140870 021-63914776 \n",
"25596 Bei Xin Starbucks 31003-102685 NaN \n",
"25597 San Ramon Valley & Crow Canyon Starbucks 25784-242224 925-421-5615 \n",
"25598 Teavana - Hillcrest Teavana 28652-250205 905-883-3832 \n",
"25599 Crenshaw & Airport, Torrance Starbucks 6849-79123 310-534-4835 \n",
"\n",
" OwnershipType Street1 Street2 \\\n",
"0 LS 1001 13th St S NaN \n",
"1 LS 7000 NE Airport Way, MB#3 NaN \n",
"2 LS 235-251 Bourke St Shops 5,6 & 10 \n",
"3 LS King Abdullah Rd Al Khuzama \n",
"4 LS 120 Hawley Ln NaN \n",
"... ... ... ... \n",
"25595 JV 黄浦区 东侧商铺 \n",
"25596 JV No. 27, Minquan Rd, Xindian Dist 1F \n",
"25597 CO 2435 San Ramon Valley Blvd Suite 7 \n",
"25598 CO 9350 Yonge St. Unit H007B \n",
"25599 CO 25348 Crenshaw Blvd. NaN \n",
"\n",
" Street3 ... CountrySubdivisionCode CountryCode PostalCode \\\n",
"0 NaN ... MN US 557923254 \n",
"1 NaN ... OR US 972181031 \n",
"2 NaN ... VIC AU 3000 \n",
"3 NaN ... 01 SA NaN \n",
"4 NaN ... CT US 066115347 \n",
"... ... ... ... ... ... \n",
"25595 福州路465号2楼 ... 31 CN 200001 \n",
"25596 NaN ... TPQ TW 231 \n",
"25597 NaN ... CA US 94583 \n",
"25598 Hillcrest ... ON CA L4C 5G5 \n",
"25599 Rolling Hills Plaza ... CA US 905056100 \n",
"\n",
" Longitude Latitude TimezoneOffset TimezoneId \\\n",
"0 -92.55 47.51 -360 Central Standard Time \n",
"1 -122.59 45.59 -480 Pacific Standard Time \n",
"2 144.97 -37.81 660 AUS Eastern Standard Time \n",
"3 47.27 24.13 180 Arab Standard Time \n",
"4 -73.15 41.23 -300 Eastern Standard Time \n",
"... ... ... ... ... \n",
"25595 121.48 31.23 480 China Standard Time \n",
"25596 121.54 24.98 480 Taipei Standard Time \n",
"25597 -121.98 37.77 -480 Pacific Standard Time \n",
"25598 -79.43 43.85 -300 Eastern Standard Time \n",
"25599 -118.33 33.79 -480 Pacific Standard Time \n",
"\n",
" TimezoneOlsonId FirstSeen \\\n",
"0 GMT-06:00 America/Chicago 12/8/2013 5:41:59 PM \n",
"1 GMT-08:00 America/Los_Angeles 12/8/2013 5:41:59 PM \n",
"2 GMT+10:00 Australia/Melbourne 10/8/2014 12:00:00 AM \n",
"3 GMT+03:00 Asia/Riyadh 6/21/2016 12:00:00 AM \n",
"4 GMT-05:00 America/New_York 12/8/2013 5:41:59 PM \n",
"... ... ... \n",
"25595 GMT+08:00 Asia/Beijing 12/8/2013 5:41:59 PM \n",
"25596 GMT+08:00 Asia/Taipei 12/8/2013 5:41:59 PM \n",
"25597 GMT-08:00 America/Los_Angeles 7/25/2015 12:00:00 AM \n",
"25598 GMT-05:00 America/Toronto 7/11/2015 12:00:00 AM \n",
"25599 GMT-08:00 America/Los_Angeles 12/8/2013 5:41:59 PM \n",
"\n",
" LastSeen \n",
"0 2/3/2017 12:00:00 AM \n",
"1 2/3/2017 12:00:00 AM \n",
"2 2/3/2017 12:00:00 AM \n",
"3 2/3/2017 12:00:00 AM \n",
"4 2/3/2017 12:00:00 AM \n",
"... ... \n",
"25595 2/3/2017 12:00:00 AM \n",
"25596 2/3/2017 12:00:00 AM \n",
"25597 2/3/2017 12:00:00 AM \n",
"25598 2/3/2017 12:00:00 AM \n",
"25599 2/3/2017 12:00:00 AM \n",
"\n",
"[25600 rows x 21 columns]"
],
"text/html": [
"\n",
" <div id=\"df-f346b9a1-9820-464f-aaad-0633aae0ac41\">\n",
" <div class=\"colab-df-container\">\n",
" <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>Id</th>\n",
" <th>StarbucksId</th>\n",
" <th>Name</th>\n",
" <th>BrandName</th>\n",
" <th>StoreNumber</th>\n",
" <th>PhoneNumber</th>\n",
" <th>OwnershipType</th>\n",
" <th>Street1</th>\n",
" <th>Street2</th>\n",
" <th>Street3</th>\n",
" <th>...</th>\n",
" <th>CountrySubdivisionCode</th>\n",
" <th>CountryCode</th>\n",
" <th>PostalCode</th>\n",
" <th>Longitude</th>\n",
" <th>Latitude</th>\n",
" <th>TimezoneOffset</th>\n",
" <th>TimezoneId</th>\n",
" <th>TimezoneOlsonId</th>\n",
" <th>FirstSeen</th>\n",
" <th>LastSeen</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1f2d204f-e773-4361-9158-0008307dbd5e</td>\n",
" <td>10357</td>\n",
" <td>Target Virginia T-847</td>\n",
" <td>Starbucks</td>\n",
" <td>76666-97597</td>\n",
" <td>218-741-6603</td>\n",
" <td>LS</td>\n",
" <td>1001 13th St S</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>MN</td>\n",
" <td>US</td>\n",
" <td>557923254</td>\n",
" <td>-92.55</td>\n",
" <td>47.51</td>\n",
" <td>-360</td>\n",
" <td>Central Standard Time</td>\n",
" <td>GMT-06:00 America/Chicago</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>49455e22-49e9-461f-912c-00092386eaee</td>\n",
" <td>6557</td>\n",
" <td>PDX A 2</td>\n",
" <td>Starbucks</td>\n",
" <td>75916-104381</td>\n",
" <td>503-284-4008</td>\n",
" <td>LS</td>\n",
" <td>7000 NE Airport Way, MB#3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>OR</td>\n",
" <td>US</td>\n",
" <td>972181031</td>\n",
" <td>-122.59</td>\n",
" <td>45.59</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1316ebf8-ee4a-479d-a11d-000964af367b</td>\n",
" <td>1010600</td>\n",
" <td>235 Bourke Street</td>\n",
" <td>Starbucks</td>\n",
" <td>25294-240419</td>\n",
" <td>NaN</td>\n",
" <td>LS</td>\n",
" <td>235-251 Bourke St</td>\n",
" <td>Shops 5,6 &amp; 10</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>VIC</td>\n",
" <td>AU</td>\n",
" <td>3000</td>\n",
" <td>144.97</td>\n",
" <td>-37.81</td>\n",
" <td>660</td>\n",
" <td>AUS Eastern Standard Time</td>\n",
" <td>GMT+10:00 Australia/Melbourne</td>\n",
" <td>10/8/2014 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1b8b9007-4587-4942-bf29-000a0af78161</td>\n",
" <td>1014921</td>\n",
" <td>Oasis Al-Kharj</td>\n",
" <td>Starbucks</td>\n",
" <td>27350-247327</td>\n",
" <td>NaN</td>\n",
" <td>LS</td>\n",
" <td>King Abdullah Rd</td>\n",
" <td>Al Khuzama</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>01</td>\n",
" <td>SA</td>\n",
" <td>NaN</td>\n",
" <td>47.27</td>\n",
" <td>24.13</td>\n",
" <td>180</td>\n",
" <td>Arab Standard Time</td>\n",
" <td>GMT+03:00 Asia/Riyadh</td>\n",
" <td>6/21/2016 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>072752df-b30b-4f3f-a9b8-000ae32f8666</td>\n",
" <td>14667</td>\n",
" <td>Target Trumbull T-1956</td>\n",
" <td>Starbucks</td>\n",
" <td>76306-93245</td>\n",
" <td>203-455-0102</td>\n",
" <td>LS</td>\n",
" <td>120 Hawley Ln</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>CT</td>\n",
" <td>US</td>\n",
" <td>066115347</td>\n",
" <td>-73.15</td>\n",
" <td>41.23</td>\n",
" <td>-300</td>\n",
" <td>Eastern Standard Time</td>\n",
" <td>GMT-05:00 America/New_York</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</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",
" <td>...</td>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25595</th>\n",
" <td>3d795b3d-5101-4bfa-8d4a-ffeac5ce30ad</td>\n",
" <td>1633</td>\n",
" <td>上海书城店</td>\n",
" <td>Starbucks</td>\n",
" <td>1396-140870</td>\n",
" <td>021-63914776</td>\n",
" <td>JV</td>\n",
" <td>黄浦区</td>\n",
" <td>东侧商铺</td>\n",
" <td>福州路465号2楼</td>\n",
" <td>...</td>\n",
" <td>31</td>\n",
" <td>CN</td>\n",
" <td>200001</td>\n",
" <td>121.48</td>\n",
" <td>31.23</td>\n",
" <td>480</td>\n",
" <td>China Standard Time</td>\n",
" <td>GMT+08:00 Asia/Beijing</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25596</th>\n",
" <td>3ce8d70e-2eaf-4200-b6af-fff401167436</td>\n",
" <td>6300</td>\n",
" <td>Bei Xin</td>\n",
" <td>Starbucks</td>\n",
" <td>31003-102685</td>\n",
" <td>NaN</td>\n",
" <td>JV</td>\n",
" <td>No. 27, Minquan Rd, Xindian Dist</td>\n",
" <td>1F</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>TPQ</td>\n",
" <td>TW</td>\n",
" <td>231</td>\n",
" <td>121.54</td>\n",
" <td>24.98</td>\n",
" <td>480</td>\n",
" <td>Taipei Standard Time</td>\n",
" <td>GMT+08:00 Asia/Taipei</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25597</th>\n",
" <td>f86b90e4-5423-4b6d-835f-fff87e08721c</td>\n",
" <td>1012298</td>\n",
" <td>San Ramon Valley &amp; Crow Canyon</td>\n",
" <td>Starbucks</td>\n",
" <td>25784-242224</td>\n",
" <td>925-421-5615</td>\n",
" <td>CO</td>\n",
" <td>2435 San Ramon Valley Blvd</td>\n",
" <td>Suite 7</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>94583</td>\n",
" <td>-121.98</td>\n",
" <td>37.77</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>7/25/2015 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25598</th>\n",
" <td>62375258-a9f2-44fb-b98e-fff9c35670e7</td>\n",
" <td>1012848</td>\n",
" <td>Teavana - Hillcrest</td>\n",
" <td>Teavana</td>\n",
" <td>28652-250205</td>\n",
" <td>905-883-3832</td>\n",
" <td>CO</td>\n",
" <td>9350 Yonge St.</td>\n",
" <td>Unit H007B</td>\n",
" <td>Hillcrest</td>\n",
" <td>...</td>\n",
" <td>ON</td>\n",
" <td>CA</td>\n",
" <td>L4C 5G5</td>\n",
" <td>-79.43</td>\n",
" <td>43.85</td>\n",
" <td>-300</td>\n",
" <td>Eastern Standard Time</td>\n",
" <td>GMT-05:00 America/Toronto</td>\n",
" <td>7/11/2015 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25599</th>\n",
" <td>e8fbdbbe-c086-44b7-a1b1-fffb38f17b1a</td>\n",
" <td>15585</td>\n",
" <td>Crenshaw &amp; Airport, Torrance</td>\n",
" <td>Starbucks</td>\n",
" <td>6849-79123</td>\n",
" <td>310-534-4835</td>\n",
" <td>CO</td>\n",
" <td>25348 Crenshaw Blvd.</td>\n",
" <td>NaN</td>\n",
" <td>Rolling Hills Plaza</td>\n",
" <td>...</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>905056100</td>\n",
" <td>-118.33</td>\n",
" <td>33.79</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>25600 rows × 21 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f346b9a1-9820-464f-aaad-0633aae0ac41')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-f346b9a1-9820-464f-aaad-0633aae0ac41 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-f346b9a1-9820-464f-aaad-0633aae0ac41');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 2
}
]
},
{
"cell_type": "code",
"source": [
"df.info()"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "ppe46AIX_dTC",
"outputId": "1c3cfbe7-41ef-4d26-9619-217837334d8f"
},
"execution_count": 3,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 25600 entries, 0 to 25599\n",
"Data columns (total 21 columns):\n",
" # Column Non-Null Count Dtype \n",
"--- ------ -------------- ----- \n",
" 0 Id 25600 non-null object \n",
" 1 StarbucksId 25600 non-null int64 \n",
" 2 Name 25600 non-null object \n",
" 3 BrandName 25600 non-null object \n",
" 4 StoreNumber 25600 non-null object \n",
" 5 PhoneNumber 18739 non-null object \n",
" 6 OwnershipType 25600 non-null object \n",
" 7 Street1 25596 non-null object \n",
" 8 Street2 8424 non-null object \n",
" 9 Street3 5732 non-null object \n",
" 10 City 25585 non-null object \n",
" 11 CountrySubdivisionCode 25600 non-null object \n",
" 12 CountryCode 25600 non-null object \n",
" 13 PostalCode 24078 non-null object \n",
" 14 Longitude 25599 non-null float64\n",
" 15 Latitude 25599 non-null float64\n",
" 16 TimezoneOffset 25600 non-null int64 \n",
" 17 TimezoneId 25600 non-null object \n",
" 18 TimezoneOlsonId 25600 non-null object \n",
" 19 FirstSeen 25600 non-null object \n",
" 20 LastSeen 25600 non-null object \n",
"dtypes: float64(2), int64(2), object(17)\n",
"memory usage: 4.1+ MB\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"df_dup = df[df.duplicated(subset=['Longitude','Latitude'],keep = False)]\n",
"df_dup"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 728
},
"id": "W3WjKiGU_-2Y",
"outputId": "44ec34b4-b60f-4bcb-804f-c77aa21a7f22"
},
"execution_count": 5,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Id StarbucksId \\\n",
"1 49455e22-49e9-461f-912c-00092386eaee 6557 \n",
"2 1316ebf8-ee4a-479d-a11d-000964af367b 1010600 \n",
"6 c247cc83-e908-4046-a9e1-000de0f73ea5 1015467 \n",
"7 884bab44-49a6-44d0-90c5-000de92ea468 1011138 \n",
"9 6fa04317-ac80-43a9-af0b-00120e4c3d12 15661 \n",
"... ... ... \n",
"25591 7fdd485e-7f78-425a-8bb7-ffdd5e675cab 89136 \n",
"25592 e0977fc3-b7ec-4288-8cc8-ffe1b18a9bb4 908 \n",
"25595 3d795b3d-5101-4bfa-8d4a-ffeac5ce30ad 1633 \n",
"25596 3ce8d70e-2eaf-4200-b6af-fff401167436 6300 \n",
"25597 f86b90e4-5423-4b6d-835f-fff87e08721c 1012298 \n",
"\n",
" Name BrandName StoreNumber \\\n",
"1 PDX A 2 Starbucks 75916-104381 \n",
"2 235 Bourke Street Starbucks 25294-240419 \n",
"6 SEC Lincoln & Yosemite - Lone Tree Starbucks 27851-193845 \n",
"7 汇暻生活广场店 Starbucks 24754-238132 \n",
"9 Sunvalley Mall - Concord Starbucks 6505-55539 \n",
"... ... ... ... \n",
"25591 Starbucks Fashion Starbucks 17057-179045 \n",
"25592 Crowfoot Village Starbucks 4769-103376 \n",
"25595 上海书城店 Starbucks 1396-140870 \n",
"25596 Bei Xin Starbucks 31003-102685 \n",
"25597 San Ramon Valley & Crow Canyon Starbucks 25784-242224 \n",
"\n",
" PhoneNumber OwnershipType Street1 \\\n",
"1 503-284-4008 LS 7000 NE Airport Way, MB#3 \n",
"2 NaN LS 235-251 Bourke St \n",
"6 (720) 467-4703 CO 9998 Commons St. \n",
"7 NaN JV 黄浦区 \n",
"9 925-680-2571 CO 1 Sunvalley Mall \n",
"... ... ... ... \n",
"25591 36706821908 JV Deák Ferenc utca 23 \n",
"25592 403 241-2640 CO 20 Crowfoot Crescent NW \n",
"25595 021-63914776 JV 黄浦区 \n",
"25596 NaN JV No. 27, Minquan Rd, Xindian Dist \n",
"25597 925-421-5615 CO 2435 San Ramon Valley Blvd \n",
"\n",
" Street2 Street3 ... CountrySubdivisionCode \\\n",
"1 NaN NaN ... OR \n",
"2 Shops 5,6 & 10 NaN ... VIC \n",
"6 NaN NaN ... CO \n",
"7 汇暻生活广场 鲁班路615号102-103室 ... 31 \n",
"9 D 115 Sunvalley Mall ... CA \n",
"... ... ... ... ... \n",
"25591 NaN NaN ... BU \n",
"25592 100 Crowfoot Village ... AB \n",
"25595 东侧商铺 福州路465号2楼 ... 31 \n",
"25596 1F NaN ... TPQ \n",
"25597 Suite 7 NaN ... CA \n",
"\n",
" CountryCode PostalCode Longitude Latitude TimezoneOffset \\\n",
"1 US 972181031 -122.59 45.59 -480 \n",
"2 AU 3000 144.97 -37.81 660 \n",
"6 US 80124 -104.88 39.54 -420 \n",
"7 CN NaN 121.48 31.20 480 \n",
"9 US 945205801 -122.06 37.97 -480 \n",
"... ... ... ... ... ... \n",
"25591 HU 1052 19.05 47.50 60 \n",
"25592 CA T3G 2P6 -114.20 51.13 -420 \n",
"25595 CN 200001 121.48 31.23 480 \n",
"25596 TW 231 121.54 24.98 480 \n",
"25597 US 94583 -121.98 37.77 -480 \n",
"\n",
" TimezoneId TimezoneOlsonId \\\n",
"1 Pacific Standard Time GMT-08:00 America/Los_Angeles \n",
"2 AUS Eastern Standard Time GMT+10:00 Australia/Melbourne \n",
"6 Mountain Standard Time GMT-07:00 America/Denver \n",
"7 China Standard Time GMT+08:00 Asia/Beijing \n",
"9 Pacific Standard Time GMT-08:00 America/Los_Angeles \n",
"... ... ... \n",
"25591 Central Europe Standard Time GMT+1:00 Europe/Budapest \n",
"25592 Mountain Standard Time GMT-07:00 America/Edmonton \n",
"25595 China Standard Time GMT+08:00 Asia/Beijing \n",
"25596 Taipei Standard Time GMT+08:00 Asia/Taipei \n",
"25597 Pacific Standard Time GMT-08:00 America/Los_Angeles \n",
"\n",
" FirstSeen LastSeen \n",
"1 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"2 10/8/2014 12:00:00 AM 2/3/2017 12:00:00 AM \n",
"6 8/16/2016 12:00:00 AM 2/3/2017 12:00:00 AM \n",
"7 12/27/2014 12:00:00 AM 2/3/2017 12:00:00 AM \n",
"9 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"... ... ... \n",
"25591 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"25592 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"25595 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"25596 12/8/2013 5:41:59 PM 2/3/2017 12:00:00 AM \n",
"25597 7/25/2015 12:00:00 AM 2/3/2017 12:00:00 AM \n",
"\n",
"[9400 rows x 21 columns]"
],
"text/html": [
"\n",
" <div id=\"df-8fb9f506-c9b2-450f-8dcb-1341e93f4e28\">\n",
" <div class=\"colab-df-container\">\n",
" <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>Id</th>\n",
" <th>StarbucksId</th>\n",
" <th>Name</th>\n",
" <th>BrandName</th>\n",
" <th>StoreNumber</th>\n",
" <th>PhoneNumber</th>\n",
" <th>OwnershipType</th>\n",
" <th>Street1</th>\n",
" <th>Street2</th>\n",
" <th>Street3</th>\n",
" <th>...</th>\n",
" <th>CountrySubdivisionCode</th>\n",
" <th>CountryCode</th>\n",
" <th>PostalCode</th>\n",
" <th>Longitude</th>\n",
" <th>Latitude</th>\n",
" <th>TimezoneOffset</th>\n",
" <th>TimezoneId</th>\n",
" <th>TimezoneOlsonId</th>\n",
" <th>FirstSeen</th>\n",
" <th>LastSeen</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>49455e22-49e9-461f-912c-00092386eaee</td>\n",
" <td>6557</td>\n",
" <td>PDX A 2</td>\n",
" <td>Starbucks</td>\n",
" <td>75916-104381</td>\n",
" <td>503-284-4008</td>\n",
" <td>LS</td>\n",
" <td>7000 NE Airport Way, MB#3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>OR</td>\n",
" <td>US</td>\n",
" <td>972181031</td>\n",
" <td>-122.59</td>\n",
" <td>45.59</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1316ebf8-ee4a-479d-a11d-000964af367b</td>\n",
" <td>1010600</td>\n",
" <td>235 Bourke Street</td>\n",
" <td>Starbucks</td>\n",
" <td>25294-240419</td>\n",
" <td>NaN</td>\n",
" <td>LS</td>\n",
" <td>235-251 Bourke St</td>\n",
" <td>Shops 5,6 &amp; 10</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>VIC</td>\n",
" <td>AU</td>\n",
" <td>3000</td>\n",
" <td>144.97</td>\n",
" <td>-37.81</td>\n",
" <td>660</td>\n",
" <td>AUS Eastern Standard Time</td>\n",
" <td>GMT+10:00 Australia/Melbourne</td>\n",
" <td>10/8/2014 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>c247cc83-e908-4046-a9e1-000de0f73ea5</td>\n",
" <td>1015467</td>\n",
" <td>SEC Lincoln &amp; Yosemite - Lone Tree</td>\n",
" <td>Starbucks</td>\n",
" <td>27851-193845</td>\n",
" <td>(720) 467-4703</td>\n",
" <td>CO</td>\n",
" <td>9998 Commons St.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80124</td>\n",
" <td>-104.88</td>\n",
" <td>39.54</td>\n",
" <td>-420</td>\n",
" <td>Mountain Standard Time</td>\n",
" <td>GMT-07:00 America/Denver</td>\n",
" <td>8/16/2016 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>884bab44-49a6-44d0-90c5-000de92ea468</td>\n",
" <td>1011138</td>\n",
" <td>汇暻生活广场店</td>\n",
" <td>Starbucks</td>\n",
" <td>24754-238132</td>\n",
" <td>NaN</td>\n",
" <td>JV</td>\n",
" <td>黄浦区</td>\n",
" <td>汇暻生活广场</td>\n",
" <td>鲁班路615号102-103室</td>\n",
" <td>...</td>\n",
" <td>31</td>\n",
" <td>CN</td>\n",
" <td>NaN</td>\n",
" <td>121.48</td>\n",
" <td>31.20</td>\n",
" <td>480</td>\n",
" <td>China Standard Time</td>\n",
" <td>GMT+08:00 Asia/Beijing</td>\n",
" <td>12/27/2014 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>6fa04317-ac80-43a9-af0b-00120e4c3d12</td>\n",
" <td>15661</td>\n",
" <td>Sunvalley Mall - Concord</td>\n",
" <td>Starbucks</td>\n",
" <td>6505-55539</td>\n",
" <td>925-680-2571</td>\n",
" <td>CO</td>\n",
" <td>1 Sunvalley Mall</td>\n",
" <td>D 115</td>\n",
" <td>Sunvalley Mall</td>\n",
" <td>...</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>945205801</td>\n",
" <td>-122.06</td>\n",
" <td>37.97</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</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",
" <td>...</td>\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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25591</th>\n",
" <td>7fdd485e-7f78-425a-8bb7-ffdd5e675cab</td>\n",
" <td>89136</td>\n",
" <td>Starbucks Fashion</td>\n",
" <td>Starbucks</td>\n",
" <td>17057-179045</td>\n",
" <td>36706821908</td>\n",
" <td>JV</td>\n",
" <td>Deák Ferenc utca 23</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>BU</td>\n",
" <td>HU</td>\n",
" <td>1052</td>\n",
" <td>19.05</td>\n",
" <td>47.50</td>\n",
" <td>60</td>\n",
" <td>Central Europe Standard Time</td>\n",
" <td>GMT+1:00 Europe/Budapest</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25592</th>\n",
" <td>e0977fc3-b7ec-4288-8cc8-ffe1b18a9bb4</td>\n",
" <td>908</td>\n",
" <td>Crowfoot Village</td>\n",
" <td>Starbucks</td>\n",
" <td>4769-103376</td>\n",
" <td>403 241-2640</td>\n",
" <td>CO</td>\n",
" <td>20 Crowfoot Crescent NW</td>\n",
" <td>100</td>\n",
" <td>Crowfoot Village</td>\n",
" <td>...</td>\n",
" <td>AB</td>\n",
" <td>CA</td>\n",
" <td>T3G 2P6</td>\n",
" <td>-114.20</td>\n",
" <td>51.13</td>\n",
" <td>-420</td>\n",
" <td>Mountain Standard Time</td>\n",
" <td>GMT-07:00 America/Edmonton</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25595</th>\n",
" <td>3d795b3d-5101-4bfa-8d4a-ffeac5ce30ad</td>\n",
" <td>1633</td>\n",
" <td>上海书城店</td>\n",
" <td>Starbucks</td>\n",
" <td>1396-140870</td>\n",
" <td>021-63914776</td>\n",
" <td>JV</td>\n",
" <td>黄浦区</td>\n",
" <td>东侧商铺</td>\n",
" <td>福州路465号2楼</td>\n",
" <td>...</td>\n",
" <td>31</td>\n",
" <td>CN</td>\n",
" <td>200001</td>\n",
" <td>121.48</td>\n",
" <td>31.23</td>\n",
" <td>480</td>\n",
" <td>China Standard Time</td>\n",
" <td>GMT+08:00 Asia/Beijing</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25596</th>\n",
" <td>3ce8d70e-2eaf-4200-b6af-fff401167436</td>\n",
" <td>6300</td>\n",
" <td>Bei Xin</td>\n",
" <td>Starbucks</td>\n",
" <td>31003-102685</td>\n",
" <td>NaN</td>\n",
" <td>JV</td>\n",
" <td>No. 27, Minquan Rd, Xindian Dist</td>\n",
" <td>1F</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>TPQ</td>\n",
" <td>TW</td>\n",
" <td>231</td>\n",
" <td>121.54</td>\n",
" <td>24.98</td>\n",
" <td>480</td>\n",
" <td>Taipei Standard Time</td>\n",
" <td>GMT+08:00 Asia/Taipei</td>\n",
" <td>12/8/2013 5:41:59 PM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25597</th>\n",
" <td>f86b90e4-5423-4b6d-835f-fff87e08721c</td>\n",
" <td>1012298</td>\n",
" <td>San Ramon Valley &amp; Crow Canyon</td>\n",
" <td>Starbucks</td>\n",
" <td>25784-242224</td>\n",
" <td>925-421-5615</td>\n",
" <td>CO</td>\n",
" <td>2435 San Ramon Valley Blvd</td>\n",
" <td>Suite 7</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>CA</td>\n",
" <td>US</td>\n",
" <td>94583</td>\n",
" <td>-121.98</td>\n",
" <td>37.77</td>\n",
" <td>-480</td>\n",
" <td>Pacific Standard Time</td>\n",
" <td>GMT-08:00 America/Los_Angeles</td>\n",
" <td>7/25/2015 12:00:00 AM</td>\n",
" <td>2/3/2017 12:00:00 AM</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>9400 rows × 21 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8fb9f506-c9b2-450f-8dcb-1341e93f4e28')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-8fb9f506-c9b2-450f-8dcb-1341e93f4e28 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-8fb9f506-c9b2-450f-8dcb-1341e93f4e28');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 5
}
]
},
{
"cell_type": "code",
"source": [
"dupdf1 = df_dup[['StarbucksId', 'Name', 'BrandName', 'StoreNumber', 'OwnershipType', 'Street1', 'Street2', 'Street3', 'City', 'CountrySubdivisionCode', 'CountryCode', 'PostalCode', 'Longitude','Latitude']].sort_values(by=['Longitude','Latitude'])\n",
"dupdf1"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 424
},
"id": "lYZmgXdq_poZ",
"outputId": "3fc58419-df20-4c65-d4a8-640efb2639ff"
},
"execution_count": 6,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" StarbucksId Name BrandName StoreNumber \\\n",
"5023 1007453 Safeway-Lihue #2894 Starbucks 17900-175567 \n",
"13569 13923 Kukui Grove Center Starbucks 21041-88460 \n",
"6489 10862 Target Oahu Kapolei T-2411 Starbucks 76999-131728 \n",
"7025 10295 Kapolei Pkwy & Kamokila Blvd Starbucks 21062-99872 \n",
"20092 116441 Keaunui & Ft Weaver Starbucks 18818-161204 \n",
"... ... ... ... ... \n",
"2801 1010595 Queen Victoria Building Starbucks 25290-240408 \n",
"3424 1010593 Wynyard Green Starbucks 25296-240405 \n",
"14727 1010587 Hyde park Starbucks 25276-240390 \n",
"670 5270 Symonds Street Starbucks 31375-106771 \n",
"10560 5251 220 Queen Street Starbucks 33824-51680 \n",
"\n",
" OwnershipType Street1 \\\n",
"5023 LS 4454 Nuhou St \n",
"13569 CO 3-2600 Kaumualii Highway \n",
"6489 LS 4450 Kapolei Pkwy \n",
"7025 CO 338 Kamokila Boulevard #108 \n",
"20092 CO 91-1105 Keaunui Drive \n",
"... ... ... \n",
"2801 LS 455 George Street \n",
"3424 LS 11-17 York St \n",
"14727 LS 201 Elizabeth Street \n",
"670 LS 37 Symonds Street Unit G01 \n",
"10560 LS 220 Queen Street \n",
"\n",
" Street2 Street3 City \\\n",
"5023 NaN NaN Lihue \n",
"13569 1800 NaN Lihue \n",
"6489 NaN NaN Kapolei \n",
"7025 NaN NaN Kapolei \n",
"20092 #500 Laulani Village Ewa Beach \n",
"... ... ... ... \n",
"2801 Tenancy 69, Lower Ground Floor NaN Sydney \n",
"3424 Shop 1 NaN Sydney \n",
"14727 NaN NaN Sydney \n",
"670 CBD NaN Auckland \n",
"10560 NaN NaN Auckland \n",
"\n",
" CountrySubdivisionCode CountryCode PostalCode Longitude Latitude \n",
"5023 HI US 96766 -159.38 21.97 \n",
"13569 HI US 967661683 -159.38 21.97 \n",
"6489 HI US 967071889 -158.09 21.33 \n",
"7025 HI US 967072055 -158.09 21.33 \n",
"20092 HI US 967066363 -158.02 21.33 \n",
"... ... ... ... ... ... \n",
"2801 NSW AU 2000 151.21 -33.87 \n",
"3424 NSW AU 2000 151.21 -33.87 \n",
"14727 NSW AU 2000 151.21 -33.87 \n",
"670 N NZ NaN 174.77 -36.85 \n",
"10560 N NZ NaN 174.77 -36.85 \n",
"\n",
"[9400 rows x 14 columns]"
],
"text/html": [
"\n",
" <div id=\"df-73c633b2-7f45-4a35-9336-02f60ef8de59\">\n",
" <div class=\"colab-df-container\">\n",
" <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>StarbucksId</th>\n",
" <th>Name</th>\n",
" <th>BrandName</th>\n",
" <th>StoreNumber</th>\n",
" <th>OwnershipType</th>\n",
" <th>Street1</th>\n",
" <th>Street2</th>\n",
" <th>Street3</th>\n",
" <th>City</th>\n",
" <th>CountrySubdivisionCode</th>\n",
" <th>CountryCode</th>\n",
" <th>PostalCode</th>\n",
" <th>Longitude</th>\n",
" <th>Latitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5023</th>\n",
" <td>1007453</td>\n",
" <td>Safeway-Lihue #2894</td>\n",
" <td>Starbucks</td>\n",
" <td>17900-175567</td>\n",
" <td>LS</td>\n",
" <td>4454 Nuhou St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Lihue</td>\n",
" <td>HI</td>\n",
" <td>US</td>\n",
" <td>96766</td>\n",
" <td>-159.38</td>\n",
" <td>21.97</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13569</th>\n",
" <td>13923</td>\n",
" <td>Kukui Grove Center</td>\n",
" <td>Starbucks</td>\n",
" <td>21041-88460</td>\n",
" <td>CO</td>\n",
" <td>3-2600 Kaumualii Highway</td>\n",
" <td>1800</td>\n",
" <td>NaN</td>\n",
" <td>Lihue</td>\n",
" <td>HI</td>\n",
" <td>US</td>\n",
" <td>967661683</td>\n",
" <td>-159.38</td>\n",
" <td>21.97</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6489</th>\n",
" <td>10862</td>\n",
" <td>Target Oahu Kapolei T-2411</td>\n",
" <td>Starbucks</td>\n",
" <td>76999-131728</td>\n",
" <td>LS</td>\n",
" <td>4450 Kapolei Pkwy</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kapolei</td>\n",
" <td>HI</td>\n",
" <td>US</td>\n",
" <td>967071889</td>\n",
" <td>-158.09</td>\n",
" <td>21.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7025</th>\n",
" <td>10295</td>\n",
" <td>Kapolei Pkwy &amp; Kamokila Blvd</td>\n",
" <td>Starbucks</td>\n",
" <td>21062-99872</td>\n",
" <td>CO</td>\n",
" <td>338 Kamokila Boulevard #108</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kapolei</td>\n",
" <td>HI</td>\n",
" <td>US</td>\n",
" <td>967072055</td>\n",
" <td>-158.09</td>\n",
" <td>21.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20092</th>\n",
" <td>116441</td>\n",
" <td>Keaunui &amp; Ft Weaver</td>\n",
" <td>Starbucks</td>\n",
" <td>18818-161204</td>\n",
" <td>CO</td>\n",
" <td>91-1105 Keaunui Drive</td>\n",
" <td>#500</td>\n",
" <td>Laulani Village</td>\n",
" <td>Ewa Beach</td>\n",
" <td>HI</td>\n",
" <td>US</td>\n",
" <td>967066363</td>\n",
" <td>-158.02</td>\n",
" <td>21.33</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",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2801</th>\n",
" <td>1010595</td>\n",
" <td>Queen Victoria Building</td>\n",
" <td>Starbucks</td>\n",
" <td>25290-240408</td>\n",
" <td>LS</td>\n",
" <td>455 George Street</td>\n",
" <td>Tenancy 69, Lower Ground Floor</td>\n",
" <td>NaN</td>\n",
" <td>Sydney</td>\n",
" <td>NSW</td>\n",
" <td>AU</td>\n",
" <td>2000</td>\n",
" <td>151.21</td>\n",
" <td>-33.87</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3424</th>\n",
" <td>1010593</td>\n",
" <td>Wynyard Green</td>\n",
" <td>Starbucks</td>\n",
" <td>25296-240405</td>\n",
" <td>LS</td>\n",
" <td>11-17 York St</td>\n",
" <td>Shop 1</td>\n",
" <td>NaN</td>\n",
" <td>Sydney</td>\n",
" <td>NSW</td>\n",
" <td>AU</td>\n",
" <td>2000</td>\n",
" <td>151.21</td>\n",
" <td>-33.87</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14727</th>\n",
" <td>1010587</td>\n",
" <td>Hyde park</td>\n",
" <td>Starbucks</td>\n",
" <td>25276-240390</td>\n",
" <td>LS</td>\n",
" <td>201 Elizabeth Street</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Sydney</td>\n",
" <td>NSW</td>\n",
" <td>AU</td>\n",
" <td>2000</td>\n",
" <td>151.21</td>\n",
" <td>-33.87</td>\n",
" </tr>\n",
" <tr>\n",
" <th>670</th>\n",
" <td>5270</td>\n",
" <td>Symonds Street</td>\n",
" <td>Starbucks</td>\n",
" <td>31375-106771</td>\n",
" <td>LS</td>\n",
" <td>37 Symonds Street Unit G01</td>\n",
" <td>CBD</td>\n",
" <td>NaN</td>\n",
" <td>Auckland</td>\n",
" <td>N</td>\n",
" <td>NZ</td>\n",
" <td>NaN</td>\n",
" <td>174.77</td>\n",
" <td>-36.85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10560</th>\n",
" <td>5251</td>\n",
" <td>220 Queen Street</td>\n",
" <td>Starbucks</td>\n",
" <td>33824-51680</td>\n",
" <td>LS</td>\n",
" <td>220 Queen Street</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Auckland</td>\n",
" <td>N</td>\n",
" <td>NZ</td>\n",
" <td>NaN</td>\n",
" <td>174.77</td>\n",
" <td>-36.85</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>9400 rows × 14 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-73c633b2-7f45-4a35-9336-02f60ef8de59')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-73c633b2-7f45-4a35-9336-02f60ef8de59 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-73c633b2-7f45-4a35-9336-02f60ef8de59');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 6
}
]
},
{
"cell_type": "code",
"source": [
"dupdf_denver = dupdf1[dupdf1['City'].str.lower() == 'denver']\n",
"dupdf_denver"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
},
"id": "c0Lr8GzkBLEQ",
"outputId": "a352540f-aa7a-4879-8899-818a7224d3aa"
},
"execution_count": 7,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" StarbucksId Name BrandName \\\n",
"1987 17736 Highlands Garden Village Starbucks \n",
"1911 1007314 Safeway - Denver #1248 Starbucks \n",
"10654 8472 Speer & Federal - Denver Starbucks \n",
"2034 1005520 Hampden & Santa Fe, Sheridan Starbucks \n",
"11101 11222 Colfax & Kalamath Starbucks \n",
"14205 7445 King Soopers - Denver #1 Starbucks \n",
"16450 91316 14th & Speer, Denver Starbucks \n",
"6457 12186 Writer Square Starbucks \n",
"14381 18413 Larimer Square Starbucks \n",
"16740 14867 16th St. & Blake Starbucks \n",
"17419 1007338 1900 Sixteenth St. Starbucks \n",
"24322 6919 The Curtis Hotel Lobby Starbucks \n",
"17580 11111 Safeway - Denver #885 Starbucks \n",
"22402 7168 Alameda & Broadway- Denver Starbucks \n",
"4363 11609 UMB Bank Plaza Starbucks \n",
"4973 20098 Embassy Suites Denver Downtown Conv Starbucks \n",
"14063 14601 Atrium @ 1700 Broadway Starbucks \n",
"17309 15921 16th & Tremont Starbucks \n",
"1452 1007646 Grand Hyatt Denver Starbucks \n",
"9366 15626 18th & California Starbucks \n",
"11555 1012255 17th and Lawrence Starbucks \n",
"16961 13338 16th Street & Curtis Starbucks \n",
"18275 16611 18th & Champa Starbucks \n",
"21394 10313 16th & California- Denver Starbucks \n",
"23117 15621 Denver Marriott CC - Lobby Starbucks \n",
"1701 13301 Safeway - Denver #1463 Starbucks \n",
"22515 7887 Franklin & Evans-Denver Starbucks \n",
"2011 15744 King Soopers-Denver #29 Starbucks \n",
"14810 12391 Safeway-Denver #1614 Starbucks \n",
"8119 18414 2nd Ave and Filmore - Cherry Creek Starbucks \n",
"8833 1012787 Teavana - Cherry Creek Teavana \n",
"17504 15126 Safeway-Denver #100 Starbucks \n",
"19808 10432 Cherry Creek Mall - West. Starbucks \n",
"4787 7958 King Soopers - Denver #72 Starbucks \n",
"11049 16586 University Hills Starbucks \n",
"7078 16192 Safeway-Denver #1038 Starbucks \n",
"16809 14304 Colorado & Arizona Starbucks \n",
"15516 9733 Colfax & Krameria Starbucks \n",
"22565 15632 Safeway-Denver #2714 Starbucks \n",
"4674 7184 Lowry Town Center - Denver Starbucks \n",
"15638 17644 Safeway - Denver #3836 Starbucks \n",
"7657 87559 King Soopers-Denver #93 Starbucks \n",
"24347 16735 Stapleton TC-29th & Quebec Starbucks \n",
"13061 17982 DEN B RJ Term South Finger Lower Starbucks \n",
"21204 18118 DEN B RJ Term South Finger Upper Starbucks \n",
"\n",
" StoreNumber OwnershipType Street1 Street2 \\\n",
"1987 11105-100844 CO 4500 W 38th Ave NaN \n",
"1911 22871-102491 LS 2660 Federal Blvd NaN \n",
"10654 10019-98985 CO 2990 North Speer Blvd Unit 1 \n",
"2034 19695-165566 CO 3500 A River Point Parkway NaN \n",
"11101 6822-82361 CO 1050 W Colfax Ave NaN \n",
"14205 73787-111045 LS 1331 N Speer Blvd NaN \n",
"16450 17562-165406 CO 1410 Speer Blvd NaN \n",
"6457 6657-73731 CO 1512 Larimer Street NaN \n",
"14381 248-135 CO 1406 Larimer St NaN \n",
"16740 5803-15714 CO 1490 16th Street NaN \n",
"17419 22162-218186 CO 1900 Sixteenth St. 100 \n",
"24322 78024-107376 LS 1405 Curtis St NaN \n",
"17580 73165-21582 LS 323 S Broadway NaN \n",
"22402 10351-99161 CO 381 S Broadway NaN \n",
"4363 6205-30 CO 1670 Broadway NaN \n",
"4973 15466-156825 LS 1420 Stout St NaN \n",
"14063 75324-95897 LS 1700 Broadway NaN \n",
"17309 5640-2442 CO 303 16th Street Ste. 100 \n",
"1452 75828-94910 LS 1740 Welton St NaN \n",
"9366 6381-25487 CO 633 17th St 110 \n",
"11555 24838-238076 CO 1125 17th Street NaN \n",
"16961 5392-873 CO 934 Sixteenth Street NaN \n",
"18275 6697-73722 CO 999 18th Street 113 \n",
"21394 10673-100271 CO 700 16th St. Suite A \n",
"23117 75506-33861 LS 1701 California Street NaN \n",
"1701 74105-23807 LS 2150 S Downing NaN \n",
"22515 10261-100356 CO 1605 E Evans Ave NaN \n",
"2011 75003-33060 LS 1155 E. 9th Ave. NaN \n",
"14810 74125-25289 LS 560 Corona St. NaN \n",
"8119 253-136 CO 200 Fillmore Street NaN \n",
"8833 28591-249796 CO 3000 E. 1ST STREET #264 \n",
"17504 74178-32999 LS 3110 E 1st Ave NaN \n",
"19808 10861-103209 CO 3000 1st Ave. NaN \n",
"4787 79292-99564 LS 2750 S Colorado Blvd NaN \n",
"11049 5434-872 CO 2700 S. Colorado Blvd. NaN \n",
"7078 74254-65021 LS 1653 S Colorado Blvd NaN \n",
"16809 8916-95345 CO 1233 S. Colorado Blvd NaN \n",
"15516 8115-95975 CO 6160 E. Colfax Ave Unit 1 \n",
"22565 74705-96758 LS 6220 E 14th St NaN \n",
"4674 10862-103208 CO 200 Quebec St. NaN \n",
"15638 73566-81441 LS 200 Quebec St #400 \n",
"7657 16946-106016 LS 2810 Quebec St. NaN \n",
"24347 2817-86203 CO 7304 E. 29th Ave NaN \n",
"13061 75960-108269 LS HMSHost 8500 Pena Blvd NaN \n",
"21204 75959-108270 LS HMSHost 8500 Pena Blvd. NaN \n",
"\n",
" Street3 City CountrySubdivisionCode CountryCode \\\n",
"1987 NaN Denver CO US \n",
"1911 NaN Denver CO US \n",
"10654 NaN Denver CO US \n",
"2034 NaN Denver CO US \n",
"11101 Plaza Zocalo Denver CO US \n",
"14205 NaN Denver CO US \n",
"16450 NaN Denver CO US \n",
"6457 Writer's Square Denver CO US \n",
"14381 NaN Denver CO US \n",
"16740 16 Market Square Denver CO US \n",
"17419 NaN Denver CO US \n",
"24322 NaN Denver CO US \n",
"17580 NaN Denver CO US \n",
"22402 NaN Denver CO US \n",
"4363 NaN Denver CO US \n",
"4973 NaN Denver CO US \n",
"14063 NaN Denver CO US \n",
"17309 NaN Denver CO US \n",
"1452 NaN Denver CO US \n",
"9366 NaN Denver CO US \n",
"11555 NaN Denver CO US \n",
"16961 16th & Curtis Denver CO US \n",
"18275 Denver Place Mall Denver CO US \n",
"21394 NaN Denver CO US \n",
"23117 Denver Marriott City Center Denver CO US \n",
"1701 NaN Denver CO US \n",
"22515 NaN Denver CO US \n",
"2011 Capitol Hill Center Denver CO US \n",
"14810 NaN Denver CO US \n",
"8119 NaN Denver CO US \n",
"8833 Cherry Creek DENVER CO US \n",
"17504 NaN Denver CO US \n",
"19808 NaN Denver CO US \n",
"4787 NaN Denver CO US \n",
"11049 University Hills Mall Denver CO US \n",
"7078 NaN Denver CO US \n",
"16809 NaN Denver CO US \n",
"15516 NaN Denver CO US \n",
"22565 NaN Denver CO US \n",
"4674 NaN Denver CO US \n",
"15638 NaN Denver CO US \n",
"7657 NaN Denver CO US \n",
"24347 NaN Denver CO US \n",
"13061 NaN Denver CO US \n",
"21204 NaN Denver CO US \n",
"\n",
" PostalCode Longitude Latitude \n",
"1987 802122001 -105.05 39.77 \n",
"1911 80211 -105.02 39.76 \n",
"10654 802114252 -105.02 39.76 \n",
"2034 80110 -105.01 39.65 \n",
"11101 802042072 -105.00 39.74 \n",
"14205 80204 -105.00 39.74 \n",
"16450 80204 -105.00 39.74 \n",
"6457 802021610 -105.00 39.75 \n",
"14381 802021705 -105.00 39.75 \n",
"16740 802021320 -105.00 39.75 \n",
"17419 80202 -105.00 39.75 \n",
"24322 802022349 -105.00 39.75 \n",
"17580 802091511 -104.99 39.71 \n",
"22402 802091522 -104.99 39.71 \n",
"4363 802024801 -104.99 39.74 \n",
"4973 802023201 -104.99 39.74 \n",
"14063 802901700 -104.99 39.74 \n",
"17309 802025657 -104.99 39.74 \n",
"1452 802023940 -104.99 39.75 \n",
"9366 802023616 -104.99 39.75 \n",
"11555 80202 -104.99 39.75 \n",
"16961 802022902 -104.99 39.75 \n",
"18275 802022499 -104.99 39.75 \n",
"21394 802023229 -104.99 39.75 \n",
"23117 802023402 -104.99 39.75 \n",
"1701 802104528 -104.97 39.68 \n",
"22515 802104608 -104.97 39.68 \n",
"2011 802184802 -104.97 39.73 \n",
"14810 802183436 -104.97 39.73 \n",
"8119 802065028 -104.95 39.72 \n",
"8833 80206 -104.95 39.72 \n",
"17504 802065614 -104.95 39.72 \n",
"19808 802065638 -104.95 39.72 \n",
"4787 802226602 -104.94 39.67 \n",
"11049 802103506 -104.94 39.67 \n",
"7078 802201055 -104.94 39.69 \n",
"16809 802462902 -104.94 39.69 \n",
"15516 802201569 -104.92 39.74 \n",
"22565 802202747 -104.92 39.74 \n",
"4674 802307144 -104.90 39.72 \n",
"15638 802307145 -104.90 39.72 \n",
"7657 802072900 -104.90 39.76 \n",
"24347 802382699 -104.90 39.76 \n",
"13061 80249 -104.67 39.86 \n",
"21204 80249 -104.67 39.86 "
],
"text/html": [
"\n",
" <div id=\"df-c9f0c7be-9788-4a7d-b7f1-2c46343f7a89\">\n",
" <div class=\"colab-df-container\">\n",
" <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>StarbucksId</th>\n",
" <th>Name</th>\n",
" <th>BrandName</th>\n",
" <th>StoreNumber</th>\n",
" <th>OwnershipType</th>\n",
" <th>Street1</th>\n",
" <th>Street2</th>\n",
" <th>Street3</th>\n",
" <th>City</th>\n",
" <th>CountrySubdivisionCode</th>\n",
" <th>CountryCode</th>\n",
" <th>PostalCode</th>\n",
" <th>Longitude</th>\n",
" <th>Latitude</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>1987</th>\n",
" <td>17736</td>\n",
" <td>Highlands Garden Village</td>\n",
" <td>Starbucks</td>\n",
" <td>11105-100844</td>\n",
" <td>CO</td>\n",
" <td>4500 W 38th Ave</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802122001</td>\n",
" <td>-105.05</td>\n",
" <td>39.77</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1911</th>\n",
" <td>1007314</td>\n",
" <td>Safeway - Denver #1248</td>\n",
" <td>Starbucks</td>\n",
" <td>22871-102491</td>\n",
" <td>LS</td>\n",
" <td>2660 Federal Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80211</td>\n",
" <td>-105.02</td>\n",
" <td>39.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10654</th>\n",
" <td>8472</td>\n",
" <td>Speer &amp; Federal - Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>10019-98985</td>\n",
" <td>CO</td>\n",
" <td>2990 North Speer Blvd</td>\n",
" <td>Unit 1</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802114252</td>\n",
" <td>-105.02</td>\n",
" <td>39.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2034</th>\n",
" <td>1005520</td>\n",
" <td>Hampden &amp; Santa Fe, Sheridan</td>\n",
" <td>Starbucks</td>\n",
" <td>19695-165566</td>\n",
" <td>CO</td>\n",
" <td>3500 A River Point Parkway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80110</td>\n",
" <td>-105.01</td>\n",
" <td>39.65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11101</th>\n",
" <td>11222</td>\n",
" <td>Colfax &amp; Kalamath</td>\n",
" <td>Starbucks</td>\n",
" <td>6822-82361</td>\n",
" <td>CO</td>\n",
" <td>1050 W Colfax Ave</td>\n",
" <td>NaN</td>\n",
" <td>Plaza Zocalo</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802042072</td>\n",
" <td>-105.00</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14205</th>\n",
" <td>7445</td>\n",
" <td>King Soopers - Denver #1</td>\n",
" <td>Starbucks</td>\n",
" <td>73787-111045</td>\n",
" <td>LS</td>\n",
" <td>1331 N Speer Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80204</td>\n",
" <td>-105.00</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16450</th>\n",
" <td>91316</td>\n",
" <td>14th &amp; Speer, Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>17562-165406</td>\n",
" <td>CO</td>\n",
" <td>1410 Speer Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80204</td>\n",
" <td>-105.00</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6457</th>\n",
" <td>12186</td>\n",
" <td>Writer Square</td>\n",
" <td>Starbucks</td>\n",
" <td>6657-73731</td>\n",
" <td>CO</td>\n",
" <td>1512 Larimer Street</td>\n",
" <td>NaN</td>\n",
" <td>Writer's Square</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802021610</td>\n",
" <td>-105.00</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14381</th>\n",
" <td>18413</td>\n",
" <td>Larimer Square</td>\n",
" <td>Starbucks</td>\n",
" <td>248-135</td>\n",
" <td>CO</td>\n",
" <td>1406 Larimer St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802021705</td>\n",
" <td>-105.00</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16740</th>\n",
" <td>14867</td>\n",
" <td>16th St. &amp; Blake</td>\n",
" <td>Starbucks</td>\n",
" <td>5803-15714</td>\n",
" <td>CO</td>\n",
" <td>1490 16th Street</td>\n",
" <td>NaN</td>\n",
" <td>16 Market Square</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802021320</td>\n",
" <td>-105.00</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17419</th>\n",
" <td>1007338</td>\n",
" <td>1900 Sixteenth St.</td>\n",
" <td>Starbucks</td>\n",
" <td>22162-218186</td>\n",
" <td>CO</td>\n",
" <td>1900 Sixteenth St.</td>\n",
" <td>100</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80202</td>\n",
" <td>-105.00</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24322</th>\n",
" <td>6919</td>\n",
" <td>The Curtis Hotel Lobby</td>\n",
" <td>Starbucks</td>\n",
" <td>78024-107376</td>\n",
" <td>LS</td>\n",
" <td>1405 Curtis St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802022349</td>\n",
" <td>-105.00</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17580</th>\n",
" <td>11111</td>\n",
" <td>Safeway - Denver #885</td>\n",
" <td>Starbucks</td>\n",
" <td>73165-21582</td>\n",
" <td>LS</td>\n",
" <td>323 S Broadway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802091511</td>\n",
" <td>-104.99</td>\n",
" <td>39.71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22402</th>\n",
" <td>7168</td>\n",
" <td>Alameda &amp; Broadway- Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>10351-99161</td>\n",
" <td>CO</td>\n",
" <td>381 S Broadway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802091522</td>\n",
" <td>-104.99</td>\n",
" <td>39.71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4363</th>\n",
" <td>11609</td>\n",
" <td>UMB Bank Plaza</td>\n",
" <td>Starbucks</td>\n",
" <td>6205-30</td>\n",
" <td>CO</td>\n",
" <td>1670 Broadway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802024801</td>\n",
" <td>-104.99</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4973</th>\n",
" <td>20098</td>\n",
" <td>Embassy Suites Denver Downtown Conv</td>\n",
" <td>Starbucks</td>\n",
" <td>15466-156825</td>\n",
" <td>LS</td>\n",
" <td>1420 Stout St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802023201</td>\n",
" <td>-104.99</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14063</th>\n",
" <td>14601</td>\n",
" <td>Atrium @ 1700 Broadway</td>\n",
" <td>Starbucks</td>\n",
" <td>75324-95897</td>\n",
" <td>LS</td>\n",
" <td>1700 Broadway</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802901700</td>\n",
" <td>-104.99</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17309</th>\n",
" <td>15921</td>\n",
" <td>16th &amp; Tremont</td>\n",
" <td>Starbucks</td>\n",
" <td>5640-2442</td>\n",
" <td>CO</td>\n",
" <td>303 16th Street</td>\n",
" <td>Ste. 100</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802025657</td>\n",
" <td>-104.99</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1452</th>\n",
" <td>1007646</td>\n",
" <td>Grand Hyatt Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>75828-94910</td>\n",
" <td>LS</td>\n",
" <td>1740 Welton St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802023940</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9366</th>\n",
" <td>15626</td>\n",
" <td>18th &amp; California</td>\n",
" <td>Starbucks</td>\n",
" <td>6381-25487</td>\n",
" <td>CO</td>\n",
" <td>633 17th St</td>\n",
" <td>110</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802023616</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11555</th>\n",
" <td>1012255</td>\n",
" <td>17th and Lawrence</td>\n",
" <td>Starbucks</td>\n",
" <td>24838-238076</td>\n",
" <td>CO</td>\n",
" <td>1125 17th Street</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80202</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16961</th>\n",
" <td>13338</td>\n",
" <td>16th Street &amp; Curtis</td>\n",
" <td>Starbucks</td>\n",
" <td>5392-873</td>\n",
" <td>CO</td>\n",
" <td>934 Sixteenth Street</td>\n",
" <td>NaN</td>\n",
" <td>16th &amp; Curtis</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802022902</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18275</th>\n",
" <td>16611</td>\n",
" <td>18th &amp; Champa</td>\n",
" <td>Starbucks</td>\n",
" <td>6697-73722</td>\n",
" <td>CO</td>\n",
" <td>999 18th Street</td>\n",
" <td>113</td>\n",
" <td>Denver Place Mall</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802022499</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21394</th>\n",
" <td>10313</td>\n",
" <td>16th &amp; California- Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>10673-100271</td>\n",
" <td>CO</td>\n",
" <td>700 16th St.</td>\n",
" <td>Suite A</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802023229</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23117</th>\n",
" <td>15621</td>\n",
" <td>Denver Marriott CC - Lobby</td>\n",
" <td>Starbucks</td>\n",
" <td>75506-33861</td>\n",
" <td>LS</td>\n",
" <td>1701 California Street</td>\n",
" <td>NaN</td>\n",
" <td>Denver Marriott City Center</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802023402</td>\n",
" <td>-104.99</td>\n",
" <td>39.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1701</th>\n",
" <td>13301</td>\n",
" <td>Safeway - Denver #1463</td>\n",
" <td>Starbucks</td>\n",
" <td>74105-23807</td>\n",
" <td>LS</td>\n",
" <td>2150 S Downing</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802104528</td>\n",
" <td>-104.97</td>\n",
" <td>39.68</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22515</th>\n",
" <td>7887</td>\n",
" <td>Franklin &amp; Evans-Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>10261-100356</td>\n",
" <td>CO</td>\n",
" <td>1605 E Evans Ave</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802104608</td>\n",
" <td>-104.97</td>\n",
" <td>39.68</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2011</th>\n",
" <td>15744</td>\n",
" <td>King Soopers-Denver #29</td>\n",
" <td>Starbucks</td>\n",
" <td>75003-33060</td>\n",
" <td>LS</td>\n",
" <td>1155 E. 9th Ave.</td>\n",
" <td>NaN</td>\n",
" <td>Capitol Hill Center</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802184802</td>\n",
" <td>-104.97</td>\n",
" <td>39.73</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14810</th>\n",
" <td>12391</td>\n",
" <td>Safeway-Denver #1614</td>\n",
" <td>Starbucks</td>\n",
" <td>74125-25289</td>\n",
" <td>LS</td>\n",
" <td>560 Corona St.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802183436</td>\n",
" <td>-104.97</td>\n",
" <td>39.73</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8119</th>\n",
" <td>18414</td>\n",
" <td>2nd Ave and Filmore - Cherry Creek</td>\n",
" <td>Starbucks</td>\n",
" <td>253-136</td>\n",
" <td>CO</td>\n",
" <td>200 Fillmore Street</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802065028</td>\n",
" <td>-104.95</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8833</th>\n",
" <td>1012787</td>\n",
" <td>Teavana - Cherry Creek</td>\n",
" <td>Teavana</td>\n",
" <td>28591-249796</td>\n",
" <td>CO</td>\n",
" <td>3000 E. 1ST STREET</td>\n",
" <td>#264</td>\n",
" <td>Cherry Creek</td>\n",
" <td>DENVER</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80206</td>\n",
" <td>-104.95</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17504</th>\n",
" <td>15126</td>\n",
" <td>Safeway-Denver #100</td>\n",
" <td>Starbucks</td>\n",
" <td>74178-32999</td>\n",
" <td>LS</td>\n",
" <td>3110 E 1st Ave</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802065614</td>\n",
" <td>-104.95</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19808</th>\n",
" <td>10432</td>\n",
" <td>Cherry Creek Mall - West.</td>\n",
" <td>Starbucks</td>\n",
" <td>10861-103209</td>\n",
" <td>CO</td>\n",
" <td>3000 1st Ave.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802065638</td>\n",
" <td>-104.95</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4787</th>\n",
" <td>7958</td>\n",
" <td>King Soopers - Denver #72</td>\n",
" <td>Starbucks</td>\n",
" <td>79292-99564</td>\n",
" <td>LS</td>\n",
" <td>2750 S Colorado Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802226602</td>\n",
" <td>-104.94</td>\n",
" <td>39.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11049</th>\n",
" <td>16586</td>\n",
" <td>University Hills</td>\n",
" <td>Starbucks</td>\n",
" <td>5434-872</td>\n",
" <td>CO</td>\n",
" <td>2700 S. Colorado Blvd.</td>\n",
" <td>NaN</td>\n",
" <td>University Hills Mall</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802103506</td>\n",
" <td>-104.94</td>\n",
" <td>39.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7078</th>\n",
" <td>16192</td>\n",
" <td>Safeway-Denver #1038</td>\n",
" <td>Starbucks</td>\n",
" <td>74254-65021</td>\n",
" <td>LS</td>\n",
" <td>1653 S Colorado Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802201055</td>\n",
" <td>-104.94</td>\n",
" <td>39.69</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16809</th>\n",
" <td>14304</td>\n",
" <td>Colorado &amp; Arizona</td>\n",
" <td>Starbucks</td>\n",
" <td>8916-95345</td>\n",
" <td>CO</td>\n",
" <td>1233 S. Colorado Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802462902</td>\n",
" <td>-104.94</td>\n",
" <td>39.69</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15516</th>\n",
" <td>9733</td>\n",
" <td>Colfax &amp; Krameria</td>\n",
" <td>Starbucks</td>\n",
" <td>8115-95975</td>\n",
" <td>CO</td>\n",
" <td>6160 E. Colfax Ave</td>\n",
" <td>Unit 1</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802201569</td>\n",
" <td>-104.92</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22565</th>\n",
" <td>15632</td>\n",
" <td>Safeway-Denver #2714</td>\n",
" <td>Starbucks</td>\n",
" <td>74705-96758</td>\n",
" <td>LS</td>\n",
" <td>6220 E 14th St</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802202747</td>\n",
" <td>-104.92</td>\n",
" <td>39.74</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4674</th>\n",
" <td>7184</td>\n",
" <td>Lowry Town Center - Denver</td>\n",
" <td>Starbucks</td>\n",
" <td>10862-103208</td>\n",
" <td>CO</td>\n",
" <td>200 Quebec St.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802307144</td>\n",
" <td>-104.90</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15638</th>\n",
" <td>17644</td>\n",
" <td>Safeway - Denver #3836</td>\n",
" <td>Starbucks</td>\n",
" <td>73566-81441</td>\n",
" <td>LS</td>\n",
" <td>200 Quebec St</td>\n",
" <td>#400</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802307145</td>\n",
" <td>-104.90</td>\n",
" <td>39.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7657</th>\n",
" <td>87559</td>\n",
" <td>King Soopers-Denver #93</td>\n",
" <td>Starbucks</td>\n",
" <td>16946-106016</td>\n",
" <td>LS</td>\n",
" <td>2810 Quebec St.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802072900</td>\n",
" <td>-104.90</td>\n",
" <td>39.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24347</th>\n",
" <td>16735</td>\n",
" <td>Stapleton TC-29th &amp; Quebec</td>\n",
" <td>Starbucks</td>\n",
" <td>2817-86203</td>\n",
" <td>CO</td>\n",
" <td>7304 E. 29th Ave</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>802382699</td>\n",
" <td>-104.90</td>\n",
" <td>39.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13061</th>\n",
" <td>17982</td>\n",
" <td>DEN B RJ Term South Finger Lower</td>\n",
" <td>Starbucks</td>\n",
" <td>75960-108269</td>\n",
" <td>LS</td>\n",
" <td>HMSHost 8500 Pena Blvd</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80249</td>\n",
" <td>-104.67</td>\n",
" <td>39.86</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21204</th>\n",
" <td>18118</td>\n",
" <td>DEN B RJ Term South Finger Upper</td>\n",
" <td>Starbucks</td>\n",
" <td>75959-108270</td>\n",
" <td>LS</td>\n",
" <td>HMSHost 8500 Pena Blvd.</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Denver</td>\n",
" <td>CO</td>\n",
" <td>US</td>\n",
" <td>80249</td>\n",
" <td>-104.67</td>\n",
" <td>39.86</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c9f0c7be-9788-4a7d-b7f1-2c46343f7a89')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-c9f0c7be-9788-4a7d-b7f1-2c46343f7a89 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-c9f0c7be-9788-4a7d-b7f1-2c46343f7a89');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 7
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment