Manage_time_task_3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "308abb8e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d7ea1434",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_Q1=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q1_sample.csv', \n",
    "                     date_parser=['start_time', 'end_time'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "fdec718a",
   "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>trip_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17617135</td>\n",
       "      <td>2018-01-22 20:04:31</td>\n",
       "      <td>2018-01-22 20:11:53</td>\n",
       "      <td>1131</td>\n",
       "      <td>442.0</td>\n",
       "      <td>471</td>\n",
       "      <td>Francisco Ave &amp; Foster Ave</td>\n",
       "      <td>468</td>\n",
       "      <td>Budlong Woods Library</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>17897619</td>\n",
       "      <td>2018-03-16 19:47:59</td>\n",
       "      <td>2018-03-16 20:04:00</td>\n",
       "      <td>6146</td>\n",
       "      <td>961.0</td>\n",
       "      <td>296</td>\n",
       "      <td>Broadway &amp; Belmont Ave</td>\n",
       "      <td>253</td>\n",
       "      <td>Winthrop Ave &amp; Lawrence Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>17881307</td>\n",
       "      <td>2018-03-14 18:49:20</td>\n",
       "      <td>2018-03-14 18:54:38</td>\n",
       "      <td>3847</td>\n",
       "      <td>318.0</td>\n",
       "      <td>260</td>\n",
       "      <td>Kedzie Ave &amp; Milwaukee Ave</td>\n",
       "      <td>503</td>\n",
       "      <td>Drake Ave &amp; Fullerton Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>17881130</td>\n",
       "      <td>2018-03-14 18:33:48</td>\n",
       "      <td>2018-03-14 19:07:40</td>\n",
       "      <td>1483</td>\n",
       "      <td>2,032.0</td>\n",
       "      <td>199</td>\n",
       "      <td>Wabash Ave &amp; Grand Ave</td>\n",
       "      <td>199</td>\n",
       "      <td>Wabash Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17686289</td>\n",
       "      <td>2018-02-05 17:39:14</td>\n",
       "      <td>2018-02-05 17:46:13</td>\n",
       "      <td>6391</td>\n",
       "      <td>419.0</td>\n",
       "      <td>596</td>\n",
       "      <td>Benson Ave &amp; Church St</td>\n",
       "      <td>605</td>\n",
       "      <td>University Library (NU)</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    trip_id           start_time             end_time  bikeid tripduration  \\\n",
       "0  17617135  2018-01-22 20:04:31  2018-01-22 20:11:53    1131        442.0   \n",
       "1  17897619  2018-03-16 19:47:59  2018-03-16 20:04:00    6146        961.0   \n",
       "2  17881307  2018-03-14 18:49:20  2018-03-14 18:54:38    3847        318.0   \n",
       "3  17881130  2018-03-14 18:33:48  2018-03-14 19:07:40    1483      2,032.0   \n",
       "4  17686289  2018-02-05 17:39:14  2018-02-05 17:46:13    6391        419.0   \n",
       "\n",
       "   from_station_id           from_station_name  to_station_id  \\\n",
       "0              471  Francisco Ave & Foster Ave            468   \n",
       "1              296      Broadway & Belmont Ave            253   \n",
       "2              260  Kedzie Ave & Milwaukee Ave            503   \n",
       "3              199      Wabash Ave & Grand Ave            199   \n",
       "4              596      Benson Ave & Church St            605   \n",
       "\n",
       "               to_station_name    usertype  gender  birthyear  \n",
       "0        Budlong Woods Library  Subscriber  Female     1949.0  \n",
       "1  Winthrop Ave & Lawrence Ave  Subscriber    Male     1988.0  \n",
       "2    Drake Ave & Fullerton Ave  Subscriber    Male     1987.0  \n",
       "3       Wabash Ave & Grand Ave  Subscriber    Male     1990.0  \n",
       "4      University Library (NU)  Subscriber    Male     1992.0  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_Q1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "6e16c0df",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_Q1.start_time=pd.to_datetime(bikes_Q1.start_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "388b9990",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_Q1.set_index('start_time', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d328ddfb",
   "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>trip_id</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-01-22 20:04:31</th>\n",
       "      <td>17617135</td>\n",
       "      <td>2018-01-22 20:11:53</td>\n",
       "      <td>1131</td>\n",
       "      <td>442.0</td>\n",
       "      <td>471</td>\n",
       "      <td>Francisco Ave &amp; Foster Ave</td>\n",
       "      <td>468</td>\n",
       "      <td>Budlong Woods Library</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-16 19:47:59</th>\n",
       "      <td>17897619</td>\n",
       "      <td>2018-03-16 20:04:00</td>\n",
       "      <td>6146</td>\n",
       "      <td>961.0</td>\n",
       "      <td>296</td>\n",
       "      <td>Broadway &amp; Belmont Ave</td>\n",
       "      <td>253</td>\n",
       "      <td>Winthrop Ave &amp; Lawrence Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-14 18:49:20</th>\n",
       "      <td>17881307</td>\n",
       "      <td>2018-03-14 18:54:38</td>\n",
       "      <td>3847</td>\n",
       "      <td>318.0</td>\n",
       "      <td>260</td>\n",
       "      <td>Kedzie Ave &amp; Milwaukee Ave</td>\n",
       "      <td>503</td>\n",
       "      <td>Drake Ave &amp; Fullerton Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-14 18:33:48</th>\n",
       "      <td>17881130</td>\n",
       "      <td>2018-03-14 19:07:40</td>\n",
       "      <td>1483</td>\n",
       "      <td>2,032.0</td>\n",
       "      <td>199</td>\n",
       "      <td>Wabash Ave &amp; Grand Ave</td>\n",
       "      <td>199</td>\n",
       "      <td>Wabash Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-05 17:39:14</th>\n",
       "      <td>17686289</td>\n",
       "      <td>2018-02-05 17:46:13</td>\n",
       "      <td>6391</td>\n",
       "      <td>419.0</td>\n",
       "      <td>596</td>\n",
       "      <td>Benson Ave &amp; Church St</td>\n",
       "      <td>605</td>\n",
       "      <td>University Library (NU)</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1992.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-28 17:16:53</th>\n",
       "      <td>17792363</td>\n",
       "      <td>2018-02-28 17:18:49</td>\n",
       "      <td>2401</td>\n",
       "      <td>116.0</td>\n",
       "      <td>50</td>\n",
       "      <td>Clark St &amp; Congress Pkwy</td>\n",
       "      <td>41</td>\n",
       "      <td>Federal St &amp; Polk St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-08 11:52:44</th>\n",
       "      <td>17695807</td>\n",
       "      <td>2018-02-08 11:58:13</td>\n",
       "      <td>4687</td>\n",
       "      <td>329.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Wacker Dr &amp; Washington St</td>\n",
       "      <td>39</td>\n",
       "      <td>Wabash Ave &amp; Adams St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-22 17:18:21</th>\n",
       "      <td>17938644</td>\n",
       "      <td>2018-03-22 17:24:13</td>\n",
       "      <td>6200</td>\n",
       "      <td>352.0</td>\n",
       "      <td>59</td>\n",
       "      <td>Wabash Ave &amp; Roosevelt Rd</td>\n",
       "      <td>50</td>\n",
       "      <td>Clark St &amp; Congress Pkwy</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1968.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-20 16:45:07</th>\n",
       "      <td>17738202</td>\n",
       "      <td>2018-02-20 16:57:42</td>\n",
       "      <td>757</td>\n",
       "      <td>755.0</td>\n",
       "      <td>99</td>\n",
       "      <td>Lake Shore Dr &amp; Ohio St</td>\n",
       "      <td>38</td>\n",
       "      <td>Clark St &amp; Lake St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-10 12:08:16</th>\n",
       "      <td>17566765</td>\n",
       "      <td>2018-01-10 12:20:31</td>\n",
       "      <td>4668</td>\n",
       "      <td>735.0</td>\n",
       "      <td>489</td>\n",
       "      <td>Drake Ave &amp; Addison St</td>\n",
       "      <td>500</td>\n",
       "      <td>Central Park Ave &amp; Elbridge Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1980.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>174215 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      trip_id             end_time  bikeid tripduration  \\\n",
       "start_time                                                                \n",
       "2018-01-22 20:04:31  17617135  2018-01-22 20:11:53    1131        442.0   \n",
       "2018-03-16 19:47:59  17897619  2018-03-16 20:04:00    6146        961.0   \n",
       "2018-03-14 18:49:20  17881307  2018-03-14 18:54:38    3847        318.0   \n",
       "2018-03-14 18:33:48  17881130  2018-03-14 19:07:40    1483      2,032.0   \n",
       "2018-02-05 17:39:14  17686289  2018-02-05 17:46:13    6391        419.0   \n",
       "...                       ...                  ...     ...          ...   \n",
       "2018-02-28 17:16:53  17792363  2018-02-28 17:18:49    2401        116.0   \n",
       "2018-02-08 11:52:44  17695807  2018-02-08 11:58:13    4687        329.0   \n",
       "2018-03-22 17:18:21  17938644  2018-03-22 17:24:13    6200        352.0   \n",
       "2018-02-20 16:45:07  17738202  2018-02-20 16:57:42     757        755.0   \n",
       "2018-01-10 12:08:16  17566765  2018-01-10 12:20:31    4668        735.0   \n",
       "\n",
       "                     from_station_id           from_station_name  \\\n",
       "start_time                                                         \n",
       "2018-01-22 20:04:31              471  Francisco Ave & Foster Ave   \n",
       "2018-03-16 19:47:59              296      Broadway & Belmont Ave   \n",
       "2018-03-14 18:49:20              260  Kedzie Ave & Milwaukee Ave   \n",
       "2018-03-14 18:33:48              199      Wabash Ave & Grand Ave   \n",
       "2018-02-05 17:39:14              596      Benson Ave & Church St   \n",
       "...                              ...                         ...   \n",
       "2018-02-28 17:16:53               50    Clark St & Congress Pkwy   \n",
       "2018-02-08 11:52:44               18   Wacker Dr & Washington St   \n",
       "2018-03-22 17:18:21               59   Wabash Ave & Roosevelt Rd   \n",
       "2018-02-20 16:45:07               99     Lake Shore Dr & Ohio St   \n",
       "2018-01-10 12:08:16              489      Drake Ave & Addison St   \n",
       "\n",
       "                     to_station_id                  to_station_name  \\\n",
       "start_time                                                            \n",
       "2018-01-22 20:04:31            468            Budlong Woods Library   \n",
       "2018-03-16 19:47:59            253      Winthrop Ave & Lawrence Ave   \n",
       "2018-03-14 18:49:20            503        Drake Ave & Fullerton Ave   \n",
       "2018-03-14 18:33:48            199           Wabash Ave & Grand Ave   \n",
       "2018-02-05 17:39:14            605          University Library (NU)   \n",
       "...                            ...                              ...   \n",
       "2018-02-28 17:16:53             41             Federal St & Polk St   \n",
       "2018-02-08 11:52:44             39            Wabash Ave & Adams St   \n",
       "2018-03-22 17:18:21             50         Clark St & Congress Pkwy   \n",
       "2018-02-20 16:45:07             38               Clark St & Lake St   \n",
       "2018-01-10 12:08:16            500  Central Park Ave & Elbridge Ave   \n",
       "\n",
       "                       usertype  gender  birthyear  \n",
       "start_time                                          \n",
       "2018-01-22 20:04:31  Subscriber  Female     1949.0  \n",
       "2018-03-16 19:47:59  Subscriber    Male     1988.0  \n",
       "2018-03-14 18:49:20  Subscriber    Male     1987.0  \n",
       "2018-03-14 18:33:48  Subscriber    Male     1990.0  \n",
       "2018-02-05 17:39:14  Subscriber    Male     1992.0  \n",
       "...                         ...     ...        ...  \n",
       "2018-02-28 17:16:53  Subscriber    Male     1991.0  \n",
       "2018-02-08 11:52:44  Subscriber    Male     1979.0  \n",
       "2018-03-22 17:18:21  Subscriber    Male     1968.0  \n",
       "2018-02-20 16:45:07  Subscriber    Male     1990.0  \n",
       "2018-01-10 12:08:16  Subscriber    Male     1980.0  \n",
       "\n",
       "[174215 rows x 11 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_Q1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1674022f",
   "metadata": {},
   "source": [
    "В данных имеется как дата аренды, так и её точное время начала и окончания с точностью до секунд. Примените метод pd.resample() и агрегируйте данные по дням. В качестве ответа укажите максимальное число аренд за день."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "71619d21",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_Q1.end_time=pd.to_datetime(bikes_Q1.end_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "0f79877c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "trip_id              4196\n",
       "end_time             4196\n",
       "bikeid               4196\n",
       "tripduration         4196\n",
       "from_station_id      4196\n",
       "from_station_name    4196\n",
       "to_station_id        4196\n",
       "to_station_name      4196\n",
       "usertype             4196\n",
       "gender               3940\n",
       "birthyear            3943\n",
       "dtype: int64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_Q1.resample(rule='D').count().max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "69f77db2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.resample.DatetimeIndexResampler object at 0x000001F76FE07340>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_Q1.resample(rule='D')."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1473ad72",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "5b5b272f",
   "metadata": {},
   "source": [
    "Посмотрим на распределение количества аренд для разных групп пользователей (usertype) — customers и subscribers в данных за апрель. Данные за нужный период можно подгрузить отсюда.\n",
    "\n",
    "Сделайте ресемпл по дням для каждой группы и в качестве ответа укажите число аренд за 18 апреля, сделанных пользователями типа Subscriber.\n",
    "\n",
    "Может пригодиться:\n",
    "\n",
    "функция для транспонирования .T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "44b38738",
   "metadata": {},
   "outputs": [],
   "source": [
    "usertype=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_april.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "bb29f27f",
   "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>start_time</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-04-01 00:10:23</td>\n",
       "      <td>18000531</td>\n",
       "      <td>2018-04-01 00:22:12</td>\n",
       "      <td>5065</td>\n",
       "      <td>709.0</td>\n",
       "      <td>228</td>\n",
       "      <td>Damen Ave &amp; Melrose Ave</td>\n",
       "      <td>219</td>\n",
       "      <td>Damen Ave &amp; Cortland St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-04-01 00:15:49</td>\n",
       "      <td>18000533</td>\n",
       "      <td>2018-04-01 00:19:47</td>\n",
       "      <td>4570</td>\n",
       "      <td>238.0</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>130</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-04-01 00:17:00</td>\n",
       "      <td>18000534</td>\n",
       "      <td>2018-04-01 00:22:53</td>\n",
       "      <td>1323</td>\n",
       "      <td>353.0</td>\n",
       "      <td>130</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-04-01 00:20:00</td>\n",
       "      <td>18000536</td>\n",
       "      <td>2018-04-01 00:26:22</td>\n",
       "      <td>2602</td>\n",
       "      <td>382.0</td>\n",
       "      <td>121</td>\n",
       "      <td>Blackstone Ave &amp; Hyde Park Blvd</td>\n",
       "      <td>351</td>\n",
       "      <td>Cottage Grove Ave &amp; 51st St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-04-01 00:23:19</td>\n",
       "      <td>18000538</td>\n",
       "      <td>2018-04-01 00:35:01</td>\n",
       "      <td>4213</td>\n",
       "      <td>702.0</td>\n",
       "      <td>31</td>\n",
       "      <td>Franklin St &amp; Chicago Ave</td>\n",
       "      <td>180</td>\n",
       "      <td>Ritchie Ct &amp; Banks St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.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>90139</th>\n",
       "      <td>2018-04-30 23:51:32</td>\n",
       "      <td>18241104</td>\n",
       "      <td>2018-04-30 23:53:50</td>\n",
       "      <td>3529</td>\n",
       "      <td>138.0</td>\n",
       "      <td>140</td>\n",
       "      <td>Dearborn Pkwy &amp; Delaware Pl</td>\n",
       "      <td>176</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90140</th>\n",
       "      <td>2018-04-30 23:52:19</td>\n",
       "      <td>18241105</td>\n",
       "      <td>2018-05-01 00:11:53</td>\n",
       "      <td>3274</td>\n",
       "      <td>1,174.0</td>\n",
       "      <td>176</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>374</td>\n",
       "      <td>Western Ave &amp; Walton St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90141</th>\n",
       "      <td>2018-04-30 23:58:00</td>\n",
       "      <td>18241110</td>\n",
       "      <td>2018-05-01 00:25:46</td>\n",
       "      <td>5964</td>\n",
       "      <td>1,666.0</td>\n",
       "      <td>176</td>\n",
       "      <td>Clark St &amp; Elm St</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90142</th>\n",
       "      <td>2018-04-30 23:58:04</td>\n",
       "      <td>18241111</td>\n",
       "      <td>2018-05-01 00:07:00</td>\n",
       "      <td>331</td>\n",
       "      <td>536.0</td>\n",
       "      <td>240</td>\n",
       "      <td>Sheridan Rd &amp; Irving Park Rd</td>\n",
       "      <td>115</td>\n",
       "      <td>Sheffield Ave &amp; Wellington Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90143</th>\n",
       "      <td>2018-04-30 23:59:56</td>\n",
       "      <td>18241112</td>\n",
       "      <td>2018-05-01 00:14:17</td>\n",
       "      <td>108</td>\n",
       "      <td>861.0</td>\n",
       "      <td>133</td>\n",
       "      <td>Kingsbury St &amp; Kinzie St</td>\n",
       "      <td>54</td>\n",
       "      <td>Ogden Ave &amp; Chicago Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1994.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90144 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               start_time   trip_id            end_time  bikeid tripduration  \\\n",
       "0     2018-04-01 00:10:23  18000531 2018-04-01 00:22:12    5065        709.0   \n",
       "1     2018-04-01 00:15:49  18000533 2018-04-01 00:19:47    4570        238.0   \n",
       "2     2018-04-01 00:17:00  18000534 2018-04-01 00:22:53    1323        353.0   \n",
       "3     2018-04-01 00:20:00  18000536 2018-04-01 00:26:22    2602        382.0   \n",
       "4     2018-04-01 00:23:19  18000538 2018-04-01 00:35:01    4213        702.0   \n",
       "...                   ...       ...                 ...     ...          ...   \n",
       "90139 2018-04-30 23:51:32  18241104 2018-04-30 23:53:50    3529        138.0   \n",
       "90140 2018-04-30 23:52:19  18241105 2018-05-01 00:11:53    3274      1,174.0   \n",
       "90141 2018-04-30 23:58:00  18241110 2018-05-01 00:25:46    5964      1,666.0   \n",
       "90142 2018-04-30 23:58:04  18241111 2018-05-01 00:07:00     331        536.0   \n",
       "90143 2018-04-30 23:59:56  18241112 2018-05-01 00:14:17     108        861.0   \n",
       "\n",
       "       from_station_id                from_station_name  to_station_id  \\\n",
       "0                  228          Damen Ave & Melrose Ave            219   \n",
       "1                  128          Damen Ave & Chicago Ave            130   \n",
       "2                  130          Damen Ave & Division St             69   \n",
       "3                  121  Blackstone Ave & Hyde Park Blvd            351   \n",
       "4                   31        Franklin St & Chicago Ave            180   \n",
       "...                ...                              ...            ...   \n",
       "90139              140      Dearborn Pkwy & Delaware Pl            176   \n",
       "90140              176                Clark St & Elm St            374   \n",
       "90141              176                Clark St & Elm St            128   \n",
       "90142              240     Sheridan Rd & Irving Park Rd            115   \n",
       "90143              133         Kingsbury St & Kinzie St             54   \n",
       "\n",
       "                      to_station_name    usertype  gender  birthyear  \n",
       "0             Damen Ave & Cortland St  Subscriber    Male     1983.0  \n",
       "1             Damen Ave & Division St  Subscriber    Male     1978.0  \n",
       "2              Damen Ave & Pierce Ave  Subscriber    Male     1991.0  \n",
       "3         Cottage Grove Ave & 51st St  Subscriber  Female     1992.0  \n",
       "4               Ritchie Ct & Banks St  Subscriber    Male     1985.0  \n",
       "...                               ...         ...     ...        ...  \n",
       "90139               Clark St & Elm St  Subscriber    Male     1983.0  \n",
       "90140         Western Ave & Walton St  Subscriber  Female     1991.0  \n",
       "90141         Damen Ave & Chicago Ave  Subscriber  Female     1996.0  \n",
       "90142  Sheffield Ave & Wellington Ave  Subscriber    Male     1985.0  \n",
       "90143         Ogden Ave & Chicago Ave  Subscriber    Male     1994.0  \n",
       "\n",
       "[90144 rows x 12 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usertype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "b0d3e31d",
   "metadata": {},
   "outputs": [],
   "source": [
    "usertype.start_time=pd.to_datetime(usertype.start_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "c7b5c236",
   "metadata": {},
   "outputs": [],
   "source": [
    "usertype.end_time=pd.to_datetime(usertype.end_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "f6d5c8f9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 90144 entries, 0 to 90143\n",
      "Data columns (total 12 columns):\n",
      " #   Column             Non-Null Count  Dtype         \n",
      "---  ------             --------------  -----         \n",
      " 0   start_time         90144 non-null  datetime64[ns]\n",
      " 1   trip_id            90144 non-null  int64         \n",
      " 2   end_time           90144 non-null  datetime64[ns]\n",
      " 3   bikeid             90144 non-null  int64         \n",
      " 4   tripduration       90144 non-null  object        \n",
      " 5   from_station_id    90144 non-null  int64         \n",
      " 6   from_station_name  90144 non-null  object        \n",
      " 7   to_station_id      90144 non-null  int64         \n",
      " 8   to_station_name    90144 non-null  object        \n",
      " 9   usertype           90144 non-null  object        \n",
      " 10  gender             80132 non-null  object        \n",
      " 11  birthyear          80220 non-null  float64       \n",
      "dtypes: datetime64[ns](2), float64(1), int64(4), object(5)\n",
      "memory usage: 8.3+ MB\n"
     ]
    }
   ],
   "source": [
    "usertype.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "17e45280",
   "metadata": {},
   "outputs": [],
   "source": [
    "def checker(date1, date2, z=datetime(2018,4,18)):\n",
    "    if date1<=z<=date2:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0\n",
    "\n",
    "# check('2018-04-01', '2018-04-20')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "b357c29d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "90144"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=usertype.shape[0]\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "94a833e7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2018-04-01 00:10:23\n",
       "1       2018-04-01 00:15:49\n",
       "2       2018-04-01 00:17:00\n",
       "3       2018-04-01 00:20:00\n",
       "4       2018-04-01 00:23:19\n",
       "                ...        \n",
       "90139   2018-04-30 23:51:32\n",
       "90140   2018-04-30 23:52:19\n",
       "90141   2018-04-30 23:58:00\n",
       "90142   2018-04-30 23:58:04\n",
       "90143   2018-04-30 23:59:56\n",
       "Name: start_time, Length: 90144, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usertype.start_time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "c6af8a63",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "8 [28412, 28414, 34835, 35776, 36759, 38033, 39627, 40075] 90144\n"
     ]
    }
   ],
   "source": [
    "i,j,m=0,0,[]\n",
    "while i<x:\n",
    "    if checker(usertype.start_time[i], usertype.end_time[i])==1:\n",
    "        m.append(int(i))\n",
    "        j+=1\n",
    "    i+=1\n",
    "        \n",
    "print(j, m, i)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "706eef99",
   "metadata": {},
   "outputs": [],
   "source": [
    "for d in m:\n",
    "    usertype.iloc[d]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7aede2d6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "73b97f65",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_april.csv', parse_dates=[0,2])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "id": "df745753",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 90144 entries, 0 to 90143\n",
      "Data columns (total 12 columns):\n",
      " #   Column             Non-Null Count  Dtype         \n",
      "---  ------             --------------  -----         \n",
      " 0   start_time         90144 non-null  datetime64[ns]\n",
      " 1   trip_id            90144 non-null  int64         \n",
      " 2   end_time           90144 non-null  datetime64[ns]\n",
      " 3   bikeid             90144 non-null  int64         \n",
      " 4   tripduration       90144 non-null  object        \n",
      " 5   from_station_id    90144 non-null  int64         \n",
      " 6   from_station_name  90144 non-null  object        \n",
      " 7   to_station_id      90144 non-null  int64         \n",
      " 8   to_station_name    90144 non-null  object        \n",
      " 9   usertype           90144 non-null  object        \n",
      " 10  gender             80132 non-null  object        \n",
      " 11  birthyear          80220 non-null  float64       \n",
      "dtypes: datetime64[ns](2), float64(1), int64(4), object(5)\n",
      "memory usage: 8.3+ MB\n"
     ]
    }
   ],
   "source": [
    "usertype.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "id": "38536edc",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes.set_index('start_time', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "dbfde44b",
   "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>trip_id</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-04-01 00:10:23</th>\n",
       "      <td>18000531</td>\n",
       "      <td>2018-04-01 00:22:12</td>\n",
       "      <td>5065</td>\n",
       "      <td>709.0</td>\n",
       "      <td>228</td>\n",
       "      <td>Damen Ave &amp; Melrose Ave</td>\n",
       "      <td>219</td>\n",
       "      <td>Damen Ave &amp; Cortland St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1983.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-01 00:15:49</th>\n",
       "      <td>18000533</td>\n",
       "      <td>2018-04-01 00:19:47</td>\n",
       "      <td>4570</td>\n",
       "      <td>238.0</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>130</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-01 00:17:00</th>\n",
       "      <td>18000534</td>\n",
       "      <td>2018-04-01 00:22:53</td>\n",
       "      <td>1323</td>\n",
       "      <td>353.0</td>\n",
       "      <td>130</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-01 00:20:00</th>\n",
       "      <td>18000536</td>\n",
       "      <td>2018-04-01 00:26:22</td>\n",
       "      <td>2602</td>\n",
       "      <td>382.0</td>\n",
       "      <td>121</td>\n",
       "      <td>Blackstone Ave &amp; Hyde Park Blvd</td>\n",
       "      <td>351</td>\n",
       "      <td>Cottage Grove Ave &amp; 51st St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-01 00:23:19</th>\n",
       "      <td>18000538</td>\n",
       "      <td>2018-04-01 00:35:01</td>\n",
       "      <td>4213</td>\n",
       "      <td>702.0</td>\n",
       "      <td>31</td>\n",
       "      <td>Franklin St &amp; Chicago Ave</td>\n",
       "      <td>180</td>\n",
       "      <td>Ritchie Ct &amp; Banks St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      trip_id            end_time  bikeid tripduration  \\\n",
       "start_time                                                               \n",
       "2018-04-01 00:10:23  18000531 2018-04-01 00:22:12    5065        709.0   \n",
       "2018-04-01 00:15:49  18000533 2018-04-01 00:19:47    4570        238.0   \n",
       "2018-04-01 00:17:00  18000534 2018-04-01 00:22:53    1323        353.0   \n",
       "2018-04-01 00:20:00  18000536 2018-04-01 00:26:22    2602        382.0   \n",
       "2018-04-01 00:23:19  18000538 2018-04-01 00:35:01    4213        702.0   \n",
       "\n",
       "                     from_station_id                from_station_name  \\\n",
       "start_time                                                              \n",
       "2018-04-01 00:10:23              228          Damen Ave & Melrose Ave   \n",
       "2018-04-01 00:15:49              128          Damen Ave & Chicago Ave   \n",
       "2018-04-01 00:17:00              130          Damen Ave & Division St   \n",
       "2018-04-01 00:20:00              121  Blackstone Ave & Hyde Park Blvd   \n",
       "2018-04-01 00:23:19               31        Franklin St & Chicago Ave   \n",
       "\n",
       "                     to_station_id              to_station_name    usertype  \\\n",
       "start_time                                                                    \n",
       "2018-04-01 00:10:23            219      Damen Ave & Cortland St  Subscriber   \n",
       "2018-04-01 00:15:49            130      Damen Ave & Division St  Subscriber   \n",
       "2018-04-01 00:17:00             69       Damen Ave & Pierce Ave  Subscriber   \n",
       "2018-04-01 00:20:00            351  Cottage Grove Ave & 51st St  Subscriber   \n",
       "2018-04-01 00:23:19            180        Ritchie Ct & Banks St  Subscriber   \n",
       "\n",
       "                     gender  birthyear  \n",
       "start_time                              \n",
       "2018-04-01 00:10:23    Male     1983.0  \n",
       "2018-04-01 00:15:49    Male     1978.0  \n",
       "2018-04-01 00:17:00    Male     1991.0  \n",
       "2018-04-01 00:20:00  Female     1992.0  \n",
       "2018-04-01 00:23:19    Male     1985.0  "
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "id": "f90a2b4f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "usertype    start_time\n",
       "Customer    2018-04-01     239\n",
       "            2018-04-02     166\n",
       "            2018-04-03      31\n",
       "            2018-04-04      82\n",
       "            2018-04-05      90\n",
       "            2018-04-06     124\n",
       "            2018-04-07     335\n",
       "            2018-04-08     242\n",
       "            2018-04-09      39\n",
       "            2018-04-10     117\n",
       "            2018-04-11     305\n",
       "            2018-04-12     491\n",
       "            2018-04-13     208\n",
       "            2018-04-14      41\n",
       "            2018-04-15      41\n",
       "            2018-04-16      40\n",
       "            2018-04-17     121\n",
       "            2018-04-18      45\n",
       "            2018-04-19     164\n",
       "            2018-04-20     562\n",
       "            2018-04-21     655\n",
       "            2018-04-22    1055\n",
       "            2018-04-23     345\n",
       "            2018-04-24     367\n",
       "            2018-04-25     220\n",
       "            2018-04-26     544\n",
       "            2018-04-27     416\n",
       "            2018-04-28     713\n",
       "            2018-04-29    1082\n",
       "            2018-04-30    1098\n",
       "Subscriber  2018-04-01     825\n",
       "            2018-04-02    2841\n",
       "            2018-04-03    1873\n",
       "            2018-04-04    2253\n",
       "            2018-04-05    2502\n",
       "            2018-04-06    2520\n",
       "            2018-04-07    1416\n",
       "            2018-04-08    1252\n",
       "            2018-04-09    1798\n",
       "            2018-04-10    3114\n",
       "            2018-04-11    3815\n",
       "            2018-04-12    4155\n",
       "            2018-04-13    2811\n",
       "            2018-04-14     611\n",
       "            2018-04-15     528\n",
       "            2018-04-16    1960\n",
       "            2018-04-17    3090\n",
       "            2018-04-18    2196\n",
       "            2018-04-19    3296\n",
       "            2018-04-20    3747\n",
       "            2018-04-21    1845\n",
       "            2018-04-22    2241\n",
       "            2018-04-23    3930\n",
       "            2018-04-24    4356\n",
       "            2018-04-25    3959\n",
       "            2018-04-26    4398\n",
       "            2018-04-27    3424\n",
       "            2018-04-28    2015\n",
       "            2018-04-29    2114\n",
       "            2018-04-30    5281\n",
       "Name: trip_id, dtype: int64"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes.groupby('usertype')\\\n",
    "     .trip_id\\\n",
    "     .resample('1d')\\\n",
    "    .count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "id": "c89733a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q2_sample_apr.csv', parse_dates=[1,2])\n",
    "df2=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q2_sample_may.csv', parse_dates=[1,2])\n",
    "df3=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q2_sample_jun.csv', parse_dates=[1,2])\n",
    "df4=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q3_sample_july.csv', parse_dates=[1,2])\n",
    "df5=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q3_sample_aug.csv', parse_dates=[1,2])\n",
    "df6=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q3_sample_sep.csv', parse_dates=[1,2])\n",
    "df7=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q4_sample_oct.csv', parse_dates=[1,2])\n",
    "df8=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q4_sample_nov.csv', parse_dates=[1,2])\n",
    "df9=pd.read_csv('https://stepik.org/media/attachments/lesson/367415/bikes_q4_sample_dec.csv', parse_dates=[1,2])\n",
    "frames = [df1, df2, df3, df4, df5, df6, df7, df8, df9]\n",
    "bikes = pd.concat(frames)\n",
    "\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87e0c39e",
   "metadata": {},
   "source": [
    "Объедините сэмплы данных за нужные месяцы в один общий датасет bikes. Сделайте преобразование по дням для каждой группы пользователей (usertype), затем выберите дни, в которые число аренд, сделанных customers, было больше, чем у subscribers."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2f9229d2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ee8b86db",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "id": "11a9cf5b",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes.set_index('start_time', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "id": "a030221e",
   "metadata": {},
   "outputs": [],
   "source": [
    "rents_byday_bytype=bikes.groupby('usertype').resample('1d').size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "id": "e1ba730a",
   "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>start_time</th>\n",
       "      <th>2018-04-01</th>\n",
       "      <th>2018-04-02</th>\n",
       "      <th>2018-04-03</th>\n",
       "      <th>2018-04-04</th>\n",
       "      <th>2018-04-05</th>\n",
       "      <th>2018-04-06</th>\n",
       "      <th>2018-04-07</th>\n",
       "      <th>2018-04-08</th>\n",
       "      <th>2018-04-09</th>\n",
       "      <th>2018-04-10</th>\n",
       "      <th>...</th>\n",
       "      <th>2018-12-22</th>\n",
       "      <th>2018-12-23</th>\n",
       "      <th>2018-12-24</th>\n",
       "      <th>2018-12-25</th>\n",
       "      <th>2018-12-26</th>\n",
       "      <th>2018-12-27</th>\n",
       "      <th>2018-12-28</th>\n",
       "      <th>2018-12-29</th>\n",
       "      <th>2018-12-30</th>\n",
       "      <th>2018-12-31</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usertype</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Customer</th>\n",
       "      <td>166</td>\n",
       "      <td>110</td>\n",
       "      <td>19</td>\n",
       "      <td>53</td>\n",
       "      <td>62</td>\n",
       "      <td>82</td>\n",
       "      <td>234</td>\n",
       "      <td>168</td>\n",
       "      <td>25</td>\n",
       "      <td>84</td>\n",
       "      <td>...</td>\n",
       "      <td>75</td>\n",
       "      <td>90</td>\n",
       "      <td>64</td>\n",
       "      <td>135</td>\n",
       "      <td>115</td>\n",
       "      <td>28</td>\n",
       "      <td>65</td>\n",
       "      <td>23</td>\n",
       "      <td>55</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Subscriber</th>\n",
       "      <td>549</td>\n",
       "      <td>1865</td>\n",
       "      <td>1276</td>\n",
       "      <td>1501</td>\n",
       "      <td>1637</td>\n",
       "      <td>1682</td>\n",
       "      <td>1004</td>\n",
       "      <td>818</td>\n",
       "      <td>1186</td>\n",
       "      <td>2068</td>\n",
       "      <td>...</td>\n",
       "      <td>579</td>\n",
       "      <td>455</td>\n",
       "      <td>479</td>\n",
       "      <td>255</td>\n",
       "      <td>977</td>\n",
       "      <td>684</td>\n",
       "      <td>872</td>\n",
       "      <td>350</td>\n",
       "      <td>385</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 275 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "start_time  2018-04-01  2018-04-02  2018-04-03  2018-04-04  2018-04-05  \\\n",
       "usertype                                                                 \n",
       "Customer           166         110          19          53          62   \n",
       "Subscriber         549        1865        1276        1501        1637   \n",
       "\n",
       "start_time  2018-04-06  2018-04-07  2018-04-08  2018-04-09  2018-04-10  ...  \\\n",
       "usertype                                                                ...   \n",
       "Customer            82         234         168          25          84  ...   \n",
       "Subscriber        1682        1004         818        1186        2068  ...   \n",
       "\n",
       "start_time  2018-12-22  2018-12-23  2018-12-24  2018-12-25  2018-12-26  \\\n",
       "usertype                                                                 \n",
       "Customer            75          90          64         135         115   \n",
       "Subscriber         579         455         479         255         977   \n",
       "\n",
       "start_time  2018-12-27  2018-12-28  2018-12-29  2018-12-30  2018-12-31  \n",
       "usertype                                                                \n",
       "Customer            28          65          23          55          27  \n",
       "Subscriber         684         872         350         385         352  \n",
       "\n",
       "[2 rows x 275 columns]"
      ]
     },
     "execution_count": 202,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rents_byday_bytype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fd62d53f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "id": "bb70dc4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "new=rents_byday_bytype.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "id": "accef89f",
   "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>usertype</th>\n",
       "      <th>Customer</th>\n",
       "      <th>Subscriber</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-04-01</th>\n",
       "      <td>166</td>\n",
       "      <td>549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-02</th>\n",
       "      <td>110</td>\n",
       "      <td>1865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-03</th>\n",
       "      <td>19</td>\n",
       "      <td>1276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-04</th>\n",
       "      <td>53</td>\n",
       "      <td>1501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-05</th>\n",
       "      <td>62</td>\n",
       "      <td>1637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-27</th>\n",
       "      <td>28</td>\n",
       "      <td>684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-28</th>\n",
       "      <td>65</td>\n",
       "      <td>872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-29</th>\n",
       "      <td>23</td>\n",
       "      <td>350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-30</th>\n",
       "      <td>55</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-12-31</th>\n",
       "      <td>27</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>275 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "usertype    Customer  Subscriber\n",
       "start_time                      \n",
       "2018-04-01       166         549\n",
       "2018-04-02       110        1865\n",
       "2018-04-03        19        1276\n",
       "2018-04-04        53        1501\n",
       "2018-04-05        62        1637\n",
       "...              ...         ...\n",
       "2018-12-27        28         684\n",
       "2018-12-28        65         872\n",
       "2018-12-29        23         350\n",
       "2018-12-30        55         385\n",
       "2018-12-31        27         352\n",
       "\n",
       "[275 rows x 2 columns]"
      ]
     },
     "execution_count": 204,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "id": "ef8fec0c",
   "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>usertype</th>\n",
       "      <th>Customer</th>\n",
       "      <th>Subscriber</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-05-27</th>\n",
       "      <td>3263</td>\n",
       "      <td>2449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-02</th>\n",
       "      <td>2752</td>\n",
       "      <td>2183</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "usertype    Customer  Subscriber\n",
       "start_time                      \n",
       "2018-05-27      3263        2449\n",
       "2018-09-02      2752        2183"
      ]
     },
     "execution_count": 205,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new[new.Customer>new.Subscriber]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "38b29503",
   "metadata": {},
   "source": [
    "Еще один плюс использования дат в качестве индексов – возможность выбрать данные за интересующий нас промежуток времени. В переменную bikes_summer сохраните наблюдения с 1 июня по 31 августа. Затем запишите в top_destination наиболее популярный пункт назначения (его название). Агрегируйте данные по дням и определите, в какой день в полученный пункт (top_destination) было совершено меньше всего поездок. Дату сохраните в bad_day, отформатировав timestamp с помощью .strftime('%Y-%m-%d').\n",
    "\n",
    "Могут пригодиться:\n",
    "\n",
    "loc\n",
    "strftime\n",
    "idxmin, idxmax\n",
    "size\n",
    "query\n",
    "Полный датафрейм уже сохранен как bikes, еще раз объединять данные в этом степе не нужно :) В качестве индексов используется start_time в нужном формате."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "id": "f6123341",
   "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>trip_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18000534</td>\n",
       "      <td>2018-04-01 00:17:00</td>\n",
       "      <td>2018-04-01 00:22:53</td>\n",
       "      <td>1323</td>\n",
       "      <td>353.0</td>\n",
       "      <td>130</td>\n",
       "      <td>Damen Ave &amp; Division St</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1991.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18000536</td>\n",
       "      <td>2018-04-01 00:20:00</td>\n",
       "      <td>2018-04-01 00:26:22</td>\n",
       "      <td>2602</td>\n",
       "      <td>382.0</td>\n",
       "      <td>121</td>\n",
       "      <td>Blackstone Ave &amp; Hyde Park Blvd</td>\n",
       "      <td>351</td>\n",
       "      <td>Cottage Grove Ave &amp; 51st St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1992.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18000538</td>\n",
       "      <td>2018-04-01 00:23:19</td>\n",
       "      <td>2018-04-01 00:35:01</td>\n",
       "      <td>4213</td>\n",
       "      <td>702.0</td>\n",
       "      <td>31</td>\n",
       "      <td>Franklin St &amp; Chicago Ave</td>\n",
       "      <td>180</td>\n",
       "      <td>Ritchie Ct &amp; Banks St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1985.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18000540</td>\n",
       "      <td>2018-04-01 00:24:46</td>\n",
       "      <td>2018-04-01 00:44:23</td>\n",
       "      <td>6401</td>\n",
       "      <td>1,177.0</td>\n",
       "      <td>596</td>\n",
       "      <td>Benson Ave &amp; Church St</td>\n",
       "      <td>517</td>\n",
       "      <td>Clark St &amp; Jarvis Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1974.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18000541</td>\n",
       "      <td>2018-04-01 00:26:04</td>\n",
       "      <td>2018-04-01 00:31:05</td>\n",
       "      <td>6333</td>\n",
       "      <td>301.0</td>\n",
       "      <td>145</td>\n",
       "      <td>Mies van der Rohe Way &amp; Chestnut St</td>\n",
       "      <td>24</td>\n",
       "      <td>Fairbanks Ct &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1984.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    trip_id          start_time            end_time  bikeid tripduration  \\\n",
       "0  18000534 2018-04-01 00:17:00 2018-04-01 00:22:53    1323        353.0   \n",
       "1  18000536 2018-04-01 00:20:00 2018-04-01 00:26:22    2602        382.0   \n",
       "2  18000538 2018-04-01 00:23:19 2018-04-01 00:35:01    4213        702.0   \n",
       "3  18000540 2018-04-01 00:24:46 2018-04-01 00:44:23    6401      1,177.0   \n",
       "4  18000541 2018-04-01 00:26:04 2018-04-01 00:31:05    6333        301.0   \n",
       "\n",
       "   from_station_id                    from_station_name  to_station_id  \\\n",
       "0              130              Damen Ave & Division St             69   \n",
       "1              121      Blackstone Ave & Hyde Park Blvd            351   \n",
       "2               31            Franklin St & Chicago Ave            180   \n",
       "3              596               Benson Ave & Church St            517   \n",
       "4              145  Mies van der Rohe Way & Chestnut St             24   \n",
       "\n",
       "               to_station_name    usertype  gender  birthyear  \n",
       "0       Damen Ave & Pierce Ave  Subscriber    Male     1991.0  \n",
       "1  Cottage Grove Ave & 51st St  Subscriber  Female     1992.0  \n",
       "2        Ritchie Ct & Banks St  Subscriber    Male     1985.0  \n",
       "3        Clark St & Jarvis Ave  Subscriber    Male     1974.0  \n",
       "4     Fairbanks Ct & Grand Ave  Subscriber    Male     1984.0  "
      ]
     },
     "execution_count": 208,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "id": "f8b46530",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_summer=bikes.query('\"2018-06-01\"<=start_time<=\"2018-08-31\"')    # 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "id": "7748c360",
   "metadata": {},
   "outputs": [],
   "source": [
    "prem=bikes_summer.groupby('to_station_name', as_index=False)\\\n",
    "            .agg({'to_station_id':'count'})\\\n",
    "            .sort_values('to_station_id',ascending=False)\\\n",
    "            #.max()[0]\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "id": "047e0a83",
   "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>to_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Streeter Dr &amp; Grand Ave</td>\n",
       "      <td>13517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>Lake Shore Dr &amp; North Blvd</td>\n",
       "      <td>7244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Canal St &amp; Adams St</td>\n",
       "      <td>6380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>Theater on the Lake</td>\n",
       "      <td>6155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>Millennium Park</td>\n",
       "      <td>5329</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                to_station_name  to_station_id\n",
       "510     Streeter Dr & Grand Ave          13517\n",
       "307  Lake Shore Dr & North Blvd           7244\n",
       "81          Canal St & Adams St           6380\n",
       "512         Theater on the Lake           6155\n",
       "375             Millennium Park           5329"
      ]
     },
     "execution_count": 242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prem.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "id": "a3c8cf6a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Streeter Dr & Grand Ave'"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prem.reset_index(drop=True).to_station_name[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "id": "4653f548",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Streeter Dr & Grand Ave'"
      ]
     },
     "execution_count": 254,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_destination=bikes_summer.groupby('to_station_name', as_index=False)\\\n",
    "            .agg({'to_station_id':'count'})\\\n",
    "            .sort_values('to_station_id',ascending=False)\\\n",
    "            .reset_index(drop=True).to_station_name[0]          #    2\n",
    "top_destination"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "id": "885ab7d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_summer.set_index('start_time', inplace=True)     #     3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "id": "f7eaade9",
   "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>trip_id</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>start_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-06-01 00:04:40</th>\n",
       "      <td>18709077</td>\n",
       "      <td>2018-06-01 00:06:47</td>\n",
       "      <td>3155</td>\n",
       "      <td>127.0</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>214</td>\n",
       "      <td>Damen Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01 00:06:08</th>\n",
       "      <td>18709080</td>\n",
       "      <td>2018-06-01 00:24:18</td>\n",
       "      <td>2807</td>\n",
       "      <td>1,090.0</td>\n",
       "      <td>258</td>\n",
       "      <td>Logan Blvd &amp; Elston Ave</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01 00:08:01</th>\n",
       "      <td>18709086</td>\n",
       "      <td>2018-06-01 00:32:55</td>\n",
       "      <td>2737</td>\n",
       "      <td>1,494.0</td>\n",
       "      <td>337</td>\n",
       "      <td>Clark St &amp; Chicago Ave</td>\n",
       "      <td>225</td>\n",
       "      <td>Halsted St &amp; Dickens Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01 00:09:02</th>\n",
       "      <td>18709091</td>\n",
       "      <td>2018-06-01 00:19:21</td>\n",
       "      <td>6089</td>\n",
       "      <td>619.0</td>\n",
       "      <td>210</td>\n",
       "      <td>Ashland Ave &amp; Division St</td>\n",
       "      <td>56</td>\n",
       "      <td>Desplaines St &amp; Kinzie St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01 00:09:28</th>\n",
       "      <td>18709092</td>\n",
       "      <td>2018-06-01 00:14:44</td>\n",
       "      <td>2352</td>\n",
       "      <td>316.0</td>\n",
       "      <td>240</td>\n",
       "      <td>Sheridan Rd &amp; Irving Park Rd</td>\n",
       "      <td>303</td>\n",
       "      <td>Broadway &amp; Cornelia Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1997.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      trip_id            end_time  bikeid tripduration  \\\n",
       "start_time                                                               \n",
       "2018-06-01 00:04:40  18709077 2018-06-01 00:06:47    3155        127.0   \n",
       "2018-06-01 00:06:08  18709080 2018-06-01 00:24:18    2807      1,090.0   \n",
       "2018-06-01 00:08:01  18709086 2018-06-01 00:32:55    2737      1,494.0   \n",
       "2018-06-01 00:09:02  18709091 2018-06-01 00:19:21    6089        619.0   \n",
       "2018-06-01 00:09:28  18709092 2018-06-01 00:14:44    2352        316.0   \n",
       "\n",
       "                     from_station_id             from_station_name  \\\n",
       "start_time                                                           \n",
       "2018-06-01 00:04:40              128       Damen Ave & Chicago Ave   \n",
       "2018-06-01 00:06:08              258       Logan Blvd & Elston Ave   \n",
       "2018-06-01 00:08:01              337        Clark St & Chicago Ave   \n",
       "2018-06-01 00:09:02              210     Ashland Ave & Division St   \n",
       "2018-06-01 00:09:28              240  Sheridan Rd & Irving Park Rd   \n",
       "\n",
       "                     to_station_id            to_station_name    usertype  \\\n",
       "start_time                                                                  \n",
       "2018-06-01 00:04:40            214      Damen Ave & Grand Ave  Subscriber   \n",
       "2018-06-01 00:06:08             69     Damen Ave & Pierce Ave    Customer   \n",
       "2018-06-01 00:08:01            225   Halsted St & Dickens Ave    Customer   \n",
       "2018-06-01 00:09:02             56  Desplaines St & Kinzie St  Subscriber   \n",
       "2018-06-01 00:09:28            303    Broadway & Cornelia Ave  Subscriber   \n",
       "\n",
       "                     gender  birthyear  \n",
       "start_time                              \n",
       "2018-06-01 00:04:40  Female     1978.0  \n",
       "2018-06-01 00:06:08     NaN        NaN  \n",
       "2018-06-01 00:08:01    Male     1988.0  \n",
       "2018-06-01 00:09:02    Male     1987.0  \n",
       "2018-06-01 00:09:28    Male     1997.0  "
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_summer.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "id": "8373c974",
   "metadata": {},
   "outputs": [],
   "source": [
    "bad_day=bikes_summer.query('to_station_name==@top_destination')\\\n",
    "                    .resample('1d')\\\n",
    "                    .count()\\\n",
    "                    .sort_values('to_station_id')\\\n",
    "                    .idxmin()[0]\\\n",
    "                    .strftime('%Y-%m-%d')       # 4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "id": "6a6ccbfb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2018-06-21'"
      ]
     },
     "execution_count": 275,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bad_day"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e72b67c6",
   "metadata": {},
   "source": [
    "Куда больше всего ездят на выходных? Туда же, куда и в будние дни, или в другие пункты назначения?\n",
    "Используя данные за период с 1 июня по 31 августа, выберите верные утверждения.\n",
    "df['weekday'] = df['datetime'].dt.day_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "id": "47eaa59f",
   "metadata": {},
   "outputs": [],
   "source": [
    "bikes_summer=bikes.query('\"2018-06-01\"<=start_time<=\"2018-08-31\"')    # 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "id": "6ff9c0b2",
   "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>trip_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18709077</td>\n",
       "      <td>2018-06-01 00:04:40</td>\n",
       "      <td>2018-06-01 00:06:47</td>\n",
       "      <td>3155</td>\n",
       "      <td>127.0</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>214</td>\n",
       "      <td>Damen Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18709080</td>\n",
       "      <td>2018-06-01 00:06:08</td>\n",
       "      <td>2018-06-01 00:24:18</td>\n",
       "      <td>2807</td>\n",
       "      <td>1,090.0</td>\n",
       "      <td>258</td>\n",
       "      <td>Logan Blvd &amp; Elston Ave</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18709086</td>\n",
       "      <td>2018-06-01 00:08:01</td>\n",
       "      <td>2018-06-01 00:32:55</td>\n",
       "      <td>2737</td>\n",
       "      <td>1,494.0</td>\n",
       "      <td>337</td>\n",
       "      <td>Clark St &amp; Chicago Ave</td>\n",
       "      <td>225</td>\n",
       "      <td>Halsted St &amp; Dickens Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18709091</td>\n",
       "      <td>2018-06-01 00:09:02</td>\n",
       "      <td>2018-06-01 00:19:21</td>\n",
       "      <td>6089</td>\n",
       "      <td>619.0</td>\n",
       "      <td>210</td>\n",
       "      <td>Ashland Ave &amp; Division St</td>\n",
       "      <td>56</td>\n",
       "      <td>Desplaines St &amp; Kinzie St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18709092</td>\n",
       "      <td>2018-06-01 00:09:28</td>\n",
       "      <td>2018-06-01 00:14:44</td>\n",
       "      <td>2352</td>\n",
       "      <td>316.0</td>\n",
       "      <td>240</td>\n",
       "      <td>Sheridan Rd &amp; Irving Park Rd</td>\n",
       "      <td>303</td>\n",
       "      <td>Broadway &amp; Cornelia Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1997.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    trip_id          start_time            end_time  bikeid tripduration  \\\n",
       "0  18709077 2018-06-01 00:04:40 2018-06-01 00:06:47    3155        127.0   \n",
       "1  18709080 2018-06-01 00:06:08 2018-06-01 00:24:18    2807      1,090.0   \n",
       "2  18709086 2018-06-01 00:08:01 2018-06-01 00:32:55    2737      1,494.0   \n",
       "3  18709091 2018-06-01 00:09:02 2018-06-01 00:19:21    6089        619.0   \n",
       "4  18709092 2018-06-01 00:09:28 2018-06-01 00:14:44    2352        316.0   \n",
       "\n",
       "   from_station_id             from_station_name  to_station_id  \\\n",
       "0              128       Damen Ave & Chicago Ave            214   \n",
       "1              258       Logan Blvd & Elston Ave             69   \n",
       "2              337        Clark St & Chicago Ave            225   \n",
       "3              210     Ashland Ave & Division St             56   \n",
       "4              240  Sheridan Rd & Irving Park Rd            303   \n",
       "\n",
       "             to_station_name    usertype  gender  birthyear  \n",
       "0      Damen Ave & Grand Ave  Subscriber  Female     1978.0  \n",
       "1     Damen Ave & Pierce Ave    Customer     NaN        NaN  \n",
       "2   Halsted St & Dickens Ave    Customer    Male     1988.0  \n",
       "3  Desplaines St & Kinzie St  Subscriber    Male     1987.0  \n",
       "4    Broadway & Cornelia Ave  Subscriber    Male     1997.0  "
      ]
     },
     "execution_count": 288,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_summer.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "id": "f91f1615",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\grebe\\AppData\\Local\\Temp/ipykernel_19388/3637640514.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  bikes_summer['weekday'] = bikes_summer[['start_time']].apply(lambda x: dt.datetime.strftime(x['start_time'], '%A'), axis=1)\n"
     ]
    }
   ],
   "source": [
    "# bikes_summer.loc[bikes_summer['start_time'].dt.day_name]\n",
    "import datetime as dt\n",
    "bikes_summer['weekday'] = bikes_summer[['start_time']].apply(lambda x: dt.datetime.strftime(x['start_time'], '%A'), axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "id": "18088042",
   "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>trip_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>bikeid</th>\n",
       "      <th>tripduration</th>\n",
       "      <th>from_station_id</th>\n",
       "      <th>from_station_name</th>\n",
       "      <th>to_station_id</th>\n",
       "      <th>to_station_name</th>\n",
       "      <th>usertype</th>\n",
       "      <th>gender</th>\n",
       "      <th>birthyear</th>\n",
       "      <th>week_day_name</th>\n",
       "      <th>weekday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18709077</td>\n",
       "      <td>2018-06-01 00:04:40</td>\n",
       "      <td>2018-06-01 00:06:47</td>\n",
       "      <td>3155</td>\n",
       "      <td>127.0</td>\n",
       "      <td>128</td>\n",
       "      <td>Damen Ave &amp; Chicago Ave</td>\n",
       "      <td>214</td>\n",
       "      <td>Damen Ave &amp; Grand Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Female</td>\n",
       "      <td>1978.0</td>\n",
       "      <td>&lt;bound method PandasDelegate._add_delegate_acc...</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18709080</td>\n",
       "      <td>2018-06-01 00:06:08</td>\n",
       "      <td>2018-06-01 00:24:18</td>\n",
       "      <td>2807</td>\n",
       "      <td>1,090.0</td>\n",
       "      <td>258</td>\n",
       "      <td>Logan Blvd &amp; Elston Ave</td>\n",
       "      <td>69</td>\n",
       "      <td>Damen Ave &amp; Pierce Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;bound method PandasDelegate._add_delegate_acc...</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>18709086</td>\n",
       "      <td>2018-06-01 00:08:01</td>\n",
       "      <td>2018-06-01 00:32:55</td>\n",
       "      <td>2737</td>\n",
       "      <td>1,494.0</td>\n",
       "      <td>337</td>\n",
       "      <td>Clark St &amp; Chicago Ave</td>\n",
       "      <td>225</td>\n",
       "      <td>Halsted St &amp; Dickens Ave</td>\n",
       "      <td>Customer</td>\n",
       "      <td>Male</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>&lt;bound method PandasDelegate._add_delegate_acc...</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>18709091</td>\n",
       "      <td>2018-06-01 00:09:02</td>\n",
       "      <td>2018-06-01 00:19:21</td>\n",
       "      <td>6089</td>\n",
       "      <td>619.0</td>\n",
       "      <td>210</td>\n",
       "      <td>Ashland Ave &amp; Division St</td>\n",
       "      <td>56</td>\n",
       "      <td>Desplaines St &amp; Kinzie St</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>&lt;bound method PandasDelegate._add_delegate_acc...</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18709092</td>\n",
       "      <td>2018-06-01 00:09:28</td>\n",
       "      <td>2018-06-01 00:14:44</td>\n",
       "      <td>2352</td>\n",
       "      <td>316.0</td>\n",
       "      <td>240</td>\n",
       "      <td>Sheridan Rd &amp; Irving Park Rd</td>\n",
       "      <td>303</td>\n",
       "      <td>Broadway &amp; Cornelia Ave</td>\n",
       "      <td>Subscriber</td>\n",
       "      <td>Male</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>&lt;bound method PandasDelegate._add_delegate_acc...</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    trip_id          start_time            end_time  bikeid tripduration  \\\n",
       "0  18709077 2018-06-01 00:04:40 2018-06-01 00:06:47    3155        127.0   \n",
       "1  18709080 2018-06-01 00:06:08 2018-06-01 00:24:18    2807      1,090.0   \n",
       "2  18709086 2018-06-01 00:08:01 2018-06-01 00:32:55    2737      1,494.0   \n",
       "3  18709091 2018-06-01 00:09:02 2018-06-01 00:19:21    6089        619.0   \n",
       "4  18709092 2018-06-01 00:09:28 2018-06-01 00:14:44    2352        316.0   \n",
       "\n",
       "   from_station_id             from_station_name  to_station_id  \\\n",
       "0              128       Damen Ave & Chicago Ave            214   \n",
       "1              258       Logan Blvd & Elston Ave             69   \n",
       "2              337        Clark St & Chicago Ave            225   \n",
       "3              210     Ashland Ave & Division St             56   \n",
       "4              240  Sheridan Rd & Irving Park Rd            303   \n",
       "\n",
       "             to_station_name    usertype  gender  birthyear  \\\n",
       "0      Damen Ave & Grand Ave  Subscriber  Female     1978.0   \n",
       "1     Damen Ave & Pierce Ave    Customer     NaN        NaN   \n",
       "2   Halsted St & Dickens Ave    Customer    Male     1988.0   \n",
       "3  Desplaines St & Kinzie St  Subscriber    Male     1987.0   \n",
       "4    Broadway & Cornelia Ave  Subscriber    Male     1997.0   \n",
       "\n",
       "                                       week_day_name weekday  \n",
       "0  <bound method PandasDelegate._add_delegate_acc...  Friday  \n",
       "1  <bound method PandasDelegate._add_delegate_acc...  Friday  \n",
       "2  <bound method PandasDelegate._add_delegate_acc...  Friday  \n",
       "3  <bound method PandasDelegate._add_delegate_acc...  Friday  \n",
       "4  <bound method PandasDelegate._add_delegate_acc...  Friday  "
      ]
     },
     "execution_count": 294,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_summer.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 310,
   "id": "8ae3cb01",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "weekday    to_station_name         \n",
       "Monday     Racine Ave & 65th St           1\n",
       "           Marshfield Ave & 59th St       1\n",
       "Wednesday  Wolcott Ave & Fargo Ave        1\n",
       "           Western Blvd & 48th Pl         1\n",
       "           Throop St & 52nd St            1\n",
       "                                       ... \n",
       "Monday     Canal St & Adams St         1276\n",
       "Thursday   Streeter Dr & Grand Ave     1482\n",
       "Monday     Streeter Dr & Grand Ave     1503\n",
       "Friday     Streeter Dr & Grand Ave     1603\n",
       "Wednesday  Streeter Dr & Grand Ave     1669\n",
       "Name: to_station_id, Length: 2783, dtype: int64"
      ]
     },
     "execution_count": 310,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bikes_summer.groupby(['weekday','to_station_name']).to_station_id.count().loc[['Monday','Tuesday','Wednesday','Thursday','Friday']].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4fc26078",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d29d26e7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f1266877",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d7ae3528",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}