02-remover-registros-duplicados.ipynb

{"cells":[{"cell_type":"markdown","source":["## Instalar Pacote de Acesso ao Azure Data Lake\n![pyhton pip package](https://raw.githubusercontent.com/fabioms-br/azure-databricks/main/package-azure-storage-file-datalake.png \"pyhton pip package\")"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"712869ce-6edd-4228-98f8-4abcc613adce"}}},{"cell_type":"code","source":["pip install azure-storage-file-datalake"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"feab514b-e791-4850-b2fe-ef8130081463"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Python interpreter will be restarted.\nCollecting azure-storage-file-datalake\n  Downloading azure_storage_file_datalake-12.8.0-py3-none-any.whl (225 kB)\nCollecting azure-storage-blob&lt;13.0.0,&gt;=12.13.0\n  Downloading azure_storage_blob-12.13.1-py3-none-any.whl (377 kB)\nCollecting msrest&gt;=0.6.21\n  Downloading msrest-0.7.1-py3-none-any.whl (85 kB)\nCollecting azure-core&lt;2.0.0,&gt;=1.23.1\n  Downloading azure_core-1.26.0-py3-none-any.whl (178 kB)\nRequirement already satisfied: requests&gt;=2.18.4 in /databricks/python3/lib/python3.8/site-packages (from azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (2.25.1)\nCollecting typing-extensions&gt;=4.0.1\n  Downloading typing_extensions-4.4.0-py3-none-any.whl (26 kB)\nRequirement already satisfied: six&gt;=1.11.0 in /databricks/python3/lib/python3.8/site-packages (from azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (1.15.0)\nCollecting cryptography&gt;=2.1.4\n  Downloading cryptography-38.0.1-cp36-abi3-manylinux_2_28_x86_64.whl (4.2 MB)\nRequirement already satisfied: cffi&gt;=1.12 in /databricks/python3/lib/python3.8/site-packages (from cryptography&gt;=2.1.4-&gt;azure-storage-blob&lt;13.0.0,&gt;=12.13.0-&gt;azure-storage-file-datalake) (1.14.5)\nRequirement already satisfied: pycparser in /databricks/python3/lib/python3.8/site-packages (from cffi&gt;=1.12-&gt;cryptography&gt;=2.1.4-&gt;azure-storage-blob&lt;13.0.0,&gt;=12.13.0-&gt;azure-storage-file-datalake) (2.20)\nCollecting isodate&gt;=0.6.0\n  Downloading isodate-0.6.1-py2.py3-none-any.whl (41 kB)\nRequirement already satisfied: certifi&gt;=2017.4.17 in /databricks/python3/lib/python3.8/site-packages (from msrest&gt;=0.6.21-&gt;azure-storage-file-datalake) (2020.12.5)\nCollecting requests-oauthlib&gt;=0.5.0\n  Downloading requests_oauthlib-1.3.1-py2.py3-none-any.whl (23 kB)\nRequirement already satisfied: urllib3&lt;1.27,&gt;=1.21.1 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (1.25.11)\nRequirement already satisfied: idna&lt;3,&gt;=2.5 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (2.10)\nRequirement already satisfied: chardet&lt;5,&gt;=3.0.2 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (4.0.0)\nCollecting oauthlib&gt;=3.0.0\n  Downloading oauthlib-3.2.1-py3-none-any.whl (151 kB)\nInstalling collected packages: typing-extensions, oauthlib, requests-oauthlib, isodate, azure-core, msrest, cryptography, azure-storage-blob, azure-storage-file-datalake\nSuccessfully installed azure-core-1.26.0 azure-storage-blob-12.13.1 azure-storage-file-datalake-12.8.0 cryptography-38.0.1 isodate-0.6.1 msrest-0.7.1 oauthlib-3.2.1 requests-oauthlib-1.3.1 typing-extensions-4.4.0\nPython interpreter will be restarted.\n</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Python interpreter will be restarted.\nCollecting azure-storage-file-datalake\n  Downloading azure_storage_file_datalake-12.8.0-py3-none-any.whl (225 kB)\nCollecting azure-storage-blob&lt;13.0.0,&gt;=12.13.0\n  Downloading azure_storage_blob-12.13.1-py3-none-any.whl (377 kB)\nCollecting msrest&gt;=0.6.21\n  Downloading msrest-0.7.1-py3-none-any.whl (85 kB)\nCollecting azure-core&lt;2.0.0,&gt;=1.23.1\n  Downloading azure_core-1.26.0-py3-none-any.whl (178 kB)\nRequirement already satisfied: requests&gt;=2.18.4 in /databricks/python3/lib/python3.8/site-packages (from azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (2.25.1)\nCollecting typing-extensions&gt;=4.0.1\n  Downloading typing_extensions-4.4.0-py3-none-any.whl (26 kB)\nRequirement already satisfied: six&gt;=1.11.0 in /databricks/python3/lib/python3.8/site-packages (from azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (1.15.0)\nCollecting cryptography&gt;=2.1.4\n  Downloading cryptography-38.0.1-cp36-abi3-manylinux_2_28_x86_64.whl (4.2 MB)\nRequirement already satisfied: cffi&gt;=1.12 in /databricks/python3/lib/python3.8/site-packages (from cryptography&gt;=2.1.4-&gt;azure-storage-blob&lt;13.0.0,&gt;=12.13.0-&gt;azure-storage-file-datalake) (1.14.5)\nRequirement already satisfied: pycparser in /databricks/python3/lib/python3.8/site-packages (from cffi&gt;=1.12-&gt;cryptography&gt;=2.1.4-&gt;azure-storage-blob&lt;13.0.0,&gt;=12.13.0-&gt;azure-storage-file-datalake) (2.20)\nCollecting isodate&gt;=0.6.0\n  Downloading isodate-0.6.1-py2.py3-none-any.whl (41 kB)\nRequirement already satisfied: certifi&gt;=2017.4.17 in /databricks/python3/lib/python3.8/site-packages (from msrest&gt;=0.6.21-&gt;azure-storage-file-datalake) (2020.12.5)\nCollecting requests-oauthlib&gt;=0.5.0\n  Downloading requests_oauthlib-1.3.1-py2.py3-none-any.whl (23 kB)\nRequirement already satisfied: urllib3&lt;1.27,&gt;=1.21.1 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (1.25.11)\nRequirement already satisfied: idna&lt;3,&gt;=2.5 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (2.10)\nRequirement already satisfied: chardet&lt;5,&gt;=3.0.2 in /databricks/python3/lib/python3.8/site-packages (from requests&gt;=2.18.4-&gt;azure-core&lt;2.0.0,&gt;=1.23.1-&gt;azure-storage-file-datalake) (4.0.0)\nCollecting oauthlib&gt;=3.0.0\n  Downloading oauthlib-3.2.1-py3-none-any.whl (151 kB)\nInstalling collected packages: typing-extensions, oauthlib, requests-oauthlib, isodate, azure-core, msrest, cryptography, azure-storage-blob, azure-storage-file-datalake\nSuccessfully installed azure-core-1.26.0 azure-storage-blob-12.13.1 azure-storage-file-datalake-12.8.0 cryptography-38.0.1 isodate-0.6.1 msrest-0.7.1 oauthlib-3.2.1 requests-oauthlib-1.3.1 typing-extensions-4.4.0\nPython interpreter will be restarted.\n</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Instalar Pacote para ler Planilha Eletrônica\n![pyhton pip package](https://raw.githubusercontent.com/fabioms-br/azure-databricks/main/package-openpyxl.png \"pyhton pip package\")"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"7e1053d4-657a-4ac1-9aad-bd440f5ddf68"}}},{"cell_type":"code","source":["pip install openpyxl"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"5a8c77d4-a55f-4e99-80c0-d587758f652f"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Python interpreter will be restarted.\nCollecting openpyxl\n  Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)\nCollecting et-xmlfile\n  Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)\nInstalling collected packages: et-xmlfile, openpyxl\nSuccessfully installed et-xmlfile-1.1.0 openpyxl-3.0.10\nPython interpreter will be restarted.\n</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Python interpreter will be restarted.\nCollecting openpyxl\n  Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)\nCollecting et-xmlfile\n  Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)\nInstalling collected packages: et-xmlfile, openpyxl\nSuccessfully installed et-xmlfile-1.1.0 openpyxl-3.0.10\nPython interpreter will be restarted.\n</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Acessar arquivos no Azure Data Lake"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"7be84e9a-14df-4435-b3e2-6c5ab7b9670b"}}},{"cell_type":"code","source":["# Importar Pacotes instalados\r\nimport pandas as pd\r\nfrom azure.storage.filedatalake import DataLakeServiceClient\r\n\r\n# Definir caminho do arquivo\r\narquivo_01 = 'https://fabiomsdatalake.blob.core.windows.net/fabiomsfilesys/linkedin/2022_FabioMenezes_2022_07_03.xlsx'\r\narquivo_02 = 'https://fabiomsdatalake.blob.core.windows.net/fabiomsfilesys/linkedin/2022_FabioMenezes_2022_08_04.xlsx'\r\n\r\n# Obter Token de Acesso\r\nsas_token = '?sv=2021-06-08&ss=bfqt&srt=o&sp=rwdlacupyx&se=2022-10-10T01:01:00Z&st=2022-10-09T17:01:00Z&spr=https&sig=id6XkLfWHMpZ9DBww8H1PJplzREkx9%2Bxy29bUv77T%2F4%3D'\r\n\r\n# Ler arquivo excel\r\ndata_01 = pd.read_excel(arquivo_01 + sas_token)\r\ndata_02 = pd.read_excel(arquivo_02 + sas_token)\r\n\r\n# Combinar valores\r\ndf = data_01.append([data_02])\r\n"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"5526094f-7f66-4882-a186-8f438fa4be13"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">/local_disk0/.ephemeral_nfs/envs/pythonEnv-7ba1c101-eb55-4e8a-a682-5229575814af/lib/python3.8/site-packages/openpyxl/styles/stylesheet.py:226: UserWarning: Workbook contains no default style, apply openpyxl&#39;s default\n  warn(&#34;Workbook contains no default style, apply openpyxl&#39;s default&#34;)\n</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">/local_disk0/.ephemeral_nfs/envs/pythonEnv-7ba1c101-eb55-4e8a-a682-5229575814af/lib/python3.8/site-packages/openpyxl/styles/stylesheet.py:226: UserWarning: Workbook contains no default style, apply openpyxl&#39;s default\n  warn(&#34;Workbook contains no default style, apply openpyxl&#39;s default&#34;)\n</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Conhecer os dados"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"3e56189c-f5e9-43cb-a91c-0654d52b3b9b"}}},{"cell_type":"code","source":["df.info()"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"32d312a4-773a-41fb-b1c5-b13a68a1234f"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">&lt;class &#39;pandas.core.frame.DataFrame&#39;&gt;\nInt64Index: 455 entries, 0 to 89\nData columns (total 3 columns):\n #   Column       Non-Null Count  Dtype \n---  ------       --------------  ----- \n 0   Date         455 non-null    object\n 1   Impressions  455 non-null    int64 \n 2   Engagements  455 non-null    int64 \ndtypes: int64(2), object(1)\nmemory usage: 22.3+ KB\n</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">&lt;class &#39;pandas.core.frame.DataFrame&#39;&gt;\nInt64Index: 455 entries, 0 to 89\nData columns (total 3 columns):\n #   Column       Non-Null Count  Dtype \n---  ------       --------------  ----- \n 0   Date         455 non-null    object\n 1   Impressions  455 non-null    int64 \n 2   Engagements  455 non-null    int64 \ndtypes: int64(2), object(1)\nmemory usage: 22.3+ KB\n</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Identificar registros duplicados"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"0932b360-6ae4-467a-b639-e64e5cd235f1"}}},{"cell_type":"code","source":["duplicados = df[df.duplicated()]\r\nduplicados"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"b3aa5a6b-4b51-4ccb-9d9b-18b3bd2ec5ac"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Out[18]: </div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Out[18]: </div>"]}},{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<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>Date</th>\n      <th>Impressions</th>\n      <th>Engagements</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>5/7/2022</td>\n      <td>267</td>\n      <td>6</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>5/9/2022</td>\n      <td>495</td>\n      <td>21</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>5/10/2022</td>\n      <td>1397</td>\n      <td>49</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5/11/2022</td>\n      <td>1041</td>\n      <td>34</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>5/12/2022</td>\n      <td>629</td>\n      <td>19</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>5/13/2022</td>\n      <td>1321</td>\n      <td>60</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>5/14/2022</td>\n      <td>554</td>\n      <td>19</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>5/15/2022</td>\n      <td>233</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>5/16/2022</td>\n      <td>701</td>\n      <td>22</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>5/17/2022</td>\n      <td>696</td>\n      <td>18</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>5/20/2022</td>\n      <td>1395</td>\n      <td>44</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>5/21/2022</td>\n      <td>417</td>\n      <td>8</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>5/22/2022</td>\n      <td>279</td>\n      <td>3</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>5/23/2022</td>\n      <td>1591</td>\n      <td>29</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>5/25/2022</td>\n      <td>573</td>\n      <td>14</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>5/26/2022</td>\n      <td>765</td>\n      <td>33</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>5/27/2022</td>\n      <td>772</td>\n      <td>21</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>5/28/2022</td>\n      <td>230</td>\n      <td>5</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>5/29/2022</td>\n      <td>131</td>\n      <td>2</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>5/30/2022</td>\n      <td>671</td>\n      <td>24</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>5/31/2022</td>\n      <td>1139</td>\n      <td>43</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>6/1/2022</td>\n      <td>1330</td>\n      <td>39</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>6/2/2022</td>\n      <td>1062</td>\n      <td>32</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>6/3/2022</td>\n      <td>791</td>\n      <td>25</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>6/4/2022</td>\n      <td>334</td>\n      <td>13</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>6/5/2022</td>\n      <td>212</td>\n      <td>7</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>6/6/2022</td>\n      <td>1332</td>\n      <td>47</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>6/7/2022</td>\n      <td>1492</td>\n      <td>41</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>6/9/2022</td>\n      <td>1050</td>\n      <td>30</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>6/10/2022</td>\n      <td>1185</td>\n      <td>35</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>6/11/2022</td>\n      <td>754</td>\n      <td>11</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>6/12/2022</td>\n      <td>187</td>\n      <td>3</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>6/13/2022</td>\n      <td>1458</td>\n      <td>44</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>6/14/2022</td>\n      <td>1325</td>\n      <td>40</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>6/19/2022</td>\n      <td>2338</td>\n      <td>58</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>6/21/2022</td>\n      <td>2779</td>\n      <td>68</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>6/22/2022</td>\n      <td>2597</td>\n      <td>73</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>6/23/2022</td>\n      <td>1921</td>\n      <td>40</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>6/24/2022</td>\n      <td>1772</td>\n      <td>48</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>6/25/2022</td>\n      <td>679</td>\n      <td>15</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>6/26/2022</td>\n      <td>1263</td>\n      <td>31</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>6/27/2022</td>\n      <td>1628</td>\n      <td>41</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>6/28/2022</td>\n      <td>1968</td>\n      <td>36</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>6/29/2022</td>\n      <td>1226</td>\n      <td>28</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>6/30/2022</td>\n      <td>1926</td>\n      <td>51</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td>7/1/2022</td>\n      <td>1592</td>\n      <td>38</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td>7/2/2022</td>\n      <td>1729</td>\n      <td>35</td>\n    </tr>\n  </tbody>\n</table>\n</div>","textData":null,"removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"htmlSandbox","arguments":{}}},"output_type":"display_data","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>Date</th>\n      <th>Impressions</th>\n      <th>Engagements</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>5/7/2022</td>\n      <td>267</td>\n      <td>6</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>5/9/2022</td>\n      <td>495</td>\n      <td>21</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>5/10/2022</td>\n      <td>1397</td>\n      <td>49</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>5/11/2022</td>\n      <td>1041</td>\n      <td>34</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>5/12/2022</td>\n      <td>629</td>\n      <td>19</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>5/13/2022</td>\n      <td>1321</td>\n      <td>60</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>5/14/2022</td>\n      <td>554</td>\n      <td>19</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>5/15/2022</td>\n      <td>233</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>5/16/2022</td>\n      <td>701</td>\n      <td>22</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>5/17/2022</td>\n      <td>696</td>\n      <td>18</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>5/20/2022</td>\n      <td>1395</td>\n      <td>44</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>5/21/2022</td>\n      <td>417</td>\n      <td>8</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>5/22/2022</td>\n      <td>279</td>\n      <td>3</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>5/23/2022</td>\n      <td>1591</td>\n      <td>29</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>5/25/2022</td>\n      <td>573</td>\n      <td>14</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>5/26/2022</td>\n      <td>765</td>\n      <td>33</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>5/27/2022</td>\n      <td>772</td>\n      <td>21</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>5/28/2022</td>\n      <td>230</td>\n      <td>5</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>5/29/2022</td>\n      <td>131</td>\n      <td>2</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>5/30/2022</td>\n      <td>671</td>\n      <td>24</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>5/31/2022</td>\n      <td>1139</td>\n      <td>43</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>6/1/2022</td>\n      <td>1330</td>\n      <td>39</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>6/2/2022</td>\n      <td>1062</td>\n      <td>32</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>6/3/2022</td>\n      <td>791</td>\n      <td>25</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>6/4/2022</td>\n      <td>334</td>\n      <td>13</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>6/5/2022</td>\n      <td>212</td>\n      <td>7</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>6/6/2022</td>\n      <td>1332</td>\n      <td>47</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>6/7/2022</td>\n      <td>1492</td>\n      <td>41</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>6/9/2022</td>\n      <td>1050</td>\n      <td>30</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>6/10/2022</td>\n      <td>1185</td>\n      <td>35</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>6/11/2022</td>\n      <td>754</td>\n      <td>11</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>6/12/2022</td>\n      <td>187</td>\n      <td>3</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>6/13/2022</td>\n      <td>1458</td>\n      <td>44</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>6/14/2022</td>\n      <td>1325</td>\n      <td>40</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>6/19/2022</td>\n      <td>2338</td>\n      <td>58</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>6/21/2022</td>\n      <td>2779</td>\n      <td>68</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>6/22/2022</td>\n      <td>2597</td>\n      <td>73</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>6/23/2022</td>\n      <td>1921</td>\n      <td>40</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>6/24/2022</td>\n      <td>1772</td>\n      <td>48</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>6/25/2022</td>\n      <td>679</td>\n      <td>15</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>6/26/2022</td>\n      <td>1263</td>\n      <td>31</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>6/27/2022</td>\n      <td>1628</td>\n      <td>41</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>6/28/2022</td>\n      <td>1968</td>\n      <td>36</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>6/29/2022</td>\n      <td>1226</td>\n      <td>28</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>6/30/2022</td>\n      <td>1926</td>\n      <td>51</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td>7/1/2022</td>\n      <td>1592</td>\n      <td>38</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td>7/2/2022</td>\n      <td>1729</td>\n      <td>35</td>\n    </tr>\n  </tbody>\n</table>\n</div>"]}}],"execution_count":0},{"cell_type":"code","source":["duplicados.count()"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"86972abf-6590-4dfd-a04d-df14ebb7ccb7"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Out[17]: Date           47\nImpressions    47\nEngagements    47\ndtype: int64</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Out[17]: Date           47\nImpressions    47\nEngagements    47\ndtype: int64</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Remover registros duplicados"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"a3084e4d-fa74-4934-8955-6f4a763b3d72"}}},{"cell_type":"code","source":["resultado = df.drop_duplicates()\r\nresultado"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"0e8057a2-e7da-4baa-94c8-a64a020d4b11"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Out[6]: </div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Out[6]: </div>"]}},{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<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>Date</th>\n      <th>Impressions</th>\n      <th>Engagements</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>7/4/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>7/5/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>7/6/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>7/7/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>7/8/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>85</th>\n      <td>7/31/2022</td>\n      <td>609</td>\n      <td>12</td>\n    </tr>\n    <tr>\n      <th>86</th>\n      <td>8/1/2022</td>\n      <td>3368</td>\n      <td>124</td>\n    </tr>\n    <tr>\n      <th>87</th>\n      <td>8/2/2022</td>\n      <td>2832</td>\n      <td>80</td>\n    </tr>\n    <tr>\n      <th>88</th>\n      <td>8/3/2022</td>\n      <td>1538</td>\n      <td>51</td>\n    </tr>\n    <tr>\n      <th>89</th>\n      <td>8/4/2022</td>\n      <td>1951</td>\n      <td>44</td>\n    </tr>\n  </tbody>\n</table>\n<p>408 rows × 3 columns</p>\n</div>","textData":null,"removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"htmlSandbox","arguments":{}}},"output_type":"display_data","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>Date</th>\n      <th>Impressions</th>\n      <th>Engagements</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>7/4/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>7/5/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>7/6/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>7/7/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>7/8/2021</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>85</th>\n      <td>7/31/2022</td>\n      <td>609</td>\n      <td>12</td>\n    </tr>\n    <tr>\n      <th>86</th>\n      <td>8/1/2022</td>\n      <td>3368</td>\n      <td>124</td>\n    </tr>\n    <tr>\n      <th>87</th>\n      <td>8/2/2022</td>\n      <td>2832</td>\n      <td>80</td>\n    </tr>\n    <tr>\n      <th>88</th>\n      <td>8/3/2022</td>\n      <td>1538</td>\n      <td>51</td>\n    </tr>\n    <tr>\n      <th>89</th>\n      <td>8/4/2022</td>\n      <td>1951</td>\n      <td>44</td>\n    </tr>\n  </tbody>\n</table>\n<p>408 rows × 3 columns</p>\n</div>"]}}],"execution_count":0},{"cell_type":"code","source":["resultado[resultado.duplicated()].count()"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"1382c0d7-a050-4a75-87bc-4ffca5024790"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">Out[7]: Date           0\nImpressions    0\nEngagements    0\ndtype: int64</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">Out[7]: Date           0\nImpressions    0\nEngagements    0\ndtype: int64</div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Salvar Resultado em Tabela"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"10a78869-8e5d-445e-80c5-78da1ab6f56f"}}},{"cell_type":"code","source":["# Converter em Spark Dataframe \r\nspark_df = spark.createDataFrame(resultado)\r\n\r\n# Gravar os registros\r\nspark_df.write.mode(\"overwrite\").saveAsTable(\"linkedin_analytics\")"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"088234ed-a0be-438d-b330-5a1a742cab4e"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\"></div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":0},{"cell_type":"markdown","source":["## Visualizar os registros da tabela"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"7a152ec4-9eec-4d8f-9f18-9b3218c994ca"}}},{"cell_type":"code","source":["tabela = spark.sql('SELECT * FROM linkedin_analytics').toPandas()"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"7b046d11-e74f-4fed-b34d-8f4cb57459b8"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\"></div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":0},{"cell_type":"code","source":["# Converter para Tipo de Dados Datetime\r\ntabela['Date'] = pd.to_datetime(tabela['Date'])"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"b27be7da-fe7d-47c2-a8b6-d4e626fc3ea2"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\"></div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\"></div>"]}}],"execution_count":0},{"cell_type":"code","source":["tabela.info()"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"fbe826fc-0c56-4b69-b8a9-3a945209bd7b"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"datasetInfos":[],"data":"<div class=\"ansiout\">&lt;class &#39;pandas.core.frame.DataFrame&#39;&gt;\nRangeIndex: 408 entries, 0 to 407\nData columns (total 3 columns):\n #   Column       Non-Null Count  Dtype         \n---  ------       --------------  -----         \n 0   Date         408 non-null    datetime64[ns]\n 1   Impressions  408 non-null    int64         \n 2   Engagements  408 non-null    int64         \ndtypes: datetime64[ns](1), int64(2)\nmemory usage: 9.7 KB\n</div>","removedWidgets":[],"addedWidgets":{},"metadata":{},"type":"html","arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .ansiout {\n    display: block;\n    unicode-bidi: embed;\n    white-space: pre-wrap;\n    word-wrap: break-word;\n    word-break: break-all;\n    font-family: \"Source Code Pro\", \"Menlo\", monospace;;\n    font-size: 13px;\n    color: #555;\n    margin-left: 4px;\n    line-height: 19px;\n  }\n</style>\n<div class=\"ansiout\">&lt;class &#39;pandas.core.frame.DataFrame&#39;&gt;\nRangeIndex: 408 entries, 0 to 407\nData columns (total 3 columns):\n #   Column       Non-Null Count  Dtype         \n---  ------       --------------  -----         \n 0   Date         408 non-null    datetime64[ns]\n 1   Impressions  408 non-null    int64         \n 2   Engagements  408 non-null    int64         \ndtypes: datetime64[ns](1), int64(2)\nmemory usage: 9.7 KB\n</div>"]}}],"execution_count":0},{"cell_type":"code","source":["display(tabela)"],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"fafc6cb7-71ac-44dc-8575-855b99b48660"}},"outputs":[{"output_type":"display_data","metadata":{"application/vnd.databricks.v1+output":{"overflow":false,"datasetInfos":[],"data":[["2022-05-06T00:00:00.000+0000",717,24],["2022-05-07T00:00:00.000+0000",267,6],["2022-05-08T00:00:00.000+0000",156,4],["2022-05-09T00:00:00.000+0000",495,21],["2022-05-10T00:00:00.000+0000",1397,49],["2022-05-11T00:00:00.000+0000",1041,34],["2022-05-12T00:00:00.000+0000",629,19],["2022-05-13T00:00:00.000+0000",1321,60],["2022-05-14T00:00:00.000+0000",554,19],["2022-05-15T00:00:00.000+0000",233,1],["2022-05-16T00:00:00.000+0000",701,22],["2022-05-17T00:00:00.000+0000",696,18],["2022-05-18T00:00:00.000+0000",1095,35],["2022-05-19T00:00:00.000+0000",1729,48],["2022-05-20T00:00:00.000+0000",1395,44],["2022-05-21T00:00:00.000+0000",417,8],["2022-05-22T00:00:00.000+0000",279,3],["2022-05-23T00:00:00.000+0000",1591,29],["2022-05-24T00:00:00.000+0000",1021,25],["2022-05-25T00:00:00.000+0000",573,14],["2022-05-26T00:00:00.000+0000",765,33],["2022-05-27T00:00:00.000+0000",772,21],["2022-05-28T00:00:00.000+0000",230,5],["2022-05-29T00:00:00.000+0000",131,2],["2022-05-30T00:00:00.000+0000",671,24],["2022-05-31T00:00:00.000+0000",1139,43],["2022-06-01T00:00:00.000+0000",1330,39],["2022-06-02T00:00:00.000+0000",1062,32],["2022-06-03T00:00:00.000+0000",791,25],["2022-06-04T00:00:00.000+0000",334,13],["2022-06-05T00:00:00.000+0000",212,7],["2022-06-06T00:00:00.000+0000",1332,47],["2022-06-07T00:00:00.000+0000",1492,41],["2022-06-08T00:00:00.000+0000",1489,42],["2022-06-09T00:00:00.000+0000",1050,30],["2022-06-10T00:00:00.000+0000",1185,35],["2022-06-11T00:00:00.000+0000",754,11],["2022-06-12T00:00:00.000+0000",187,3],["2022-06-13T00:00:00.000+0000",1458,44],["2022-06-14T00:00:00.000+0000",1325,40],["2022-06-15T00:00:00.000+0000",1681,82],["2022-06-16T00:00:00.000+0000",1687,68],["2022-06-17T00:00:00.000+0000",2657,63],["2022-06-18T00:00:00.000+0000",3957,75],["2022-06-19T00:00:00.000+0000",2338,58],["2022-06-20T00:00:00.000+0000",3666,59],["2022-06-21T00:00:00.000+0000",2779,68],["2022-06-22T00:00:00.000+0000",2597,73],["2022-06-23T00:00:00.000+0000",1921,40],["2022-06-24T00:00:00.000+0000",1772,48],["2022-06-25T00:00:00.000+0000",679,15],["2022-06-26T00:00:00.000+0000",1263,31],["2022-06-27T00:00:00.000+0000",1628,41],["2022-06-28T00:00:00.000+0000",1968,36],["2022-06-29T00:00:00.000+0000",1226,28],["2022-06-30T00:00:00.000+0000",1926,51],["2022-07-01T00:00:00.000+0000",1592,38],["2022-07-02T00:00:00.000+0000",1729,35],["2022-07-03T00:00:00.000+0000",300,3],["2022-05-08T00:00:00.000+0000",155,4],["2022-05-18T00:00:00.000+0000",1093,35],["2022-05-19T00:00:00.000+0000",1728,48],["2022-05-24T00:00:00.000+0000",1019,25],["2022-06-08T00:00:00.000+0000",1488,42],["2022-06-15T00:00:00.000+0000",1679,82],["2022-06-16T00:00:00.000+0000",1685,68],["2022-06-17T00:00:00.000+0000",2655,63],["2022-06-18T00:00:00.000+0000",3956,75],["2022-06-20T00:00:00.000+0000",3664,59],["2022-07-03T00:00:00.000+0000",997,24],["2022-07-04T00:00:00.000+0000",1394,25],["2022-07-05T00:00:00.000+0000",1159,36],["2022-07-06T00:00:00.000+0000",1059,20],["2022-07-07T00:00:00.000+0000",842,31],["2022-07-08T00:00:00.000+0000",728,15],["2022-07-09T00:00:00.000+0000",316,7],["2022-07-10T00:00:00.000+0000",666,19],["2022-07-11T00:00:00.000+0000",784,28],["2022-07-12T00:00:00.000+0000",1391,31],["2022-07-13T00:00:00.000+0000",1787,42],["2022-07-14T00:00:00.000+0000",1128,23],["2022-07-15T00:00:00.000+0000",598,14],["2022-07-16T00:00:00.000+0000",764,16],["2022-07-17T00:00:00.000+0000",580,18],["2022-07-18T00:00:00.000+0000",1430,48],["2022-07-19T00:00:00.000+0000",1358,39],["2022-07-20T00:00:00.000+0000",990,24],["2022-07-21T00:00:00.000+0000",802,26],["2022-07-22T00:00:00.000+0000",673,26],["2022-07-23T00:00:00.000+0000",451,10],["2022-07-24T00:00:00.000+0000",588,15],["2022-07-25T00:00:00.000+0000",1339,19],["2022-07-26T00:00:00.000+0000",700,14],["2022-07-27T00:00:00.000+0000",872,23],["2022-07-28T00:00:00.000+0000",961,18],["2022-07-29T00:00:00.000+0000",379,9],["2022-07-30T00:00:00.000+0000",119,2],["2022-07-31T00:00:00.000+0000",609,12],["2022-08-01T00:00:00.000+0000",3368,124],["2022-08-02T00:00:00.000+0000",2832,80],["2022-08-03T00:00:00.000+0000",1538,51],["2022-08-04T00:00:00.000+0000",1951,44],["2022-01-24T00:00:00.000+0000",260,7],["2022-01-25T00:00:00.000+0000",594,20],["2022-01-26T00:00:00.000+0000",194,5],["2022-01-27T00:00:00.000+0000",101,0],["2022-01-28T00:00:00.000+0000",371,16],["2022-01-29T00:00:00.000+0000",170,4],["2022-01-30T00:00:00.000+0000",145,7],["2022-01-31T00:00:00.000+0000",126,2],["2022-02-01T00:00:00.000+0000",146,4],["2022-02-02T00:00:00.000+0000",122,3],["2022-02-03T00:00:00.000+0000",261,8],["2022-02-04T00:00:00.000+0000",810,21],["2022-02-05T00:00:00.000+0000",485,10],["2022-02-06T00:00:00.000+0000",610,24],["2022-02-07T00:00:00.000+0000",493,14],["2022-02-08T00:00:00.000+0000",511,12],["2022-02-09T00:00:00.000+0000",395,14],["2022-02-10T00:00:00.000+0000",385,16],["2022-02-11T00:00:00.000+0000",261,5],["2022-02-12T00:00:00.000+0000",170,6],["2022-02-13T00:00:00.000+0000",108,3],["2022-02-14T00:00:00.000+0000",436,11],["2022-02-15T00:00:00.000+0000",598,27],["2022-02-16T00:00:00.000+0000",251,5],["2022-02-17T00:00:00.000+0000",414,8],["2022-02-18T00:00:00.000+0000",1173,46],["2022-02-19T00:00:00.000+0000",274,10],["2022-02-20T00:00:00.000+0000",185,5],["2022-02-21T00:00:00.000+0000",467,12],["2022-02-22T00:00:00.000+0000",660,31],["2022-02-23T00:00:00.000+0000",511,16],["2022-02-24T00:00:00.000+0000",699,20],["2022-02-25T00:00:00.000+0000",278,13],["2022-02-26T00:00:00.000+0000",129,10],["2022-02-27T00:00:00.000+0000",86,2],["2022-02-28T00:00:00.000+0000",83,2],["2022-03-01T00:00:00.000+0000",103,2],["2022-03-02T00:00:00.000+0000",45,0],["2022-03-03T00:00:00.000+0000",49,1],["2022-03-04T00:00:00.000+0000",373,12],["2022-03-05T00:00:00.000+0000",128,3],["2022-03-06T00:00:00.000+0000",398,11],["2022-03-07T00:00:00.000+0000",862,27],["2022-03-08T00:00:00.000+0000",789,27],["2022-03-09T00:00:00.000+0000",1309,29],["2022-03-10T00:00:00.000+0000",811,18],["2022-03-11T00:00:00.000+0000",825,23],["2022-03-12T00:00:00.000+0000",344,9],["2022-03-13T00:00:00.000+0000",532,9],["2022-03-14T00:00:00.000+0000",1370,39],["2022-03-15T00:00:00.000+0000",1269,29],["2022-03-16T00:00:00.000+0000",854,30],["2022-03-17T00:00:00.000+0000",1744,42],["2022-03-18T00:00:00.000+0000",1058,22],["2022-03-19T00:00:00.000+0000",319,4],["2022-03-20T00:00:00.000+0000",301,7],["2022-03-21T00:00:00.000+0000",928,35],["2022-03-22T00:00:00.000+0000",1369,38],["2022-03-23T00:00:00.000+0000",932,28],["2022-03-24T00:00:00.000+0000",1340,43],["2022-03-25T00:00:00.000+0000",1235,22],["2022-03-26T00:00:00.000+0000",508,8],["2022-03-27T00:00:00.000+0000",379,8],["2022-03-28T00:00:00.000+0000",1165,39],["2022-03-29T00:00:00.000+0000",1528,46],["2022-03-30T00:00:00.000+0000",1674,41],["2022-03-31T00:00:00.000+0000",1214,33],["2022-04-01T00:00:00.000+0000",1074,35],["2022-04-02T00:00:00.000+0000",1044,20],["2022-04-03T00:00:00.000+0000",452,4],["2022-04-04T00:00:00.000+0000",1244,32],["2022-04-05T00:00:00.000+0000",1008,22],["2022-04-06T00:00:00.000+0000",672,23],["2022-04-07T00:00:00.000+0000",938,19],["2022-04-08T00:00:00.000+0000",685,17],["2022-04-09T00:00:00.000+0000",193,3],["2022-04-10T00:00:00.000+0000",228,8],["2022-04-11T00:00:00.000+0000",939,33],["2022-04-12T00:00:00.000+0000",1158,22],["2022-04-13T00:00:00.000+0000",1179,36],["2022-04-14T00:00:00.000+0000",1534,41],["2022-04-15T00:00:00.000+0000",958,28],["2022-04-16T00:00:00.000+0000",407,11],["2022-04-17T00:00:00.000+0000",241,3],["2022-04-18T00:00:00.000+0000",635,12],["2022-04-19T00:00:00.000+0000",608,15],["2022-04-20T00:00:00.000+0000",773,26],["2022-04-21T00:00:00.000+0000",1750,78],["2022-04-22T00:00:00.000+0000",1658,51],["2022-04-23T00:00:00.000+0000",555,11],["2022-04-24T00:00:00.000+0000",320,9],["2022-04-25T00:00:00.000+0000",712,19],["2022-04-26T00:00:00.000+0000",1106,30],["2022-04-27T00:00:00.000+0000",2143,55],["2022-04-28T00:00:00.000+0000",1538,48],["2022-04-29T00:00:00.000+0000",1284,33],["2022-04-30T00:00:00.000+0000",828,14],["2022-05-01T00:00:00.000+0000",473,3],["2022-05-02T00:00:00.000+0000",778,18],["2022-05-03T00:00:00.000+0000",670,11],["2022-05-04T00:00:00.000+0000",794,22],["2022-05-05T00:00:00.000+0000",1040,30],["2021-10-14T00:00:00.000+0000",13,1],["2021-10-15T00:00:00.000+0000",18,1],["2021-10-16T00:00:00.000+0000",9,0],["2021-10-17T00:00:00.000+0000",14,0],["2021-10-18T00:00:00.000+0000",5,0],["2021-10-19T00:00:00.000+0000",4,0],["2021-10-20T00:00:00.000+0000",26,2],["2021-10-21T00:00:00.000+0000",7,0],["2021-10-22T00:00:00.000+0000",1,0],["2021-10-23T00:00:00.000+0000",183,8],["2021-10-24T00:00:00.000+0000",80,0],["2021-10-25T00:00:00.000+0000",21,0],["2021-10-26T00:00:00.000+0000",22,1],["2021-10-27T00:00:00.000+0000",153,9],["2021-10-28T00:00:00.000+0000",56,5],["2021-10-29T00:00:00.000+0000",30,2],["2021-10-30T00:00:00.000+0000",8,0],["2021-10-31T00:00:00.000+0000",18,3],["2021-11-01T00:00:00.000+0000",457,14],["2021-11-02T00:00:00.000+0000",652,22],["2021-11-03T00:00:00.000+0000",371,9],["2021-11-04T00:00:00.000+0000",586,13],["2021-11-05T00:00:00.000+0000",125,1],["2021-11-06T00:00:00.000+0000",62,2],["2021-11-07T00:00:00.000+0000",55,0],["2021-11-08T00:00:00.000+0000",520,17],["2021-11-09T00:00:00.000+0000",143,1],["2021-11-10T00:00:00.000+0000",59,2],["2021-11-11T00:00:00.000+0000",44,1],["2021-11-12T00:00:00.000+0000",262,7],["2021-11-13T00:00:00.000+0000",69,1],["2021-11-14T00:00:00.000+0000",29,0],["2021-11-15T00:00:00.000+0000",59,1],["2021-11-16T00:00:00.000+0000",375,9],["2021-11-17T00:00:00.000+0000",117,6],["2021-11-18T00:00:00.000+0000",62,3],["2021-11-19T00:00:00.000+0000",1178,50],["2021-11-20T00:00:00.000+0000",363,12],["2021-11-21T00:00:00.000+0000",180,2],["2021-11-22T00:00:00.000+0000",400,8],["2021-11-23T00:00:00.000+0000",718,26],["2021-11-24T00:00:00.000+0000",489,10],["2021-11-25T00:00:00.000+0000",119,2],["2021-11-26T00:00:00.000+0000",118,2],["2021-11-27T00:00:00.000+0000",91,2],["2021-11-28T00:00:00.000+0000",86,0],["2021-11-29T00:00:00.000+0000",800,20],["2021-11-30T00:00:00.000+0000",227,5],["2021-12-01T00:00:00.000+0000",118,2],["2021-12-02T00:00:00.000+0000",540,18],["2021-12-03T00:00:00.000+0000",101,3],["2021-12-04T00:00:00.000+0000",35,0],["2021-12-05T00:00:00.000+0000",40,0],["2021-12-06T00:00:00.000+0000",668,21],["2021-12-07T00:00:00.000+0000",474,7],["2021-12-08T00:00:00.000+0000",135,7],["2021-12-09T00:00:00.000+0000",194,8],["2021-12-10T00:00:00.000+0000",95,4],["2021-12-11T00:00:00.000+0000",486,17],["2021-12-12T00:00:00.000+0000",0,6],["2021-12-13T00:00:00.000+0000",101,5],["2021-12-14T00:00:00.000+0000",2241,40],["2021-12-15T00:00:00.000+0000",504,7],["2021-12-16T00:00:00.000+0000",235,3],["2021-12-17T00:00:00.000+0000",107,2],["2021-12-18T00:00:00.000+0000",143,3],["2021-12-19T00:00:00.000+0000",86,2],["2021-12-20T00:00:00.000+0000",375,10],["2021-12-21T00:00:00.000+0000",194,3],["2021-12-22T00:00:00.000+0000",1376,49],["2021-12-23T00:00:00.000+0000",387,6],["2021-12-24T00:00:00.000+0000",346,9],["2021-12-25T00:00:00.000+0000",186,3],["2021-12-26T00:00:00.000+0000",93,1],["2021-12-27T00:00:00.000+0000",755,32],["2021-12-28T00:00:00.000+0000",2318,50],["2021-12-29T00:00:00.000+0000",406,11],["2021-12-30T00:00:00.000+0000",266,11],["2021-12-31T00:00:00.000+0000",170,3],["2022-01-01T00:00:00.000+0000",140,0],["2022-01-02T00:00:00.000+0000",144,2],["2022-01-03T00:00:00.000+0000",1393,32],["2022-01-04T00:00:00.000+0000",675,12],["2022-01-05T00:00:00.000+0000",344,6],["2022-01-06T00:00:00.000+0000",458,5],["2022-01-07T00:00:00.000+0000",239,9],["2022-01-08T00:00:00.000+0000",179,9],["2022-01-09T00:00:00.000+0000",138,2],["2022-01-10T00:00:00.000+0000",212,5],["2022-01-11T00:00:00.000+0000",709,17],["2022-01-12T00:00:00.000+0000",254,3],["2022-01-13T00:00:00.000+0000",479,16],["2022-01-14T00:00:00.000+0000",198,5],["2022-01-15T00:00:00.000+0000",155,1],["2022-01-16T00:00:00.000+0000",93,0],["2022-01-17T00:00:00.000+0000",481,15],["2022-01-18T00:00:00.000+0000",102,2],["2022-01-19T00:00:00.000+0000",1149,64],["2022-01-20T00:00:00.000+0000",457,17],["2022-01-21T00:00:00.000+0000",143,8],["2022-01-22T00:00:00.000+0000",91,7],["2022-01-23T00:00:00.000+0000",68,0],["2021-07-04T00:00:00.000+0000",0,0],["2021-07-05T00:00:00.000+0000",0,0],["2021-07-06T00:00:00.000+0000",0,0],["2021-07-07T00:00:00.000+0000",0,0],["2021-07-08T00:00:00.000+0000",0,0],["2021-07-09T00:00:00.000+0000",0,0],["2021-07-10T00:00:00.000+0000",0,0],["2021-07-11T00:00:00.000+0000",0,0],["2021-07-12T00:00:00.000+0000",0,0],["2021-07-13T00:00:00.000+0000",0,0],["2021-07-14T00:00:00.000+0000",0,0],["2021-07-15T00:00:00.000+0000",1,0],["2021-07-16T00:00:00.000+0000",0,0],["2021-07-17T00:00:00.000+0000",0,0],["2021-07-18T00:00:00.000+0000",0,0],["2021-07-19T00:00:00.000+0000",0,0],["2021-07-20T00:00:00.000+0000",0,0],["2021-07-21T00:00:00.000+0000",0,0],["2021-07-22T00:00:00.000+0000",0,0],["2021-07-23T00:00:00.000+0000",0,0],["2021-07-24T00:00:00.000+0000",0,0],["2021-07-25T00:00:00.000+0000",0,0],["2021-07-26T00:00:00.000+0000",0,0],["2021-07-27T00:00:00.000+0000",0,0],["2021-07-28T00:00:00.000+0000",0,0],["2021-07-29T00:00:00.000+0000",142,4],["2021-07-30T00:00:00.000+0000",575,20],["2021-07-31T00:00:00.000+0000",98,3],["2021-08-01T00:00:00.000+0000",190,4],["2021-08-02T00:00:00.000+0000",164,6],["2021-08-03T00:00:00.000+0000",103,1],["2021-08-04T00:00:00.000+0000",100,0],["2021-08-05T00:00:00.000+0000",66,0],["2021-08-06T00:00:00.000+0000",15,0],["2021-08-07T00:00:00.000+0000",144,0],["2021-08-08T00:00:00.000+0000",301,10],["2021-08-09T00:00:00.000+0000",265,10],["2021-08-10T00:00:00.000+0000",295,12],["2021-08-11T00:00:00.000+0000",70,0],["2021-08-12T00:00:00.000+0000",29,1],["2021-08-13T00:00:00.000+0000",26,1],["2021-08-14T00:00:00.000+0000",10,0],["2021-08-15T00:00:00.000+0000",8,0],["2021-08-16T00:00:00.000+0000",20,1],["2021-08-17T00:00:00.000+0000",20,2],["2021-08-18T00:00:00.000+0000",26,4],["2021-08-19T00:00:00.000+0000",770,49],["2021-08-20T00:00:00.000+0000",520,20],["2021-08-21T00:00:00.000+0000",320,8],["2021-08-22T00:00:00.000+0000",121,9],["2021-08-23T00:00:00.000+0000",486,26],["2021-08-24T00:00:00.000+0000",137,2],["2021-08-25T00:00:00.000+0000",138,5],["2021-08-26T00:00:00.000+0000",69,3],["2021-08-27T00:00:00.000+0000",50,1],["2021-08-28T00:00:00.000+0000",42,0],["2021-08-29T00:00:00.000+0000",50,3],["2021-08-30T00:00:00.000+0000",289,11],["2021-08-31T00:00:00.000+0000",314,15],["2021-09-01T00:00:00.000+0000",111,4],["2021-09-02T00:00:00.000+0000",252,10],["2021-09-03T00:00:00.000+0000",391,21],["2021-09-04T00:00:00.000+0000",79,4],["2021-09-05T00:00:00.000+0000",66,3],["2021-09-06T00:00:00.000+0000",54,1],["2021-09-07T00:00:00.000+0000",40,0],["2021-09-08T00:00:00.000+0000",122,3],["2021-09-09T00:00:00.000+0000",45,4],["2021-09-10T00:00:00.000+0000",336,12],["2021-09-11T00:00:00.000+0000",45,1],["2021-09-12T00:00:00.000+0000",29,1],["2021-09-13T00:00:00.000+0000",88,0],["2021-09-14T00:00:00.000+0000",611,6],["2021-09-15T00:00:00.000+0000",119,4],["2021-09-16T00:00:00.000+0000",897,23],["2021-09-17T00:00:00.000+0000",225,3],["2021-09-18T00:00:00.000+0000",94,0],["2021-09-19T00:00:00.000+0000",931,31],["2021-09-20T00:00:00.000+0000",375,7],["2021-09-21T00:00:00.000+0000",87,0],["2021-09-22T00:00:00.000+0000",158,3],["2021-09-23T00:00:00.000+0000",81,3],["2021-09-24T00:00:00.000+0000",406,18],["2021-09-25T00:00:00.000+0000",127,0],["2021-09-26T00:00:00.000+0000",291,10],["2021-09-27T00:00:00.000+0000",284,5],["2021-09-28T00:00:00.000+0000",91,4],["2021-09-29T00:00:00.000+0000",29,1],["2021-09-30T00:00:00.000+0000",340,9],["2021-10-01T00:00:00.000+0000",84,0],["2021-10-02T00:00:00.000+0000",29,0],["2021-10-03T00:00:00.000+0000",29,0],["2021-10-04T00:00:00.000+0000",46,0],["2021-10-05T00:00:00.000+0000",35,0],["2021-10-06T00:00:00.000+0000",17,0],["2021-10-07T00:00:00.000+0000",736,20],["2021-10-08T00:00:00.000+0000",241,6],["2021-10-09T00:00:00.000+0000",80,2],["2021-10-10T00:00:00.000+0000",74,0],["2021-10-11T00:00:00.000+0000",42,1],["2021-10-12T00:00:00.000+0000",31,3],["2021-10-13T00:00:00.000+0000",21,0]],"plotOptions":{"displayType":"plotlyLine","customPlotOptions":{"plotlyLine":[{"key":"yRange","value":""},{"key":"showPoints","value":false},{"key":"logScale","value":false}],"plotlyBar":[{"key":"grouped","value":true},{"key":"stacked","value":false},{"key":"100_stacked","value":false}],"histogram":[{"key":"bins","value":"20"}]},"pivotColumns":[],"pivotAggregation":"sum","xColumns":["Date"],"yColumns":["Impressions","Engagements"]},"columnCustomDisplayInfos":{},"aggType":"","isJsonSchema":true,"removedWidgets":[],"aggSchema":[],"schema":[{"name":"Date","type":"\"timestamp\"","metadata":"{}"},{"name":"Impressions","type":"\"long\"","metadata":"{}"},{"name":"Engagements","type":"\"long\"","metadata":"{}"}],"aggError":"","aggData":[],"addedWidgets":{},"metadata":{},"dbfsResultPath":null,"type":"table","aggOverflow":false,"aggSeriesLimitReached":false,"arguments":{}}},"output_type":"display_data","data":{"text/html":["<style scoped>\n  .table-result-container {\n    max-height: 300px;\n    overflow: auto;\n  }\n  table, th, td {\n    border: 1px solid black;\n    border-collapse: collapse;\n  }\n  th, td {\n    padding: 5px;\n  }\n  th {\n    text-align: left;\n  }\n</style><div class='table-result-container'><table class='table-result'><thead style='background-color: white'><tr><th>Date</th><th>Impressions</th><th>Engagements</th></tr></thead><tbody><tr><td>2022-05-06T00:00:00.000+0000</td><td>717</td><td>24</td></tr><tr><td>2022-05-07T00:00:00.000+0000</td><td>267</td><td>6</td></tr><tr><td>2022-05-08T00:00:00.000+0000</td><td>156</td><td>4</td></tr><tr><td>2022-05-09T00:00:00.000+0000</td><td>495</td><td>21</td></tr><tr><td>2022-05-10T00:00:00.000+0000</td><td>1397</td><td>49</td></tr><tr><td>2022-05-11T00:00:00.000+0000</td><td>1041</td><td>34</td></tr><tr><td>2022-05-12T00:00:00.000+0000</td><td>629</td><td>19</td></tr><tr><td>2022-05-13T00:00:00.000+0000</td><td>1321</td><td>60</td></tr><tr><td>2022-05-14T00:00:00.000+0000</td><td>554</td><td>19</td></tr><tr><td>2022-05-15T00:00:00.000+0000</td><td>233</td><td>1</td></tr><tr><td>2022-05-16T00:00:00.000+0000</td><td>701</td><td>22</td></tr><tr><td>2022-05-17T00:00:00.000+0000</td><td>696</td><td>18</td></tr><tr><td>2022-05-18T00:00:00.000+0000</td><td>1095</td><td>35</td></tr><tr><td>2022-05-19T00:00:00.000+0000</td><td>1729</td><td>48</td></tr><tr><td>2022-05-20T00:00:00.000+0000</td><td>1395</td><td>44</td></tr><tr><td>2022-05-21T00:00:00.000+0000</td><td>417</td><td>8</td></tr><tr><td>2022-05-22T00:00:00.000+0000</td><td>279</td><td>3</td></tr><tr><td>2022-05-23T00:00:00.000+0000</td><td>1591</td><td>29</td></tr><tr><td>2022-05-24T00:00:00.000+0000</td><td>1021</td><td>25</td></tr><tr><td>2022-05-25T00:00:00.000+0000</td><td>573</td><td>14</td></tr><tr><td>2022-05-26T00:00:00.000+0000</td><td>765</td><td>33</td></tr><tr><td>2022-05-27T00:00:00.000+0000</td><td>772</td><td>21</td></tr><tr><td>2022-05-28T00:00:00.000+0000</td><td>230</td><td>5</td></tr><tr><td>2022-05-29T00:00:00.000+0000</td><td>131</td><td>2</td></tr><tr><td>2022-05-30T00:00:00.000+0000</td><td>671</td><td>24</td></tr><tr><td>2022-05-31T00:00:00.000+0000</td><td>1139</td><td>43</td></tr><tr><td>2022-06-01T00:00:00.000+0000</td><td>1330</td><td>39</td></tr><tr><td>2022-06-02T00:00:00.000+0000</td><td>1062</td><td>32</td></tr><tr><td>2022-06-03T00:00:00.000+0000</td><td>791</td><td>25</td></tr><tr><td>2022-06-04T00:00:00.000+0000</td><td>334</td><td>13</td></tr><tr><td>2022-06-05T00:00:00.000+0000</td><td>212</td><td>7</td></tr><tr><td>2022-06-06T00:00:00.000+0000</td><td>1332</td><td>47</td></tr><tr><td>2022-06-07T00:00:00.000+0000</td><td>1492</td><td>41</td></tr><tr><td>2022-06-08T00:00:00.000+0000</td><td>1489</td><td>42</td></tr><tr><td>2022-06-09T00:00:00.000+0000</td><td>1050</td><td>30</td></tr><tr><td>2022-06-10T00:00:00.000+0000</td><td>1185</td><td>35</td></tr><tr><td>2022-06-11T00:00:00.000+0000</td><td>754</td><td>11</td></tr><tr><td>2022-06-12T00:00:00.000+0000</td><td>187</td><td>3</td></tr><tr><td>2022-06-13T00:00:00.000+0000</td><td>1458</td><td>44</td></tr><tr><td>2022-06-14T00:00:00.000+0000</td><td>1325</td><td>40</td></tr><tr><td>2022-06-15T00:00:00.000+0000</td><td>1681</td><td>82</td></tr><tr><td>2022-06-16T00:00:00.000+0000</td><td>1687</td><td>68</td></tr><tr><td>2022-06-17T00:00:00.000+0000</td><td>2657</td><td>63</td></tr><tr><td>2022-06-18T00:00:00.000+0000</td><td>3957</td><td>75</td></tr><tr><td>2022-06-19T00:00:00.000+0000</td><td>2338</td><td>58</td></tr><tr><td>2022-06-20T00:00:00.000+0000</td><td>3666</td><td>59</td></tr><tr><td>2022-06-21T00:00:00.000+0000</td><td>2779</td><td>68</td></tr><tr><td>2022-06-22T00:00:00.000+0000</td><td>2597</td><td>73</td></tr><tr><td>2022-06-23T00:00:00.000+0000</td><td>1921</td><td>40</td></tr><tr><td>2022-06-24T00:00:00.000+0000</td><td>1772</td><td>48</td></tr><tr><td>2022-06-25T00:00:00.000+0000</td><td>679</td><td>15</td></tr><tr><td>2022-06-26T00:00:00.000+0000</td><td>1263</td><td>31</td></tr><tr><td>2022-06-27T00:00:00.000+0000</td><td>1628</td><td>41</td></tr><tr><td>2022-06-28T00:00:00.000+0000</td><td>1968</td><td>36</td></tr><tr><td>2022-06-29T00:00:00.000+0000</td><td>1226</td><td>28</td></tr><tr><td>2022-06-30T00:00:00.000+0000</td><td>1926</td><td>51</td></tr><tr><td>2022-07-01T00:00:00.000+0000</td><td>1592</td><td>38</td></tr><tr><td>2022-07-02T00:00:00.000+0000</td><td>1729</td><td>35</td></tr><tr><td>2022-07-03T00:00:00.000+0000</td><td>300</td><td>3</td></tr><tr><td>2022-05-08T00:00:00.000+0000</td><td>155</td><td>4</td></tr><tr><td>2022-05-18T00:00:00.000+0000</td><td>1093</td><td>35</td></tr><tr><td>2022-05-19T00:00:00.000+0000</td><td>1728</td><td>48</td></tr><tr><td>2022-05-24T00:00:00.000+0000</td><td>1019</td><td>25</td></tr><tr><td>2022-06-08T00:00:00.000+0000</td><td>1488</td><td>42</td></tr><tr><td>2022-06-15T00:00:00.000+0000</td><td>1679</td><td>82</td></tr><tr><td>2022-06-16T00:00:00.000+0000</td><td>1685</td><td>68</td></tr><tr><td>2022-06-17T00:00:00.000+0000</td><td>2655</td><td>63</td></tr><tr><td>2022-06-18T00:00:00.000+0000</td><td>3956</td><td>75</td></tr><tr><td>2022-06-20T00:00:00.000+0000</td><td>3664</td><td>59</td></tr><tr><td>2022-07-03T00:00:00.000+0000</td><td>997</td><td>24</td></tr><tr><td>2022-07-04T00:00:00.000+0000</td><td>1394</td><td>25</td></tr><tr><td>2022-07-05T00:00:00.000+0000</td><td>1159</td><td>36</td></tr><tr><td>2022-07-06T00:00:00.000+0000</td><td>1059</td><td>20</td></tr><tr><td>2022-07-07T00:00:00.000+0000</td><td>842</td><td>31</td></tr><tr><td>2022-07-08T00:00:00.000+0000</td><td>728</td><td>15</td></tr><tr><td>2022-07-09T00:00:00.000+0000</td><td>316</td><td>7</td></tr><tr><td>2022-07-10T00:00:00.000+0000</td><td>666</td><td>19</td></tr><tr><td>2022-07-11T00:00:00.000+0000</td><td>784</td><td>28</td></tr><tr><td>2022-07-12T00:00:00.000+0000</td><td>1391</td><td>31</td></tr><tr><td>2022-07-13T00:00:00.000+0000</td><td>1787</td><td>42</td></tr><tr><td>2022-07-14T00:00:00.000+0000</td><td>1128</td><td>23</td></tr><tr><td>2022-07-15T00:00:00.000+0000</td><td>598</td><td>14</td></tr><tr><td>2022-07-16T00:00:00.000+0000</td><td>764</td><td>16</td></tr><tr><td>2022-07-17T00:00:00.000+0000</td><td>580</td><td>18</td></tr><tr><td>2022-07-18T00:00:00.000+0000</td><td>1430</td><td>48</td></tr><tr><td>2022-07-19T00:00:00.000+0000</td><td>1358</td><td>39</td></tr><tr><td>2022-07-20T00:00:00.000+0000</td><td>990</td><td>24</td></tr><tr><td>2022-07-21T00:00:00.000+0000</td><td>802</td><td>26</td></tr><tr><td>2022-07-22T00:00:00.000+0000</td><td>673</td><td>26</td></tr><tr><td>2022-07-23T00:00:00.000+0000</td><td>451</td><td>10</td></tr><tr><td>2022-07-24T00:00:00.000+0000</td><td>588</td><td>15</td></tr><tr><td>2022-07-25T00:00:00.000+0000</td><td>1339</td><td>19</td></tr><tr><td>2022-07-26T00:00:00.000+0000</td><td>700</td><td>14</td></tr><tr><td>2022-07-27T00:00:00.000+0000</td><td>872</td><td>23</td></tr><tr><td>2022-07-28T00:00:00.000+0000</td><td>961</td><td>18</td></tr><tr><td>2022-07-29T00:00:00.000+0000</td><td>379</td><td>9</td></tr><tr><td>2022-07-30T00:00:00.000+0000</td><td>119</td><td>2</td></tr><tr><td>2022-07-31T00:00:00.000+0000</td><td>609</td><td>12</td></tr><tr><td>2022-08-01T00:00:00.000+0000</td><td>3368</td><td>124</td></tr><tr><td>2022-08-02T00:00:00.000+0000</td><td>2832</td><td>80</td></tr><tr><td>2022-08-03T00:00:00.000+0000</td><td>1538</td><td>51</td></tr><tr><td>2022-08-04T00:00:00.000+0000</td><td>1951</td><td>44</td></tr><tr><td>2022-01-24T00:00:00.000+0000</td><td>260</td><td>7</td></tr><tr><td>2022-01-25T00:00:00.000+0000</td><td>594</td><td>20</td></tr><tr><td>2022-01-26T00:00:00.000+0000</td><td>194</td><td>5</td></tr><tr><td>2022-01-27T00:00:00.000+0000</td><td>101</td><td>0</td></tr><tr><td>2022-01-28T00:00:00.000+0000</td><td>371</td><td>16</td></tr><tr><td>2022-01-29T00:00:00.000+0000</td><td>170</td><td>4</td></tr><tr><td>2022-01-30T00:00:00.000+0000</td><td>145</td><td>7</td></tr><tr><td>2022-01-31T00:00:00.000+0000</td><td>126</td><td>2</td></tr><tr><td>2022-02-01T00:00:00.000+0000</td><td>146</td><td>4</td></tr><tr><td>2022-02-02T00:00:00.000+0000</td><td>122</td><td>3</td></tr><tr><td>2022-02-03T00:00:00.000+0000</td><td>261</td><td>8</td></tr><tr><td>2022-02-04T00:00:00.000+0000</td><td>810</td><td>21</td></tr><tr><td>2022-02-05T00:00:00.000+0000</td><td>485</td><td>10</td></tr><tr><td>2022-02-06T00:00:00.000+0000</td><td>610</td><td>24</td></tr><tr><td>2022-02-07T00:00:00.000+0000</td><td>493</td><td>14</td></tr><tr><td>2022-02-08T00:00:00.000+0000</td><td>511</td><td>12</td></tr><tr><td>2022-02-09T00:00:00.000+0000</td><td>395</td><td>14</td></tr><tr><td>2022-02-10T00:00:00.000+0000</td><td>385</td><td>16</td></tr><tr><td>2022-02-11T00:00:00.000+0000</td><td>261</td><td>5</td></tr><tr><td>2022-02-12T00:00:00.000+0000</td><td>170</td><td>6</td></tr><tr><td>2022-02-13T00:00:00.000+0000</td><td>108</td><td>3</td></tr><tr><td>2022-02-14T00:00:00.000+0000</td><td>436</td><td>11</td></tr><tr><td>2022-02-15T00:00:00.000+0000</td><td>598</td><td>27</td></tr><tr><td>2022-02-16T00:00:00.000+0000</td><td>251</td><td>5</td></tr><tr><td>2022-02-17T00:00:00.000+0000</td><td>414</td><td>8</td></tr><tr><td>2022-02-18T00:00:00.000+0000</td><td>1173</td><td>46</td></tr><tr><td>2022-02-19T00:00:00.000+0000</td><td>274</td><td>10</td></tr><tr><td>2022-02-20T00:00:00.000+0000</td><td>185</td><td>5</td></tr><tr><td>2022-02-21T00:00:00.000+0000</td><td>467</td><td>12</td></tr><tr><td>2022-02-22T00:00:00.000+0000</td><td>660</td><td>31</td></tr><tr><td>2022-02-23T00:00:00.000+0000</td><td>511</td><td>16</td></tr><tr><td>2022-02-24T00:00:00.000+0000</td><td>699</td><td>20</td></tr><tr><td>2022-02-25T00:00:00.000+0000</td><td>278</td><td>13</td></tr><tr><td>2022-02-26T00:00:00.000+0000</td><td>129</td><td>10</td></tr><tr><td>2022-02-27T00:00:00.000+0000</td><td>86</td><td>2</td></tr><tr><td>2022-02-28T00:00:00.000+0000</td><td>83</td><td>2</td></tr><tr><td>2022-03-01T00:00:00.000+0000</td><td>103</td><td>2</td></tr><tr><td>2022-03-02T00:00:00.000+0000</td><td>45</td><td>0</td></tr><tr><td>2022-03-03T00:00:00.000+0000</td><td>49</td><td>1</td></tr><tr><td>2022-03-04T00:00:00.000+0000</td><td>373</td><td>12</td></tr><tr><td>2022-03-05T00:00:00.000+0000</td><td>128</td><td>3</td></tr><tr><td>2022-03-06T00:00:00.000+0000</td><td>398</td><td>11</td></tr><tr><td>2022-03-07T00:00:00.000+0000</td><td>862</td><td>27</td></tr><tr><td>2022-03-08T00:00:00.000+0000</td><td>789</td><td>27</td></tr><tr><td>2022-03-09T00:00:00.000+0000</td><td>1309</td><td>29</td></tr><tr><td>2022-03-10T00:00:00.000+0000</td><td>811</td><td>18</td></tr><tr><td>2022-03-11T00:00:00.000+0000</td><td>825</td><td>23</td></tr><tr><td>2022-03-12T00:00:00.000+0000</td><td>344</td><td>9</td></tr><tr><td>2022-03-13T00:00:00.000+0000</td><td>532</td><td>9</td></tr><tr><td>2022-03-14T00:00:00.000+0000</td><td>1370</td><td>39</td></tr><tr><td>2022-03-15T00:00:00.000+0000</td><td>1269</td><td>29</td></tr><tr><td>2022-03-16T00:00:00.000+0000</td><td>854</td><td>30</td></tr><tr><td>2022-03-17T00:00:00.000+0000</td><td>1744</td><td>42</td></tr><tr><td>2022-03-18T00:00:00.000+0000</td><td>1058</td><td>22</td></tr><tr><td>2022-03-19T00:00:00.000+0000</td><td>319</td><td>4</td></tr><tr><td>2022-03-20T00:00:00.000+0000</td><td>301</td><td>7</td></tr><tr><td>2022-03-21T00:00:00.000+0000</td><td>928</td><td>35</td></tr><tr><td>2022-03-22T00:00:00.000+0000</td><td>1369</td><td>38</td></tr><tr><td>2022-03-23T00:00:00.000+0000</td><td>932</td><td>28</td></tr><tr><td>2022-03-24T00:00:00.000+0000</td><td>1340</td><td>43</td></tr><tr><td>2022-03-25T00:00:00.000+0000</td><td>1235</td><td>22</td></tr><tr><td>2022-03-26T00:00:00.000+0000</td><td>508</td><td>8</td></tr><tr><td>2022-03-27T00:00:00.000+0000</td><td>379</td><td>8</td></tr><tr><td>2022-03-28T00:00:00.000+0000</td><td>1165</td><td>39</td></tr><tr><td>2022-03-29T00:00:00.000+0000</td><td>1528</td><td>46</td></tr><tr><td>2022-03-30T00:00:00.000+0000</td><td>1674</td><td>41</td></tr><tr><td>2022-03-31T00:00:00.000+0000</td><td>1214</td><td>33</td></tr><tr><td>2022-04-01T00:00:00.000+0000</td><td>1074</td><td>35</td></tr><tr><td>2022-04-02T00:00:00.000+0000</td><td>1044</td><td>20</td></tr><tr><td>2022-04-03T00:00:00.000+0000</td><td>452</td><td>4</td></tr><tr><td>2022-04-04T00:00:00.000+0000</td><td>1244</td><td>32</td></tr><tr><td>2022-04-05T00:00:00.000+0000</td><td>1008</td><td>22</td></tr><tr><td>2022-04-06T00:00:00.000+0000</td><td>672</td><td>23</td></tr><tr><td>2022-04-07T00:00:00.000+0000</td><td>938</td><td>19</td></tr><tr><td>2022-04-08T00:00:00.000+0000</td><td>685</td><td>17</td></tr><tr><td>2022-04-09T00:00:00.000+0000</td><td>193</td><td>3</td></tr><tr><td>2022-04-10T00:00:00.000+0000</td><td>228</td><td>8</td></tr><tr><td>2022-04-11T00:00:00.000+0000</td><td>939</td><td>33</td></tr><tr><td>2022-04-12T00:00:00.000+0000</td><td>1158</td><td>22</td></tr><tr><td>2022-04-13T00:00:00.000+0000</td><td>1179</td><td>36</td></tr><tr><td>2022-04-14T00:00:00.000+0000</td><td>1534</td><td>41</td></tr><tr><td>2022-04-15T00:00:00.000+0000</td><td>958</td><td>28</td></tr><tr><td>2022-04-16T00:00:00.000+0000</td><td>407</td><td>11</td></tr><tr><td>2022-04-17T00:00:00.000+0000</td><td>241</td><td>3</td></tr><tr><td>2022-04-18T00:00:00.000+0000</td><td>635</td><td>12</td></tr><tr><td>2022-04-19T00:00:00.000+0000</td><td>608</td><td>15</td></tr><tr><td>2022-04-20T00:00:00.000+0000</td><td>773</td><td>26</td></tr><tr><td>2022-04-21T00:00:00.000+0000</td><td>1750</td><td>78</td></tr><tr><td>2022-04-22T00:00:00.000+0000</td><td>1658</td><td>51</td></tr><tr><td>2022-04-23T00:00:00.000+0000</td><td>555</td><td>11</td></tr><tr><td>2022-04-24T00:00:00.000+0000</td><td>320</td><td>9</td></tr><tr><td>2022-04-25T00:00:00.000+0000</td><td>712</td><td>19</td></tr><tr><td>2022-04-26T00:00:00.000+0000</td><td>1106</td><td>30</td></tr><tr><td>2022-04-27T00:00:00.000+0000</td><td>2143</td><td>55</td></tr><tr><td>2022-04-28T00:00:00.000+0000</td><td>1538</td><td>48</td></tr><tr><td>2022-04-29T00:00:00.000+0000</td><td>1284</td><td>33</td></tr><tr><td>2022-04-30T00:00:00.000+0000</td><td>828</td><td>14</td></tr><tr><td>2022-05-01T00:00:00.000+0000</td><td>473</td><td>3</td></tr><tr><td>2022-05-02T00:00:00.000+0000</td><td>778</td><td>18</td></tr><tr><td>2022-05-03T00:00:00.000+0000</td><td>670</td><td>11</td></tr><tr><td>2022-05-04T00:00:00.000+0000</td><td>794</td><td>22</td></tr><tr><td>2022-05-05T00:00:00.000+0000</td><td>1040</td><td>30</td></tr><tr><td>2021-10-14T00:00:00.000+0000</td><td>13</td><td>1</td></tr><tr><td>2021-10-15T00:00:00.000+0000</td><td>18</td><td>1</td></tr><tr><td>2021-10-16T00:00:00.000+0000</td><td>9</td><td>0</td></tr><tr><td>2021-10-17T00:00:00.000+0000</td><td>14</td><td>0</td></tr><tr><td>2021-10-18T00:00:00.000+0000</td><td>5</td><td>0</td></tr><tr><td>2021-10-19T00:00:00.000+0000</td><td>4</td><td>0</td></tr><tr><td>2021-10-20T00:00:00.000+0000</td><td>26</td><td>2</td></tr><tr><td>2021-10-21T00:00:00.000+0000</td><td>7</td><td>0</td></tr><tr><td>2021-10-22T00:00:00.000+0000</td><td>1</td><td>0</td></tr><tr><td>2021-10-23T00:00:00.000+0000</td><td>183</td><td>8</td></tr><tr><td>2021-10-24T00:00:00.000+0000</td><td>80</td><td>0</td></tr><tr><td>2021-10-25T00:00:00.000+0000</td><td>21</td><td>0</td></tr><tr><td>2021-10-26T00:00:00.000+0000</td><td>22</td><td>1</td></tr><tr><td>2021-10-27T00:00:00.000+0000</td><td>153</td><td>9</td></tr><tr><td>2021-10-28T00:00:00.000+0000</td><td>56</td><td>5</td></tr><tr><td>2021-10-29T00:00:00.000+0000</td><td>30</td><td>2</td></tr><tr><td>2021-10-30T00:00:00.000+0000</td><td>8</td><td>0</td></tr><tr><td>2021-10-31T00:00:00.000+0000</td><td>18</td><td>3</td></tr><tr><td>2021-11-01T00:00:00.000+0000</td><td>457</td><td>14</td></tr><tr><td>2021-11-02T00:00:00.000+0000</td><td>652</td><td>22</td></tr><tr><td>2021-11-03T00:00:00.000+0000</td><td>371</td><td>9</td></tr><tr><td>2021-11-04T00:00:00.000+0000</td><td>586</td><td>13</td></tr><tr><td>2021-11-05T00:00:00.000+0000</td><td>125</td><td>1</td></tr><tr><td>2021-11-06T00:00:00.000+0000</td><td>62</td><td>2</td></tr><tr><td>2021-11-07T00:00:00.000+0000</td><td>55</td><td>0</td></tr><tr><td>2021-11-08T00:00:00.000+0000</td><td>520</td><td>17</td></tr><tr><td>2021-11-09T00:00:00.000+0000</td><td>143</td><td>1</td></tr><tr><td>2021-11-10T00:00:00.000+0000</td><td>59</td><td>2</td></tr><tr><td>2021-11-11T00:00:00.000+0000</td><td>44</td><td>1</td></tr><tr><td>2021-11-12T00:00:00.000+0000</td><td>262</td><td>7</td></tr><tr><td>2021-11-13T00:00:00.000+0000</td><td>69</td><td>1</td></tr><tr><td>2021-11-14T00:00:00.000+0000</td><td>29</td><td>0</td></tr><tr><td>2021-11-15T00:00:00.000+0000</td><td>59</td><td>1</td></tr><tr><td>2021-11-16T00:00:00.000+0000</td><td>375</td><td>9</td></tr><tr><td>2021-11-17T00:00:00.000+0000</td><td>117</td><td>6</td></tr><tr><td>2021-11-18T00:00:00.000+0000</td><td>62</td><td>3</td></tr><tr><td>2021-11-19T00:00:00.000+0000</td><td>1178</td><td>50</td></tr><tr><td>2021-11-20T00:00:00.000+0000</td><td>363</td><td>12</td></tr><tr><td>2021-11-21T00:00:00.000+0000</td><td>180</td><td>2</td></tr><tr><td>2021-11-22T00:00:00.000+0000</td><td>400</td><td>8</td></tr><tr><td>2021-11-23T00:00:00.000+0000</td><td>718</td><td>26</td></tr><tr><td>2021-11-24T00:00:00.000+0000</td><td>489</td><td>10</td></tr><tr><td>2021-11-25T00:00:00.000+0000</td><td>119</td><td>2</td></tr><tr><td>2021-11-26T00:00:00.000+0000</td><td>118</td><td>2</td></tr><tr><td>2021-11-27T00:00:00.000+0000</td><td>91</td><td>2</td></tr><tr><td>2021-11-28T00:00:00.000+0000</td><td>86</td><td>0</td></tr><tr><td>2021-11-29T00:00:00.000+0000</td><td>800</td><td>20</td></tr><tr><td>2021-11-30T00:00:00.000+0000</td><td>227</td><td>5</td></tr><tr><td>2021-12-01T00:00:00.000+0000</td><td>118</td><td>2</td></tr><tr><td>2021-12-02T00:00:00.000+0000</td><td>540</td><td>18</td></tr><tr><td>2021-12-03T00:00:00.000+0000</td><td>101</td><td>3</td></tr><tr><td>2021-12-04T00:00:00.000+0000</td><td>35</td><td>0</td></tr><tr><td>2021-12-05T00:00:00.000+0000</td><td>40</td><td>0</td></tr><tr><td>2021-12-06T00:00:00.000+0000</td><td>668</td><td>21</td></tr><tr><td>2021-12-07T00:00:00.000+0000</td><td>474</td><td>7</td></tr><tr><td>2021-12-08T00:00:00.000+0000</td><td>135</td><td>7</td></tr><tr><td>2021-12-09T00:00:00.000+0000</td><td>194</td><td>8</td></tr><tr><td>2021-12-10T00:00:00.000+0000</td><td>95</td><td>4</td></tr><tr><td>2021-12-11T00:00:00.000+0000</td><td>486</td><td>17</td></tr><tr><td>2021-12-12T00:00:00.000+0000</td><td>0</td><td>6</td></tr><tr><td>2021-12-13T00:00:00.000+0000</td><td>101</td><td>5</td></tr><tr><td>2021-12-14T00:00:00.000+0000</td><td>2241</td><td>40</td></tr><tr><td>2021-12-15T00:00:00.000+0000</td><td>504</td><td>7</td></tr><tr><td>2021-12-16T00:00:00.000+0000</td><td>235</td><td>3</td></tr><tr><td>2021-12-17T00:00:00.000+0000</td><td>107</td><td>2</td></tr><tr><td>2021-12-18T00:00:00.000+0000</td><td>143</td><td>3</td></tr><tr><td>2021-12-19T00:00:00.000+0000</td><td>86</td><td>2</td></tr><tr><td>2021-12-20T00:00:00.000+0000</td><td>375</td><td>10</td></tr><tr><td>2021-12-21T00:00:00.000+0000</td><td>194</td><td>3</td></tr><tr><td>2021-12-22T00:00:00.000+0000</td><td>1376</td><td>49</td></tr><tr><td>2021-12-23T00:00:00.000+0000</td><td>387</td><td>6</td></tr><tr><td>2021-12-24T00:00:00.000+0000</td><td>346</td><td>9</td></tr><tr><td>2021-12-25T00:00:00.000+0000</td><td>186</td><td>3</td></tr><tr><td>2021-12-26T00:00:00.000+0000</td><td>93</td><td>1</td></tr><tr><td>2021-12-27T00:00:00.000+0000</td><td>755</td><td>32</td></tr><tr><td>2021-12-28T00:00:00.000+0000</td><td>2318</td><td>50</td></tr><tr><td>2021-12-29T00:00:00.000+0000</td><td>406</td><td>11</td></tr><tr><td>2021-12-30T00:00:00.000+0000</td><td>266</td><td>11</td></tr><tr><td>2021-12-31T00:00:00.000+0000</td><td>170</td><td>3</td></tr><tr><td>2022-01-01T00:00:00.000+0000</td><td>140</td><td>0</td></tr><tr><td>2022-01-02T00:00:00.000+0000</td><td>144</td><td>2</td></tr><tr><td>2022-01-03T00:00:00.000+0000</td><td>1393</td><td>32</td></tr><tr><td>2022-01-04T00:00:00.000+0000</td><td>675</td><td>12</td></tr><tr><td>2022-01-05T00:00:00.000+0000</td><td>344</td><td>6</td></tr><tr><td>2022-01-06T00:00:00.000+0000</td><td>458</td><td>5</td></tr><tr><td>2022-01-07T00:00:00.000+0000</td><td>239</td><td>9</td></tr><tr><td>2022-01-08T00:00:00.000+0000</td><td>179</td><td>9</td></tr><tr><td>2022-01-09T00:00:00.000+0000</td><td>138</td><td>2</td></tr><tr><td>2022-01-10T00:00:00.000+0000</td><td>212</td><td>5</td></tr><tr><td>2022-01-11T00:00:00.000+0000</td><td>709</td><td>17</td></tr><tr><td>2022-01-12T00:00:00.000+0000</td><td>254</td><td>3</td></tr><tr><td>2022-01-13T00:00:00.000+0000</td><td>479</td><td>16</td></tr><tr><td>2022-01-14T00:00:00.000+0000</td><td>198</td><td>5</td></tr><tr><td>2022-01-15T00:00:00.000+0000</td><td>155</td><td>1</td></tr><tr><td>2022-01-16T00:00:00.000+0000</td><td>93</td><td>0</td></tr><tr><td>2022-01-17T00:00:00.000+0000</td><td>481</td><td>15</td></tr><tr><td>2022-01-18T00:00:00.000+0000</td><td>102</td><td>2</td></tr><tr><td>2022-01-19T00:00:00.000+0000</td><td>1149</td><td>64</td></tr><tr><td>2022-01-20T00:00:00.000+0000</td><td>457</td><td>17</td></tr><tr><td>2022-01-21T00:00:00.000+0000</td><td>143</td><td>8</td></tr><tr><td>2022-01-22T00:00:00.000+0000</td><td>91</td><td>7</td></tr><tr><td>2022-01-23T00:00:00.000+0000</td><td>68</td><td>0</td></tr><tr><td>2021-07-04T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-05T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-06T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-07T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-08T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-09T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-10T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-11T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-12T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-13T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-14T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-15T00:00:00.000+0000</td><td>1</td><td>0</td></tr><tr><td>2021-07-16T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-17T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-18T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-19T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-20T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-21T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-22T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-23T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-24T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-25T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-26T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-27T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-28T00:00:00.000+0000</td><td>0</td><td>0</td></tr><tr><td>2021-07-29T00:00:00.000+0000</td><td>142</td><td>4</td></tr><tr><td>2021-07-30T00:00:00.000+0000</td><td>575</td><td>20</td></tr><tr><td>2021-07-31T00:00:00.000+0000</td><td>98</td><td>3</td></tr><tr><td>2021-08-01T00:00:00.000+0000</td><td>190</td><td>4</td></tr><tr><td>2021-08-02T00:00:00.000+0000</td><td>164</td><td>6</td></tr><tr><td>2021-08-03T00:00:00.000+0000</td><td>103</td><td>1</td></tr><tr><td>2021-08-04T00:00:00.000+0000</td><td>100</td><td>0</td></tr><tr><td>2021-08-05T00:00:00.000+0000</td><td>66</td><td>0</td></tr><tr><td>2021-08-06T00:00:00.000+0000</td><td>15</td><td>0</td></tr><tr><td>2021-08-07T00:00:00.000+0000</td><td>144</td><td>0</td></tr><tr><td>2021-08-08T00:00:00.000+0000</td><td>301</td><td>10</td></tr><tr><td>2021-08-09T00:00:00.000+0000</td><td>265</td><td>10</td></tr><tr><td>2021-08-10T00:00:00.000+0000</td><td>295</td><td>12</td></tr><tr><td>2021-08-11T00:00:00.000+0000</td><td>70</td><td>0</td></tr><tr><td>2021-08-12T00:00:00.000+0000</td><td>29</td><td>1</td></tr><tr><td>2021-08-13T00:00:00.000+0000</td><td>26</td><td>1</td></tr><tr><td>2021-08-14T00:00:00.000+0000</td><td>10</td><td>0</td></tr><tr><td>2021-08-15T00:00:00.000+0000</td><td>8</td><td>0</td></tr><tr><td>2021-08-16T00:00:00.000+0000</td><td>20</td><td>1</td></tr><tr><td>2021-08-17T00:00:00.000+0000</td><td>20</td><td>2</td></tr><tr><td>2021-08-18T00:00:00.000+0000</td><td>26</td><td>4</td></tr><tr><td>2021-08-19T00:00:00.000+0000</td><td>770</td><td>49</td></tr><tr><td>2021-08-20T00:00:00.000+0000</td><td>520</td><td>20</td></tr><tr><td>2021-08-21T00:00:00.000+0000</td><td>320</td><td>8</td></tr><tr><td>2021-08-22T00:00:00.000+0000</td><td>121</td><td>9</td></tr><tr><td>2021-08-23T00:00:00.000+0000</td><td>486</td><td>26</td></tr><tr><td>2021-08-24T00:00:00.000+0000</td><td>137</td><td>2</td></tr><tr><td>2021-08-25T00:00:00.000+0000</td><td>138</td><td>5</td></tr><tr><td>2021-08-26T00:00:00.000+0000</td><td>69</td><td>3</td></tr><tr><td>2021-08-27T00:00:00.000+0000</td><td>50</td><td>1</td></tr><tr><td>2021-08-28T00:00:00.000+0000</td><td>42</td><td>0</td></tr><tr><td>2021-08-29T00:00:00.000+0000</td><td>50</td><td>3</td></tr><tr><td>2021-08-30T00:00:00.000+0000</td><td>289</td><td>11</td></tr><tr><td>2021-08-31T00:00:00.000+0000</td><td>314</td><td>15</td></tr><tr><td>2021-09-01T00:00:00.000+0000</td><td>111</td><td>4</td></tr><tr><td>2021-09-02T00:00:00.000+0000</td><td>252</td><td>10</td></tr><tr><td>2021-09-03T00:00:00.000+0000</td><td>391</td><td>21</td></tr><tr><td>2021-09-04T00:00:00.000+0000</td><td>79</td><td>4</td></tr><tr><td>2021-09-05T00:00:00.000+0000</td><td>66</td><td>3</td></tr><tr><td>2021-09-06T00:00:00.000+0000</td><td>54</td><td>1</td></tr><tr><td>2021-09-07T00:00:00.000+0000</td><td>40</td><td>0</td></tr><tr><td>2021-09-08T00:00:00.000+0000</td><td>122</td><td>3</td></tr><tr><td>2021-09-09T00:00:00.000+0000</td><td>45</td><td>4</td></tr><tr><td>2021-09-10T00:00:00.000+0000</td><td>336</td><td>12</td></tr><tr><td>2021-09-11T00:00:00.000+0000</td><td>45</td><td>1</td></tr><tr><td>2021-09-12T00:00:00.000+0000</td><td>29</td><td>1</td></tr><tr><td>2021-09-13T00:00:00.000+0000</td><td>88</td><td>0</td></tr><tr><td>2021-09-14T00:00:00.000+0000</td><td>611</td><td>6</td></tr><tr><td>2021-09-15T00:00:00.000+0000</td><td>119</td><td>4</td></tr><tr><td>2021-09-16T00:00:00.000+0000</td><td>897</td><td>23</td></tr><tr><td>2021-09-17T00:00:00.000+0000</td><td>225</td><td>3</td></tr><tr><td>2021-09-18T00:00:00.000+0000</td><td>94</td><td>0</td></tr><tr><td>2021-09-19T00:00:00.000+0000</td><td>931</td><td>31</td></tr><tr><td>2021-09-20T00:00:00.000+0000</td><td>375</td><td>7</td></tr><tr><td>2021-09-21T00:00:00.000+0000</td><td>87</td><td>0</td></tr><tr><td>2021-09-22T00:00:00.000+0000</td><td>158</td><td>3</td></tr><tr><td>2021-09-23T00:00:00.000+0000</td><td>81</td><td>3</td></tr><tr><td>2021-09-24T00:00:00.000+0000</td><td>406</td><td>18</td></tr><tr><td>2021-09-25T00:00:00.000+0000</td><td>127</td><td>0</td></tr><tr><td>2021-09-26T00:00:00.000+0000</td><td>291</td><td>10</td></tr><tr><td>2021-09-27T00:00:00.000+0000</td><td>284</td><td>5</td></tr><tr><td>2021-09-28T00:00:00.000+0000</td><td>91</td><td>4</td></tr><tr><td>2021-09-29T00:00:00.000+0000</td><td>29</td><td>1</td></tr><tr><td>2021-09-30T00:00:00.000+0000</td><td>340</td><td>9</td></tr><tr><td>2021-10-01T00:00:00.000+0000</td><td>84</td><td>0</td></tr><tr><td>2021-10-02T00:00:00.000+0000</td><td>29</td><td>0</td></tr><tr><td>2021-10-03T00:00:00.000+0000</td><td>29</td><td>0</td></tr><tr><td>2021-10-04T00:00:00.000+0000</td><td>46</td><td>0</td></tr><tr><td>2021-10-05T00:00:00.000+0000</td><td>35</td><td>0</td></tr><tr><td>2021-10-06T00:00:00.000+0000</td><td>17</td><td>0</td></tr><tr><td>2021-10-07T00:00:00.000+0000</td><td>736</td><td>20</td></tr><tr><td>2021-10-08T00:00:00.000+0000</td><td>241</td><td>6</td></tr><tr><td>2021-10-09T00:00:00.000+0000</td><td>80</td><td>2</td></tr><tr><td>2021-10-10T00:00:00.000+0000</td><td>74</td><td>0</td></tr><tr><td>2021-10-11T00:00:00.000+0000</td><td>42</td><td>1</td></tr><tr><td>2021-10-12T00:00:00.000+0000</td><td>31</td><td>3</td></tr><tr><td>2021-10-13T00:00:00.000+0000</td><td>21</td><td>0</td></tr></tbody></table></div>"]}}],"execution_count":0},{"cell_type":"code","source":[""],"metadata":{"application/vnd.databricks.v1+cell":{"title":"","showTitle":false,"inputWidgets":{},"nuid":"f3008f5f-1cd7-45f9-8157-1d7313b24f66"}},"outputs":[],"execution_count":0}],"metadata":{"application/vnd.databricks.v1+notebook":{"notebookName":"02-Remove-Duplicates-Data","dashboards":[],"notebookMetadata":{"pythonIndentUnit":4},"language":"python","widgets":{},"notebookOrigID":3070776618390875}},"nbformat":4,"nbformat_minor":0}