Hadling_Dates.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "aebc6373-4563-4756-8148-f3f23d5a4222",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "fd40d934-9ba3-4d70-a7be-4685a6afdf26",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "b9c8d5e1-1f03-4327-83bb-1237f0a349d8",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  product_id  city_id  orders\n",
       "0  2019-12-10        5628       25       3\n",
       "1  2018-08-15        3646       14     157"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates=pd.read_csv(\"orders.csv\")\n",
    "dates.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "96bbf63a-8efe-474c-a7b1-dfdf4c6a8754",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 4 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   date        1000 non-null   object\n",
      " 1   product_id  1000 non-null   int64 \n",
      " 2   city_id     1000 non-null   int64 \n",
      " 3   orders      1000 non-null   int64 \n",
      "dtypes: int64(3), object(1)\n",
      "memory usage: 31.4+ KB\n"
     ]
    }
   ],
   "source": [
    "dates.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "d535cedd-c947-445b-871c-850dc3c478bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "dates[\"date\"]=pd.to_datetime(dates[\"date\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "73bb8dfc-f06e-473b-adcf-5b195ab87a35",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 4 columns):\n",
      " #   Column      Non-Null Count  Dtype         \n",
      "---  ------      --------------  -----         \n",
      " 0   date        1000 non-null   datetime64[ns]\n",
      " 1   product_id  1000 non-null   int64         \n",
      " 2   city_id     1000 non-null   int64         \n",
      " 3   orders      1000 non-null   int64         \n",
      "dtypes: datetime64[ns](1), int64(3)\n",
      "memory usage: 31.4 KB\n"
     ]
    }
   ],
   "source": [
    "dates.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "fbb52bd5-b4d8-4343-948a-71e1f57eff74",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "      <th>date_month</th>\n",
       "      <th>date_year</th>\n",
       "      <th>date_day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>December</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1859</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-08-17</td>\n",
       "      <td>7292</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  product_id  city_id  orders date_month  date_year  date_day\n",
       "0 2019-12-10        5628       25       3   December       2019        10\n",
       "1 2018-08-15        3646       14     157     August       2018        15\n",
       "2 2018-10-23        1859       25       1    October       2018        23\n",
       "3 2019-08-17        7292       25       1     August       2019        17"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now apply dunction\n",
    "dates[\"date_month\"]=dates[\"date\"].dt.month_name()\n",
    "dates.head(4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "bc339692-62c7-4b48-b087-20359af7a112",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "      <th>date_month</th>\n",
       "      <th>date_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "      <td>8</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1859</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-08-17</td>\n",
       "      <td>7292</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-06</td>\n",
       "      <td>4344</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  product_id  city_id  orders  date_month  date_year\n",
       "0 2019-12-10        5628       25       3          12       2019\n",
       "1 2018-08-15        3646       14     157           8       2018\n",
       "2 2018-10-23        1859       25       1          10       2018\n",
       "3 2019-08-17        7292       25       1           8       2019\n",
       "4 2019-01-06        4344       25       3           1       2019"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now apply dunction\n",
    "dates[\"date_year\"]=dates[\"date\"].dt.year\n",
    "dates.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "f2079985-79f0-45b1-82e2-1ba9d213c8ec",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "      <th>date_month</th>\n",
       "      <th>date_year</th>\n",
       "      <th>date_day</th>\n",
       "      <th>MOnth_agust</th>\n",
       "      <th>week_day</th>\n",
       "      <th>week_Quarter</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>December</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1859</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-08-17</td>\n",
       "      <td>7292</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-06</td>\n",
       "      <td>4344</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>January</td>\n",
       "      <td>2019</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  product_id  city_id  orders date_month  date_year  date_day  \\\n",
       "0 2019-12-10        5628       25       3   December       2019        10   \n",
       "1 2018-08-15        3646       14     157     August       2018        15   \n",
       "2 2018-10-23        1859       25       1    October       2018        23   \n",
       "3 2019-08-17        7292       25       1     August       2019        17   \n",
       "4 2019-01-06        4344       25       3    January       2019         6   \n",
       "\n",
       "   MOnth_agust  week_day  week_Quarter  \n",
       "0            0         4             4  \n",
       "1            1         3             3  \n",
       "2            0         4             4  \n",
       "3            1         3             3  \n",
       "4            0         1             1  "
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now apply dunction\n",
    "dates[\"date_day\"]=dates[\"date\"].dt.day\n",
    "dates.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "424377c1-29f4-4fa2-a912-de8c3fb0f118",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 7 columns):\n",
      " #   Column      Non-Null Count  Dtype         \n",
      "---  ------      --------------  -----         \n",
      " 0   date        1000 non-null   datetime64[ns]\n",
      " 1   product_id  1000 non-null   int64         \n",
      " 2   city_id     1000 non-null   int64         \n",
      " 3   orders      1000 non-null   int64         \n",
      " 4   date_month  1000 non-null   int32         \n",
      " 5   date_year   1000 non-null   int32         \n",
      " 6   date_day    1000 non-null   int32         \n",
      "dtypes: datetime64[ns](1), int32(3), int64(3)\n",
      "memory usage: 43.1 KB\n"
     ]
    }
   ],
   "source": [
    "dates.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "7109d7d4-e113-4875-a53c-deeaed07128d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#to check is tis weekend.\n",
    "dates[\"MOnth_agust\"]=np.where(dates[\"date_month\"].isin([\"August\"]),1,0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "7a4060e0-0868-4029-8022-264302d3b261",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "      <th>date_month</th>\n",
       "      <th>date_year</th>\n",
       "      <th>date_day</th>\n",
       "      <th>MOnth_agust</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>December</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1859</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-08-17</td>\n",
       "      <td>7292</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-06</td>\n",
       "      <td>4344</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>January</td>\n",
       "      <td>2019</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-08-23</td>\n",
       "      <td>1811</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-11-21</td>\n",
       "      <td>1282</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>November</td>\n",
       "      <td>2018</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>5022</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>March</td>\n",
       "      <td>2019</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2019-06-29</td>\n",
       "      <td>3699</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>June</td>\n",
       "      <td>2019</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-08-30</td>\n",
       "      <td>4373</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>6339</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2019</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2019-08-02</td>\n",
       "      <td>3311</td>\n",
       "      <td>22</td>\n",
       "      <td>6</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2019-03-15</td>\n",
       "      <td>5665</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>March</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-08-24</td>\n",
       "      <td>3020</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2019-05-29</td>\n",
       "      <td>3833</td>\n",
       "      <td>26</td>\n",
       "      <td>240</td>\n",
       "      <td>May</td>\n",
       "      <td>2019</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2019-02-14</td>\n",
       "      <td>202</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>February</td>\n",
       "      <td>2019</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019-04-10</td>\n",
       "      <td>977</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>April</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-09-24</td>\n",
       "      <td>2701</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>September</td>\n",
       "      <td>2018</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2019-06-12</td>\n",
       "      <td>5630</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "      <td>June</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2019-04-13</td>\n",
       "      <td>7163</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>April</td>\n",
       "      <td>2019</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  product_id  city_id  orders date_month  date_year  date_day  \\\n",
       "0  2019-12-10        5628       25       3   December       2019        10   \n",
       "1  2018-08-15        3646       14     157     August       2018        15   \n",
       "2  2018-10-23        1859       25       1    October       2018        23   \n",
       "3  2019-08-17        7292       25       1     August       2019        17   \n",
       "4  2019-01-06        4344       25       3    January       2019         6   \n",
       "5  2018-08-23        1811       25       4     August       2018        23   \n",
       "6  2018-11-21        1282       26       1   November       2018        21   \n",
       "7  2019-03-27        5022        2      41      March       2019        27   \n",
       "8  2019-06-29        3699        3      15       June       2019        29   \n",
       "9  2018-08-30        4373       11       3     August       2018        30   \n",
       "10 2019-10-24        6339       26       1    October       2019        24   \n",
       "11 2019-08-02        3311       22       6     August       2019         2   \n",
       "12 2019-03-15        5665        5       1      March       2019        15   \n",
       "13 2018-08-24        3020       13       4     August       2018        24   \n",
       "14 2019-05-29        3833       26     240        May       2019        29   \n",
       "15 2019-02-14         202        2       4   February       2019        14   \n",
       "16 2019-04-10         977       22       1      April       2019        10   \n",
       "17 2018-09-24        2701       14      16  September       2018        24   \n",
       "18 2019-06-12        5630       14      31       June       2019        12   \n",
       "19 2019-04-13        7163        2      20      April       2019        13   \n",
       "\n",
       "    MOnth_agust  \n",
       "0             0  \n",
       "1             1  \n",
       "2             0  \n",
       "3             1  \n",
       "4             0  \n",
       "5             1  \n",
       "6             0  \n",
       "7             0  \n",
       "8             0  \n",
       "9             1  \n",
       "10            0  \n",
       "11            1  \n",
       "12            0  \n",
       "13            1  \n",
       "14            0  \n",
       "15            0  \n",
       "16            0  \n",
       "17            0  \n",
       "18            0  \n",
       "19            0  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "a62b82ee-eaf2-4894-bcb8-038ed0baafe3",
   "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>date</th>\n",
       "      <th>product_id</th>\n",
       "      <th>city_id</th>\n",
       "      <th>orders</th>\n",
       "      <th>date_month</th>\n",
       "      <th>date_year</th>\n",
       "      <th>date_day</th>\n",
       "      <th>MOnth_agust</th>\n",
       "      <th>week_day</th>\n",
       "      <th>week_Quarter</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-12-10</td>\n",
       "      <td>5628</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>December</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>3646</td>\n",
       "      <td>14</td>\n",
       "      <td>157</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1859</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-08-17</td>\n",
       "      <td>7292</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-01-06</td>\n",
       "      <td>4344</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>January</td>\n",
       "      <td>2019</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-08-23</td>\n",
       "      <td>1811</td>\n",
       "      <td>25</td>\n",
       "      <td>4</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-11-21</td>\n",
       "      <td>1282</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>November</td>\n",
       "      <td>2018</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>5022</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>March</td>\n",
       "      <td>2019</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2019-06-29</td>\n",
       "      <td>3699</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>June</td>\n",
       "      <td>2019</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-08-30</td>\n",
       "      <td>4373</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>6339</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>October</td>\n",
       "      <td>2019</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2019-08-02</td>\n",
       "      <td>3311</td>\n",
       "      <td>22</td>\n",
       "      <td>6</td>\n",
       "      <td>August</td>\n",
       "      <td>2019</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2019-03-15</td>\n",
       "      <td>5665</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>March</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-08-24</td>\n",
       "      <td>3020</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "      <td>August</td>\n",
       "      <td>2018</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2019-05-29</td>\n",
       "      <td>3833</td>\n",
       "      <td>26</td>\n",
       "      <td>240</td>\n",
       "      <td>May</td>\n",
       "      <td>2019</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2019-02-14</td>\n",
       "      <td>202</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>February</td>\n",
       "      <td>2019</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019-04-10</td>\n",
       "      <td>977</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>April</td>\n",
       "      <td>2019</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-09-24</td>\n",
       "      <td>2701</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>September</td>\n",
       "      <td>2018</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2019-06-12</td>\n",
       "      <td>5630</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "      <td>June</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2019-04-13</td>\n",
       "      <td>7163</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>April</td>\n",
       "      <td>2019</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  product_id  city_id  orders date_month  date_year  date_day  \\\n",
       "0  2019-12-10        5628       25       3   December       2019        10   \n",
       "1  2018-08-15        3646       14     157     August       2018        15   \n",
       "2  2018-10-23        1859       25       1    October       2018        23   \n",
       "3  2019-08-17        7292       25       1     August       2019        17   \n",
       "4  2019-01-06        4344       25       3    January       2019         6   \n",
       "5  2018-08-23        1811       25       4     August       2018        23   \n",
       "6  2018-11-21        1282       26       1   November       2018        21   \n",
       "7  2019-03-27        5022        2      41      March       2019        27   \n",
       "8  2019-06-29        3699        3      15       June       2019        29   \n",
       "9  2018-08-30        4373       11       3     August       2018        30   \n",
       "10 2019-10-24        6339       26       1    October       2019        24   \n",
       "11 2019-08-02        3311       22       6     August       2019         2   \n",
       "12 2019-03-15        5665        5       1      March       2019        15   \n",
       "13 2018-08-24        3020       13       4     August       2018        24   \n",
       "14 2019-05-29        3833       26     240        May       2019        29   \n",
       "15 2019-02-14         202        2       4   February       2019        14   \n",
       "16 2019-04-10         977       22       1      April       2019        10   \n",
       "17 2018-09-24        2701       14      16  September       2018        24   \n",
       "18 2019-06-12        5630       14      31       June       2019        12   \n",
       "19 2019-04-13        7163        2      20      April       2019        13   \n",
       "\n",
       "    MOnth_agust  week_day  week_Quarter  \n",
       "0             0         4             4  \n",
       "1             1         3             3  \n",
       "2             0         4             4  \n",
       "3             1         3             3  \n",
       "4             0         1             1  \n",
       "5             1         3             3  \n",
       "6             0         4             4  \n",
       "7             0         1             1  \n",
       "8             0         2             2  \n",
       "9             1         3             3  \n",
       "10            0         4             4  \n",
       "11            1         3             3  \n",
       "12            0         1             1  \n",
       "13            1         3             3  \n",
       "14            0         2             2  \n",
       "15            0         1             1  \n",
       "16            0         2             2  \n",
       "17            0         3             3  \n",
       "18            0         2             2  \n",
       "19            0         2             2  "
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates[\"week_Quarter\"]=dates[\"date\"].dt.quarter\n",
    "dates.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "7c157223-476f-41b6-81d0-87a3edc11550",
   "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>date</th>\n",
       "      <th>msg</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-12-15 00:50:00</td>\n",
       "      <td>ищу на сегодня мужика 37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-04-29 23:40:00</td>\n",
       "      <td>ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2012-12-30 00:21:00</td>\n",
       "      <td>Днепр.м 43 позн.с д/ж *.о  067.16.34.576</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  date                                               msg\n",
       "0  2013-12-15 00:50:00                          ищу на сегодня мужика 37\n",
       "1  2014-04-29 23:40:00  ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826\n",
       "2  2012-12-30 00:21:00          Днепр.м 43 позн.с д/ж *.о  067.16.34.576"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time=pd.read_csv(\"messages (1).csv\")\n",
    "time.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "078523f4-ea46-461b-b1dc-73d3caaf0afc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 2 columns):\n",
      " #   Column  Non-Null Count  Dtype \n",
      "---  ------  --------------  ----- \n",
      " 0   date    1000 non-null   object\n",
      " 1   msg     1000 non-null   object\n",
      "dtypes: object(2)\n",
      "memory usage: 15.8+ KB\n"
     ]
    }
   ],
   "source": [
    "time.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "3dea9cec-35df-415c-807a-3718810fcb4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "time[\"date\"]=pd.to_datetime(time[\"date\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "f2f9139a-952d-4aa9-af3a-c3306d46d2ae",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1000 entries, 0 to 999\n",
      "Data columns (total 2 columns):\n",
      " #   Column  Non-Null Count  Dtype         \n",
      "---  ------  --------------  -----         \n",
      " 0   date    1000 non-null   datetime64[ns]\n",
      " 1   msg     1000 non-null   object        \n",
      "dtypes: datetime64[ns](1), object(1)\n",
      "memory usage: 15.8+ KB\n"
     ]
    }
   ],
   "source": [
    "time.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "0549447b-8ba7-42b6-90d9-ba6e7571e2f7",
   "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>date</th>\n",
       "      <th>msg</th>\n",
       "      <th>hours</th>\n",
       "      <th>Minut</th>\n",
       "      <th>seconds</th>\n",
       "      <th>time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-12-15 00:50:00</td>\n",
       "      <td>ищу на сегодня мужика 37</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>00:50:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-04-29 23:40:00</td>\n",
       "      <td>ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826</td>\n",
       "      <td>23</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>23:40:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2012-12-30 00:21:00</td>\n",
       "      <td>Днепр.м 43 позн.с д/ж *.о  067.16.34.576</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>00:21:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-11-28 00:31:00</td>\n",
       "      <td>КИЕВ ИЩУ Д/Ж ДО 45 МНЕ СЕЙЧАС СКУЧНО 093 629 9...</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>00:31:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-10-26 23:11:00</td>\n",
       "      <td>Зая я тебя никогда не обижу  люблю тебя!)  Даше</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>23:11:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2016-03-08 22:52:00</td>\n",
       "      <td>пар.32прок.дев.на авто по ночн.городу.Днепр.06...</td>\n",
       "      <td>22</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>22:52:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-02-18 00:23:00</td>\n",
       "      <td>Семейная пара познакомится для отношений</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>00:23:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2012-11-23 01:10:00</td>\n",
       "      <td>ДЛЯ С.П СНАЧАЛО СМС 066.679.400.8</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>01:10:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014-12-23 01:20:00</td>\n",
       "      <td>Дедушки ау вы где? СНЕГУРОЧКИ СКУЧАЮТ. Здесь е...</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>01:20:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2012-11-03 23:46:00</td>\n",
       "      <td>ищу парня с авто.063 528 90 72</td>\n",
       "      <td>23</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>23:46:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2013-07-26 00:11:00</td>\n",
       "      <td>Хочу обшения на инт темы с девушкой 0500747823...</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>00:11:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2013-12-18 00:39:00</td>\n",
       "      <td>открою дверь прохожему который хочет погреться...</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>00:39:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2013-06-05 01:05:00</td>\n",
       "      <td>.эксперементаторше. 0678676246</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>01:05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016-11-27 22:29:00</td>\n",
       "      <td>Полненькая девушка ищет парня для серн.отн.Али...</td>\n",
       "      <td>22</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>22:29:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-10-04 01:42:00</td>\n",
       "      <td>парень ищет общения. 099</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>01:42:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2012-08-24 23:13:00</td>\n",
       "      <td>Саша 4 Я знаю все о твоих письмах.Сколько это ...</td>\n",
       "      <td>23</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>23:13:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-10-19 22:52:00</td>\n",
       "      <td>КТО СДЕЛАЕТ ПАРНЮ МАССАЖ ДЕВ ИЛИ 2 СЕЙЧАС 099 ...</td>\n",
       "      <td>22</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>22:52:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2013-10-13 01:01:00</td>\n",
       "      <td>М.37 хочу общения с д/ж и не только. смс ммс з...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>01:01:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2016-01-19 22:33:00</td>\n",
       "      <td>Элегантная госпожа ищет мальчика на побегушках...</td>\n",
       "      <td>22</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>22:33:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-03-17 23:16:00</td>\n",
       "      <td>МЗ9ПОЗНАК.СО СТРОЙНОЙ ДЕВ.С ДНЕПРА ДО З0 ДЛЯ С...</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>23:16:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  date                                                msg  \\\n",
       "0  2013-12-15 00:50:00                           ищу на сегодня мужика 37   \n",
       "1  2014-04-29 23:40:00   ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826   \n",
       "2  2012-12-30 00:21:00           Днепр.м 43 позн.с д/ж *.о  067.16.34.576   \n",
       "3  2014-11-28 00:31:00  КИЕВ ИЩУ Д/Ж ДО 45 МНЕ СЕЙЧАС СКУЧНО 093 629 9...   \n",
       "4  2013-10-26 23:11:00    Зая я тебя никогда не обижу  люблю тебя!)  Даше   \n",
       "5  2016-03-08 22:52:00  пар.32прок.дев.на авто по ночн.городу.Днепр.06...   \n",
       "6  2014-02-18 00:23:00           Семейная пара познакомится для отношений   \n",
       "7  2012-11-23 01:10:00                  ДЛЯ С.П СНАЧАЛО СМС 066.679.400.8   \n",
       "8  2014-12-23 01:20:00  Дедушки ау вы где? СНЕГУРОЧКИ СКУЧАЮТ. Здесь е...   \n",
       "9  2012-11-03 23:46:00                     ищу парня с авто.063 528 90 72   \n",
       "10 2013-07-26 00:11:00  Хочу обшения на инт темы с девушкой 0500747823...   \n",
       "11 2013-12-18 00:39:00  открою дверь прохожему который хочет погреться...   \n",
       "12 2013-06-05 01:05:00                     .эксперементаторше. 0678676246   \n",
       "13 2016-11-27 22:29:00  Полненькая девушка ищет парня для серн.отн.Али...   \n",
       "14 2015-10-04 01:42:00                           парень ищет общения. 099   \n",
       "15 2012-08-24 23:13:00  Саша 4 Я знаю все о твоих письмах.Сколько это ...   \n",
       "16 2015-10-19 22:52:00  КТО СДЕЛАЕТ ПАРНЮ МАССАЖ ДЕВ ИЛИ 2 СЕЙЧАС 099 ...   \n",
       "17 2013-10-13 01:01:00  М.37 хочу общения с д/ж и не только. смс ммс з...   \n",
       "18 2016-01-19 22:33:00  Элегантная госпожа ищет мальчика на побегушках...   \n",
       "19 2014-03-17 23:16:00  МЗ9ПОЗНАК.СО СТРОЙНОЙ ДЕВ.С ДНЕПРА ДО З0 ДЛЯ С...   \n",
       "\n",
       "    hours  Minut  seconds      time  \n",
       "0       0     50        0  00:50:00  \n",
       "1      23     40        0  23:40:00  \n",
       "2       0     21        0  00:21:00  \n",
       "3       0     31        0  00:31:00  \n",
       "4      23     11        0  23:11:00  \n",
       "5      22     52        0  22:52:00  \n",
       "6       0     23        0  00:23:00  \n",
       "7       1     10        0  01:10:00  \n",
       "8       1     20        0  01:20:00  \n",
       "9      23     46        0  23:46:00  \n",
       "10      0     11        0  00:11:00  \n",
       "11      0     39        0  00:39:00  \n",
       "12      1      5        0  01:05:00  \n",
       "13     22     29        0  22:29:00  \n",
       "14      1     42        0  01:42:00  \n",
       "15     23     13        0  23:13:00  \n",
       "16     22     52        0  22:52:00  \n",
       "17      1      1        0  01:01:00  \n",
       "18     22     33        0  22:33:00  \n",
       "19     23     16        0  23:16:00  "
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time[\"time\"]=time[\"date\"].dt.time\n",
    "time.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "87777f33-80bf-462b-8c01-f744ecb616c2",
   "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>date</th>\n",
       "      <th>msg</th>\n",
       "      <th>hours</th>\n",
       "      <th>Minut</th>\n",
       "      <th>seconds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2013-12-15 00:50:00</td>\n",
       "      <td>ищу на сегодня мужика 37</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-04-29 23:40:00</td>\n",
       "      <td>ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826</td>\n",
       "      <td>23</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2012-12-30 00:21:00</td>\n",
       "      <td>Днепр.м 43 позн.с д/ж *.о  067.16.34.576</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-11-28 00:31:00</td>\n",
       "      <td>КИЕВ ИЩУ Д/Ж ДО 45 МНЕ СЕЙЧАС СКУЧНО 093 629 9...</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-10-26 23:11:00</td>\n",
       "      <td>Зая я тебя никогда не обижу  люблю тебя!)  Даше</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2016-03-08 22:52:00</td>\n",
       "      <td>пар.32прок.дев.на авто по ночн.городу.Днепр.06...</td>\n",
       "      <td>22</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-02-18 00:23:00</td>\n",
       "      <td>Семейная пара познакомится для отношений</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2012-11-23 01:10:00</td>\n",
       "      <td>ДЛЯ С.П СНАЧАЛО СМС 066.679.400.8</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014-12-23 01:20:00</td>\n",
       "      <td>Дедушки ау вы где? СНЕГУРОЧКИ СКУЧАЮТ. Здесь е...</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2012-11-03 23:46:00</td>\n",
       "      <td>ищу парня с авто.063 528 90 72</td>\n",
       "      <td>23</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2013-07-26 00:11:00</td>\n",
       "      <td>Хочу обшения на инт темы с девушкой 0500747823...</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2013-12-18 00:39:00</td>\n",
       "      <td>открою дверь прохожему который хочет погреться...</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2013-06-05 01:05:00</td>\n",
       "      <td>.эксперементаторше. 0678676246</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016-11-27 22:29:00</td>\n",
       "      <td>Полненькая девушка ищет парня для серн.отн.Али...</td>\n",
       "      <td>22</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-10-04 01:42:00</td>\n",
       "      <td>парень ищет общения. 099</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2012-08-24 23:13:00</td>\n",
       "      <td>Саша 4 Я знаю все о твоих письмах.Сколько это ...</td>\n",
       "      <td>23</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-10-19 22:52:00</td>\n",
       "      <td>КТО СДЕЛАЕТ ПАРНЮ МАССАЖ ДЕВ ИЛИ 2 СЕЙЧАС 099 ...</td>\n",
       "      <td>22</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2013-10-13 01:01:00</td>\n",
       "      <td>М.37 хочу общения с д/ж и не только. смс ммс з...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2016-01-19 22:33:00</td>\n",
       "      <td>Элегантная госпожа ищет мальчика на побегушках...</td>\n",
       "      <td>22</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-03-17 23:16:00</td>\n",
       "      <td>МЗ9ПОЗНАК.СО СТРОЙНОЙ ДЕВ.С ДНЕПРА ДО З0 ДЛЯ С...</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-06-11 00:12:00</td>\n",
       "      <td>парень познакомиться с.девушкой для серьёзных ...</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-23 00:17:00</td>\n",
       "      <td>увезу Д до 20 за границу стройн красив Алексей</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-02-18 00:34:00</td>\n",
       "      <td>ищю д-ж для и от30до60 сначала смс админ 226(0...</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2013-09-10 00:06:00</td>\n",
       "      <td>ласковая кошечка ищет своего ночного котика</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2013-03-18 02:00:00</td>\n",
       "      <td>Мар Володя</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2014-06-03 01:01:00</td>\n",
       "      <td>М   41.185.75. Интересные Женщ. Есть? Дн-жинск...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2016-07-31 23:19:00</td>\n",
       "      <td>М38/192/95 ищу сим дев реб не помеха 0679688357</td>\n",
       "      <td>23</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-11-30 22:59:00</td>\n",
       "      <td>М 48/176 для серьёзн. отн с Ж до 49л  ДНЕПР  0...</td>\n",
       "      <td>22</td>\n",
       "      <td>59</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2016-11-08 00:17:00</td>\n",
       "      <td>097 509 29 45 ИЩУ Д/Ж 35-45 ЛЕТ ДЛЯ И. О .ЗАПО...</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-03-21 22:56:00</td>\n",
       "      <td>отв 80</td>\n",
       "      <td>22</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2013-03-16 23:20:00</td>\n",
       "      <td>Д.позн.с поряд.парнем27-29 Для С/О.Ростдо1.75 ...</td>\n",
       "      <td>23</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2013-03-03 00:58:00</td>\n",
       "      <td>. Мне 36. Хочу женщину 50-55лет. Жду смс ммс. ...</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2012-02-20 23:40:00</td>\n",
       "      <td>ПАР ПРИГЛАСИТ ИЛИ ПРИЕДЕТ К  ДЕВ ДЛЯ ЛЮБВИ сей...</td>\n",
       "      <td>23</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2015-07-03 00:45:00</td>\n",
       "      <td>п+п познакомится30-45 звонить завтра после10 ....</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2015-10-10 00:52:00</td>\n",
       "      <td>Днепр Пар 32лет познак с Жен 40-50лет для встр...</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2015-10-27 01:07:00</td>\n",
       "      <td>Парень 24. Ищу девушку</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2014-06-30 01:13:00</td>\n",
       "      <td>Адекватный парень с богатой фантазией пообщает...</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2013-11-05 01:49:00</td>\n",
       "      <td>СамыйПервыйПакимонЧебурашкараскрылТайнуСвоегоП...</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2013-10-26 00:12:00</td>\n",
       "      <td>сделаю инт массаж М за 40 Света</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2016-05-07 00:07:00</td>\n",
       "      <td>Муж.45.женат ищу дев.женщину для встреч.жду ва...</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  date                                                msg  \\\n",
       "0  2013-12-15 00:50:00                           ищу на сегодня мужика 37   \n",
       "1  2014-04-29 23:40:00   ПАРЕНЬ БИ ИЩЕТ ДРУГА СЕЙЧАС!! СМС ММС 0955532826   \n",
       "2  2012-12-30 00:21:00           Днепр.м 43 позн.с д/ж *.о  067.16.34.576   \n",
       "3  2014-11-28 00:31:00  КИЕВ ИЩУ Д/Ж ДО 45 МНЕ СЕЙЧАС СКУЧНО 093 629 9...   \n",
       "4  2013-10-26 23:11:00    Зая я тебя никогда не обижу  люблю тебя!)  Даше   \n",
       "5  2016-03-08 22:52:00  пар.32прок.дев.на авто по ночн.городу.Днепр.06...   \n",
       "6  2014-02-18 00:23:00           Семейная пара познакомится для отношений   \n",
       "7  2012-11-23 01:10:00                  ДЛЯ С.П СНАЧАЛО СМС 066.679.400.8   \n",
       "8  2014-12-23 01:20:00  Дедушки ау вы где? СНЕГУРОЧКИ СКУЧАЮТ. Здесь е...   \n",
       "9  2012-11-03 23:46:00                     ищу парня с авто.063 528 90 72   \n",
       "10 2013-07-26 00:11:00  Хочу обшения на инт темы с девушкой 0500747823...   \n",
       "11 2013-12-18 00:39:00  открою дверь прохожему который хочет погреться...   \n",
       "12 2013-06-05 01:05:00                     .эксперементаторше. 0678676246   \n",
       "13 2016-11-27 22:29:00  Полненькая девушка ищет парня для серн.отн.Али...   \n",
       "14 2015-10-04 01:42:00                           парень ищет общения. 099   \n",
       "15 2012-08-24 23:13:00  Саша 4 Я знаю все о твоих письмах.Сколько это ...   \n",
       "16 2015-10-19 22:52:00  КТО СДЕЛАЕТ ПАРНЮ МАССАЖ ДЕВ ИЛИ 2 СЕЙЧАС 099 ...   \n",
       "17 2013-10-13 01:01:00  М.37 хочу общения с д/ж и не только. смс ммс з...   \n",
       "18 2016-01-19 22:33:00  Элегантная госпожа ищет мальчика на побегушках...   \n",
       "19 2014-03-17 23:16:00  МЗ9ПОЗНАК.СО СТРОЙНОЙ ДЕВ.С ДНЕПРА ДО З0 ДЛЯ С...   \n",
       "20 2014-06-11 00:12:00  парень познакомиться с.девушкой для серьёзных ...   \n",
       "21 2014-01-23 00:17:00     увезу Д до 20 за границу стройн красив Алексей   \n",
       "22 2015-02-18 00:34:00  ищю д-ж для и от30до60 сначала смс админ 226(0...   \n",
       "23 2013-09-10 00:06:00        ласковая кошечка ищет своего ночного котика   \n",
       "24 2013-03-18 02:00:00                                         Мар Володя   \n",
       "25 2014-06-03 01:01:00  М   41.185.75. Интересные Женщ. Есть? Дн-жинск...   \n",
       "26 2016-07-31 23:19:00    М38/192/95 ищу сим дев реб не помеха 0679688357   \n",
       "27 2014-11-30 22:59:00  М 48/176 для серьёзн. отн с Ж до 49л  ДНЕПР  0...   \n",
       "28 2016-11-08 00:17:00  097 509 29 45 ИЩУ Д/Ж 35-45 ЛЕТ ДЛЯ И. О .ЗАПО...   \n",
       "29 2014-03-21 22:56:00                                             отв 80   \n",
       "30 2013-03-16 23:20:00  Д.позн.с поряд.парнем27-29 Для С/О.Ростдо1.75 ...   \n",
       "31 2013-03-03 00:58:00  . Мне 36. Хочу женщину 50-55лет. Жду смс ммс. ...   \n",
       "32 2012-02-20 23:40:00  ПАР ПРИГЛАСИТ ИЛИ ПРИЕДЕТ К  ДЕВ ДЛЯ ЛЮБВИ сей...   \n",
       "33 2015-07-03 00:45:00  п+п познакомится30-45 звонить завтра после10 ....   \n",
       "34 2015-10-10 00:52:00  Днепр Пар 32лет познак с Жен 40-50лет для встр...   \n",
       "35 2015-10-27 01:07:00                             Парень 24. Ищу девушку   \n",
       "36 2014-06-30 01:13:00  Адекватный парень с богатой фантазией пообщает...   \n",
       "37 2013-11-05 01:49:00  СамыйПервыйПакимонЧебурашкараскрылТайнуСвоегоП...   \n",
       "38 2013-10-26 00:12:00                    сделаю инт массаж М за 40 Света   \n",
       "39 2016-05-07 00:07:00  Муж.45.женат ищу дев.женщину для встреч.жду ва...   \n",
       "\n",
       "    hours  Minut  seconds  \n",
       "0       0     50        0  \n",
       "1      23     40        0  \n",
       "2       0     21        0  \n",
       "3       0     31        0  \n",
       "4      23     11        0  \n",
       "5      22     52        0  \n",
       "6       0     23        0  \n",
       "7       1     10        0  \n",
       "8       1     20        0  \n",
       "9      23     46        0  \n",
       "10      0     11        0  \n",
       "11      0     39        0  \n",
       "12      1      5        0  \n",
       "13     22     29        0  \n",
       "14      1     42        0  \n",
       "15     23     13        0  \n",
       "16     22     52        0  \n",
       "17      1      1        0  \n",
       "18     22     33        0  \n",
       "19     23     16        0  \n",
       "20      0     12        0  \n",
       "21      0     17        0  \n",
       "22      0     34        0  \n",
       "23      0      6        0  \n",
       "24      2      0        0  \n",
       "25      1      1        0  \n",
       "26     23     19        0  \n",
       "27     22     59        0  \n",
       "28      0     17        0  \n",
       "29     22     56        0  \n",
       "30     23     20        0  \n",
       "31      0     58        0  \n",
       "32     23     40        0  \n",
       "33      0     45        0  \n",
       "34      0     52        0  \n",
       "35      1      7        0  \n",
       "36      1     13        0  \n",
       "37      1     49        0  \n",
       "38      0     12        0  \n",
       "39      0      7        0  "
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time[\"hours\"]=time[\"date\"].dt.hour\n",
    "time[\"Minut\"]=time[\"date\"].dt.minute\n",
    "time[\"seconds\"]=time[\"date\"].dt.second\n",
    "time.head(40)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "da06755b-89f9-4bae-974f-db0ef742e31b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12.0"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}