examples/cobi_bike/processing_cobi_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "jsonfile=\"ebike-5min-ride.json\"\n",
    "#jsonfile=\"standard-5min-ride.json\"\n",
    "with open(jsonfile) as f:\n",
    "    dataraw=json.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "actions=[]\n",
    "timestamps=[]\n",
    "paths=[]\n",
    "payloads=[]\n",
    "for item in dataraw:\n",
    "    actions.append(item['action'])\n",
    "    timestamps.append(item['timestamp'])\n",
    "    paths.append(item['path'])\n",
    "    payloads.append(item['payload'])\n",
    "    \n",
    "df=pd.DataFrame(data={\"actions\":actions,\"timestamps\":timestamps,\"paths\":paths,\"payloads\":payloads})\n",
    "#df.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['rideService/heartRateAvailability',\n",
       "       'rideService/cadenceAvailability', 'mobile/locationAvailability',\n",
       "       'hub/motorInterfaceId', 'rideService/speed',\n",
       "       'rideService/userPower', 'tourService/ridingDuration',\n",
       "       'tourService/ridingDistance', 'tourService/ascent',\n",
       "       'tourService/calories', 'mobile/location', 'rideService/heartRate',\n",
       "       'tourService/averageSpeed'], dtype=object)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps=df.paths.unique()\n",
    "ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.loc[df['paths']=='rideService/speed',:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.loc[df[\"paths\"]==\"mobile/location\",'payloads']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "rsspeedi=[]\n",
    "userPoweri=[]\n",
    "ridingDurationi=[]\n",
    "ridingDistancei=[]\n",
    "ascenti=[]\n",
    "caloriesi=[]\n",
    "heartRatei=[]\n",
    "cadencei=[]\n",
    "distancei=[]\n",
    "averageSpeedi=[]\n",
    "rangei=[]\n",
    "tsi=[]\n",
    "\n",
    "def state2arrays(state):\n",
    "    rsspeedi.append(state['rideService/speed'])\n",
    "    userPoweri.append(state['rideService/userPower'])\n",
    "    ridingDurationi.append(state['tourService/ridingDuration'])\n",
    "    ridingDistancei.append(state['tourService/ridingDistance'])\n",
    "    ascenti.append(state['tourService/ascent'])\n",
    "    caloriesi.append(state['tourService/calories'])\n",
    "    heartRatei.append(state['rideService/heartRate'])\n",
    "    cadencei.append(state['rideService/cadence'])\n",
    "    distancei.append(state['motor/distance'])\n",
    "    averageSpeedi.append(state['tourService/averageSpeed'])\n",
    "    rangei.append(state['motor/range'])\n",
    "    tsi.append(state['ts'])\n",
    "\n",
    "state={}\n",
    "state['oldts']=0\n",
    "state['ts']=0\n",
    "state['rideService/speed']=0\n",
    "state['rideService/userPower']=0\n",
    "state['tourService/ridingDuration']=0\n",
    "state['tourService/ridingDistance']=0\n",
    "state['tourService/ascent']=0\n",
    "state['tourService/calories']=0\n",
    "state['rideService/heartRate']=0\n",
    "state['rideService/cadence']=0\n",
    "state['motor/distance']=0\n",
    "state['tourService/averageSpeed']=0\n",
    "state['motor/range']=0\n",
    "\n",
    "badpaths= ['rideService/heartRateAvailability',\n",
    "       'rideService/cadenceAvailability', 'mobile/locationAvailability',\n",
    "       'hub/motorInterfaceId', 'mobile/location']\n",
    "\n",
    "for i,row in df.iterrows():\n",
    "    if row['paths'] not in badpaths:\n",
    "        state['oldts']=state['ts']\n",
    "        state['ts']=row['timestamps']\n",
    "        state[row['paths']]=row['payloads']\n",
    "        if state['oldts']!=state['ts']:\n",
    "            state2arrays(state)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>rsspeed</th>\n",
       "      <th>userPower</th>\n",
       "      <th>ridingDuration</th>\n",
       "      <th>ridingDistance</th>\n",
       "      <th>ascent</th>\n",
       "      <th>calories</th>\n",
       "      <th>heartRate</th>\n",
       "      <th>cadence</th>\n",
       "      <th>distance</th>\n",
       "      <th>averageSpeed</th>\n",
       "      <th>range</th>\n",
       "      <th>ts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7818</th>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.933979</td>\n",
       "      <td>140.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7819</th>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.933979</td>\n",
       "      <td>140.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7820</th>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.948345</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7821</th>\n",
       "      <td>0.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.948345</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7822</th>\n",
       "      <td>0.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.948345</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7823</th>\n",
       "      <td>0.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.964031</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7824</th>\n",
       "      <td>0.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.964031</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7825</th>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.964031</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7826</th>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.964031</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7827</th>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.964031</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7828</th>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.977928</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7829</th>\n",
       "      <td>0.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.977928</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7830</th>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.977928</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7831</th>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.977928</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7832</th>\n",
       "      <td>0.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.993908</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7833</th>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.993908</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7834</th>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>41.993908</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7835</th>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.009247</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7836</th>\n",
       "      <td>0.0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.009247</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7837</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.009247</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7838</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.009247</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7839</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.009247</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7840</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.024666</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075444913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7841</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.024666</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7842</th>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.024666</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7843</th>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.024666</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7844</th>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.039261</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7845</th>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.039261</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7846</th>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.039261</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7847</th>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.039261</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7848</th>\n",
       "      <td>0.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.054501</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7849</th>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.054501</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7850</th>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.054501</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7851</th>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.054501</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7852</th>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.068558</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7853</th>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.068558</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7854</th>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.068558</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7855</th>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.068558</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7856</th>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.084591</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7857</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.084591</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7858</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.084591</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7859</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>139.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7861</th>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7862</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7863</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7864</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.100258</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7865</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.114296</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7866</th>\n",
       "      <td>0.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.114296</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7867</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.114296</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5.827182</td>\n",
       "      <td>0</td>\n",
       "      <td>1499075445607</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      rsspeed  userPower  ridingDuration  ridingDistance     ascent  \\\n",
       "7818      0.0       90.0      298.008338     1736.548966  12.678441   \n",
       "7819      0.0       90.0      298.008338     1736.548966  12.678441   \n",
       "7820      0.0       90.0      298.008338     1736.548966  12.678441   \n",
       "7821      0.0       90.0      298.008338     1736.548966  12.678441   \n",
       "7822      0.0       85.0      298.008338     1736.548966  12.678441   \n",
       "7823      0.0       85.0      298.008338     1736.548966  12.678441   \n",
       "7824      0.0       85.0      298.008338     1736.548966  12.678441   \n",
       "7825      0.0       80.0      298.008338     1736.548966  12.678441   \n",
       "7826      0.0       80.0      298.008338     1736.548966  12.678441   \n",
       "7827      0.0       80.0      298.008338     1736.548966  12.678441   \n",
       "7828      0.0       80.0      298.008338     1736.548966  12.678441   \n",
       "7829      0.0       80.0      298.008338     1736.548966  12.678441   \n",
       "7830      0.0       70.0      298.008338     1736.548966  12.678441   \n",
       "7831      0.0       70.0      298.008338     1736.548966  12.678441   \n",
       "7832      0.0       70.0      298.008338     1736.548966  12.678441   \n",
       "7833      0.0       65.0      298.008338     1736.548966  12.678441   \n",
       "7834      0.0       65.0      298.008338     1736.548966  12.678441   \n",
       "7835      0.0       65.0      298.008338     1736.548966  12.678441   \n",
       "7836      0.0       65.0      298.008338     1736.548966  12.678441   \n",
       "7837      0.0       60.0      298.008338     1736.548966  12.678441   \n",
       "7838      0.0       60.0      298.008338     1736.548966  12.678441   \n",
       "7839      0.0       60.0      298.008338     1736.548966  12.678441   \n",
       "7840      0.0       60.0      298.008338     1736.548966  12.678441   \n",
       "7841      0.0       60.0      298.008338     1736.548966  12.678441   \n",
       "7842      0.0       50.0      298.008338     1736.548966  12.678441   \n",
       "7843      0.0       50.0      298.008338     1736.548966  12.678441   \n",
       "7844      0.0       50.0      298.008338     1736.548966  12.678441   \n",
       "7845      0.0       50.0      298.008338     1736.548966  12.678441   \n",
       "7846      0.0       45.0      298.008338     1736.548966  12.678441   \n",
       "7847      0.0       45.0      298.008338     1736.548966  12.678441   \n",
       "7848      0.0       45.0      298.008338     1736.548966  12.678441   \n",
       "7849      0.0       40.0      298.008338     1736.548966  12.678441   \n",
       "7850      0.0       40.0      298.008338     1736.548966  12.678441   \n",
       "7851      0.0       40.0      298.008338     1736.548966  12.678441   \n",
       "7852      0.0       40.0      298.008338     1736.548966  12.678441   \n",
       "7853      0.0       40.0      298.008338     1736.548966  12.678441   \n",
       "7854      0.0       35.0      298.008338     1736.548966  12.678441   \n",
       "7855      0.0       35.0      298.008338     1736.548966  12.678441   \n",
       "7856      0.0       35.0      298.008338     1736.548966  12.678441   \n",
       "7857      0.0       25.0      298.008338     1736.548966  12.678441   \n",
       "7858      0.0       25.0      298.008338     1736.548966  12.678441   \n",
       "7859      0.0       25.0      298.008338     1736.548966  12.678441   \n",
       "7860      0.0       25.0      298.008338     1736.548966  12.678441   \n",
       "7861      0.0       25.0      298.008338     1736.548966  12.678441   \n",
       "7862      0.0       20.0      298.008338     1736.548966  12.678441   \n",
       "7863      0.0       20.0      298.008338     1736.548966  12.678441   \n",
       "7864      0.0       20.0      298.008338     1736.548966  12.678441   \n",
       "7865      0.0       20.0      298.008338     1736.548966  12.678441   \n",
       "7866      0.0       20.0      298.008338     1736.548966  12.678441   \n",
       "7867      0.0       15.0      298.008338     1736.548966  12.678441   \n",
       "\n",
       "       calories  heartRate  cadence  distance  averageSpeed  range  \\\n",
       "7818  41.933979      140.0        0         0      5.827182      0   \n",
       "7819  41.933979      140.0        0         0      5.827182      0   \n",
       "7820  41.948345      139.0        0         0      5.827182      0   \n",
       "7821  41.948345      139.0        0         0      5.827182      0   \n",
       "7822  41.948345      139.0        0         0      5.827182      0   \n",
       "7823  41.964031      139.0        0         0      5.827182      0   \n",
       "7824  41.964031      139.0        0         0      5.827182      0   \n",
       "7825  41.964031      139.0        0         0      5.827182      0   \n",
       "7826  41.964031      139.0        0         0      5.827182      0   \n",
       "7827  41.964031      139.0        0         0      5.827182      0   \n",
       "7828  41.977928      139.0        0         0      5.827182      0   \n",
       "7829  41.977928      139.0        0         0      5.827182      0   \n",
       "7830  41.977928      139.0        0         0      5.827182      0   \n",
       "7831  41.977928      139.0        0         0      5.827182      0   \n",
       "7832  41.993908      139.0        0         0      5.827182      0   \n",
       "7833  41.993908      139.0        0         0      5.827182      0   \n",
       "7834  41.993908      139.0        0         0      5.827182      0   \n",
       "7835  42.009247      139.0        0         0      5.827182      0   \n",
       "7836  42.009247      139.0        0         0      5.827182      0   \n",
       "7837  42.009247      139.0        0         0      5.827182      0   \n",
       "7838  42.009247      139.0        0         0      5.827182      0   \n",
       "7839  42.009247      139.0        0         0      5.827182      0   \n",
       "7840  42.024666      139.0        0         0      5.827182      0   \n",
       "7841  42.024666      139.0        0         0      5.827182      0   \n",
       "7842  42.024666      139.0        0         0      5.827182      0   \n",
       "7843  42.024666      139.0        0         0      5.827182      0   \n",
       "7844  42.039261      139.0        0         0      5.827182      0   \n",
       "7845  42.039261      139.0        0         0      5.827182      0   \n",
       "7846  42.039261      139.0        0         0      5.827182      0   \n",
       "7847  42.039261      139.0        0         0      5.827182      0   \n",
       "7848  42.054501      139.0        0         0      5.827182      0   \n",
       "7849  42.054501      139.0        0         0      5.827182      0   \n",
       "7850  42.054501      139.0        0         0      5.827182      0   \n",
       "7851  42.054501      139.0        0         0      5.827182      0   \n",
       "7852  42.068558      139.0        0         0      5.827182      0   \n",
       "7853  42.068558      139.0        0         0      5.827182      0   \n",
       "7854  42.068558      139.0        0         0      5.827182      0   \n",
       "7855  42.068558      139.0        0         0      5.827182      0   \n",
       "7856  42.084591      139.0        0         0      5.827182      0   \n",
       "7857  42.084591      139.0        0         0      5.827182      0   \n",
       "7858  42.084591      139.0        0         0      5.827182      0   \n",
       "7859  42.100258      139.0        0         0      5.827182      0   \n",
       "7860  42.100258      138.0        0         0      5.827182      0   \n",
       "7861  42.100258      138.0        0         0      5.827182      0   \n",
       "7862  42.100258      138.0        0         0      5.827182      0   \n",
       "7863  42.100258      138.0        0         0      5.827182      0   \n",
       "7864  42.100258      138.0        0         0      5.827182      0   \n",
       "7865  42.114296      138.0        0         0      5.827182      0   \n",
       "7866  42.114296      138.0        0         0      5.827182      0   \n",
       "7867  42.114296      138.0        0         0      5.827182      0   \n",
       "\n",
       "                 ts  \n",
       "7818  1499075444403  \n",
       "7819  1499075444404  \n",
       "7820  1499075444478  \n",
       "7821  1499075444505  \n",
       "7822  1499075444506  \n",
       "7823  1499075444507  \n",
       "7824  1499075444597  \n",
       "7825  1499075444598  \n",
       "7826  1499075444599  \n",
       "7827  1499075444600  \n",
       "7828  1499075444601  \n",
       "7829  1499075444703  \n",
       "7830  1499075444704  \n",
       "7831  1499075444705  \n",
       "7832  1499075444804  \n",
       "7833  1499075444805  \n",
       "7834  1499075444806  \n",
       "7835  1499075444807  \n",
       "7836  1499075444906  \n",
       "7837  1499075444907  \n",
       "7838  1499075444908  \n",
       "7839  1499075444910  \n",
       "7840  1499075444913  \n",
       "7841  1499075445003  \n",
       "7842  1499075445004  \n",
       "7843  1499075445005  \n",
       "7844  1499075445006  \n",
       "7845  1499075445104  \n",
       "7846  1499075445107  \n",
       "7847  1499075445108  \n",
       "7848  1499075445196  \n",
       "7849  1499075445197  \n",
       "7850  1499075445198  \n",
       "7851  1499075445199  \n",
       "7852  1499075445200  \n",
       "7853  1499075445304  \n",
       "7854  1499075445305  \n",
       "7855  1499075445306  \n",
       "7856  1499075445406  \n",
       "7857  1499075445407  \n",
       "7858  1499075445408  \n",
       "7859  1499075445409  \n",
       "7860  1499075445467  \n",
       "7861  1499075445499  \n",
       "7862  1499075445500  \n",
       "7863  1499075445501  \n",
       "7864  1499075445502  \n",
       "7865  1499075445503  \n",
       "7866  1499075445606  \n",
       "7867  1499075445607  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datastate={'rsspeed':rsspeedi,\n",
    "      'userPower':userPoweri,\n",
    "      'ridingDuration':ridingDurationi,\n",
    "      'ridingDistance':ridingDistancei,\n",
    "      'ascent':ascenti,\n",
    "      'calories':caloriesi,\n",
    "      'heartRate':heartRatei,\n",
    "      'cadence':cadencei,\n",
    "      'distance':distancei,\n",
    "      'averageSpeed':averageSpeedi,\n",
    "      'range':rangei,\n",
    "      'ts':tsi}\n",
    "dfstate=pd.DataFrame(data=datastate)\n",
    "dfstate.tail(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7868, 12)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfstate.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['rsspeed', 'userPower', 'ridingDuration', 'ridingDistance', 'ascent',\n",
      "       'calories', 'heartRate', 'cadence', 'distance', 'averageSpeed', 'range',\n",
      "       'ts'],\n",
      "      dtype='object')\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "array([0])"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(dfstate.columns)\n",
    "dfstate.cadence.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "keepcols=['rsspeed', 'userPower', 'ridingDuration', 'ridingDistance', 'ascent',\n",
    "       'calories', 'heartRate', 'cadence', 'averageSpeed']\n",
    "outdf=dfstate.loc[500:,keepcols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "outdf.to_csv(\"cobi_state_data2.csv\",index=False, header=False)"
   ]
  },
  {
   "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>rsspeed</th>\n",
       "      <th>userPower</th>\n",
       "      <th>ridingDuration</th>\n",
       "      <th>ridingDistance</th>\n",
       "      <th>ascent</th>\n",
       "      <th>calories</th>\n",
       "      <th>heartRate</th>\n",
       "      <th>cadence</th>\n",
       "      <th>averageSpeed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.000000</td>\n",
       "      <td>7368.0</td>\n",
       "      <td>7368.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>5.048815</td>\n",
       "      <td>85.325733</td>\n",
       "      <td>149.719310</td>\n",
       "      <td>881.590400</td>\n",
       "      <td>5.214163</td>\n",
       "      <td>21.322461</td>\n",
       "      <td>132.520223</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.400841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.608876</td>\n",
       "      <td>9.895739</td>\n",
       "      <td>85.476509</td>\n",
       "      <td>501.596117</td>\n",
       "      <td>3.645467</td>\n",
       "      <td>11.951526</td>\n",
       "      <td>6.525503</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.667473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.432435</td>\n",
       "      <td>1.331206</td>\n",
       "      <td>113.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>4.186410</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>77.694944</td>\n",
       "      <td>460.113483</td>\n",
       "      <td>1.880545</td>\n",
       "      <td>10.795568</td>\n",
       "      <td>130.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.810427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>5.370290</td>\n",
       "      <td>85.000000</td>\n",
       "      <td>147.003192</td>\n",
       "      <td>892.611721</td>\n",
       "      <td>4.603966</td>\n",
       "      <td>21.098654</td>\n",
       "      <td>133.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.884984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>6.205056</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>224.132252</td>\n",
       "      <td>1304.516883</td>\n",
       "      <td>7.077678</td>\n",
       "      <td>31.835942</td>\n",
       "      <td>138.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.000211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.795568</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>298.008338</td>\n",
       "      <td>1736.548966</td>\n",
       "      <td>12.678441</td>\n",
       "      <td>42.114296</td>\n",
       "      <td>142.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.151452</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           rsspeed    userPower  ridingDuration  ridingDistance       ascent  \\\n",
       "count  7368.000000  7368.000000     7368.000000     7368.000000  7368.000000   \n",
       "mean      5.048815    85.325733      149.719310      881.590400     5.214163   \n",
       "std       1.608876     9.895739       85.476509      501.596117     3.645467   \n",
       "min       0.000000    15.000000        0.000000        0.000000     0.432435   \n",
       "25%       4.186410    85.000000       77.694944      460.113483     1.880545   \n",
       "50%       5.370290    85.000000      147.003192      892.611721     4.603966   \n",
       "75%       6.205056    90.000000      224.132252     1304.516883     7.077678   \n",
       "max       7.795568   100.000000      298.008338     1736.548966    12.678441   \n",
       "\n",
       "          calories    heartRate  cadence  averageSpeed  \n",
       "count  7368.000000  7368.000000   7368.0   7368.000000  \n",
       "mean     21.322461   132.520223      0.0      5.400841  \n",
       "std      11.951526     6.525503      0.0      1.667473  \n",
       "min       1.331206   113.000000      0.0      0.000000  \n",
       "25%      10.795568   130.000000      0.0      5.810427  \n",
       "50%      21.098654   133.000000      0.0      5.884984  \n",
       "75%      31.835942   138.000000      0.0      6.000211  \n",
       "max      42.114296   142.000000      0.0      6.151452  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "outdf.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "rsspeedmax=10.\n",
    "userPowermax=100.\n",
    "ridingDurationmax=500.\n",
    "ridingDistancemax=2000.\n",
    "ascentmax=15.\n",
    "caloriesmax=50.\n",
    "heartratemax=150.\n",
    "cadencemax=90.\n",
    "averageSpeedmax=8."
   ]
  }
 ],
 "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}