Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "65f25a2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ade20431",
   "metadata": {},
   "source": [
    "## Импорт данных полиграфа"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9dc8f215",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 21658 entries, 0 to 21657\n",
      "Data columns (total 4 columns):\n",
      " #   Column         Non-Null Count  Dtype         \n",
      "---  ------         --------------  -----         \n",
      " 0   Time           21658 non-null  datetime64[ns]\n",
      " 1   Value          21658 non-null  int64         \n",
      " 2   Amplification  21658 non-null  int64         \n",
      " 3   Displacement   21658 non-null  int64         \n",
      "dtypes: datetime64[ns](1), int64(3)\n",
      "memory usage: 676.9 KB\n"
     ]
    }
   ],
   "source": [
    "bd_vl = pd.read_table('Цифры_BLOOD_VOLUME.txt',sep='\\s+')\n",
    "bd_vl['Time'] = bd_vl['Time'].apply(lambda x: datetime.datetime.utcfromtimestamp(x//1000).replace(microsecond=x%1000*1000))\n",
    "bd_vl.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "913f6400",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        00:00:00.009000\n",
       "1        00:00:00.040000\n",
       "2        00:00:00.072000\n",
       "3        00:00:00.104000\n",
       "4        00:00:00.137000\n",
       "              ...       \n",
       "21653    00:11:36.514000\n",
       "21654    00:11:36.545000\n",
       "21655    00:11:36.578000\n",
       "21656    00:11:36.610000\n",
       "21657    00:11:36.641000\n",
       "Name: Time, Length: 21658, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bd_vl['Time'].dt.time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "c31730c3",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0               00:00:00\n",
       "1        00:00:00.040000\n",
       "2        00:00:00.080000\n",
       "3        00:00:00.120000\n",
       "4        00:00:00.160000\n",
       "              ...       \n",
       "15286    00:10:11.440000\n",
       "15287    00:10:11.480000\n",
       "15288    00:10:11.520000\n",
       "15289    00:10:11.559000\n",
       "15290    00:10:11.600000\n",
       "Name: Video Time, Length: 15291, dtype: object"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#emotions['Video Time'] = pd.to_datetime(emotions['Video Time'])\n",
    "#pd.to_datetime(emotions['Video Time']).dt.time"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "55a39f6d",
   "metadata": {},
   "source": [
    "## Импорт FaceReader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9597a419",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3165: DtypeWarning: Columns (68,69) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    }
   ],
   "source": [
    "cols = ['Neutral', 'Happy', 'Sad', 'Angry', 'Surprised', 'Scared',\n",
    "       'Disgusted', 'Contempt', 'Valence', 'Arousal', 'Y - Head Orientation', \n",
    "        'X - Head Orientation','Z - Head Orientation', 'Quality']\n",
    "#conv = dict.fromkeys(cols, lambda x: pd.to_numeric(x, errors='coerce'))\n",
    "na = [\"FIND_FAILED\", \"FIT_FAILED\"]\n",
    "emotions = pd.read_table('Participant 4_Метелева Ольга_Цифры.txt', sep='\\t', skiprows=8, index_col=False, parse_dates = ['Video Time'], na_values = na)\n",
    "#converters= conv\n",
    "emotions[cols] = emotions[cols].apply(pd.to_numeric,errors='coerce').fillna(emotions)\n",
    "for i in range(26, 68):\n",
    "    emotions.iloc[:,i] = pd.to_numeric(emotions.iloc[:,i], errors='coerce').fillna(0, downcast='infer')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "afe23de7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 15291 entries, 0 to 15290\n",
      "Data columns (total 75 columns):\n",
      " #   Column                                         Non-Null Count  Dtype         \n",
      "---  ------                                         --------------  -----         \n",
      " 0   Video Time                                     15291 non-null  datetime64[ns]\n",
      " 1   Neutral                                        15187 non-null  float64       \n",
      " 2   Happy                                          15187 non-null  float64       \n",
      " 3   Sad                                            15187 non-null  float64       \n",
      " 4   Angry                                          15187 non-null  float64       \n",
      " 5   Surprised                                      15187 non-null  float64       \n",
      " 6   Scared                                         15187 non-null  float64       \n",
      " 7   Disgusted                                      15187 non-null  float64       \n",
      " 8   Contempt                                       15187 non-null  float64       \n",
      " 9   Valence                                        15187 non-null  float64       \n",
      " 10  Arousal                                        15187 non-null  float64       \n",
      " 11  Gender                                         15187 non-null  object        \n",
      " 12  Age                                            15187 non-null  object        \n",
      " 13  Beard                                          15187 non-null  object        \n",
      " 14  Moustache                                      15187 non-null  object        \n",
      " 15  Glasses                                        15187 non-null  object        \n",
      " 16  Y - Head Orientation                           15180 non-null  float64       \n",
      " 17  X - Head Orientation                           15180 non-null  float64       \n",
      " 18  Z - Head Orientation                           15180 non-null  float64       \n",
      " 19  Quality                                        15187 non-null  float64       \n",
      " 20  Mouth                                          15180 non-null  object        \n",
      " 21  Left Eye                                       15180 non-null  object        \n",
      " 22  Right Eye                                      15180 non-null  object        \n",
      " 23  Left Eyebrow                                   15180 non-null  object        \n",
      " 24  Right Eyebrow                                  15180 non-null  object        \n",
      " 25  Gaze Direction                                 15187 non-null  object        \n",
      " 26  Action Unit 01 - Inner Brow Raiser             15291 non-null  float64       \n",
      " 27  Action Unit 02 - Outer Brow Raiser             15291 non-null  int64         \n",
      " 28  Action Unit 04 - Brow Lowerer                  15291 non-null  float64       \n",
      " 29  Action Unit 05 - Upper Lid Raiser              15291 non-null  float64       \n",
      " 30  Action Unit 06 - Cheek Raiser                  15291 non-null  float64       \n",
      " 31  Action Unit 07 - Lid Tightener                 15291 non-null  float64       \n",
      " 32  Action Unit 09 - Nose Wrinkler                 15291 non-null  int64         \n",
      " 33  Action Unit 10 - Upper Lip Raiser              15291 non-null  float64       \n",
      " 34  Action Unit 12 - Lip Corner Puller             15291 non-null  float64       \n",
      " 35  Action Unit 14 - Dimpler                       15291 non-null  int64         \n",
      " 36  Action Unit 15 - Lip Corner Depressor          15291 non-null  float64       \n",
      " 37  Action Unit 17 - Chin Raiser                   15291 non-null  float64       \n",
      " 38  Action Unit 18 - Lip Pucker                    15291 non-null  float64       \n",
      " 39  Action Unit 20 - Lip Stretcher                 15291 non-null  int64         \n",
      " 40  Action Unit 23 - Lip Tightener                 15291 non-null  int64         \n",
      " 41  Action Unit 24 - Lip Pressor                   15291 non-null  float64       \n",
      " 42  Action Unit 25 - Lips Part                     15291 non-null  float64       \n",
      " 43  Action Unit 26 - Jaw Drop                      15291 non-null  float64       \n",
      " 44  Action Unit 27 - Mouth Stretch                 15291 non-null  int64         \n",
      " 45  Action Unit 43 - Eyes Closed                   15291 non-null  float64       \n",
      " 46  Action Unit 01 - Left - Inner Brow Raiser      15291 non-null  float64       \n",
      " 47  Action Unit 02 - Left - Outer Brow Raiser      15291 non-null  int64         \n",
      " 48  Action Unit 04 - Left - Brow Lowerer           15291 non-null  float64       \n",
      " 49  Action Unit 05 - Left - Upper Lid Raiser       15291 non-null  int64         \n",
      " 50  Action Unit 06 - Left - Cheek Raiser           15291 non-null  float64       \n",
      " 51  Action Unit 07 - Left - Lid Tightener          15291 non-null  float64       \n",
      " 52  Action Unit 12 - Left - Lip Corner Puller      15291 non-null  float64       \n",
      " 53  Action Unit 14 - Left - Dimpler                15291 non-null  int64         \n",
      " 54  Action Unit 15 - Left - Lip Corner Depressor   15291 non-null  float64       \n",
      " 55  Action Unit 20 - Left - Lip Stretcher          15291 non-null  int64         \n",
      " 56  Action Unit 43 - Left - Eyes Closed            15291 non-null  float64       \n",
      " 57  Action Unit 01 - Right - Inner Brow Raiser     15291 non-null  float64       \n",
      " 58  Action Unit 02 - Right - Outer Brow Raiser     15291 non-null  int64         \n",
      " 59  Action Unit 04 - Right - Brow Lowerer          15291 non-null  float64       \n",
      " 60  Action Unit 05 - Right - Upper Lid Raiser      15291 non-null  float64       \n",
      " 61  Action Unit 06 - Right - Cheek Raiser          15291 non-null  float64       \n",
      " 62  Action Unit 07 - Right - Lid Tightener         15291 non-null  float64       \n",
      " 63  Action Unit 12 - Right - Lip Corner Puller     15291 non-null  float64       \n",
      " 64  Action Unit 14 - Right - Dimpler               15291 non-null  int64         \n",
      " 65  Action Unit 15 - Right - Lip Corner Depressor  15291 non-null  int64         \n",
      " 66  Action Unit 20 - Right - Lip Stretcher         15291 non-null  int64         \n",
      " 67  Action Unit 43 - Right - Eyes Closed           15291 non-null  float64       \n",
      " 68  Heart Rate                                     15180 non-null  object        \n",
      " 69  Heart Rate Variability                         15180 non-null  object        \n",
      " 70  Heart Rate Warnings                            15180 non-null  object        \n",
      " 71  Stimulus                                       15291 non-null  object        \n",
      " 72  Event Marker                                   15291 non-null  object        \n",
      " 73  Participant Name                               0 non-null      float64       \n",
      " 74  Analysis Index                                 15291 non-null  object        \n",
      "dtypes: datetime64[ns](1), float64(43), int64(14), object(17)\n",
      "memory usage: 8.7+ MB\n"
     ]
    }
   ],
   "source": [
    "emotions.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5bf78ed0",
   "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>Video Time</th>\n",
       "      <th>Neutral</th>\n",
       "      <th>Happy</th>\n",
       "      <th>Sad</th>\n",
       "      <th>Angry</th>\n",
       "      <th>Surprised</th>\n",
       "      <th>Scared</th>\n",
       "      <th>Disgusted</th>\n",
       "      <th>Contempt</th>\n",
       "      <th>Valence</th>\n",
       "      <th>...</th>\n",
       "      <th>Action Unit 15 - Right - Lip Corner Depressor</th>\n",
       "      <th>Action Unit 20 - Right - Lip Stretcher</th>\n",
       "      <th>Action Unit 43 - Right - Eyes Closed</th>\n",
       "      <th>Heart Rate</th>\n",
       "      <th>Heart Rate Variability</th>\n",
       "      <th>Heart Rate Warnings</th>\n",
       "      <th>Stimulus</th>\n",
       "      <th>Event Marker</th>\n",
       "      <th>Participant Name</th>\n",
       "      <th>Analysis Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5360</th>\n",
       "      <td>2023-02-04 00:03:34.400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5361</th>\n",
       "      <td>2023-02-04 00:03:34.440</td>\n",
       "      <td>0.430536</td>\n",
       "      <td>0.284837</td>\n",
       "      <td>0.294160</td>\n",
       "      <td>0.012297</td>\n",
       "      <td>0.008904</td>\n",
       "      <td>0.000188</td>\n",
       "      <td>0.032923</td>\n",
       "      <td>0.020342</td>\n",
       "      <td>-0.009323</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5362</th>\n",
       "      <td>2023-02-04 00:03:34.480</td>\n",
       "      <td>0.418693</td>\n",
       "      <td>0.301311</td>\n",
       "      <td>0.311672</td>\n",
       "      <td>0.010908</td>\n",
       "      <td>0.009080</td>\n",
       "      <td>0.000167</td>\n",
       "      <td>0.035673</td>\n",
       "      <td>0.018983</td>\n",
       "      <td>-0.010361</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5363</th>\n",
       "      <td>2023-02-04 00:03:34.520</td>\n",
       "      <td>0.408420</td>\n",
       "      <td>0.315913</td>\n",
       "      <td>0.324942</td>\n",
       "      <td>0.009676</td>\n",
       "      <td>0.009383</td>\n",
       "      <td>0.000148</td>\n",
       "      <td>0.038597</td>\n",
       "      <td>0.018380</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5364</th>\n",
       "      <td>2023-02-04 00:03:34.560</td>\n",
       "      <td>0.398313</td>\n",
       "      <td>0.327186</td>\n",
       "      <td>0.337465</td>\n",
       "      <td>0.008583</td>\n",
       "      <td>0.009520</td>\n",
       "      <td>0.000131</td>\n",
       "      <td>0.041162</td>\n",
       "      <td>0.017163</td>\n",
       "      <td>-0.010278</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15286</th>\n",
       "      <td>2023-02-04 00:10:11.440</td>\n",
       "      <td>0.494769</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.185496</td>\n",
       "      <td>0.137891</td>\n",
       "      <td>0.000679</td>\n",
       "      <td>0.008787</td>\n",
       "      <td>0.012756</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>-0.185496</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56</td>\n",
       "      <td>93</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15287</th>\n",
       "      <td>2023-02-04 00:10:11.480</td>\n",
       "      <td>0.494396</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.180969</td>\n",
       "      <td>0.143234</td>\n",
       "      <td>0.000667</td>\n",
       "      <td>0.008413</td>\n",
       "      <td>0.012845</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>-0.180969</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>93</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15288</th>\n",
       "      <td>2023-02-04 00:10:11.520</td>\n",
       "      <td>0.495532</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.176113</td>\n",
       "      <td>0.146723</td>\n",
       "      <td>0.000674</td>\n",
       "      <td>0.008025</td>\n",
       "      <td>0.012896</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>-0.176113</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>93</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15289</th>\n",
       "      <td>2023-02-04 00:10:11.559</td>\n",
       "      <td>0.496959</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.170198</td>\n",
       "      <td>0.150339</td>\n",
       "      <td>0.000650</td>\n",
       "      <td>0.007572</td>\n",
       "      <td>0.012893</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>-0.170198</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>93</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15290</th>\n",
       "      <td>2023-02-04 00:10:11.600</td>\n",
       "      <td>0.498157</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.165575</td>\n",
       "      <td>0.153036</td>\n",
       "      <td>0.000612</td>\n",
       "      <td>0.007140</td>\n",
       "      <td>0.013087</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>-0.165575</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>55</td>\n",
       "      <td>93</td>\n",
       "      <td>Frame rate, bitrate, resolution ratio too low</td>\n",
       "      <td>No Stimulus</td>\n",
       "      <td>No Event Marker</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Метелева Ольга</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9931 rows × 75 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Video Time   Neutral     Happy       Sad     Angry  \\\n",
       "5360  2023-02-04 00:03:34.400       NaN       NaN       NaN       NaN   \n",
       "5361  2023-02-04 00:03:34.440  0.430536  0.284837  0.294160  0.012297   \n",
       "5362  2023-02-04 00:03:34.480  0.418693  0.301311  0.311672  0.010908   \n",
       "5363  2023-02-04 00:03:34.520  0.408420  0.315913  0.324942  0.009676   \n",
       "5364  2023-02-04 00:03:34.560  0.398313  0.327186  0.337465  0.008583   \n",
       "...                       ...       ...       ...       ...       ...   \n",
       "15286 2023-02-04 00:10:11.440  0.494769  0.000000  0.185496  0.137891   \n",
       "15287 2023-02-04 00:10:11.480  0.494396  0.000000  0.180969  0.143234   \n",
       "15288 2023-02-04 00:10:11.520  0.495532  0.000000  0.176113  0.146723   \n",
       "15289 2023-02-04 00:10:11.559  0.496959  0.000000  0.170198  0.150339   \n",
       "15290 2023-02-04 00:10:11.600  0.498157  0.000000  0.165575  0.153036   \n",
       "\n",
       "       Surprised    Scared  Disgusted  Contempt   Valence  ...  \\\n",
       "5360         NaN       NaN        NaN       NaN       NaN  ...   \n",
       "5361    0.008904  0.000188   0.032923  0.020342 -0.009323  ...   \n",
       "5362    0.009080  0.000167   0.035673  0.018983 -0.010361  ...   \n",
       "5363    0.009383  0.000148   0.038597  0.018380 -0.009029  ...   \n",
       "5364    0.009520  0.000131   0.041162  0.017163 -0.010278  ...   \n",
       "...          ...       ...        ...       ...       ...  ...   \n",
       "15286   0.000679  0.008787   0.012756  0.000003 -0.185496  ...   \n",
       "15287   0.000667  0.008413   0.012845  0.000003 -0.180969  ...   \n",
       "15288   0.000674  0.008025   0.012896  0.000002 -0.176113  ...   \n",
       "15289   0.000650  0.007572   0.012893  0.000002 -0.170198  ...   \n",
       "15290   0.000612  0.007140   0.013087  0.000002 -0.165575  ...   \n",
       "\n",
       "       Action Unit 15 - Right - Lip Corner Depressor  \\\n",
       "5360                                               0   \n",
       "5361                                               0   \n",
       "5362                                               0   \n",
       "5363                                               0   \n",
       "5364                                               0   \n",
       "...                                              ...   \n",
       "15286                                              0   \n",
       "15287                                              0   \n",
       "15288                                              0   \n",
       "15289                                              0   \n",
       "15290                                              0   \n",
       "\n",
       "      Action Unit 20 - Right - Lip Stretcher  \\\n",
       "5360                                       0   \n",
       "5361                                       0   \n",
       "5362                                       0   \n",
       "5363                                       0   \n",
       "5364                                       0   \n",
       "...                                      ...   \n",
       "15286                                      0   \n",
       "15287                                      0   \n",
       "15288                                      0   \n",
       "15289                                      0   \n",
       "15290                                      0   \n",
       "\n",
       "      Action Unit 43 - Right - Eyes Closed Heart Rate Heart Rate Variability  \\\n",
       "5360                                   0.0        NaN                    NaN   \n",
       "5361                                   0.0         55                Unknown   \n",
       "5362                                   0.0         55                Unknown   \n",
       "5363                                   0.0         54                Unknown   \n",
       "5364                                   0.0         54                Unknown   \n",
       "...                                    ...        ...                    ...   \n",
       "15286                                  0.0         56                     93   \n",
       "15287                                  0.0         55                     93   \n",
       "15288                                  0.0         55                     93   \n",
       "15289                                  0.0         55                     93   \n",
       "15290                                  0.0         55                     93   \n",
       "\n",
       "                                 Heart Rate Warnings     Stimulus  \\\n",
       "5360                                             NaN  No Stimulus   \n",
       "5361   Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "5362   Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "5363   Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "5364   Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "...                                              ...          ...   \n",
       "15286  Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "15287  Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "15288  Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "15289  Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "15290  Frame rate, bitrate, resolution ratio too low  No Stimulus   \n",
       "\n",
       "          Event Marker  Participant Name  Analysis Index  \n",
       "5360   No Event Marker               NaN  Метелева Ольга  \n",
       "5361   No Event Marker               NaN  Метелева Ольга  \n",
       "5362   No Event Marker               NaN  Метелева Ольга  \n",
       "5363   No Event Marker               NaN  Метелева Ольга  \n",
       "5364   No Event Marker               NaN  Метелева Ольга  \n",
       "...                ...               ...             ...  \n",
       "15286  No Event Marker               NaN  Метелева Ольга  \n",
       "15287  No Event Marker               NaN  Метелева Ольга  \n",
       "15288  No Event Marker               NaN  Метелева Ольга  \n",
       "15289  No Event Marker               NaN  Метелева Ольга  \n",
       "15290  No Event Marker               NaN  Метелева Ольга  \n",
       "\n",
       "[9931 rows x 75 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emotions.iloc[5360:] #проверка значений NaN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f6e5b841",
   "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>Video Time</th>\n",
       "      <th>Neutral</th>\n",
       "      <th>Happy</th>\n",
       "      <th>Sad</th>\n",
       "      <th>Angry</th>\n",
       "      <th>Surprised</th>\n",
       "      <th>Scared</th>\n",
       "      <th>Disgusted</th>\n",
       "      <th>Contempt</th>\n",
       "      <th>Valence</th>\n",
       "      <th>...</th>\n",
       "      <th>Heart Rate Variability</th>\n",
       "      <th>Heart Rate Warnings</th>\n",
       "      <th>Stimulus</th>\n",
       "      <th>Event Marker</th>\n",
       "      <th>Participant Name</th>\n",
       "      <th>Analysis Index</th>\n",
       "      <th>Time</th>\n",
       "      <th>Value</th>\n",
       "      <th>Amplification</th>\n",
       "      <th>Displacement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 79 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Video Time, Neutral, Happy, Sad, Angry, Surprised, Scared, Disgusted, Contempt, Valence, Arousal, Gender, Age, Beard, Moustache, Glasses, Y - Head Orientation, X - Head Orientation, Z - Head Orientation, Quality, Mouth, Left Eye, Right Eye, Left Eyebrow, Right Eyebrow, Gaze Direction, Action Unit 01 - Inner Brow Raiser, Action Unit 02 - Outer Brow Raiser, Action Unit 04 - Brow Lowerer, Action Unit 05 - Upper Lid Raiser, Action Unit 06 - Cheek Raiser, Action Unit 07 - Lid Tightener, Action Unit 09 - Nose Wrinkler, Action Unit 10 - Upper Lip Raiser, Action Unit 12 - Lip Corner Puller, Action Unit 14 - Dimpler, Action Unit 15 - Lip Corner Depressor, Action Unit 17 - Chin Raiser, Action Unit 18 - Lip Pucker, Action Unit 20 - Lip Stretcher, Action Unit 23 - Lip Tightener, Action Unit 24 - Lip Pressor, Action Unit 25 - Lips Part, Action Unit 26 - Jaw Drop, Action Unit 27 - Mouth Stretch, Action Unit 43 - Eyes Closed, Action Unit 01 - Left - Inner Brow Raiser, Action Unit 02 - Left - Outer Brow Raiser, Action Unit 04 - Left - Brow Lowerer, Action Unit 05 - Left - Upper Lid Raiser, Action Unit 06 - Left - Cheek Raiser, Action Unit 07 - Left - Lid Tightener, Action Unit 12 - Left - Lip Corner Puller, Action Unit 14 - Left - Dimpler, Action Unit 15 - Left - Lip Corner Depressor, Action Unit 20 - Left - Lip Stretcher, Action Unit 43 - Left - Eyes Closed, Action Unit 01 - Right - Inner Brow Raiser, Action Unit 02 - Right - Outer Brow Raiser, Action Unit 04 - Right - Brow Lowerer, Action Unit 05 - Right - Upper Lid Raiser, Action Unit 06 - Right - Cheek Raiser, Action Unit 07 - Right - Lid Tightener, Action Unit 12 - Right - Lip Corner Puller, Action Unit 14 - Right - Dimpler, Action Unit 15 - Right - Lip Corner Depressor, Action Unit 20 - Right - Lip Stretcher, Action Unit 43 - Right - Eyes Closed, Heart Rate, Heart Rate Variability, Heart Rate Warnings, Stimulus, Event Marker, Participant Name, Analysis Index, Time, Value, Amplification, Displacement]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 79 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(columns= list(emotions.columns) + list(bd_vl.columns))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "02b6ec10",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "696641.0\n"
     ]
    }
   ],
   "source": [
    "end_time = 0 #в миллисекундах\n",
    "if (bd_vl['Time'].iloc[-1].time() > emotions['Video Time'].iloc[-1].time()):\n",
    "    end_time = bd_vl['Time'][len(bd_vl)-1].timestamp() * 1000\n",
    "else:\n",
    "    end_time = emotions['Video Time'][len(emotions)-1].timestamp() * 1000\n",
    "\n",
    "print (end_time)\n",
    "\n",
    "i = 0 #start_time\n",
    "while i < int(end_time):\n",
    "    i += 50\n",
    "    print i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "66352ef6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "40.0"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7cd90e87",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}