Posterior Arm, Calf - Extraction and Merge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "import time\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for other subjects, change the 'S6' in the file path to appropriate subject folder and run the same script\n",
    "\n",
    "# for merging hand sensors, change the 'Gastrocnemius - leg' in the file path to 'Extensor Digitorum - hand' and run the same script"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.961746</td>\n",
       "      <td>0.127749</td>\n",
       "      <td>0.235538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.962356</td>\n",
       "      <td>0.118837</td>\n",
       "      <td>0.253605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.952590</td>\n",
       "      <td>0.099062</td>\n",
       "      <td>0.264591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.947341</td>\n",
       "      <td>0.095399</td>\n",
       "      <td>0.255314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.939651</td>\n",
       "      <td>0.121279</td>\n",
       "      <td>0.273259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17459</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948440</td>\n",
       "      <td>0.125673</td>\n",
       "      <td>0.273503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17460</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948806</td>\n",
       "      <td>0.099428</td>\n",
       "      <td>0.299748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17461</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.942458</td>\n",
       "      <td>0.112123</td>\n",
       "      <td>0.352605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17462</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.938674</td>\n",
       "      <td>0.118715</td>\n",
       "      <td>0.385199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17463</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.922683</td>\n",
       "      <td>0.105653</td>\n",
       "      <td>0.415961</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17464 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)\n",
       "0                  1.604169e+15     0.961746     0.127749     0.235538\n",
       "1                  1.604169e+15     0.962356     0.118837     0.253605\n",
       "2                  1.604169e+15     0.952590     0.099062     0.264591\n",
       "3                  1.604169e+15     0.947341     0.095399     0.255314\n",
       "4                  1.604169e+15     0.939651     0.121279     0.273259\n",
       "...                         ...          ...          ...          ...\n",
       "17459              1.604171e+15     0.948440     0.125673     0.273503\n",
       "17460              1.604171e+15     0.948806     0.099428     0.299748\n",
       "17461              1.604171e+15     0.942458     0.112123     0.352605\n",
       "17462              1.604171e+15     0.938674     0.118715     0.385199\n",
       "17463              1.604171e+15     0.922683     0.105653     0.415961\n",
       "\n",
       "[17464 rows x 4 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "accel = pd.read_csv('Data\\\\Raw Data\\\\S6\\\\Gastrocnemius - leg\\\\accel.csv')\n",
    "accel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>-2.227817</td>\n",
       "      <td>3.875792</td>\n",
       "      <td>-1.922637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>-4.180972</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>-1.800565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>-3.692683</td>\n",
       "      <td>3.265431</td>\n",
       "      <td>-1.617456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>1.007095</td>\n",
       "      <td>2.716106</td>\n",
       "      <td>-1.983673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>3.997864</td>\n",
       "      <td>2.349889</td>\n",
       "      <td>-1.922637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17461</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>-9.063859</td>\n",
       "      <td>15.106432</td>\n",
       "      <td>-8.575570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17462</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>-11.078050</td>\n",
       "      <td>14.923323</td>\n",
       "      <td>-9.308003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17463</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>-10.833906</td>\n",
       "      <td>14.801251</td>\n",
       "      <td>-10.101472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17464</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>-10.162509</td>\n",
       "      <td>13.824674</td>\n",
       "      <td>-11.322194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17465</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>-9.979400</td>\n",
       "      <td>12.603952</td>\n",
       "      <td>-12.176699</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17466 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s)\n",
       "0                  1.604169e+15     -2.227817      3.875792     -1.922637\n",
       "1                  1.604169e+15     -4.180972      3.814755     -1.800565\n",
       "2                  1.604169e+15     -3.692683      3.265431     -1.617456\n",
       "3                  1.604169e+15      1.007095      2.716106     -1.983673\n",
       "4                  1.604169e+15      3.997864      2.349889     -1.922637\n",
       "...                         ...           ...           ...           ...\n",
       "17461              1.604171e+15     -9.063859     15.106432     -8.575570\n",
       "17462              1.604171e+15    -11.078050     14.923323     -9.308003\n",
       "17463              1.604171e+15    -10.833906     14.801251    -10.101472\n",
       "17464              1.604171e+15    -10.162509     13.824674    -11.322194\n",
       "17465              1.604171e+15     -9.979400     12.603952    -12.176699\n",
       "\n",
       "[17466 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gyro = pd.read_csv('Data\\\\Raw Data\\\\S6\\\\Gastrocnemius - leg\\\\gyro.csv')\n",
    "gyro"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Merging data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = accel.join(gyro.set_index('Timestamp (microseconds)'), on='Timestamp (microseconds)', how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.961746</td>\n",
       "      <td>0.127749</td>\n",
       "      <td>0.235538</td>\n",
       "      <td>-2.227817</td>\n",
       "      <td>3.875792</td>\n",
       "      <td>-1.922637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.962356</td>\n",
       "      <td>0.118837</td>\n",
       "      <td>0.253605</td>\n",
       "      <td>-4.180972</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>-1.800565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.952590</td>\n",
       "      <td>0.099062</td>\n",
       "      <td>0.264591</td>\n",
       "      <td>-3.692683</td>\n",
       "      <td>3.265431</td>\n",
       "      <td>-1.617456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.947341</td>\n",
       "      <td>0.095399</td>\n",
       "      <td>0.255314</td>\n",
       "      <td>1.007095</td>\n",
       "      <td>2.716106</td>\n",
       "      <td>-1.983673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.939651</td>\n",
       "      <td>0.121279</td>\n",
       "      <td>0.273259</td>\n",
       "      <td>3.997864</td>\n",
       "      <td>2.349889</td>\n",
       "      <td>-1.922637</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17459</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948440</td>\n",
       "      <td>0.125673</td>\n",
       "      <td>0.273503</td>\n",
       "      <td>-9.063859</td>\n",
       "      <td>15.106432</td>\n",
       "      <td>-8.575570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17460</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948806</td>\n",
       "      <td>0.099428</td>\n",
       "      <td>0.299748</td>\n",
       "      <td>-11.078050</td>\n",
       "      <td>14.923323</td>\n",
       "      <td>-9.308003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17461</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.942458</td>\n",
       "      <td>0.112123</td>\n",
       "      <td>0.352605</td>\n",
       "      <td>-10.833906</td>\n",
       "      <td>14.801251</td>\n",
       "      <td>-10.101472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17462</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.938674</td>\n",
       "      <td>0.118715</td>\n",
       "      <td>0.385199</td>\n",
       "      <td>-10.162509</td>\n",
       "      <td>13.824674</td>\n",
       "      <td>-11.322194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17463</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.922683</td>\n",
       "      <td>0.105653</td>\n",
       "      <td>0.415961</td>\n",
       "      <td>-9.979400</td>\n",
       "      <td>12.603952</td>\n",
       "      <td>-12.176699</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17464 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "0                  1.604169e+15     0.961746     0.127749     0.235538   \n",
       "1                  1.604169e+15     0.962356     0.118837     0.253605   \n",
       "2                  1.604169e+15     0.952590     0.099062     0.264591   \n",
       "3                  1.604169e+15     0.947341     0.095399     0.255314   \n",
       "4                  1.604169e+15     0.939651     0.121279     0.273259   \n",
       "...                         ...          ...          ...          ...   \n",
       "17459              1.604171e+15     0.948440     0.125673     0.273503   \n",
       "17460              1.604171e+15     0.948806     0.099428     0.299748   \n",
       "17461              1.604171e+15     0.942458     0.112123     0.352605   \n",
       "17462              1.604171e+15     0.938674     0.118715     0.385199   \n",
       "17463              1.604171e+15     0.922683     0.105653     0.415961   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s)  \n",
       "0         -2.227817      3.875792     -1.922637  \n",
       "1         -4.180972      3.814755     -1.800565  \n",
       "2         -3.692683      3.265431     -1.617456  \n",
       "3          1.007095      2.716106     -1.983673  \n",
       "4          3.997864      2.349889     -1.922637  \n",
       "...             ...           ...           ...  \n",
       "17459     -9.063859     15.106432     -8.575570  \n",
       "17460    -11.078050     14.923323     -9.308003  \n",
       "17461    -10.833906     14.801251    -10.101472  \n",
       "17462    -10.162509     13.824674    -11.322194  \n",
       "17463     -9.979400     12.603952    -12.176699  \n",
       "\n",
       "[17464 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data filtering and adding labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1604169310006280.0\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Timestamp('2020-10-31 18:35:10.006280')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df['Timestamp (microseconds)'][0])\n",
    "pd.Timestamp(df['Timestamp (microseconds)'][0], unit='us')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\mahaj\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:11: SettingWithCopyWarning: \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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  # This is added back by InteractiveShellApp.init_path()\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.961746</td>\n",
       "      <td>0.127749</td>\n",
       "      <td>0.235538</td>\n",
       "      <td>-2.227817</td>\n",
       "      <td>3.875792</td>\n",
       "      <td>-1.922637</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.962356</td>\n",
       "      <td>0.118837</td>\n",
       "      <td>0.253605</td>\n",
       "      <td>-4.180972</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>-1.800565</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.952590</td>\n",
       "      <td>0.099062</td>\n",
       "      <td>0.264591</td>\n",
       "      <td>-3.692683</td>\n",
       "      <td>3.265431</td>\n",
       "      <td>-1.617456</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.947341</td>\n",
       "      <td>0.095399</td>\n",
       "      <td>0.255314</td>\n",
       "      <td>1.007095</td>\n",
       "      <td>2.716106</td>\n",
       "      <td>-1.983673</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.939651</td>\n",
       "      <td>0.121279</td>\n",
       "      <td>0.273259</td>\n",
       "      <td>3.997864</td>\n",
       "      <td>2.349889</td>\n",
       "      <td>-1.922637</td>\n",
       "      <td>stairs</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5560</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>1.114336</td>\n",
       "      <td>-0.373968</td>\n",
       "      <td>0.417670</td>\n",
       "      <td>78.828107</td>\n",
       "      <td>21.271077</td>\n",
       "      <td>35.309377</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5561</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>1.247761</td>\n",
       "      <td>-0.328435</td>\n",
       "      <td>0.215030</td>\n",
       "      <td>76.874952</td>\n",
       "      <td>11.078050</td>\n",
       "      <td>21.393149</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5562</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>1.276081</td>\n",
       "      <td>-0.137636</td>\n",
       "      <td>0.022400</td>\n",
       "      <td>60.456245</td>\n",
       "      <td>20.660716</td>\n",
       "      <td>6.988632</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5563</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>1.108232</td>\n",
       "      <td>0.022522</td>\n",
       "      <td>0.128237</td>\n",
       "      <td>32.684825</td>\n",
       "      <td>22.858015</td>\n",
       "      <td>2.105745</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5564</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.997635</td>\n",
       "      <td>0.004822</td>\n",
       "      <td>0.211368</td>\n",
       "      <td>6.805524</td>\n",
       "      <td>26.886397</td>\n",
       "      <td>0.396735</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5565 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "0                 1.604169e+15     0.961746     0.127749     0.235538   \n",
       "1                 1.604169e+15     0.962356     0.118837     0.253605   \n",
       "2                 1.604169e+15     0.952590     0.099062     0.264591   \n",
       "3                 1.604169e+15     0.947341     0.095399     0.255314   \n",
       "4                 1.604169e+15     0.939651     0.121279     0.273259   \n",
       "...                        ...          ...          ...          ...   \n",
       "5560              1.604169e+15     1.114336    -0.373968     0.417670   \n",
       "5561              1.604169e+15     1.247761    -0.328435     0.215030   \n",
       "5562              1.604169e+15     1.276081    -0.137636     0.022400   \n",
       "5563              1.604169e+15     1.108232     0.022522     0.128237   \n",
       "5564              1.604169e+15     0.997635     0.004822     0.211368   \n",
       "\n",
       "      Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "0        -2.227817      3.875792     -1.922637         stairs  \n",
       "1        -4.180972      3.814755     -1.800565         stairs  \n",
       "2        -3.692683      3.265431     -1.617456         stairs  \n",
       "3         1.007095      2.716106     -1.983673         stairs  \n",
       "4         3.997864      2.349889     -1.922637         stairs  \n",
       "...            ...           ...           ...            ...  \n",
       "5560     78.828107     21.271077     35.309377         stairs  \n",
       "5561     76.874952     11.078050     21.393149         stairs  \n",
       "5562     60.456245     20.660716      6.988632         stairs  \n",
       "5563     32.684825     22.858015      2.105745         stairs  \n",
       "5564      6.805524     26.886397      0.396735         stairs  \n",
       "\n",
       "[5565 rows x 8 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# These values are obtained from the Meta Data and converted to UTC from Est\n",
    "\n",
    "start = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 35, second = 10)\n",
    "start_ts = int(start.timestamp() * 1e6)\n",
    "\n",
    "end = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 36, second = 39)\n",
    "end_ts = int(end.timestamp() * 1e6)\n",
    "\n",
    "stairs = df.loc[(df['Timestamp (microseconds)'] >= start_ts) & (df['Timestamp (microseconds)'] <= end_ts)]\n",
    "\n",
    "stairs['Activity_Label'] = 'stairs'\n",
    "stairs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\mahaj\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:9: SettingWithCopyWarning: \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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5565</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.946975</td>\n",
       "      <td>0.176822</td>\n",
       "      <td>0.244694</td>\n",
       "      <td>2.227817</td>\n",
       "      <td>5.828946</td>\n",
       "      <td>-0.701915</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5566</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.942702</td>\n",
       "      <td>0.194400</td>\n",
       "      <td>0.260319</td>\n",
       "      <td>2.594034</td>\n",
       "      <td>5.706874</td>\n",
       "      <td>-0.701915</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5567</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.942702</td>\n",
       "      <td>0.196597</td>\n",
       "      <td>0.258854</td>\n",
       "      <td>2.410925</td>\n",
       "      <td>5.096513</td>\n",
       "      <td>-0.518807</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5568</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.950881</td>\n",
       "      <td>0.187564</td>\n",
       "      <td>0.264958</td>\n",
       "      <td>0.518807</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>-0.396735</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5569</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.944533</td>\n",
       "      <td>0.231022</td>\n",
       "      <td>0.251408</td>\n",
       "      <td>0.518807</td>\n",
       "      <td>2.166781</td>\n",
       "      <td>0.457771</td>\n",
       "      <td>jog</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10937</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>1.250202</td>\n",
       "      <td>0.623484</td>\n",
       "      <td>0.044373</td>\n",
       "      <td>-21.454185</td>\n",
       "      <td>-289.219501</td>\n",
       "      <td>-21.271077</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10938</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>1.629236</td>\n",
       "      <td>0.721386</td>\n",
       "      <td>0.266178</td>\n",
       "      <td>62.409400</td>\n",
       "      <td>-218.966964</td>\n",
       "      <td>11.932555</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10939</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>1.772671</td>\n",
       "      <td>-0.266300</td>\n",
       "      <td>0.410590</td>\n",
       "      <td>28.717479</td>\n",
       "      <td>-129.182879</td>\n",
       "      <td>46.234836</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10940</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>1.690272</td>\n",
       "      <td>-0.846754</td>\n",
       "      <td>0.388251</td>\n",
       "      <td>61.188678</td>\n",
       "      <td>-25.238422</td>\n",
       "      <td>50.568399</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10941</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>2.115572</td>\n",
       "      <td>0.120058</td>\n",
       "      <td>0.131899</td>\n",
       "      <td>115.754940</td>\n",
       "      <td>73.273823</td>\n",
       "      <td>-6.073091</td>\n",
       "      <td>jog</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5377 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "5565               1.604170e+15     0.946975     0.176822     0.244694   \n",
       "5566               1.604170e+15     0.942702     0.194400     0.260319   \n",
       "5567               1.604170e+15     0.942702     0.196597     0.258854   \n",
       "5568               1.604170e+15     0.950881     0.187564     0.264958   \n",
       "5569               1.604170e+15     0.944533     0.231022     0.251408   \n",
       "...                         ...          ...          ...          ...   \n",
       "10937              1.604170e+15     1.250202     0.623484     0.044373   \n",
       "10938              1.604170e+15     1.629236     0.721386     0.266178   \n",
       "10939              1.604170e+15     1.772671    -0.266300     0.410590   \n",
       "10940              1.604170e+15     1.690272    -0.846754     0.388251   \n",
       "10941              1.604170e+15     2.115572     0.120058     0.131899   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "5565       2.227817      5.828946     -0.701915            jog  \n",
       "5566       2.594034      5.706874     -0.701915            jog  \n",
       "5567       2.410925      5.096513     -0.518807            jog  \n",
       "5568       0.518807      3.814755     -0.396735            jog  \n",
       "5569       0.518807      2.166781      0.457771            jog  \n",
       "...             ...           ...           ...            ...  \n",
       "10937    -21.454185   -289.219501    -21.271077            jog  \n",
       "10938     62.409400   -218.966964     11.932555            jog  \n",
       "10939     28.717479   -129.182879     46.234836            jog  \n",
       "10940     61.188678    -25.238422     50.568399            jog  \n",
       "10941    115.754940     73.273823     -6.073091            jog  \n",
       "\n",
       "[5377 rows x 8 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 44, second = 30)\n",
    "start_ts = int(start.timestamp() * 1e6)\n",
    "\n",
    "end = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 45, second = 56)\n",
    "end_ts = int(end.timestamp() * 1e6)\n",
    "\n",
    "jog = df.loc[(df['Timestamp (microseconds)'] >= start_ts) & (df['Timestamp (microseconds)'] <= end_ts)]\n",
    "\n",
    "jog['Activity_Label'] = 'jog'\n",
    "jog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\mahaj\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:8: SettingWithCopyWarning: \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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10942</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.899245</td>\n",
       "      <td>0.269474</td>\n",
       "      <td>0.380926</td>\n",
       "      <td>15.167468</td>\n",
       "      <td>-17.486839</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10943</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.849683</td>\n",
       "      <td>0.193912</td>\n",
       "      <td>0.253849</td>\n",
       "      <td>8.514534</td>\n",
       "      <td>-17.730983</td>\n",
       "      <td>4.425116</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10944</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.913649</td>\n",
       "      <td>0.141665</td>\n",
       "      <td>0.211734</td>\n",
       "      <td>1.861601</td>\n",
       "      <td>-18.219272</td>\n",
       "      <td>5.951019</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10945</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>1.005692</td>\n",
       "      <td>0.211368</td>\n",
       "      <td>0.214908</td>\n",
       "      <td>2.655070</td>\n",
       "      <td>-17.364767</td>\n",
       "      <td>6.256199</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10946</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>0.997635</td>\n",
       "      <td>0.287785</td>\n",
       "      <td>0.218082</td>\n",
       "      <td>-1.434348</td>\n",
       "      <td>-14.679179</td>\n",
       "      <td>2.227817</td>\n",
       "      <td>skipping</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11561</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>-0.825879</td>\n",
       "      <td>2.300633</td>\n",
       "      <td>-1.420127</td>\n",
       "      <td>506.141756</td>\n",
       "      <td>645.731289</td>\n",
       "      <td>-209.506371</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11562</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>-3.365591</td>\n",
       "      <td>2.154391</td>\n",
       "      <td>-0.259464</td>\n",
       "      <td>230.991073</td>\n",
       "      <td>464.820325</td>\n",
       "      <td>-340.550851</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11563</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>-3.021958</td>\n",
       "      <td>-1.044144</td>\n",
       "      <td>-1.155718</td>\n",
       "      <td>-148.775464</td>\n",
       "      <td>283.115892</td>\n",
       "      <td>-241.550317</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11564</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>-2.224216</td>\n",
       "      <td>-2.301610</td>\n",
       "      <td>-1.824918</td>\n",
       "      <td>-365.758755</td>\n",
       "      <td>200.961318</td>\n",
       "      <td>-100.007630</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11565</th>\n",
       "      <td>1.604170e+15</td>\n",
       "      <td>-1.258869</td>\n",
       "      <td>-2.807599</td>\n",
       "      <td>-1.898528</td>\n",
       "      <td>-233.798733</td>\n",
       "      <td>-52.826734</td>\n",
       "      <td>95.490959</td>\n",
       "      <td>skipping</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>624 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "10942              1.604170e+15     0.899245     0.269474     0.380926   \n",
       "10943              1.604170e+15     0.849683     0.193912     0.253849   \n",
       "10944              1.604170e+15     0.913649     0.141665     0.211734   \n",
       "10945              1.604170e+15     1.005692     0.211368     0.214908   \n",
       "10946              1.604170e+15     0.997635     0.287785     0.218082   \n",
       "...                         ...          ...          ...          ...   \n",
       "11561              1.604170e+15    -0.825879     2.300633    -1.420127   \n",
       "11562              1.604170e+15    -3.365591     2.154391    -0.259464   \n",
       "11563              1.604170e+15    -3.021958    -1.044144    -1.155718   \n",
       "11564              1.604170e+15    -2.224216    -2.301610    -1.824918   \n",
       "11565              1.604170e+15    -1.258869    -2.807599    -1.898528   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "10942     15.167468    -17.486839      3.814755       skipping  \n",
       "10943      8.514534    -17.730983      4.425116       skipping  \n",
       "10944      1.861601    -18.219272      5.951019       skipping  \n",
       "10945      2.655070    -17.364767      6.256199       skipping  \n",
       "10946     -1.434348    -14.679179      2.227817       skipping  \n",
       "...             ...           ...           ...            ...  \n",
       "11561    506.141756    645.731289   -209.506371       skipping  \n",
       "11562    230.991073    464.820325   -340.550851       skipping  \n",
       "11563   -148.775464    283.115892   -241.550317       skipping  \n",
       "11564   -365.758755    200.961318   -100.007630       skipping  \n",
       "11565   -233.798733    -52.826734     95.490959       skipping  \n",
       "\n",
       "[624 rows x 8 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 50, second = 45)\n",
    "start_ts = int(start.timestamp() * 1e6)\n",
    "\n",
    "end = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 50, second = 55)\n",
    "end_ts = int(end.timestamp() * 1e6)\n",
    "\n",
    "skip = df.loc[(df['Timestamp (microseconds)'] >= start_ts) & (df['Timestamp (microseconds)'] <= end_ts)]\n",
    "skip['Activity_Label'] = 'skipping'\n",
    "skip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\mahaj\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:8: SettingWithCopyWarning: \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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11566</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>1.002152</td>\n",
       "      <td>0.060731</td>\n",
       "      <td>0.100038</td>\n",
       "      <td>1.861601</td>\n",
       "      <td>0.152590</td>\n",
       "      <td>1.434348</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11567</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.995926</td>\n",
       "      <td>0.073548</td>\n",
       "      <td>0.110414</td>\n",
       "      <td>0.640879</td>\n",
       "      <td>-0.518807</td>\n",
       "      <td>2.105745</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11568</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.995438</td>\n",
       "      <td>0.097719</td>\n",
       "      <td>0.117372</td>\n",
       "      <td>-1.434348</td>\n",
       "      <td>-1.251240</td>\n",
       "      <td>2.960250</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11569</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.993973</td>\n",
       "      <td>0.099550</td>\n",
       "      <td>0.119570</td>\n",
       "      <td>-1.007095</td>\n",
       "      <td>-1.007095</td>\n",
       "      <td>2.899214</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11570</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.993851</td>\n",
       "      <td>0.075257</td>\n",
       "      <td>0.098573</td>\n",
       "      <td>-0.640879</td>\n",
       "      <td>-0.152590</td>\n",
       "      <td>2.349889</td>\n",
       "      <td>kettlebell</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14125</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.954665</td>\n",
       "      <td>0.072572</td>\n",
       "      <td>0.196109</td>\n",
       "      <td>14.801251</td>\n",
       "      <td>-11.749447</td>\n",
       "      <td>-0.335698</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14126</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.936965</td>\n",
       "      <td>0.155215</td>\n",
       "      <td>0.215152</td>\n",
       "      <td>10.406653</td>\n",
       "      <td>-15.228504</td>\n",
       "      <td>0.091554</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14127</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.937697</td>\n",
       "      <td>0.157656</td>\n",
       "      <td>0.257267</td>\n",
       "      <td>11.688411</td>\n",
       "      <td>-19.989319</td>\n",
       "      <td>-1.312276</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14128</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.947951</td>\n",
       "      <td>0.080262</td>\n",
       "      <td>0.204776</td>\n",
       "      <td>4.425116</td>\n",
       "      <td>-23.651484</td>\n",
       "      <td>-3.265431</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14129</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948684</td>\n",
       "      <td>0.060365</td>\n",
       "      <td>0.241642</td>\n",
       "      <td>-6.195163</td>\n",
       "      <td>-25.543603</td>\n",
       "      <td>-1.434348</td>\n",
       "      <td>kettlebell</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2564 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "11566              1.604171e+15     1.002152     0.060731     0.100038   \n",
       "11567              1.604171e+15     0.995926     0.073548     0.110414   \n",
       "11568              1.604171e+15     0.995438     0.097719     0.117372   \n",
       "11569              1.604171e+15     0.993973     0.099550     0.119570   \n",
       "11570              1.604171e+15     0.993851     0.075257     0.098573   \n",
       "...                         ...          ...          ...          ...   \n",
       "14125              1.604171e+15     0.954665     0.072572     0.196109   \n",
       "14126              1.604171e+15     0.936965     0.155215     0.215152   \n",
       "14127              1.604171e+15     0.937697     0.157656     0.257267   \n",
       "14128              1.604171e+15     0.947951     0.080262     0.204776   \n",
       "14129              1.604171e+15     0.948684     0.060365     0.241642   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "11566      1.861601      0.152590      1.434348     kettlebell  \n",
       "11567      0.640879     -0.518807      2.105745     kettlebell  \n",
       "11568     -1.434348     -1.251240      2.960250     kettlebell  \n",
       "11569     -1.007095     -1.007095      2.899214     kettlebell  \n",
       "11570     -0.640879     -0.152590      2.349889     kettlebell  \n",
       "...             ...           ...           ...            ...  \n",
       "14125     14.801251    -11.749447     -0.335698     kettlebell  \n",
       "14126     10.406653    -15.228504      0.091554     kettlebell  \n",
       "14127     11.688411    -19.989319     -1.312276     kettlebell  \n",
       "14128      4.425116    -23.651484     -3.265431     kettlebell  \n",
       "14129     -6.195163    -25.543603     -1.434348     kettlebell  \n",
       "\n",
       "[2564 rows x 8 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 57, second = 30)\n",
    "start_ts = int(start.timestamp() * 1e6)\n",
    "\n",
    "end = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 18, minute = 58, second = 11)\n",
    "end_ts = int(end.timestamp() * 1e6)\n",
    "\n",
    "kb = df.loc[(df['Timestamp (microseconds)'] >= start_ts) & (df['Timestamp (microseconds)'] <= end_ts)]\n",
    "kb['Activity_Label'] = 'kettlebell'\n",
    "kb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\mahaj\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:8: SettingWithCopyWarning: \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: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14130</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.933913</td>\n",
       "      <td>0.085878</td>\n",
       "      <td>0.256535</td>\n",
       "      <td>-0.091554</td>\n",
       "      <td>1.251240</td>\n",
       "      <td>-1.068132</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14131</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.950393</td>\n",
       "      <td>0.066712</td>\n",
       "      <td>0.237980</td>\n",
       "      <td>1.556420</td>\n",
       "      <td>1.556420</td>\n",
       "      <td>-0.457771</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14132</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.962844</td>\n",
       "      <td>0.093080</td>\n",
       "      <td>0.277531</td>\n",
       "      <td>3.448539</td>\n",
       "      <td>1.556420</td>\n",
       "      <td>0.213626</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14133</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.962966</td>\n",
       "      <td>0.143374</td>\n",
       "      <td>0.300481</td>\n",
       "      <td>5.035477</td>\n",
       "      <td>1.190204</td>\n",
       "      <td>0.457771</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14134</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.949538</td>\n",
       "      <td>0.149844</td>\n",
       "      <td>0.308171</td>\n",
       "      <td>3.326467</td>\n",
       "      <td>0.885023</td>\n",
       "      <td>0.152590</td>\n",
       "      <td>basket ball</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17459</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948440</td>\n",
       "      <td>0.125673</td>\n",
       "      <td>0.273503</td>\n",
       "      <td>-9.063859</td>\n",
       "      <td>15.106432</td>\n",
       "      <td>-8.575570</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17460</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948806</td>\n",
       "      <td>0.099428</td>\n",
       "      <td>0.299748</td>\n",
       "      <td>-11.078050</td>\n",
       "      <td>14.923323</td>\n",
       "      <td>-9.308003</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17461</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.942458</td>\n",
       "      <td>0.112123</td>\n",
       "      <td>0.352605</td>\n",
       "      <td>-10.833906</td>\n",
       "      <td>14.801251</td>\n",
       "      <td>-10.101472</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17462</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.938674</td>\n",
       "      <td>0.118715</td>\n",
       "      <td>0.385199</td>\n",
       "      <td>-10.162509</td>\n",
       "      <td>13.824674</td>\n",
       "      <td>-11.322194</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17463</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.922683</td>\n",
       "      <td>0.105653</td>\n",
       "      <td>0.415961</td>\n",
       "      <td>-9.979400</td>\n",
       "      <td>12.603952</td>\n",
       "      <td>-12.176699</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3334 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "14130              1.604171e+15     0.933913     0.085878     0.256535   \n",
       "14131              1.604171e+15     0.950393     0.066712     0.237980   \n",
       "14132              1.604171e+15     0.962844     0.093080     0.277531   \n",
       "14133              1.604171e+15     0.962966     0.143374     0.300481   \n",
       "14134              1.604171e+15     0.949538     0.149844     0.308171   \n",
       "...                         ...          ...          ...          ...   \n",
       "17459              1.604171e+15     0.948440     0.125673     0.273503   \n",
       "17460              1.604171e+15     0.948806     0.099428     0.299748   \n",
       "17461              1.604171e+15     0.942458     0.112123     0.352605   \n",
       "17462              1.604171e+15     0.938674     0.118715     0.385199   \n",
       "17463              1.604171e+15     0.922683     0.105653     0.415961   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "14130     -0.091554      1.251240     -1.068132    basket ball  \n",
       "14131      1.556420      1.556420     -0.457771    basket ball  \n",
       "14132      3.448539      1.556420      0.213626    basket ball  \n",
       "14133      5.035477      1.190204      0.457771    basket ball  \n",
       "14134      3.326467      0.885023      0.152590    basket ball  \n",
       "...             ...           ...           ...            ...  \n",
       "17459     -9.063859     15.106432     -8.575570    basket ball  \n",
       "17460    -11.078050     14.923323     -9.308003    basket ball  \n",
       "17461    -10.833906     14.801251    -10.101472    basket ball  \n",
       "17462    -10.162509     13.824674    -11.322194    basket ball  \n",
       "17463     -9.979400     12.603952    -12.176699    basket ball  \n",
       "\n",
       "[3334 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 19, minute = 1, second = 0)\n",
    "start_ts = int(start.timestamp() * 1e6)\n",
    "\n",
    "end = pd.Timestamp(year = 2020, month = 10, day = 31, hour = 19, minute = 2, second = 11)\n",
    "end_ts = int(end.timestamp() * 1e6)\n",
    "\n",
    "bb = df.loc[(df['Timestamp (microseconds)'] >= start_ts) & (df['Timestamp (microseconds)'] <= end_ts)]\n",
    "bb['Activity_Label'] = 'basket ball'\n",
    "bb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df = pd.concat([stairs, jog, skip, kb, bb], ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp (microseconds)</th>\n",
       "      <th>Accel X (g)</th>\n",
       "      <th>Accel Y (g)</th>\n",
       "      <th>Accel Z (g)</th>\n",
       "      <th>Gyro X (°/s)</th>\n",
       "      <th>Gyro Y (°/s)</th>\n",
       "      <th>Gyro Z (°/s)</th>\n",
       "      <th>Activity_Label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.961746</td>\n",
       "      <td>0.127749</td>\n",
       "      <td>0.235538</td>\n",
       "      <td>-2.227817</td>\n",
       "      <td>3.875792</td>\n",
       "      <td>-1.922637</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.962356</td>\n",
       "      <td>0.118837</td>\n",
       "      <td>0.253605</td>\n",
       "      <td>-4.180972</td>\n",
       "      <td>3.814755</td>\n",
       "      <td>-1.800565</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.952590</td>\n",
       "      <td>0.099062</td>\n",
       "      <td>0.264591</td>\n",
       "      <td>-3.692683</td>\n",
       "      <td>3.265431</td>\n",
       "      <td>-1.617456</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.947341</td>\n",
       "      <td>0.095399</td>\n",
       "      <td>0.255314</td>\n",
       "      <td>1.007095</td>\n",
       "      <td>2.716106</td>\n",
       "      <td>-1.983673</td>\n",
       "      <td>stairs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.604169e+15</td>\n",
       "      <td>0.939651</td>\n",
       "      <td>0.121279</td>\n",
       "      <td>0.273259</td>\n",
       "      <td>3.997864</td>\n",
       "      <td>2.349889</td>\n",
       "      <td>-1.922637</td>\n",
       "      <td>stairs</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17459</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948440</td>\n",
       "      <td>0.125673</td>\n",
       "      <td>0.273503</td>\n",
       "      <td>-9.063859</td>\n",
       "      <td>15.106432</td>\n",
       "      <td>-8.575570</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17460</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.948806</td>\n",
       "      <td>0.099428</td>\n",
       "      <td>0.299748</td>\n",
       "      <td>-11.078050</td>\n",
       "      <td>14.923323</td>\n",
       "      <td>-9.308003</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17461</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.942458</td>\n",
       "      <td>0.112123</td>\n",
       "      <td>0.352605</td>\n",
       "      <td>-10.833906</td>\n",
       "      <td>14.801251</td>\n",
       "      <td>-10.101472</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17462</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.938674</td>\n",
       "      <td>0.118715</td>\n",
       "      <td>0.385199</td>\n",
       "      <td>-10.162509</td>\n",
       "      <td>13.824674</td>\n",
       "      <td>-11.322194</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17463</th>\n",
       "      <td>1.604171e+15</td>\n",
       "      <td>0.922683</td>\n",
       "      <td>0.105653</td>\n",
       "      <td>0.415961</td>\n",
       "      <td>-9.979400</td>\n",
       "      <td>12.603952</td>\n",
       "      <td>-12.176699</td>\n",
       "      <td>basket ball</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17464 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Timestamp (microseconds)  Accel X (g)  Accel Y (g)  Accel Z (g)  \\\n",
       "0                  1.604169e+15     0.961746     0.127749     0.235538   \n",
       "1                  1.604169e+15     0.962356     0.118837     0.253605   \n",
       "2                  1.604169e+15     0.952590     0.099062     0.264591   \n",
       "3                  1.604169e+15     0.947341     0.095399     0.255314   \n",
       "4                  1.604169e+15     0.939651     0.121279     0.273259   \n",
       "...                         ...          ...          ...          ...   \n",
       "17459              1.604171e+15     0.948440     0.125673     0.273503   \n",
       "17460              1.604171e+15     0.948806     0.099428     0.299748   \n",
       "17461              1.604171e+15     0.942458     0.112123     0.352605   \n",
       "17462              1.604171e+15     0.938674     0.118715     0.385199   \n",
       "17463              1.604171e+15     0.922683     0.105653     0.415961   \n",
       "\n",
       "       Gyro X (°/s)  Gyro Y (°/s)  Gyro Z (°/s) Activity_Label  \n",
       "0         -2.227817      3.875792     -1.922637         stairs  \n",
       "1         -4.180972      3.814755     -1.800565         stairs  \n",
       "2         -3.692683      3.265431     -1.617456         stairs  \n",
       "3          1.007095      2.716106     -1.983673         stairs  \n",
       "4          3.997864      2.349889     -1.922637         stairs  \n",
       "...             ...           ...           ...            ...  \n",
       "17459     -9.063859     15.106432     -8.575570    basket ball  \n",
       "17460    -11.078050     14.923323     -9.308003    basket ball  \n",
       "17461    -10.833906     14.801251    -10.101472    basket ball  \n",
       "17462    -10.162509     13.824674    -11.322194    basket ball  \n",
       "17463     -9.979400     12.603952    -12.176699    basket ball  \n",
       "\n",
       "[17464 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df.to_csv('Data\\\\Intermediate Data\\\\S6\\\\Gastrocnemius - leg\\\\accel+gyro.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}