analysis_era_films_2020.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "toc": true
   },
   "source": [
    "<h1>Содержание<span class=\"tocSkip\"></span></h1>\n",
    "<div class=\"toc\"><ul class=\"toc-item\"><li><span><a href=\"#Подготовка-и-анализ-фильмов-за-2020-год\" data-toc-modified-id=\"Подготовка-и-анализ-фильмов-за-2020-год-1\"><span class=\"toc-item-num\">1&nbsp;&nbsp;</span>Подготовка и анализ фильмов за 2020 год</a></span></li><li><span><a href=\"#Составление-запросов-года-фильма-в-Google\" data-toc-modified-id=\"Составление-запросов-года-фильма-в-Google-2\"><span class=\"toc-item-num\">2&nbsp;&nbsp;</span>Составление запросов года фильма в Google</a></span></li><li><span><a href=\"#Определение-эпохи\" data-toc-modified-id=\"Определение-эпохи-3\"><span class=\"toc-item-num\">3&nbsp;&nbsp;</span>Определение эпохи</a></span></li><li><span><a href=\"#Построение-диаграммы-по-эпохам\" data-toc-modified-id=\"Построение-диаграммы-по-эпохам-4\"><span class=\"toc-item-num\">4&nbsp;&nbsp;</span>Построение диаграммы по эпохам</a></span></li></ul></div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Подготовка и анализ фильмов за 2020 год"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('D:/HOBBIES/PROGRAMMER/ANALYSIS/films.txt', encoding='utf-8') as f:\n",
    "    films2020 = []\n",
    "    for i in f:\n",
    "        if i != '':\n",
    "            i = i.strip()\n",
    "            if re.search('сезон', i) == None:\n",
    "                films2020.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "154"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(films2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('D:/HOBBIES/PROGRAMMER/ANALYSIS/new_films.txt', encoding='utf-8') as f:\n",
    "    new_films = []\n",
    "    for i in f:\n",
    "        if i != '':\n",
    "            i = i.split()\n",
    "            k = i[:-1]\n",
    "            if re.search('сезон', ' '.join(k)) == None:\n",
    "                i = ' '.join(i[:-1])\n",
    "                new_films.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "70"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(new_films)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "films2020.extend(new_films)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "224"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(films2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12 Лет Рабства</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12 Разгневанных Мужчин</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500 Дней Лета</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ex Machine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Шпион, Выйди Вон!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Шпионский Мост</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Эд Вуд</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Эта Замечательная Жизнь</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Я Убил Свою Маму</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Фильм\n",
       "0             12 Лет Рабства\n",
       "1     12 Разгневанных Мужчин\n",
       "2                       1917\n",
       "3              500 Дней Лета\n",
       "4                 Ex Machine\n",
       "..                       ...\n",
       "219        Шпион, Выйди Вон!\n",
       "220           Шпионский Мост\n",
       "221                   Эд Вуд\n",
       "222  Эта Замечательная Жизнь\n",
       "223         Я Убил Свою Маму\n",
       "\n",
       "[224 rows x 1 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "films2020.sort()\n",
    "data = pd.DataFrame(films2020, columns=['Фильм'])\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Составление запросов года фильма в Google"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12 Лет Рабства\n",
      "12 Разгневанных Мужчин\n",
      "1917\n",
      "500 Дней Лета\n",
      "Ex Machine\n",
      "А В Душе Я Танцую\n",
      "Август Раш\n",
      "Авиатор\n",
      "Адвокат Дьявола\n",
      "Академия Рашмор\n",
      "Амели\n",
      "Американский Психопат\n",
      "Анима\n",
      "Антихрист\n",
      "Апокалипсис Сегодня\n",
      "Артист\n",
      "Аэроплан\n",
      "Баллада Бастера Сркаггса\n",
      "Бархатная Бензопила\n",
      "Бегущий По Лезвию\n",
      "Бегущий По Лезвию 2049\n",
      "Безумный Макс: Дорога ярости\n",
      "Бердмэн\n",
      "Берегись Автомобиля\n",
      "Бивень\n",
      "Боль и Слава\n",
      "Борат\n",
      "Борат 2\n",
      "Бразилия\n",
      "Брат\n",
      "Брат 2\n",
      "Братья\n",
      "Брачная История\n",
      "Бриллиантовая Рука\n",
      "Бутылочная Ракета\n",
      "Быть Джоном Малковичем\n",
      "Бэтмен: Начало\n",
      "В Бой Идут Одни «Старики»\n",
      "В Погоне За Счастьем\n",
      "В Центре Внимания\n",
      "Ван Гог. На пороге вечности\n",
      "Великая Красота\n",
      "Властелин Колец: Братство Кольца\n",
      "Властелин Колец: Возвращение Короля\n",
      "Властелин Колец: Две Крепости\n",
      "Водная Жизнь\n",
      "Возвращение\n",
      "Враг\n",
      "Врождённый Порок\n",
      "Вход в Пустоту\n",
      "Выживут Только Любовники\n",
      "Выживший\n",
      "Голова-Ластик\n",
      "Головокружение\n",
      "Голубь Сидел на Ветке, Размышляя о Бытие\n",
      "Город Бога\n",
      "Гость\n",
      "Гравитация\n",
      "Гражданин Кейн\n",
      "Девушка Из Дании\n",
      "Девчата\n",
      "Джентльмены\n",
      "Джентльмены Удачи\n",
      "Дикие Истории\n",
      "Дитя Погоды\n",
      "Дитя Человеческое\n",
      "Дневник Памяти\n",
      "Довод\n",
      "Доктор Сон\n",
      "Доктор Стрейнджлав, или Как я перестал бояться и полюбил бомбу\n",
      "Дом, Который Построил Джек\n",
      "Достать Ножи\n",
      "Дурак\n",
      "Дюнкерк\n",
      "Елена\n",
      "Если Бил-Стрит Могла Бы Заговорить\n",
      "Железная Леди\n",
      "Жертвоприношение\n",
      "Жизнь Дэвида Гейла\n",
      "Жизнь Прекрасна\n",
      "Жить\n",
      "Заводной Апельсин\n",
      "Запах Женщины\n",
      "Звук Металла\n",
      "Звуки Шума\n",
      "Зеркало\n",
      "Зови Меня Своим Именем\n",
      "Зодиак\n",
      "И Все Же Лоранс\n",
      "Иван Васильевич Меняет Профессию\n",
      "Иваново Детство\n",
      "Игра\n",
      "Игра На Понижение\n",
      "Ида\n",
      "Иди и Смотри\n",
      "Идиоты\n",
      "Ирландец\n",
      "История Призрака\n",
      "Кавказская Пленница, Или Новые Приключения Шурика\n",
      "Кирпич\n",
      "Китайский Квартал\n",
      "Клаус\n",
      "Клык\n",
      "Королевство Полной Луны\n",
      "Король Говорит\n",
      "Космическая Одиссея 2001\n",
      "Кофе и Сигареты\n",
      "Коянискацци\n",
      "Красота По-американски\n",
      "Крестный Отец\n",
      "Крестный Отец 2\n",
      "Кролик Джоджо\n",
      "Ла-Ла Лэнд\n",
      "Левиафан\n",
      "Лок\n",
      "Луна 2112\n",
      "Лучший Стрелок\n",
      "Любовное Настроение\n",
      "Любовь И Голуби\n",
      "Магнолия\n",
      "Маленькие Женщины\n",
      "Малхолланд-Драйв\n",
      "Мама\n",
      "Мамочка\n",
      "Манк\n",
      "Манчестер у Моря\n",
      "Мастер\n",
      "Матиас и Максим\n",
      "Маяк\n",
      "Меланхолия\n",
      "Мертвец\n",
      "Место под Соснами\n",
      "Молчание Ягнят\n",
      "Монти Пайтон и Священный Грааль\n",
      "Москва Слезам Не Верит\n",
      "Невероятная Жизнь Уолтера Митти\n",
      "Нелюбовь\n",
      "Неограненные Драгоценности\n",
      "Неоновый Демон\n",
      "Нефть\n",
      "Ностальгия\n",
      "Ночи В Стиле Буги\n",
      "Ночь На Земле\n",
      "Общество Мертвых Поэтов\n",
      "Однажды на Диком Западе\n",
      "Окно во Двор\n",
      "Оно Следует\n",
      "Операция «Арго»\n",
      "Операция «Ы» И Другие Приключения Шурика\n",
      "Оружейный Барон\n",
      "Охота\n",
      "Паразиты\n",
      "Песни Со Второго Этажа\n",
      "Пленницы\n",
      "Под Сильвер-Лэйк\n",
      "Подлинная История Банды Келли\n",
      "Подозрительные Лица\n",
      "Поезд на Дарджилинг\n",
      "Политех\n",
      "Полночь в Париже\n",
      "Помни\n",
      "Порок На Экспорт\n",
      "Прекрасный День По Соседству\n",
      "Призрачная Нить\n",
      "Прогулка\n",
      "Проект Флорида\n",
      "Психо\n",
      "Птицы\n",
      "Пылающий\n",
      "Разрушение\n",
      "Рассекая Волны\n",
      "Расёмон\n",
      "Рейд\n",
      "Реквием По Мечте\n",
      "Рома\n",
      "С Любовью, Антоша\n",
      "Свой Среди Чужих, Чужой Среди Своих\n",
      "Семейка Тененбаум\n",
      "Семь Самураев\n",
      "Сестры\n",
      "Сильнее\n",
      "Скафандр И Бабочка\n",
      "Сквозь Снег\n",
      "Скрытые Фигуры\n",
      "Славные Парни\n",
      "Служебный Роман\n",
      "Солярис\n",
      "Соучастник\n",
      "Социальная Сеть\n",
      "Спасти Рядового Райана\n",
      "Сталкер\n",
      "Старик С Пистолетом\n",
      "Страх и Ненависть в Лас-Вегасе\n",
      "Страшные Сказки\n",
      "Стрингер\n",
      "Субурбикон\n",
      "Суд Над Чикагской Семёркой\n",
      "Схватка\n",
      "Таксист\n",
      "Талантливый Мистер Рипли\n",
      "Тебя Никогда Здесь Не Было\n",
      "Текст\n",
      "Темные Времена\n",
      "Темный Рыцарь\n",
      "Темный Рыцарь: Возрождение Легенды\n",
      "Терминал\n",
      "Тренировочный День\n",
      "Трудности Перевода\n",
      "Ты, Живущий\n",
      "Форд Против Феррари\n",
      "Форрест Гамп\n",
      "Фото За Час\n",
      "Хорошее Время\n",
      "Хоть Раз в Жизни\n",
      "Цвет Из Иных Миров\n",
      "Человек Дождя\n",
      "Человек, Который Изменил Все\n",
      "Человек-Невидимка\n",
      "Черный Лебедь\n",
      "Шпион, Выйди Вон!\n",
      "Шпионский Мост\n",
      "Эд Вуд\n",
      "Эта Замечательная Жизнь\n",
      "Я Убил Свою Маму\n"
     ]
    }
   ],
   "source": [
    "def year_of_film(film):\n",
    "    print(film)\n",
    "    film = film.split(' ')\n",
    "    try:\n",
    "        req = requests.get(f\"https://www.google.ru/search?ie=UTF-8&q={'%20'.join(film)}\")\n",
    "        soup = BeautifulSoup(req.text, 'lxml')\n",
    "        for g in soup.find_all(class_=\"BNeawe tAd8D AP7Wnd\"):\n",
    "            if re.search('\\w+ \\d{4} г.', g.text) or re.search('\\d{4} г.', g.text):\n",
    "                res = g.text.split()\n",
    "                return res[(res.index('г.'))-1]\n",
    "            else: raise TypeError\n",
    "        raise TypeError\n",
    "    except TypeError:\n",
    "        req = requests.get(f\"https://www.google.ru/search?ie=UTF-8&q={'%20'.join(film)}%20фильм%20год%20выпуска\")\n",
    "        soup = BeautifulSoup(req.text, 'lxml')\n",
    "        for g in soup.find_all(class_=\"BNeawe tAd8D AP7Wnd\"):\n",
    "            if re.search('\\w+ \\d{4} г.', g.text):\n",
    "                res = g.text.split()\n",
    "                return res[(res.index('г.'))-1]\n",
    "\n",
    "# for i in list_spec:\n",
    "#     print(f'{i} - {year_of_film(films_for_ques[i])}')\n",
    "# for i in range(200, 220):\n",
    "# for i in [12, 13, 15, 18]:\n",
    "# print(data.loc[109, 'Фильм'], year_of_film(data.loc[109, 'Фильм']), sep=': ')\n",
    "\n",
    "data['Год'] = data['Фильм'].apply(year_of_film)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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>Год</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12 Лет Рабства</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12 Разгневанных Мужчин</td>\n",
       "      <td>1957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1917</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500 Дней Лета</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ex Machine</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Шпион, Выйди Вон!</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Шпионский Мост</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Эд Вуд</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Эта Замечательная Жизнь</td>\n",
       "      <td>1946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Я Убил Свою Маму</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Фильм   Год\n",
       "0             12 Лет Рабства  2013\n",
       "1     12 Разгневанных Мужчин  1957\n",
       "2                       1917  2019\n",
       "3              500 Дней Лета  2009\n",
       "4                 Ex Machine  2014\n",
       "..                       ...   ...\n",
       "219        Шпион, Выйди Вон!  2011\n",
       "220           Шпионский Мост  2015\n",
       "221                   Эд Вуд  1994\n",
       "222  Эта Замечательная Жизнь  1946\n",
       "223         Я Убил Свою Маму  2009\n",
       "\n",
       "[224 rows x 2 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Определение эпохи"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "ages = list(range(1930, 2040, 10))\n",
    "def age(year):\n",
    "    global ages\n",
    "    y = int(datetime.strptime(year, '%Y').year)\n",
    "    for i in range(len(ages)-1):\n",
    "        if ages[i] <= y < ages[i+1]:\n",
    "            return str(ages[i])+'-е'\n",
    "    \n",
    "data['Эпоха'] = data['Год'].apply(age)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                       Фильм   Год   Эпоха\n",
      "0             12 Лет Рабства  2013  2010-е\n",
      "1     12 Разгневанных Мужчин  1957  1950-е\n",
      "2                       1917  2019  2010-е\n",
      "3              500 Дней Лета  2009  2000-е\n",
      "4                 Ex Machine  2014  2010-е\n",
      "..                       ...   ...     ...\n",
      "219        Шпион, Выйди Вон!  2011  2010-е\n",
      "220           Шпионский Мост  2015  2010-е\n",
      "221                   Эд Вуд  1994  1990-е\n",
      "222  Эта Замечательная Жизнь  1946  1940-е\n",
      "223         Я Убил Свою Маму  2009  2000-е\n",
      "\n",
      "[224 rows x 3 columns]\n"
     ]
    }
   ],
   "source": [
    "print(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv('films_with_ages', index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Построение диаграммы по эпохам"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Фильм</th>\n",
       "      <th>Год</th>\n",
       "      <th>Эпоха</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12 Лет Рабства</td>\n",
       "      <td>2013</td>\n",
       "      <td>2010-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12 Разгневанных Мужчин</td>\n",
       "      <td>1957</td>\n",
       "      <td>1950-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1917</td>\n",
       "      <td>2019</td>\n",
       "      <td>2010-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500 Дней Лета</td>\n",
       "      <td>2009</td>\n",
       "      <td>2000-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ex Machine</td>\n",
       "      <td>2014</td>\n",
       "      <td>2010-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Шпион, Выйди Вон!</td>\n",
       "      <td>2011</td>\n",
       "      <td>2010-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>Шпионский Мост</td>\n",
       "      <td>2015</td>\n",
       "      <td>2010-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Эд Вуд</td>\n",
       "      <td>1994</td>\n",
       "      <td>1990-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Эта Замечательная Жизнь</td>\n",
       "      <td>1946</td>\n",
       "      <td>1940-е</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Я Убил Свою Маму</td>\n",
       "      <td>2009</td>\n",
       "      <td>2000-е</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Фильм   Год   Эпоха\n",
       "0             12 Лет Рабства  2013  2010-е\n",
       "1     12 Разгневанных Мужчин  1957  1950-е\n",
       "2                       1917  2019  2010-е\n",
       "3              500 Дней Лета  2009  2000-е\n",
       "4                 Ex Machine  2014  2010-е\n",
       "..                       ...   ...     ...\n",
       "219        Шпион, Выйди Вон!  2011  2010-е\n",
       "220           Шпионский Мост  2015  2010-е\n",
       "221                   Эд Вуд  1994  1990-е\n",
       "222  Эта Замечательная Жизнь  1946  1940-е\n",
       "223         Я Убил Свою Маму  2009  2000-е\n",
       "\n",
       "[224 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dt = pd.read_csv('films_with_ages', sep=',')\n",
    "dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2, 5, 11, 16, 9, 25, 49, 99, 8]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "count = pd.value_counts(dt['Эпоха']).sort_index().to_list()\n",
    "count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1940-е', '1950-е', '1960-е', '1970-е', '1980-е', '1990-е',\n",
       "       '2000-е', '2010-е', '2020-е'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "uniages = pd.unique(dt['Эпоха'])\n",
    "uniages.sort()\n",
    "uniages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAtQAAAHwCAYAAACG+PhNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de7xUdb3/8deGDV4SU1I4XFTQvGzZKoqJnDxoGkbekfJImiKo6K+OWpmip2PosfRoltcUb2VSmKYmGZF5S/OGoKCioYnIRRJFTMQr8v398V3jnj17b5i9F7PXnpnX8/GYx8y6zKzPfPfaM+/5znetqQkhIEmSJKltOmVdgCRJklTODNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEvFmQ98OW+6DzAPuCiTaqR170Hg+KyL6EB+ArwErAD+DhxTsHwgMBN4L7kemLfs2GTeO8Ai4utEbd7y7sCdwErgVeAb6758Se3JQC213ubAvcA04IyMa5FUGiuBg4HPEgPyZcC/J8u6AncBk4BNgZuS6a7J8g2B04DNgMHAfsDpeY99FfAR0BM4CrgaGFC6pyKp1AzUUutsAtwDTAe+lTd/PeBS4LXkcmkyL6cfEIB3k8snNPQGTiC+Mef8PFn388n0fBr3judPdwLGAy8Dy4Bbib1fOXsBjwJvAwuB0cB/FtTxQd50rp6Pk+m3iT1p3fK29wNir9pS4FfEwNGcfYDVeY+d297oZPlo4BHgCuBfxF7A/fLu3xuYArwF/AM4IW9ZZ+Ds5HmvIPYGbpEsC8DsgnVfI/YU5tQRe2TfBuYAhyTzi2mb3wG/Tbb7FLBLQc23A28ArwCn5C2bQOO/c21Sa79k+pfA+XnLP58sz3mQ5nuQz0/um6t/HrBxMv1V4J/ED4HNOTOp9Y/A+sTw9xKxXYfmrTefhn1uI+B14G8FjzUfeJ/YVh/R8Fz3oXHb5+tHfI535c3blNju+Y//78CTxP3kSRqCLcR2yf2dlgI/amFbrV33h8R9cjXwBPAwMCRZtg/x73cp8CFwOVAD7JssvzpZ/yNgMfBr4IvJss8AI4H/Ser4G3E//2YLdYwm7ov5/0erkxpg7a89hXL7VXOvRQB70vCaMTtvO9B4H9yG+JpycN70/cTXoTeT57xJwbYnEdvkXeK+kr9fHAg8TezVX0j8f8npR3H7iZQZA7VUvI2APxHfSMfQOOz8N/GNaCAxYO1BDJ45uf+1zyaP83AL29iWGILyrabl/9VTgMOAvYlhbjmx9wtgy6TeK4iBaiAwixgGN8qr49t50zm5dbYE+hN76CC+uY8GvgRsnaxzZQu1QXyD3yjv8ljB8sHEALgZMcDcQcMHgsnEN9zewNeAH9MQuL8LjAIOIIbHMcSv3nO6Al9Ibh9IDAc5XYA/ED8Y9QD+i/jmvz3Ftc2hwG1Jnb8Bfp88ZqfkcWcThwTtR+yl/Moa2mdd+y2xjS8HPgfcQAxAbzSz7iBir+kQYtvvSNz/did+WLmF5oPZ94kfuAp1Ag4ittWPW1n31kCv5PY3iftETndi4M89p58m05/LWyf3d9oL+B5Qv4ZttWbdnA2I+9OcZHoA8AyNXwOeoeVe5qF5992OGGJfzFs+ew33hfg3zf8/ei1v2dpeewrlXkvy9/OcPsS2PZ/Y7qcTPyAWfiD7N+DPybb/kMyrAS4g/r/WET/gTii4Xw3xQ8xGNH2dW0kcVrMJ8X/2ZOJrW7417SdSpgzUUvGuJvas9KWhtynnKOA8Yq/XG8C5NO5x6koMxp+sZRsXAP9bMG8BsXewppn1xxHf1BYRe8omEMNnbVLTvcRg+jGx52jWWrZfqDPxdWJZMn0UMdDMI7bFWcCRNB4f2hpLiT1qHxPD4Fzim+kWxMBzJrEXahZwPQ1tejwxNMyloUd6Wd7j5oJkbt0b8pbtSXxDv5DYW3Y/cDcxoBdjJrGX+mNiW6yfPOYXiMHjvORx5wHXEdunPX2L2FP6IDHs3N3Ceocky/8BzCD2tk8i9gL/lvgchhTcpycwlvi8C3VN7tMWN9HwzcUxyXTOgcRe85uBVcT9+e809IzmqyX+j/2riG22Zt1riPvYn5PpjZq5379o+CYn33HEDyk/acN9i7G2155C69Py3+loYGpyWQ38hbhvHJC3Tu5bul8Tv6HK+Uey/odJHT8lftDPt8Eatv0g8Gyy3WeIf+fC+69pP5EyZaCWipd7Ez+DGNA2yFvWmzgMIufVZF5Od2Lv8ZoMBnag6ZvEmcQ3tH8Re1q3zFu2FXFIxtvJ5QViSOhJDKUvr2WbLTkiebw3iD1HuV6o5p5nbbK9tlhM416+XLv1Jg71WFGwrE9ye23P7W7iV9WfJ/Zozcxb1pv4lfLqFh57bRbm3V5NQy/6Vsn123mXs2ncNkfkLXuzmcc+PW/5U80svzxZtgS4kRiOCr1N7EGvBy5Zw/PoSfM91zlLiT2R+SYQv/F4q2B+DTFotbSP59plOfFr/cJe+5uJwXAwsX1fL7jvqwXrF/69cu0yh9guC2lZa9YFuJjYlkfQsK++S8OwmpyNaby/QuxhvZDYG5v7exd732Kt7bWn0L/R8t99K+DrNN6H96KhVxhieH+X+A1MfoboQfxWYzFx2MYk4jdPxW57MPBAsvxfwEnN3H9N+4mUKQO1VLwfEXtLryP2Guf3JL9GfDPK2ZLGX8tuR+OveJtzEXE8dGEv9hPEN/SNiaFlQd6yhcQ3603yLusT39QWEsc1tsWtyWNtSOw1ygWz5p7nKtr+xtaHxj3vuXZ7jfghpFvBssXJ7bU9t1XEDxq/o2F8cc5rxECe//qX/9hrs0Xe7U7EbyxeS2p6hcZ/i2407t27NW9ZYViA2IuZW75bM8tPSZbVE4dsjG5mnYHEITCTieGxJW+0UENODxr/XbcjBuHmHnMr4gerlr6Cfy2puzsxkBd+aFwGPAdMJH4TUXjfrQrmFf69cu3SnRgA1/RtQ2vWPZf4/7U/MSTmzAF2pvG+uzMNwzoAhhNfKw4m/g/lvEhsq23z5u1ScN/WWNtrT6FdaXyMQb6FxNCavw9/hvihIOdWYrtBHD6TcwHxA8fOxNeqo2ncPl2I+21L2/4NcSz5FsShcdfQ9Fu5Ne0nUqYM1FLbnACcSByvCDG8/ID4lf9mwDk0HJS1BXAqcaxtS/Ylvhm19PV8S64hBv3cG+rmxDG+EL+S/TKxZ62WOOZ0YOEDrMXqpK7cGMrJwHeI46pzY2V/SwywbdGDGHC6EHvG6ohfNy8kHhh1AfEDws7EoQa/Tu53PfEDzbbEN92daTymFuBaYo/9rwvmP0HsdT8j2e4+xNBzS5E1DwIOJ7bpacSvuB8nHqj6DvEbhQ2Iw2XqaRjLvS6tTLZb+Bq+PnG/O5s41KAP8P9aeIypxOe9NXFIwm7E3r/PEv8WGxKfV84PiL2T7xc8TjfiGOx7aDyOvTmB2OvZ3HvPz4hDe6Y1U+d2xFPL1RIPvNyR5v9XPqHx/roma1v3rGSbw2g8nAji8IRPiPvuejQEy/uT632J+91I4n6RbyXxWIHziGH1i8T/2ZuLqLk5a3rtKbQx8UPY5BaWTyLuE18h7r/rE/8/+uat8zfi68KYZFtbJ/O70XAgcx/iWPt8xxEPkJ3Rwra7Eb/5+ID4utrSqQRb2k+kTBmopbaZR3wz+QVx7Oj5xDeKZ4i9UU/RcMaGPxPfgH+2hsfrRdtOwXcZsVfnHuJXxo8Tvw6F2JN9APHAq7eIb0K7NPMYzcmd7WIZMbycncy/kfjG/xCxN/YD4kF9bfUEMRS/Sfxg8DUawsso4tH9rxF7m39IHKMJcXzmrcTn/Q5Nh+BA/BuNovEBiRDHcB5Cw9fwPyeOx/x7kTXfRWyf5cSxqocTx1N/QgwjA4lt8yYx+Ld0FpS2uIg4xGQecczqLwqWX5Asv5oYuI8m7ofb0tRjxN7i6cSe2OdpGE99ETHQ5IfnZTQeM5tzBbG3d03nsP63pK5FST1jm1nnCRrOaJFvGfFgx+8lt89IpvOHzFxJ3F/nE/+ON9CyYtf9MbG39yUazoiR+z/4iDic4xji/jUmmc6ND/4f4t99at59/5T32P+PuL8uJYbbk2l7D/WaXnsKzSAOK5uYV9d/ENtkS+IH2UOT5/lGMv19ms8KLxJ7rq8nfqg9l/ih7F/EAxvvyFv3qGSb/YmvU7n26E3sFIDYJucly88h/n83p6X9RMpUTQhh7WtJ0ro3mhjC9lrLeh3JBOK47KMzrqMUHiT2UPpVeuWaT8NpGvNdTwzh80u03dHJdicUzO+bbHd0ibYrtRt7qCVJqg5LWpj/Fm0ftlWMlTQeg56ziqYHuEplqa2nupIkSeWl8DSIOaX+xdfbWpj/T+I55aWy55APSZIkKQWHfEiSJEkpGKglSZKkFMp6DPVmm20W+vXrl3UZkiRJqnAzZ858M4TQ7LnryzpQ9+vXjxkzWjpHvCRJkrRu1NTUvNrSMod8SJIkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJKkZl112GfX19QwYMIBLL70UgNmzZzNkyBB22mknDj74YN55552Mq1RHYKCWJEkq8Nxzz3Hdddcxffp0Zs+ezd13381LL73E8ccfz4UXXsizzz7LiBEjuPjii7MuVR2AgVqSJKnACy+8wJ577smGG25IbW0te++9N3feeSdz585l6NChAAwbNozbb78940rVERioJUmSCtTX1/PQQw+xbNky3nvvPaZOncrChQupr69nypQpANx2220sXLgw40rVERioJUmSCtTV1XHmmWcybNgwhg8fzi677EJtbS033ngjV111FYMGDWLFihV07do161LVARioJUmSmjF27FieeuopHnroIbp37862227LDjvswD333MPMmTMZNWoU22yzTdZlqgMwUEuSJDVj6dKlACxYsIA77riDUaNGfTpv9erVnH/++Zx00klZlqgOwkAtSZLUjJEjR7Ljjjty8MEHc9VVV7HpppsyefJktttuO3bYYQd69+7Ncccdl3WZ6gBqQghZ19Bmu+++e5gxY0bWZUiSJKnC1dTUzAwh7N7cMnuoJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlEJt1gVIkiS1xbhx47IuoeQmTpyYdQkqQikD9Y3AQcBSoD6Z1x34LdAPmA8cASxPlp0FjAU+AU4B/lzC2iRJUgWY/spbWZdQMnv07551CSpSKQP1L4ErgV/lzRsP3AdcmNweD5wJ7AgcCQwAegP3AtsRw7UkSVKLhp90TtYlrHPTrjkv6xLUCqUcQ/0QUPix8VDgpuT2TcBhefNvAT4EXgH+AexRwtokSZKkdaK9D0rsCSxJbi8BeiS3+wAL89ZblMyTJEmSOrSOclBiTTPzWvoJxxOTiyRJkpS59u6hfh3oldzuRTxgEWKP9BZ56/UFXmvhMa4Fdk8ukiRJUqbaO1BPAY5Nbh8L3JU3/0hgPaA/sC0wvZ1rkyRJklqtlEM+JgP7AJsRe6B/SDy7x63E0+MtAL6erDsnmf88sAr4Fp7hQ5IkSWWglIF6VAvz92th/o+SiyRJklQ2/OlxSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKIatA/R1gDvAcMBlYH+gO/AV4KbneNKPaJEmSpKJlEaj7AKcAuwP1QGfgSGA8cB+wbXI9PoPaJEmSpFbJqoe6Ftggud4QeA04FLgpWX4TcFg2pUmSJEnFyyJQLwZ+AiwAlgD/Au4BeibTJNc9Wrj/icCM5CJJkiRlKotAvSmxN7o/0Bv4DHB0K+5/LXG4yO7rvjRJkiSpdbII1F8GXgHeAD4G7gD+HXgd6JWs0wtYmkFtkiRJUqtkEagXAHsSx07XAPsBLwBTgGOTdY4F7sqgNkmSJKlVajPY5hPA74CngFXA08RhHBsBtwJjiaH76xnUJkmSJLVKFoEa4IfJJd+HxN5qSZIkqWz4S4mSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCsUE6g2A+uT2kcC3gY1LVpEkSZJURmqLWOf3QE/gn8BSYAVwG/CVEtYlSZIklYViAvUWxB7qhUCfZN7sklUkSZIklZFiAvXHwCbAMmBToKakFUmSJEllpJhA/VlgZnL7qeQ6lKYcSZIkqbwUE6j7lboISZIkqVwVE6i7ACcDQ5PpB4GJxKEgkiRJUlUrJlBfTQzVP0+mv5nMO75URUmSJEnlophA/QVgl7zp+/EsH5IkSRJQ3A+7fAJskze9dTJPkiRJqnrF9FB/H3gAmEc8Zd5WwHGlLEqSJEkqF8UE6vuAbYHtiYH678CHpSxKkiRJKhfFBOpjCqZz46l/tY5rkSRJkspOMYH6l8DjwAwafiUxYKCWJEmSigrUA4hjpgcCU4FJwJulLEqSJEkqF8Wc5eMF4AzgYGBH4gGKkiRJkiguUG8HXAhMIYbrfUtakSRJklRGignUfwf2Bl4E+gP/A1xeyqIkSZKkclHMGGrPOS1JkiS1oJhAfVPe7fWBzsDK0pQjSZIklZdihnzkHAcsBF4CTi9NOZIkSVJ5aU2g/jawA3Ec9ajSlCNJkiSVl2KGfOTUAMuS2w75kCRJkiguUP+B+MuIWxNPnVdDPB+1JEmSVPWKCdQ/Sa4vKWUhkiRJUjkqJlA/W4LtbgJcD9QTe7/HAHOB3wL9gPnAEcDyEmxbkiRJWmeKOShxCTADmJl3mZFyu5cB04gHOe5C/AXG8cB9wLbJ9fiU25AkSZJKrpge6ueBXdfhNjcGhgKjk+mPksuhwD7JvJuAB4Ez1+F2JUmSpHWumB7qzxLD7nBgZ1p3ZpDmbA28AfwCeJo49OMzQE9ibzjJdY+U25EkSZJKrphA/VdgJDAWuJo4vvmrKbZZC+yWPNauxFPwtWZ4x4nEISdph51IkiRJqRXT23xcwfTngd8Df2rjNhcllyeS6d8RA/XrQC9i73QvYGkL9782uUA8oFGSJEnKTGt+KTHnH8CwFNv8J/EnzLdPpvcjjtOeAhybzDsWuCvFNiRJkqR2UUwP9eUtzD8lxXb/C/g10BWYR+wF7wTcShxasgD4eorHlyRJktpFMYH6QGAFcczzB+tou7OA3ZuZv986enxJkiSpXRQz5GN74DrgeKALcDPxtHaSJElS1SsmUK8CriKeO3pz4FHga6UsSpIkSSoXxf70eO5sGjXE81L/FuhcqqIkSZKkclFMoD6o5FVIkiRJZaqYIR+vAt2IBwx+mdhD/Wopi5IkSZLKRTGB+nziz4PvQMMBiheUsihJkiSpXBQz5ONQYBdgdTLdGZgNnFWqoiRJkqRysaZAvVtyPQf4JvHgRICdgWfylj9VmtIkSZKkjm9NgfqS5Lo7MBiYn0z3A95Olgdg3xLVJkmSJHV4awrUX0qupwFfBN5NprsRfyL8qyWsS5IkSSoLxRyUuAUwKG96ELBVacqRJEmSyksxByUeCfwUuIM4xGMWcFQpi5IkSZLKRbG/lDis1IVIkiRJ5aiYIR+SJEmSWmCgliRJklIwUEuSJEkpFBOoPwv8DJiRXC5J5kmSJElVr5hAfSPwDnBEcnkH+EUpi5IkSZLKRTFn+dgGGJk3fS7x1HmSJElS1Sumh/p9YK+86S8m8yRJUgX55JNP2HXXXTnooIMAmD17NkOGDGGnnXbi4IMP5p133sm4QqljKiZQnwxcBcwHXgWuBE4qYU2SJCkDl112GXV1dZ9OH3/88Vx44YU8++yzjBgxgosvvjjD6qSOq5hAPQvYBdgZ2AnYFZhdyqIkSVL7WrRoEX/84x85/vjjP503d+5chg4dCsCwYcO4/fbbsypP6tCKCdQ7At8GNgAuBn5HDNWSJKlCnHbaaVx00UV06tQQDerr65kyZQoAt912GwsXLsyqPKlDKyZQ/wbYHngCmA7cClxfyqIkSVL7ufvuu+nRoweDBg1qNP/GG2/kqquuYtCgQaxYsYKuXbtmVKHUsRVzlo9OwH8BXwFuSOadVbKKJElSu3rkkUeYMmUKU6dO5YMPPuCdd97h6KOPZtKkSdxzzz0AvPjii/zxj3/MuFKpYyqmh3oj4HBi+B5BPIXexqUsSpIktZ8LLriARYsWMX/+fG655Rb23XdfJk2axNKlSwFYvXo1559/Pied5DkJpOYUE6j/ChycXB8CHAQ8VMqiJElS9iZPnsx2223HDjvsQO/evTnuuOOyLknqkIoZ8nEF8FSpC5EkSdnbZ5992GeffQA49dRTOfXUU7MtSCoDxfRQewCiJEmS1IJieqhrgU2BmoL5b637ciRJkqTyUkyg3h6YSeNAHYCtS1KRJEmSVEaKCdTP4w+5SJIkSc0qJlBLkqSMjRs3LusSSm7ixIlZlyC1STGBekjJq5AkSWs1/ZXKPXxpj/7dsy5BarNiAvUfgK8DbyfTmwK3EH85UZIktaPhJ52TdQnr3LRrzsu6BCmVYk6btzkNYRpgOdCjNOVIkiRJ5aWYQP0JsGXe9FbEs3xIkiRJVa+YIR//DfyN+NPjAEOBE0tWkSRJklRGignU04DdgD2J56L+DvBmKYuSJEmSykUxQz5qgOHEUP0HYENgj1IWJUmSJJWLYgL1z4mnzhuVTK8AripZRZIkSVIZKWbIx2Bi7/TTyfRyoGvJKpIkSZLKSDE91B8DnWk4s8fmwOqSVSRJkiSVkWIC9eXAncRzT/+IeMaPH5eyKEmSJKlcFDPk49fATGA/4gGKhwEvlLIoSZIkqVwUE6i7A0uByQXz3ipJRZIkSVIZKSZQzySOn64BegFLkumtS1iXJEmSVBaKCdT9824/DexaolokSZKkslPMQYk5XfF0eZIkSVIjxfRQ/yG5rgN+U8JaJEmSpLJTTKD+CfG804uAV0pbjiRJklReignUz+bd7p5327N8SJIkqeoVE6jfBF4H3iee6QM8y4ckSZIEFHdQ4onE4R6XANsSz/phmJYkSZIoLlBfD+wFrAc8ChxV0ookSZKkMlJMoD4cOBCYD1wNnAnMLmFNkiRJUtkoZgz1wQXTM0tRiCRJklSOignUx5W8CkmSJKlMFROop7Qw/5B1WYgkSZJUjooJ1HXA8aUuRJIkSSpHxQTqFcBfS12IJEmSVI6KOcvHLsDbwD+Bp4ArgM1KWZQkSZJULooJ1J2JPzm+DfCfxGB9UymLkiRJkspFMYEaYDWwEngJ+BEwrWQVSZIkSWWkmDHUEM/oMTS5/VfisA9JkiSp6hXTQ30BcCrwfHI5JZknSZIkVb1ieqgPBAYSh31AHD/9NHBWqYqSJEmSykWxY6g3ybv92VIUIkmSJJWjYnqoLyD2SD8A1BDHUp9dyqIkSZKkclFMoJ4MPAh8gRiozySeOk+SJEmqemsa8nFg3u0lwBTgLuLp8zzLhyRJksSaA/VlwNiCed8AngGWlqwiSZIkqYysacjHfwB/BPoAtwA/Bz4Cvgy8XPrSJEmSpI5vTT3US4C9icH6GeB64AAM05IkSdKn1nbavBXAV4FbicM91i95RZIkSVIZWdOQjxVASG7XAJ8B3gI+SeZvnHLbnYEZwGLgIKA78FugHzAfOAJYnnIbkiRJUkmtqYe6GzE0b5zc7gRsmDc/rVOBF/KmxwP3Adsm1+PXwTYkSZKkkir2lxLXtb7E0/JdnzfvUOLPmpNcH9beRUmSJEmtlVWgvhQ4A1idN68n8UBIkuse7V2UJEmS1FpZBOqDiOexntnG+59IHHs9Y51VJEmSJLVRMT89vq59ETiEeAq+9YnjsScBrwO9iL3TvWj5x2OuTS7QcNCkJEmSlIkseqjPIo6h7gccCdwPHE38afNjk3WOJf7MuSRJktShZTWGujkXAsOAl5LrC7MtR5IkSVq7LIZ85HswuQAsA/bLrBJJkiSpDTpSD7UkSZJUdgzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjXPvzkAABPpSURBVDBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQO1JKmqLFy4kC996UvU1dUxYMAALrvsMgAmTJhAnz59GDhwIAMHDmTq1KkZVyqpXNRmXYAkSe2ptraWSy65hN12240VK1YwaNAghg0bBsB3vvMdTj/99IwrlFRuDNSSpKrSq1cvevXqBUC3bt2oq6tj8eLFGVclqZw55EOSVLXmz5/P008/zeDBgwG48sor2XnnnRkzZgzLly/PuDpJ5cJALUmqSu+++y4jR47k0ksvZeONN+bkk0/m5ZdfZtasWfTq1Yvvfe97WZcoqUwYqCVJVefjjz9m5MiRHHXUURx++OEA9OzZk86dO9OpUydOOOEEpk+fnnGVksqFgVqSVFVCCIwdO5a6ujq++93vfjp/yZIln96+8847qa+vz6I8SWXIgxIlSVXlkUce4eabb2annXZi4MCBAPz4xz9m8uTJzJo1i5qaGvr168fEiRMzrlRSuTBQS5Kqyl577UUIocn8Aw44IINqJFUCh3xIkiRJKRioJUmSpBQM1JIkSVIKBmpJkiQpBQ9KlCR1OOPGjcu6hJLzLCJS5TBQS5I6pOmvvJV1CSWzR//uWZcgaR0yUEuSOqzhJ52TdQnr3LRrzsu6BEnrmGOoJUmSpBQM1JIkSVIKBmpJkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSlYKCWJEmSUjBQS5IkSSkYqCVJkqQUDNSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALUmSJKVgoJZUMcaMGUOPHj2or69vNP+KK65g++23Z8CAAZxxxhkZVSdJqlQGakkVY/To0UybNq3RvAceeIC77rqLZ555hjlz5nD66adnVJ0kqVJlEai3AB4AXgDmAKcm87sDfwFeSq43zaA2SWVs6NChdO/evdG8q6++mvHjx7PeeusB0KNHjyxKkyRVsCwC9Srge0AdsCfwLWBHYDxwH7Btcj0+g9okVZgXX3yRhx9+mMGDB7P33nvz5JNPZl2SJKnC1GawzSXJBWAFsae6D3AosE8y/ybgQeDMdq5NUoVZtWoVy5cv5/HHH+fJJ5/kiCOOYN68edTU1GRdmiSpQmQ9hrofsCvwBNCThqC9BGjpe9kTgRnJRZLWqG/fvhx++OHU1NSwxx570KlTJ958882sy5IkVZAsA/VGwO3AacA7rbjftcDuyUWS1uiwww7j/vvvB+Lwj48++ojNNtss46okSZUkq0DdhRimfw3ckcx7HeiV3O4FLM2gLkllbNSoUQwZMoS5c+fSt29fbrjhBsaMGcO8efOor6/nyCOP5KabbnK4hyRpncpiDHUNcANx7PRP8+ZPAY4FLkyu72r/0iSVs8mTJzc7f9KkSe1ciSSpmmQRqL8IfBN4FpiVzDubGKRvBcYCC4CvZ1CbJEmS1CpZBOq/EXupm7NfexYiSZIkpZX1WT4kSZKksmagliRJklLIYsiHpCo1bty4rEtoFxMnTsy6BElSOzJQS2pX0195K+sSSmqP/t2zLkGS1M4M1JLa3fCTzsm6hJKYds15WZcgScqAY6glSZKkFAzUkiRJUgoGakmSJCkFA7UkSZKUgoFakiRJSsFALZWpMWPG0KNHD+rr6z+dd9tttzFgwAA6derEjBkzMqxOkqTqYaCWytTo0aOZNm1ao3n19fXccccdDB06NKOqJEmqPp6HWipTQ4cOZf78+Y3m1dXVZVOMJElVzB5qSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCglsrUqFGjGDJkCHPnzqVv377ccMMN3HnnnfTt25fHHnuMAw88kK985StZlylJUsXzLB9SmZo8eXKz80eMGNHOlaicXHbZZVx33XWEEDjhhBM47bTTsi5JksqePdSSVCWee+45rrvuOqZPn87s2bO5++67eemll7IuS5LKnoFakqrECy+8wJ577smGG25IbW0te++9N3feeWfWZUlS2TNQS1KVqK+v56GHHmLZsmW89957TJ06lYULF2ZdliSVPQO1JFWJuro6zjzzTIYNG8bw4cPZZZddqK31UBpJbfOzn/2MAQMGUF9fz6hRo/jggw+yLikzvpJKJTJu3LisSyi5iRMnZl2CWmns2LGMHTsWgLPPPpu+fftmXJGkcrR48WIuv/xynn/+eTbYYAOOOOIIbrnlFkaPHp11aZkwUEslNP2Vt7IuoWT26N896xLUBkuXLqVHjx4sWLCAO+64g8ceeyzrkiSVqVWrVvH+++/TpUsX3nvvPXr37p11SZkxUEslNvykc7IuYZ2bds15WZegNho5ciTLli2jS5cuXHXVVWy66aZZlySpDPXp04fTTz+dLbfckg022ID999+f/fffP+uyMuMYakmqIg8//DDPP/88s2fPZr/99su6HEllavny5dx111288sorvPbaa6xcuZJJkyZlXVZmDNSSJElqlXvvvZf+/fuz+eab06VLFw4//HAeffTRrMvKjIFakiRJrbLlllvy+OOP89577xFC4L777qOuri7rsjJjoJYkSVKrDB48mK997Wvstttu7LTTTqxevZoTTzwx67Iy40GJkiRJarVzzz2Xc889N+syOgQDtSRlqBrOVw6es1xSZTNQS1LGKvl85eA5yyVVPgO1JHUAlXi+cvCc5ZKqgwclSpIkSSnYQ62y069fP7p160bnzp2pra1lxowZWZckSVKHUA3HZXTEYzIM1CpLDzzwAJtttlnWZUiS1OFU8nEZHfWYDAO1JElShanE4zI68jEZjqFW2ampqWH//fdn0KBBXHvttVmXI0mSqpw91Co7jzzyCL1792bp0qUMGzaMHXbYgaFDh2ZdliRJqlL2UKvs9O7dG4AePXowYsQIpk+fnnFFkiSpmhmoVVZWrlzJihUrPr19zz33UF9fn3FVkiSpmjnkQ2Xl9ddfZ8SIEQCsWrWKb3zjGwwfPjzjqiRJUjUzUKusbL311syePTvrMiRJkj7lkA9JkiQpBQO1JEmSlIKBWpIkSUrBQC1JkiSl4EGJHdjChQs55phj+Oc//0mnTp048cQTOfXUU7Muq1njxo3LuoSSmzhxYtYlSJKkDshA3YHV1tZyySWXsNtuu7FixQoGDRrEsGHD2HHHHbMurVnTX3kr6xJKZo/+3bMuQZIkdVAG6g6sV69e9OrVC4Bu3bpRV1fH4sWLO2ygBhh+0jlZl7DOTbvmvKxLkCRJHZhjqMvE/Pnzefrppxk8eHDWpUiSJCmPgboMvPvuu4wcOZJLL72UjTfeOOtyJEmSlMdA3cF9/PHHjBw5kqOOOorDDz8863IkSZJUwEDdgYUQGDt2LHV1dXz3u9/NuhxJkiQ1w0DdgT3yyCPcfPPN3H///QwcOJCBAwcyderUrMuSJElSHs/y0YHttddehBCyLkOSJElrYA+1JEmSlIKBWpIkSUrBQC1JkiSl4BjqNhg3blzWJZTcxIkTsy5BkiSpLBio22j6K29lXULJ7NG/e9YlSJIklQ0DdQrDTzon6xLWuWnXnJd1CZIkSWXFMdSSJElSCgZqSZIkKQUDtSRJkpSCgVqSJElKwUAtSZIkpWCgliRJklLwtHkpeIq5pmyTpmyTpmyTpmyT5tkuTdkmTdkmTdkm7asmhJB1DW1WU1PzBvBq1nWUWs+ePTd7/fXX38y6jo7GdmnKNmnKNmnKNmnKNmnKNmme7dJUFbXJViGEzZtbUNaBuorMAHbPuogOyHZpyjZpyjZpyjZpyjZpyjZpnu3SVNW3iWOoJUmSpBQM1JIkSVIKnSdMmJB1DSrOzKwL6KBsl6Zsk6Zsk6Zsk6Zsk6Zsk+bZLk1VdZs4hlqSJElKwSEfkiRJUgoG6vZxI7AUeC5v3i7AY8CzwB+AjQvusyXwLnB63rxByfr/AC4HakpUb3toTZv0A94HZiWXa/LuU61tArBzsmxOsnz9ZH61tslRNOwjs4DVwMBkWSW1CbSuXboANyXzXwDOyrtPJbVLa9qkK/CLZP5sYJ+8+1RSm2wBPED8u88BTk3mdwf+AryUXG+ad5+ziM99LvCVvPmV0i6tbZPPJeu/C1xZ8FjV2ibDiMM7nk2u9817rEppk9YLIXgp/WVoCGG3EMJzefOeDCHsndweE0L434L73B5CuC2EcHrevOkhhCEhhJoQwp9CCF/tAM+tPdqkX8F6+ZdqbZPaEMIzIYRdkunPhRA6V3mb5F92CiHMy5uupDZpbbt8I4RwS3J7wxDC/BD/pyqtXVrTJt8KIfwiud0jhDAzhNCpAtukV9ImhBC6hRBeDCHsGEK4KIQwPpk/PoTwf8ntHUMIs0MI64UQ+ocQXg6V97rS2jb5TAhhrxDCSSGEKwseq1rbZNcQQu/kdn0IYXEFtkmrL/ZQt4+HgLcK5m2fzIf4yW9k3rLDgHnET4o5vYi9K48BAfhVsl5z9k/Wewq4DdgoRe2l0to2aU41t8n+wDPE3jWAZcAnVHeb5BsFTE5uV1qbQOvaJQCfIf4y7gbAR8A7VF67tKZNdgTuS24vBd4mnkO30tpkCbE+gBXEHsg+wKHEby1IrnPP8VDgFuBD4BViL+MeVFa7tLZNVgJ/Az4oeJxqbpOngdeS23OI346uR2W1SasZqLPzHHBIcvvrxK9cIL7xnQmcW7B+H2BR3vSiZF6hzYAfAF8GdiOebP2766bkkmupTQD6E/+J/wr8RzKvmttkO+IL1p+JL0hnJPOruU3y/ScNgboa2gRabpffEUPBEmAB8BNi8KyGdmmpTWYTw0It8bVlULKsktukH7Ar8ATQk7g/kFz3SG73ARbm3Sf3/Cu1Xfqx9jZpiW0SjSS+N39I5bZJUWqzLqCKjSGOLzoHmELsNYIYpH9GHK+Vr7lxSM2domVPYu/LI8l0V+KnwHLQUpssIY4pX0Z84/s9MIDqbpNaYC/gC8B7xN62mcSex0LV0iY5g4ltkhtLWw37CbTcLnsQv73oTRwD+TBwL9XRLi21yY1AHfGN/FXgUWAVldsmGwG3A6fR/GtETkvPvxLbpdg2aYltEt+H/4/Y2wyV2SZFM1Bn5+807ITbAQcmtwcDXwMuAjYhHlj1AXEn75t3/77Er1w603DuxynAk8SvNkeVsPZSaalNPkwuEJ/ry8nyRVRvmywi9ta/mUxPJX7Sn0T1tknOkTT0TkN17CfQcrt8A5gGfEwc3vAIcXjDw1R+u7TUJquA7+St9yjxwKvlVF6bdCG+f/wauCOZ9zrx6/klyfXSZP4iGn/jk3v+lfY/1Jo2aUm1t0lf4E7gGOJ7MlRem7RO1oO4q+jSLzQ+WKZHct0phPCrEA+YKbzPhND4oMQnQwh7hobB/gc0c5/NQwgLQgifT6Y3DCFs1wGef5o22Tw0HBizdYgHQHSv8jbZNITwVPJcakMI94YQDqzyNsnNWxTifpL/GJXWJq1plzNDPACvJsQDrJ4PIexcoe1SbJtsmLQFIYRhIYSH8u5TSW1SkzzvSwvmXxwaH2x2UXJ7QGh8UOK80PDaWynt0to2yV1Gh6YHJVZrm2wS4n4yspnHqpQ2afUl8wKq5DI5hLAkhPBxiG/2Y0MIp4Z4JO2LIYQLQ9z5Cu83ITQO1LuH+Gbxcoj/2M3dhxDCviHu1M8kl0M6QBukaZORIYQ5If4DPxVCONg2CYQQjk7a5bnQ+MW/mttknxDC4808TiW1SWvbZaMQzxg0J8Qw/f0KbZfWtEm/EMLcEMILIX4Y3apC22SvED0TQpiVXA4I8axA94UQXkquu+fd57+T5z43ND5DQ6W0S1vaZH4I4a0Qwrsh7ls7Vnmb/CCEsDJv3Vmh4cNrpbRJqy/+UqIkSZKUgmf5kCRJklIwUEuSJEkpGKglSZKkFAzUkiRJUgoGakmSJCkFA7UklY/ngOeBWcBiYEKm1UiSAH8pUZLKzVeJP5d9OvGngiVJGbOHWpLKRxfgw2bmf5/4c77PAOcm8/oRe7QB6oDZNPys9O+JPwU8Bzix4LHeJfaAP593//zHKlxXkqqePdSSVD66ASsK5u0PbAvsAdQAU4ChwIJkeR/gFuAbwMJk3hjgLWADYhC/HViWLKsBBhJD9N0leA6SVHEM1JJUHjoTA/XKgvn7J5enk+mNiAF7QXJ7GnA/sTc65xRgRHJ7i2T9ZcT3hPda2P42xJ5rgNuAH7XxeUhSxTFQS1J52Bp4sZn5NcAFwMSC+f2IYfmbwHjisI8XgH2ALwNDiOH5QWD9vPssbmH7LxN7rjckBuvfteE5SFJFcgy1JJWHI4DHmpn/Z+IQjtwBin2AHsntF4DfAP9FDNw1wGeB5cQwvQOwZ95jfZ21D/N4P7lvl1Y/A0mqUPZQS1LHdzLwv8RhHHsl8zYnDgN5ihiac2H7XeBo4JO8+/8V+HvyODcAJxEPYJwLPJ6sc0jeNg4CugL9k3WnJbf/Rhx3/RDNH6QoSVWpJoSQdQ2SpDWbAMwHflnk/LYYnVznP1Y98DU837UkrZE91JIkiL3YhRbiWGlJWit7qCWp46sFAo2HcaxpviSpHRmoJUmSpBQ8y4ckSZKUgoFakiRJSsFALUmSJKVgoJYkSZJSMFBLkiRJKfx/rN6hPGCG1FgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 864x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "dark"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig, ax = plt.subplots()\n",
    "\n",
    "ax.bar(uniages, count, alpha=0.6, bottom=2, edgecolor=\"k\", linewidth=2)\n",
    "\n",
    "fig.set_figwidth(12)\n",
    "fig.set_figheight(8)\n",
    "\n",
    "ax.set_title('Количество просмотренных фильмов в 2020 по декадам').set_color('white')\n",
    "ax.set_xlabel('Декады').set_color('white')\n",
    "ax.set_ylabel('Количество фильмов').set_color('white')\n",
    "ax.tick_params(axis='x', colors='white')\n",
    "ax.tick_params(axis='y', colors='white')\n",
    "\n",
    "rects = ax.patches\n",
    "\n",
    "# Make some labels.\n",
    "labels = count\n",
    "\n",
    "for rect, label in zip(rects, labels):\n",
    "    height = rect.get_height()\n",
    "    ax.text(rect.get_x() + rect.get_width() / 2, height + 3, label,\n",
    "            ha='center', va='bottom')\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "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"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Содержание",
   "title_sidebar": "Содержание",
   "toc_cell": true,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}