Skip to content

Instantly share code, notes, and snippets.

@MathewBiddle

MathewBiddle/filter_for_first_row_in_hour.ipynb

Created November 8, 2023 16:56
Show Gist options
  • Save MathewBiddle/d434ac2b538b2728aa80c6a7945f94be to your computer and use it in GitHub Desktop.
Save MathewBiddle/d434ac2b538b2728aa80c6a7945f94be to your computer and use it in GitHub Desktop.
Download ZIP
filter_for_first_row_in_hour.ipynb
Display the source blob
Display the rendered blob
Raw
filter_for_first_row_in_hour.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"provenance": [],
"authorship_tag": "ABX9TyMt5gNCvQ9J1h5Gmhcb3mf2",
"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/MathewBiddle/d434ac2b538b2728aa80c6a7945f94be/filter_for_first_row_in_hour.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": "GN7tVfIDt9Pw"
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"source": [
"data = [\n",
"\"2009-09-23T00:00:00Z\",\n",
"\"2009-09-25T06:42:00Z\",\n",
"\"2009-09-25T11:09:00Z\",\n",
"\"2009-09-25T11:11:00Z\",\n",
"\"2009-09-27T17:58:00Z\",\n",
"\"2009-09-30T05:01:00Z\",\n",
"\"2009-10-08T20:24:00Z\",\n",
"\"2009-10-15T11:05:00Z\",\n",
"\"2009-10-17T06:11:00Z\",\n",
"\"2009-10-17T09:00:00Z\",\n",
"\"2009-10-17T10:38:00Z\",\n",
"\"2009-10-18T08:48:00Z\",\n",
"\"2009-10-18T10:26:00Z\",\n",
"\"2009-10-18T11:15:00Z\",\n",
"\"2009-10-19T10:20:00Z\",\n",
"\"2009-10-23T23:52:00Z\",\n",
"\"2009-10-24T00:06:00Z\",\n",
"\"2009-10-26T10:53:00Z\",\n",
"\"2009-10-26T11:22:00Z\",\n",
"\"2009-10-27T16:21:00Z\",\n",
"\"2009-10-27T16:22:00Z\",\n",
"\"2009-10-29T11:53:00Z\",\n",
"\"2009-10-30T10:03:00Z\",\n",
"\"2009-10-31T19:48:00Z\",\n",
"\"2009-10-31T21:15:00Z\",\n",
"\"2009-11-01T21:04:00Z\",\n",
"\"2009-11-06T17:53:00Z\",\n",
"\"2009-11-13T18:48:00Z\",\n",
"\"2009-11-23T05:12:00Z\"\n",
" ]\n",
"\n",
"\n",
"df = pd.DataFrame({'time':data})\n",
"\n",
"df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 959
},
"id": "eweTDPuouJSP",
"outputId": "a27ba4ff-0736-4e41-cab1-3c2a0b505d8f"
},
"execution_count": 2,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" time\n",
"0 2009-09-23T00:00:00Z\n",
"1 2009-09-25T06:42:00Z\n",
"2 2009-09-25T11:09:00Z\n",
"3 2009-09-25T11:11:00Z\n",
"4 2009-09-27T17:58:00Z\n",
"5 2009-09-30T05:01:00Z\n",
"6 2009-10-08T20:24:00Z\n",
"7 2009-10-15T11:05:00Z\n",
"8 2009-10-17T06:11:00Z\n",
"9 2009-10-17T09:00:00Z\n",
"10 2009-10-17T10:38:00Z\n",
"11 2009-10-18T08:48:00Z\n",
"12 2009-10-18T10:26:00Z\n",
"13 2009-10-18T11:15:00Z\n",
"14 2009-10-19T10:20:00Z\n",
"15 2009-10-23T23:52:00Z\n",
"16 2009-10-24T00:06:00Z\n",
"17 2009-10-26T10:53:00Z\n",
"18 2009-10-26T11:22:00Z\n",
"19 2009-10-27T16:21:00Z\n",
"20 2009-10-27T16:22:00Z\n",
"21 2009-10-29T11:53:00Z\n",
"22 2009-10-30T10:03:00Z\n",
"23 2009-10-31T19:48:00Z\n",
"24 2009-10-31T21:15:00Z\n",
"25 2009-11-01T21:04:00Z\n",
"26 2009-11-06T17:53:00Z\n",
"27 2009-11-13T18:48:00Z\n",
"28 2009-11-23T05:12:00Z"
],
"text/html": [
"\n",
" <div id=\"df-9bcecd80-c8c6-48ec-bf3f-95637e820264\" 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>time</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009-09-23T00:00:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2009-09-25T06:42:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2009-09-25T11:09:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2009-09-25T11:11:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2009-09-27T17:58:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>2009-09-30T05:01:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>2009-10-08T20:24:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2009-10-15T11:05:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>2009-10-17T06:11:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>2009-10-17T09:00:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>2009-10-17T10:38:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>2009-10-18T08:48:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>2009-10-18T10:26:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>2009-10-18T11:15:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>2009-10-19T10:20:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>2009-10-23T23:52:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>2009-10-24T00:06:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>2009-10-26T10:53:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>2009-10-26T11:22:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>2009-10-27T16:21:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>2009-10-27T16:22:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>2009-10-29T11:53:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>2009-10-30T10:03:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>2009-10-31T19:48:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>2009-10-31T21:15:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>2009-11-01T21:04:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>2009-11-06T17:53:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>2009-11-13T18:48:00Z</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>2009-11-23T05:12:00Z</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <div class=\"colab-df-buttons\">\n",
"\n",
" <div class=\"colab-df-container\">\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9bcecd80-c8c6-48ec-bf3f-95637e820264')\"\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 -960 960 960\">\n",
" <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
" </svg>\n",
" </button>\n",
"\n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\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",
" .colab-df-buttons div {\n",
" margin-bottom: 4px;\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-9bcecd80-c8c6-48ec-bf3f-95637e820264 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-9bcecd80-c8c6-48ec-bf3f-95637e820264');\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",
"\n",
"\n",
"<div id=\"df-d63535c6-de98-480b-92c9-a15826047be4\">\n",
" <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d63535c6-de98-480b-92c9-a15826047be4')\"\n",
" title=\"Suggest charts\"\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",
" <g>\n",
" <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
" </g>\n",
"</svg>\n",
" </button>\n",
"\n",
"<style>\n",
" .colab-df-quickchart {\n",
" --bg-color: #E8F0FE;\n",
" --fill-color: #1967D2;\n",
" --hover-bg-color: #E2EBFA;\n",
" --hover-fill-color: #174EA6;\n",
" --disabled-fill-color: #AAA;\n",
" --disabled-bg-color: #DDD;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-quickchart {\n",
" --bg-color: #3B4455;\n",
" --fill-color: #D2E3FC;\n",
" --hover-bg-color: #434B5C;\n",
" --hover-fill-color: #FFFFFF;\n",
" --disabled-bg-color: #3B4455;\n",
" --disabled-fill-color: #666;\n",
" }\n",
"\n",
" .colab-df-quickchart {\n",
" background-color: var(--bg-color);\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: var(--fill-color);\n",
" height: 32px;\n",
" padding: 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-quickchart:hover {\n",
" background-color: var(--hover-bg-color);\n",
" box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: var(--button-hover-fill-color);\n",
" }\n",
"\n",
" .colab-df-quickchart-complete:disabled,\n",
" .colab-df-quickchart-complete:disabled:hover {\n",
" background-color: var(--disabled-bg-color);\n",
" fill: var(--disabled-fill-color);\n",
" box-shadow: none;\n",
" }\n",
"\n",
" .colab-df-spinner {\n",
" border: 2px solid var(--fill-color);\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" animation:\n",
" spin 1s steps(1) infinite;\n",
" }\n",
"\n",
" @keyframes spin {\n",
" 0% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" border-left-color: var(--fill-color);\n",
" }\n",
" 20% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 30% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 40% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 60% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 80% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" 90% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" }\n",
"</style>\n",
"\n",
" <script>\n",
" async function quickchart(key) {\n",
" const quickchartButtonEl =\n",
" document.querySelector('#' + key + ' button');\n",
" quickchartButtonEl.disabled = true; // To prevent multiple clicks.\n",
" quickchartButtonEl.classList.add('colab-df-spinner');\n",
" try {\n",
" const charts = await google.colab.kernel.invokeFunction(\n",
" 'suggestCharts', [key], {});\n",
" } catch (error) {\n",
" console.error('Error during call to suggestCharts:', error);\n",
" }\n",
" quickchartButtonEl.classList.remove('colab-df-spinner');\n",
" quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
" }\n",
" (() => {\n",
" let quickchartButtonEl =\n",
" document.querySelector('#df-d63535c6-de98-480b-92c9-a15826047be4 button');\n",
" quickchartButtonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
" })();\n",
" </script>\n",
"</div>\n",
" </div>\n",
" </div>\n"
]
},
"metadata": {},
"execution_count": 2
}
]
},
{
"cell_type": "code",
"source": [
"df['dayhr'] = pd.to_datetime(df['time']).dt.strftime('%Y-%m-%dT%H')\n",
"\n",
"df['duplicate?']=df['dayhr'].duplicated()\n",
"\n",
"df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 959
},
"id": "Net9GU_MzkbI",
"outputId": "be2cec9e-9d06-4314-9f46-536e41a74308"
},
"execution_count": 3,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" time dayhr duplicate?\n",
"0 2009-09-23T00:00:00Z 2009-09-23T00 False\n",
"1 2009-09-25T06:42:00Z 2009-09-25T06 False\n",
"2 2009-09-25T11:09:00Z 2009-09-25T11 False\n",
"3 2009-09-25T11:11:00Z 2009-09-25T11 True\n",
"4 2009-09-27T17:58:00Z 2009-09-27T17 False\n",
"5 2009-09-30T05:01:00Z 2009-09-30T05 False\n",
"6 2009-10-08T20:24:00Z 2009-10-08T20 False\n",
"7 2009-10-15T11:05:00Z 2009-10-15T11 False\n",
"8 2009-10-17T06:11:00Z 2009-10-17T06 False\n",
"9 2009-10-17T09:00:00Z 2009-10-17T09 False\n",
"10 2009-10-17T10:38:00Z 2009-10-17T10 False\n",
"11 2009-10-18T08:48:00Z 2009-10-18T08 False\n",
"12 2009-10-18T10:26:00Z 2009-10-18T10 False\n",
"13 2009-10-18T11:15:00Z 2009-10-18T11 False\n",
"14 2009-10-19T10:20:00Z 2009-10-19T10 False\n",
"15 2009-10-23T23:52:00Z 2009-10-23T23 False\n",
"16 2009-10-24T00:06:00Z 2009-10-24T00 False\n",
"17 2009-10-26T10:53:00Z 2009-10-26T10 False\n",
"18 2009-10-26T11:22:00Z 2009-10-26T11 False\n",
"19 2009-10-27T16:21:00Z 2009-10-27T16 False\n",
"20 2009-10-27T16:22:00Z 2009-10-27T16 True\n",
"21 2009-10-29T11:53:00Z 2009-10-29T11 False\n",
"22 2009-10-30T10:03:00Z 2009-10-30T10 False\n",
"23 2009-10-31T19:48:00Z 2009-10-31T19 False\n",
"24 2009-10-31T21:15:00Z 2009-10-31T21 False\n",
"25 2009-11-01T21:04:00Z 2009-11-01T21 False\n",
"26 2009-11-06T17:53:00Z 2009-11-06T17 False\n",
"27 2009-11-13T18:48:00Z 2009-11-13T18 False\n",
"28 2009-11-23T05:12:00Z 2009-11-23T05 False"
],
"text/html": [
"\n",
" <div id=\"df-9ca6fd60-c4ad-4d99-a02e-04b383d573a9\" 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>time</th>\n",
" <th>dayhr</th>\n",
" <th>duplicate?</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009-09-23T00:00:00Z</td>\n",
" <td>2009-09-23T00</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2009-09-25T06:42:00Z</td>\n",
" <td>2009-09-25T06</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2009-09-25T11:09:00Z</td>\n",
" <td>2009-09-25T11</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2009-09-25T11:11:00Z</td>\n",
" <td>2009-09-25T11</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2009-09-27T17:58:00Z</td>\n",
" <td>2009-09-27T17</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>2009-09-30T05:01:00Z</td>\n",
" <td>2009-09-30T05</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>2009-10-08T20:24:00Z</td>\n",
" <td>2009-10-08T20</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2009-10-15T11:05:00Z</td>\n",
" <td>2009-10-15T11</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>2009-10-17T06:11:00Z</td>\n",
" <td>2009-10-17T06</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>2009-10-17T09:00:00Z</td>\n",
" <td>2009-10-17T09</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>2009-10-17T10:38:00Z</td>\n",
" <td>2009-10-17T10</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>2009-10-18T08:48:00Z</td>\n",
" <td>2009-10-18T08</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>2009-10-18T10:26:00Z</td>\n",
" <td>2009-10-18T10</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>2009-10-18T11:15:00Z</td>\n",
" <td>2009-10-18T11</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>2009-10-19T10:20:00Z</td>\n",
" <td>2009-10-19T10</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>2009-10-23T23:52:00Z</td>\n",
" <td>2009-10-23T23</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>2009-10-24T00:06:00Z</td>\n",
" <td>2009-10-24T00</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>2009-10-26T10:53:00Z</td>\n",
" <td>2009-10-26T10</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>2009-10-26T11:22:00Z</td>\n",
" <td>2009-10-26T11</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>2009-10-27T16:21:00Z</td>\n",
" <td>2009-10-27T16</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>2009-10-27T16:22:00Z</td>\n",
" <td>2009-10-27T16</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>2009-10-29T11:53:00Z</td>\n",
" <td>2009-10-29T11</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>2009-10-30T10:03:00Z</td>\n",
" <td>2009-10-30T10</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>2009-10-31T19:48:00Z</td>\n",
" <td>2009-10-31T19</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>2009-10-31T21:15:00Z</td>\n",
" <td>2009-10-31T21</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>2009-11-01T21:04:00Z</td>\n",
" <td>2009-11-01T21</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>2009-11-06T17:53:00Z</td>\n",
" <td>2009-11-06T17</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>2009-11-13T18:48:00Z</td>\n",
" <td>2009-11-13T18</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>2009-11-23T05:12:00Z</td>\n",
" <td>2009-11-23T05</td>\n",
" <td>False</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <div class=\"colab-df-buttons\">\n",
"\n",
" <div class=\"colab-df-container\">\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9ca6fd60-c4ad-4d99-a02e-04b383d573a9')\"\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 -960 960 960\">\n",
" <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
" </svg>\n",
" </button>\n",
"\n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\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",
" .colab-df-buttons div {\n",
" margin-bottom: 4px;\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-9ca6fd60-c4ad-4d99-a02e-04b383d573a9 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-9ca6fd60-c4ad-4d99-a02e-04b383d573a9');\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",
"\n",
"\n",
"<div id=\"df-92a56e0c-89b6-4d56-b8bd-1aa4e1ffe6be\">\n",
" <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-92a56e0c-89b6-4d56-b8bd-1aa4e1ffe6be')\"\n",
" title=\"Suggest charts\"\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",
" <g>\n",
" <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
" </g>\n",
"</svg>\n",
" </button>\n",
"\n",
"<style>\n",
" .colab-df-quickchart {\n",
" --bg-color: #E8F0FE;\n",
" --fill-color: #1967D2;\n",
" --hover-bg-color: #E2EBFA;\n",
" --hover-fill-color: #174EA6;\n",
" --disabled-fill-color: #AAA;\n",
" --disabled-bg-color: #DDD;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-quickchart {\n",
" --bg-color: #3B4455;\n",
" --fill-color: #D2E3FC;\n",
" --hover-bg-color: #434B5C;\n",
" --hover-fill-color: #FFFFFF;\n",
" --disabled-bg-color: #3B4455;\n",
" --disabled-fill-color: #666;\n",
" }\n",
"\n",
" .colab-df-quickchart {\n",
" background-color: var(--bg-color);\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: var(--fill-color);\n",
" height: 32px;\n",
" padding: 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-quickchart:hover {\n",
" background-color: var(--hover-bg-color);\n",
" box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: var(--button-hover-fill-color);\n",
" }\n",
"\n",
" .colab-df-quickchart-complete:disabled,\n",
" .colab-df-quickchart-complete:disabled:hover {\n",
" background-color: var(--disabled-bg-color);\n",
" fill: var(--disabled-fill-color);\n",
" box-shadow: none;\n",
" }\n",
"\n",
" .colab-df-spinner {\n",
" border: 2px solid var(--fill-color);\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" animation:\n",
" spin 1s steps(1) infinite;\n",
" }\n",
"\n",
" @keyframes spin {\n",
" 0% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" border-left-color: var(--fill-color);\n",
" }\n",
" 20% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 30% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 40% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 60% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 80% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" 90% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" }\n",
"</style>\n",
"\n",
" <script>\n",
" async function quickchart(key) {\n",
" const quickchartButtonEl =\n",
" document.querySelector('#' + key + ' button');\n",
" quickchartButtonEl.disabled = true; // To prevent multiple clicks.\n",
" quickchartButtonEl.classList.add('colab-df-spinner');\n",
" try {\n",
" const charts = await google.colab.kernel.invokeFunction(\n",
" 'suggestCharts', [key], {});\n",
" } catch (error) {\n",
" console.error('Error during call to suggestCharts:', error);\n",
" }\n",
" quickchartButtonEl.classList.remove('colab-df-spinner');\n",
" quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
" }\n",
" (() => {\n",
" let quickchartButtonEl =\n",
" document.querySelector('#df-92a56e0c-89b6-4d56-b8bd-1aa4e1ffe6be button');\n",
" quickchartButtonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
" })();\n",
" </script>\n",
"</div>\n",
" </div>\n",
" </div>\n"
]
},
"metadata": {},
"execution_count": 3
}
]
},
{
"cell_type": "code",
"source": [
"import time\n",
"import datetime\n",
"def filter_df(df):\n",
" df['dayhr'] = pd.to_datetime(df['time']).dt.strftime('%Y-%m-%dT%H')\n",
" #df['hr']=df['time'].apply(lambda x:datetime.datetime.strptime(x,'%Y-%m-%dT%H:%M:%SZ').time().hour)\n",
" df=df.groupby('dayhr').first().reset_index()\n",
" #df=df.drop('hr',axis=1)\n",
" return df\n",
"df_out=filter_df(df)\n",
"\n",
"df_out"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 896
},
"id": "QXTcpldsuD4n",
"outputId": "f7d8e19e-722a-4178-cabe-0e3fe3019721"
},
"execution_count": 4,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" dayhr time duplicate?\n",
"0 2009-09-23T00 2009-09-23T00:00:00Z False\n",
"1 2009-09-25T06 2009-09-25T06:42:00Z False\n",
"2 2009-09-25T11 2009-09-25T11:09:00Z False\n",
"3 2009-09-27T17 2009-09-27T17:58:00Z False\n",
"4 2009-09-30T05 2009-09-30T05:01:00Z False\n",
"5 2009-10-08T20 2009-10-08T20:24:00Z False\n",
"6 2009-10-15T11 2009-10-15T11:05:00Z False\n",
"7 2009-10-17T06 2009-10-17T06:11:00Z False\n",
"8 2009-10-17T09 2009-10-17T09:00:00Z False\n",
"9 2009-10-17T10 2009-10-17T10:38:00Z False\n",
"10 2009-10-18T08 2009-10-18T08:48:00Z False\n",
"11 2009-10-18T10 2009-10-18T10:26:00Z False\n",
"12 2009-10-18T11 2009-10-18T11:15:00Z False\n",
"13 2009-10-19T10 2009-10-19T10:20:00Z False\n",
"14 2009-10-23T23 2009-10-23T23:52:00Z False\n",
"15 2009-10-24T00 2009-10-24T00:06:00Z False\n",
"16 2009-10-26T10 2009-10-26T10:53:00Z False\n",
"17 2009-10-26T11 2009-10-26T11:22:00Z False\n",
"18 2009-10-27T16 2009-10-27T16:21:00Z False\n",
"19 2009-10-29T11 2009-10-29T11:53:00Z False\n",
"20 2009-10-30T10 2009-10-30T10:03:00Z False\n",
"21 2009-10-31T19 2009-10-31T19:48:00Z False\n",
"22 2009-10-31T21 2009-10-31T21:15:00Z False\n",
"23 2009-11-01T21 2009-11-01T21:04:00Z False\n",
"24 2009-11-06T17 2009-11-06T17:53:00Z False\n",
"25 2009-11-13T18 2009-11-13T18:48:00Z False\n",
"26 2009-11-23T05 2009-11-23T05:12:00Z False"
],
"text/html": [
"\n",
" <div id=\"df-6e798c43-79c2-4357-8199-2ff47ded0abc\" 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>dayhr</th>\n",
" <th>time</th>\n",
" <th>duplicate?</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009-09-23T00</td>\n",
" <td>2009-09-23T00:00:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2009-09-25T06</td>\n",
" <td>2009-09-25T06:42:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2009-09-25T11</td>\n",
" <td>2009-09-25T11:09:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2009-09-27T17</td>\n",
" <td>2009-09-27T17:58:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2009-09-30T05</td>\n",
" <td>2009-09-30T05:01:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>2009-10-08T20</td>\n",
" <td>2009-10-08T20:24:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>2009-10-15T11</td>\n",
" <td>2009-10-15T11:05:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>2009-10-17T06</td>\n",
" <td>2009-10-17T06:11:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>2009-10-17T09</td>\n",
" <td>2009-10-17T09:00:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>2009-10-17T10</td>\n",
" <td>2009-10-17T10:38:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>2009-10-18T08</td>\n",
" <td>2009-10-18T08:48:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>2009-10-18T10</td>\n",
" <td>2009-10-18T10:26:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>2009-10-18T11</td>\n",
" <td>2009-10-18T11:15:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>2009-10-19T10</td>\n",
" <td>2009-10-19T10:20:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>2009-10-23T23</td>\n",
" <td>2009-10-23T23:52:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>2009-10-24T00</td>\n",
" <td>2009-10-24T00:06:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>2009-10-26T10</td>\n",
" <td>2009-10-26T10:53:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>2009-10-26T11</td>\n",
" <td>2009-10-26T11:22:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>2009-10-27T16</td>\n",
" <td>2009-10-27T16:21:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>2009-10-29T11</td>\n",
" <td>2009-10-29T11:53:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>2009-10-30T10</td>\n",
" <td>2009-10-30T10:03:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>2009-10-31T19</td>\n",
" <td>2009-10-31T19:48:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>2009-10-31T21</td>\n",
" <td>2009-10-31T21:15:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>2009-11-01T21</td>\n",
" <td>2009-11-01T21:04:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>2009-11-06T17</td>\n",
" <td>2009-11-06T17:53:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>2009-11-13T18</td>\n",
" <td>2009-11-13T18:48:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>2009-11-23T05</td>\n",
" <td>2009-11-23T05:12:00Z</td>\n",
" <td>False</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <div class=\"colab-df-buttons\">\n",
"\n",
" <div class=\"colab-df-container\">\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-6e798c43-79c2-4357-8199-2ff47ded0abc')\"\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 -960 960 960\">\n",
" <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
" </svg>\n",
" </button>\n",
"\n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\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",
" .colab-df-buttons div {\n",
" margin-bottom: 4px;\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-6e798c43-79c2-4357-8199-2ff47ded0abc 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-6e798c43-79c2-4357-8199-2ff47ded0abc');\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",
"\n",
"\n",
"<div id=\"df-99f313bf-903a-428f-b003-5a623aab2a65\">\n",
" <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-99f313bf-903a-428f-b003-5a623aab2a65')\"\n",
" title=\"Suggest charts\"\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",
" <g>\n",
" <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
" </g>\n",
"</svg>\n",
" </button>\n",
"\n",
"<style>\n",
" .colab-df-quickchart {\n",
" --bg-color: #E8F0FE;\n",
" --fill-color: #1967D2;\n",
" --hover-bg-color: #E2EBFA;\n",
" --hover-fill-color: #174EA6;\n",
" --disabled-fill-color: #AAA;\n",
" --disabled-bg-color: #DDD;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-quickchart {\n",
" --bg-color: #3B4455;\n",
" --fill-color: #D2E3FC;\n",
" --hover-bg-color: #434B5C;\n",
" --hover-fill-color: #FFFFFF;\n",
" --disabled-bg-color: #3B4455;\n",
" --disabled-fill-color: #666;\n",
" }\n",
"\n",
" .colab-df-quickchart {\n",
" background-color: var(--bg-color);\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: var(--fill-color);\n",
" height: 32px;\n",
" padding: 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-quickchart:hover {\n",
" background-color: var(--hover-bg-color);\n",
" box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: var(--button-hover-fill-color);\n",
" }\n",
"\n",
" .colab-df-quickchart-complete:disabled,\n",
" .colab-df-quickchart-complete:disabled:hover {\n",
" background-color: var(--disabled-bg-color);\n",
" fill: var(--disabled-fill-color);\n",
" box-shadow: none;\n",
" }\n",
"\n",
" .colab-df-spinner {\n",
" border: 2px solid var(--fill-color);\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" animation:\n",
" spin 1s steps(1) infinite;\n",
" }\n",
"\n",
" @keyframes spin {\n",
" 0% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" border-left-color: var(--fill-color);\n",
" }\n",
" 20% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 30% {\n",
" border-color: transparent;\n",
" border-left-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 40% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-top-color: var(--fill-color);\n",
" }\n",
" 60% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" }\n",
" 80% {\n",
" border-color: transparent;\n",
" border-right-color: var(--fill-color);\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" 90% {\n",
" border-color: transparent;\n",
" border-bottom-color: var(--fill-color);\n",
" }\n",
" }\n",
"</style>\n",
"\n",
" <script>\n",
" async function quickchart(key) {\n",
" const quickchartButtonEl =\n",
" document.querySelector('#' + key + ' button');\n",
" quickchartButtonEl.disabled = true; // To prevent multiple clicks.\n",
" quickchartButtonEl.classList.add('colab-df-spinner');\n",
" try {\n",
" const charts = await google.colab.kernel.invokeFunction(\n",
" 'suggestCharts', [key], {});\n",
" } catch (error) {\n",
" console.error('Error during call to suggestCharts:', error);\n",
" }\n",
" quickchartButtonEl.classList.remove('colab-df-spinner');\n",
" quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
" }\n",
" (() => {\n",
" let quickchartButtonEl =\n",
" document.querySelector('#df-99f313bf-903a-428f-b003-5a623aab2a65 button');\n",
" quickchartButtonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
" })();\n",
" </script>\n",
"</div>\n",
" </div>\n",
" </div>\n"
]
},
"metadata": {},
"execution_count": 4
}
]
},
{
"cell_type": "code",
"source": [],
"metadata": {
"id": "WxsmLCV3vdG8"
},
"execution_count": 5,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment