work_with_pandas.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "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></th>\n",
       "      <th>Film</th>\n",
       "      <th>Durations</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Channel</th>\n",
       "      <th>Genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Fox</th>\n",
       "      <th>Drama</th>\n",
       "      <td>Suits</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>Bones</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Discovery</th>\n",
       "      <th>Documentary</th>\n",
       "      <td>Salvage Hunters</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Gold Rush</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Chasing Ocean Giants</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2+2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Die Hard</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Film  Durations\n",
       "Channel   Genre                                       \n",
       "Fox       Drama                       Suits         65\n",
       "          Drama                       Bones         59\n",
       "Discovery Documentary       Salvage Hunters         60\n",
       "          Documentary             Gold Rush         75\n",
       "          Documentary  Chasing Ocean Giants         59\n",
       "2+2       Action                   Die Hard         98"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df1 = pd.DataFrame({\n",
    "                    \"Channel\":['Fox','Fox','Discovery','Discovery','Discovery','2+2'],\n",
    "                    \"Genre\":['Drama','Drama', 'Documentary', 'Documentary', 'Documentary', 'Action'],\n",
    "                    \"Film\":['Suits','Bones','Salvage Hunters','Gold Rush','Chasing Ocean Giants','Die Hard'],\n",
    "                    \"Durations\":[65, 59, 60, 75, 59, 98],\n",
    "                    }).set_index(['Channel','Genre'])\n",
    "\n",
    "\n",
    "df2 = pd.DataFrame({\n",
    "        \"Actor\":['Sarah Rafferty','Emily Deschanel','Drew Pritchard','Parker Schnabel','Patrick Dykstra','Bruce Willis'],\n",
    "        \"Height\":[175, 175, 173, 180, 186, 182],\n",
    "        \"Weight\":[55, 65, 75, 80, 82, 87],\n",
    "        \"Birthday\":[1979, 1980, 1970, 1989, 1989, 1955],\n",
    "        \"Show\":[\"Suits\", \"Bones\", \"Salvage Hunters\", \"Gold Rush\", \"Chasing Ocean Giants\", \"Die Hard\"]\n",
    "        })\n",
    "df1\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Actor</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>Show</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sarah Rafferty</td>\n",
       "      <td>175</td>\n",
       "      <td>55</td>\n",
       "      <td>1979</td>\n",
       "      <td>Suits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Emily Deschanel</td>\n",
       "      <td>175</td>\n",
       "      <td>65</td>\n",
       "      <td>1980</td>\n",
       "      <td>Bones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Drew Pritchard</td>\n",
       "      <td>173</td>\n",
       "      <td>75</td>\n",
       "      <td>1970</td>\n",
       "      <td>Salvage Hunters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Parker Schnabel</td>\n",
       "      <td>180</td>\n",
       "      <td>80</td>\n",
       "      <td>1989</td>\n",
       "      <td>Gold Rush</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Patrick Dykstra</td>\n",
       "      <td>186</td>\n",
       "      <td>82</td>\n",
       "      <td>1989</td>\n",
       "      <td>Chasing Ocean Giants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bruce Willis</td>\n",
       "      <td>182</td>\n",
       "      <td>87</td>\n",
       "      <td>1955</td>\n",
       "      <td>Die Hard</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Actor  Height  Weight  Birthday                  Show\n",
       "0   Sarah Rafferty     175      55      1979                 Suits\n",
       "1  Emily Deschanel     175      65      1980                 Bones\n",
       "2   Drew Pritchard     173      75      1970       Salvage Hunters\n",
       "3  Parker Schnabel     180      80      1989             Gold Rush\n",
       "4  Patrick Dykstra     186      82      1989  Chasing Ocean Giants\n",
       "5     Bruce Willis     182      87      1955              Die Hard"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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></th>\n",
       "      <th>Film</th>\n",
       "      <th>Durations</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Birthday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Channel</th>\n",
       "      <th>Genre</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 rowspan=\"2\" valign=\"top\">Fox</th>\n",
       "      <th>Drama</th>\n",
       "      <td>Suits</td>\n",
       "      <td>65</td>\n",
       "      <td>Sarah Rafferty</td>\n",
       "      <td>175</td>\n",
       "      <td>55</td>\n",
       "      <td>1979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>Bones</td>\n",
       "      <td>59</td>\n",
       "      <td>Emily Deschanel</td>\n",
       "      <td>175</td>\n",
       "      <td>65</td>\n",
       "      <td>1980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Discovery</th>\n",
       "      <th>Documentary</th>\n",
       "      <td>Salvage Hunters</td>\n",
       "      <td>60</td>\n",
       "      <td>Drew Pritchard</td>\n",
       "      <td>173</td>\n",
       "      <td>75</td>\n",
       "      <td>1970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Gold Rush</td>\n",
       "      <td>75</td>\n",
       "      <td>Parker Schnabel</td>\n",
       "      <td>180</td>\n",
       "      <td>80</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Chasing Ocean Giants</td>\n",
       "      <td>59</td>\n",
       "      <td>Patrick Dykstra</td>\n",
       "      <td>186</td>\n",
       "      <td>82</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2+2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Die Hard</td>\n",
       "      <td>98</td>\n",
       "      <td>Bruce Willis</td>\n",
       "      <td>182</td>\n",
       "      <td>87</td>\n",
       "      <td>1955</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Film  Durations            Actor  \\\n",
       "Channel   Genre                                                           \n",
       "Fox       Drama                       Suits         65   Sarah Rafferty   \n",
       "          Drama                       Bones         59  Emily Deschanel   \n",
       "Discovery Documentary       Salvage Hunters         60   Drew Pritchard   \n",
       "          Documentary             Gold Rush         75  Parker Schnabel   \n",
       "          Documentary  Chasing Ocean Giants         59  Patrick Dykstra   \n",
       "2+2       Action                   Die Hard         98     Bruce Willis   \n",
       "\n",
       "                       Height  Weight  Birthday  \n",
       "Channel   Genre                                  \n",
       "Fox       Drama           175      55      1979  \n",
       "          Drama           175      65      1980  \n",
       "Discovery Documentary     173      75      1970  \n",
       "          Documentary     180      80      1989  \n",
       "          Documentary     186      82      1989  \n",
       "2+2       Action          182      87      1955  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df1.join(df2.set_index('Show'), on='Film')\n",
    "df3.set_index('Actor', append=True)\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "             Durations\n",
      "Genre                 \n",
      "Documentary        194\n"
     ]
    }
   ],
   "source": [
    "max_lenght=df3.sum(level='Genre')\n",
    "max_lenght.sort_values(by='Durations',ascending=False,inplace=True)\n",
    "max_lenght.drop(['Weight', 'Height', 'Birthday'], axis='columns', inplace=True)\n",
    "res = max_lenght.head(1)\n",
    "print(res)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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></th>\n",
       "      <th>Film</th>\n",
       "      <th>Durations</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Birthday</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Channel</th>\n",
       "      <th>Genre</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>2+2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Die Hard</td>\n",
       "      <td>98</td>\n",
       "      <td>Bruce Willis</td>\n",
       "      <td>182</td>\n",
       "      <td>87</td>\n",
       "      <td>1955</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Film  Durations         Actor  Height  Weight  Birthday\n",
       "Channel Genre                                                              \n",
       "2+2     Action  Die Hard         98  Bruce Willis     182      87      1955"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_width=df3.sort_values(by='Height',ascending=False)\n",
    "max_width=max_width.head(2)\n",
    "max_width=max_width.tail(1)\n",
    "max_width"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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></th>\n",
       "      <th>Film</th>\n",
       "      <th>Durations</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>Millennials</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Channel</th>\n",
       "      <th>Genre</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 rowspan=\"2\" valign=\"top\">Fox</th>\n",
       "      <th>Drama</th>\n",
       "      <td>Suits</td>\n",
       "      <td>65</td>\n",
       "      <td>Sarah Rafferty</td>\n",
       "      <td>175</td>\n",
       "      <td>55</td>\n",
       "      <td>1979</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>Bones</td>\n",
       "      <td>59</td>\n",
       "      <td>Emily Deschanel</td>\n",
       "      <td>175</td>\n",
       "      <td>65</td>\n",
       "      <td>1980</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Discovery</th>\n",
       "      <th>Documentary</th>\n",
       "      <td>Salvage Hunters</td>\n",
       "      <td>60</td>\n",
       "      <td>Drew Pritchard</td>\n",
       "      <td>173</td>\n",
       "      <td>75</td>\n",
       "      <td>1970</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Gold Rush</td>\n",
       "      <td>75</td>\n",
       "      <td>Parker Schnabel</td>\n",
       "      <td>180</td>\n",
       "      <td>80</td>\n",
       "      <td>1989</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Chasing Ocean Giants</td>\n",
       "      <td>59</td>\n",
       "      <td>Patrick Dykstra</td>\n",
       "      <td>186</td>\n",
       "      <td>82</td>\n",
       "      <td>1989</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2+2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Die Hard</td>\n",
       "      <td>98</td>\n",
       "      <td>Bruce Willis</td>\n",
       "      <td>182</td>\n",
       "      <td>87</td>\n",
       "      <td>1955</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Film  Durations            Actor  \\\n",
       "Channel   Genre                                                           \n",
       "Fox       Drama                       Suits         65   Sarah Rafferty   \n",
       "          Drama                       Bones         59  Emily Deschanel   \n",
       "Discovery Documentary       Salvage Hunters         60   Drew Pritchard   \n",
       "          Documentary             Gold Rush         75  Parker Schnabel   \n",
       "          Documentary  Chasing Ocean Giants         59  Patrick Dykstra   \n",
       "2+2       Action                   Die Hard         98     Bruce Willis   \n",
       "\n",
       "                       Height  Weight  Birthday  Millennials  \n",
       "Channel   Genre                                               \n",
       "Fox       Drama           175      55      1979            0  \n",
       "          Drama           175      65      1980            0  \n",
       "Discovery Documentary     173      75      1970            0  \n",
       "          Documentary     180      80      1989            1  \n",
       "          Documentary     186      82      1989            1  \n",
       "2+2       Action          182      87      1955            0  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3['Millennials'] = (df3['Birthday'] > 1981).astype(int)\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " \n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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></th>\n",
       "      <th>Film</th>\n",
       "      <th>Durations</th>\n",
       "      <th>Actor</th>\n",
       "      <th>Height</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Birthday</th>\n",
       "      <th>Result</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Channel</th>\n",
       "      <th>Genre</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 rowspan=\"3\" valign=\"top\">Discovery</th>\n",
       "      <th>Documentary</th>\n",
       "      <td>Salvage Hunters</td>\n",
       "      <td>60</td>\n",
       "      <td>Drew Pritchard</td>\n",
       "      <td>173</td>\n",
       "      <td>75</td>\n",
       "      <td>1970</td>\n",
       "      <td>2.306667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Gold Rush</td>\n",
       "      <td>75</td>\n",
       "      <td>Parker Schnabel</td>\n",
       "      <td>180</td>\n",
       "      <td>80</td>\n",
       "      <td>1989</td>\n",
       "      <td>2.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Documentary</th>\n",
       "      <td>Chasing Ocean Giants</td>\n",
       "      <td>59</td>\n",
       "      <td>Patrick Dykstra</td>\n",
       "      <td>186</td>\n",
       "      <td>82</td>\n",
       "      <td>1989</td>\n",
       "      <td>2.268293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2+2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Die Hard</td>\n",
       "      <td>98</td>\n",
       "      <td>Bruce Willis</td>\n",
       "      <td>182</td>\n",
       "      <td>87</td>\n",
       "      <td>1955</td>\n",
       "      <td>2.091954</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Film  Durations            Actor  \\\n",
       "Channel   Genre                                                           \n",
       "Discovery Documentary       Salvage Hunters         60   Drew Pritchard   \n",
       "          Documentary             Gold Rush         75  Parker Schnabel   \n",
       "          Documentary  Chasing Ocean Giants         59  Patrick Dykstra   \n",
       "2+2       Action                   Die Hard         98     Bruce Willis   \n",
       "\n",
       "                       Height  Weight  Birthday    Result  \n",
       "Channel   Genre                                            \n",
       "Discovery Documentary     173      75      1970  2.306667  \n",
       "          Documentary     180      80      1989  2.250000  \n",
       "          Documentary     186      82      1989  2.268293  \n",
       "2+2       Action          182      87      1955  2.091954  "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3['Result'] = df3['Height']/df3['Weight']\n",
    "average=df3.Result.mean()\n",
    "only_lesser=df3[df3['Result']<average]\n",
    "only_lesser"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEWCAYAAABrDZDcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAdw0lEQVR4nO3deZhcdZ3v8fcnJAgJYgIBaUJY1Mi4XG1iD4sL4pU7D0QW9aqAoMKMk4uPqCg6Oo4bd1yuIzAOoGQyYXUJAioGBRVnIstVxCQ0a+AaEU2bSFjSISGNkOR7/zi/xkqlqvt0pU7VSc7n9Tz1pM7+qV9V6tvnd06do4jAzMyqa1y3A5iZWXe5EJiZVZwLgZlZxbkQmJlVnAuBmVnFuRCYmVWcC4GZWcW5EFSEpIckDUlaV/P4dLdzmVn3je92AOuoYyPiZ90OYWbl4j0CQ9Jlkj5fM3y9pJA0Pg3vJulSSSskrZZ0bRo/mPYsnpK0sWZP4+Q0/ThJ96b5fi7pJTXbqN9D+UUa/zlJ10j6jqS1kpZIemXNcp+Q9Ns07T5Jb6mZdmrK/eGacbPSuM+n4SmSfijpkfRafihpnxHapj7nU5J+XjM9JH1Q0oOSHpX0FUnj0rRxkj4l6feSVkm6QtLzapZ9raRfpPZZLunUmvcjJB1UM++/pHFHpuHnSPpqek9WpOfPGe19kbR/Ws/stNxKSWfVbGek9R4haVNa11pJt0t6eZN2O0LSQM3we+va7fOS5tUMN/ysSPqYpO/WrfsCSV9t9p7Z2LkQ2GYkHQG8om70N4CJwMuAPYF/BYiIyRGxC3A68MuI2CU9viXpxcB84ExgD+B64DpJO9as99iaZV5dM/544GpgN+DbwLWSJqRpvwVeBzwPOBv4pqSemmWXAe+pGX4vsLRmeBxwKbAfsC8wBFw4SrM8mxM4o8H0twB9wMyU/W/T+FPT4w3AC4BdhrclaV/gBuACsvbpBfpr1nl/yk567ccCD9dM/yfg0LTcK4GDgU/ByO9LzfJvAGYAfwN8YrjAjLTeZEVa92TgTuBzjZssv1E+K98EjpI0Oc07HjiB7DNpbeJCYM+SJOBfgM/UjOsBjgZOj4jVEfFMRNyUY3UnAD+KiBsj4hngHGBn4NUjLwbA4oi4Ji13HrAT2ZcTEXF1RKyIiE0R8R3gN2RfVsMeBh6SdJikPcm+8G8fnhgRj0XEdyNifUSsBb4AvD5HppF8OSIej4g/AF8FTkrjTwbOi4gHI2Id8I/AienL7GTgZxExP7XpYxFRWwgWAEdK2pmsCPwMeKpm+snA/46IVRHxCFlRfNcYMp8dEU9GxN1khbE2c571jgN2AB4bwzabafpZiYiVwM3A29O8RwGPRsTiNmzXEhcCq/UOsv/Y/1UzbjrweESsHuO69gZ+PzwQEZuA5cC0HMsur1tuIK0PSe+W1J+6EAaBlwNT65afR/bX9KnAFbUTJE2U9O+pu+YJsi+ZyZJ2GOPra5iX7DXvnZ5v1gbp+Xjg+WTt+tsR1vkMcB3wNuDvyF5TrUbr3pv8xpK5dr17p3ZfS/YHwgVj2GYzo31WLgdOSc9PwXsDbedCYMMmAP8MfLxu/HJgt+Fd8zFYQfbXOPDs3sZ04I85lp1es9w4YB9ghaT9gP8g657ZPSImA/cAqlv+BuA1ZF1E9V8aZwEHAodExK7A4cObyveyRs5L1t20Ij3frA3StA1key3LgReOst55wD+QvdY766Y1WvcK8htL5tr1rkjtvjPwCWCz/vsWjfZZuRZ4RToecQzwrS3WYFvFhcCGvQv4RUTcVTsy7ZrfAHw9HWidIOnwhmvY3FXAmyS9MfVxnwX8GfhFjmVfJemtqQvlzLTcbcAkIIBHACSdRrZHsJmI2Ah8GfhmRDxeN/m5ZMcFBiXtBnw2R57RfCy1zXTgQ8B30vj5wIclHSBpF+CLwHciYgPZl9mRkt4habyk3SX11r2O+4EfA19qsM35wKck7SFpKll33jfHkPnTae/oZcBpdZlHXW9k16/fxJZ7Y60Y8bMSEU8B15AdL7o9dcFZG/n0URs2BWj2u4J3kR0gvh/YEVhI1qXSVEQ8IOkUsq6DaWQHQo+NiKdzZPkBWb/x5WQHf9+a+o7vk3Qu8EuyL6ErgP/bZPuXNln3V8m+UB4l+0v0XODNOTKNlncx2QHsy4CL0/hLyLo9biY7zvET4AMp3x8kzSLrD58HrCE7KFt7nICI+FiTbX4e2BUYLtxXp3F53UTWtuOAcyLipznXu7ekdWQFeYC/HBhvZK+aM4cmApNqhnclKwB5PyuXk3X3jbQ9a5F8YxorE0mfA14UEaeMNm8ZSApgRkQs63aWPCTtD/wOmJD2TLYJ6Syr+4G9IuKJbufZ3rhryMxKLR0n+ghwpYtAMdw1ZGalJWkS2cH135OdOmoFcNeQmVnFuWvIzKzitrmuoalTp8b+++/f9vU++eSTTJo0qe3rbZcy53O21pQ5G5Q7n7ON3eLFix+NiD0aToyIberxqle9KoqwcOHCQtbbLmXO52ytKXO2iHLnc7axAxZFk+9Vdw2ZmVWcC4GZWcW5EJiZVZwLgZlZxbkQmJlVnAuBmVnFFVYIJO2U7ml6Z7oX6dkN5pGk8yUtk3SXpJlF5TEzs8aK/EHZn4H/HhHr0jXGb5V0Q0TcVjPP0WT3TZ0BHAJclP41M7MOKWyPIP2GYV0anJAe9Rc2Oh64Is17G9ktA3swM7OOKfQSE+k+sIuBFwFfi4hf1c0yjc3vnTqQxq2sW89sYDZAT08P/f2b3bsjv5WPNJ009MxT9N9wY+OJPY1/ld1JQ0NDrb/ugjlba8qcDcqdz9naq9BCENktA3vT/W6/L+nlEXFPzSyN7hO7xeVQI2IuMBegr68vent7t1golzWLmk4aXLuK3olTGk9sdXttNDg4SMuvu2DO1poyZ4Ny53O29urIWUMRMQj8nC2vJz7A5jfR3oex3YDbzMy2UpFnDe2R9gSQtDNwJNmt5motAN6dzh46FFgT2c3SzcysQ4rsGuoBLk/HCcYBV0XEDyWdDhARc4DrgVlkN9FeD5xWYB4zM2ugsEIQEXcBBzUYP6fmeQDvLyqDmZmNzr8sNjOrOBcCM7OKcyEwM6s4FwIzs4pzITAzqzgXAjOzinMhMDOrOBcCM7OKcyEwM6s4FwIzs4pzITAzqzgXAjOzinMhMDOrOBcCM7OKcyEwM6s4FwIzs4pzITAzqzgXAjOzinMhMDOrOBcCM7OKcyEwM6s4FwIzs4pzITAzqzgXAjOzinMhMDOruMIKgaTpkhZKWirpXkkfajDPEZLWSOpPj88UlcfMzBobX+C6NwBnRcQSSc8FFku6MSLuq5vvlog4psAcZmY2gsL2CCJiZUQsSc/XAkuBaUVtz8zMWlPkHsGzJO0PHAT8qsHkwyTdCawAPhoR9zZYfjYwG6Cnp4f+/v7Wgqxf3XTS0KaN9Deb3ur22mhoaKj1110wZ2tNmbNBufM5W3sVXggk7QJ8FzgzIp6om7wE2C8i1kmaBVwLzKhfR0TMBeYC9PX1RW9vb2th1ixqOmlw7Sp6J05pPLHV7bXR4OAgLb/ugjlba8qcDcqdz9naq9CzhiRNICsC34qI79VPj4gnImJden49MEHS1CIzmZnZ5oo8a0jAxcDSiDivyTx7pfmQdHDK81hRmczMbEtFdg29BngXcLek4Q6zTwL7AkTEHOBtwPskbQCGgBMjIgrMZGZmdQorBBFxK6BR5rkQuLCoDGZmNjr/stjMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziRi0EknbrRBAzM+uOPHsEv5J0taRZwzeaNzOz7UeeQvBiYC7ZjeiXSfqipBcXG8vMzDpl1EIQmRsj4iTgvcB7gNsl3STpsMITmplZocaPNoOk3YFTyPYIHgY+ACwAeoGrgQOKDGhmZsUatRAAvwS+Abw5IgZqxi+SNKeYWGZm1il5CsGBERGSnitpl4hYNzwhIr5cYDYzM+uAPAeLXybpDuAe4D5JiyW9vOBcZmbWIXkKwVzgIxGxX0TsC5yVxpmZ2XYgTyGYFBELhwci4ufApNEWkjRd0kJJSyXdK+lDDeaRpPMlLZN0l6SZY0pvZmZbLc8xggclfZrsgDFkZxD9LsdyG4CzImKJpOcCiyXdGBH31cxzNDAjPQ4BLkr/mplZh+TZI/hbYA/ge8D30/PTRlsoIlZGxJL0fC2wFJhWN9vxwBXptwq3AZMl9Ywhv5mZbaVR9wgiYjXwwa3ZiKT9gYOAX9VNmgYsrxkeSONW1i0/G5gN0NPTQ39/f2tB1q9uOmlo00b6m01vdXttNDQ01PrrLpiztabM2aDc+ZytvfL8oOxqIOrHR8Q78mxA0i7Ad4EzI+KJ+skNFmm0rbmkA9R9fX3R29ubZ9NbWrOo6aTBtavonTil8cRWt9dGg4ODtPy6C+ZsrSlzNih3PmdrrzzHCOp/NCbg3DwrlzSBrAh8KyK+12CWAWB6zfA+wIo86zYzs/bI0zX0n/XjJK0Zbbl0pdKLgaURcV6T2RYAZ0i6kuwg8ZqIWNlkXjMzK0CerqHP1I8C9s2x7teQXZ/obknDHWafHF42IuYA1wOzgGXAenIchDYzs/bK0zX0ZINxG0dbKCJupfExgNp5Anh/jgxmZlaQPF1DWxwPkHR8MXHMzKzT8nQNvbXB6N0LyGJmZl2Qp2vo2Abjbm93EDMz6448XUM+gGtmth3Lc4kJMzPbjrkQmJlVnAuBmVnFjVoIJD1P0r9KWpQe50p6XifCmZlZ8fLsEVwCPAG8Iz2eAC4tMpSZmXVOntNHXxgR/7Nm+OyaS0aYmdk2Ls8ewZCk1w4PSHoNMFRcJDMz66Q8ewTvAy5PxwUEPA6cWmQoMzPrnDw/KOsHXilp1zRcf3MZMzPbhuU5a+ilks4Adga+IukaSQcVH83MzDohzzGCbwMHkt1v+HbgKmBekaHMzKxz8hSCcRHxAeDpiLg4Iq7KuZyZmW0D8hws3iVdinq8pLeQFYFdi41lZmadkqcQ3ER2KeqbgOPSuJsLS2RmZh2VpxBcEBFLCk9iZmZdkaev3weGzcy2Y3n2CMZLmkLdjegj4vFiIpmZWSflKQQHAovZvBAE8IJCEpmZWUflKQT3RYR/QGZmtp3y7wHMzCouTyE4rPAUZmbWNXkKwXWSJg8PSJoi6SejLSTpEkmrJN3TZPoRktZI6k+Pz4wht5mZtUmeYwR7RMTg8EBErJa0Z47lLgMuBK4YYZ5bIuKYHOsyM7OC5Nkj2Chp3+EBSfuRnTU0ooi4mezeBWZmVmJ59gj+CbhV0k1p+HBgdpu2f5ikO4EVwEcj4t5GM0maPbzNnp4e+vtbvFPm+tVNJw1t2kh/s+mtbq+NhoaGWn/dBXO21pQ5G5Q7n7O1V54b0/xY0kzgULLfEnw4Ih5tw7aXAPtFxDpJs4BrgRlNMswF5gL09fVFb29va1tcs6jppMG1q+idOKXxxFa310aDg4O0/LoL5mytKXM2KHc+Z2uvPDemEXAUMDMirgMmSjp4azccEU9ExLr0/HpggqSpW7teMzMbmzzHCL5OdgrpSWl4LfC1rd2wpL1SkSEVlnHAY1u7XjMzG5s8xwgOiYiZku6AZ88a2nG0hSTNB44ApkoaAD4LTEjrmAO8DXifpA3AEHBiRIx6ENrMzNorTyF4RtIOpDOFJO0BbBptoYg4aZTpF5KdXmpmZl2Up2vofOD7wJ6SvgDcCnyx0FRmZtYxec4a+pakxcAbyc4aenNELC08mZmZdcSohUDSbsAqYH7tON+PwMxs+5DnGMFisuMDAnqAlfh+BGZm2408XUMHDD+XdIfvTWBmtn3JfT+CdMroqKeNmpnZtiXPMYLr0tOXAN8uNo6ZmXVanmME55D9bmAgIn5XcB4zM+uwPIXg7uEn6QwiAHzWkJnZ9iFPIXgUeJjsMhBK43zWkJnZdiLPweLZwABwLjAjIg6ICBcBM7PtxKiFICLmAa8FngP8QtLJhacyM7OOyXM/grcCbwIeAi4CPp7uKmZmZtuBPMcIjq0bXlxEEDMz6448vyw+rRNBzMysO/L8oGxBo/ERcVz745iZWafl6Rp6CfDeooOYmVl35CkEayPipsKTmJlZV+T5HcErJQ1K+pOkJZIukDS18GRmZtYReX5HsAOwG/BC4ATgT8DlBecyM7MOyXUZ6ojYFBFPRsRvIuILwI8LzmVmZh2S5xgBko4DDk+DN0XEBcVFMjOzTsrzy+IvAR8C7kuPD6ZxZma2HcizR/AmoDciNgFIuhy4A/jHIoOZmVln5L1V5eSa588rIoiZmXVHnj2CLwF3SFpIdj+Cw4FPFprKzMw6Js/po/OBQ4HvpcdhadyIJF0iaZWke5pMl6TzJS2TdJekmWMNb2ZmW69pIZD0puHnEbEyIhZExA+AJyXlOWvoMuCoEaYfDcxIj9lkl7g2M7MOG2mP4N8k/V3tCEnvBO4CVo224oi4GRjpvsbHA1dE5jZgsqSeHJnNzKyNRjpG8DrgR5KmAVcCXweeBo6MiN+2YdvTgOU1wwNp3Mr6GSXNJttroKenh/7+/ta2uH5100lDmzbS32x6q9trl5WPMPTMU/TfcOPYluvZo5g8dYaGhlp/T4qy8hGAsbdbh9oMStpuNcqcb5vPlj6fY1bQ57NpIYiIlZJeT3Zc4JPAqRFxZRu3rUabbZJlLjAXoK+vL3p7e1vb4ppFTScNrl1F78QpjSe2ur12WbNo5HzNdCj34OAgLb8nRUnv9ZjbrYOvo5TtVqPM+bb5bCN8F42ooNc84sHiiFhL1pd/FfBOSTu1cdsDwPSa4X2AFW1cv5mZ5dB0j0DSWv7yF7qAScDjkjYCERG7buW2FwBnSLoSOARYExFbdAuZmVmxRuoaeu7WrFjSfOAIYKqkAeCzwIS07jnA9cAsYBmwHvAtMc3MuiDXRedaEREnjTI9gPcXtX0zM8sn7yUmzMxsO+VCYGZWcS4EZmYV50JgZlZxLgRmZhXnQmBmVnEuBGZmFedCYGZWcS4EZmYV50JgZlZxLgRmZhXnQmBmVnEuBGZmFedCYGZWcS4EZmYV50JgZlZxLgRmZhXnQmBmVnEuBGZmFedCYGZWcS4EZmYV50JgZlZxLgRmZhXnQmBmVnEuBGZmFVdoIZB0lKQHJC2T9IkG04+QtEZSf3p8psg8Zma2pfFFrVjSDsDXgP8BDAC/lrQgIu6rm/WWiDimqBxmZjayIvcIDgaWRcSDEfE0cCVwfIHbMzOzFhS2RwBMA5bXDA8AhzSY7zBJdwIrgI9GxL31M0iaDcwG6Onpob+/v7VE61c3nTS0aSP9zaa3ur12Wb965HzNdCj30NBQ6+9JUVJbjbndOvg6StluNcqcb5vPNtb/y8MKes1FFgI1GBd1w0uA/SJinaRZwLXAjC0WipgLzAXo6+uL3t7e1hKtWdR00uDaVfROnNJ4Yqvba5c1i0bO10yHcg8ODtLye1KU9F6Pud06+DpK2W41ypxvm882wnfRiAp6zUV2DQ0A02uG9yH7q/9ZEfFERKxLz68HJkiaWmAmMzOrU2Qh+DUwQ9IBknYETgQW1M4gaS9JSs8PTnkeKzCTmZnVKaxrKCI2SDoD+AmwA3BJRNwr6fQ0fQ7wNuB9kjYAQ8CJEVHffWRmZgUq8hjBcHfP9XXj5tQ8vxC4sMgMZmY2Mv+y2Mys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqzoXAzKziXAjMzCrOhcDMrOJcCMzMKs6FwMys4lwIzMwqrtBCIOkoSQ9IWibpEw2mS9L5afpdkmYWmcfMzLZUWCGQtAPwNeBo4KXASZJeWjfb0cCM9JgNXFRUHjMza6zIPYKDgWUR8WBEPA1cCRxfN8/xwBWRuQ2YLKmnwExmZlZnfIHrngYsrxkeAA7JMc80YGXtTJJmk+0xAKyT9EB7owIwFXi0gPW2S5nzOVtrypwNyp3P2cZuv2YTiiwEajAuWpiHiJgLzG1HqGYkLYqIviK3sTXKnM/ZWlPmbFDufM7WXkV2DQ0A02uG9wFWtDCPmZkVqMhC8GtghqQDJO0InAgsqJtnAfDudPbQocCaiFhZvyIzMytOYV1DEbFB0hnAT4AdgEsi4l5Jp6fpc4DrgVnAMmA9cFpReXIotOupDcqcz9laU+ZsUO58ztZGitiiS97MzCrEvyw2M6s4FwIzs4qrbCGQNFnSNZLul7RU0mGSdpN0o6TfpH+nlCjb5yT9UVJ/eszqQq4Da7bfL+kJSWeWqN2a5et626V8H5Z0r6R7JM2XtFOJ2q5RtrK024dSrnslnZnGlaXdGmUrRbuNRWWPEUi6HLglIuals5omAp8EHo+I/5OujTQlIj5ekmxnAusi4pxO52kkXULkj2Q/Enw/JWi3EfKdRpfbTtI04FbgpRExJOkqspMlXkqX226EbPvT/XZ7OdlVCQ4GngZ+DLwP+Hu6327Nsp1Mif6v5lHJPQJJuwKHAxcDRMTTETFIdsmLy9NslwNvLlG2snkj8NuI+D0laLcGavOVxXhgZ0njyYr7CsrTdo2ylcFLgNsiYn1EbABuAt5COdqtWbZtTiULAfAC4BHgUkl3SJonaRLw/OHfMaR/9yxRNoAzlF2l9ZJu7QrXOBGYn56Xod3q1eaDLrddRPwROAf4A9klVNZExE8pQduNkA26/5m7Bzhc0u6SJpKdbj6dErTbCNmg++02JlUtBOOBmcBFEXEQ8CSwxWWyu6RZtouAFwK9ZP9Zz+1WwNRddRxwdbcyjKRBvq63XfoyOB44ANgbmCTplE7naGSEbF1vt4hYCnwZuJGs6+VOYEOnczQyQraut9tYVbUQDAADEfGrNHwN2Zfvw0pXP03/ripLtoh4OCI2RsQm4D/I+iW75WhgSUQ8nIbL0G61NstXkrY7EvhdRDwSEc8A3wNeTTnarmG2krQbEXFxRMyMiMOBx4HfUI52a5itLO02FpUsBBHxJ2C5pAPTqDcC95Fd8uI9adx7gB+UJZs2vzz3W8h2S7vlJDbvdul6u9XZLF9J2u4PwKGSJkoS2fu6lHK0XcNsJWk3JO2Z/t0XeCvZe1uGdmuYrSztNhZVPmuoF5gH7Ag8SHZmyTjgKmBfsv8cb4+Ix0uS7XyyXc0AHgL+Vzeuy5T6QpcDL4iINWnc7pSg3UbI9w3K0XZnAyeQdR/cAbwX2IUStF2TbPMoR7vdAuwOPAN8JCL+syyfuSbZSvF5G4vKFgIzM8tUsmvIzMz+woXAzKziXAjMzCrOhcDMrOJcCMzMKq7Im9ebdYWkjcDdNaN2AxZExBldimRWai4Etj0aioje4QFJpwJ93YtjVm7uGrJKkXSZpDmSbpH0/yQdk8bvJOlSSXeni/29IY3fQdI5afxdkj6Qxj8kqfbXy9+R9NAo61qYrk+/TtID6flx6fr135D0X8qur//3aX5J+oqy693fLemENP4ISWvS8g9K+khHG9G2O94jsCraH3g92YXBFkp6Edk9FYiI/ybpr4CfSnox2a+6DwAOiogNknarWc/e6YJtAvaqGd9wXRExXBB+Dnw0Ihal4ZnAK4BDgUnAHZJ+BBxG9gvVVwJTgV9Lujlt45aIOEbSXwP/DpzXvuaxqvEegVXRVRGxKSJ+Q3YJj78CXgt8AyAi7gd+D7yY7IJsc9L15qm7jMF84J3p8e2a8c3WNZIfRMRQRDwKLCS7UNlrgfnpAmYPk13v/q/T/K+T1J/mPX/sTWD2Fy4EVkX111UJsr/qG1GD+YctILvc9XHAdXXLFJkJsj2CXrK9m7Ml7dTCNs0AFwKrprdLGifphWQ3AnoAuJnsFoOkLqF90/ifAqcru3MXdV1DTwO3Ab9Mz4c1W9dIjk/HFnYHjgB+ndZzQjpOsQfZnetur1tuPbAz8Jzcr96sjo8RWBU9QNbN8nzg9Ih4StLXgTmS7ia7AuepEfFnSfPIunXukvQM2fXlLxxeUUR8FkDS1Jr1N1zXKJluB35EVjT+OSJWSPo+2XGCO8n2EP4hIv6UjjsMdw3tBJw3fKVVs1b46qNWKZIuA34YEdd0O8swSZ9jG7vZuW1f3DVkZlZx3iMwM6s47xGYmVWcC4GZWcW5EJiZVZwLgZlZxbkQmJlV3P8H1Bkws1ggfrIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# 8 задание\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "\n",
    "size, scale = 1000, 10\n",
    "ages = df3['Durations']\n",
    "\n",
    "ages.plot.hist(grid=True, bins=20, rwidth=0.9,\n",
    "                   color='pink')\n",
    "plt.title('Гистограма просмотров шоу')\n",
    "plt.xlabel('Просмотров')\n",
    "plt.ylabel('Количество шоу')\n",
    "plt.grid(axis='y', alpha=0.75)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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></th>\n",
       "      <th>Name</th>\n",
       "      <th>Age</th>\n",
       "      <th>Can Swim</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Food</th>\n",
       "      <th>Kg</th>\n",
       "      <th>Cost_per_kg</th>\n",
       "      <th>Cost_per_day</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kind</th>\n",
       "      <th>Cage</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 rowspan=\"4\" valign=\"top\">Bear</th>\n",
       "      <th>4</th>\n",
       "      <td>Dobrik</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "      <td>290.0</td>\n",
       "      <td>Meat</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dobrik</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "      <td>290.0</td>\n",
       "      <td>Honey</td>\n",
       "      <td>0.5</td>\n",
       "      <td>120</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonya</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "      <td>315.0</td>\n",
       "      <td>Meat</td>\n",
       "      <td>3.0</td>\n",
       "      <td>100</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonya</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "      <td>315.0</td>\n",
       "      <td>Honey</td>\n",
       "      <td>0.5</td>\n",
       "      <td>120</td>\n",
       "      <td>60.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Name  Age  Can Swim  Weight   Food   Kg  Cost_per_kg  \\\n",
       "Kind Cage                                                           \n",
       "Bear 4     Dobrik    5      True   290.0   Meat  3.0          100   \n",
       "     4     Dobrik    5      True   290.0  Honey  0.5          120   \n",
       "     3      Sonya    7      True   315.0   Meat  3.0          100   \n",
       "     3      Sonya    7      True   315.0  Honey  0.5          120   \n",
       "\n",
       "           Cost_per_day  \n",
       "Kind Cage                \n",
       "Bear 4            300.0  \n",
       "     4             60.0  \n",
       "     3            300.0  \n",
       "     3             60.0  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           Durations    Result\n",
      "Channel                       \n",
      "Discovery        194  6.824959\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}