1853 lines (1852 with data), 59.8 kB
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"CPU times: user 44.7 s, sys: 6.46 s, total: 51.1 s\n",
"Wall time: 51.1 s\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>target</th>\n",
" <th>subject</th>\n",
" <th>chest_ACC_x</th>\n",
" <th>chest_ACC_y</th>\n",
" <th>chest_ACC_z</th>\n",
" <th>chest_ECG</th>\n",
" <th>chest_EMG</th>\n",
" <th>chest_EDA</th>\n",
" <th>chest_Temp</th>\n",
" <th>chest_Resp</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6280</td>\n",
" <td>-0.0082</td>\n",
" <td>-0.7272</td>\n",
" <td>0.016937</td>\n",
" <td>0.134720</td>\n",
" <td>9.645462</td>\n",
" <td>33.432587</td>\n",
" <td>4.010010</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6276</td>\n",
" <td>-0.0056</td>\n",
" <td>-0.7262</td>\n",
" <td>0.017853</td>\n",
" <td>0.216248</td>\n",
" <td>9.645462</td>\n",
" <td>33.459747</td>\n",
" <td>4.039001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6270</td>\n",
" <td>-0.0054</td>\n",
" <td>-0.7200</td>\n",
" <td>0.016525</td>\n",
" <td>0.142136</td>\n",
" <td>9.646606</td>\n",
" <td>33.452240</td>\n",
" <td>3.993225</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6266</td>\n",
" <td>-0.0070</td>\n",
" <td>-0.7174</td>\n",
" <td>0.012863</td>\n",
" <td>0.033371</td>\n",
" <td>9.646225</td>\n",
" <td>33.453735</td>\n",
" <td>4.002380</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6242</td>\n",
" <td>-0.0078</td>\n",
" <td>-0.7202</td>\n",
" <td>0.007278</td>\n",
" <td>-0.024994</td>\n",
" <td>9.646988</td>\n",
" <td>33.426544</td>\n",
" <td>3.996277</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6238</td>\n",
" <td>-0.0072</td>\n",
" <td>-0.7206</td>\n",
" <td>-0.007416</td>\n",
" <td>-0.050766</td>\n",
" <td>9.645462</td>\n",
" <td>33.447693</td>\n",
" <td>3.977966</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6242</td>\n",
" <td>-0.0090</td>\n",
" <td>-0.7194</td>\n",
" <td>-0.025040</td>\n",
" <td>-0.017715</td>\n",
" <td>9.647369</td>\n",
" <td>33.444672</td>\n",
" <td>3.956604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6232</td>\n",
" <td>-0.0074</td>\n",
" <td>-0.7182</td>\n",
" <td>-0.039093</td>\n",
" <td>0.011215</td>\n",
" <td>9.648132</td>\n",
" <td>33.467316</td>\n",
" <td>3.953552</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6218</td>\n",
" <td>-0.0114</td>\n",
" <td>-0.7166</td>\n",
" <td>-0.045410</td>\n",
" <td>-0.011032</td>\n",
" <td>9.646988</td>\n",
" <td>33.453735</td>\n",
" <td>3.929138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6162</td>\n",
" <td>-0.0130</td>\n",
" <td>-0.7158</td>\n",
" <td>-0.040237</td>\n",
" <td>-0.049576</td>\n",
" <td>9.646225</td>\n",
" <td>33.437103</td>\n",
" <td>3.932190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6158</td>\n",
" <td>-0.0158</td>\n",
" <td>-0.7138</td>\n",
" <td>-0.024490</td>\n",
" <td>-0.069260</td>\n",
" <td>9.645081</td>\n",
" <td>33.447693</td>\n",
" <td>3.904724</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6140</td>\n",
" <td>-0.0156</td>\n",
" <td>-0.7128</td>\n",
" <td>-0.012909</td>\n",
" <td>-0.053513</td>\n",
" <td>9.644699</td>\n",
" <td>33.447693</td>\n",
" <td>3.892517</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6090</td>\n",
" <td>-0.0142</td>\n",
" <td>-0.7138</td>\n",
" <td>-0.009293</td>\n",
" <td>-0.049026</td>\n",
" <td>9.643936</td>\n",
" <td>33.447693</td>\n",
" <td>3.883362</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6082</td>\n",
" <td>-0.0166</td>\n",
" <td>-0.7090</td>\n",
" <td>-0.008194</td>\n",
" <td>-0.016800</td>\n",
" <td>9.645844</td>\n",
" <td>33.414459</td>\n",
" <td>3.906250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6058</td>\n",
" <td>-0.0184</td>\n",
" <td>-0.7082</td>\n",
" <td>-0.008606</td>\n",
" <td>0.059189</td>\n",
" <td>9.644318</td>\n",
" <td>33.411469</td>\n",
" <td>3.712463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6040</td>\n",
" <td>-0.0218</td>\n",
" <td>-0.7048</td>\n",
" <td>-0.003250</td>\n",
" <td>0.077133</td>\n",
" <td>9.643936</td>\n",
" <td>33.465851</td>\n",
" <td>3.254700</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6040</td>\n",
" <td>-0.0238</td>\n",
" <td>-0.7128</td>\n",
" <td>0.000916</td>\n",
" <td>0.010071</td>\n",
" <td>9.643173</td>\n",
" <td>33.450684</td>\n",
" <td>3.834534</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6038</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.7160</td>\n",
" <td>0.003433</td>\n",
" <td>0.006821</td>\n",
" <td>9.643173</td>\n",
" <td>33.435608</td>\n",
" <td>3.840637</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6018</td>\n",
" <td>-0.0286</td>\n",
" <td>-0.7110</td>\n",
" <td>-0.003067</td>\n",
" <td>-0.011856</td>\n",
" <td>9.643936</td>\n",
" <td>33.508148</td>\n",
" <td>3.851318</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5994</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.7126</td>\n",
" <td>-0.015884</td>\n",
" <td>-0.044632</td>\n",
" <td>9.643936</td>\n",
" <td>33.438599</td>\n",
" <td>3.837585</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5978</td>\n",
" <td>-0.0326</td>\n",
" <td>-0.7080</td>\n",
" <td>-0.030899</td>\n",
" <td>0.076950</td>\n",
" <td>9.644699</td>\n",
" <td>33.462799</td>\n",
" <td>3.788757</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5982</td>\n",
" <td>-0.0358</td>\n",
" <td>-0.7064</td>\n",
" <td>-0.035339</td>\n",
" <td>0.133026</td>\n",
" <td>9.643173</td>\n",
" <td>33.444672</td>\n",
" <td>3.782654</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5950</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.7106</td>\n",
" <td>-0.034470</td>\n",
" <td>0.051956</td>\n",
" <td>9.645462</td>\n",
" <td>33.459747</td>\n",
" <td>3.778076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5948</td>\n",
" <td>-0.0350</td>\n",
" <td>-0.7102</td>\n",
" <td>-0.034332</td>\n",
" <td>-0.047836</td>\n",
" <td>9.643936</td>\n",
" <td>33.438599</td>\n",
" <td>3.761292</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5912</td>\n",
" <td>-0.0352</td>\n",
" <td>-0.7046</td>\n",
" <td>-0.033737</td>\n",
" <td>-0.207779</td>\n",
" <td>9.643936</td>\n",
" <td>33.441620</td>\n",
" <td>3.762817</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5922</td>\n",
" <td>-0.0370</td>\n",
" <td>-0.7056</td>\n",
" <td>-0.024765</td>\n",
" <td>-0.344147</td>\n",
" <td>9.643173</td>\n",
" <td>33.440155</td>\n",
" <td>3.746033</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5928</td>\n",
" <td>-0.0410</td>\n",
" <td>-0.7054</td>\n",
" <td>-0.021149</td>\n",
" <td>-0.347305</td>\n",
" <td>9.643936</td>\n",
" <td>33.536865</td>\n",
" <td>3.778076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5914</td>\n",
" <td>-0.0406</td>\n",
" <td>-0.7032</td>\n",
" <td>-0.026413</td>\n",
" <td>-0.049118</td>\n",
" <td>9.643173</td>\n",
" <td>33.450684</td>\n",
" <td>3.648376</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5890</td>\n",
" <td>-0.0418</td>\n",
" <td>-0.7054</td>\n",
" <td>-0.032547</td>\n",
" <td>0.199448</td>\n",
" <td>9.643173</td>\n",
" <td>33.455261</td>\n",
" <td>3.285217</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5886</td>\n",
" <td>-0.0466</td>\n",
" <td>-0.7026</td>\n",
" <td>-0.032593</td>\n",
" <td>0.287384</td>\n",
" <td>9.643173</td>\n",
" <td>33.476379</td>\n",
" <td>3.697205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470573</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8482</td>\n",
" <td>-0.0274</td>\n",
" <td>-0.3788</td>\n",
" <td>-0.144699</td>\n",
" <td>0.013138</td>\n",
" <td>12.242508</td>\n",
" <td>34.706207</td>\n",
" <td>2.009583</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470574</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8474</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.3698</td>\n",
" <td>-0.141861</td>\n",
" <td>0.009384</td>\n",
" <td>12.242508</td>\n",
" <td>34.724670</td>\n",
" <td>2.021790</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470575</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8510</td>\n",
" <td>-0.0262</td>\n",
" <td>-0.3596</td>\n",
" <td>-0.138016</td>\n",
" <td>-0.006271</td>\n",
" <td>12.242508</td>\n",
" <td>34.713867</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470576</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8486</td>\n",
" <td>-0.0258</td>\n",
" <td>-0.3560</td>\n",
" <td>-0.133072</td>\n",
" <td>-0.015427</td>\n",
" <td>12.234879</td>\n",
" <td>34.727722</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470577</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8466</td>\n",
" <td>-0.0228</td>\n",
" <td>-0.3560</td>\n",
" <td>-0.128677</td>\n",
" <td>-0.011902</td>\n",
" <td>12.240982</td>\n",
" <td>34.724670</td>\n",
" <td>2.064514</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470578</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0236</td>\n",
" <td>-0.3570</td>\n",
" <td>-0.125977</td>\n",
" <td>-0.004166</td>\n",
" <td>12.241745</td>\n",
" <td>34.720032</td>\n",
" <td>2.061462</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470579</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8442</td>\n",
" <td>-0.0238</td>\n",
" <td>-0.3682</td>\n",
" <td>-0.124329</td>\n",
" <td>-0.016617</td>\n",
" <td>12.240982</td>\n",
" <td>34.726166</td>\n",
" <td>1.881409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470580</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8414</td>\n",
" <td>-0.0262</td>\n",
" <td>-0.3758</td>\n",
" <td>-0.124283</td>\n",
" <td>-0.015244</td>\n",
" <td>12.240219</td>\n",
" <td>34.681610</td>\n",
" <td>2.018738</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470581</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8382</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.3814</td>\n",
" <td>-0.123230</td>\n",
" <td>-0.018082</td>\n",
" <td>12.242508</td>\n",
" <td>34.744629</td>\n",
" <td>2.021790</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470582</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8402</td>\n",
" <td>-0.0242</td>\n",
" <td>-0.3906</td>\n",
" <td>-0.120667</td>\n",
" <td>-0.016068</td>\n",
" <td>12.240219</td>\n",
" <td>34.712341</td>\n",
" <td>2.030945</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470583</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8350</td>\n",
" <td>-0.0222</td>\n",
" <td>-0.3960</td>\n",
" <td>-0.117691</td>\n",
" <td>-0.010529</td>\n",
" <td>12.240982</td>\n",
" <td>34.726166</td>\n",
" <td>2.052307</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470584</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8358</td>\n",
" <td>-0.0258</td>\n",
" <td>-0.4038</td>\n",
" <td>-0.115677</td>\n",
" <td>-0.001602</td>\n",
" <td>12.234879</td>\n",
" <td>34.712341</td>\n",
" <td>2.056885</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470585</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8356</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4118</td>\n",
" <td>-0.112198</td>\n",
" <td>0.006363</td>\n",
" <td>12.240982</td>\n",
" <td>34.715424</td>\n",
" <td>2.061462</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470586</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8354</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4130</td>\n",
" <td>-0.109451</td>\n",
" <td>0.003479</td>\n",
" <td>12.245178</td>\n",
" <td>34.720032</td>\n",
" <td>2.043152</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470587</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8354</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4126</td>\n",
" <td>-0.108765</td>\n",
" <td>-0.010071</td>\n",
" <td>12.239838</td>\n",
" <td>34.733856</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470588</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8370</td>\n",
" <td>-0.0274</td>\n",
" <td>-0.4066</td>\n",
" <td>-0.105377</td>\n",
" <td>0.000961</td>\n",
" <td>12.238693</td>\n",
" <td>34.727722</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470589</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8376</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.4014</td>\n",
" <td>-0.101120</td>\n",
" <td>-0.006729</td>\n",
" <td>12.239456</td>\n",
" <td>34.740021</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470590</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8396</td>\n",
" <td>-0.0302</td>\n",
" <td>-0.3942</td>\n",
" <td>-0.097366</td>\n",
" <td>-0.005447</td>\n",
" <td>12.240219</td>\n",
" <td>34.727722</td>\n",
" <td>2.032471</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470591</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8390</td>\n",
" <td>-0.0294</td>\n",
" <td>-0.3864</td>\n",
" <td>-0.092834</td>\n",
" <td>-0.005081</td>\n",
" <td>12.234879</td>\n",
" <td>34.740021</td>\n",
" <td>2.027893</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470592</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8398</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.3806</td>\n",
" <td>-0.088943</td>\n",
" <td>-0.005173</td>\n",
" <td>12.239075</td>\n",
" <td>34.710846</td>\n",
" <td>2.040100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470593</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8382</td>\n",
" <td>-0.0302</td>\n",
" <td>-0.3766</td>\n",
" <td>-0.087753</td>\n",
" <td>-0.002792</td>\n",
" <td>12.239456</td>\n",
" <td>34.727722</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470594</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8414</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.3720</td>\n",
" <td>-0.088760</td>\n",
" <td>-0.006638</td>\n",
" <td>12.239456</td>\n",
" <td>34.723114</td>\n",
" <td>2.041626</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470595</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8440</td>\n",
" <td>-0.0330</td>\n",
" <td>-0.3710</td>\n",
" <td>-0.085098</td>\n",
" <td>0.008514</td>\n",
" <td>12.239456</td>\n",
" <td>34.712341</td>\n",
" <td>1.889038</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470596</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8452</td>\n",
" <td>-0.0322</td>\n",
" <td>-0.3674</td>\n",
" <td>-0.082809</td>\n",
" <td>0.006775</td>\n",
" <td>12.237930</td>\n",
" <td>34.663177</td>\n",
" <td>2.073669</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470597</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.3608</td>\n",
" <td>-0.079971</td>\n",
" <td>0.000778</td>\n",
" <td>12.240219</td>\n",
" <td>34.732361</td>\n",
" <td>2.082825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470598</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8442</td>\n",
" <td>-0.0344</td>\n",
" <td>-0.3638</td>\n",
" <td>-0.076309</td>\n",
" <td>-0.001511</td>\n",
" <td>12.240219</td>\n",
" <td>34.724670</td>\n",
" <td>2.073669</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470599</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8434</td>\n",
" <td>-0.0330</td>\n",
" <td>-0.3634</td>\n",
" <td>-0.074844</td>\n",
" <td>-0.006271</td>\n",
" <td>12.240219</td>\n",
" <td>34.716980</td>\n",
" <td>2.082825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470600</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8462</td>\n",
" <td>-0.0348</td>\n",
" <td>-0.3650</td>\n",
" <td>-0.073013</td>\n",
" <td>-0.006638</td>\n",
" <td>12.233353</td>\n",
" <td>34.715424</td>\n",
" <td>2.079773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470601</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0360</td>\n",
" <td>-0.3652</td>\n",
" <td>-0.071136</td>\n",
" <td>-0.001694</td>\n",
" <td>12.239075</td>\n",
" <td>34.724670</td>\n",
" <td>2.079773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470602</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8472</td>\n",
" <td>-0.0358</td>\n",
" <td>-0.3654</td>\n",
" <td>-0.067154</td>\n",
" <td>0.000778</td>\n",
" <td>12.236786</td>\n",
" <td>34.726166</td>\n",
" <td>2.076721</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>31470603 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" target subject chest_ACC_x chest_ACC_y chest_ACC_z chest_ECG \\\n",
"0 1 6 0.6280 -0.0082 -0.7272 0.016937 \n",
"1 1 6 0.6276 -0.0056 -0.7262 0.017853 \n",
"2 1 6 0.6270 -0.0054 -0.7200 0.016525 \n",
"3 1 6 0.6266 -0.0070 -0.7174 0.012863 \n",
"4 1 6 0.6242 -0.0078 -0.7202 0.007278 \n",
"... ... ... ... ... ... ... \n",
"31470598 4 7 0.8442 -0.0344 -0.3638 -0.076309 \n",
"31470599 4 7 0.8434 -0.0330 -0.3634 -0.074844 \n",
"31470600 4 7 0.8462 -0.0348 -0.3650 -0.073013 \n",
"31470601 4 7 0.8446 -0.0360 -0.3652 -0.071136 \n",
"31470602 4 7 0.8472 -0.0358 -0.3654 -0.067154 \n",
"\n",
" chest_EMG chest_EDA chest_Temp chest_Resp \n",
"0 0.134720 9.645462 33.432587 4.010010 \n",
"1 0.216248 9.645462 33.459747 4.039001 \n",
"2 0.142136 9.646606 33.452240 3.993225 \n",
"3 0.033371 9.646225 33.453735 4.002380 \n",
"4 -0.024994 9.646988 33.426544 3.996277 \n",
"... ... ... ... ... \n",
"31470598 -0.001511 12.240219 34.724670 2.073669 \n",
"31470599 -0.006271 12.240219 34.716980 2.082825 \n",
"31470600 -0.006638 12.233353 34.715424 2.079773 \n",
"31470601 -0.001694 12.239075 34.724670 2.079773 \n",
"31470602 0.000778 12.236786 34.726166 2.076721 \n",
"\n",
"[31470603 rows x 10 columns]"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%%time\n",
"df = pd.read_csv(\"master_data.csv\")\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"df = df[df['target']>0]"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"scrolled": true
},
"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>target</th>\n",
" <th>subject</th>\n",
" <th>chest_ACC_x</th>\n",
" <th>chest_ACC_y</th>\n",
" <th>chest_ACC_z</th>\n",
" <th>chest_ECG</th>\n",
" <th>chest_EMG</th>\n",
" <th>chest_EDA</th>\n",
" <th>chest_Temp</th>\n",
" <th>chest_Resp</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6280</td>\n",
" <td>-0.0082</td>\n",
" <td>-0.7272</td>\n",
" <td>0.016937</td>\n",
" <td>0.134720</td>\n",
" <td>9.645462</td>\n",
" <td>33.432587</td>\n",
" <td>4.010010</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6276</td>\n",
" <td>-0.0056</td>\n",
" <td>-0.7262</td>\n",
" <td>0.017853</td>\n",
" <td>0.216248</td>\n",
" <td>9.645462</td>\n",
" <td>33.459747</td>\n",
" <td>4.039001</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6270</td>\n",
" <td>-0.0054</td>\n",
" <td>-0.7200</td>\n",
" <td>0.016525</td>\n",
" <td>0.142136</td>\n",
" <td>9.646606</td>\n",
" <td>33.452240</td>\n",
" <td>3.993225</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6266</td>\n",
" <td>-0.0070</td>\n",
" <td>-0.7174</td>\n",
" <td>0.012863</td>\n",
" <td>0.033371</td>\n",
" <td>9.646225</td>\n",
" <td>33.453735</td>\n",
" <td>4.002380</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6242</td>\n",
" <td>-0.0078</td>\n",
" <td>-0.7202</td>\n",
" <td>0.007278</td>\n",
" <td>-0.024994</td>\n",
" <td>9.646988</td>\n",
" <td>33.426544</td>\n",
" <td>3.996277</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6238</td>\n",
" <td>-0.0072</td>\n",
" <td>-0.7206</td>\n",
" <td>-0.007416</td>\n",
" <td>-0.050766</td>\n",
" <td>9.645462</td>\n",
" <td>33.447693</td>\n",
" <td>3.977966</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6242</td>\n",
" <td>-0.0090</td>\n",
" <td>-0.7194</td>\n",
" <td>-0.025040</td>\n",
" <td>-0.017715</td>\n",
" <td>9.647369</td>\n",
" <td>33.444672</td>\n",
" <td>3.956604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6232</td>\n",
" <td>-0.0074</td>\n",
" <td>-0.7182</td>\n",
" <td>-0.039093</td>\n",
" <td>0.011215</td>\n",
" <td>9.648132</td>\n",
" <td>33.467316</td>\n",
" <td>3.953552</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6218</td>\n",
" <td>-0.0114</td>\n",
" <td>-0.7166</td>\n",
" <td>-0.045410</td>\n",
" <td>-0.011032</td>\n",
" <td>9.646988</td>\n",
" <td>33.453735</td>\n",
" <td>3.929138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6162</td>\n",
" <td>-0.0130</td>\n",
" <td>-0.7158</td>\n",
" <td>-0.040237</td>\n",
" <td>-0.049576</td>\n",
" <td>9.646225</td>\n",
" <td>33.437103</td>\n",
" <td>3.932190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6158</td>\n",
" <td>-0.0158</td>\n",
" <td>-0.7138</td>\n",
" <td>-0.024490</td>\n",
" <td>-0.069260</td>\n",
" <td>9.645081</td>\n",
" <td>33.447693</td>\n",
" <td>3.904724</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6140</td>\n",
" <td>-0.0156</td>\n",
" <td>-0.7128</td>\n",
" <td>-0.012909</td>\n",
" <td>-0.053513</td>\n",
" <td>9.644699</td>\n",
" <td>33.447693</td>\n",
" <td>3.892517</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6090</td>\n",
" <td>-0.0142</td>\n",
" <td>-0.7138</td>\n",
" <td>-0.009293</td>\n",
" <td>-0.049026</td>\n",
" <td>9.643936</td>\n",
" <td>33.447693</td>\n",
" <td>3.883362</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6082</td>\n",
" <td>-0.0166</td>\n",
" <td>-0.7090</td>\n",
" <td>-0.008194</td>\n",
" <td>-0.016800</td>\n",
" <td>9.645844</td>\n",
" <td>33.414459</td>\n",
" <td>3.906250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6058</td>\n",
" <td>-0.0184</td>\n",
" <td>-0.7082</td>\n",
" <td>-0.008606</td>\n",
" <td>0.059189</td>\n",
" <td>9.644318</td>\n",
" <td>33.411469</td>\n",
" <td>3.712463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6040</td>\n",
" <td>-0.0218</td>\n",
" <td>-0.7048</td>\n",
" <td>-0.003250</td>\n",
" <td>0.077133</td>\n",
" <td>9.643936</td>\n",
" <td>33.465851</td>\n",
" <td>3.254700</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6040</td>\n",
" <td>-0.0238</td>\n",
" <td>-0.7128</td>\n",
" <td>0.000916</td>\n",
" <td>0.010071</td>\n",
" <td>9.643173</td>\n",
" <td>33.450684</td>\n",
" <td>3.834534</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6038</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.7160</td>\n",
" <td>0.003433</td>\n",
" <td>0.006821</td>\n",
" <td>9.643173</td>\n",
" <td>33.435608</td>\n",
" <td>3.840637</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.6018</td>\n",
" <td>-0.0286</td>\n",
" <td>-0.7110</td>\n",
" <td>-0.003067</td>\n",
" <td>-0.011856</td>\n",
" <td>9.643936</td>\n",
" <td>33.508148</td>\n",
" <td>3.851318</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5994</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.7126</td>\n",
" <td>-0.015884</td>\n",
" <td>-0.044632</td>\n",
" <td>9.643936</td>\n",
" <td>33.438599</td>\n",
" <td>3.837585</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5978</td>\n",
" <td>-0.0326</td>\n",
" <td>-0.7080</td>\n",
" <td>-0.030899</td>\n",
" <td>0.076950</td>\n",
" <td>9.644699</td>\n",
" <td>33.462799</td>\n",
" <td>3.788757</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5982</td>\n",
" <td>-0.0358</td>\n",
" <td>-0.7064</td>\n",
" <td>-0.035339</td>\n",
" <td>0.133026</td>\n",
" <td>9.643173</td>\n",
" <td>33.444672</td>\n",
" <td>3.782654</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5950</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.7106</td>\n",
" <td>-0.034470</td>\n",
" <td>0.051956</td>\n",
" <td>9.645462</td>\n",
" <td>33.459747</td>\n",
" <td>3.778076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5948</td>\n",
" <td>-0.0350</td>\n",
" <td>-0.7102</td>\n",
" <td>-0.034332</td>\n",
" <td>-0.047836</td>\n",
" <td>9.643936</td>\n",
" <td>33.438599</td>\n",
" <td>3.761292</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5912</td>\n",
" <td>-0.0352</td>\n",
" <td>-0.7046</td>\n",
" <td>-0.033737</td>\n",
" <td>-0.207779</td>\n",
" <td>9.643936</td>\n",
" <td>33.441620</td>\n",
" <td>3.762817</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5922</td>\n",
" <td>-0.0370</td>\n",
" <td>-0.7056</td>\n",
" <td>-0.024765</td>\n",
" <td>-0.344147</td>\n",
" <td>9.643173</td>\n",
" <td>33.440155</td>\n",
" <td>3.746033</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5928</td>\n",
" <td>-0.0410</td>\n",
" <td>-0.7054</td>\n",
" <td>-0.021149</td>\n",
" <td>-0.347305</td>\n",
" <td>9.643936</td>\n",
" <td>33.536865</td>\n",
" <td>3.778076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5914</td>\n",
" <td>-0.0406</td>\n",
" <td>-0.7032</td>\n",
" <td>-0.026413</td>\n",
" <td>-0.049118</td>\n",
" <td>9.643173</td>\n",
" <td>33.450684</td>\n",
" <td>3.648376</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5890</td>\n",
" <td>-0.0418</td>\n",
" <td>-0.7054</td>\n",
" <td>-0.032547</td>\n",
" <td>0.199448</td>\n",
" <td>9.643173</td>\n",
" <td>33.455261</td>\n",
" <td>3.285217</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.5886</td>\n",
" <td>-0.0466</td>\n",
" <td>-0.7026</td>\n",
" <td>-0.032593</td>\n",
" <td>0.287384</td>\n",
" <td>9.643173</td>\n",
" <td>33.476379</td>\n",
" <td>3.697205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470573</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8482</td>\n",
" <td>-0.0274</td>\n",
" <td>-0.3788</td>\n",
" <td>-0.144699</td>\n",
" <td>0.013138</td>\n",
" <td>12.242508</td>\n",
" <td>34.706207</td>\n",
" <td>2.009583</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470574</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8474</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.3698</td>\n",
" <td>-0.141861</td>\n",
" <td>0.009384</td>\n",
" <td>12.242508</td>\n",
" <td>34.724670</td>\n",
" <td>2.021790</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470575</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8510</td>\n",
" <td>-0.0262</td>\n",
" <td>-0.3596</td>\n",
" <td>-0.138016</td>\n",
" <td>-0.006271</td>\n",
" <td>12.242508</td>\n",
" <td>34.713867</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470576</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8486</td>\n",
" <td>-0.0258</td>\n",
" <td>-0.3560</td>\n",
" <td>-0.133072</td>\n",
" <td>-0.015427</td>\n",
" <td>12.234879</td>\n",
" <td>34.727722</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470577</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8466</td>\n",
" <td>-0.0228</td>\n",
" <td>-0.3560</td>\n",
" <td>-0.128677</td>\n",
" <td>-0.011902</td>\n",
" <td>12.240982</td>\n",
" <td>34.724670</td>\n",
" <td>2.064514</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470578</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0236</td>\n",
" <td>-0.3570</td>\n",
" <td>-0.125977</td>\n",
" <td>-0.004166</td>\n",
" <td>12.241745</td>\n",
" <td>34.720032</td>\n",
" <td>2.061462</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470579</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8442</td>\n",
" <td>-0.0238</td>\n",
" <td>-0.3682</td>\n",
" <td>-0.124329</td>\n",
" <td>-0.016617</td>\n",
" <td>12.240982</td>\n",
" <td>34.726166</td>\n",
" <td>1.881409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470580</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8414</td>\n",
" <td>-0.0262</td>\n",
" <td>-0.3758</td>\n",
" <td>-0.124283</td>\n",
" <td>-0.015244</td>\n",
" <td>12.240219</td>\n",
" <td>34.681610</td>\n",
" <td>2.018738</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470581</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8382</td>\n",
" <td>-0.0254</td>\n",
" <td>-0.3814</td>\n",
" <td>-0.123230</td>\n",
" <td>-0.018082</td>\n",
" <td>12.242508</td>\n",
" <td>34.744629</td>\n",
" <td>2.021790</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470582</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8402</td>\n",
" <td>-0.0242</td>\n",
" <td>-0.3906</td>\n",
" <td>-0.120667</td>\n",
" <td>-0.016068</td>\n",
" <td>12.240219</td>\n",
" <td>34.712341</td>\n",
" <td>2.030945</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470583</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8350</td>\n",
" <td>-0.0222</td>\n",
" <td>-0.3960</td>\n",
" <td>-0.117691</td>\n",
" <td>-0.010529</td>\n",
" <td>12.240982</td>\n",
" <td>34.726166</td>\n",
" <td>2.052307</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470584</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8358</td>\n",
" <td>-0.0258</td>\n",
" <td>-0.4038</td>\n",
" <td>-0.115677</td>\n",
" <td>-0.001602</td>\n",
" <td>12.234879</td>\n",
" <td>34.712341</td>\n",
" <td>2.056885</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470585</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8356</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4118</td>\n",
" <td>-0.112198</td>\n",
" <td>0.006363</td>\n",
" <td>12.240982</td>\n",
" <td>34.715424</td>\n",
" <td>2.061462</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470586</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8354</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4130</td>\n",
" <td>-0.109451</td>\n",
" <td>0.003479</td>\n",
" <td>12.245178</td>\n",
" <td>34.720032</td>\n",
" <td>2.043152</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470587</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8354</td>\n",
" <td>-0.0264</td>\n",
" <td>-0.4126</td>\n",
" <td>-0.108765</td>\n",
" <td>-0.010071</td>\n",
" <td>12.239838</td>\n",
" <td>34.733856</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470588</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8370</td>\n",
" <td>-0.0274</td>\n",
" <td>-0.4066</td>\n",
" <td>-0.105377</td>\n",
" <td>0.000961</td>\n",
" <td>12.238693</td>\n",
" <td>34.727722</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470589</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8376</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.4014</td>\n",
" <td>-0.101120</td>\n",
" <td>-0.006729</td>\n",
" <td>12.239456</td>\n",
" <td>34.740021</td>\n",
" <td>2.024841</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470590</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8396</td>\n",
" <td>-0.0302</td>\n",
" <td>-0.3942</td>\n",
" <td>-0.097366</td>\n",
" <td>-0.005447</td>\n",
" <td>12.240219</td>\n",
" <td>34.727722</td>\n",
" <td>2.032471</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470591</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8390</td>\n",
" <td>-0.0294</td>\n",
" <td>-0.3864</td>\n",
" <td>-0.092834</td>\n",
" <td>-0.005081</td>\n",
" <td>12.234879</td>\n",
" <td>34.740021</td>\n",
" <td>2.027893</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470592</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8398</td>\n",
" <td>-0.0290</td>\n",
" <td>-0.3806</td>\n",
" <td>-0.088943</td>\n",
" <td>-0.005173</td>\n",
" <td>12.239075</td>\n",
" <td>34.710846</td>\n",
" <td>2.040100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470593</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8382</td>\n",
" <td>-0.0302</td>\n",
" <td>-0.3766</td>\n",
" <td>-0.087753</td>\n",
" <td>-0.002792</td>\n",
" <td>12.239456</td>\n",
" <td>34.727722</td>\n",
" <td>2.037048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470594</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8414</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.3720</td>\n",
" <td>-0.088760</td>\n",
" <td>-0.006638</td>\n",
" <td>12.239456</td>\n",
" <td>34.723114</td>\n",
" <td>2.041626</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470595</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8440</td>\n",
" <td>-0.0330</td>\n",
" <td>-0.3710</td>\n",
" <td>-0.085098</td>\n",
" <td>0.008514</td>\n",
" <td>12.239456</td>\n",
" <td>34.712341</td>\n",
" <td>1.889038</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470596</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8452</td>\n",
" <td>-0.0322</td>\n",
" <td>-0.3674</td>\n",
" <td>-0.082809</td>\n",
" <td>0.006775</td>\n",
" <td>12.237930</td>\n",
" <td>34.663177</td>\n",
" <td>2.073669</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470597</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0328</td>\n",
" <td>-0.3608</td>\n",
" <td>-0.079971</td>\n",
" <td>0.000778</td>\n",
" <td>12.240219</td>\n",
" <td>34.732361</td>\n",
" <td>2.082825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470598</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8442</td>\n",
" <td>-0.0344</td>\n",
" <td>-0.3638</td>\n",
" <td>-0.076309</td>\n",
" <td>-0.001511</td>\n",
" <td>12.240219</td>\n",
" <td>34.724670</td>\n",
" <td>2.073669</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470599</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8434</td>\n",
" <td>-0.0330</td>\n",
" <td>-0.3634</td>\n",
" <td>-0.074844</td>\n",
" <td>-0.006271</td>\n",
" <td>12.240219</td>\n",
" <td>34.716980</td>\n",
" <td>2.082825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470600</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8462</td>\n",
" <td>-0.0348</td>\n",
" <td>-0.3650</td>\n",
" <td>-0.073013</td>\n",
" <td>-0.006638</td>\n",
" <td>12.233353</td>\n",
" <td>34.715424</td>\n",
" <td>2.079773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470601</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8446</td>\n",
" <td>-0.0360</td>\n",
" <td>-0.3652</td>\n",
" <td>-0.071136</td>\n",
" <td>-0.001694</td>\n",
" <td>12.239075</td>\n",
" <td>34.724670</td>\n",
" <td>2.079773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31470602</th>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>0.8472</td>\n",
" <td>-0.0358</td>\n",
" <td>-0.3654</td>\n",
" <td>-0.067154</td>\n",
" <td>0.000778</td>\n",
" <td>12.236786</td>\n",
" <td>34.726166</td>\n",
" <td>2.076721</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>31470603 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" target subject chest_ACC_x chest_ACC_y chest_ACC_z chest_ECG \\\n",
"0 1 6 0.6280 -0.0082 -0.7272 0.016937 \n",
"1 1 6 0.6276 -0.0056 -0.7262 0.017853 \n",
"2 1 6 0.6270 -0.0054 -0.7200 0.016525 \n",
"3 1 6 0.6266 -0.0070 -0.7174 0.012863 \n",
"4 1 6 0.6242 -0.0078 -0.7202 0.007278 \n",
"... ... ... ... ... ... ... \n",
"31470598 4 7 0.8442 -0.0344 -0.3638 -0.076309 \n",
"31470599 4 7 0.8434 -0.0330 -0.3634 -0.074844 \n",
"31470600 4 7 0.8462 -0.0348 -0.3650 -0.073013 \n",
"31470601 4 7 0.8446 -0.0360 -0.3652 -0.071136 \n",
"31470602 4 7 0.8472 -0.0358 -0.3654 -0.067154 \n",
"\n",
" chest_EMG chest_EDA chest_Temp chest_Resp \n",
"0 0.134720 9.645462 33.432587 4.010010 \n",
"1 0.216248 9.645462 33.459747 4.039001 \n",
"2 0.142136 9.646606 33.452240 3.993225 \n",
"3 0.033371 9.646225 33.453735 4.002380 \n",
"4 -0.024994 9.646988 33.426544 3.996277 \n",
"... ... ... ... ... \n",
"31470598 -0.001511 12.240219 34.724670 2.073669 \n",
"31470599 -0.006271 12.240219 34.716980 2.082825 \n",
"31470600 -0.006638 12.233353 34.715424 2.079773 \n",
"31470601 -0.001694 12.239075 34.724670 2.079773 \n",
"31470602 0.000778 12.236786 34.726166 2.076721 \n",
"\n",
"[31470603 rows x 10 columns]"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([1, 2, 4, 3])"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['target'].unique()"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"df.to_csv(\"master_data.csv\",index=False)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"df"
]
},
{
"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.6.8"
}
},
"nbformat": 4,
"nbformat_minor": 2
}