Apple Health Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "DistanceWalkingRunning = pd.read_csv(\"DistanceWalkingRunning.csv\",parse_dates=True)\n",
    "StepCount = pd.read_csv(\"StepCount.csv\",parse_dates=True)\n",
    "FlightsClimbed = pd.read_csv(\"FlightsClimbed.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sourceName</th>\n",
       "      <th>sourceVersion</th>\n",
       "      <th>device</th>\n",
       "      <th>type</th>\n",
       "      <th>unit</th>\n",
       "      <th>creationDate</th>\n",
       "      <th>startDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049fa40&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:04:02 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>0.05479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f8b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>0.01064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f810&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>0.13241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f770&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>2017-09-27 08:37:41 +0530</td>\n",
       "      <td>0.25867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f6d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 09:44:28 +0530</td>\n",
       "      <td>2017-09-27 09:09:32 +0530</td>\n",
       "      <td>2017-09-27 09:16:00 +0530</td>\n",
       "      <td>0.00690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f3b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 09:44:28 +0530</td>\n",
       "      <td>2017-09-27 09:16:00 +0530</td>\n",
       "      <td>2017-09-27 09:24:43 +0530</td>\n",
       "      <td>0.26844</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f5e0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 10:46:09 +0530</td>\n",
       "      <td>2017-09-27 09:34:34 +0530</td>\n",
       "      <td>2017-09-27 09:44:32 +0530</td>\n",
       "      <td>0.19726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f590&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 10:46:09 +0530</td>\n",
       "      <td>2017-09-27 09:44:32 +0530</td>\n",
       "      <td>2017-09-27 09:49:42 +0530</td>\n",
       "      <td>0.06906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f4f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 11:47:33 +0530</td>\n",
       "      <td>2017-09-27 11:29:02 +0530</td>\n",
       "      <td>2017-09-27 11:37:39 +0530</td>\n",
       "      <td>0.09767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f450&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 12:45:37 +0530</td>\n",
       "      <td>2017-09-27 11:37:39 +0530</td>\n",
       "      <td>2017-09-27 11:40:58 +0530</td>\n",
       "      <td>0.00859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f360&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 13:45:54 +0530</td>\n",
       "      <td>2017-09-27 12:47:27 +0530</td>\n",
       "      <td>2017-09-27 12:57:16 +0530</td>\n",
       "      <td>0.12292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f270&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 13:45:54 +0530</td>\n",
       "      <td>2017-09-27 13:30:06 +0530</td>\n",
       "      <td>2017-09-27 13:40:05 +0530</td>\n",
       "      <td>0.16777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f1d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 13:40:05 +0530</td>\n",
       "      <td>2017-09-27 13:45:55 +0530</td>\n",
       "      <td>0.07441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f130&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 14:02:39 +0530</td>\n",
       "      <td>2017-09-27 14:12:38 +0530</td>\n",
       "      <td>0.02743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f090&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 14:12:38 +0530</td>\n",
       "      <td>2017-09-27 14:20:00 +0530</td>\n",
       "      <td>0.24316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049efa0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 16:44:16 +0530</td>\n",
       "      <td>2017-09-27 16:26:47 +0530</td>\n",
       "      <td>2017-09-27 16:36:25 +0530</td>\n",
       "      <td>0.11365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049eff0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 17:44:58 +0530</td>\n",
       "      <td>2017-09-27 16:36:25 +0530</td>\n",
       "      <td>2017-09-27 16:38:08 +0530</td>\n",
       "      <td>0.00957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049edc0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 18:47:12 +0530</td>\n",
       "      <td>2017-09-27 18:57:11 +0530</td>\n",
       "      <td>0.23743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049ed20&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 18:57:11 +0530</td>\n",
       "      <td>2017-09-27 19:02:43 +0530</td>\n",
       "      <td>0.07678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049ec80&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 19:14:41 +0530</td>\n",
       "      <td>2017-09-27 19:23:59 +0530</td>\n",
       "      <td>0.16156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049ebe0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:01:52 +0530</td>\n",
       "      <td>2017-09-27 20:11:51 +0530</td>\n",
       "      <td>0.21399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049eb40&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:11:51 +0530</td>\n",
       "      <td>2017-09-27 20:21:34 +0530</td>\n",
       "      <td>0.33167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049eaa0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:21:34 +0530</td>\n",
       "      <td>2017-09-27 20:28:20 +0530</td>\n",
       "      <td>0.06029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049ea00&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:29:29 +0530</td>\n",
       "      <td>2017-09-27 20:38:57 +0530</td>\n",
       "      <td>0.01423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e960&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 21:51:28 +0530</td>\n",
       "      <td>2017-09-27 20:38:57 +0530</td>\n",
       "      <td>2017-09-27 20:48:55 +0530</td>\n",
       "      <td>0.11725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e8c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 21:51:28 +0530</td>\n",
       "      <td>2017-09-27 20:48:55 +0530</td>\n",
       "      <td>2017-09-27 20:58:53 +0530</td>\n",
       "      <td>0.07756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e820&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 21:51:28 +0530</td>\n",
       "      <td>2017-09-27 20:58:53 +0530</td>\n",
       "      <td>2017-09-27 21:06:28 +0530</td>\n",
       "      <td>0.01021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e780&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 22:54:45 +0530</td>\n",
       "      <td>2017-09-27 22:17:13 +0530</td>\n",
       "      <td>2017-09-27 22:26:22 +0530</td>\n",
       "      <td>0.02447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e6e0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 22:54:45 +0530</td>\n",
       "      <td>2017-09-27 22:26:22 +0530</td>\n",
       "      <td>2017-09-27 22:30:06 +0530</td>\n",
       "      <td>0.00560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049e640&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-28 07:49:52 +0530</td>\n",
       "      <td>2017-09-28 06:51:50 +0530</td>\n",
       "      <td>2017-09-28 06:58:28 +0530</td>\n",
       "      <td>0.02135</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1990</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685410&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:04:44 +0530</td>\n",
       "      <td>2018-01-19 08:14:43 +0530</td>\n",
       "      <td>0.72504</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1991</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1706854b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:14:43 +0530</td>\n",
       "      <td>2018-01-19 08:24:29 +0530</td>\n",
       "      <td>0.73498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1992</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685550&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:24:29 +0530</td>\n",
       "      <td>2018-01-19 08:34:28 +0530</td>\n",
       "      <td>0.03527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1706855f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:34:28 +0530</td>\n",
       "      <td>2018-01-19 08:44:26 +0530</td>\n",
       "      <td>0.01999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685690&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:44:26 +0530</td>\n",
       "      <td>2018-01-19 08:54:24 +0530</td>\n",
       "      <td>0.01506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428ff00&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 09:10:32 +0530</td>\n",
       "      <td>2018-01-19 08:54:24 +0530</td>\n",
       "      <td>2018-01-19 08:55:18 +0530</td>\n",
       "      <td>0.01564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428ffa0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 11:21:12 +0530</td>\n",
       "      <td>2018-01-19 10:14:05 +0530</td>\n",
       "      <td>2018-01-19 10:23:26 +0530</td>\n",
       "      <td>0.02012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x174290040&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 11:21:12 +0530</td>\n",
       "      <td>2018-01-19 10:23:26 +0530</td>\n",
       "      <td>2018-01-19 10:33:06 +0530</td>\n",
       "      <td>0.03516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1742900e0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 11:21:12 +0530</td>\n",
       "      <td>2018-01-19 10:33:06 +0530</td>\n",
       "      <td>2018-01-19 10:38:27 +0530</td>\n",
       "      <td>0.00440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x174290220&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 15:18:48 +0530</td>\n",
       "      <td>2018-01-19 14:31:07 +0530</td>\n",
       "      <td>2018-01-19 14:38:26 +0530</td>\n",
       "      <td>0.01221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685870&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-19 19:08:10 +0530</td>\n",
       "      <td>2018-01-19 18:24:10 +0530</td>\n",
       "      <td>2018-01-19 18:33:35 +0530</td>\n",
       "      <td>0.01976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685780&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 08:09:09 +0530</td>\n",
       "      <td>2018-01-20 07:22:22 +0530</td>\n",
       "      <td>2018-01-20 07:32:14 +0530</td>\n",
       "      <td>0.02774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685910&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 08:09:09 +0530</td>\n",
       "      <td>2018-01-20 07:32:14 +0530</td>\n",
       "      <td>2018-01-20 07:42:12 +0530</td>\n",
       "      <td>0.57104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1706859b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 08:09:09 +0530</td>\n",
       "      <td>2018-01-20 07:42:12 +0530</td>\n",
       "      <td>2018-01-20 07:52:10 +0530</td>\n",
       "      <td>0.73781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685a50&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 08:09:09 +0530</td>\n",
       "      <td>2018-01-20 07:52:10 +0530</td>\n",
       "      <td>2018-01-20 08:02:08 +0530</td>\n",
       "      <td>0.72015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685af0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 09:09:05 +0530</td>\n",
       "      <td>2018-01-20 08:02:08 +0530</td>\n",
       "      <td>2018-01-20 08:11:33 +0530</td>\n",
       "      <td>0.67012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685b90&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 09:09:05 +0530</td>\n",
       "      <td>2018-01-20 08:11:33 +0530</td>\n",
       "      <td>2018-01-20 08:16:17 +0530</td>\n",
       "      <td>0.03180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685c80&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 09:09:05 +0530</td>\n",
       "      <td>2018-01-20 08:37:16 +0530</td>\n",
       "      <td>2018-01-20 08:46:55 +0530</td>\n",
       "      <td>0.06845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685d20&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 09:09:05 +0530</td>\n",
       "      <td>2018-01-20 08:46:55 +0530</td>\n",
       "      <td>2018-01-20 08:55:48 +0530</td>\n",
       "      <td>0.01237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685dc0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 09:09:05 +0530</td>\n",
       "      <td>2018-01-20 08:55:48 +0530</td>\n",
       "      <td>2018-01-20 09:02:11 +0530</td>\n",
       "      <td>0.04483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685e60&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 10:12:54 +0530</td>\n",
       "      <td>2018-01-20 09:54:31 +0530</td>\n",
       "      <td>2018-01-20 10:04:30 +0530</td>\n",
       "      <td>0.04937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685eb0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 11:13:00 +0530</td>\n",
       "      <td>2018-01-20 10:04:30 +0530</td>\n",
       "      <td>2018-01-20 10:13:07 +0530</td>\n",
       "      <td>0.50541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685f50&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 11:13:00 +0530</td>\n",
       "      <td>2018-01-20 10:16:45 +0530</td>\n",
       "      <td>2018-01-20 10:24:05 +0530</td>\n",
       "      <td>0.02488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170685ff0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 11:13:00 +0530</td>\n",
       "      <td>2018-01-20 10:24:05 +0530</td>\n",
       "      <td>2018-01-20 10:31:45 +0530</td>\n",
       "      <td>0.03876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170686090&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 11:13:00 +0530</td>\n",
       "      <td>2018-01-20 10:40:53 +0530</td>\n",
       "      <td>2018-01-20 10:50:11 +0530</td>\n",
       "      <td>0.00685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170686130&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 11:13:00 +0530</td>\n",
       "      <td>2018-01-20 10:50:11 +0530</td>\n",
       "      <td>2018-01-20 10:57:30 +0530</td>\n",
       "      <td>0.01831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1706861d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 17:10:19 +0530</td>\n",
       "      <td>2018-01-20 16:05:18 +0530</td>\n",
       "      <td>2018-01-20 16:12:24 +0530</td>\n",
       "      <td>0.02605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170686270&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 17:10:19 +0530</td>\n",
       "      <td>2018-01-20 16:12:24 +0530</td>\n",
       "      <td>2018-01-20 16:20:33 +0530</td>\n",
       "      <td>0.01525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170686310&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 17:10:19 +0530</td>\n",
       "      <td>2018-01-20 16:20:33 +0530</td>\n",
       "      <td>2018-01-20 16:27:07 +0530</td>\n",
       "      <td>0.00048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1706863b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2018-01-20 17:10:19 +0530</td>\n",
       "      <td>2018-01-20 16:28:35 +0530</td>\n",
       "      <td>2018-01-20 16:38:34 +0530</td>\n",
       "      <td>0.04047</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2020 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              sourceName sourceVersion  \\\n",
       "0     Sivabalan’s iPhone        10.3.3   \n",
       "1     Sivabalan’s iPhone        10.3.3   \n",
       "2     Sivabalan’s iPhone        10.3.3   \n",
       "3     Sivabalan’s iPhone        10.3.3   \n",
       "4     Sivabalan’s iPhone        10.3.3   \n",
       "5     Sivabalan’s iPhone        10.3.3   \n",
       "6     Sivabalan’s iPhone        10.3.3   \n",
       "7     Sivabalan’s iPhone        10.3.3   \n",
       "8     Sivabalan’s iPhone        10.3.3   \n",
       "9     Sivabalan’s iPhone        10.3.3   \n",
       "10    Sivabalan’s iPhone        10.3.3   \n",
       "11    Sivabalan’s iPhone        10.3.3   \n",
       "12    Sivabalan’s iPhone        10.3.3   \n",
       "13    Sivabalan’s iPhone        10.3.3   \n",
       "14    Sivabalan’s iPhone        10.3.3   \n",
       "15    Sivabalan’s iPhone        10.3.3   \n",
       "16    Sivabalan’s iPhone        10.3.3   \n",
       "17    Sivabalan’s iPhone        10.3.3   \n",
       "18    Sivabalan’s iPhone        10.3.3   \n",
       "19    Sivabalan’s iPhone        10.3.3   \n",
       "20    Sivabalan’s iPhone        10.3.3   \n",
       "21    Sivabalan’s iPhone        10.3.3   \n",
       "22    Sivabalan’s iPhone        10.3.3   \n",
       "23    Sivabalan’s iPhone        10.3.3   \n",
       "24    Sivabalan’s iPhone        10.3.3   \n",
       "25    Sivabalan’s iPhone        10.3.3   \n",
       "26    Sivabalan’s iPhone        10.3.3   \n",
       "27    Sivabalan’s iPhone        10.3.3   \n",
       "28    Sivabalan’s iPhone        10.3.3   \n",
       "29    Sivabalan’s iPhone        10.3.3   \n",
       "...                  ...           ...   \n",
       "1990  Sivabalan’s iPhone        10.3.3   \n",
       "1991  Sivabalan’s iPhone        10.3.3   \n",
       "1992  Sivabalan’s iPhone        10.3.3   \n",
       "1993  Sivabalan’s iPhone        10.3.3   \n",
       "1994  Sivabalan’s iPhone        10.3.3   \n",
       "1995  Sivabalan’s iPhone        10.3.3   \n",
       "1996  Sivabalan’s iPhone        10.3.3   \n",
       "1997  Sivabalan’s iPhone        10.3.3   \n",
       "1998  Sivabalan’s iPhone        10.3.3   \n",
       "1999  Sivabalan’s iPhone        10.3.3   \n",
       "2000  Sivabalan’s iPhone        10.3.3   \n",
       "2001  Sivabalan’s iPhone        10.3.3   \n",
       "2002  Sivabalan’s iPhone        10.3.3   \n",
       "2003  Sivabalan’s iPhone        10.3.3   \n",
       "2004  Sivabalan’s iPhone        10.3.3   \n",
       "2005  Sivabalan’s iPhone        10.3.3   \n",
       "2006  Sivabalan’s iPhone        10.3.3   \n",
       "2007  Sivabalan’s iPhone        10.3.3   \n",
       "2008  Sivabalan’s iPhone        10.3.3   \n",
       "2009  Sivabalan’s iPhone        10.3.3   \n",
       "2010  Sivabalan’s iPhone        10.3.3   \n",
       "2011  Sivabalan’s iPhone        10.3.3   \n",
       "2012  Sivabalan’s iPhone        10.3.3   \n",
       "2013  Sivabalan’s iPhone        10.3.3   \n",
       "2014  Sivabalan’s iPhone        10.3.3   \n",
       "2015  Sivabalan’s iPhone        10.3.3   \n",
       "2016  Sivabalan’s iPhone        10.3.3   \n",
       "2017  Sivabalan’s iPhone        10.3.3   \n",
       "2018  Sivabalan’s iPhone        10.3.3   \n",
       "2019  Sivabalan’s iPhone        10.3.3   \n",
       "\n",
       "                                                 device  \\\n",
       "0     <<HKDevice: 0x17049fa40>, name:iPhone, manufac...   \n",
       "1     <<HKDevice: 0x17049f8b0>, name:iPhone, manufac...   \n",
       "2     <<HKDevice: 0x17049f810>, name:iPhone, manufac...   \n",
       "3     <<HKDevice: 0x17049f770>, name:iPhone, manufac...   \n",
       "4     <<HKDevice: 0x17049f6d0>, name:iPhone, manufac...   \n",
       "5     <<HKDevice: 0x17049f3b0>, name:iPhone, manufac...   \n",
       "6     <<HKDevice: 0x17049f5e0>, name:iPhone, manufac...   \n",
       "7     <<HKDevice: 0x17049f590>, name:iPhone, manufac...   \n",
       "8     <<HKDevice: 0x17049f4f0>, name:iPhone, manufac...   \n",
       "9     <<HKDevice: 0x17049f450>, name:iPhone, manufac...   \n",
       "10    <<HKDevice: 0x17049f360>, name:iPhone, manufac...   \n",
       "11    <<HKDevice: 0x17049f270>, name:iPhone, manufac...   \n",
       "12    <<HKDevice: 0x17049f1d0>, name:iPhone, manufac...   \n",
       "13    <<HKDevice: 0x17049f130>, name:iPhone, manufac...   \n",
       "14    <<HKDevice: 0x17049f090>, name:iPhone, manufac...   \n",
       "15    <<HKDevice: 0x17049efa0>, name:iPhone, manufac...   \n",
       "16    <<HKDevice: 0x17049eff0>, name:iPhone, manufac...   \n",
       "17    <<HKDevice: 0x17049edc0>, name:iPhone, manufac...   \n",
       "18    <<HKDevice: 0x17049ed20>, name:iPhone, manufac...   \n",
       "19    <<HKDevice: 0x17049ec80>, name:iPhone, manufac...   \n",
       "20    <<HKDevice: 0x17049ebe0>, name:iPhone, manufac...   \n",
       "21    <<HKDevice: 0x17049eb40>, name:iPhone, manufac...   \n",
       "22    <<HKDevice: 0x17049eaa0>, name:iPhone, manufac...   \n",
       "23    <<HKDevice: 0x17049ea00>, name:iPhone, manufac...   \n",
       "24    <<HKDevice: 0x17049e960>, name:iPhone, manufac...   \n",
       "25    <<HKDevice: 0x17049e8c0>, name:iPhone, manufac...   \n",
       "26    <<HKDevice: 0x17049e820>, name:iPhone, manufac...   \n",
       "27    <<HKDevice: 0x17049e780>, name:iPhone, manufac...   \n",
       "28    <<HKDevice: 0x17049e6e0>, name:iPhone, manufac...   \n",
       "29    <<HKDevice: 0x17049e640>, name:iPhone, manufac...   \n",
       "...                                                 ...   \n",
       "1990  <<HKDevice: 0x170685410>, name:iPhone, manufac...   \n",
       "1991  <<HKDevice: 0x1706854b0>, name:iPhone, manufac...   \n",
       "1992  <<HKDevice: 0x170685550>, name:iPhone, manufac...   \n",
       "1993  <<HKDevice: 0x1706855f0>, name:iPhone, manufac...   \n",
       "1994  <<HKDevice: 0x170685690>, name:iPhone, manufac...   \n",
       "1995  <<HKDevice: 0x17428ff00>, name:iPhone, manufac...   \n",
       "1996  <<HKDevice: 0x17428ffa0>, name:iPhone, manufac...   \n",
       "1997  <<HKDevice: 0x174290040>, name:iPhone, manufac...   \n",
       "1998  <<HKDevice: 0x1742900e0>, name:iPhone, manufac...   \n",
       "1999  <<HKDevice: 0x174290220>, name:iPhone, manufac...   \n",
       "2000  <<HKDevice: 0x170685870>, name:iPhone, manufac...   \n",
       "2001  <<HKDevice: 0x170685780>, name:iPhone, manufac...   \n",
       "2002  <<HKDevice: 0x170685910>, name:iPhone, manufac...   \n",
       "2003  <<HKDevice: 0x1706859b0>, name:iPhone, manufac...   \n",
       "2004  <<HKDevice: 0x170685a50>, name:iPhone, manufac...   \n",
       "2005  <<HKDevice: 0x170685af0>, name:iPhone, manufac...   \n",
       "2006  <<HKDevice: 0x170685b90>, name:iPhone, manufac...   \n",
       "2007  <<HKDevice: 0x170685c80>, name:iPhone, manufac...   \n",
       "2008  <<HKDevice: 0x170685d20>, name:iPhone, manufac...   \n",
       "2009  <<HKDevice: 0x170685dc0>, name:iPhone, manufac...   \n",
       "2010  <<HKDevice: 0x170685e60>, name:iPhone, manufac...   \n",
       "2011  <<HKDevice: 0x170685eb0>, name:iPhone, manufac...   \n",
       "2012  <<HKDevice: 0x170685f50>, name:iPhone, manufac...   \n",
       "2013  <<HKDevice: 0x170685ff0>, name:iPhone, manufac...   \n",
       "2014  <<HKDevice: 0x170686090>, name:iPhone, manufac...   \n",
       "2015  <<HKDevice: 0x170686130>, name:iPhone, manufac...   \n",
       "2016  <<HKDevice: 0x1706861d0>, name:iPhone, manufac...   \n",
       "2017  <<HKDevice: 0x170686270>, name:iPhone, manufac...   \n",
       "2018  <<HKDevice: 0x170686310>, name:iPhone, manufac...   \n",
       "2019  <<HKDevice: 0x1706863b0>, name:iPhone, manufac...   \n",
       "\n",
       "                        type unit               creationDate  \\\n",
       "0     DistanceWalkingRunning   km  2017-09-27 08:45:59 +0530   \n",
       "1     DistanceWalkingRunning   km  2017-09-27 08:45:59 +0530   \n",
       "2     DistanceWalkingRunning   km  2017-09-27 08:45:59 +0530   \n",
       "3     DistanceWalkingRunning   km  2017-09-27 08:45:59 +0530   \n",
       "4     DistanceWalkingRunning   km  2017-09-27 09:44:28 +0530   \n",
       "5     DistanceWalkingRunning   km  2017-09-27 09:44:28 +0530   \n",
       "6     DistanceWalkingRunning   km  2017-09-27 10:46:09 +0530   \n",
       "7     DistanceWalkingRunning   km  2017-09-27 10:46:09 +0530   \n",
       "8     DistanceWalkingRunning   km  2017-09-27 11:47:33 +0530   \n",
       "9     DistanceWalkingRunning   km  2017-09-27 12:45:37 +0530   \n",
       "10    DistanceWalkingRunning   km  2017-09-27 13:45:54 +0530   \n",
       "11    DistanceWalkingRunning   km  2017-09-27 13:45:54 +0530   \n",
       "12    DistanceWalkingRunning   km  2017-09-27 14:44:51 +0530   \n",
       "13    DistanceWalkingRunning   km  2017-09-27 14:44:51 +0530   \n",
       "14    DistanceWalkingRunning   km  2017-09-27 14:44:51 +0530   \n",
       "15    DistanceWalkingRunning   km  2017-09-27 16:44:16 +0530   \n",
       "16    DistanceWalkingRunning   km  2017-09-27 17:44:58 +0530   \n",
       "17    DistanceWalkingRunning   km  2017-09-27 19:45:12 +0530   \n",
       "18    DistanceWalkingRunning   km  2017-09-27 19:45:12 +0530   \n",
       "19    DistanceWalkingRunning   km  2017-09-27 19:45:12 +0530   \n",
       "20    DistanceWalkingRunning   km  2017-09-27 20:45:16 +0530   \n",
       "21    DistanceWalkingRunning   km  2017-09-27 20:45:16 +0530   \n",
       "22    DistanceWalkingRunning   km  2017-09-27 20:45:16 +0530   \n",
       "23    DistanceWalkingRunning   km  2017-09-27 20:45:16 +0530   \n",
       "24    DistanceWalkingRunning   km  2017-09-27 21:51:28 +0530   \n",
       "25    DistanceWalkingRunning   km  2017-09-27 21:51:28 +0530   \n",
       "26    DistanceWalkingRunning   km  2017-09-27 21:51:28 +0530   \n",
       "27    DistanceWalkingRunning   km  2017-09-27 22:54:45 +0530   \n",
       "28    DistanceWalkingRunning   km  2017-09-27 22:54:45 +0530   \n",
       "29    DistanceWalkingRunning   km  2017-09-28 07:49:52 +0530   \n",
       "...                      ...  ...                        ...   \n",
       "1990  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1991  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1992  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1993  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1994  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1995  DistanceWalkingRunning   km  2018-01-19 09:10:32 +0530   \n",
       "1996  DistanceWalkingRunning   km  2018-01-19 11:21:12 +0530   \n",
       "1997  DistanceWalkingRunning   km  2018-01-19 11:21:12 +0530   \n",
       "1998  DistanceWalkingRunning   km  2018-01-19 11:21:12 +0530   \n",
       "1999  DistanceWalkingRunning   km  2018-01-19 15:18:48 +0530   \n",
       "2000  DistanceWalkingRunning   km  2018-01-19 19:08:10 +0530   \n",
       "2001  DistanceWalkingRunning   km  2018-01-20 08:09:09 +0530   \n",
       "2002  DistanceWalkingRunning   km  2018-01-20 08:09:09 +0530   \n",
       "2003  DistanceWalkingRunning   km  2018-01-20 08:09:09 +0530   \n",
       "2004  DistanceWalkingRunning   km  2018-01-20 08:09:09 +0530   \n",
       "2005  DistanceWalkingRunning   km  2018-01-20 09:09:05 +0530   \n",
       "2006  DistanceWalkingRunning   km  2018-01-20 09:09:05 +0530   \n",
       "2007  DistanceWalkingRunning   km  2018-01-20 09:09:05 +0530   \n",
       "2008  DistanceWalkingRunning   km  2018-01-20 09:09:05 +0530   \n",
       "2009  DistanceWalkingRunning   km  2018-01-20 09:09:05 +0530   \n",
       "2010  DistanceWalkingRunning   km  2018-01-20 10:12:54 +0530   \n",
       "2011  DistanceWalkingRunning   km  2018-01-20 11:13:00 +0530   \n",
       "2012  DistanceWalkingRunning   km  2018-01-20 11:13:00 +0530   \n",
       "2013  DistanceWalkingRunning   km  2018-01-20 11:13:00 +0530   \n",
       "2014  DistanceWalkingRunning   km  2018-01-20 11:13:00 +0530   \n",
       "2015  DistanceWalkingRunning   km  2018-01-20 11:13:00 +0530   \n",
       "2016  DistanceWalkingRunning   km  2018-01-20 17:10:19 +0530   \n",
       "2017  DistanceWalkingRunning   km  2018-01-20 17:10:19 +0530   \n",
       "2018  DistanceWalkingRunning   km  2018-01-20 17:10:19 +0530   \n",
       "2019  DistanceWalkingRunning   km  2018-01-20 17:10:19 +0530   \n",
       "\n",
       "                      startDate                    endDate    value  \n",
       "0     2017-09-27 08:04:02 +0530  2017-09-27 08:13:53 +0530  0.05479  \n",
       "1     2017-09-27 08:13:53 +0530  2017-09-27 08:23:09 +0530  0.01064  \n",
       "2     2017-09-27 08:23:09 +0530  2017-09-27 08:33:08 +0530  0.13241  \n",
       "3     2017-09-27 08:33:08 +0530  2017-09-27 08:37:41 +0530  0.25867  \n",
       "4     2017-09-27 09:09:32 +0530  2017-09-27 09:16:00 +0530  0.00690  \n",
       "5     2017-09-27 09:16:00 +0530  2017-09-27 09:24:43 +0530  0.26844  \n",
       "6     2017-09-27 09:34:34 +0530  2017-09-27 09:44:32 +0530  0.19726  \n",
       "7     2017-09-27 09:44:32 +0530  2017-09-27 09:49:42 +0530  0.06906  \n",
       "8     2017-09-27 11:29:02 +0530  2017-09-27 11:37:39 +0530  0.09767  \n",
       "9     2017-09-27 11:37:39 +0530  2017-09-27 11:40:58 +0530  0.00859  \n",
       "10    2017-09-27 12:47:27 +0530  2017-09-27 12:57:16 +0530  0.12292  \n",
       "11    2017-09-27 13:30:06 +0530  2017-09-27 13:40:05 +0530  0.16777  \n",
       "12    2017-09-27 13:40:05 +0530  2017-09-27 13:45:55 +0530  0.07441  \n",
       "13    2017-09-27 14:02:39 +0530  2017-09-27 14:12:38 +0530  0.02743  \n",
       "14    2017-09-27 14:12:38 +0530  2017-09-27 14:20:00 +0530  0.24316  \n",
       "15    2017-09-27 16:26:47 +0530  2017-09-27 16:36:25 +0530  0.11365  \n",
       "16    2017-09-27 16:36:25 +0530  2017-09-27 16:38:08 +0530  0.00957  \n",
       "17    2017-09-27 18:47:12 +0530  2017-09-27 18:57:11 +0530  0.23743  \n",
       "18    2017-09-27 18:57:11 +0530  2017-09-27 19:02:43 +0530  0.07678  \n",
       "19    2017-09-27 19:14:41 +0530  2017-09-27 19:23:59 +0530  0.16156  \n",
       "20    2017-09-27 20:01:52 +0530  2017-09-27 20:11:51 +0530  0.21399  \n",
       "21    2017-09-27 20:11:51 +0530  2017-09-27 20:21:34 +0530  0.33167  \n",
       "22    2017-09-27 20:21:34 +0530  2017-09-27 20:28:20 +0530  0.06029  \n",
       "23    2017-09-27 20:29:29 +0530  2017-09-27 20:38:57 +0530  0.01423  \n",
       "24    2017-09-27 20:38:57 +0530  2017-09-27 20:48:55 +0530  0.11725  \n",
       "25    2017-09-27 20:48:55 +0530  2017-09-27 20:58:53 +0530  0.07756  \n",
       "26    2017-09-27 20:58:53 +0530  2017-09-27 21:06:28 +0530  0.01021  \n",
       "27    2017-09-27 22:17:13 +0530  2017-09-27 22:26:22 +0530  0.02447  \n",
       "28    2017-09-27 22:26:22 +0530  2017-09-27 22:30:06 +0530  0.00560  \n",
       "29    2017-09-28 06:51:50 +0530  2017-09-28 06:58:28 +0530  0.02135  \n",
       "...                         ...                        ...      ...  \n",
       "1990  2018-01-19 08:04:44 +0530  2018-01-19 08:14:43 +0530  0.72504  \n",
       "1991  2018-01-19 08:14:43 +0530  2018-01-19 08:24:29 +0530  0.73498  \n",
       "1992  2018-01-19 08:24:29 +0530  2018-01-19 08:34:28 +0530  0.03527  \n",
       "1993  2018-01-19 08:34:28 +0530  2018-01-19 08:44:26 +0530  0.01999  \n",
       "1994  2018-01-19 08:44:26 +0530  2018-01-19 08:54:24 +0530  0.01506  \n",
       "1995  2018-01-19 08:54:24 +0530  2018-01-19 08:55:18 +0530  0.01564  \n",
       "1996  2018-01-19 10:14:05 +0530  2018-01-19 10:23:26 +0530  0.02012  \n",
       "1997  2018-01-19 10:23:26 +0530  2018-01-19 10:33:06 +0530  0.03516  \n",
       "1998  2018-01-19 10:33:06 +0530  2018-01-19 10:38:27 +0530  0.00440  \n",
       "1999  2018-01-19 14:31:07 +0530  2018-01-19 14:38:26 +0530  0.01221  \n",
       "2000  2018-01-19 18:24:10 +0530  2018-01-19 18:33:35 +0530  0.01976  \n",
       "2001  2018-01-20 07:22:22 +0530  2018-01-20 07:32:14 +0530  0.02774  \n",
       "2002  2018-01-20 07:32:14 +0530  2018-01-20 07:42:12 +0530  0.57104  \n",
       "2003  2018-01-20 07:42:12 +0530  2018-01-20 07:52:10 +0530  0.73781  \n",
       "2004  2018-01-20 07:52:10 +0530  2018-01-20 08:02:08 +0530  0.72015  \n",
       "2005  2018-01-20 08:02:08 +0530  2018-01-20 08:11:33 +0530  0.67012  \n",
       "2006  2018-01-20 08:11:33 +0530  2018-01-20 08:16:17 +0530  0.03180  \n",
       "2007  2018-01-20 08:37:16 +0530  2018-01-20 08:46:55 +0530  0.06845  \n",
       "2008  2018-01-20 08:46:55 +0530  2018-01-20 08:55:48 +0530  0.01237  \n",
       "2009  2018-01-20 08:55:48 +0530  2018-01-20 09:02:11 +0530  0.04483  \n",
       "2010  2018-01-20 09:54:31 +0530  2018-01-20 10:04:30 +0530  0.04937  \n",
       "2011  2018-01-20 10:04:30 +0530  2018-01-20 10:13:07 +0530  0.50541  \n",
       "2012  2018-01-20 10:16:45 +0530  2018-01-20 10:24:05 +0530  0.02488  \n",
       "2013  2018-01-20 10:24:05 +0530  2018-01-20 10:31:45 +0530  0.03876  \n",
       "2014  2018-01-20 10:40:53 +0530  2018-01-20 10:50:11 +0530  0.00685  \n",
       "2015  2018-01-20 10:50:11 +0530  2018-01-20 10:57:30 +0530  0.01831  \n",
       "2016  2018-01-20 16:05:18 +0530  2018-01-20 16:12:24 +0530  0.02605  \n",
       "2017  2018-01-20 16:12:24 +0530  2018-01-20 16:20:33 +0530  0.01525  \n",
       "2018  2018-01-20 16:20:33 +0530  2018-01-20 16:27:07 +0530  0.00048  \n",
       "2019  2018-01-20 16:28:35 +0530  2018-01-20 16:38:34 +0530  0.04047  \n",
       "\n",
       "[2020 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DistanceWalkingRunning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sourceName</th>\n",
       "      <th>sourceVersion</th>\n",
       "      <th>device</th>\n",
       "      <th>type</th>\n",
       "      <th>unit</th>\n",
       "      <th>creationDate</th>\n",
       "      <th>startDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x174290040&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:34:07 +0530</td>\n",
       "      <td>2017-09-27 08:34:07 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428ffa0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 10:46:09 +0530</td>\n",
       "      <td>2017-09-27 09:42:09 +0530</td>\n",
       "      <td>2017-09-27 09:42:09 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fe60&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 10:46:09 +0530</td>\n",
       "      <td>2017-09-27 09:42:29 +0530</td>\n",
       "      <td>2017-09-27 09:42:29 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fdc0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 14:18:33 +0530</td>\n",
       "      <td>2017-09-27 14:18:33 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fd20&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 14:18:43 +0530</td>\n",
       "      <td>2017-09-27 14:18:43 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fc80&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 14:44:51 +0530</td>\n",
       "      <td>2017-09-27 14:18:58 +0530</td>\n",
       "      <td>2017-09-27 14:18:58 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fbe0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 19:23:13 +0530</td>\n",
       "      <td>2017-09-27 19:23:13 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fb90&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 19:23:20 +0530</td>\n",
       "      <td>2017-09-27 19:23:20 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428faf0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 19:45:12 +0530</td>\n",
       "      <td>2017-09-27 19:23:59 +0530</td>\n",
       "      <td>2017-09-27 19:23:59 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428fa50&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:11:18 +0530</td>\n",
       "      <td>2017-09-27 20:11:18 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f9b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:11:30 +0530</td>\n",
       "      <td>2017-09-27 20:11:30 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f8c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-27 20:45:16 +0530</td>\n",
       "      <td>2017-09-27 20:13:18 +0530</td>\n",
       "      <td>2017-09-27 20:13:18 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f820&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 08:44:03 +0530</td>\n",
       "      <td>2017-09-28 08:34:07 +0530</td>\n",
       "      <td>2017-09-28 08:34:07 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f780&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 10:17:43 +0530</td>\n",
       "      <td>2017-09-28 09:36:10 +0530</td>\n",
       "      <td>2017-09-28 09:36:10 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f140&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 10:17:43 +0530</td>\n",
       "      <td>2017-09-28 09:36:44 +0530</td>\n",
       "      <td>2017-09-28 09:36:44 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f230&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 11:24:17 +0530</td>\n",
       "      <td>2017-09-28 11:11:34 +0530</td>\n",
       "      <td>2017-09-28 11:11:34 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428e970&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 11:24:17 +0530</td>\n",
       "      <td>2017-09-28 11:12:00 +0530</td>\n",
       "      <td>2017-09-28 11:12:00 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428ef60&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 12:44:35 +0530</td>\n",
       "      <td>2017-09-28 11:59:52 +0530</td>\n",
       "      <td>2017-09-28 11:59:52 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f2d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 12:44:35 +0530</td>\n",
       "      <td>2017-09-28 12:00:05 +0530</td>\n",
       "      <td>2017-09-28 12:00:05 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428d160&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 12:44:35 +0530</td>\n",
       "      <td>2017-09-28 12:00:18 +0530</td>\n",
       "      <td>2017-09-28 12:00:18 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428eec0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 14:44:59 +0530</td>\n",
       "      <td>2017-09-28 13:58:37 +0530</td>\n",
       "      <td>2017-09-28 13:58:37 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428eba0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 14:44:59 +0530</td>\n",
       "      <td>2017-09-28 13:58:55 +0530</td>\n",
       "      <td>2017-09-28 13:58:55 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428f3c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 15:45:30 +0530</td>\n",
       "      <td>2017-09-28 15:18:05 +0530</td>\n",
       "      <td>2017-09-28 15:18:05 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c5d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 15:45:30 +0530</td>\n",
       "      <td>2017-09-28 15:18:26 +0530</td>\n",
       "      <td>2017-09-28 15:18:26 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c530&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 17:47:15 +0530</td>\n",
       "      <td>2017-09-28 17:28:38 +0530</td>\n",
       "      <td>2017-09-28 17:28:38 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c490&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 17:47:15 +0530</td>\n",
       "      <td>2017-09-28 17:28:53 +0530</td>\n",
       "      <td>2017-09-28 17:28:53 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c3f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 23:54:06 +0530</td>\n",
       "      <td>2017-09-28 22:16:44 +0530</td>\n",
       "      <td>2017-09-28 22:16:44 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c350&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-28 23:54:06 +0530</td>\n",
       "      <td>2017-09-28 22:18:01 +0530</td>\n",
       "      <td>2017-09-28 22:18:01 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c2b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-29 14:33:24 +0530</td>\n",
       "      <td>2017-09-29 13:38:33 +0530</td>\n",
       "      <td>2017-09-29 13:38:33 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17428c210&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-09-30 12:23:53 +0530</td>\n",
       "      <td>2017-09-30 11:55:40 +0530</td>\n",
       "      <td>2017-09-30 11:55:40 +0530</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b850&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 12:24:14 +0530</td>\n",
       "      <td>2017-11-20 11:28:48 +0530</td>\n",
       "      <td>2017-11-20 11:28:48 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029ab30&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 12:24:14 +0530</td>\n",
       "      <td>2017-11-20 11:29:03 +0530</td>\n",
       "      <td>2017-11-20 11:29:03 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029ae50&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 12:24:14 +0530</td>\n",
       "      <td>2017-11-20 11:30:28 +0530</td>\n",
       "      <td>2017-11-20 11:30:28 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029aef0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 12:24:14 +0530</td>\n",
       "      <td>2017-11-20 12:12:22 +0530</td>\n",
       "      <td>2017-11-20 12:12:22 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b350&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 12:24:14 +0530</td>\n",
       "      <td>2017-11-20 12:12:45 +0530</td>\n",
       "      <td>2017-11-20 12:12:45 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b3f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 16:10:55 +0530</td>\n",
       "      <td>2017-11-20 15:19:13 +0530</td>\n",
       "      <td>2017-11-20 15:19:13 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b620&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 17:08:59 +0530</td>\n",
       "      <td>2017-11-20 16:44:56 +0530</td>\n",
       "      <td>2017-11-20 16:44:56 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029aae0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 18:10:49 +0530</td>\n",
       "      <td>2017-11-20 17:12:11 +0530</td>\n",
       "      <td>2017-11-20 17:12:11 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029aa90&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 18:10:49 +0530</td>\n",
       "      <td>2017-11-20 17:16:18 +0530</td>\n",
       "      <td>2017-11-20 17:16:18 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029a900&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 18:10:49 +0530</td>\n",
       "      <td>2017-11-20 17:16:31 +0530</td>\n",
       "      <td>2017-11-20 17:16:31 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029afe0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-20 18:10:49 +0530</td>\n",
       "      <td>2017-11-20 18:09:19 +0530</td>\n",
       "      <td>2017-11-20 18:09:19 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b0d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-11-24 08:38:00 +0530</td>\n",
       "      <td>2017-11-24 08:21:07 +0530</td>\n",
       "      <td>2017-11-24 08:21:07 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b6c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2017-12-09 15:55:39 +0530</td>\n",
       "      <td>2017-12-09 15:40:45 +0530</td>\n",
       "      <td>2017-12-09 15:40:45 +0530</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029b760&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-10 19:12:17 +0530</td>\n",
       "      <td>2018-01-10 18:12:40 +0530</td>\n",
       "      <td>2018-01-10 18:12:40 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170298650&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-10 20:44:12 +0530</td>\n",
       "      <td>2018-01-10 19:20:09 +0530</td>\n",
       "      <td>2018-01-10 19:20:09 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702986f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-10 20:44:12 +0530</td>\n",
       "      <td>2018-01-10 19:25:33 +0530</td>\n",
       "      <td>2018-01-10 19:25:33 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702986a0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-10 20:44:12 +0530</td>\n",
       "      <td>2018-01-10 19:38:53 +0530</td>\n",
       "      <td>2018-01-10 19:38:53 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170298600&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 13:43:47 +0530</td>\n",
       "      <td>2018-01-11 12:20:14 +0530</td>\n",
       "      <td>2018-01-11 12:20:14 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170298510&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 13:43:47 +0530</td>\n",
       "      <td>2018-01-11 12:41:26 +0530</td>\n",
       "      <td>2018-01-11 12:41:26 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702984c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 15:09:08 +0530</td>\n",
       "      <td>2018-01-11 14:07:25 +0530</td>\n",
       "      <td>2018-01-11 14:07:25 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170299320&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 16:06:01 +0530</td>\n",
       "      <td>2018-01-11 15:57:14 +0530</td>\n",
       "      <td>2018-01-11 15:57:14 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702992d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 17:11:07 +0530</td>\n",
       "      <td>2018-01-11 16:07:22 +0530</td>\n",
       "      <td>2018-01-11 16:07:22 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702975c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-11 18:12:37 +0530</td>\n",
       "      <td>2018-01-11 17:36:06 +0530</td>\n",
       "      <td>2018-01-11 17:36:06 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702970c0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-12 15:08:15 +0530</td>\n",
       "      <td>2018-01-12 14:37:57 +0530</td>\n",
       "      <td>2018-01-12 14:37:57 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170292750&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-12 16:11:20 +0530</td>\n",
       "      <td>2018-01-12 16:00:29 +0530</td>\n",
       "      <td>2018-01-12 16:00:29 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702926b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-12 20:18:15 +0530</td>\n",
       "      <td>2018-01-12 20:04:25 +0530</td>\n",
       "      <td>2018-01-12 20:04:25 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170290950&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-13 11:06:24 +0530</td>\n",
       "      <td>2018-01-13 10:14:11 +0530</td>\n",
       "      <td>2018-01-13 10:14:11 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x170290860&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-13 12:07:00 +0530</td>\n",
       "      <td>2018-01-13 11:29:47 +0530</td>\n",
       "      <td>2018-01-13 11:29:47 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17029c480&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-13 15:06:57 +0530</td>\n",
       "      <td>2018-01-13 14:23:27 +0530</td>\n",
       "      <td>2018-01-13 14:23:27 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x1702972f0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>FlightsClimbed</td>\n",
       "      <td>count</td>\n",
       "      <td>2018-01-13 18:08:18 +0530</td>\n",
       "      <td>2018-01-13 17:48:17 +0530</td>\n",
       "      <td>2018-01-13 17:48:17 +0530</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>475 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             sourceName sourceVersion  \\\n",
       "0    Sivabalan’s iPhone        10.3.3   \n",
       "1    Sivabalan’s iPhone        10.3.3   \n",
       "2    Sivabalan’s iPhone        10.3.3   \n",
       "3    Sivabalan’s iPhone        10.3.3   \n",
       "4    Sivabalan’s iPhone        10.3.3   \n",
       "5    Sivabalan’s iPhone        10.3.3   \n",
       "6    Sivabalan’s iPhone        10.3.3   \n",
       "7    Sivabalan’s iPhone        10.3.3   \n",
       "8    Sivabalan’s iPhone        10.3.3   \n",
       "9    Sivabalan’s iPhone        10.3.3   \n",
       "10   Sivabalan’s iPhone        10.3.3   \n",
       "11   Sivabalan’s iPhone        10.3.3   \n",
       "12   Sivabalan’s iPhone        10.3.3   \n",
       "13   Sivabalan’s iPhone        10.3.3   \n",
       "14   Sivabalan’s iPhone        10.3.3   \n",
       "15   Sivabalan’s iPhone        10.3.3   \n",
       "16   Sivabalan’s iPhone        10.3.3   \n",
       "17   Sivabalan’s iPhone        10.3.3   \n",
       "18   Sivabalan’s iPhone        10.3.3   \n",
       "19   Sivabalan’s iPhone        10.3.3   \n",
       "20   Sivabalan’s iPhone        10.3.3   \n",
       "21   Sivabalan’s iPhone        10.3.3   \n",
       "22   Sivabalan’s iPhone        10.3.3   \n",
       "23   Sivabalan’s iPhone        10.3.3   \n",
       "24   Sivabalan’s iPhone        10.3.3   \n",
       "25   Sivabalan’s iPhone        10.3.3   \n",
       "26   Sivabalan’s iPhone        10.3.3   \n",
       "27   Sivabalan’s iPhone        10.3.3   \n",
       "28   Sivabalan’s iPhone        10.3.3   \n",
       "29   Sivabalan’s iPhone        10.3.3   \n",
       "..                  ...           ...   \n",
       "445  Sivabalan’s iPhone        10.3.3   \n",
       "446  Sivabalan’s iPhone        10.3.3   \n",
       "447  Sivabalan’s iPhone        10.3.3   \n",
       "448  Sivabalan’s iPhone        10.3.3   \n",
       "449  Sivabalan’s iPhone        10.3.3   \n",
       "450  Sivabalan’s iPhone        10.3.3   \n",
       "451  Sivabalan’s iPhone        10.3.3   \n",
       "452  Sivabalan’s iPhone        10.3.3   \n",
       "453  Sivabalan’s iPhone        10.3.3   \n",
       "454  Sivabalan’s iPhone        10.3.3   \n",
       "455  Sivabalan’s iPhone        10.3.3   \n",
       "456  Sivabalan’s iPhone        10.3.3   \n",
       "457  Sivabalan’s iPhone        10.3.3   \n",
       "458  Sivabalan’s iPhone        10.3.3   \n",
       "459  Sivabalan’s iPhone        10.3.3   \n",
       "460  Sivabalan’s iPhone        10.3.3   \n",
       "461  Sivabalan’s iPhone        10.3.3   \n",
       "462  Sivabalan’s iPhone        10.3.3   \n",
       "463  Sivabalan’s iPhone        10.3.3   \n",
       "464  Sivabalan’s iPhone        10.3.3   \n",
       "465  Sivabalan’s iPhone        10.3.3   \n",
       "466  Sivabalan’s iPhone        10.3.3   \n",
       "467  Sivabalan’s iPhone        10.3.3   \n",
       "468  Sivabalan’s iPhone        10.3.3   \n",
       "469  Sivabalan’s iPhone        10.3.3   \n",
       "470  Sivabalan’s iPhone        10.3.3   \n",
       "471  Sivabalan’s iPhone        10.3.3   \n",
       "472  Sivabalan’s iPhone        10.3.3   \n",
       "473  Sivabalan’s iPhone        10.3.3   \n",
       "474  Sivabalan’s iPhone        10.3.3   \n",
       "\n",
       "                                                device            type   unit  \\\n",
       "0    <<HKDevice: 0x174290040>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "1    <<HKDevice: 0x17428ffa0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "2    <<HKDevice: 0x17428fe60>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "3    <<HKDevice: 0x17428fdc0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "4    <<HKDevice: 0x17428fd20>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "5    <<HKDevice: 0x17428fc80>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "6    <<HKDevice: 0x17428fbe0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "7    <<HKDevice: 0x17428fb90>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "8    <<HKDevice: 0x17428faf0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "9    <<HKDevice: 0x17428fa50>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "10   <<HKDevice: 0x17428f9b0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "11   <<HKDevice: 0x17428f8c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "12   <<HKDevice: 0x17428f820>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "13   <<HKDevice: 0x17428f780>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "14   <<HKDevice: 0x17428f140>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "15   <<HKDevice: 0x17428f230>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "16   <<HKDevice: 0x17428e970>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "17   <<HKDevice: 0x17428ef60>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "18   <<HKDevice: 0x17428f2d0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "19   <<HKDevice: 0x17428d160>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "20   <<HKDevice: 0x17428eec0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "21   <<HKDevice: 0x17428eba0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "22   <<HKDevice: 0x17428f3c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "23   <<HKDevice: 0x17428c5d0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "24   <<HKDevice: 0x17428c530>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "25   <<HKDevice: 0x17428c490>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "26   <<HKDevice: 0x17428c3f0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "27   <<HKDevice: 0x17428c350>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "28   <<HKDevice: 0x17428c2b0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "29   <<HKDevice: 0x17428c210>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "..                                                 ...             ...    ...   \n",
       "445  <<HKDevice: 0x17029b850>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "446  <<HKDevice: 0x17029ab30>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "447  <<HKDevice: 0x17029ae50>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "448  <<HKDevice: 0x17029aef0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "449  <<HKDevice: 0x17029b350>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "450  <<HKDevice: 0x17029b3f0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "451  <<HKDevice: 0x17029b620>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "452  <<HKDevice: 0x17029aae0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "453  <<HKDevice: 0x17029aa90>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "454  <<HKDevice: 0x17029a900>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "455  <<HKDevice: 0x17029afe0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "456  <<HKDevice: 0x17029b0d0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "457  <<HKDevice: 0x17029b6c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "458  <<HKDevice: 0x17029b760>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "459  <<HKDevice: 0x170298650>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "460  <<HKDevice: 0x1702986f0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "461  <<HKDevice: 0x1702986a0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "462  <<HKDevice: 0x170298600>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "463  <<HKDevice: 0x170298510>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "464  <<HKDevice: 0x1702984c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "465  <<HKDevice: 0x170299320>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "466  <<HKDevice: 0x1702992d0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "467  <<HKDevice: 0x1702975c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "468  <<HKDevice: 0x1702970c0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "469  <<HKDevice: 0x170292750>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "470  <<HKDevice: 0x1702926b0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "471  <<HKDevice: 0x170290950>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "472  <<HKDevice: 0x170290860>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "473  <<HKDevice: 0x17029c480>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "474  <<HKDevice: 0x1702972f0>, name:iPhone, manufac...  FlightsClimbed  count   \n",
       "\n",
       "                  creationDate                  startDate  \\\n",
       "0    2017-09-27 08:45:59 +0530  2017-09-27 08:34:07 +0530   \n",
       "1    2017-09-27 10:46:09 +0530  2017-09-27 09:42:09 +0530   \n",
       "2    2017-09-27 10:46:09 +0530  2017-09-27 09:42:29 +0530   \n",
       "3    2017-09-27 14:44:51 +0530  2017-09-27 14:18:33 +0530   \n",
       "4    2017-09-27 14:44:51 +0530  2017-09-27 14:18:43 +0530   \n",
       "5    2017-09-27 14:44:51 +0530  2017-09-27 14:18:58 +0530   \n",
       "6    2017-09-27 19:45:12 +0530  2017-09-27 19:23:13 +0530   \n",
       "7    2017-09-27 19:45:12 +0530  2017-09-27 19:23:20 +0530   \n",
       "8    2017-09-27 19:45:12 +0530  2017-09-27 19:23:59 +0530   \n",
       "9    2017-09-27 20:45:16 +0530  2017-09-27 20:11:18 +0530   \n",
       "10   2017-09-27 20:45:16 +0530  2017-09-27 20:11:30 +0530   \n",
       "11   2017-09-27 20:45:16 +0530  2017-09-27 20:13:18 +0530   \n",
       "12   2017-09-28 08:44:03 +0530  2017-09-28 08:34:07 +0530   \n",
       "13   2017-09-28 10:17:43 +0530  2017-09-28 09:36:10 +0530   \n",
       "14   2017-09-28 10:17:43 +0530  2017-09-28 09:36:44 +0530   \n",
       "15   2017-09-28 11:24:17 +0530  2017-09-28 11:11:34 +0530   \n",
       "16   2017-09-28 11:24:17 +0530  2017-09-28 11:12:00 +0530   \n",
       "17   2017-09-28 12:44:35 +0530  2017-09-28 11:59:52 +0530   \n",
       "18   2017-09-28 12:44:35 +0530  2017-09-28 12:00:05 +0530   \n",
       "19   2017-09-28 12:44:35 +0530  2017-09-28 12:00:18 +0530   \n",
       "20   2017-09-28 14:44:59 +0530  2017-09-28 13:58:37 +0530   \n",
       "21   2017-09-28 14:44:59 +0530  2017-09-28 13:58:55 +0530   \n",
       "22   2017-09-28 15:45:30 +0530  2017-09-28 15:18:05 +0530   \n",
       "23   2017-09-28 15:45:30 +0530  2017-09-28 15:18:26 +0530   \n",
       "24   2017-09-28 17:47:15 +0530  2017-09-28 17:28:38 +0530   \n",
       "25   2017-09-28 17:47:15 +0530  2017-09-28 17:28:53 +0530   \n",
       "26   2017-09-28 23:54:06 +0530  2017-09-28 22:16:44 +0530   \n",
       "27   2017-09-28 23:54:06 +0530  2017-09-28 22:18:01 +0530   \n",
       "28   2017-09-29 14:33:24 +0530  2017-09-29 13:38:33 +0530   \n",
       "29   2017-09-30 12:23:53 +0530  2017-09-30 11:55:40 +0530   \n",
       "..                         ...                        ...   \n",
       "445  2017-11-20 12:24:14 +0530  2017-11-20 11:28:48 +0530   \n",
       "446  2017-11-20 12:24:14 +0530  2017-11-20 11:29:03 +0530   \n",
       "447  2017-11-20 12:24:14 +0530  2017-11-20 11:30:28 +0530   \n",
       "448  2017-11-20 12:24:14 +0530  2017-11-20 12:12:22 +0530   \n",
       "449  2017-11-20 12:24:14 +0530  2017-11-20 12:12:45 +0530   \n",
       "450  2017-11-20 16:10:55 +0530  2017-11-20 15:19:13 +0530   \n",
       "451  2017-11-20 17:08:59 +0530  2017-11-20 16:44:56 +0530   \n",
       "452  2017-11-20 18:10:49 +0530  2017-11-20 17:12:11 +0530   \n",
       "453  2017-11-20 18:10:49 +0530  2017-11-20 17:16:18 +0530   \n",
       "454  2017-11-20 18:10:49 +0530  2017-11-20 17:16:31 +0530   \n",
       "455  2017-11-20 18:10:49 +0530  2017-11-20 18:09:19 +0530   \n",
       "456  2017-11-24 08:38:00 +0530  2017-11-24 08:21:07 +0530   \n",
       "457  2017-12-09 15:55:39 +0530  2017-12-09 15:40:45 +0530   \n",
       "458  2018-01-10 19:12:17 +0530  2018-01-10 18:12:40 +0530   \n",
       "459  2018-01-10 20:44:12 +0530  2018-01-10 19:20:09 +0530   \n",
       "460  2018-01-10 20:44:12 +0530  2018-01-10 19:25:33 +0530   \n",
       "461  2018-01-10 20:44:12 +0530  2018-01-10 19:38:53 +0530   \n",
       "462  2018-01-11 13:43:47 +0530  2018-01-11 12:20:14 +0530   \n",
       "463  2018-01-11 13:43:47 +0530  2018-01-11 12:41:26 +0530   \n",
       "464  2018-01-11 15:09:08 +0530  2018-01-11 14:07:25 +0530   \n",
       "465  2018-01-11 16:06:01 +0530  2018-01-11 15:57:14 +0530   \n",
       "466  2018-01-11 17:11:07 +0530  2018-01-11 16:07:22 +0530   \n",
       "467  2018-01-11 18:12:37 +0530  2018-01-11 17:36:06 +0530   \n",
       "468  2018-01-12 15:08:15 +0530  2018-01-12 14:37:57 +0530   \n",
       "469  2018-01-12 16:11:20 +0530  2018-01-12 16:00:29 +0530   \n",
       "470  2018-01-12 20:18:15 +0530  2018-01-12 20:04:25 +0530   \n",
       "471  2018-01-13 11:06:24 +0530  2018-01-13 10:14:11 +0530   \n",
       "472  2018-01-13 12:07:00 +0530  2018-01-13 11:29:47 +0530   \n",
       "473  2018-01-13 15:06:57 +0530  2018-01-13 14:23:27 +0530   \n",
       "474  2018-01-13 18:08:18 +0530  2018-01-13 17:48:17 +0530   \n",
       "\n",
       "                       endDate  value  \n",
       "0    2017-09-27 08:34:07 +0530      1  \n",
       "1    2017-09-27 09:42:09 +0530      1  \n",
       "2    2017-09-27 09:42:29 +0530      1  \n",
       "3    2017-09-27 14:18:33 +0530      1  \n",
       "4    2017-09-27 14:18:43 +0530      1  \n",
       "5    2017-09-27 14:18:58 +0530      1  \n",
       "6    2017-09-27 19:23:13 +0530      1  \n",
       "7    2017-09-27 19:23:20 +0530      1  \n",
       "8    2017-09-27 19:23:59 +0530      1  \n",
       "9    2017-09-27 20:11:18 +0530      1  \n",
       "10   2017-09-27 20:11:30 +0530      1  \n",
       "11   2017-09-27 20:13:18 +0530      1  \n",
       "12   2017-09-28 08:34:07 +0530      1  \n",
       "13   2017-09-28 09:36:10 +0530      1  \n",
       "14   2017-09-28 09:36:44 +0530      1  \n",
       "15   2017-09-28 11:11:34 +0530      1  \n",
       "16   2017-09-28 11:12:00 +0530      1  \n",
       "17   2017-09-28 11:59:52 +0530      1  \n",
       "18   2017-09-28 12:00:05 +0530      1  \n",
       "19   2017-09-28 12:00:18 +0530      1  \n",
       "20   2017-09-28 13:58:37 +0530      1  \n",
       "21   2017-09-28 13:58:55 +0530      1  \n",
       "22   2017-09-28 15:18:05 +0530      1  \n",
       "23   2017-09-28 15:18:26 +0530      1  \n",
       "24   2017-09-28 17:28:38 +0530      1  \n",
       "25   2017-09-28 17:28:53 +0530      1  \n",
       "26   2017-09-28 22:16:44 +0530      1  \n",
       "27   2017-09-28 22:18:01 +0530      1  \n",
       "28   2017-09-29 13:38:33 +0530      1  \n",
       "29   2017-09-30 11:55:40 +0530      1  \n",
       "..                         ...    ...  \n",
       "445  2017-11-20 11:28:48 +0530      1  \n",
       "446  2017-11-20 11:29:03 +0530      1  \n",
       "447  2017-11-20 11:30:28 +0530      1  \n",
       "448  2017-11-20 12:12:22 +0530      1  \n",
       "449  2017-11-20 12:12:45 +0530      1  \n",
       "450  2017-11-20 15:19:13 +0530      1  \n",
       "451  2017-11-20 16:44:56 +0530      1  \n",
       "452  2017-11-20 17:12:11 +0530      1  \n",
       "453  2017-11-20 17:16:18 +0530      1  \n",
       "454  2017-11-20 17:16:31 +0530      1  \n",
       "455  2017-11-20 18:09:19 +0530      1  \n",
       "456  2017-11-24 08:21:07 +0530      1  \n",
       "457  2017-12-09 15:40:45 +0530      3  \n",
       "458  2018-01-10 18:12:40 +0530      1  \n",
       "459  2018-01-10 19:20:09 +0530      1  \n",
       "460  2018-01-10 19:25:33 +0530      1  \n",
       "461  2018-01-10 19:38:53 +0530      1  \n",
       "462  2018-01-11 12:20:14 +0530      1  \n",
       "463  2018-01-11 12:41:26 +0530      1  \n",
       "464  2018-01-11 14:07:25 +0530      1  \n",
       "465  2018-01-11 15:57:14 +0530      1  \n",
       "466  2018-01-11 16:07:22 +0530      1  \n",
       "467  2018-01-11 17:36:06 +0530      1  \n",
       "468  2018-01-12 14:37:57 +0530      1  \n",
       "469  2018-01-12 16:00:29 +0530      1  \n",
       "470  2018-01-12 20:04:25 +0530      1  \n",
       "471  2018-01-13 10:14:11 +0530      1  \n",
       "472  2018-01-13 11:29:47 +0530      1  \n",
       "473  2018-01-13 14:23:27 +0530      1  \n",
       "474  2018-01-13 17:48:17 +0530      1  \n",
       "\n",
       "[475 rows x 9 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FlightsClimbed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sourceName</th>\n",
       "      <th>sourceVersion</th>\n",
       "      <th>device</th>\n",
       "      <th>type</th>\n",
       "      <th>unit</th>\n",
       "      <th>creationDate</th>\n",
       "      <th>startDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049fa40&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:04:02 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>0.05479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f8b0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>0.01064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f810&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>0.13241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f770&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>2017-09-27 08:37:41 +0530</td>\n",
       "      <td>0.25867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sivabalan’s iPhone</td>\n",
       "      <td>10.3.3</td>\n",
       "      <td>&lt;&lt;HKDevice: 0x17049f6d0&gt;, name:iPhone, manufac...</td>\n",
       "      <td>DistanceWalkingRunning</td>\n",
       "      <td>km</td>\n",
       "      <td>2017-09-27 09:44:28 +0530</td>\n",
       "      <td>2017-09-27 09:09:32 +0530</td>\n",
       "      <td>2017-09-27 09:16:00 +0530</td>\n",
       "      <td>0.00690</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           sourceName sourceVersion  \\\n",
       "0  Sivabalan’s iPhone        10.3.3   \n",
       "1  Sivabalan’s iPhone        10.3.3   \n",
       "2  Sivabalan’s iPhone        10.3.3   \n",
       "3  Sivabalan’s iPhone        10.3.3   \n",
       "4  Sivabalan’s iPhone        10.3.3   \n",
       "\n",
       "                                              device                    type  \\\n",
       "0  <<HKDevice: 0x17049fa40>, name:iPhone, manufac...  DistanceWalkingRunning   \n",
       "1  <<HKDevice: 0x17049f8b0>, name:iPhone, manufac...  DistanceWalkingRunning   \n",
       "2  <<HKDevice: 0x17049f810>, name:iPhone, manufac...  DistanceWalkingRunning   \n",
       "3  <<HKDevice: 0x17049f770>, name:iPhone, manufac...  DistanceWalkingRunning   \n",
       "4  <<HKDevice: 0x17049f6d0>, name:iPhone, manufac...  DistanceWalkingRunning   \n",
       "\n",
       "  unit               creationDate                  startDate  \\\n",
       "0   km  2017-09-27 08:45:59 +0530  2017-09-27 08:04:02 +0530   \n",
       "1   km  2017-09-27 08:45:59 +0530  2017-09-27 08:13:53 +0530   \n",
       "2   km  2017-09-27 08:45:59 +0530  2017-09-27 08:23:09 +0530   \n",
       "3   km  2017-09-27 08:45:59 +0530  2017-09-27 08:33:08 +0530   \n",
       "4   km  2017-09-27 09:44:28 +0530  2017-09-27 09:09:32 +0530   \n",
       "\n",
       "                     endDate    value  \n",
       "0  2017-09-27 08:13:53 +0530  0.05479  \n",
       "1  2017-09-27 08:23:09 +0530  0.01064  \n",
       "2  2017-09-27 08:33:08 +0530  0.13241  \n",
       "3  2017-09-27 08:37:41 +0530  0.25867  \n",
       "4  2017-09-27 09:16:00 +0530  0.00690  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DistanceWalkingRunning.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creationDate</th>\n",
       "      <th>startDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:04:02 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>0.05479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>0.01064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>0.13241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>2017-09-27 08:37:41 +0530</td>\n",
       "      <td>0.25867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-09-27 09:44:28 +0530</td>\n",
       "      <td>2017-09-27 09:09:32 +0530</td>\n",
       "      <td>2017-09-27 09:16:00 +0530</td>\n",
       "      <td>0.00690</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                creationDate                  startDate  \\\n",
       "0  2017-09-27 08:45:59 +0530  2017-09-27 08:04:02 +0530   \n",
       "1  2017-09-27 08:45:59 +0530  2017-09-27 08:13:53 +0530   \n",
       "2  2017-09-27 08:45:59 +0530  2017-09-27 08:23:09 +0530   \n",
       "3  2017-09-27 08:45:59 +0530  2017-09-27 08:33:08 +0530   \n",
       "4  2017-09-27 09:44:28 +0530  2017-09-27 09:09:32 +0530   \n",
       "\n",
       "                     endDate    value  \n",
       "0  2017-09-27 08:13:53 +0530  0.05479  \n",
       "1  2017-09-27 08:23:09 +0530  0.01064  \n",
       "2  2017-09-27 08:33:08 +0530  0.13241  \n",
       "3  2017-09-27 08:37:41 +0530  0.25867  \n",
       "4  2017-09-27 09:16:00 +0530  0.00690  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "walking = DistanceWalkingRunning[[\"creationDate\",\"startDate\",\"endDate\",\"value\"]]\n",
    "\n",
    "walking.head()\n",
    "\n",
    "walking[\"creationDate\"]\n",
    "\n",
    "walking.head()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creationDate</th>\n",
       "      <th>startDate</th>\n",
       "      <th>endDate</th>\n",
       "      <th>value</th>\n",
       "      <th>date</th>\n",
       "      <th>Date</th>\n",
       "      <th>walkeddate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:04:02 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>0.05479</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:13:53 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>0.01064</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:23:09 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>0.13241</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-09-27 08:45:59 +0530</td>\n",
       "      <td>2017-09-27 08:33:08 +0530</td>\n",
       "      <td>2017-09-27 08:37:41 +0530</td>\n",
       "      <td>0.25867</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "      <td>2017-09-27 03:15:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-09-27 09:44:28 +0530</td>\n",
       "      <td>2017-09-27 09:09:32 +0530</td>\n",
       "      <td>2017-09-27 09:16:00 +0530</td>\n",
       "      <td>0.00690</td>\n",
       "      <td>2017-09-27 04:14:28</td>\n",
       "      <td>2017-09-27 04:14:28</td>\n",
       "      <td>2017-09-27 04:14:28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                creationDate                  startDate  \\\n",
       "0  2017-09-27 08:45:59 +0530  2017-09-27 08:04:02 +0530   \n",
       "1  2017-09-27 08:45:59 +0530  2017-09-27 08:13:53 +0530   \n",
       "2  2017-09-27 08:45:59 +0530  2017-09-27 08:23:09 +0530   \n",
       "3  2017-09-27 08:45:59 +0530  2017-09-27 08:33:08 +0530   \n",
       "4  2017-09-27 09:44:28 +0530  2017-09-27 09:09:32 +0530   \n",
       "\n",
       "                     endDate    value                date                Date  \\\n",
       "0  2017-09-27 08:13:53 +0530  0.05479 2017-09-27 03:15:59 2017-09-27 03:15:59   \n",
       "1  2017-09-27 08:23:09 +0530  0.01064 2017-09-27 03:15:59 2017-09-27 03:15:59   \n",
       "2  2017-09-27 08:33:08 +0530  0.13241 2017-09-27 03:15:59 2017-09-27 03:15:59   \n",
       "3  2017-09-27 08:37:41 +0530  0.25867 2017-09-27 03:15:59 2017-09-27 03:15:59   \n",
       "4  2017-09-27 09:16:00 +0530  0.00690 2017-09-27 04:14:28 2017-09-27 04:14:28   \n",
       "\n",
       "           walkeddate  \n",
       "0 2017-09-27 03:15:59  \n",
       "1 2017-09-27 03:15:59  \n",
       "2 2017-09-27 03:15:59  \n",
       "3 2017-09-27 03:15:59  \n",
       "4 2017-09-27 04:14:28  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "walking.head()\n",
    "\n",
    "pd.to_datetime(walking[\"creationDate\"])\n",
    "\n",
    "walking[\"date\"]\n",
    "\n",
    "walking.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'file:///Users/siva/Documents/Code/Pandas/temp-plot.html'"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import plotly\n",
    "from plotly.graph_objs import Scatter, Layout\n",
    "import plotly.graph_objs as go\n",
    "\n",
    "\n",
    "stepdata = [go.Bar(x=walking[\"date\"].dt.date, y=walking[\"metres\"])]\n",
    "\n",
    "\n",
    "plotly.offline.plot({ 'data': stepdata,\n",
    "            'layout': {\n",
    "               'title': 'Walking (metres)',\n",
    "               'xaxis': {\n",
    "                 'title': 'Creation Date'},\n",
    "               'yaxis': {\n",
    "                'title': 'Value '}\n",
    "        }})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def km_to_m(km):\n",
    "    return int(km*1000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/siva/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:\n",
      "\n",
      "\n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "\n"
     ]
    }
   ],
   "source": [
    "walking[\"metres\"] = walking[\"value\"].apply(km_to_m)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "97.93811881188118"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "walking[\"metres\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}