heart_Rate.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import re\n",
    "import datetime as dt\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "com.samsung.health.heart_rate.201809031104.csv\n"
     ]
    },
    {
     "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>create_time</th>\n",
       "      <th>time_offset</th>\n",
       "      <th>max</th>\n",
       "      <th>heart_beat_count</th>\n",
       "      <th>custom</th>\n",
       "      <th>end_time</th>\n",
       "      <th>heart_rate</th>\n",
       "      <th>deviceuuid</th>\n",
       "      <th>start_time</th>\n",
       "      <th>pkg_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>min</th>\n",
       "      <th>binning_data</th>\n",
       "      <th>datauuid</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-10-11 20:55:00.587</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-10-11 20:40:29.271</td>\n",
       "      <td>58.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2017-10-11 20:40:29.271</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-10-11 20:55:00.587</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00004f1f-db81-65d8-4e7a-67d5156f6517</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-10-23 06:35:01.585</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-10-23 06:20:29.292</td>\n",
       "      <td>76.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2017-10-23 06:20:29.292</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-10-23 06:35:01.585</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00009399-20d2-d24d-6577-cd80fb670660</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-10-16 13:15:00.369</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-10-16 13:10:29.296</td>\n",
       "      <td>75.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2017-10-16 13:10:29.296</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-10-16 13:15:00.369</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0000f06f-a5aa-67d0-e4e6-506f841c7629</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-06-15 00:15:00.657</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-06-15 00:10:29.301</td>\n",
       "      <td>63.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-06-15 00:10:29.301</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-06-15 00:15:00.657</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0004feb8-5274-2862-5c10-0ce079a7f061</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-08-30 10:09:33.601</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>113.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-08-30 09:59:59.999</td>\n",
       "      <td>69.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-08-30 09:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-08-30 10:09:33.601</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0006f63b-10b8-26ec-0e31-8dec63f0218e.binning_d...</td>\n",
       "      <td>0006f63b-10b8-26ec-0e31-8dec63f0218e</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               create_time time_offset    max  heart_beat_count  custom  \\\n",
       "0  2017-10-11 20:55:00.587    UTC+0400    0.0                 1     NaN   \n",
       "1  2017-10-23 06:35:01.585    UTC+0400    0.0                 1     NaN   \n",
       "2  2017-10-16 13:15:00.369    UTC+0400    0.0                 1     NaN   \n",
       "3  2018-06-15 00:15:00.657    UTC+0400    0.0                 1     NaN   \n",
       "4  2018-08-30 10:09:33.601    UTC+0400  113.0                 1     NaN   \n",
       "\n",
       "                  end_time  heart_rate  deviceuuid               start_time  \\\n",
       "0  2017-10-11 20:40:29.271        58.0  YhcXJQnntK  2017-10-11 20:40:29.271   \n",
       "1  2017-10-23 06:20:29.292        76.0  YhcXJQnntK  2017-10-23 06:20:29.292   \n",
       "2  2017-10-16 13:10:29.296        75.0  YhcXJQnntK  2017-10-16 13:10:29.296   \n",
       "3  2018-06-15 00:10:29.301        63.0  YhcXJQnntK  2018-06-15 00:10:29.301   \n",
       "4  2018-08-30 09:59:59.999        69.0  YhcXJQnntK  2018-08-30 09:00:00.000   \n",
       "\n",
       "                      pkg_name              update_time   min  \\\n",
       "0  com.sec.android.app.shealth  2017-10-11 20:55:00.587   0.0   \n",
       "1  com.sec.android.app.shealth  2017-10-23 06:35:01.585   0.0   \n",
       "2  com.sec.android.app.shealth  2017-10-16 13:15:00.369   0.0   \n",
       "3  com.sec.android.app.shealth  2018-06-15 00:15:00.657   0.0   \n",
       "4  com.sec.android.app.shealth  2018-08-30 10:09:33.601  57.0   \n",
       "\n",
       "                                        binning_data  \\\n",
       "0                                                NaN   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4  0006f63b-10b8-26ec-0e31-8dec63f0218e.binning_d...   \n",
       "\n",
       "                               datauuid comment  \n",
       "0  00004f1f-db81-65d8-4e7a-67d5156f6517     NaN  \n",
       "1  00009399-20d2-d24d-6577-cd80fb670660     NaN  \n",
       "2  0000f06f-a5aa-67d0-e4e6-506f841c7629     NaN  \n",
       "3  0004feb8-5274-2862-5c10-0ce079a7f061     NaN  \n",
       "4  0006f63b-10b8-26ec-0e31-8dec63f0218e     NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Path for files downloaded from Samsung Health\n",
    "data_dir = \"/persistentStorage/SHealth_DataSet/Shealth/\"\n",
    "\n",
    "hr_data_file_prefix = \"com.samsung.health.heart_rate\"\n",
    "\n",
    "for file in os.listdir(data_dir):\n",
    "    if ((hr_data_file_prefix in file) and (file.endswith(\"csv\"))):\n",
    "        print(file)\n",
    "        hr_df = pd.read_csv(data_dir+file, header=1)\n",
    "        break\n",
    "        \n",
    "hr_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>create_time</th>\n",
       "      <th>time_offset</th>\n",
       "      <th>max</th>\n",
       "      <th>heart_beat_count</th>\n",
       "      <th>custom</th>\n",
       "      <th>end_time</th>\n",
       "      <th>heart_rate</th>\n",
       "      <th>deviceuuid</th>\n",
       "      <th>start_time</th>\n",
       "      <th>pkg_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>min</th>\n",
       "      <th>binning_data</th>\n",
       "      <th>datauuid</th>\n",
       "      <th>comment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10779</th>\n",
       "      <td>2017-07-18 18:40:29.554</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>70.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-07-18 18:40:29.554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>cc83c429-d843-0e49-628f-ce952cc134cf</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9878</th>\n",
       "      <td>2017-07-15 10:51:43.149</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>73.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-07-15 10:51:43.149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>bb7b0cba-27ec-f10e-9707-4d102b7c5e7e</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3311</th>\n",
       "      <td>2017-07-17 04:30:29.768</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>72.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>1970-01-01 00:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-07-17 04:30:29.768</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3f17ac2e-84dd-4351-db57-86196f7b3dfb</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5162</th>\n",
       "      <td>2017-01-31 05:05:42.939</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-01-31 05:05:31.149</td>\n",
       "      <td>76.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-01-31 05:05:27.989</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-01-31 05:05:42.939</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62bdb3f9-5f89-4cee-84e7-979a970846cf</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11990</th>\n",
       "      <td>2017-01-31 05:06:03.130</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-01-31 05:05:56.049</td>\n",
       "      <td>83.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-01-31 05:05:53.015</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-01-31 05:06:03.130</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>e4fae0ee-4662-4513-9244-18f7bc5fc2f3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2017-01-31 05:07:00.066</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-01-31 05:06:24.759</td>\n",
       "      <td>73.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-01-31 05:06:19.229</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-01-31 05:07:00.066</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0089c258-3465-49b2-a721-0cd1fe2142eb</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8799</th>\n",
       "      <td>2017-01-31 06:30:19.065</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-01-31 06:28:54.393</td>\n",
       "      <td>110.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-01-31 06:28:50.313</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-01-31 06:30:19.065</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a79a84cd-07fc-4c46-b438-840cf1256e81</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2296</th>\n",
       "      <td>2017-02-01 07:11:03.320</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-01 07:10:48.391</td>\n",
       "      <td>84.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-01 07:10:45.479</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-01 07:11:03.320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2cc963ec-d775-4ca2-9809-a43542d57085</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10554</th>\n",
       "      <td>2017-02-03 05:02:29.120</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-03 05:02:20.045</td>\n",
       "      <td>74.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-03 05:02:16.669</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-03 05:02:29.120</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c8c007c0-7e1f-4537-bb93-7221cac491f2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4555</th>\n",
       "      <td>2017-02-06 14:31:31.558</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-06 14:31:23.179</td>\n",
       "      <td>112.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-06 14:31:20.502</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-06 14:31:31.558</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57562db1-5cc2-440b-8e40-98d029b8ddce</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3343</th>\n",
       "      <td>2017-02-07 04:53:47.994</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-07 04:53:37.434</td>\n",
       "      <td>85.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-07 04:53:34.486</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-07 04:53:47.994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3feee7f6-9e14-449b-a612-b18f9d616514</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1025</th>\n",
       "      <td>2017-02-09 19:09:55.299</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-09 19:09:49.310</td>\n",
       "      <td>61.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-09 19:09:45.374</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-09 19:09:55.299</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14ab589f-3797-49f0-9395-18f94a414546</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>2017-02-09 19:11:43.397</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-09 19:11:12.518</td>\n",
       "      <td>63.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-09 19:11:06.482</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-09 19:11:43.397</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0e66031f-c8b2-4c8b-9a6d-babaac8cce3f</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5554</th>\n",
       "      <td>2017-02-27 14:20:27.170</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-27 14:20:21.912</td>\n",
       "      <td>117.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-27 14:20:19.862</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-27 14:20:27.170</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>69f015c4-8cea-447c-b72f-0e8c7f132783</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10964</th>\n",
       "      <td>2017-02-27 14:27:45.648</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-27 14:27:37.021</td>\n",
       "      <td>119.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-27 14:27:34.903</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-27 14:27:45.648</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>d053d62c-5d5e-456b-be71-c977f921b632</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2944</th>\n",
       "      <td>2017-02-28 04:10:40.245</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 04:10:31.202</td>\n",
       "      <td>70.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 04:10:27.587</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 04:10:40.245</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38ea0202-aca8-45ec-b1fc-e5ee3c27605b</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10860</th>\n",
       "      <td>2017-02-28 04:18:32.781</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 04:18:25.980</td>\n",
       "      <td>80.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 04:18:22.865</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 04:18:32.781</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ce16178f-0dc2-4327-974e-18ad97dc09a9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3390</th>\n",
       "      <td>2017-02-28 04:46:02.897</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 04:45:55.223</td>\n",
       "      <td>85.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 04:45:52.440</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 04:46:02.897</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4127d153-7ff5-45b4-8920-79ca9db0c39f</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12687</th>\n",
       "      <td>2017-02-28 04:46:27.587</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 04:46:16.091</td>\n",
       "      <td>77.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 04:46:13.056</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 04:46:27.587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>f2b94350-bed5-4588-a841-47e2a7e66836</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11552</th>\n",
       "      <td>2017-02-28 07:38:59.100</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 07:38:49.367</td>\n",
       "      <td>95.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 07:38:46.819</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 07:38:59.100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>dc18c24c-2867-41f7-8fcb-9395b1fbc8a5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13288</th>\n",
       "      <td>2017-02-28 07:39:14.958</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 07:39:11.170</td>\n",
       "      <td>95.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 07:39:08.643</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 07:39:14.958</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>fe0d129f-1645-49c3-aca9-0951e36b1aea</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11808</th>\n",
       "      <td>2017-02-28 08:53:13.884</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 08:53:10.769</td>\n",
       "      <td>74.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 08:53:07.669</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 08:53:13.884</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>e10dd589-0238-474d-9738-a769f3e52764</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9135</th>\n",
       "      <td>2017-02-28 13:58:12.938</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 13:57:54.456</td>\n",
       "      <td>106.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 13:57:52.251</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 13:58:12.938</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ad87a44e-5cfa-4f73-99e0-ba680c2da8cd</td>\n",
       "      <td>Exercise</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10105</th>\n",
       "      <td>2017-02-28 15:40:28.566</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 15:40:21.231</td>\n",
       "      <td>82.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 15:40:18.348</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 15:40:28.566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>bfe45cc9-2c05-4a5b-8788-3696d9673384</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980</th>\n",
       "      <td>2017-02-28 20:28:23.283</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-02-28 20:28:17.063</td>\n",
       "      <td>66.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-02-28 20:28:12.904</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-02-28 20:28:23.283</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2707bac6-b683-44f7-8041-30fa48363201</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11074</th>\n",
       "      <td>2017-03-01 04:19:29.534</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-01 04:19:24.280</td>\n",
       "      <td>66.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-03-01 04:19:20.492</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-03-01 04:19:29.534</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>d2a3882c-c27c-43db-b82c-39b84c502403</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1082</th>\n",
       "      <td>2017-03-01 04:45:09.234</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-01 04:45:00.464</td>\n",
       "      <td>69.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-03-01 04:44:55.053</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-03-01 04:45:09.234</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15caab3d-9437-48d5-916a-48cfca3d9223</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4018</th>\n",
       "      <td>2017-03-01 04:53:59.049</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-01 04:53:51.475</td>\n",
       "      <td>82.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-03-01 04:53:48.155</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-03-01 04:53:59.049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4d161969-41b8-4f70-86a4-dc37f8ef36d7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8789</th>\n",
       "      <td>2017-03-01 04:55:20.005</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-01 04:55:12.886</td>\n",
       "      <td>64.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-03-01 04:55:09.028</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-03-01 04:55:20.005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a7642657-2836-4ae2-9f0a-73d5828875bf</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10457</th>\n",
       "      <td>2017-03-01 10:10:34.093</td>\n",
       "      <td>UTC+0300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-03-01 10:10:28.452</td>\n",
       "      <td>60.0</td>\n",
       "      <td>7chpf+113K</td>\n",
       "      <td>2017-03-01 10:10:24.835</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2017-03-01 10:10:34.093</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c6f671af-15d0-46ef-873f-7afca9eadbc1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12287</th>\n",
       "      <td>2018-09-03 00:08:10.640</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>69.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:59:59.999</td>\n",
       "      <td>50.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:08:10.640</td>\n",
       "      <td>46.0</td>\n",
       "      <td>eab70251-7025-9e1f-d87b-b76af55686ff.binning_d...</td>\n",
       "      <td>eab70251-7025-9e1f-d87b-b76af55686ff</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5046</th>\n",
       "      <td>2018-09-02 23:14:59.659</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:00:29.255</td>\n",
       "      <td>54.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:00:29.255</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:14:59.659</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60cb83bd-748b-b9df-eaa1-5bc6a6cb4ced</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10122</th>\n",
       "      <td>2018-09-02 23:14:59.920</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:10:29.257</td>\n",
       "      <td>52.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:10:29.257</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:14:59.920</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>c0352870-5d91-b946-12ee-668584bdbc63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1237</th>\n",
       "      <td>2018-09-02 23:14:59.809</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:10:29.258</td>\n",
       "      <td>52.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:10:29.258</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:14:59.809</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18bd1da2-3a22-f26b-9841-c15b936aa18b</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3741</th>\n",
       "      <td>2018-09-02 23:34:59.684</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:20:29.260</td>\n",
       "      <td>52.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:20:29.260</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:34:59.684</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>476f4a1c-c6c2-1a4f-0bf0-f04ea38c9cec</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12128</th>\n",
       "      <td>2018-09-02 23:54:59.827</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:40:29.264</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:40:29.264</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:54:59.827</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>e7a994a9-e396-b797-ef51-72504543cabe</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5173</th>\n",
       "      <td>2018-09-02 23:54:59.806</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:40:29.265</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:40:29.265</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:54:59.806</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62e05115-3783-0a9c-8e82-5f094308f820</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4894</th>\n",
       "      <td>2018-09-02 23:55:00.050</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-02 23:50:29.268</td>\n",
       "      <td>48.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-02 23:50:29.268</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-02 23:55:00.050</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5dbe1063-4d00-d8dd-e4ff-17df8e3f0f27</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9167</th>\n",
       "      <td>2018-09-03 01:04:31.596</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>99.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:59:59.999</td>\n",
       "      <td>55.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:04:31.596</td>\n",
       "      <td>47.0</td>\n",
       "      <td>ae0fc694-aaef-118b-465b-088267c720db.binning_d...</td>\n",
       "      <td>ae0fc694-aaef-118b-465b-088267c720db</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12056</th>\n",
       "      <td>2018-09-03 00:14:59.723</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:00:29.269</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:00:29.269</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:14:59.723</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>e6539efd-8e17-f294-75ad-7c16473f4848</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3553</th>\n",
       "      <td>2018-09-03 00:14:59.966</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:10:29.272</td>\n",
       "      <td>48.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:10:29.272</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:14:59.966</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43f992ab-b2a0-731d-fe17-5169af233425</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>2018-09-03 00:34:29.709</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:20:29.275</td>\n",
       "      <td>55.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:20:29.275</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:34:29.709</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>205fcc18-f78a-93c0-292b-36c2c3d34a58</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>2018-09-03 00:34:30.448</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:30:29.277</td>\n",
       "      <td>54.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:30:29.277</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:34:30.448</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15bade36-064d-0528-a01b-ed1c749a5ff8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13389</th>\n",
       "      <td>2018-09-03 00:34:29.717</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:30:29.278</td>\n",
       "      <td>54.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:30:29.278</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:34:29.717</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ffe940cd-4f45-4f17-0bb1-226b3bcf7b63</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7872</th>\n",
       "      <td>2018-09-03 00:54:59.967</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 00:50:29.283</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 00:50:29.283</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 00:54:59.967</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>952fe250-af67-cc6d-7597-b55d94b1e1e3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11824</th>\n",
       "      <td>2018-09-03 02:04:34.653</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>69.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:59:59.999</td>\n",
       "      <td>51.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 02:04:34.653</td>\n",
       "      <td>46.0</td>\n",
       "      <td>e16a5e3c-1c8b-06eb-ad77-0ac8eee718c3.binning_d...</td>\n",
       "      <td>e16a5e3c-1c8b-06eb-ad77-0ac8eee718c3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1567</th>\n",
       "      <td>2018-09-03 01:14:59.944</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:10:29.287</td>\n",
       "      <td>48.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:10:29.287</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:14:59.944</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1ebe31cb-ced6-ccd6-d79a-4b483f658bbb</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2560</th>\n",
       "      <td>2018-09-03 01:14:59.694</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:10:29.288</td>\n",
       "      <td>48.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:10:29.288</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:14:59.694</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31736f09-baa3-0364-42cf-9b80055c6a01</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9118</th>\n",
       "      <td>2018-09-03 01:34:59.814</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:20:29.290</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:20:29.290</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:34:59.814</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ad528d94-a7c4-69db-b013-e7adbdee5924</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13197</th>\n",
       "      <td>2018-09-03 01:34:59.964</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:30:29.292</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:30:29.292</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:34:59.964</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>fbffc3ab-1552-60d9-7b8f-080dde18aee8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8416</th>\n",
       "      <td>2018-09-03 01:35:00.075</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 01:30:29.293</td>\n",
       "      <td>49.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 01:30:29.293</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 01:35:00.075</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a030da29-9421-9c26-9062-81b2b2cf7518</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9889</th>\n",
       "      <td>2018-09-03 03:01:08.731</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 02:59:59.999</td>\n",
       "      <td>52.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 02:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 03:01:08.731</td>\n",
       "      <td>48.0</td>\n",
       "      <td>bbb97e02-0a02-ead7-12e0-bfc005baa2e5.binning_d...</td>\n",
       "      <td>bbb97e02-0a02-ead7-12e0-bfc005baa2e5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8696</th>\n",
       "      <td>2018-09-03 02:50:32.764</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 02:40:29.310</td>\n",
       "      <td>50.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 02:40:29.310</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 02:50:32.764</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>a59792cb-61a1-2e4c-811b-a3f51b1c3fa3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9290</th>\n",
       "      <td>2018-09-03 02:50:33.530</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 02:50:29.313</td>\n",
       "      <td>54.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 02:50:29.313</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 02:50:33.530</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>b07e907f-b68e-62fc-6244-8e6aaf12ca52</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3201</th>\n",
       "      <td>2018-09-03 03:01:08.818</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>65.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 03:59:59.999</td>\n",
       "      <td>62.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 03:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 04:23:44.513</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3d563558-3f29-21bd-6744-0d44ef2109c3.binning_d...</td>\n",
       "      <td>3d563558-3f29-21bd-6744-0d44ef2109c3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9845</th>\n",
       "      <td>2018-09-03 05:03:46.682</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>125.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 04:59:59.999</td>\n",
       "      <td>87.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 04:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 05:03:46.682</td>\n",
       "      <td>71.0</td>\n",
       "      <td>baef0ee2-7fe9-73cb-3747-91da21e218d9.binning_d...</td>\n",
       "      <td>baef0ee2-7fe9-73cb-3747-91da21e218d9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12878</th>\n",
       "      <td>2018-09-03 06:09:19.546</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>133.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 05:59:59.999</td>\n",
       "      <td>85.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 05:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 06:09:19.546</td>\n",
       "      <td>74.0</td>\n",
       "      <td>f5f89298-ac93-9be3-f12d-84b90f6d87c2.binning_d...</td>\n",
       "      <td>f5f89298-ac93-9be3-f12d-84b90f6d87c2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>2018-09-03 06:10:04.230</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>108.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 06:59:59.999</td>\n",
       "      <td>77.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 06:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 07:02:38.382</td>\n",
       "      <td>61.0</td>\n",
       "      <td>03328f38-246b-d0a1-0208-1a6dc43a1168.binning_d...</td>\n",
       "      <td>03328f38-246b-d0a1-0208-1a6dc43a1168</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2533</th>\n",
       "      <td>2018-09-03 07:03:41.138</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>106.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 07:59:59.999</td>\n",
       "      <td>75.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 07:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 08:04:10.030</td>\n",
       "      <td>61.0</td>\n",
       "      <td>310638aa-dfe7-e348-1e65-3d9f99fee1cc.binning_d...</td>\n",
       "      <td>310638aa-dfe7-e348-1e65-3d9f99fee1cc</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5161</th>\n",
       "      <td>2018-09-03 08:04:10.098</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>60.0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-09-03 08:04:10.096</td>\n",
       "      <td>57.0</td>\n",
       "      <td>YhcXJQnntK</td>\n",
       "      <td>2018-09-03 08:00:00.000</td>\n",
       "      <td>com.sec.android.app.shealth</td>\n",
       "      <td>2018-09-03 08:04:10.098</td>\n",
       "      <td>56.0</td>\n",
       "      <td>62b808ef-5a36-a963-8dd0-7141a9501214.binning_d...</td>\n",
       "      <td>62b808ef-5a36-a963-8dd0-7141a9501214</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13395 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   create_time time_offset    max  heart_beat_count  custom  \\\n",
       "10779  2017-07-18 18:40:29.554    UTC+0400    NaN                 1     NaN   \n",
       "9878   2017-07-15 10:51:43.149    UTC+0400    NaN                 1     NaN   \n",
       "3311   2017-07-17 04:30:29.768    UTC+0400    NaN                 1     NaN   \n",
       "5162   2017-01-31 05:05:42.939    UTC+0300    NaN                 0     NaN   \n",
       "11990  2017-01-31 05:06:03.130    UTC+0300    NaN                 0     NaN   \n",
       "31     2017-01-31 05:07:00.066    UTC+0300    NaN                 0     NaN   \n",
       "8799   2017-01-31 06:30:19.065    UTC+0300    NaN                 0     NaN   \n",
       "2296   2017-02-01 07:11:03.320    UTC+0300    NaN                 0     NaN   \n",
       "10554  2017-02-03 05:02:29.120    UTC+0300    NaN                 0     NaN   \n",
       "4555   2017-02-06 14:31:31.558    UTC+0300    NaN                 0     NaN   \n",
       "3343   2017-02-07 04:53:47.994    UTC+0300    NaN                 0     NaN   \n",
       "1025   2017-02-09 19:09:55.299    UTC+0300    NaN                 0     NaN   \n",
       "714    2017-02-09 19:11:43.397    UTC+0300    NaN                 0     NaN   \n",
       "5554   2017-02-27 14:20:27.170    UTC+0300    NaN                 0     NaN   \n",
       "10964  2017-02-27 14:27:45.648    UTC+0300    NaN                 0     NaN   \n",
       "2944   2017-02-28 04:10:40.245    UTC+0300    NaN                 0     NaN   \n",
       "10860  2017-02-28 04:18:32.781    UTC+0300    NaN                 0     NaN   \n",
       "3390   2017-02-28 04:46:02.897    UTC+0300    NaN                 0     NaN   \n",
       "12687  2017-02-28 04:46:27.587    UTC+0300    NaN                 0     NaN   \n",
       "11552  2017-02-28 07:38:59.100    UTC+0300    NaN                 0     NaN   \n",
       "13288  2017-02-28 07:39:14.958    UTC+0300    NaN                 0     NaN   \n",
       "11808  2017-02-28 08:53:13.884    UTC+0300    NaN                 0     NaN   \n",
       "9135   2017-02-28 13:58:12.938    UTC+0300    NaN                 0     NaN   \n",
       "10105  2017-02-28 15:40:28.566    UTC+0300    NaN                 0     NaN   \n",
       "1980   2017-02-28 20:28:23.283    UTC+0300    NaN                 0     NaN   \n",
       "11074  2017-03-01 04:19:29.534    UTC+0300    NaN                 0     NaN   \n",
       "1082   2017-03-01 04:45:09.234    UTC+0300    NaN                 0     NaN   \n",
       "4018   2017-03-01 04:53:59.049    UTC+0300    NaN                 0     NaN   \n",
       "8789   2017-03-01 04:55:20.005    UTC+0300    NaN                 0     NaN   \n",
       "10457  2017-03-01 10:10:34.093    UTC+0300    NaN                 0     NaN   \n",
       "...                        ...         ...    ...               ...     ...   \n",
       "12287  2018-09-03 00:08:10.640    UTC+0400   69.0                 1     NaN   \n",
       "5046   2018-09-02 23:14:59.659    UTC+0400    0.0                 1     NaN   \n",
       "10122  2018-09-02 23:14:59.920    UTC+0400    0.0                 1     NaN   \n",
       "1237   2018-09-02 23:14:59.809    UTC+0400    0.0                 1     NaN   \n",
       "3741   2018-09-02 23:34:59.684    UTC+0400    0.0                 1     NaN   \n",
       "12128  2018-09-02 23:54:59.827    UTC+0400    0.0                 1     NaN   \n",
       "5173   2018-09-02 23:54:59.806    UTC+0400    0.0                 1     NaN   \n",
       "4894   2018-09-02 23:55:00.050    UTC+0400    0.0                 1     NaN   \n",
       "9167   2018-09-03 01:04:31.596    UTC+0400   99.0                 1     NaN   \n",
       "12056  2018-09-03 00:14:59.723    UTC+0400    0.0                 1     NaN   \n",
       "3553   2018-09-03 00:14:59.966    UTC+0400    0.0                 1     NaN   \n",
       "1663   2018-09-03 00:34:29.709    UTC+0400    0.0                 1     NaN   \n",
       "1074   2018-09-03 00:34:30.448    UTC+0400    0.0                 1     NaN   \n",
       "13389  2018-09-03 00:34:29.717    UTC+0400    0.0                 1     NaN   \n",
       "7872   2018-09-03 00:54:59.967    UTC+0400    0.0                 1     NaN   \n",
       "11824  2018-09-03 02:04:34.653    UTC+0400   69.0                 1     NaN   \n",
       "1567   2018-09-03 01:14:59.944    UTC+0400    0.0                 1     NaN   \n",
       "2560   2018-09-03 01:14:59.694    UTC+0400    0.0                 1     NaN   \n",
       "9118   2018-09-03 01:34:59.814    UTC+0400    0.0                 1     NaN   \n",
       "13197  2018-09-03 01:34:59.964    UTC+0400    0.0                 1     NaN   \n",
       "8416   2018-09-03 01:35:00.075    UTC+0400    0.0                 1     NaN   \n",
       "9889   2018-09-03 03:01:08.731    UTC+0400   85.0                 1     NaN   \n",
       "8696   2018-09-03 02:50:32.764    UTC+0400    0.0                 1     NaN   \n",
       "9290   2018-09-03 02:50:33.530    UTC+0400    0.0                 1     NaN   \n",
       "3201   2018-09-03 03:01:08.818    UTC+0400   65.0                 1     NaN   \n",
       "9845   2018-09-03 05:03:46.682    UTC+0400  125.0                 1     NaN   \n",
       "12878  2018-09-03 06:09:19.546    UTC+0400  133.0                 1     NaN   \n",
       "176    2018-09-03 06:10:04.230    UTC+0400  108.0                 1     NaN   \n",
       "2533   2018-09-03 07:03:41.138    UTC+0400  106.0                 1     NaN   \n",
       "5161   2018-09-03 08:04:10.098    UTC+0400   60.0                 1     NaN   \n",
       "\n",
       "                      end_time  heart_rate  deviceuuid  \\\n",
       "10779  1970-01-01 00:00:00.000        70.0  YhcXJQnntK   \n",
       "9878   1970-01-01 00:00:00.000        73.0  YhcXJQnntK   \n",
       "3311   1970-01-01 00:00:00.000        72.0  YhcXJQnntK   \n",
       "5162   2017-01-31 05:05:31.149        76.0  7chpf+113K   \n",
       "11990  2017-01-31 05:05:56.049        83.0  7chpf+113K   \n",
       "31     2017-01-31 05:06:24.759        73.0  7chpf+113K   \n",
       "8799   2017-01-31 06:28:54.393       110.0  7chpf+113K   \n",
       "2296   2017-02-01 07:10:48.391        84.0  7chpf+113K   \n",
       "10554  2017-02-03 05:02:20.045        74.0  7chpf+113K   \n",
       "4555   2017-02-06 14:31:23.179       112.0  7chpf+113K   \n",
       "3343   2017-02-07 04:53:37.434        85.0  7chpf+113K   \n",
       "1025   2017-02-09 19:09:49.310        61.0  7chpf+113K   \n",
       "714    2017-02-09 19:11:12.518        63.0  7chpf+113K   \n",
       "5554   2017-02-27 14:20:21.912       117.0  7chpf+113K   \n",
       "10964  2017-02-27 14:27:37.021       119.0  7chpf+113K   \n",
       "2944   2017-02-28 04:10:31.202        70.0  7chpf+113K   \n",
       "10860  2017-02-28 04:18:25.980        80.0  7chpf+113K   \n",
       "3390   2017-02-28 04:45:55.223        85.0  7chpf+113K   \n",
       "12687  2017-02-28 04:46:16.091        77.0  7chpf+113K   \n",
       "11552  2017-02-28 07:38:49.367        95.0  7chpf+113K   \n",
       "13288  2017-02-28 07:39:11.170        95.0  7chpf+113K   \n",
       "11808  2017-02-28 08:53:10.769        74.0  7chpf+113K   \n",
       "9135   2017-02-28 13:57:54.456       106.0  7chpf+113K   \n",
       "10105  2017-02-28 15:40:21.231        82.0  7chpf+113K   \n",
       "1980   2017-02-28 20:28:17.063        66.0  7chpf+113K   \n",
       "11074  2017-03-01 04:19:24.280        66.0  7chpf+113K   \n",
       "1082   2017-03-01 04:45:00.464        69.0  7chpf+113K   \n",
       "4018   2017-03-01 04:53:51.475        82.0  7chpf+113K   \n",
       "8789   2017-03-01 04:55:12.886        64.0  7chpf+113K   \n",
       "10457  2017-03-01 10:10:28.452        60.0  7chpf+113K   \n",
       "...                        ...         ...         ...   \n",
       "12287  2018-09-02 23:59:59.999        50.0  YhcXJQnntK   \n",
       "5046   2018-09-02 23:00:29.255        54.0  YhcXJQnntK   \n",
       "10122  2018-09-02 23:10:29.257        52.0  YhcXJQnntK   \n",
       "1237   2018-09-02 23:10:29.258        52.0  YhcXJQnntK   \n",
       "3741   2018-09-02 23:20:29.260        52.0  YhcXJQnntK   \n",
       "12128  2018-09-02 23:40:29.264        49.0  YhcXJQnntK   \n",
       "5173   2018-09-02 23:40:29.265        49.0  YhcXJQnntK   \n",
       "4894   2018-09-02 23:50:29.268        48.0  YhcXJQnntK   \n",
       "9167   2018-09-03 00:59:59.999        55.0  YhcXJQnntK   \n",
       "12056  2018-09-03 00:00:29.269        49.0  YhcXJQnntK   \n",
       "3553   2018-09-03 00:10:29.272        48.0  YhcXJQnntK   \n",
       "1663   2018-09-03 00:20:29.275        55.0  YhcXJQnntK   \n",
       "1074   2018-09-03 00:30:29.277        54.0  YhcXJQnntK   \n",
       "13389  2018-09-03 00:30:29.278        54.0  YhcXJQnntK   \n",
       "7872   2018-09-03 00:50:29.283        49.0  YhcXJQnntK   \n",
       "11824  2018-09-03 01:59:59.999        51.0  YhcXJQnntK   \n",
       "1567   2018-09-03 01:10:29.287        48.0  YhcXJQnntK   \n",
       "2560   2018-09-03 01:10:29.288        48.0  YhcXJQnntK   \n",
       "9118   2018-09-03 01:20:29.290        49.0  YhcXJQnntK   \n",
       "13197  2018-09-03 01:30:29.292        49.0  YhcXJQnntK   \n",
       "8416   2018-09-03 01:30:29.293        49.0  YhcXJQnntK   \n",
       "9889   2018-09-03 02:59:59.999        52.0  YhcXJQnntK   \n",
       "8696   2018-09-03 02:40:29.310        50.0  YhcXJQnntK   \n",
       "9290   2018-09-03 02:50:29.313        54.0  YhcXJQnntK   \n",
       "3201   2018-09-03 03:59:59.999        62.0  YhcXJQnntK   \n",
       "9845   2018-09-03 04:59:59.999        87.0  YhcXJQnntK   \n",
       "12878  2018-09-03 05:59:59.999        85.0  YhcXJQnntK   \n",
       "176    2018-09-03 06:59:59.999        77.0  YhcXJQnntK   \n",
       "2533   2018-09-03 07:59:59.999        75.0  YhcXJQnntK   \n",
       "5161   2018-09-03 08:04:10.096        57.0  YhcXJQnntK   \n",
       "\n",
       "                    start_time                     pkg_name  \\\n",
       "10779  1970-01-01 00:00:00.000  com.sec.android.app.shealth   \n",
       "9878   1970-01-01 00:00:00.000  com.sec.android.app.shealth   \n",
       "3311   1970-01-01 00:00:00.000  com.sec.android.app.shealth   \n",
       "5162   2017-01-31 05:05:27.989  com.sec.android.app.shealth   \n",
       "11990  2017-01-31 05:05:53.015  com.sec.android.app.shealth   \n",
       "31     2017-01-31 05:06:19.229  com.sec.android.app.shealth   \n",
       "8799   2017-01-31 06:28:50.313  com.sec.android.app.shealth   \n",
       "2296   2017-02-01 07:10:45.479  com.sec.android.app.shealth   \n",
       "10554  2017-02-03 05:02:16.669  com.sec.android.app.shealth   \n",
       "4555   2017-02-06 14:31:20.502  com.sec.android.app.shealth   \n",
       "3343   2017-02-07 04:53:34.486  com.sec.android.app.shealth   \n",
       "1025   2017-02-09 19:09:45.374  com.sec.android.app.shealth   \n",
       "714    2017-02-09 19:11:06.482  com.sec.android.app.shealth   \n",
       "5554   2017-02-27 14:20:19.862  com.sec.android.app.shealth   \n",
       "10964  2017-02-27 14:27:34.903  com.sec.android.app.shealth   \n",
       "2944   2017-02-28 04:10:27.587  com.sec.android.app.shealth   \n",
       "10860  2017-02-28 04:18:22.865  com.sec.android.app.shealth   \n",
       "3390   2017-02-28 04:45:52.440  com.sec.android.app.shealth   \n",
       "12687  2017-02-28 04:46:13.056  com.sec.android.app.shealth   \n",
       "11552  2017-02-28 07:38:46.819  com.sec.android.app.shealth   \n",
       "13288  2017-02-28 07:39:08.643  com.sec.android.app.shealth   \n",
       "11808  2017-02-28 08:53:07.669  com.sec.android.app.shealth   \n",
       "9135   2017-02-28 13:57:52.251  com.sec.android.app.shealth   \n",
       "10105  2017-02-28 15:40:18.348  com.sec.android.app.shealth   \n",
       "1980   2017-02-28 20:28:12.904  com.sec.android.app.shealth   \n",
       "11074  2017-03-01 04:19:20.492  com.sec.android.app.shealth   \n",
       "1082   2017-03-01 04:44:55.053  com.sec.android.app.shealth   \n",
       "4018   2017-03-01 04:53:48.155  com.sec.android.app.shealth   \n",
       "8789   2017-03-01 04:55:09.028  com.sec.android.app.shealth   \n",
       "10457  2017-03-01 10:10:24.835  com.sec.android.app.shealth   \n",
       "...                        ...                          ...   \n",
       "12287  2018-09-02 23:00:00.000  com.sec.android.app.shealth   \n",
       "5046   2018-09-02 23:00:29.255  com.sec.android.app.shealth   \n",
       "10122  2018-09-02 23:10:29.257  com.sec.android.app.shealth   \n",
       "1237   2018-09-02 23:10:29.258  com.sec.android.app.shealth   \n",
       "3741   2018-09-02 23:20:29.260  com.sec.android.app.shealth   \n",
       "12128  2018-09-02 23:40:29.264  com.sec.android.app.shealth   \n",
       "5173   2018-09-02 23:40:29.265  com.sec.android.app.shealth   \n",
       "4894   2018-09-02 23:50:29.268  com.sec.android.app.shealth   \n",
       "9167   2018-09-03 00:00:00.000  com.sec.android.app.shealth   \n",
       "12056  2018-09-03 00:00:29.269  com.sec.android.app.shealth   \n",
       "3553   2018-09-03 00:10:29.272  com.sec.android.app.shealth   \n",
       "1663   2018-09-03 00:20:29.275  com.sec.android.app.shealth   \n",
       "1074   2018-09-03 00:30:29.277  com.sec.android.app.shealth   \n",
       "13389  2018-09-03 00:30:29.278  com.sec.android.app.shealth   \n",
       "7872   2018-09-03 00:50:29.283  com.sec.android.app.shealth   \n",
       "11824  2018-09-03 01:00:00.000  com.sec.android.app.shealth   \n",
       "1567   2018-09-03 01:10:29.287  com.sec.android.app.shealth   \n",
       "2560   2018-09-03 01:10:29.288  com.sec.android.app.shealth   \n",
       "9118   2018-09-03 01:20:29.290  com.sec.android.app.shealth   \n",
       "13197  2018-09-03 01:30:29.292  com.sec.android.app.shealth   \n",
       "8416   2018-09-03 01:30:29.293  com.sec.android.app.shealth   \n",
       "9889   2018-09-03 02:00:00.000  com.sec.android.app.shealth   \n",
       "8696   2018-09-03 02:40:29.310  com.sec.android.app.shealth   \n",
       "9290   2018-09-03 02:50:29.313  com.sec.android.app.shealth   \n",
       "3201   2018-09-03 03:00:00.000  com.sec.android.app.shealth   \n",
       "9845   2018-09-03 04:00:00.000  com.sec.android.app.shealth   \n",
       "12878  2018-09-03 05:00:00.000  com.sec.android.app.shealth   \n",
       "176    2018-09-03 06:00:00.000  com.sec.android.app.shealth   \n",
       "2533   2018-09-03 07:00:00.000  com.sec.android.app.shealth   \n",
       "5161   2018-09-03 08:00:00.000  com.sec.android.app.shealth   \n",
       "\n",
       "                   update_time   min  \\\n",
       "10779  2017-07-18 18:40:29.554   NaN   \n",
       "9878   2017-07-15 10:51:43.149   NaN   \n",
       "3311   2017-07-17 04:30:29.768   NaN   \n",
       "5162   2017-01-31 05:05:42.939   NaN   \n",
       "11990  2017-01-31 05:06:03.130   NaN   \n",
       "31     2017-01-31 05:07:00.066   NaN   \n",
       "8799   2017-01-31 06:30:19.065   NaN   \n",
       "2296   2017-02-01 07:11:03.320   NaN   \n",
       "10554  2017-02-03 05:02:29.120   NaN   \n",
       "4555   2017-02-06 14:31:31.558   NaN   \n",
       "3343   2017-02-07 04:53:47.994   NaN   \n",
       "1025   2017-02-09 19:09:55.299   NaN   \n",
       "714    2017-02-09 19:11:43.397   NaN   \n",
       "5554   2017-02-27 14:20:27.170   NaN   \n",
       "10964  2017-02-27 14:27:45.648   NaN   \n",
       "2944   2017-02-28 04:10:40.245   NaN   \n",
       "10860  2017-02-28 04:18:32.781   NaN   \n",
       "3390   2017-02-28 04:46:02.897   NaN   \n",
       "12687  2017-02-28 04:46:27.587   NaN   \n",
       "11552  2017-02-28 07:38:59.100   NaN   \n",
       "13288  2017-02-28 07:39:14.958   NaN   \n",
       "11808  2017-02-28 08:53:13.884   NaN   \n",
       "9135   2017-02-28 13:58:12.938   NaN   \n",
       "10105  2017-02-28 15:40:28.566   NaN   \n",
       "1980   2017-02-28 20:28:23.283   NaN   \n",
       "11074  2017-03-01 04:19:29.534   NaN   \n",
       "1082   2017-03-01 04:45:09.234   NaN   \n",
       "4018   2017-03-01 04:53:59.049   NaN   \n",
       "8789   2017-03-01 04:55:20.005   NaN   \n",
       "10457  2017-03-01 10:10:34.093   NaN   \n",
       "...                        ...   ...   \n",
       "12287  2018-09-03 00:08:10.640  46.0   \n",
       "5046   2018-09-02 23:14:59.659   0.0   \n",
       "10122  2018-09-02 23:14:59.920   0.0   \n",
       "1237   2018-09-02 23:14:59.809   0.0   \n",
       "3741   2018-09-02 23:34:59.684   0.0   \n",
       "12128  2018-09-02 23:54:59.827   0.0   \n",
       "5173   2018-09-02 23:54:59.806   0.0   \n",
       "4894   2018-09-02 23:55:00.050   0.0   \n",
       "9167   2018-09-03 01:04:31.596  47.0   \n",
       "12056  2018-09-03 00:14:59.723   0.0   \n",
       "3553   2018-09-03 00:14:59.966   0.0   \n",
       "1663   2018-09-03 00:34:29.709   0.0   \n",
       "1074   2018-09-03 00:34:30.448   0.0   \n",
       "13389  2018-09-03 00:34:29.717   0.0   \n",
       "7872   2018-09-03 00:54:59.967   0.0   \n",
       "11824  2018-09-03 02:04:34.653  46.0   \n",
       "1567   2018-09-03 01:14:59.944   0.0   \n",
       "2560   2018-09-03 01:14:59.694   0.0   \n",
       "9118   2018-09-03 01:34:59.814   0.0   \n",
       "13197  2018-09-03 01:34:59.964   0.0   \n",
       "8416   2018-09-03 01:35:00.075   0.0   \n",
       "9889   2018-09-03 03:01:08.731  48.0   \n",
       "8696   2018-09-03 02:50:32.764   0.0   \n",
       "9290   2018-09-03 02:50:33.530   0.0   \n",
       "3201   2018-09-03 04:23:44.513  60.0   \n",
       "9845   2018-09-03 05:03:46.682  71.0   \n",
       "12878  2018-09-03 06:09:19.546  74.0   \n",
       "176    2018-09-03 07:02:38.382  61.0   \n",
       "2533   2018-09-03 08:04:10.030  61.0   \n",
       "5161   2018-09-03 08:04:10.098  56.0   \n",
       "\n",
       "                                            binning_data  \\\n",
       "10779                                                NaN   \n",
       "9878                                                 NaN   \n",
       "3311                                                 NaN   \n",
       "5162                                                 NaN   \n",
       "11990                                                NaN   \n",
       "31                                                   NaN   \n",
       "8799                                                 NaN   \n",
       "2296                                                 NaN   \n",
       "10554                                                NaN   \n",
       "4555                                                 NaN   \n",
       "3343                                                 NaN   \n",
       "1025                                                 NaN   \n",
       "714                                                  NaN   \n",
       "5554                                                 NaN   \n",
       "10964                                                NaN   \n",
       "2944                                                 NaN   \n",
       "10860                                                NaN   \n",
       "3390                                                 NaN   \n",
       "12687                                                NaN   \n",
       "11552                                                NaN   \n",
       "13288                                                NaN   \n",
       "11808                                                NaN   \n",
       "9135                                                 NaN   \n",
       "10105                                                NaN   \n",
       "1980                                                 NaN   \n",
       "11074                                                NaN   \n",
       "1082                                                 NaN   \n",
       "4018                                                 NaN   \n",
       "8789                                                 NaN   \n",
       "10457                                                NaN   \n",
       "...                                                  ...   \n",
       "12287  eab70251-7025-9e1f-d87b-b76af55686ff.binning_d...   \n",
       "5046                                                 NaN   \n",
       "10122                                                NaN   \n",
       "1237                                                 NaN   \n",
       "3741                                                 NaN   \n",
       "12128                                                NaN   \n",
       "5173                                                 NaN   \n",
       "4894                                                 NaN   \n",
       "9167   ae0fc694-aaef-118b-465b-088267c720db.binning_d...   \n",
       "12056                                                NaN   \n",
       "3553                                                 NaN   \n",
       "1663                                                 NaN   \n",
       "1074                                                 NaN   \n",
       "13389                                                NaN   \n",
       "7872                                                 NaN   \n",
       "11824  e16a5e3c-1c8b-06eb-ad77-0ac8eee718c3.binning_d...   \n",
       "1567                                                 NaN   \n",
       "2560                                                 NaN   \n",
       "9118                                                 NaN   \n",
       "13197                                                NaN   \n",
       "8416                                                 NaN   \n",
       "9889   bbb97e02-0a02-ead7-12e0-bfc005baa2e5.binning_d...   \n",
       "8696                                                 NaN   \n",
       "9290                                                 NaN   \n",
       "3201   3d563558-3f29-21bd-6744-0d44ef2109c3.binning_d...   \n",
       "9845   baef0ee2-7fe9-73cb-3747-91da21e218d9.binning_d...   \n",
       "12878  f5f89298-ac93-9be3-f12d-84b90f6d87c2.binning_d...   \n",
       "176    03328f38-246b-d0a1-0208-1a6dc43a1168.binning_d...   \n",
       "2533   310638aa-dfe7-e348-1e65-3d9f99fee1cc.binning_d...   \n",
       "5161   62b808ef-5a36-a963-8dd0-7141a9501214.binning_d...   \n",
       "\n",
       "                                   datauuid   comment  \n",
       "10779  cc83c429-d843-0e49-628f-ce952cc134cf       NaN  \n",
       "9878   bb7b0cba-27ec-f10e-9707-4d102b7c5e7e       NaN  \n",
       "3311   3f17ac2e-84dd-4351-db57-86196f7b3dfb       NaN  \n",
       "5162   62bdb3f9-5f89-4cee-84e7-979a970846cf       NaN  \n",
       "11990  e4fae0ee-4662-4513-9244-18f7bc5fc2f3       NaN  \n",
       "31     0089c258-3465-49b2-a721-0cd1fe2142eb       NaN  \n",
       "8799   a79a84cd-07fc-4c46-b438-840cf1256e81       NaN  \n",
       "2296   2cc963ec-d775-4ca2-9809-a43542d57085       NaN  \n",
       "10554  c8c007c0-7e1f-4537-bb93-7221cac491f2       NaN  \n",
       "4555   57562db1-5cc2-440b-8e40-98d029b8ddce       NaN  \n",
       "3343   3feee7f6-9e14-449b-a612-b18f9d616514       NaN  \n",
       "1025   14ab589f-3797-49f0-9395-18f94a414546       NaN  \n",
       "714    0e66031f-c8b2-4c8b-9a6d-babaac8cce3f       NaN  \n",
       "5554   69f015c4-8cea-447c-b72f-0e8c7f132783       NaN  \n",
       "10964  d053d62c-5d5e-456b-be71-c977f921b632       NaN  \n",
       "2944   38ea0202-aca8-45ec-b1fc-e5ee3c27605b       NaN  \n",
       "10860  ce16178f-0dc2-4327-974e-18ad97dc09a9       NaN  \n",
       "3390   4127d153-7ff5-45b4-8920-79ca9db0c39f       NaN  \n",
       "12687  f2b94350-bed5-4588-a841-47e2a7e66836       NaN  \n",
       "11552  dc18c24c-2867-41f7-8fcb-9395b1fbc8a5       NaN  \n",
       "13288  fe0d129f-1645-49c3-aca9-0951e36b1aea       NaN  \n",
       "11808  e10dd589-0238-474d-9738-a769f3e52764       NaN  \n",
       "9135   ad87a44e-5cfa-4f73-99e0-ba680c2da8cd  Exercise  \n",
       "10105  bfe45cc9-2c05-4a5b-8788-3696d9673384       NaN  \n",
       "1980   2707bac6-b683-44f7-8041-30fa48363201       NaN  \n",
       "11074  d2a3882c-c27c-43db-b82c-39b84c502403       NaN  \n",
       "1082   15caab3d-9437-48d5-916a-48cfca3d9223       NaN  \n",
       "4018   4d161969-41b8-4f70-86a4-dc37f8ef36d7       NaN  \n",
       "8789   a7642657-2836-4ae2-9f0a-73d5828875bf       NaN  \n",
       "10457  c6f671af-15d0-46ef-873f-7afca9eadbc1       NaN  \n",
       "...                                     ...       ...  \n",
       "12287  eab70251-7025-9e1f-d87b-b76af55686ff       NaN  \n",
       "5046   60cb83bd-748b-b9df-eaa1-5bc6a6cb4ced       NaN  \n",
       "10122  c0352870-5d91-b946-12ee-668584bdbc63       NaN  \n",
       "1237   18bd1da2-3a22-f26b-9841-c15b936aa18b       NaN  \n",
       "3741   476f4a1c-c6c2-1a4f-0bf0-f04ea38c9cec       NaN  \n",
       "12128  e7a994a9-e396-b797-ef51-72504543cabe       NaN  \n",
       "5173   62e05115-3783-0a9c-8e82-5f094308f820       NaN  \n",
       "4894   5dbe1063-4d00-d8dd-e4ff-17df8e3f0f27       NaN  \n",
       "9167   ae0fc694-aaef-118b-465b-088267c720db       NaN  \n",
       "12056  e6539efd-8e17-f294-75ad-7c16473f4848       NaN  \n",
       "3553   43f992ab-b2a0-731d-fe17-5169af233425       NaN  \n",
       "1663   205fcc18-f78a-93c0-292b-36c2c3d34a58       NaN  \n",
       "1074   15bade36-064d-0528-a01b-ed1c749a5ff8       NaN  \n",
       "13389  ffe940cd-4f45-4f17-0bb1-226b3bcf7b63       NaN  \n",
       "7872   952fe250-af67-cc6d-7597-b55d94b1e1e3       NaN  \n",
       "11824  e16a5e3c-1c8b-06eb-ad77-0ac8eee718c3       NaN  \n",
       "1567   1ebe31cb-ced6-ccd6-d79a-4b483f658bbb       NaN  \n",
       "2560   31736f09-baa3-0364-42cf-9b80055c6a01       NaN  \n",
       "9118   ad528d94-a7c4-69db-b013-e7adbdee5924       NaN  \n",
       "13197  fbffc3ab-1552-60d9-7b8f-080dde18aee8       NaN  \n",
       "8416   a030da29-9421-9c26-9062-81b2b2cf7518       NaN  \n",
       "9889   bbb97e02-0a02-ead7-12e0-bfc005baa2e5       NaN  \n",
       "8696   a59792cb-61a1-2e4c-811b-a3f51b1c3fa3       NaN  \n",
       "9290   b07e907f-b68e-62fc-6244-8e6aaf12ca52       NaN  \n",
       "3201   3d563558-3f29-21bd-6744-0d44ef2109c3       NaN  \n",
       "9845   baef0ee2-7fe9-73cb-3747-91da21e218d9       NaN  \n",
       "12878  f5f89298-ac93-9be3-f12d-84b90f6d87c2       NaN  \n",
       "176    03328f38-246b-d0a1-0208-1a6dc43a1168       NaN  \n",
       "2533   310638aa-dfe7-e348-1e65-3d9f99fee1cc       NaN  \n",
       "5161   62b808ef-5a36-a963-8dd0-7141a9501214       NaN  \n",
       "\n",
       "[13395 rows x 15 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hr_df.sort_values(by=\"start_time\", inplace=True, ascending=True)\n",
    "hr_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "hr_df.loc[:, \"start_time\"] = pd.to_datetime(hr_df[\"start_time\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "base_val = dt.datetime(1970, 1, 1)\n",
    "epoch_val = pd.to_datetime(\"2018-09-01 00:00:00\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "hr_df = hr_df[hr_df[\"start_time\"] < epoch_val]\n",
    "hr_df.sort_values(by=\"start_time\", ascending=False, inplace=True)\n",
    "hr_df_orig = hr_df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.date(2018, 8, 31)"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for it, row in hr_df.head(1).iterrows():\n",
    "    check_time = row[\"start_time\"]\n",
    "    \n",
    "check_time.date()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/root/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n"
     ]
    },
    {
     "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>max</th>\n",
       "      <th>min</th>\n",
       "      <th>heart_rate</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>time_offset</th>\n",
       "      <th>binning_data</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2340</th>\n",
       "      <td>79.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 00:00:00.000</td>\n",
       "      <td>2018-08-31 00:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>2d8398c4-4e42-a8a7-60ce-6de0ae6e8f80.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10313</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2018-08-31 00:00:29.303</td>\n",
       "      <td>2018-08-31 00:00:29.303</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3722</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2018-08-31 00:10:29.304</td>\n",
       "      <td>2018-08-31 00:10:29.304</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2744</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2018-08-31 00:10:29.305</td>\n",
       "      <td>2018-08-31 00:10:29.305</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8393</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2018-08-31 00:20:29.307</td>\n",
       "      <td>2018-08-31 00:20:29.307</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10853</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2018-08-31 00:20:29.308</td>\n",
       "      <td>2018-08-31 00:20:29.308</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7165</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2018-08-31 00:50:29.316</td>\n",
       "      <td>2018-08-31 00:50:29.316</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3800</th>\n",
       "      <td>78.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 01:00:00.000</td>\n",
       "      <td>2018-08-31 01:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>48a23289-ed17-a045-2b8e-bf5320c7e6c2.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>2018-08-31 01:00:29.318</td>\n",
       "      <td>2018-08-31 01:00:29.318</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2018-08-31 01:10:29.221</td>\n",
       "      <td>2018-08-31 01:10:29.221</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7132</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2018-08-31 01:20:29.222</td>\n",
       "      <td>2018-08-31 01:20:29.222</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5702</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 01:40:29.227</td>\n",
       "      <td>2018-08-31 01:40:29.227</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4503</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>2018-08-31 01:50:29.230</td>\n",
       "      <td>2018-08-31 01:50:29.230</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3580</th>\n",
       "      <td>74.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 02:00:00.000</td>\n",
       "      <td>2018-08-31 02:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>44ae1b8b-7fdb-3467-7dad-60adccf79e44.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12405</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2018-08-31 02:00:29.234</td>\n",
       "      <td>2018-08-31 02:00:29.234</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11629</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2018-08-31 02:40:29.244</td>\n",
       "      <td>2018-08-31 02:40:29.244</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9617</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>2018-08-31 02:50:29.246</td>\n",
       "      <td>2018-08-31 02:50:29.246</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7050</th>\n",
       "      <td>58.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2018-08-31 03:00:00.000</td>\n",
       "      <td>2018-08-31 03:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>85ac8ebe-7168-0e60-dfe8-27114fe72925.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10787</th>\n",
       "      <td>98.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>2018-08-31 04:00:00.000</td>\n",
       "      <td>2018-08-31 04:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>cc93812a-647a-282f-e37c-6eed67bc9577.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>120.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>2018-08-31 05:00:00.000</td>\n",
       "      <td>2018-08-31 05:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>05d21652-dd9d-585d-471a-edbf59e7e4e5.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7526</th>\n",
       "      <td>90.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>2018-08-31 06:00:00.000</td>\n",
       "      <td>2018-08-31 06:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>8eb986ce-5421-717c-f99f-e3591f7fbbb6.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8190</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2018-08-31 06:00:29.288</td>\n",
       "      <td>2018-08-31 06:00:29.288</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8074</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>2018-08-31 06:10:29.291</td>\n",
       "      <td>2018-08-31 06:10:29.291</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13199</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2018-08-31 06:20:29.294</td>\n",
       "      <td>2018-08-31 06:20:29.294</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9104</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>2018-08-31 06:40:48.311</td>\n",
       "      <td>2018-08-31 06:40:48.311</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6613</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>2018-08-31 06:40:48.312</td>\n",
       "      <td>2018-08-31 06:40:48.312</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9944</th>\n",
       "      <td>116.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>2018-08-31 07:00:00.000</td>\n",
       "      <td>2018-08-31 07:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>bcaa501e-7006-97ed-2c5e-5da496b5eded.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5061</th>\n",
       "      <td>129.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>2018-08-31 08:00:00.000</td>\n",
       "      <td>2018-08-31 08:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>60fe7780-3ab6-3abe-2c97-7a39aea42b15.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12838</th>\n",
       "      <td>111.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2018-08-31 09:00:00.000</td>\n",
       "      <td>2018-08-31 09:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>f53f3fbe-c063-8d60-d006-59678d1e2eb8.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11014</th>\n",
       "      <td>102.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>2018-08-31 10:00:00.000</td>\n",
       "      <td>2018-08-31 10:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>d156e530-3334-2b02-a925-8fadae164220.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12280</th>\n",
       "      <td>93.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>2018-08-31 11:00:00.000</td>\n",
       "      <td>2018-08-31 11:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>ea9135ad-faa6-834c-ad1f-1870e905e189.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3121</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2018-08-31 11:00:29.270</td>\n",
       "      <td>2018-08-31 11:00:29.270</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8481</th>\n",
       "      <td>79.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2018-08-31 12:00:00.000</td>\n",
       "      <td>2018-08-31 12:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>a19ab51f-01bc-7b4b-744f-9bd44985d922.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5178</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 12:20:29.290</td>\n",
       "      <td>2018-08-31 12:20:29.290</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7449</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2018-08-31 12:20:29.291</td>\n",
       "      <td>2018-08-31 12:20:29.291</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10881</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2018-08-31 12:40:29.295</td>\n",
       "      <td>2018-08-31 12:40:29.295</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4471</th>\n",
       "      <td>102.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2018-08-31 13:00:00.000</td>\n",
       "      <td>2018-08-31 13:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>55c3800e-1a9c-f65e-1107-882a72d0666e.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4417</th>\n",
       "      <td>94.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>2018-08-31 14:00:00.000</td>\n",
       "      <td>2018-08-31 14:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>54a4961f-8792-20dc-f0a3-7653c5d640f1.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5283</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>2018-08-31 14:10:29.318</td>\n",
       "      <td>2018-08-31 14:10:29.318</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4318</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>2018-08-31 14:20:31.622</td>\n",
       "      <td>2018-08-31 14:20:31.622</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8700</th>\n",
       "      <td>112.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>2018-08-31 15:00:00.000</td>\n",
       "      <td>2018-08-31 15:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>a5a5101a-a58e-28d4-4860-039febfcde9d.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11730</th>\n",
       "      <td>111.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2018-08-31 16:00:00.000</td>\n",
       "      <td>2018-08-31 16:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>df782a0b-8fb8-386f-0e94-c37df25aa366.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2851</th>\n",
       "      <td>109.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>2018-08-31 17:00:00.000</td>\n",
       "      <td>2018-08-31 17:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>37213520-577a-db5f-c591-ecdb0e5af0e5.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2700</th>\n",
       "      <td>106.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>2018-08-31 18:00:00.000</td>\n",
       "      <td>2018-08-31 18:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>344899c0-4976-b4ff-3571-ac842505e3d9.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10563</th>\n",
       "      <td>89.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>2018-08-31 19:00:00.000</td>\n",
       "      <td>2018-08-31 19:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>c8df8bdb-df9e-b726-54fe-176adfc4f18b.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12570</th>\n",
       "      <td>105.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2018-08-31 20:00:00.000</td>\n",
       "      <td>2018-08-31 20:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>eff78eb2-9ffb-c17d-216e-889e9e763488.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12837</th>\n",
       "      <td>80.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2018-08-31 21:00:00.000</td>\n",
       "      <td>2018-08-31 21:59:59.999</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>f53b4477-0a83-b25f-1369-078bc4084081.binning_d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6987</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2018-08-31 21:10:29.299</td>\n",
       "      <td>2018-08-31 21:10:29.299</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9715</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2018-08-31 21:10:29.300</td>\n",
       "      <td>2018-08-31 21:10:29.300</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5932</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2018-08-31 21:20:29.302</td>\n",
       "      <td>2018-08-31 21:20:29.302</td>\n",
       "      <td>UTC+0400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         max   min  heart_rate              start_time  \\\n",
       "2340    79.0  47.0        55.0 2018-08-31 00:00:00.000   \n",
       "10313    0.0   0.0        54.0 2018-08-31 00:00:29.303   \n",
       "3722     0.0   0.0        57.0 2018-08-31 00:10:29.304   \n",
       "2744     0.0   0.0        57.0 2018-08-31 00:10:29.305   \n",
       "8393     0.0   0.0        56.0 2018-08-31 00:20:29.307   \n",
       "10853    0.0   0.0        56.0 2018-08-31 00:20:29.308   \n",
       "7165     0.0   0.0        52.0 2018-08-31 00:50:29.316   \n",
       "3800    78.0  49.0        55.0 2018-08-31 01:00:00.000   \n",
       "652      0.0   0.0        51.0 2018-08-31 01:00:29.318   \n",
       "829      0.0   0.0        52.0 2018-08-31 01:10:29.221   \n",
       "7132     0.0   0.0        52.0 2018-08-31 01:20:29.222   \n",
       "5702     0.0   0.0        55.0 2018-08-31 01:40:29.227   \n",
       "4503     0.0   0.0        61.0 2018-08-31 01:50:29.230   \n",
       "3580    74.0  51.0        55.0 2018-08-31 02:00:00.000   \n",
       "12405    0.0   0.0        60.0 2018-08-31 02:00:29.234   \n",
       "11629    0.0   0.0        54.0 2018-08-31 02:40:29.244   \n",
       "9617     0.0   0.0        54.0 2018-08-31 02:50:29.246   \n",
       "7050    58.0  52.0        53.0 2018-08-31 03:00:00.000   \n",
       "10787   98.0  77.0        85.0 2018-08-31 04:00:00.000   \n",
       "306    120.0  64.0        84.0 2018-08-31 05:00:00.000   \n",
       "7526    90.0  63.0        69.0 2018-08-31 06:00:00.000   \n",
       "8190     0.0   0.0        70.0 2018-08-31 06:00:29.288   \n",
       "8074     0.0   0.0        69.0 2018-08-31 06:10:29.291   \n",
       "13199    0.0   0.0        70.0 2018-08-31 06:20:29.294   \n",
       "9104     0.0   0.0        68.0 2018-08-31 06:40:48.311   \n",
       "6613     0.0   0.0        68.0 2018-08-31 06:40:48.312   \n",
       "9944   116.0  63.0        80.0 2018-08-31 07:00:00.000   \n",
       "5061   129.0  66.0        84.0 2018-08-31 08:00:00.000   \n",
       "12838  111.0  60.0        70.0 2018-08-31 09:00:00.000   \n",
       "11014  102.0  55.0        66.0 2018-08-31 10:00:00.000   \n",
       "12280   93.0  55.0        66.0 2018-08-31 11:00:00.000   \n",
       "3121     0.0   0.0        60.0 2018-08-31 11:00:29.270   \n",
       "8481    79.0  53.0        56.0 2018-08-31 12:00:00.000   \n",
       "5178     0.0   0.0        55.0 2018-08-31 12:20:29.290   \n",
       "7449     0.0   0.0        55.0 2018-08-31 12:20:29.291   \n",
       "10881    0.0   0.0        57.0 2018-08-31 12:40:29.295   \n",
       "4471   102.0  61.0        76.0 2018-08-31 13:00:00.000   \n",
       "4417    94.0  61.0        72.0 2018-08-31 14:00:00.000   \n",
       "5283     0.0   0.0        77.0 2018-08-31 14:10:29.318   \n",
       "4318     0.0   0.0        72.0 2018-08-31 14:20:31.622   \n",
       "8700   112.0  65.0        81.0 2018-08-31 15:00:00.000   \n",
       "11730  111.0  57.0        76.0 2018-08-31 16:00:00.000   \n",
       "2851   109.0  59.0        73.0 2018-08-31 17:00:00.000   \n",
       "2700   106.0  57.0        68.0 2018-08-31 18:00:00.000   \n",
       "10563   89.0  64.0        75.0 2018-08-31 19:00:00.000   \n",
       "12570  105.0  55.0        70.0 2018-08-31 20:00:00.000   \n",
       "12837   80.0  51.0        57.0 2018-08-31 21:00:00.000   \n",
       "6987     0.0   0.0        60.0 2018-08-31 21:10:29.299   \n",
       "9715     0.0   0.0        60.0 2018-08-31 21:10:29.300   \n",
       "5932     0.0   0.0        56.0 2018-08-31 21:20:29.302   \n",
       "\n",
       "                      end_time time_offset  \\\n",
       "2340   2018-08-31 00:59:59.999    UTC+0400   \n",
       "10313  2018-08-31 00:00:29.303    UTC+0400   \n",
       "3722   2018-08-31 00:10:29.304    UTC+0400   \n",
       "2744   2018-08-31 00:10:29.305    UTC+0400   \n",
       "8393   2018-08-31 00:20:29.307    UTC+0400   \n",
       "10853  2018-08-31 00:20:29.308    UTC+0400   \n",
       "7165   2018-08-31 00:50:29.316    UTC+0400   \n",
       "3800   2018-08-31 01:59:59.999    UTC+0400   \n",
       "652    2018-08-31 01:00:29.318    UTC+0400   \n",
       "829    2018-08-31 01:10:29.221    UTC+0400   \n",
       "7132   2018-08-31 01:20:29.222    UTC+0400   \n",
       "5702   2018-08-31 01:40:29.227    UTC+0400   \n",
       "4503   2018-08-31 01:50:29.230    UTC+0400   \n",
       "3580   2018-08-31 02:59:59.999    UTC+0400   \n",
       "12405  2018-08-31 02:00:29.234    UTC+0400   \n",
       "11629  2018-08-31 02:40:29.244    UTC+0400   \n",
       "9617   2018-08-31 02:50:29.246    UTC+0400   \n",
       "7050   2018-08-31 03:59:59.999    UTC+0400   \n",
       "10787  2018-08-31 04:59:59.999    UTC+0400   \n",
       "306    2018-08-31 05:59:59.999    UTC+0400   \n",
       "7526   2018-08-31 06:59:59.999    UTC+0400   \n",
       "8190   2018-08-31 06:00:29.288    UTC+0400   \n",
       "8074   2018-08-31 06:10:29.291    UTC+0400   \n",
       "13199  2018-08-31 06:20:29.294    UTC+0400   \n",
       "9104   2018-08-31 06:40:48.311    UTC+0400   \n",
       "6613   2018-08-31 06:40:48.312    UTC+0400   \n",
       "9944   2018-08-31 07:59:59.999    UTC+0400   \n",
       "5061   2018-08-31 08:59:59.999    UTC+0400   \n",
       "12838  2018-08-31 09:59:59.999    UTC+0400   \n",
       "11014  2018-08-31 10:59:59.999    UTC+0400   \n",
       "12280  2018-08-31 11:59:59.999    UTC+0400   \n",
       "3121   2018-08-31 11:00:29.270    UTC+0400   \n",
       "8481   2018-08-31 12:59:59.999    UTC+0400   \n",
       "5178   2018-08-31 12:20:29.290    UTC+0400   \n",
       "7449   2018-08-31 12:20:29.291    UTC+0400   \n",
       "10881  2018-08-31 12:40:29.295    UTC+0400   \n",
       "4471   2018-08-31 13:59:59.999    UTC+0400   \n",
       "4417   2018-08-31 14:59:59.999    UTC+0400   \n",
       "5283   2018-08-31 14:10:29.318    UTC+0400   \n",
       "4318   2018-08-31 14:20:31.622    UTC+0400   \n",
       "8700   2018-08-31 15:59:59.999    UTC+0400   \n",
       "11730  2018-08-31 16:59:59.999    UTC+0400   \n",
       "2851   2018-08-31 17:59:59.999    UTC+0400   \n",
       "2700   2018-08-31 18:59:59.999    UTC+0400   \n",
       "10563  2018-08-31 19:59:59.999    UTC+0400   \n",
       "12570  2018-08-31 20:59:59.999    UTC+0400   \n",
       "12837  2018-08-31 21:59:59.999    UTC+0400   \n",
       "6987   2018-08-31 21:10:29.299    UTC+0400   \n",
       "9715   2018-08-31 21:10:29.300    UTC+0400   \n",
       "5932   2018-08-31 21:20:29.302    UTC+0400   \n",
       "\n",
       "                                            binning_data  \n",
       "2340   2d8398c4-4e42-a8a7-60ce-6de0ae6e8f80.binning_d...  \n",
       "10313                                                NaN  \n",
       "3722                                                 NaN  \n",
       "2744                                                 NaN  \n",
       "8393                                                 NaN  \n",
       "10853                                                NaN  \n",
       "7165                                                 NaN  \n",
       "3800   48a23289-ed17-a045-2b8e-bf5320c7e6c2.binning_d...  \n",
       "652                                                  NaN  \n",
       "829                                                  NaN  \n",
       "7132                                                 NaN  \n",
       "5702                                                 NaN  \n",
       "4503                                                 NaN  \n",
       "3580   44ae1b8b-7fdb-3467-7dad-60adccf79e44.binning_d...  \n",
       "12405                                                NaN  \n",
       "11629                                                NaN  \n",
       "9617                                                 NaN  \n",
       "7050   85ac8ebe-7168-0e60-dfe8-27114fe72925.binning_d...  \n",
       "10787  cc93812a-647a-282f-e37c-6eed67bc9577.binning_d...  \n",
       "306    05d21652-dd9d-585d-471a-edbf59e7e4e5.binning_d...  \n",
       "7526   8eb986ce-5421-717c-f99f-e3591f7fbbb6.binning_d...  \n",
       "8190                                                 NaN  \n",
       "8074                                                 NaN  \n",
       "13199                                                NaN  \n",
       "9104                                                 NaN  \n",
       "6613                                                 NaN  \n",
       "9944   bcaa501e-7006-97ed-2c5e-5da496b5eded.binning_d...  \n",
       "5061   60fe7780-3ab6-3abe-2c97-7a39aea42b15.binning_d...  \n",
       "12838  f53f3fbe-c063-8d60-d006-59678d1e2eb8.binning_d...  \n",
       "11014  d156e530-3334-2b02-a925-8fadae164220.binning_d...  \n",
       "12280  ea9135ad-faa6-834c-ad1f-1870e905e189.binning_d...  \n",
       "3121                                                 NaN  \n",
       "8481   a19ab51f-01bc-7b4b-744f-9bd44985d922.binning_d...  \n",
       "5178                                                 NaN  \n",
       "7449                                                 NaN  \n",
       "10881                                                NaN  \n",
       "4471   55c3800e-1a9c-f65e-1107-882a72d0666e.binning_d...  \n",
       "4417   54a4961f-8792-20dc-f0a3-7653c5d640f1.binning_d...  \n",
       "5283                                                 NaN  \n",
       "4318                                                 NaN  \n",
       "8700   a5a5101a-a58e-28d4-4860-039febfcde9d.binning_d...  \n",
       "11730  df782a0b-8fb8-386f-0e94-c37df25aa366.binning_d...  \n",
       "2851   37213520-577a-db5f-c591-ecdb0e5af0e5.binning_d...  \n",
       "2700   344899c0-4976-b4ff-3571-ac842505e3d9.binning_d...  \n",
       "10563  c8df8bdb-df9e-b726-54fe-176adfc4f18b.binning_d...  \n",
       "12570  eff78eb2-9ffb-c17d-216e-889e9e763488.binning_d...  \n",
       "12837  f53b4477-0a83-b25f-1369-078bc4084081.binning_d...  \n",
       "6987                                                 NaN  \n",
       "9715                                                 NaN  \n",
       "5932                                                 NaN  "
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check_df = hr_df[hr_df[\"start_time\"].dt.date == check_time.date()]\n",
    "check_df.sort_values(by=\"start_time\", ascending=True, inplace=True)\n",
    "check_df[[\"max\", \"min\", \"heart_rate\", \"start_time\", \"end_time\", \"time_offset\", \"binning_data\"]].head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>max</th>\n",
       "      <th>heart_beat_count</th>\n",
       "      <th>custom</th>\n",
       "      <th>heart_rate</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>68.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>34.735294</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.926471</td>\n",
       "      <td>20.411765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>48.449579</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.270509</td>\n",
       "      <td>28.134663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>55.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>89.250000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>52.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>129.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>111.000000</td>\n",
       "      <td>77.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              max  heart_beat_count  custom  heart_rate        min\n",
       "count   68.000000              68.0     0.0   68.000000  68.000000\n",
       "mean    34.735294               1.0     NaN   62.926471  20.411765\n",
       "std     48.449579               0.0     NaN   11.270509  28.134663\n",
       "min      0.000000               1.0     NaN   51.000000   0.000000\n",
       "25%      0.000000               1.0     NaN   55.000000   0.000000\n",
       "50%      0.000000               1.0     NaN   57.000000   0.000000\n",
       "75%     89.250000               1.0     NaN   70.000000  52.250000\n",
       "max    129.000000               1.0     NaN  111.000000  77.000000"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "129.0"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check_df[\"max\"].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "47.0"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check_df[check_df[\"min\"] > 0][\"min\"].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "62.9264705882353"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "check_df[\"heart_rate\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## No binning data or no min/max data = Resting heart rate\n",
    "## With binning data, it is active time or exercise time\n",
    "## Can filter day and night time resting rates based on time filters\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}