data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "dialogs_2_data = pd.read_csv(\"data/DATA/dialogs_2.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>appeal_id</th>\n",
       "      <th>datetime</th>\n",
       "      <th>client_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>msg_type</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_name</th>\n",
       "      <th>channel_type</th>\n",
       "      <th>answer_time</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>323874</td>\n",
       "      <td>2088-08-08 16:44:02+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19670.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Привет.))</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>323870</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19671.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Все подписки отключены. Как это делать самосто...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>323861</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19418.0</td>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "      <td>Нижний Новгород B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Вы забыли пароль и хотите войти в кабинет?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>323850</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19578.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Можем отправить заявку на подключение новых но...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>323867</td>\n",
       "      <td>2088-08-08 16:43:58+03</td>\n",
       "      <td>569008.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>177</td>\n",
       "      <td>Омск B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Тогда проще перейти с номером в мегафон Включа...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   appeal_id                datetime  client_id  user_id  msg_type  \\\n",
       "0     323874  2088-08-08 16:44:02+03        NaN  19670.0         0   \n",
       "1     323870  2088-08-08 16:44:01+03        NaN  19671.0         0   \n",
       "2     323861  2088-08-08 16:44:01+03        NaN  19418.0         0   \n",
       "3     323850  2088-08-08 16:44:01+03        NaN  19578.0         0   \n",
       "5     323867  2088-08-08 16:43:58+03   569008.0     -1.0         0   \n",
       "\n",
       "   channel_id         channel_name channel_type  answer_time  \\\n",
       "0          73            Webdealer      Веб-чат         12.0   \n",
       "1          73            Webdealer      Веб-чат          NaN   \n",
       "2         133  Нижний Новгород B2C      Веб-чат          NaN   \n",
       "3           2                Viber        Viber         54.0   \n",
       "5         177             Омск B2C      Веб-чат          NaN   \n",
       "\n",
       "                                                text  \n",
       "0                                          Привет.))  \n",
       "1  Все подписки отключены. Как это делать самосто...  \n",
       "2         Вы забыли пароль и хотите войти в кабинет?  \n",
       "3  Можем отправить заявку на подключение новых но...  \n",
       "5  Тогда проще перейти с номером в мегафон Включа...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dialogs_2_data = dialogs_2_data.dropna(subset=['client_id','user_id'], how='all')\n",
    "dialogs_2_data['user_id'] = dialogs_2_data['user_id'].fillna(-1)\n",
    "dialogs_2_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   appeal_id                datetime  client_id  user_id  msg_type  \\\n",
      "0     323874  2088-08-08 16:44:02+03        NaN  19670.0         0   \n",
      "1     323870  2088-08-08 16:44:01+03        NaN  19671.0         0   \n",
      "2     323861  2088-08-08 16:44:01+03        NaN  19418.0         0   \n",
      "3     323850  2088-08-08 16:44:01+03        NaN  19578.0         0   \n",
      "5     323867  2088-08-08 16:43:58+03   569008.0     -1.0         0   \n",
      "\n",
      "   channel_id         channel_name channel_type  answer_time  \\\n",
      "0          73            Webdealer      Веб-чат         12.0   \n",
      "1          73            Webdealer      Веб-чат          NaN   \n",
      "2         133  Нижний Новгород B2C      Веб-чат          NaN   \n",
      "3           2                Viber        Viber         54.0   \n",
      "5         177             Омск B2C      Веб-чат          NaN   \n",
      "\n",
      "                                                text                  dt  \n",
      "0                                          Привет.)) 2088-08-08 16:44:02  \n",
      "1  Все подписки отключены. Как это делать самосто... 2088-08-08 16:44:01  \n",
      "2         Вы забыли пароль и хотите войти в кабинет? 2088-08-08 16:44:01  \n",
      "3  Можем отправить заявку на подключение новых но... 2088-08-08 16:44:01  \n",
      "5  Тогда проще перейти с номером в мегафон Включа... 2088-08-08 16:43:58  \n"
     ]
    }
   ],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "def parseDatetime(dt_str):\n",
    "    y = int(dt_str[0:4])\n",
    "    m = int(dt_str[5:7])\n",
    "    d = int(dt_str[8:10])\n",
    "    \n",
    "    H = int(dt_str[11:13])\n",
    "    M = int(dt_str[14:16])\n",
    "    S = int(dt_str[17:19])\n",
    "    dt = datetime(y, m, d, H, M, S)\n",
    "    return dt\n",
    "\n",
    "dialogs_2_data[\"dt\"] = dialogs_2_data[\"datetime\"].apply(lambda x: parseDatetime(x))\n",
    "print(dialogs_2_data.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n",
    "def userAnswerTime(data):\n",
    "    data = data.sort_values(by=['datetime'])\n",
    "    delta = [0]\n",
    "    values = data['dt'].get_values()\n",
    "    for i in range(0,len(data)-1):\n",
    "        val = (values[i+1] - values[i])/np.timedelta64(1, 's')\n",
    "        if (val < 60*10):\n",
    "            delta.append(val)\n",
    "        else:\n",
    "            delta.append(0)\n",
    "    data['user_answer_time'] = delta\n",
    "    return data\n",
    "\n",
    "group = dialogs_2_data.groupby(\"user_id\")\n",
    "group = group.apply(userAnswerTime)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>user_id</th>\n",
       "      <th>level_1</th>\n",
       "      <th>appeal_id</th>\n",
       "      <th>datetime</th>\n",
       "      <th>client_id</th>\n",
       "      <th>msg_type</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_name</th>\n",
       "      <th>channel_type</th>\n",
       "      <th>answer_time</th>\n",
       "      <th>text</th>\n",
       "      <th>dt</th>\n",
       "      <th>user_answer_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778572</td>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:00:21+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По чьей инициативе мне была подключена данная ...</td>\n",
       "      <td>2088-04-01 00:00:21</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778570</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:40+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Да понятно</td>\n",
       "      <td>2088-04-01 00:00:40</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778571</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:47+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Блин</td>\n",
       "      <td>2088-04-01 00:00:47</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778564</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:59+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ну это вообще дурдом</td>\n",
       "      <td>2088-04-01 00:00:59</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778565</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:06+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>На какой х... Мне платить абонент плату</td>\n",
       "      <td>2088-04-01 00:01:06</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778566</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:14+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Если связь дерьмо</td>\n",
       "      <td>2088-04-01 00:01:14</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778567</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:26+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Как у вас в рекламе говорят</td>\n",
       "      <td>2088-04-01 00:01:26</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778562</td>\n",
       "      <td>112427</td>\n",
       "      <td>2088-04-01 00:01:41+03</td>\n",
       "      <td>423552.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Плохо работа</td>\n",
       "      <td>2088-04-01 00:01:41</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778569</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:43+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Если у вас не ловит 4г мы отдадим вам деньги</td>\n",
       "      <td>2088-04-01 00:01:43</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778568</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:46+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Отдавайте</td>\n",
       "      <td>2088-04-01 00:01:46</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778560</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:02:47+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ну так что молчите</td>\n",
       "      <td>2088-04-01 00:02:47</td>\n",
       "      <td>61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778561</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:02:53+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Будет какой то результат</td>\n",
       "      <td>2088-04-01 00:02:53</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778559</td>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:03:00+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Чья инициатива была ее мне предоставить?!-имен...</td>\n",
       "      <td>2088-04-01 00:03:00</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778551</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:37+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;img class='emoji codexxxxx' draggable='false'...</td>\n",
       "      <td>2088-04-01 00:04:37</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778550</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:43+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088-04-01 00:04:43</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778553</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:52+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Сейчас поставлю</td>\n",
       "      <td>2088-04-01 00:04:52</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778549</td>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:04:57+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По чьей инициативе мне была подключена данная ...</td>\n",
       "      <td>2088-04-01 00:04:57</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778552</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:57+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>И посмотрим</td>\n",
       "      <td>2088-04-01 00:04:57</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778548</td>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:05:20+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По моей или оператора?</td>\n",
       "      <td>2088-04-01 00:05:20</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778544</td>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:05:56+03</td>\n",
       "      <td>441537.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Я готова(wink2)</td>\n",
       "      <td>2088-04-01 00:05:56</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778540</td>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:06:25+03</td>\n",
       "      <td>441537.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Жду</td>\n",
       "      <td>2088-04-01 00:06:25</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778538</td>\n",
       "      <td>112433</td>\n",
       "      <td>2088-04-01 00:06:41+03</td>\n",
       "      <td>399223.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Интернет на телефоне работает,а звонки не прох...</td>\n",
       "      <td>2088-04-01 00:06:41</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778535</td>\n",
       "      <td>112433</td>\n",
       "      <td>2088-04-01 00:07:29+03</td>\n",
       "      <td>399223.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>xxx xxx xx xx</td>\n",
       "      <td>2088-04-01 00:07:29</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778534</td>\n",
       "      <td>112427</td>\n",
       "      <td>2088-04-01 00:07:37+03</td>\n",
       "      <td>423552.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Где ответ</td>\n",
       "      <td>2088-04-01 00:07:37</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778533</td>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:07:44+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Платежная система в договорных отношениях межд...</td>\n",
       "      <td>2088-04-01 00:07:44</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778532</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:07:46+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ваш бот фото открывает</td>\n",
       "      <td>2088-04-01 00:07:46</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778531</td>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:07:49+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>?</td>\n",
       "      <td>2088-04-01 00:07:49</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778528</td>\n",
       "      <td>112434</td>\n",
       "      <td>2088-04-01 00:08:01+03</td>\n",
       "      <td>441538.0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>Воронеж</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Добрый вечер. Что происходит с трафиком? Почем...</td>\n",
       "      <td>2088-04-01 00:08:01</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778522</td>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:08:24+03</td>\n",
       "      <td>441537.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Xiaomi Redmi 4a</td>\n",
       "      <td>2088-04-01 00:08:24</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>3778521</td>\n",
       "      <td>112434</td>\n",
       "      <td>2088-04-01 00:08:31+03</td>\n",
       "      <td>441538.0</td>\n",
       "      <td>0</td>\n",
       "      <td>71</td>\n",
       "      <td>Воронеж</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Добрый вечер. Что происходит с трафиком? Почем...</td>\n",
       "      <td>2088-04-01 00:08:31</td>\n",
       "      <td>7.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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136765</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9626</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 12:53:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2 руб/минута, так как в поездках по России мин...</td>\n",
       "      <td>2088-08-08 12:53:01</td>\n",
       "      <td>57.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136766</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9623</td>\n",
       "      <td>322982</td>\n",
       "      <td>2088-08-08 12:53:10+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>47.0</td>\n",
       "      <td>Вам спасибо, что написали нам. Всегда будем ра...</td>\n",
       "      <td>2088-08-08 12:53:10</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136767</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9619</td>\n",
       "      <td>322982</td>\n",
       "      <td>2088-08-08 12:53:27+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088-08-08 12:53:27</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136768</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9572</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 12:55:45+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Подробнее о тарифе &amp;quot;Мой онлайн&amp;quot; Вы м...</td>\n",
       "      <td>2088-08-08 12:55:45</td>\n",
       "      <td>138.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136769</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9566</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 12:55:56+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Возможно, еще вопросы остались?=)</td>\n",
       "      <td>2088-08-08 12:55:56</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136770</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9521</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 12:58:46+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>118.0</td>\n",
       "      <td>При смене тарифа, на старый вернуться будет не...</td>\n",
       "      <td>2088-08-08 12:58:46</td>\n",
       "      <td>170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136771</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9468</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 13:00:39+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Информации об изменениях абонентской платы по ...</td>\n",
       "      <td>2088-08-08 13:00:39</td>\n",
       "      <td>113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136772</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9448</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 13:01:24+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Возможно, могу Вам еще чем-либо помочь?=)</td>\n",
       "      <td>2088-08-08 13:01:24</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136773</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9428</td>\n",
       "      <td>323167</td>\n",
       "      <td>2088-08-08 13:02:32+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>530.0</td>\n",
       "      <td>Владимир, пожалуйста, некоторое время ожидайте...</td>\n",
       "      <td>2088-08-08 13:02:32</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136774</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9362</td>\n",
       "      <td>323167</td>\n",
       "      <td>2088-08-08 13:06:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Упс…. По независящим от нас причинам сессия бы...</td>\n",
       "      <td>2088-08-08 13:06:01</td>\n",
       "      <td>209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136775</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9361</td>\n",
       "      <td>323281</td>\n",
       "      <td>2088-08-08 13:06:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Упс…. По независящим от нас причинам сессия бы...</td>\n",
       "      <td>2088-08-08 13:06:01</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136776</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9325</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:08:19+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Здравствуйте, Наталья.</td>\n",
       "      <td>2088-08-08 13:08:19</td>\n",
       "      <td>138.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136777</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9322</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:08:27+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Чем могу Вам помочь?</td>\n",
       "      <td>2088-08-08 13:08:27</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136778</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9307</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:09:29+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>93.0</td>\n",
       "      <td>В данный момент очень удобно. Пакетные тарифы&amp;...</td>\n",
       "      <td>2088-08-08 13:09:29</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136779</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9300</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:09:58+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Наталья, о каком номере идет речь?=)</td>\n",
       "      <td>2088-08-08 13:09:58</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136780</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9283</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:10:47+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Оксана, регион подскажите, я проверю=)</td>\n",
       "      <td>2088-08-08 13:10:47</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136781</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9272</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:11:12+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>56.0</td>\n",
       "      <td>Уточню информацию и вернусь к Вам через пару м...</td>\n",
       "      <td>2088-08-08 13:11:12</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136782</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9259</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:11:50+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>55.0</td>\n",
       "      <td>Сейчас проверю, пару минут, пожалуйста=)</td>\n",
       "      <td>2088-08-08 13:11:50</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136783</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9251</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:11:59+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Минуту=)</td>\n",
       "      <td>2088-08-08 13:11:59</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136784</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9233</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:12:55+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>31.0</td>\n",
       "      <td>Благодарю вас за ожидание.</td>\n",
       "      <td>2088-08-08 13:12:55</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136785</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9229</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:13:20+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Наталья, Вы будете в поездках по России?&lt;br&gt;</td>\n",
       "      <td>2088-08-08 13:13:20</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136786</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9216</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:14:09+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>129.0</td>\n",
       "      <td>Благодарю Вас за ожидание.</td>\n",
       "      <td>2088-08-08 13:14:09</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136787</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9208</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:14:24+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Переход на тариф &amp;quot;классический&amp;quot; бесп...</td>\n",
       "      <td>2088-08-08 13:14:24</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136788</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9200</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:14:43+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>58.0</td>\n",
       "      <td>В таком случае, Вам нужна услуга &amp;quot;Везде н...</td>\n",
       "      <td>2088-08-08 13:14:43</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136789</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9196</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:14:57+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Еще могу Вам помочь?=)</td>\n",
       "      <td>2088-08-08 13:14:57</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136790</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9188</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:15:23+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Если Вы ее подключаете, тариф она не меняет. Я...</td>\n",
       "      <td>2088-08-08 13:15:23</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136791</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9180</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:16:18+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Хорошего дня и всего Вам самого наилучшего! :)</td>\n",
       "      <td>2088-08-08 13:16:18</td>\n",
       "      <td>55.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136792</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9179</td>\n",
       "      <td>323300</td>\n",
       "      <td>2088-08-08 13:16:21+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088-08-08 13:16:21</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136793</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9168</td>\n",
       "      <td>323301</td>\n",
       "      <td>2088-08-08 13:17:06+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>85.0</td>\n",
       "      <td>О ее стоимости, параметрах и командах управлен...</td>\n",
       "      <td>2088-08-08 13:17:06</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3136794</th>\n",
       "      <td>19876.0</td>\n",
       "      <td>9166</td>\n",
       "      <td>323306</td>\n",
       "      <td>2088-08-08 13:17:14+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088-08-08 13:17:14</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3136795 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         user_id  level_1  appeal_id                datetime  client_id  \\\n",
       "0           -1.0  3778572     112419  2088-04-01 00:00:21+03   396307.0   \n",
       "1           -1.0  3778570     112432  2088-04-01 00:00:40+03   410152.0   \n",
       "2           -1.0  3778571     112432  2088-04-01 00:00:47+03   410152.0   \n",
       "3           -1.0  3778564     112432  2088-04-01 00:00:59+03   410152.0   \n",
       "4           -1.0  3778565     112432  2088-04-01 00:01:06+03   410152.0   \n",
       "5           -1.0  3778566     112432  2088-04-01 00:01:14+03   410152.0   \n",
       "6           -1.0  3778567     112432  2088-04-01 00:01:26+03   410152.0   \n",
       "7           -1.0  3778562     112427  2088-04-01 00:01:41+03   423552.0   \n",
       "8           -1.0  3778569     112432  2088-04-01 00:01:43+03   410152.0   \n",
       "9           -1.0  3778568     112432  2088-04-01 00:01:46+03   410152.0   \n",
       "10          -1.0  3778560     112432  2088-04-01 00:02:47+03   410152.0   \n",
       "11          -1.0  3778561     112432  2088-04-01 00:02:53+03   410152.0   \n",
       "12          -1.0  3778559     112419  2088-04-01 00:03:00+03   396307.0   \n",
       "13          -1.0  3778551     112432  2088-04-01 00:04:37+03   410152.0   \n",
       "14          -1.0  3778550     112432  2088-04-01 00:04:43+03   410152.0   \n",
       "15          -1.0  3778553     112432  2088-04-01 00:04:52+03   410152.0   \n",
       "16          -1.0  3778549     112419  2088-04-01 00:04:57+03   396307.0   \n",
       "17          -1.0  3778552     112432  2088-04-01 00:04:57+03   410152.0   \n",
       "18          -1.0  3778548     112419  2088-04-01 00:05:20+03   396307.0   \n",
       "19          -1.0  3778544     112430  2088-04-01 00:05:56+03   441537.0   \n",
       "20          -1.0  3778540     112430  2088-04-01 00:06:25+03   441537.0   \n",
       "21          -1.0  3778538     112433  2088-04-01 00:06:41+03   399223.0   \n",
       "22          -1.0  3778535     112433  2088-04-01 00:07:29+03   399223.0   \n",
       "23          -1.0  3778534     112427  2088-04-01 00:07:37+03   423552.0   \n",
       "24          -1.0  3778533     112419  2088-04-01 00:07:44+03   396307.0   \n",
       "25          -1.0  3778532     112432  2088-04-01 00:07:46+03   410152.0   \n",
       "26          -1.0  3778531     112432  2088-04-01 00:07:49+03   410152.0   \n",
       "27          -1.0  3778528     112434  2088-04-01 00:08:01+03   441538.0   \n",
       "28          -1.0  3778522     112430  2088-04-01 00:08:24+03   441537.0   \n",
       "29          -1.0  3778521     112434  2088-04-01 00:08:31+03   441538.0   \n",
       "...          ...      ...        ...                     ...        ...   \n",
       "3136765  19876.0     9626     323281  2088-08-08 12:53:01+03        NaN   \n",
       "3136766  19876.0     9623     322982  2088-08-08 12:53:10+03        NaN   \n",
       "3136767  19876.0     9619     322982  2088-08-08 12:53:27+03        NaN   \n",
       "3136768  19876.0     9572     323281  2088-08-08 12:55:45+03        NaN   \n",
       "3136769  19876.0     9566     323281  2088-08-08 12:55:56+03        NaN   \n",
       "3136770  19876.0     9521     323281  2088-08-08 12:58:46+03        NaN   \n",
       "3136771  19876.0     9468     323281  2088-08-08 13:00:39+03        NaN   \n",
       "3136772  19876.0     9448     323281  2088-08-08 13:01:24+03        NaN   \n",
       "3136773  19876.0     9428     323167  2088-08-08 13:02:32+03        NaN   \n",
       "3136774  19876.0     9362     323167  2088-08-08 13:06:01+03        NaN   \n",
       "3136775  19876.0     9361     323281  2088-08-08 13:06:01+03        NaN   \n",
       "3136776  19876.0     9325     323301  2088-08-08 13:08:19+03        NaN   \n",
       "3136777  19876.0     9322     323301  2088-08-08 13:08:27+03        NaN   \n",
       "3136778  19876.0     9307     323300  2088-08-08 13:09:29+03        NaN   \n",
       "3136779  19876.0     9300     323301  2088-08-08 13:09:58+03        NaN   \n",
       "3136780  19876.0     9283     323300  2088-08-08 13:10:47+03        NaN   \n",
       "3136781  19876.0     9272     323301  2088-08-08 13:11:12+03        NaN   \n",
       "3136782  19876.0     9259     323300  2088-08-08 13:11:50+03        NaN   \n",
       "3136783  19876.0     9251     323301  2088-08-08 13:11:59+03        NaN   \n",
       "3136784  19876.0     9233     323301  2088-08-08 13:12:55+03        NaN   \n",
       "3136785  19876.0     9229     323301  2088-08-08 13:13:20+03        NaN   \n",
       "3136786  19876.0     9216     323300  2088-08-08 13:14:09+03        NaN   \n",
       "3136787  19876.0     9208     323300  2088-08-08 13:14:24+03        NaN   \n",
       "3136788  19876.0     9200     323301  2088-08-08 13:14:43+03        NaN   \n",
       "3136789  19876.0     9196     323300  2088-08-08 13:14:57+03        NaN   \n",
       "3136790  19876.0     9188     323301  2088-08-08 13:15:23+03        NaN   \n",
       "3136791  19876.0     9180     323300  2088-08-08 13:16:18+03        NaN   \n",
       "3136792  19876.0     9179     323300  2088-08-08 13:16:21+03        NaN   \n",
       "3136793  19876.0     9168     323301  2088-08-08 13:17:06+03        NaN   \n",
       "3136794  19876.0     9166     323306  2088-08-08 13:17:14+03        NaN   \n",
       "\n",
       "         msg_type  channel_id channel_name channel_type  answer_time  \\\n",
       "0               0           3     Telegram     Telegram          NaN   \n",
       "1               0           3     Telegram     Telegram          NaN   \n",
       "2               0           3     Telegram     Telegram          NaN   \n",
       "3               0           3     Telegram     Telegram          NaN   \n",
       "4               0           3     Telegram     Telegram          NaN   \n",
       "5               0           3     Telegram     Telegram          NaN   \n",
       "6               0           3     Telegram     Telegram          NaN   \n",
       "7               0           2        Viber        Viber          NaN   \n",
       "8               0           3     Telegram     Telegram          NaN   \n",
       "9               0           3     Telegram     Telegram          NaN   \n",
       "10              0           3     Telegram     Telegram          NaN   \n",
       "11              0           3     Telegram     Telegram          NaN   \n",
       "12              0           3     Telegram     Telegram          NaN   \n",
       "13              0           3     Telegram     Telegram          NaN   \n",
       "14              0           3     Telegram     Telegram          NaN   \n",
       "15              0           3     Telegram     Telegram          NaN   \n",
       "16              0           3     Telegram     Telegram          NaN   \n",
       "17              0           3     Telegram     Telegram          NaN   \n",
       "18              0           3     Telegram     Telegram          NaN   \n",
       "19              0           2        Viber        Viber          NaN   \n",
       "20              0           2        Viber        Viber          NaN   \n",
       "21              0           3     Telegram     Telegram          NaN   \n",
       "22              0           3     Telegram     Telegram          NaN   \n",
       "23              0           2        Viber        Viber          NaN   \n",
       "24              0           3     Telegram     Telegram          NaN   \n",
       "25              0           3     Telegram     Telegram          NaN   \n",
       "26              0           3     Telegram     Telegram          NaN   \n",
       "27              0          71      Воронеж      Веб-чат          NaN   \n",
       "28              0           2        Viber        Viber          NaN   \n",
       "29              0          71      Воронеж      Веб-чат          NaN   \n",
       "...           ...         ...          ...          ...          ...   \n",
       "3136765         0           2        Viber        Viber         39.0   \n",
       "3136766         0           2        Viber        Viber         47.0   \n",
       "3136767         2           0          NaN          NaN          NaN   \n",
       "3136768         0           2        Viber        Viber          NaN   \n",
       "3136769         0           2        Viber        Viber          NaN   \n",
       "3136770         0           2        Viber        Viber        118.0   \n",
       "3136771         0           2        Viber        Viber         42.0   \n",
       "3136772         0           2        Viber        Viber          NaN   \n",
       "3136773         0           2        Viber        Viber        530.0   \n",
       "3136774         9           0          NaN          NaN          NaN   \n",
       "3136775         9           0          NaN          NaN          NaN   \n",
       "3136776         0           2        Viber        Viber         23.0   \n",
       "3136777         0           2        Viber        Viber          NaN   \n",
       "3136778         0           2        Viber        Viber         93.0   \n",
       "3136779         0           2        Viber        Viber         35.0   \n",
       "3136780         0           2        Viber        Viber         34.0   \n",
       "3136781         0           2        Viber        Viber         56.0   \n",
       "3136782         0           2        Viber        Viber         55.0   \n",
       "3136783         0           2        Viber        Viber         42.0   \n",
       "3136784         0           2        Viber        Viber         31.0   \n",
       "3136785         0           2        Viber        Viber          NaN   \n",
       "3136786         0           2        Viber        Viber        129.0   \n",
       "3136787         0           2        Viber        Viber          NaN   \n",
       "3136788         0           2        Viber        Viber         58.0   \n",
       "3136789         0           2        Viber        Viber         19.0   \n",
       "3136790         0           2        Viber        Viber          2.0   \n",
       "3136791         0           2        Viber        Viber         70.0   \n",
       "3136792         2           0          NaN          NaN          NaN   \n",
       "3136793         0           2        Viber        Viber         85.0   \n",
       "3136794         2           0          NaN          NaN          NaN   \n",
       "\n",
       "                                                      text  \\\n",
       "0        По чьей инициативе мне была подключена данная ...   \n",
       "1                                               Да понятно   \n",
       "2                                                     Блин   \n",
       "3                                     Ну это вообще дурдом   \n",
       "4                  На какой х... Мне платить абонент плату   \n",
       "5                                        Если связь дерьмо   \n",
       "6                              Как у вас в рекламе говорят   \n",
       "7                                             Плохо работа   \n",
       "8             Если у вас не ловит 4г мы отдадим вам деньги   \n",
       "9                                                Отдавайте   \n",
       "10                                      Ну так что молчите   \n",
       "11                                Будет какой то результат   \n",
       "12       Чья инициатива была ее мне предоставить?!-имен...   \n",
       "13       <img class='emoji codexxxxx' draggable='false'...   \n",
       "14                                                     NaN   \n",
       "15                                         Сейчас поставлю   \n",
       "16       По чьей инициативе мне была подключена данная ...   \n",
       "17                                             И посмотрим   \n",
       "18                                  По моей или оператора?   \n",
       "19                                         Я готова(wink2)   \n",
       "20                                                     Жду   \n",
       "21       Интернет на телефоне работает,а звонки не прох...   \n",
       "22                                           xxx xxx xx xx   \n",
       "23                                               Где ответ   \n",
       "24       Платежная система в договорных отношениях межд...   \n",
       "25                                  Ваш бот фото открывает   \n",
       "26                                                       ?   \n",
       "27       Добрый вечер. Что происходит с трафиком? Почем...   \n",
       "28                                         Xiaomi Redmi 4a   \n",
       "29       Добрый вечер. Что происходит с трафиком? Почем...   \n",
       "...                                                    ...   \n",
       "3136765  2 руб/минута, так как в поездках по России мин...   \n",
       "3136766  Вам спасибо, что написали нам. Всегда будем ра...   \n",
       "3136767                                                NaN   \n",
       "3136768  Подробнее о тарифе &quot;Мой онлайн&quot; Вы м...   \n",
       "3136769                  Возможно, еще вопросы остались?=)   \n",
       "3136770  При смене тарифа, на старый вернуться будет не...   \n",
       "3136771  Информации об изменениях абонентской платы по ...   \n",
       "3136772          Возможно, могу Вам еще чем-либо помочь?=)   \n",
       "3136773  Владимир, пожалуйста, некоторое время ожидайте...   \n",
       "3136774  Упс…. По независящим от нас причинам сессия бы...   \n",
       "3136775  Упс…. По независящим от нас причинам сессия бы...   \n",
       "3136776                             Здравствуйте, Наталья.   \n",
       "3136777                               Чем могу Вам помочь?   \n",
       "3136778  В данный момент очень удобно. Пакетные тарифы&...   \n",
       "3136779               Наталья, о каком номере идет речь?=)   \n",
       "3136780             Оксана, регион подскажите, я проверю=)   \n",
       "3136781  Уточню информацию и вернусь к Вам через пару м...   \n",
       "3136782           Сейчас проверю, пару минут, пожалуйста=)   \n",
       "3136783                                           Минуту=)   \n",
       "3136784                         Благодарю вас за ожидание.   \n",
       "3136785       Наталья, Вы будете в поездках по России?<br>   \n",
       "3136786                         Благодарю Вас за ожидание.   \n",
       "3136787  Переход на тариф &quot;классический&quot; бесп...   \n",
       "3136788  В таком случае, Вам нужна услуга &quot;Везде н...   \n",
       "3136789                             Еще могу Вам помочь?=)   \n",
       "3136790  Если Вы ее подключаете, тариф она не меняет. Я...   \n",
       "3136791     Хорошего дня и всего Вам самого наилучшего! :)   \n",
       "3136792                                                NaN   \n",
       "3136793  О ее стоимости, параметрах и командах управлен...   \n",
       "3136794                                                NaN   \n",
       "\n",
       "                         dt  user_answer_time  \n",
       "0       2088-04-01 00:00:21               0.0  \n",
       "1       2088-04-01 00:00:40              19.0  \n",
       "2       2088-04-01 00:00:47               7.0  \n",
       "3       2088-04-01 00:00:59              12.0  \n",
       "4       2088-04-01 00:01:06               7.0  \n",
       "5       2088-04-01 00:01:14               8.0  \n",
       "6       2088-04-01 00:01:26              12.0  \n",
       "7       2088-04-01 00:01:41              15.0  \n",
       "8       2088-04-01 00:01:43               2.0  \n",
       "9       2088-04-01 00:01:46               3.0  \n",
       "10      2088-04-01 00:02:47              61.0  \n",
       "11      2088-04-01 00:02:53               6.0  \n",
       "12      2088-04-01 00:03:00               7.0  \n",
       "13      2088-04-01 00:04:37              97.0  \n",
       "14      2088-04-01 00:04:43               6.0  \n",
       "15      2088-04-01 00:04:52               9.0  \n",
       "16      2088-04-01 00:04:57               5.0  \n",
       "17      2088-04-01 00:04:57               0.0  \n",
       "18      2088-04-01 00:05:20              23.0  \n",
       "19      2088-04-01 00:05:56              36.0  \n",
       "20      2088-04-01 00:06:25              29.0  \n",
       "21      2088-04-01 00:06:41              16.0  \n",
       "22      2088-04-01 00:07:29              48.0  \n",
       "23      2088-04-01 00:07:37               8.0  \n",
       "24      2088-04-01 00:07:44               7.0  \n",
       "25      2088-04-01 00:07:46               2.0  \n",
       "26      2088-04-01 00:07:49               3.0  \n",
       "27      2088-04-01 00:08:01              12.0  \n",
       "28      2088-04-01 00:08:24              23.0  \n",
       "29      2088-04-01 00:08:31               7.0  \n",
       "...                     ...               ...  \n",
       "3136765 2088-08-08 12:53:01              57.0  \n",
       "3136766 2088-08-08 12:53:10               9.0  \n",
       "3136767 2088-08-08 12:53:27              17.0  \n",
       "3136768 2088-08-08 12:55:45             138.0  \n",
       "3136769 2088-08-08 12:55:56              11.0  \n",
       "3136770 2088-08-08 12:58:46             170.0  \n",
       "3136771 2088-08-08 13:00:39             113.0  \n",
       "3136772 2088-08-08 13:01:24              45.0  \n",
       "3136773 2088-08-08 13:02:32              68.0  \n",
       "3136774 2088-08-08 13:06:01             209.0  \n",
       "3136775 2088-08-08 13:06:01               0.0  \n",
       "3136776 2088-08-08 13:08:19             138.0  \n",
       "3136777 2088-08-08 13:08:27               8.0  \n",
       "3136778 2088-08-08 13:09:29              62.0  \n",
       "3136779 2088-08-08 13:09:58              29.0  \n",
       "3136780 2088-08-08 13:10:47              49.0  \n",
       "3136781 2088-08-08 13:11:12              25.0  \n",
       "3136782 2088-08-08 13:11:50              38.0  \n",
       "3136783 2088-08-08 13:11:59               9.0  \n",
       "3136784 2088-08-08 13:12:55              56.0  \n",
       "3136785 2088-08-08 13:13:20              25.0  \n",
       "3136786 2088-08-08 13:14:09              49.0  \n",
       "3136787 2088-08-08 13:14:24              15.0  \n",
       "3136788 2088-08-08 13:14:43              19.0  \n",
       "3136789 2088-08-08 13:14:57              14.0  \n",
       "3136790 2088-08-08 13:15:23              26.0  \n",
       "3136791 2088-08-08 13:16:18              55.0  \n",
       "3136792 2088-08-08 13:16:21               3.0  \n",
       "3136793 2088-08-08 13:17:06              45.0  \n",
       "3136794 2088-08-08 13:17:14               8.0  \n",
       "\n",
       "[3136795 rows x 13 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dialogs_2_data = group.drop(\"user_id\",1).reset_index()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#dialogs_2_data = dialogs_2_data.sort_values(by=['datetime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>appeal_id</th>\n",
       "      <th>datetime</th>\n",
       "      <th>client_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>msg_type</th>\n",
       "      <th>channel_id</th>\n",
       "      <th>channel_name</th>\n",
       "      <th>channel_type</th>\n",
       "      <th>answer_time</th>\n",
       "      <th>text</th>\n",
       "      <th>dt</th>\n",
       "      <th>ten_minutes_index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3778573</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:19+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>96.0</td>\n",
       "      <td>&lt;img data-code=\"\"&lt;U+0001F60A&gt;\"\" src=\"\"data:ima...</td>\n",
       "      <td>2088-04-01 00:00:19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778572</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:00:21+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По чьей инициативе мне была подключена данная ...</td>\n",
       "      <td>2088-04-01 00:00:21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778570</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:40+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Да понятно</td>\n",
       "      <td>2088-04-01 00:00:40</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778571</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:47+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Блин</td>\n",
       "      <td>2088-04-01 00:00:47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778563</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:00:49+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>27.0</td>\n",
       "      <td>Услуга доступна абонентам, которые пополнили б...</td>\n",
       "      <td>2088-04-01 00:00:49</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778564</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:00:59+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ну это вообще дурдом</td>\n",
       "      <td>2088-04-01 00:00:59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778565</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:06+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>На какой х... Мне платить абонент плату</td>\n",
       "      <td>2088-04-01 00:01:06</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778566</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:14+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Если связь дерьмо</td>\n",
       "      <td>2088-04-01 00:01:14</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778567</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:26+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Как у вас в рекламе говорят</td>\n",
       "      <td>2088-04-01 00:01:26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778562</th>\n",
       "      <td>112427</td>\n",
       "      <td>2088-04-01 00:01:41+03</td>\n",
       "      <td>423552.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Плохо работа</td>\n",
       "      <td>2088-04-01 00:01:41</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778569</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:43+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Если у вас не ловит 4г мы отдадим вам деньги</td>\n",
       "      <td>2088-04-01 00:01:43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778568</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:01:46+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Отдавайте</td>\n",
       "      <td>2088-04-01 00:01:46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778560</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:02:47+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ну так что молчите</td>\n",
       "      <td>2088-04-01 00:02:47</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778561</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:02:53+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Будет какой то результат</td>\n",
       "      <td>2088-04-01 00:02:53</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778559</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:03:00+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Чья инициатива была ее мне предоставить?!-имен...</td>\n",
       "      <td>2088-04-01 00:03:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778558</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:03:50+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>190.0</td>\n",
       "      <td>Покрытие 3G хорошее, Вам нужно установить режи...</td>\n",
       "      <td>2088-04-01 00:03:50</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778554</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:04:26+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>86.0</td>\n",
       "      <td>Если происходит пополнение баланса, подключени...</td>\n",
       "      <td>2088-04-01 00:04:26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778551</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:37+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;img class='emoji codexxxxx' draggable='false'...</td>\n",
       "      <td>2088-04-01 00:04:37</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778550</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:43+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2088-04-01 00:04:43</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778553</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:52+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Сейчас поставлю</td>\n",
       "      <td>2088-04-01 00:04:52</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778549</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:04:57+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По чьей инициативе мне была подключена данная ...</td>\n",
       "      <td>2088-04-01 00:04:57</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778552</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:04:57+03</td>\n",
       "      <td>410152.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>И посмотрим</td>\n",
       "      <td>2088-04-01 00:04:57</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778547</th>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:04:59+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19393.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>311.0</td>\n",
       "      <td>В данном районе покрытие 4G неуверенное .Будем...</td>\n",
       "      <td>2088-04-01 00:04:59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778546</th>\n",
       "      <td>112432</td>\n",
       "      <td>2088-04-01 00:05:12+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>35.0</td>\n",
       "      <td>Нет возможности открыть файл.</td>\n",
       "      <td>2088-04-01 00:05:12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778548</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:05:20+03</td>\n",
       "      <td>396307.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>По моей или оператора?</td>\n",
       "      <td>2088-04-01 00:05:20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778545</th>\n",
       "      <td>112419</td>\n",
       "      <td>2088-04-01 00:05:36+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19387.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>39.0</td>\n",
       "      <td>По инициативе платежной системы.</td>\n",
       "      <td>2088-04-01 00:05:36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778544</th>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:05:56+03</td>\n",
       "      <td>441537.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Я готова(wink2)</td>\n",
       "      <td>2088-04-01 00:05:56</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778541</th>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:06:23+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19393.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Уточните, пожалуйста, модель и марку Вашего ус...</td>\n",
       "      <td>2088-04-01 00:06:23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778540</th>\n",
       "      <td>112430</td>\n",
       "      <td>2088-04-01 00:06:25+03</td>\n",
       "      <td>441537.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Жду</td>\n",
       "      <td>2088-04-01 00:06:25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3778538</th>\n",
       "      <td>112433</td>\n",
       "      <td>2088-04-01 00:06:41+03</td>\n",
       "      <td>399223.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>Telegram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Интернет на телефоне работает,а звонки не прох...</td>\n",
       "      <td>2088-04-01 00:06:41</td>\n",
       "      <td>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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>323864</td>\n",
       "      <td>2088-08-08 16:43:35+03</td>\n",
       "      <td>569006.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>171</td>\n",
       "      <td>Кузбасс B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>хорошо, дождусь. А пока опишу свои предпочтени...</td>\n",
       "      <td>2088-08-08 16:43:35</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>323748</td>\n",
       "      <td>2088-08-08 16:43:35+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19409.0</td>\n",
       "      <td>0</td>\n",
       "      <td>117</td>\n",
       "      <td>Санкт-Петербург B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>189.0</td>\n",
       "      <td>На старую сим-карту нельзя перенести номер.</td>\n",
       "      <td>2088-08-08 16:43:35</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>323863</td>\n",
       "      <td>2088-08-08 16:43:37+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19669.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Мы можем блокировать номер определенного отпра...</td>\n",
       "      <td>2088-08-08 16:43:37</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>323871</td>\n",
       "      <td>2088-08-08 16:43:37+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19416.0</td>\n",
       "      <td>0</td>\n",
       "      <td>173</td>\n",
       "      <td>Красноярск B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Переход может занять от 8 до 180 дней после по...</td>\n",
       "      <td>2088-08-08 16:43:37</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>323865</td>\n",
       "      <td>2088-08-08 16:43:39+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19530.0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>Краснодар B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>193.0</td>\n",
       "      <td>Вы сможете подключить услугу &amp;quot;Безлимит на...</td>\n",
       "      <td>2088-08-08 16:43:39</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>323868</td>\n",
       "      <td>2088-08-08 16:43:39+03</td>\n",
       "      <td>569009.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>195</td>\n",
       "      <td>Бурятия B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Здравствуйте. Как перейти к другому оператору?</td>\n",
       "      <td>2088-08-08 16:43:39</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>323869</td>\n",
       "      <td>2088-08-08 16:43:40+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19650.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>55.0</td>\n",
       "      <td>Какой вопрос?</td>\n",
       "      <td>2088-08-08 16:43:40</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>323813</td>\n",
       "      <td>2088-08-08 16:43:40+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19511.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>182.0</td>\n",
       "      <td>Я вижу, Ваш вопрос касается переноса номера. Д...</td>\n",
       "      <td>2088-08-08 16:43:40</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>323816</td>\n",
       "      <td>2088-08-08 16:43:42+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19409.0</td>\n",
       "      <td>0</td>\n",
       "      <td>115</td>\n",
       "      <td>Москва B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>285.0</td>\n",
       "      <td>Пару минут.</td>\n",
       "      <td>2088-08-08 16:43:42</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>323873</td>\n",
       "      <td>2088-08-08 16:43:42+03</td>\n",
       "      <td>569011.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>Краснодар B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Здравсьвуйте!Пожалуйста подскажите  как зареги...</td>\n",
       "      <td>2088-08-08 16:43:42</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>323874</td>\n",
       "      <td>2088-08-08 16:43:43+03</td>\n",
       "      <td>478718.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>по</td>\n",
       "      <td>2088-08-08 16:43:43</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>323875</td>\n",
       "      <td>2088-08-08 16:43:44+03</td>\n",
       "      <td>506274.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Привет</td>\n",
       "      <td>2088-08-08 16:43:44</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>323873</td>\n",
       "      <td>2088-08-08 16:43:45+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19389.0</td>\n",
       "      <td>12</td>\n",
       "      <td>77</td>\n",
       "      <td>Краснодар B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Приветствуем Вас в службе поддержки клиентов! ...</td>\n",
       "      <td>2088-08-08 16:43:45</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>323864</td>\n",
       "      <td>2088-08-08 16:43:45+03</td>\n",
       "      <td>569006.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>171</td>\n",
       "      <td>Кузбасс B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>не могу подобрать соотетствующий тариф, выше н...</td>\n",
       "      <td>2088-08-08 16:43:45</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>323785</td>\n",
       "      <td>2088-08-08 16:43:46+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19671.0</td>\n",
       "      <td>0</td>\n",
       "      <td>101</td>\n",
       "      <td>Тула B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Прошу прощения, это письмо не Вам)</td>\n",
       "      <td>2088-08-08 16:43:46</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>323866</td>\n",
       "      <td>2088-08-08 16:43:48+03</td>\n",
       "      <td>566603.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>что делать в это ситуации?</td>\n",
       "      <td>2088-08-08 16:43:48</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>323835</td>\n",
       "      <td>2088-08-08 16:43:48+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19523.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>197.0</td>\n",
       "      <td>Я понял Вас. Не спорю с Вами.</td>\n",
       "      <td>2088-08-08 16:43:48</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>323872</td>\n",
       "      <td>2088-08-08 16:43:49+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19669.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Здравствуйте, меня зовут Таня. С удовольствием...</td>\n",
       "      <td>2088-08-08 16:43:49</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>323876</td>\n",
       "      <td>2088-08-08 16:43:52+03</td>\n",
       "      <td>569013.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>Волгоград B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Здравствуйте! Скажите, откуда у меня взялась п...</td>\n",
       "      <td>2088-08-08 16:43:52</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>323874</td>\n",
       "      <td>2088-08-08 16:43:52+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19670.0</td>\n",
       "      <td>12</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Приветствуем Вас в службе поддержки клиентов! ...</td>\n",
       "      <td>2088-08-08 16:43:52</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>323875</td>\n",
       "      <td>2088-08-08 16:43:52+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19670.0</td>\n",
       "      <td>12</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Приветствуем Вас в службе поддержки клиентов! ...</td>\n",
       "      <td>2088-08-08 16:43:52</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>323877</td>\n",
       "      <td>2088-08-08 16:43:53+03</td>\n",
       "      <td>569014.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>157</td>\n",
       "      <td>Ямало-Ненецкий автономный округ B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Хочу со своим номером перейти на новый тариф &amp;...</td>\n",
       "      <td>2088-08-08 16:43:53</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>323876</td>\n",
       "      <td>2088-08-08 16:43:54+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19752.0</td>\n",
       "      <td>12</td>\n",
       "      <td>79</td>\n",
       "      <td>Волгоград B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Приветствуем Вас в службе поддержки клиентов! ...</td>\n",
       "      <td>2088-08-08 16:43:54</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>323873</td>\n",
       "      <td>2088-08-08 16:43:56+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19389.0</td>\n",
       "      <td>0</td>\n",
       "      <td>77</td>\n",
       "      <td>Краснодар B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Здравствуйте, меня зовут Оксана. С удовольстви...</td>\n",
       "      <td>2088-08-08 16:43:56</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>323868</td>\n",
       "      <td>2088-08-08 16:43:57+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19671.0</td>\n",
       "      <td>0</td>\n",
       "      <td>195</td>\n",
       "      <td>Бурятия B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>18.0</td>\n",
       "      <td>По какой причине решили перейти?</td>\n",
       "      <td>2088-08-08 16:43:57</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>323867</td>\n",
       "      <td>2088-08-08 16:43:58+03</td>\n",
       "      <td>569008.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>177</td>\n",
       "      <td>Омск B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Тогда проще перейти с номером в мегафон Включа...</td>\n",
       "      <td>2088-08-08 16:43:58</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>323850</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19578.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Viber</td>\n",
       "      <td>Viber</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Можем отправить заявку на подключение новых но...</td>\n",
       "      <td>2088-08-08 16:44:01</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>323861</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19418.0</td>\n",
       "      <td>0</td>\n",
       "      <td>133</td>\n",
       "      <td>Нижний Новгород B2C</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Вы забыли пароль и хотите войти в кабинет?</td>\n",
       "      <td>2088-08-08 16:44:01</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>323870</td>\n",
       "      <td>2088-08-08 16:44:01+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19671.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Все подписки отключены. Как это делать самосто...</td>\n",
       "      <td>2088-08-08 16:44:01</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>323874</td>\n",
       "      <td>2088-08-08 16:44:02+03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19670.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73</td>\n",
       "      <td>Webdealer</td>\n",
       "      <td>Веб-чат</td>\n",
       "      <td>12.0</td>\n",
       "      <td>Привет.))</td>\n",
       "      <td>2088-08-08 16:44:02</td>\n",
       "      <td>18676</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3136795 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         appeal_id                datetime  client_id  user_id  msg_type  \\\n",
       "3778573     112432  2088-04-01 00:00:19+03        NaN  19387.0         0   \n",
       "3778572     112419  2088-04-01 00:00:21+03   396307.0     -1.0         0   \n",
       "3778570     112432  2088-04-01 00:00:40+03   410152.0     -1.0         0   \n",
       "3778571     112432  2088-04-01 00:00:47+03   410152.0     -1.0         0   \n",
       "3778563     112419  2088-04-01 00:00:49+03        NaN  19387.0         0   \n",
       "3778564     112432  2088-04-01 00:00:59+03   410152.0     -1.0         0   \n",
       "3778565     112432  2088-04-01 00:01:06+03   410152.0     -1.0         0   \n",
       "3778566     112432  2088-04-01 00:01:14+03   410152.0     -1.0         0   \n",
       "3778567     112432  2088-04-01 00:01:26+03   410152.0     -1.0         0   \n",
       "3778562     112427  2088-04-01 00:01:41+03   423552.0     -1.0         0   \n",
       "3778569     112432  2088-04-01 00:01:43+03   410152.0     -1.0         0   \n",
       "3778568     112432  2088-04-01 00:01:46+03   410152.0     -1.0         0   \n",
       "3778560     112432  2088-04-01 00:02:47+03   410152.0     -1.0         0   \n",
       "3778561     112432  2088-04-01 00:02:53+03   410152.0     -1.0         0   \n",
       "3778559     112419  2088-04-01 00:03:00+03   396307.0     -1.0         0   \n",
       "3778558     112432  2088-04-01 00:03:50+03        NaN  19387.0         0   \n",
       "3778554     112419  2088-04-01 00:04:26+03        NaN  19387.0         0   \n",
       "3778551     112432  2088-04-01 00:04:37+03   410152.0     -1.0         0   \n",
       "3778550     112432  2088-04-01 00:04:43+03   410152.0     -1.0         0   \n",
       "3778553     112432  2088-04-01 00:04:52+03   410152.0     -1.0         0   \n",
       "3778549     112419  2088-04-01 00:04:57+03   396307.0     -1.0         0   \n",
       "3778552     112432  2088-04-01 00:04:57+03   410152.0     -1.0         0   \n",
       "3778547     112430  2088-04-01 00:04:59+03        NaN  19393.0         0   \n",
       "3778546     112432  2088-04-01 00:05:12+03        NaN  19387.0         0   \n",
       "3778548     112419  2088-04-01 00:05:20+03   396307.0     -1.0         0   \n",
       "3778545     112419  2088-04-01 00:05:36+03        NaN  19387.0         0   \n",
       "3778544     112430  2088-04-01 00:05:56+03   441537.0     -1.0         0   \n",
       "3778541     112430  2088-04-01 00:06:23+03        NaN  19393.0         0   \n",
       "3778540     112430  2088-04-01 00:06:25+03   441537.0     -1.0         0   \n",
       "3778538     112433  2088-04-01 00:06:41+03   399223.0     -1.0         0   \n",
       "...            ...                     ...        ...      ...       ...   \n",
       "48          323864  2088-08-08 16:43:35+03   569006.0     -1.0         0   \n",
       "37          323748  2088-08-08 16:43:35+03        NaN  19409.0         0   \n",
       "35          323863  2088-08-08 16:43:37+03        NaN  19669.0         0   \n",
       "36          323871  2088-08-08 16:43:37+03        NaN  19416.0         0   \n",
       "33          323865  2088-08-08 16:43:39+03        NaN  19530.0         0   \n",
       "34          323868  2088-08-08 16:43:39+03   569009.0     -1.0         0   \n",
       "31          323869  2088-08-08 16:43:40+03        NaN  19650.0         0   \n",
       "30          323813  2088-08-08 16:43:40+03        NaN  19511.0         0   \n",
       "29          323816  2088-08-08 16:43:42+03        NaN  19409.0         0   \n",
       "28          323873  2088-08-08 16:43:42+03   569011.0     -1.0         0   \n",
       "26          323874  2088-08-08 16:43:43+03   478718.0     -1.0         0   \n",
       "24          323875  2088-08-08 16:43:44+03   506274.0     -1.0         0   \n",
       "22          323873  2088-08-08 16:43:45+03        NaN  19389.0        12   \n",
       "47          323864  2088-08-08 16:43:45+03   569006.0     -1.0         0   \n",
       "21          323785  2088-08-08 16:43:46+03        NaN  19671.0         0   \n",
       "20          323866  2088-08-08 16:43:48+03   566603.0     -1.0         0   \n",
       "19          323835  2088-08-08 16:43:48+03        NaN  19523.0         0   \n",
       "18          323872  2088-08-08 16:43:49+03        NaN  19669.0         0   \n",
       "12          323876  2088-08-08 16:43:52+03   569013.0     -1.0         0   \n",
       "14          323874  2088-08-08 16:43:52+03        NaN  19670.0        12   \n",
       "13          323875  2088-08-08 16:43:52+03        NaN  19670.0        12   \n",
       "10          323877  2088-08-08 16:43:53+03   569014.0     -1.0         0   \n",
       "8           323876  2088-08-08 16:43:54+03        NaN  19752.0        12   \n",
       "7           323873  2088-08-08 16:43:56+03        NaN  19389.0         0   \n",
       "6           323868  2088-08-08 16:43:57+03        NaN  19671.0         0   \n",
       "5           323867  2088-08-08 16:43:58+03   569008.0     -1.0         0   \n",
       "3           323850  2088-08-08 16:44:01+03        NaN  19578.0         0   \n",
       "2           323861  2088-08-08 16:44:01+03        NaN  19418.0         0   \n",
       "1           323870  2088-08-08 16:44:01+03        NaN  19671.0         0   \n",
       "0           323874  2088-08-08 16:44:02+03        NaN  19670.0         0   \n",
       "\n",
       "         channel_id                         channel_name channel_type  \\\n",
       "3778573           3                             Telegram     Telegram   \n",
       "3778572           3                             Telegram     Telegram   \n",
       "3778570           3                             Telegram     Telegram   \n",
       "3778571           3                             Telegram     Telegram   \n",
       "3778563           3                             Telegram     Telegram   \n",
       "3778564           3                             Telegram     Telegram   \n",
       "3778565           3                             Telegram     Telegram   \n",
       "3778566           3                             Telegram     Telegram   \n",
       "3778567           3                             Telegram     Telegram   \n",
       "3778562           2                                Viber        Viber   \n",
       "3778569           3                             Telegram     Telegram   \n",
       "3778568           3                             Telegram     Telegram   \n",
       "3778560           3                             Telegram     Telegram   \n",
       "3778561           3                             Telegram     Telegram   \n",
       "3778559           3                             Telegram     Telegram   \n",
       "3778558           3                             Telegram     Telegram   \n",
       "3778554           3                             Telegram     Telegram   \n",
       "3778551           3                             Telegram     Telegram   \n",
       "3778550           3                             Telegram     Telegram   \n",
       "3778553           3                             Telegram     Telegram   \n",
       "3778549           3                             Telegram     Telegram   \n",
       "3778552           3                             Telegram     Telegram   \n",
       "3778547           2                                Viber        Viber   \n",
       "3778546           3                             Telegram     Telegram   \n",
       "3778548           3                             Telegram     Telegram   \n",
       "3778545           3                             Telegram     Telegram   \n",
       "3778544           2                                Viber        Viber   \n",
       "3778541           2                                Viber        Viber   \n",
       "3778540           2                                Viber        Viber   \n",
       "3778538           3                             Telegram     Telegram   \n",
       "...             ...                                  ...          ...   \n",
       "48              171                          Кузбасс B2C      Веб-чат   \n",
       "37              117                  Санкт-Петербург B2C      Веб-чат   \n",
       "35                2                                Viber        Viber   \n",
       "36              173                       Красноярск B2C      Веб-чат   \n",
       "33               77                        Краснодар B2C      Веб-чат   \n",
       "34              195                          Бурятия B2C      Веб-чат   \n",
       "31               73                            Webdealer      Веб-чат   \n",
       "30                2                                Viber        Viber   \n",
       "29              115                           Москва B2C      Веб-чат   \n",
       "28               77                        Краснодар B2C      Веб-чат   \n",
       "26               73                            Webdealer      Веб-чат   \n",
       "24               73                            Webdealer      Веб-чат   \n",
       "22               77                        Краснодар B2C      Веб-чат   \n",
       "47              171                          Кузбасс B2C      Веб-чат   \n",
       "21              101                             Тула B2C      Веб-чат   \n",
       "20               73                            Webdealer      Веб-чат   \n",
       "19                2                                Viber        Viber   \n",
       "18                2                                Viber        Viber   \n",
       "12               79                        Волгоград B2C      Веб-чат   \n",
       "14               73                            Webdealer      Веб-чат   \n",
       "13               73                            Webdealer      Веб-чат   \n",
       "10              157  Ямало-Ненецкий автономный округ B2C      Веб-чат   \n",
       "8                79                        Волгоград B2C      Веб-чат   \n",
       "7                77                        Краснодар B2C      Веб-чат   \n",
       "6               195                          Бурятия B2C      Веб-чат   \n",
       "5               177                             Омск B2C      Веб-чат   \n",
       "3                 2                                Viber        Viber   \n",
       "2               133                  Нижний Новгород B2C      Веб-чат   \n",
       "1                73                            Webdealer      Веб-чат   \n",
       "0                73                            Webdealer      Веб-чат   \n",
       "\n",
       "         answer_time                                               text  \\\n",
       "3778573         96.0  <img data-code=\"\"<U+0001F60A>\"\" src=\"\"data:ima...   \n",
       "3778572          NaN  По чьей инициативе мне была подключена данная ...   \n",
       "3778570          NaN                                         Да понятно   \n",
       "3778571          NaN                                               Блин   \n",
       "3778563         27.0  Услуга доступна абонентам, которые пополнили б...   \n",
       "3778564          NaN                               Ну это вообще дурдом   \n",
       "3778565          NaN            На какой х... Мне платить абонент плату   \n",
       "3778566          NaN                                  Если связь дерьмо   \n",
       "3778567          NaN                        Как у вас в рекламе говорят   \n",
       "3778562          NaN                                       Плохо работа   \n",
       "3778569          NaN       Если у вас не ловит 4г мы отдадим вам деньги   \n",
       "3778568          NaN                                          Отдавайте   \n",
       "3778560          NaN                                 Ну так что молчите   \n",
       "3778561          NaN                           Будет какой то результат   \n",
       "3778559          NaN  Чья инициатива была ее мне предоставить?!-имен...   \n",
       "3778558        190.0  Покрытие 3G хорошее, Вам нужно установить режи...   \n",
       "3778554         86.0  Если происходит пополнение баланса, подключени...   \n",
       "3778551          NaN  <img class='emoji codexxxxx' draggable='false'...   \n",
       "3778550          NaN                                                NaN   \n",
       "3778553          NaN                                    Сейчас поставлю   \n",
       "3778549          NaN  По чьей инициативе мне была подключена данная ...   \n",
       "3778552          NaN                                        И посмотрим   \n",
       "3778547        311.0  В данном районе покрытие 4G неуверенное .Будем...   \n",
       "3778546         35.0                      Нет возможности открыть файл.   \n",
       "3778548          NaN                             По моей или оператора?   \n",
       "3778545         39.0                   По инициативе платежной системы.   \n",
       "3778544          NaN                                    Я готова(wink2)   \n",
       "3778541         26.0  Уточните, пожалуйста, модель и марку Вашего ус...   \n",
       "3778540          NaN                                                Жду   \n",
       "3778538          NaN  Интернет на телефоне работает,а звонки не прох...   \n",
       "...              ...                                                ...   \n",
       "48               NaN  хорошо, дождусь. А пока опишу свои предпочтени...   \n",
       "37             189.0        На старую сим-карту нельзя перенести номер.   \n",
       "35               NaN  Мы можем блокировать номер определенного отпра...   \n",
       "36               7.0  Переход может занять от 8 до 180 дней после по...   \n",
       "33             193.0  Вы сможете подключить услугу &quot;Безлимит на...   \n",
       "34               NaN     Здравствуйте. Как перейти к другому оператору?   \n",
       "31              55.0                                      Какой вопрос?   \n",
       "30             182.0  Я вижу, Ваш вопрос касается переноса номера. Д...   \n",
       "29             285.0                                        Пару минут.   \n",
       "28               NaN  Здравсьвуйте!Пожалуйста подскажите  как зареги...   \n",
       "26               NaN                                                 по   \n",
       "24               NaN                                             Привет   \n",
       "22               NaN  Приветствуем Вас в службе поддержки клиентов! ...   \n",
       "47               NaN  не могу подобрать соотетствующий тариф, выше н...   \n",
       "21               NaN                 Прошу прощения, это письмо не Вам)   \n",
       "20               NaN                         что делать в это ситуации?   \n",
       "19             197.0                      Я понял Вас. Не спорю с Вами.   \n",
       "18              28.0  Здравствуйте, меня зовут Таня. С удовольствием...   \n",
       "12               NaN  Здравствуйте! Скажите, откуда у меня взялась п...   \n",
       "14               NaN  Приветствуем Вас в службе поддержки клиентов! ...   \n",
       "13               NaN  Приветствуем Вас в службе поддержки клиентов! ...   \n",
       "10               NaN  Хочу со своим номером перейти на новый тариф &...   \n",
       "8                NaN  Приветствуем Вас в службе поддержки клиентов! ...   \n",
       "7               13.0  Здравствуйте, меня зовут Оксана. С удовольстви...   \n",
       "6               18.0                   По какой причине решили перейти?   \n",
       "5                NaN  Тогда проще перейти с номером в мегафон Включа...   \n",
       "3               54.0  Можем отправить заявку на подключение новых но...   \n",
       "2                NaN         Вы забыли пароль и хотите войти в кабинет?   \n",
       "1                NaN  Все подписки отключены. Как это делать самосто...   \n",
       "0               12.0                                          Привет.))   \n",
       "\n",
       "                         dt  ten_minutes_index  \n",
       "3778573 2088-04-01 00:00:19                  0  \n",
       "3778572 2088-04-01 00:00:21                  0  \n",
       "3778570 2088-04-01 00:00:40                  0  \n",
       "3778571 2088-04-01 00:00:47                  0  \n",
       "3778563 2088-04-01 00:00:49                  0  \n",
       "3778564 2088-04-01 00:00:59                  0  \n",
       "3778565 2088-04-01 00:01:06                  0  \n",
       "3778566 2088-04-01 00:01:14                  0  \n",
       "3778567 2088-04-01 00:01:26                  0  \n",
       "3778562 2088-04-01 00:01:41                  0  \n",
       "3778569 2088-04-01 00:01:43                  0  \n",
       "3778568 2088-04-01 00:01:46                  0  \n",
       "3778560 2088-04-01 00:02:47                  0  \n",
       "3778561 2088-04-01 00:02:53                  0  \n",
       "3778559 2088-04-01 00:03:00                  0  \n",
       "3778558 2088-04-01 00:03:50                  0  \n",
       "3778554 2088-04-01 00:04:26                  0  \n",
       "3778551 2088-04-01 00:04:37                  0  \n",
       "3778550 2088-04-01 00:04:43                  0  \n",
       "3778553 2088-04-01 00:04:52                  0  \n",
       "3778549 2088-04-01 00:04:57                  0  \n",
       "3778552 2088-04-01 00:04:57                  0  \n",
       "3778547 2088-04-01 00:04:59                  0  \n",
       "3778546 2088-04-01 00:05:12                  0  \n",
       "3778548 2088-04-01 00:05:20                  0  \n",
       "3778545 2088-04-01 00:05:36                  0  \n",
       "3778544 2088-04-01 00:05:56                  0  \n",
       "3778541 2088-04-01 00:06:23                  0  \n",
       "3778540 2088-04-01 00:06:25                  0  \n",
       "3778538 2088-04-01 00:06:41                  0  \n",
       "...                     ...                ...  \n",
       "48      2088-08-08 16:43:35              18676  \n",
       "37      2088-08-08 16:43:35              18676  \n",
       "35      2088-08-08 16:43:37              18676  \n",
       "36      2088-08-08 16:43:37              18676  \n",
       "33      2088-08-08 16:43:39              18676  \n",
       "34      2088-08-08 16:43:39              18676  \n",
       "31      2088-08-08 16:43:40              18676  \n",
       "30      2088-08-08 16:43:40              18676  \n",
       "29      2088-08-08 16:43:42              18676  \n",
       "28      2088-08-08 16:43:42              18676  \n",
       "26      2088-08-08 16:43:43              18676  \n",
       "24      2088-08-08 16:43:44              18676  \n",
       "22      2088-08-08 16:43:45              18676  \n",
       "47      2088-08-08 16:43:45              18676  \n",
       "21      2088-08-08 16:43:46              18676  \n",
       "20      2088-08-08 16:43:48              18676  \n",
       "19      2088-08-08 16:43:48              18676  \n",
       "18      2088-08-08 16:43:49              18676  \n",
       "12      2088-08-08 16:43:52              18676  \n",
       "14      2088-08-08 16:43:52              18676  \n",
       "13      2088-08-08 16:43:52              18676  \n",
       "10      2088-08-08 16:43:53              18676  \n",
       "8       2088-08-08 16:43:54              18676  \n",
       "7       2088-08-08 16:43:56              18676  \n",
       "6       2088-08-08 16:43:57              18676  \n",
       "5       2088-08-08 16:43:58              18676  \n",
       "3       2088-08-08 16:44:01              18676  \n",
       "2       2088-08-08 16:44:01              18676  \n",
       "1       2088-08-08 16:44:01              18676  \n",
       "0       2088-08-08 16:44:02              18676  \n",
       "\n",
       "[3136795 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_time = dialogs_2_data['dt'].min()\n",
    "dialogs_2_data[\"ten_minutes_index\"] = dialogs_2_data[\"dt\"].apply(lambda x: int((x-min_time)/np.timedelta64(10,'m')))\n",
    "dialogs_2_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#clients messages count\n",
    "def messagesCount(df):\n",
    "    \n",
    "ten_mins_groups = dialogs_2_data.groupby('ten_minutes_index')\n",
    "dialogs_2_data = ten_mins_groups.apply("
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#unique user mean time\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False    3056755\n",
       "True       80040\n",
       "Name: thx, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dialogs_2_data[\"thx\"] = dialogs_2_data['text'].apply(lambda x: str(x).find(\"спасибо\")!=-1)\n",
    "dialogs_2_data[\"thx\"].value_counts()"
   ]
  },
  {
   "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}