compute_saves.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime\n",
    "from os import walk\n",
    "\n",
    "for (dirpath, dirnames, filenames) in walk('data'):\n",
    "    break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(6365919, 8)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sensores = pd.DataFrame(columns=['temp','pres','veloc','kilom','date'])\n",
    "for file in filenames:\n",
    "    if file.find('oda') > 0:\n",
    "        sensor = pd.read_csv('data/'+file, names=['temp','pres','veloc','kilom','date'])\n",
    "        if len(sensor) > 0:\n",
    "            # adiciona próxima leitura de pressão\n",
    "            next_pres = sensor['pres'][1:].values\n",
    "            next_pres = np.append(next_pres, sensor['pres'][0])\n",
    "            sensor['next_pres'] = next_pres\n",
    "\n",
    "            # adiciona próxima data\n",
    "            next_date = sensor['date'][1:].values\n",
    "            next_date = np.append(next_date, sensor['date'][0])\n",
    "            sensor['next_date'] = next_date\n",
    "\n",
    "            #remove último registro sem próximo\n",
    "            sensor = sensor[:-1]\n",
    "\n",
    "            sensor['tires'] = file\n",
    "            sensores = sensores.append(sensor)\n",
    "            \n",
    "sensores.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(6365919, 9)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def press_diff(x): \n",
    "    try:\n",
    "        return abs(x['pres'] - x['next_pres'])\n",
    "    except:\n",
    "        return 0\n",
    "    \n",
    "sensores['press_diff'] = sensores.apply(press_diff,axis=1)\n",
    "sensores.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3095, 9)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sensor_filter = sensores[(sensores['press_diff'] > 0) & (sensores['pres'] < 100)]\n",
    "sensor_filter.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>kilom</th>\n",
       "      <th>next_date</th>\n",
       "      <th>next_pres</th>\n",
       "      <th>pres</th>\n",
       "      <th>temp</th>\n",
       "      <th>tires</th>\n",
       "      <th>veloc</th>\n",
       "      <th>press_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>2016-12-21 09:11:43</td>\n",
       "      <td>89.927486</td>\n",
       "      <td>2016-12-21 09:11:58</td>\n",
       "      <td>114.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_1.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18346</th>\n",
       "      <td>2017-01-18 10:00:41</td>\n",
       "      <td>1503.387481</td>\n",
       "      <td>2017-01-18 10:01:52</td>\n",
       "      <td>109.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2559-roda_1.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18368</th>\n",
       "      <td>2017-01-18 10:36:23</td>\n",
       "      <td>1503.543049</td>\n",
       "      <td>2017-01-18 10:36:30</td>\n",
       "      <td>113.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2559-roda_1.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18370</th>\n",
       "      <td>2017-01-18 10:36:53</td>\n",
       "      <td>1503.543049</td>\n",
       "      <td>2017-01-18 10:37:09</td>\n",
       "      <td>119.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2559-roda_1.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101874</th>\n",
       "      <td>2017-05-15 10:54:47</td>\n",
       "      <td>3300.976020</td>\n",
       "      <td>2017-05-15 10:55:00</td>\n",
       "      <td>123.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2559-roda_1.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>607</th>\n",
       "      <td>2016-12-21 09:10:16</td>\n",
       "      <td>89.884890</td>\n",
       "      <td>2016-12-21 09:10:28</td>\n",
       "      <td>115.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_4.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86718</th>\n",
       "      <td>2017-05-15 10:58:51</td>\n",
       "      <td>3300.976020</td>\n",
       "      <td>2017-05-15 10:59:05</td>\n",
       "      <td>127.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2559-roda_4.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-12-20 11:29:04</td>\n",
       "      <td>14.369656</td>\n",
       "      <td>2016-12-20 11:31:07</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>1.844</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2016-12-20 11:39:13</td>\n",
       "      <td>14.449292</td>\n",
       "      <td>2016-12-20 11:41:15</td>\n",
       "      <td>95.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2016-12-20 12:13:43</td>\n",
       "      <td>26.398385</td>\n",
       "      <td>2016-12-20 12:15:43</td>\n",
       "      <td>96.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>55.974</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2016-12-20 12:58:20</td>\n",
       "      <td>45.722136</td>\n",
       "      <td>2016-12-20 13:00:21</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>31.310</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2016-12-20 13:08:29</td>\n",
       "      <td>47.253739</td>\n",
       "      <td>2016-12-20 13:10:30</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2016-12-20 13:12:34</td>\n",
       "      <td>47.279667</td>\n",
       "      <td>2016-12-20 13:14:33</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2016-12-20 13:22:42</td>\n",
       "      <td>47.366711</td>\n",
       "      <td>2016-12-20 13:24:42</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2016-12-20 14:52:01</td>\n",
       "      <td>54.926569</td>\n",
       "      <td>2016-12-20 14:54:03</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>64.143</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2016-12-20 14:58:08</td>\n",
       "      <td>61.543759</td>\n",
       "      <td>2016-12-20 15:00:08</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>61.959</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2016-12-20 15:02:10</td>\n",
       "      <td>65.586671</td>\n",
       "      <td>2016-12-20 15:04:12</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>59.653</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2016-12-20 15:50:53</td>\n",
       "      <td>79.272940</td>\n",
       "      <td>2016-12-20 15:52:55</td>\n",
       "      <td>96.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>2016-12-20 21:31:54</td>\n",
       "      <td>82.373185</td>\n",
       "      <td>2016-12-20 21:33:55</td>\n",
       "      <td>95.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>2016-12-20 21:37:58</td>\n",
       "      <td>82.400965</td>\n",
       "      <td>2016-12-20 21:40:02</td>\n",
       "      <td>96.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>2016-12-20 21:42:03</td>\n",
       "      <td>82.441709</td>\n",
       "      <td>2016-12-20 21:44:03</td>\n",
       "      <td>95.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>2016-12-21 00:30:25</td>\n",
       "      <td>84.195551</td>\n",
       "      <td>2016-12-21 00:32:28</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>2016-12-21 00:36:30</td>\n",
       "      <td>84.212219</td>\n",
       "      <td>2016-12-21 00:38:33</td>\n",
       "      <td>95.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>2016-12-21 00:40:33</td>\n",
       "      <td>84.241851</td>\n",
       "      <td>2016-12-21 00:42:35</td>\n",
       "      <td>94.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td>2016-12-21 07:30:08</td>\n",
       "      <td>88.288468</td>\n",
       "      <td>2016-12-21 07:32:08</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>2016-12-21 07:36:12</td>\n",
       "      <td>88.368104</td>\n",
       "      <td>2016-12-21 07:38:12</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>2016-12-21 07:50:25</td>\n",
       "      <td>88.557007</td>\n",
       "      <td>2016-12-21 07:52:25</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>589</th>\n",
       "      <td>2016-12-21 07:54:25</td>\n",
       "      <td>88.610715</td>\n",
       "      <td>2016-12-21 07:56:28</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>2016-12-21 08:04:35</td>\n",
       "      <td>88.781099</td>\n",
       "      <td>2016-12-21 08:06:35</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>2016-12-21 08:10:39</td>\n",
       "      <td>88.964447</td>\n",
       "      <td>2016-12-21 08:12:39</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>2559-roda_7.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7827</th>\n",
       "      <td>2017-02-11 08:02:19</td>\n",
       "      <td>7536.166705</td>\n",
       "      <td>2017-02-11 08:17:04</td>\n",
       "      <td>86.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>6290-roda_5.txt</td>\n",
       "      <td>23.409</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7828</th>\n",
       "      <td>2017-02-11 08:17:04</td>\n",
       "      <td>7551.408652</td>\n",
       "      <td>2017-02-11 08:22:00</td>\n",
       "      <td>87.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>6290-roda_5.txt</td>\n",
       "      <td>73.625</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7830</th>\n",
       "      <td>2017-02-11 08:27:05</td>\n",
       "      <td>7562.607686</td>\n",
       "      <td>2017-02-11 08:54:37</td>\n",
       "      <td>88.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>6290-roda_5.txt</td>\n",
       "      <td>84.188</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7833</th>\n",
       "      <td>2017-02-11 09:12:28</td>\n",
       "      <td>7607.500128</td>\n",
       "      <td>2017-02-11 10:25:41</td>\n",
       "      <td>123.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>6290-roda_5.txt</td>\n",
       "      <td>40.874</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1252</th>\n",
       "      <td>2017-01-23 05:59:02</td>\n",
       "      <td>400.453910</td>\n",
       "      <td>2017-01-23 06:23:29</td>\n",
       "      <td>103.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>0.000</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716</th>\n",
       "      <td>2017-01-23 13:32:39</td>\n",
       "      <td>675.983120</td>\n",
       "      <td>2017-01-23 13:37:20</td>\n",
       "      <td>93.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>82.874</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1749</th>\n",
       "      <td>2017-01-23 13:38:06</td>\n",
       "      <td>680.850172</td>\n",
       "      <td>2017-01-23 13:47:40</td>\n",
       "      <td>94.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>24.503</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2171</th>\n",
       "      <td>2017-01-23 14:37:36</td>\n",
       "      <td>731.739384</td>\n",
       "      <td>2017-01-23 14:47:52</td>\n",
       "      <td>93.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>45.135</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2174</th>\n",
       "      <td>2017-01-23 14:48:04</td>\n",
       "      <td>739.491849</td>\n",
       "      <td>2017-01-23 14:53:03</td>\n",
       "      <td>92.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>27.021</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2179</th>\n",
       "      <td>2017-01-23 14:53:24</td>\n",
       "      <td>742.592094</td>\n",
       "      <td>2017-01-23 14:58:02</td>\n",
       "      <td>91.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>34.703</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2243</th>\n",
       "      <td>2017-01-23 15:04:42</td>\n",
       "      <td>748.694429</td>\n",
       "      <td>2017-01-23 15:07:52</td>\n",
       "      <td>89.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>24.345</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2265</th>\n",
       "      <td>2017-01-23 15:14:47</td>\n",
       "      <td>757.634025</td>\n",
       "      <td>2017-01-23 15:33:03</td>\n",
       "      <td>86.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>36.174</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2427</th>\n",
       "      <td>2017-01-23 15:41:32</td>\n",
       "      <td>780.885865</td>\n",
       "      <td>2017-01-23 15:48:10</td>\n",
       "      <td>85.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>79.266</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2531</th>\n",
       "      <td>2017-01-23 16:04:39</td>\n",
       "      <td>804.402541</td>\n",
       "      <td>2017-01-23 16:13:26</td>\n",
       "      <td>84.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>42.822</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2626</th>\n",
       "      <td>2017-01-23 16:21:11</td>\n",
       "      <td>818.381425</td>\n",
       "      <td>2017-01-23 17:19:38</td>\n",
       "      <td>109.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>84.429</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2678</th>\n",
       "      <td>2017-01-24 07:57:16</td>\n",
       "      <td>939.372480</td>\n",
       "      <td>2017-01-24 08:03:23</td>\n",
       "      <td>96.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>51.103</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2680</th>\n",
       "      <td>2017-01-24 08:03:39</td>\n",
       "      <td>945.556303</td>\n",
       "      <td>2017-01-24 08:07:06</td>\n",
       "      <td>97.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>37.578</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2681</th>\n",
       "      <td>2017-01-24 08:07:06</td>\n",
       "      <td>948.743592</td>\n",
       "      <td>2017-01-24 08:22:03</td>\n",
       "      <td>98.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>42.238</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2682</th>\n",
       "      <td>2017-01-24 08:22:03</td>\n",
       "      <td>962.442825</td>\n",
       "      <td>2017-01-24 08:27:02</td>\n",
       "      <td>99.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>82.142</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2684</th>\n",
       "      <td>2017-01-24 08:32:01</td>\n",
       "      <td>971.543545</td>\n",
       "      <td>2017-01-24 11:17:14</td>\n",
       "      <td>114.0</td>\n",
       "      <td>99.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>42.311</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2775</th>\n",
       "      <td>2017-01-24 13:31:07</td>\n",
       "      <td>1163.605039</td>\n",
       "      <td>2017-01-24 14:02:38</td>\n",
       "      <td>86.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>7.909</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2777</th>\n",
       "      <td>2017-01-24 14:03:06</td>\n",
       "      <td>1164.801430</td>\n",
       "      <td>2017-01-24 14:07:36</td>\n",
       "      <td>85.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>71.855</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2784</th>\n",
       "      <td>2017-01-24 14:24:19</td>\n",
       "      <td>1191.360939</td>\n",
       "      <td>2017-01-24 14:30:20</td>\n",
       "      <td>84.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>84.663</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>2017-01-24 14:31:06</td>\n",
       "      <td>1197.563281</td>\n",
       "      <td>2017-01-24 14:37:49</td>\n",
       "      <td>83.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>45.467</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2804</th>\n",
       "      <td>2017-01-24 14:38:22</td>\n",
       "      <td>1205.200923</td>\n",
       "      <td>2017-01-24 14:47:53</td>\n",
       "      <td>81.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>72.437</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2808</th>\n",
       "      <td>2017-01-24 14:49:36</td>\n",
       "      <td>1218.974235</td>\n",
       "      <td>2017-01-24 14:52:48</td>\n",
       "      <td>80.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>64.979</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2809</th>\n",
       "      <td>2017-01-24 14:52:48</td>\n",
       "      <td>1222.217084</td>\n",
       "      <td>2017-01-24 15:12:58</td>\n",
       "      <td>76.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>73.100</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2811</th>\n",
       "      <td>2017-01-24 15:14:14</td>\n",
       "      <td>1234.886605</td>\n",
       "      <td>2017-01-24 15:23:01</td>\n",
       "      <td>74.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>11.871</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2849</th>\n",
       "      <td>2017-01-24 15:26:50</td>\n",
       "      <td>1249.113657</td>\n",
       "      <td>2017-01-24 15:38:05</td>\n",
       "      <td>72.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>57.349</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2851</th>\n",
       "      <td>2017-01-24 15:38:12</td>\n",
       "      <td>1262.227658</td>\n",
       "      <td>2017-01-24 16:16:49</td>\n",
       "      <td>122.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>6290-roda_9.txt</td>\n",
       "      <td>44.413</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3095 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       date        kilom            next_date  next_pres  \\\n",
       "638     2016-12-21 09:11:43    89.927486  2016-12-21 09:11:58      114.0   \n",
       "18346   2017-01-18 10:00:41  1503.387481  2017-01-18 10:01:52      109.0   \n",
       "18368   2017-01-18 10:36:23  1503.543049  2017-01-18 10:36:30      113.0   \n",
       "18370   2017-01-18 10:36:53  1503.543049  2017-01-18 10:37:09      119.0   \n",
       "101874  2017-05-15 10:54:47  3300.976020  2017-05-15 10:55:00      123.0   \n",
       "607     2016-12-21 09:10:16    89.884890  2016-12-21 09:10:28      115.0   \n",
       "86718   2017-05-15 10:58:51  3300.976020  2017-05-15 10:59:05      127.0   \n",
       "2       2016-12-20 11:29:04    14.369656  2016-12-20 11:31:07       94.0   \n",
       "7       2016-12-20 11:39:13    14.449292  2016-12-20 11:41:15       95.0   \n",
       "24      2016-12-20 12:13:43    26.398385  2016-12-20 12:15:43       96.0   \n",
       "45      2016-12-20 12:58:20    45.722136  2016-12-20 13:00:21       97.0   \n",
       "49      2016-12-20 13:08:29    47.253739  2016-12-20 13:10:30       96.0   \n",
       "51      2016-12-20 13:12:34    47.279667  2016-12-20 13:14:33       97.0   \n",
       "55      2016-12-20 13:22:42    47.366711  2016-12-20 13:24:42       96.0   \n",
       "94      2016-12-20 14:52:01    54.926569  2016-12-20 14:54:03       97.0   \n",
       "97      2016-12-20 14:58:08    61.543759  2016-12-20 15:00:08       96.0   \n",
       "99      2016-12-20 15:02:10    65.586671  2016-12-20 15:04:12       97.0   \n",
       "122     2016-12-20 15:50:53    79.272940  2016-12-20 15:52:55       96.0   \n",
       "287     2016-12-20 21:31:54    82.373185  2016-12-20 21:33:55       95.0   \n",
       "290     2016-12-20 21:37:58    82.400965  2016-12-20 21:40:02       96.0   \n",
       "292     2016-12-20 21:42:03    82.441709  2016-12-20 21:44:03       95.0   \n",
       "373     2016-12-21 00:30:25    84.195551  2016-12-21 00:32:28       94.0   \n",
       "376     2016-12-21 00:36:30    84.212219  2016-12-21 00:38:33       95.0   \n",
       "378     2016-12-21 00:40:33    84.241851  2016-12-21 00:42:35       94.0   \n",
       "578     2016-12-21 07:30:08    88.288468  2016-12-21 07:32:08       93.0   \n",
       "581     2016-12-21 07:36:12    88.368104  2016-12-21 07:38:12       94.0   \n",
       "587     2016-12-21 07:50:25    88.557007  2016-12-21 07:52:25       93.0   \n",
       "589     2016-12-21 07:54:25    88.610715  2016-12-21 07:56:28       94.0   \n",
       "594     2016-12-21 08:04:35    88.781099  2016-12-21 08:06:35       93.0   \n",
       "597     2016-12-21 08:10:39    88.964447  2016-12-21 08:12:39       94.0   \n",
       "...                     ...          ...                  ...        ...   \n",
       "7827    2017-02-11 08:02:19  7536.166705  2017-02-11 08:17:04       86.0   \n",
       "7828    2017-02-11 08:17:04  7551.408652  2017-02-11 08:22:00       87.0   \n",
       "7830    2017-02-11 08:27:05  7562.607686  2017-02-11 08:54:37       88.0   \n",
       "7833    2017-02-11 09:12:28  7607.500128  2017-02-11 10:25:41      123.0   \n",
       "1252    2017-01-23 05:59:02   400.453910  2017-01-23 06:23:29      103.0   \n",
       "1716    2017-01-23 13:32:39   675.983120  2017-01-23 13:37:20       93.0   \n",
       "1749    2017-01-23 13:38:06   680.850172  2017-01-23 13:47:40       94.0   \n",
       "2171    2017-01-23 14:37:36   731.739384  2017-01-23 14:47:52       93.0   \n",
       "2174    2017-01-23 14:48:04   739.491849  2017-01-23 14:53:03       92.0   \n",
       "2179    2017-01-23 14:53:24   742.592094  2017-01-23 14:58:02       91.0   \n",
       "2243    2017-01-23 15:04:42   748.694429  2017-01-23 15:07:52       89.0   \n",
       "2265    2017-01-23 15:14:47   757.634025  2017-01-23 15:33:03       86.0   \n",
       "2427    2017-01-23 15:41:32   780.885865  2017-01-23 15:48:10       85.0   \n",
       "2531    2017-01-23 16:04:39   804.402541  2017-01-23 16:13:26       84.0   \n",
       "2626    2017-01-23 16:21:11   818.381425  2017-01-23 17:19:38      109.0   \n",
       "2678    2017-01-24 07:57:16   939.372480  2017-01-24 08:03:23       96.0   \n",
       "2680    2017-01-24 08:03:39   945.556303  2017-01-24 08:07:06       97.0   \n",
       "2681    2017-01-24 08:07:06   948.743592  2017-01-24 08:22:03       98.0   \n",
       "2682    2017-01-24 08:22:03   962.442825  2017-01-24 08:27:02       99.0   \n",
       "2684    2017-01-24 08:32:01   971.543545  2017-01-24 11:17:14      114.0   \n",
       "2775    2017-01-24 13:31:07  1163.605039  2017-01-24 14:02:38       86.0   \n",
       "2777    2017-01-24 14:03:06  1164.801430  2017-01-24 14:07:36       85.0   \n",
       "2784    2017-01-24 14:24:19  1191.360939  2017-01-24 14:30:20       84.0   \n",
       "2802    2017-01-24 14:31:06  1197.563281  2017-01-24 14:37:49       83.0   \n",
       "2804    2017-01-24 14:38:22  1205.200923  2017-01-24 14:47:53       81.0   \n",
       "2808    2017-01-24 14:49:36  1218.974235  2017-01-24 14:52:48       80.0   \n",
       "2809    2017-01-24 14:52:48  1222.217084  2017-01-24 15:12:58       76.0   \n",
       "2811    2017-01-24 15:14:14  1234.886605  2017-01-24 15:23:01       74.0   \n",
       "2849    2017-01-24 15:26:50  1249.113657  2017-01-24 15:38:05       72.0   \n",
       "2851    2017-01-24 15:38:12  1262.227658  2017-01-24 16:16:49      122.0   \n",
       "\n",
       "        pres  temp            tires   veloc  press_diff  \n",
       "638     97.0  24.0  2559-roda_1.txt   0.000        17.0  \n",
       "18346   98.0  25.0  2559-roda_1.txt   0.000        11.0  \n",
       "18368   99.0  26.0  2559-roda_1.txt   0.000        14.0  \n",
       "18370   94.0  26.0  2559-roda_1.txt   0.000        25.0  \n",
       "101874  94.0  14.0  2559-roda_1.txt   0.000        29.0  \n",
       "607     99.0  24.0  2559-roda_4.txt   0.000        16.0  \n",
       "86718   94.0  14.0  2559-roda_4.txt   0.000        33.0  \n",
       "2       95.0  33.0  2559-roda_7.txt   1.844         1.0  \n",
       "7       94.0  27.0  2559-roda_7.txt   0.000         1.0  \n",
       "24      95.0  31.0  2559-roda_7.txt  55.974         1.0  \n",
       "45      96.0  33.0  2559-roda_7.txt  31.310         1.0  \n",
       "49      97.0  33.0  2559-roda_7.txt   0.000         1.0  \n",
       "51      96.0  32.0  2559-roda_7.txt   0.000         1.0  \n",
       "55      97.0  31.0  2559-roda_7.txt   0.000         1.0  \n",
       "94      96.0  32.0  2559-roda_7.txt  64.143         1.0  \n",
       "97      97.0  34.0  2559-roda_7.txt  61.959         1.0  \n",
       "99      96.0  34.0  2559-roda_7.txt  59.653         1.0  \n",
       "122     97.0  28.0  2559-roda_7.txt   0.000         1.0  \n",
       "287     96.0  29.0  2559-roda_7.txt   0.000         1.0  \n",
       "290     95.0  28.0  2559-roda_7.txt   0.000         1.0  \n",
       "292     96.0  29.0  2559-roda_7.txt   0.000         1.0  \n",
       "373     95.0  26.0  2559-roda_7.txt   0.000         1.0  \n",
       "376     94.0  26.0  2559-roda_7.txt   0.000         1.0  \n",
       "378     95.0  26.0  2559-roda_7.txt   0.000         1.0  \n",
       "578     94.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "581     93.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "587     94.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "589     93.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "594     94.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "597     93.0  24.0  2559-roda_7.txt   0.000         1.0  \n",
       "...      ...   ...              ...     ...         ...  \n",
       "7827    84.0  34.0  6290-roda_5.txt  23.409         2.0  \n",
       "7828    86.0  32.0  6290-roda_5.txt  73.625         1.0  \n",
       "7830    87.0  34.0  6290-roda_5.txt  84.188         1.0  \n",
       "7833    88.0  38.0  6290-roda_5.txt  40.874        35.0  \n",
       "1252    97.0  21.0  6290-roda_9.txt   0.000         6.0  \n",
       "1716    92.0  39.0  6290-roda_9.txt  82.874         1.0  \n",
       "1749    93.0  38.0  6290-roda_9.txt  24.503         1.0  \n",
       "2171    94.0  51.0  6290-roda_9.txt  45.135         1.0  \n",
       "2174    93.0  52.0  6290-roda_9.txt  27.021         1.0  \n",
       "2179    92.0  51.0  6290-roda_9.txt  34.703         1.0  \n",
       "2243    91.0  49.0  6290-roda_9.txt  24.345         2.0  \n",
       "2265    89.0  49.0  6290-roda_9.txt  36.174         3.0  \n",
       "2427    86.0  51.0  6290-roda_9.txt  79.266         1.0  \n",
       "2531    85.0  61.0  6290-roda_9.txt  42.822         1.0  \n",
       "2626    84.0  60.0  6290-roda_9.txt  84.429        25.0  \n",
       "2678    93.0  20.0  6290-roda_9.txt  51.103         3.0  \n",
       "2680    96.0  20.0  6290-roda_9.txt  37.578         1.0  \n",
       "2681    97.0  21.0  6290-roda_9.txt  42.238         1.0  \n",
       "2682    98.0  22.0  6290-roda_9.txt  82.142         1.0  \n",
       "2684    99.0  23.0  6290-roda_9.txt  42.311        15.0  \n",
       "2775    94.0  42.0  6290-roda_9.txt   7.909         8.0  \n",
       "2777    86.0  43.0  6290-roda_9.txt  71.855         1.0  \n",
       "2784    85.0  41.0  6290-roda_9.txt  84.663         1.0  \n",
       "2802    84.0  41.0  6290-roda_9.txt  45.467         1.0  \n",
       "2804    83.0  43.0  6290-roda_9.txt  72.437         2.0  \n",
       "2808    81.0  42.0  6290-roda_9.txt  64.979         1.0  \n",
       "2809    80.0  42.0  6290-roda_9.txt  73.100         4.0  \n",
       "2811    76.0  48.0  6290-roda_9.txt  11.871         2.0  \n",
       "2849    74.0  45.0  6290-roda_9.txt  57.349         2.0  \n",
       "2851    72.0  44.0  6290-roda_9.txt  44.413        50.0  \n",
       "\n",
       "[3095 rows x 9 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sensor_filter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sensor_filter.to_csv('sensor_savings.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}