Расчет расстояния между геокоординатами по прямой в Python (2).ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Расчет расстояния между геокоординатами по прямой в Python"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Считаем расстояния между объектами по их координатам. В данном примере будем считать расстояния от населенных пунктов до школ и выбирать ближайшую школу. \n",
    "\n",
    "Важно: расстояния считаются по прямой, без учета дорог, гор, рек и пр., поэтому дают только общее представление о дальности объектов. Чтобы точно рассчитать дистанцию и время в пути по дорогам, можно воспользоваться API матрицы расстояний Яндекс.Карт (платно, либо можно попробовать попросить бесплатно в исследовательских и научных целях по индивидуальному запросу) или OSRM — Open Sourced Routing Machine (бесплатно)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Скачивание данных"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. Данные по населенным пунктам скачиваем на сайте ИНИД (Инфраструктура научно-исследовательских данных) https://www.data-in.ru/data-catalog/datasets/160/\n",
    "2. Данные по школам — парсингом сайта https://schoolotzyv.ru/schools/9-russia/ (данные доступны в формате json по ссылке https://drive.google.com/file/d/12zw_ZroDTfYKSjsUCPZy3GRhTluzmljx/view?usp=sharing) По некоторым регионам на нем есть не все школы. Можно дополнить данными с сайтов https://arhangelsk.fulledu.ru/, https://russiaedu.ru/, набора открытых данных с лицензиями Рособрнадзора (требуется парсинг xml) http://obrnadzor.gov.ru/otkrytoe-pravitelstvo/opendata/7701537808-fbdrl/ и других источников."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2. Загрузка библиотек"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd # будем работать в pandas\n",
    "import numpy as np # numpy и sklearn для математических расчетов и использования формул\n",
    "import sklearn.neighbors\n",
    "import json # для работы с файлами в формате json"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. Загрузка и подготовка данных"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# загружаем датасет со школами в pandas\n",
    "\n",
    "with open('/Users/me/Downloads/schoolotzyv (1).json', 'r') as read_file:\n",
    "    otzyv = json.load(read_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>geo_lat</th>\n",
       "      <th>geo_long</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>54.154966</td>\n",
       "      <td>155.843419</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа с. Устьевое</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>52.928782</td>\n",
       "      <td>156.573372</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Большерецкая школа №5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>52.670512</td>\n",
       "      <td>156.238983</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №1 п. Октябрьский</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>52.824094</td>\n",
       "      <td>156.285057</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа с. Усть-Большерецк</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>51.494019</td>\n",
       "      <td>156.501408</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа п. Озерновский</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50804</th>\n",
       "      <td>55.924598</td>\n",
       "      <td>158.693755</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа с. Эссо</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50805</th>\n",
       "      <td>56.053578</td>\n",
       "      <td>158.971110</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа с. Анавгай</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50806</th>\n",
       "      <td>54.299330</td>\n",
       "      <td>155.948234</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа с. Соболево</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50807</th>\n",
       "      <td>55.026700</td>\n",
       "      <td>155.591163</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа п. Крутогоровский</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50808</th>\n",
       "      <td>55.609792</td>\n",
       "      <td>155.612839</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Начальная школа п. Ичинский</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50809 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         geo_lat    geo_long  \\\n",
       "0      54.154966  155.843419   \n",
       "1      52.928782  156.573372   \n",
       "2      52.670512  156.238983   \n",
       "3      52.824094  156.285057   \n",
       "4      51.494019  156.501408   \n",
       "...          ...         ...   \n",
       "50804  55.924598  158.693755   \n",
       "50805  56.053578  158.971110   \n",
       "50806  54.299330  155.948234   \n",
       "50807  55.026700  155.591163   \n",
       "50808  55.609792  155.612839   \n",
       "\n",
       "                                                     url  \\\n",
       "0      https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1      https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "2      https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "3      https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "4      https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "...                                                  ...   \n",
       "50804  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "50805  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "50806  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "50807  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "50808  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "\n",
       "                              text  \n",
       "0                Школа с. Устьевое  \n",
       "1            Большерецкая школа №5  \n",
       "2          Школа №1 п. Октябрьский  \n",
       "3         Школа с. Усть-Большерецк  \n",
       "4             Школа п. Озерновский  \n",
       "...                            ...  \n",
       "50804                Школа с. Эссо  \n",
       "50805             Школа с. Анавгай  \n",
       "50806            Школа с. Соболево  \n",
       "50807      Школа п. Крутогоровский  \n",
       "50808  Начальная школа п. Ичинский  \n",
       "\n",
       "[50809 rows x 4 columns]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "otzyv = pd.DataFrame(otzyv)\n",
    "otzyv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://schoolotzyv.ru/component/schools/9-russia/131-kamchatskij/64530-obshheobrazovatelnaya-shkola'"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# нам нужно узнать регионы, для этого выбираем любую ссылку, переходим по ней и смотрим, как в ссылках зашит нужный нам регион\n",
    "\n",
    "otzyv.loc[1,'url']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1245"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# для примера возьмем Нижегородскую область (если взять всю Россию, считаться будет долго)\n",
    "# она в ссылках на школы помечена как \"146-nizhegorodskaya\"\n",
    "# выбираем только те строки, которые содержат такую запись\n",
    "# подробнее о том как фильтровать датафреймы в pandas — в уроке https://istories.media/workshops/2021/03/05/python-biblioteka-pandas-chast-1/\n",
    "\n",
    "\n",
    "schools_nn = otzyv[otzyv['url'].str.contains('146-nizhegorodskaya')]\n",
    "len(schools_nn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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>geo_lat</th>\n",
       "      <th>geo_long</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7598</th>\n",
       "      <td>55.784521</td>\n",
       "      <td>44.781727</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Большемурашкинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7599</th>\n",
       "      <td>55.825548</td>\n",
       "      <td>44.761182</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Холязинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7600</th>\n",
       "      <td>55.886998</td>\n",
       "      <td>44.695407</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Кишкинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7601</th>\n",
       "      <td>55.820749</td>\n",
       "      <td>44.688356</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Советская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7602</th>\n",
       "      <td>55.829173</td>\n",
       "      <td>44.525374</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Карабатовская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8838</th>\n",
       "      <td>56.181499</td>\n",
       "      <td>44.075750</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Мореновская санаторно-лесная школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8839</th>\n",
       "      <td>56.288776</td>\n",
       "      <td>44.003723</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Нижегородская школа-интернат для слепых</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8840</th>\n",
       "      <td>56.530916</td>\n",
       "      <td>43.459353</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Нижегородская кадетская школа-интернат им. Мар...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43394</th>\n",
       "      <td>56.263447</td>\n",
       "      <td>44.015293</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №131 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45225</th>\n",
       "      <td>56.363588</td>\n",
       "      <td>43.820008</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Сормовская православная гимназия Нижний Новгород</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1245 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         geo_lat   geo_long  \\\n",
       "7598   55.784521  44.781727   \n",
       "7599   55.825548  44.761182   \n",
       "7600   55.886998  44.695407   \n",
       "7601   55.820749  44.688356   \n",
       "7602   55.829173  44.525374   \n",
       "...          ...        ...   \n",
       "8838   56.181499  44.075750   \n",
       "8839   56.288776  44.003723   \n",
       "8840   56.530916  43.459353   \n",
       "43394  56.263447  44.015293   \n",
       "45225  56.363588  43.820008   \n",
       "\n",
       "                                                     url  \\\n",
       "7598   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "7599   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "7600   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "7601   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "7602   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "...                                                  ...   \n",
       "8838   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "8839   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "8840   https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "43394  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "45225  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "\n",
       "                                                    text  \n",
       "7598                            Большемурашкинская школа  \n",
       "7599                                   Холязинская школа  \n",
       "7600                                    Кишкинская школа  \n",
       "7601                                     Советская школа  \n",
       "7602                                 Карабатовская школа  \n",
       "...                                                  ...  \n",
       "8838                  Мореновская санаторно-лесная школа  \n",
       "8839             Нижегородская школа-интернат для слепых  \n",
       "8840   Нижегородская кадетская школа-интернат им. Мар...  \n",
       "43394                         Школа №131 Нижний Новгород  \n",
       "45225   Сормовская православная гимназия Нижний Новгород  \n",
       "\n",
       "[1245 rows x 4 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schools_nn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "# поскольку мы выбрали только некоторые строки, индексы датафрейма сбились\n",
    "# чтобы они опять начинались с нуля, нужно их сбросить методом reset_index\n",
    "\n",
    "schools_nn = schools_nn.reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>id</th>\n",
       "      <th>region</th>\n",
       "      <th>municipality</th>\n",
       "      <th>settlement</th>\n",
       "      <th>type</th>\n",
       "      <th>population</th>\n",
       "      <th>children</th>\n",
       "      <th>latitude_dms</th>\n",
       "      <th>longitude_dms</th>\n",
       "      <th>latitude_dd</th>\n",
       "      <th>longitude_dd</th>\n",
       "      <th>oktmo</th>\n",
       "      <th>dadata</th>\n",
       "      <th>rosstat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Орловская область</td>\n",
       "      <td>Болховский</td>\n",
       "      <td>Колонтаева</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53.22.07</td>\n",
       "      <td>035.54.36</td>\n",
       "      <td>53.368611</td>\n",
       "      <td>35.910000</td>\n",
       "      <td>5.460442e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Республика Крым</td>\n",
       "      <td>Алушта</td>\n",
       "      <td>Пушкино</td>\n",
       "      <td>с</td>\n",
       "      <td>273</td>\n",
       "      <td>0</td>\n",
       "      <td>44.35.45</td>\n",
       "      <td>034.20.27</td>\n",
       "      <td>44.595833</td>\n",
       "      <td>34.340833</td>\n",
       "      <td>3.570300e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Липецкая область</td>\n",
       "      <td>Лев-Толстовский район</td>\n",
       "      <td>Барятино</td>\n",
       "      <td>с</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>53.15.46</td>\n",
       "      <td>039.30.14</td>\n",
       "      <td>53.262778</td>\n",
       "      <td>39.503889</td>\n",
       "      <td>4.263641e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Тверская область</td>\n",
       "      <td>Селижаровский район</td>\n",
       "      <td>Хилово</td>\n",
       "      <td>д</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>56.54.20</td>\n",
       "      <td>033.25.09</td>\n",
       "      <td>56.905556</td>\n",
       "      <td>33.419167</td>\n",
       "      <td>2.865043e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Томская область</td>\n",
       "      <td>Парабельский район</td>\n",
       "      <td>Басмасово</td>\n",
       "      <td>д</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>58.38.12</td>\n",
       "      <td>082.02.40</td>\n",
       "      <td>58.636667</td>\n",
       "      <td>82.044444</td>\n",
       "      <td>6.964444e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155916</th>\n",
       "      <td>155916</td>\n",
       "      <td>Ульяновская область</td>\n",
       "      <td>Вешкаймский район</td>\n",
       "      <td>Ребровка</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53.59.12</td>\n",
       "      <td>046.48.35</td>\n",
       "      <td>53.986667</td>\n",
       "      <td>46.809722</td>\n",
       "      <td>7.360744e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155917</th>\n",
       "      <td>155917</td>\n",
       "      <td>Псковская область</td>\n",
       "      <td>Палкинский район</td>\n",
       "      <td>Шадрица</td>\n",
       "      <td>д</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>57.29.03</td>\n",
       "      <td>028.08.48</td>\n",
       "      <td>57.484167</td>\n",
       "      <td>28.146667</td>\n",
       "      <td>5.863742e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155918</th>\n",
       "      <td>155918</td>\n",
       "      <td>Псковская область</td>\n",
       "      <td>Себежский район</td>\n",
       "      <td>Овчинниково</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.19.48</td>\n",
       "      <td>028.26.17</td>\n",
       "      <td>56.330000</td>\n",
       "      <td>28.438056</td>\n",
       "      <td>5.865410e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155919</th>\n",
       "      <td>155919</td>\n",
       "      <td>Тульская область</td>\n",
       "      <td>рабочий пос. Новогуровский</td>\n",
       "      <td>Новогуровский</td>\n",
       "      <td>рп</td>\n",
       "      <td>3398</td>\n",
       "      <td>305</td>\n",
       "      <td>54.28.03</td>\n",
       "      <td>037.20.19</td>\n",
       "      <td>54.467500</td>\n",
       "      <td>37.338611</td>\n",
       "      <td>7.070200e+10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155920</th>\n",
       "      <td>155920</td>\n",
       "      <td>Краснодарский край</td>\n",
       "      <td>Город-курорт Анапа</td>\n",
       "      <td>Гостагаевская</td>\n",
       "      <td>ст-ца</td>\n",
       "      <td>12566</td>\n",
       "      <td>2980</td>\n",
       "      <td>45.01.21</td>\n",
       "      <td>037.30.15</td>\n",
       "      <td>45.022500</td>\n",
       "      <td>37.504167</td>\n",
       "      <td>3.703000e+09</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>155921 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id               region                municipality  \\\n",
       "0            0    Орловская область                  Болховский   \n",
       "1            1      Республика Крым                      Алушта   \n",
       "2            2     Липецкая область       Лев-Толстовский район   \n",
       "3            3     Тверская область         Селижаровский район   \n",
       "4            4      Томская область          Парабельский район   \n",
       "...        ...                  ...                         ...   \n",
       "155916  155916  Ульяновская область           Вешкаймский район   \n",
       "155917  155917    Псковская область            Палкинский район   \n",
       "155918  155918    Псковская область             Себежский район   \n",
       "155919  155919     Тульская область  рабочий пос. Новогуровский   \n",
       "155920  155920   Краснодарский край          Город-курорт Анапа   \n",
       "\n",
       "           settlement   type  population  children latitude_dms longitude_dms  \\\n",
       "0          Колонтаева      д           0         0     53.22.07     035.54.36   \n",
       "1             Пушкино      с         273         0     44.35.45     034.20.27   \n",
       "2            Барятино      с           7         1     53.15.46     039.30.14   \n",
       "3              Хилово      д           2         0     56.54.20     033.25.09   \n",
       "4           Басмасово      д           6         0     58.38.12     082.02.40   \n",
       "...               ...    ...         ...       ...          ...           ...   \n",
       "155916       Ребровка      д           0         0     53.59.12     046.48.35   \n",
       "155917        Шадрица      д           1         0     57.29.03     028.08.48   \n",
       "155918    Овчинниково      д           0         0     56.19.48     028.26.17   \n",
       "155919  Новогуровский     рп        3398       305     54.28.03     037.20.19   \n",
       "155920  Гостагаевская  ст-ца       12566      2980     45.01.21     037.30.15   \n",
       "\n",
       "        latitude_dd  longitude_dd         oktmo  dadata  rosstat  \n",
       "0         53.368611     35.910000  5.460442e+10       0        1  \n",
       "1         44.595833     34.340833  3.570300e+10       0        1  \n",
       "2         53.262778     39.503889  4.263641e+10       0        1  \n",
       "3         56.905556     33.419167  2.865043e+10       0        1  \n",
       "4         58.636667     82.044444  6.964444e+10       0        1  \n",
       "...             ...           ...           ...     ...      ...  \n",
       "155916    53.986667     46.809722  7.360744e+10       0        1  \n",
       "155917    57.484167     28.146667  5.863742e+10       0        1  \n",
       "155918    56.330000     28.438056  5.865410e+10       0        1  \n",
       "155919    54.467500     37.338611  7.070200e+10       1        0  \n",
       "155920    45.022500     37.504167  3.703000e+09       1        0  \n",
       "\n",
       "[155921 rows x 14 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# загружаем датасет с населенными пунктами\n",
    "\n",
    "places = pd.read_csv('/Users/me/Downloads/places.csv')\n",
    "places"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "163"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# для примера выбираем только Нижегородскую область и только один район — например, Воскресенский \n",
    "# (чтобы точно всё быстро посчиталось на небольшом объеме данных)\n",
    "\n",
    "places_voskresensk = places[(places['region'] == 'Нижегородская область') & \n",
    "                            (places['municipality'] == 'Воскресенский район')]\n",
    "len(places_voskresensk)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "# опять обновляем индексы, чтобы шли с нуля \n",
    "\n",
    "places_voskresensk = places_voskresensk.reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4. Создание словарей"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Прежде чем считать расстояния, нам понадобится создать два словаря — с населенными пунктами и со школами. Это нужно, чтобы в дальнейшем мы могли сопоставить разные датафреймы по какому-то уникальному параметру, доставать и добавлять нужные нам данные. Это нам пригодится на последних этапах. \n",
    "\n",
    "Для населенных пунктов таким уникальным параметром будет код ОКТМО (Общероссийского классификатора территорий муниципальных образований)\n",
    "\n",
    "Перед этим нам нужно убедиться, что:\n",
    "1) Во всех нужных нам столбцахуказан правильный тип данных\n",
    "\n",
    "2) Удалить дубликаты в тех столбцах, которые будут уникальным ключом для словаря (для населенных пунктов это поле oktmo, для школ — url, ссылка)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('float64')"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# смотрим какой тип данный в столбце 'oktmo'\n",
    "\n",
    "places_voskresensk['oktmo'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "# float, а нам нужны строки, поэтому меняем сначала на integer, а затем на str"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places_voskresensk['oktmo'] = places_voskresensk['oktmo'].astype('int').astype('str')\n",
    "places_voskresensk['oktmo'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>id</th>\n",
       "      <th>region</th>\n",
       "      <th>municipality</th>\n",
       "      <th>settlement</th>\n",
       "      <th>type</th>\n",
       "      <th>population</th>\n",
       "      <th>children</th>\n",
       "      <th>latitude_dms</th>\n",
       "      <th>longitude_dms</th>\n",
       "      <th>latitude_dd</th>\n",
       "      <th>longitude_dd</th>\n",
       "      <th>oktmo</th>\n",
       "      <th>dadata</th>\n",
       "      <th>rosstat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>88013</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Безводное</td>\n",
       "      <td>д</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>56.56.48</td>\n",
       "      <td>045.25.17</td>\n",
       "      <td>56.946667</td>\n",
       "      <td>45.421389</td>\n",
       "      <td>2.262245e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>105267</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Осиновка</td>\n",
       "      <td>д</td>\n",
       "      <td>57</td>\n",
       "      <td>8</td>\n",
       "      <td>56.37.21</td>\n",
       "      <td>045.33.42</td>\n",
       "      <td>56.622500</td>\n",
       "      <td>45.561667</td>\n",
       "      <td>2.262242e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>116684</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Пузеево</td>\n",
       "      <td>д</td>\n",
       "      <td>34</td>\n",
       "      <td>3</td>\n",
       "      <td>56.49.46</td>\n",
       "      <td>045.14.38</td>\n",
       "      <td>56.829444</td>\n",
       "      <td>45.243889</td>\n",
       "      <td>2.262240e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>127088</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Богданово</td>\n",
       "      <td>д</td>\n",
       "      <td>32</td>\n",
       "      <td>10</td>\n",
       "      <td>56.44.03</td>\n",
       "      <td>045.38.21</td>\n",
       "      <td>56.734167</td>\n",
       "      <td>45.639167</td>\n",
       "      <td>2.262241e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>129089</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Калиниха</td>\n",
       "      <td>д</td>\n",
       "      <td>233</td>\n",
       "      <td>68</td>\n",
       "      <td>56.48.50</td>\n",
       "      <td>045.25.58</td>\n",
       "      <td>56.813889</td>\n",
       "      <td>45.432778</td>\n",
       "      <td>2.262215e+10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                 region         municipality settlement type  \\\n",
       "94    88013  Нижегородская область  Воскресенский район  Безводное    д   \n",
       "107  105267  Нижегородская область  Воскресенский район   Осиновка    д   \n",
       "118  116684  Нижегородская область  Воскресенский район    Пузеево    д   \n",
       "133  127088  Нижегородская область  Воскресенский район  Богданово    д   \n",
       "135  129089  Нижегородская область  Воскресенский район   Калиниха    д   \n",
       "\n",
       "     population  children latitude_dms longitude_dms  latitude_dd  \\\n",
       "94           17         0     56.56.48     045.25.17    56.946667   \n",
       "107          57         8     56.37.21     045.33.42    56.622500   \n",
       "118          34         3     56.49.46     045.14.38    56.829444   \n",
       "133          32        10     56.44.03     045.38.21    56.734167   \n",
       "135         233        68     56.48.50     045.25.58    56.813889   \n",
       "\n",
       "     longitude_dd         oktmo  dadata  rosstat  \n",
       "94      45.421389  2.262245e+10       0        1  \n",
       "107     45.561667  2.262242e+10       0        1  \n",
       "118     45.243889  2.262240e+10       0        1  \n",
       "133     45.639167  2.262241e+10       0        1  \n",
       "135     45.432778  2.262215e+10       0        1  "
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# удаляем дубликты и сбрасываем индексы \n",
    "\n",
    "places_voskresensk[places_voskresensk['oktmo'].duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "places_voskresensk = places_voskresensk[~places_voskresensk['oktmo'].duplicated()]\n",
    "places_voskresensk = places_voskresensk.reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "158"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# собираем датафрейм с населенными пунктами в словарь \n",
    "\n",
    "\n",
    "places_by_oktmo = {} # пустой словарь \n",
    "for i in range(len(places_voskresensk)): # i это индекс, порядковый номер строки\n",
    "    el = places_voskresensk.loc[i] # записываем в переменную el строку с индексом i \n",
    "    places_by_oktmo[el['oktmo']] = el # создаем словарь, где ключом будет код октмо, \n",
    "                                    # а значением — соответствующая ему строка датафрейма\n",
    "len(places_voskresensk)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# (чтобы посмотреть, что содержится в el, попробуйте вывести на экран в отдельной ячейке places_voskresensk.loc[1] (или другое число))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                1902\n",
       "region           Нижегородская область\n",
       "municipality       Воскресенский район\n",
       "settlement                    Докукино\n",
       "type                                 с\n",
       "population                         237\n",
       "children                            40\n",
       "latitude_dms                  56.43.39\n",
       "longitude_dms                045.41.59\n",
       "latitude_dd                    56.7275\n",
       "longitude_dd                   45.6997\n",
       "oktmo                      2.26224e+10\n",
       "dadata                               0\n",
       "rosstat                              1\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places_voskresensk.loc[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                4649\n",
       "region           Нижегородская область\n",
       "municipality       Воскресенский район\n",
       "settlement                   Рассадино\n",
       "type                                 д\n",
       "population                          11\n",
       "children                             2\n",
       "latitude_dms                  56.51.18\n",
       "longitude_dms                045.05.22\n",
       "latitude_dd                     56.855\n",
       "longitude_dd                   45.0894\n",
       "oktmo                      22622416166\n",
       "dadata                               0\n",
       "rosstat                              1\n",
       "Name: 5, dtype: object"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places_by_oktmo['22622416166'] # пример того что выдает словарь по ключу - коду октмо"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# переходим к датафрейму со школами \n",
    "# сначала меняем тип данных в столбцах с широтой и долгой — были строки, а нужны числа (float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schools_nn['geo_lat'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "float64\n",
      "float64\n"
     ]
    }
   ],
   "source": [
    "schools_nn['geo_lat'] = schools_nn['geo_lat'].astype('float')\n",
    "schools_nn['geo_long'] = schools_nn['geo_long'].astype('float')\n",
    "print(schools_nn['geo_lat'].dtype)\n",
    "print(schools_nn['geo_long'].dtype)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>geo_lat</th>\n",
       "      <th>geo_long</th>\n",
       "      <th>url</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>55.855785</td>\n",
       "      <td>45.458679</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Высокоосельская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>56.196832</td>\n",
       "      <td>43.855258</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №88 \"Новинская\" Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>54.916123</td>\n",
       "      <td>43.347369</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Лицей №3 Саров</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>54.916123</td>\n",
       "      <td>43.347369</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Лицей №15 Саров</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>56.235430</td>\n",
       "      <td>43.415811</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №23 Дзержинск</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>924</th>\n",
       "      <td>56.335550</td>\n",
       "      <td>44.113685</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №10 Бор</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>56.326388</td>\n",
       "      <td>43.955887</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Гимназия №2 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>56.289056</td>\n",
       "      <td>43.851548</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №75 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>56.312565</td>\n",
       "      <td>43.864385</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №109 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>56.302752</td>\n",
       "      <td>43.880537</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №167 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1028</th>\n",
       "      <td>56.280302</td>\n",
       "      <td>43.932639</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №182 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1031</th>\n",
       "      <td>56.289365</td>\n",
       "      <td>43.942520</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №185 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>56.315505</td>\n",
       "      <td>43.894631</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №64 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>56.328609</td>\n",
       "      <td>44.015032</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Гимназия №1 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>56.326178</td>\n",
       "      <td>44.019892</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Гимназия №13 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1084</th>\n",
       "      <td>56.306767</td>\n",
       "      <td>43.993284</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Лицей №28 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1097</th>\n",
       "      <td>56.285858</td>\n",
       "      <td>44.050363</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №187 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1106</th>\n",
       "      <td>56.368420</td>\n",
       "      <td>43.814546</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №79 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1107</th>\n",
       "      <td>56.364700</td>\n",
       "      <td>43.800416</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №79 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1113</th>\n",
       "      <td>56.362062</td>\n",
       "      <td>43.856776</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №117 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1116</th>\n",
       "      <td>56.379586</td>\n",
       "      <td>43.829764</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №156 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1117</th>\n",
       "      <td>56.386209</td>\n",
       "      <td>43.757521</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №156 Нижний Новгород</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>56.343763</td>\n",
       "      <td>43.869272</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>Школа №183 Нижний Новгород</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        geo_lat   geo_long                                                url  \\\n",
       "317   55.855785  45.458679  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "405   56.196832  43.855258  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "814   54.916123  43.347369  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "824   54.916123  43.347369  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "850   56.235430  43.415811  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "924   56.335550  44.113685  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "989   56.326388  43.955887  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "996   56.289056  43.851548  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "999   56.312565  43.864385  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1004  56.302752  43.880537  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1028  56.280302  43.932639  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1031  56.289365  43.942520  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1036  56.315505  43.894631  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1052  56.328609  44.015032  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1057  56.326178  44.019892  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1084  56.306767  43.993284  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1097  56.285858  44.050363  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1106  56.368420  43.814546  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1107  56.364700  43.800416  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1113  56.362062  43.856776  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1116  56.379586  43.829764  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1117  56.386209  43.757521  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1119  56.343763  43.869272  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "\n",
       "                                       text  \n",
       "317                   Высокоосельская школа  \n",
       "405   Школа №88 \"Новинская\" Нижний Новгород  \n",
       "814                          Лицей №3 Саров  \n",
       "824                         Лицей №15 Саров  \n",
       "850                     Школа №23 Дзержинск  \n",
       "924                           Школа №10 Бор  \n",
       "989             Гимназия №2 Нижний Новгород  \n",
       "996               Школа №75 Нижний Новгород  \n",
       "999              Школа №109 Нижний Новгород  \n",
       "1004             Школа №167 Нижний Новгород  \n",
       "1028             Школа №182 Нижний Новгород  \n",
       "1031             Школа №185 Нижний Новгород  \n",
       "1036              Школа №64 Нижний Новгород  \n",
       "1052            Гимназия №1 Нижний Новгород  \n",
       "1057           Гимназия №13 Нижний Новгород  \n",
       "1084              Лицей №28 Нижний Новгород  \n",
       "1097             Школа №187 Нижний Новгород  \n",
       "1106              Школа №79 Нижний Новгород  \n",
       "1107              Школа №79 Нижний Новгород  \n",
       "1113             Школа №117 Нижний Новгород  \n",
       "1116             Школа №156 Нижний Новгород  \n",
       "1117             Школа №156 Нижний Новгород  \n",
       "1119             Школа №183 Нижний Новгород  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# удаляем дубликаты \n",
    "schools_nn[schools_nn['url'].duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "schools_nn = schools_nn[~schools_nn['url'].duplicated()]\n",
    "schools_nn = schools_nn.reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# собираем такой же словарь, как с населенными пунктами, только ключом будет url школы "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1222"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schools_by_url = {}\n",
    "for i in range(len(schools_nn)):\n",
    "    el = schools_nn.loc[i]\n",
    "    schools_by_url[el['url']] = el\n",
    "len(schools_by_url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 5. Расчет матрицы расстояний"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Переходим к расчету расстояний между каждым населенным пунктом и каждой школой (матрица расстояний). За основу взят туториал Dana Lindquist https://medium.com/@danalindquist/finding-the-distance-between-two-lists-of-geographic-coordinates-9ace7e43bb2f"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# переводим координаты из градусов в радианы, потому что математические формулы обычно требуют \n",
    "# значения в радианах, а не в градусах.\n",
    "# делаем это с помощью библиотеки numpy\n",
    "\n",
    "schools_nn[['lat_radians_A','long_radians_A']] = (\n",
    "    np.radians(schools_nn.loc[:,['geo_lat','geo_long']])\n",
    ")\n",
    "places_voskresensk[['lat_radians_B','long_radians_B']] = (\n",
    "    np.radians(places_voskresensk.loc[:,['latitude_dd','longitude_dd']])\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# считаем расстояния с помощью формулы из библиотеки scikit-learn\n",
    "# она вычисляет гаверсинусное расстояние, то есть представляет форму Земли как идеальную сферу (а не геоид, \n",
    "# как на самом деле), и за счет этого обеспечивает быстрые вычисления\n",
    "# если требуется измерение в км, то нужно умножить на 6371, если в милях — на 3959\n",
    "\n",
    "\n",
    "dist = sklearn.neighbors.DistanceMetric.get_metric('haversine')\n",
    "dist_matrix = (dist.pairwise\n",
    "    (schools_nn[['lat_radians_A','long_radians_A']],\n",
    "     places_voskresensk[['lat_radians_B','long_radians_B']])*6371\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# создаем матрицу расстояний — таблицу, в которой индексами будут url школ,\n",
    "# колонками - октмо населенных пунктов, а в ячейках будет расстояние от каждого населенного пункта до каждой школы\n",
    "\n",
    "df_dist_matrix = (\n",
    "    pd.DataFrame(dist_matrix,index=schools_nn['url'], \n",
    "                 columns=places_voskresensk['oktmo'])\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>oktmo</th>\n",
       "      <th>22622404111</th>\n",
       "      <th>22622408141</th>\n",
       "      <th>22622440121</th>\n",
       "      <th>22622440151</th>\n",
       "      <th>22622420111</th>\n",
       "      <th>22622416166</th>\n",
       "      <th>22622420181</th>\n",
       "      <th>22622460141</th>\n",
       "      <th>22622460111</th>\n",
       "      <th>22622404126</th>\n",
       "      <th>...</th>\n",
       "      <th>22622416131</th>\n",
       "      <th>22622452106</th>\n",
       "      <th>22622424161</th>\n",
       "      <th>22622432101</th>\n",
       "      <th>22622456121</th>\n",
       "      <th>22622456126</th>\n",
       "      <th>22622460136</th>\n",
       "      <th>22622416106</th>\n",
       "      <th>22622408221</th>\n",
       "      <th>22622416176</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</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>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72980-bolshemurashkinskaya-shkola</th>\n",
       "      <td>127.780010</td>\n",
       "      <td>119.201251</td>\n",
       "      <td>121.505056</td>\n",
       "      <td>121.558613</td>\n",
       "      <td>138.361254</td>\n",
       "      <td>120.534432</td>\n",
       "      <td>148.722942</td>\n",
       "      <td>132.194424</td>\n",
       "      <td>142.803590</td>\n",
       "      <td>135.330889</td>\n",
       "      <td>...</td>\n",
       "      <td>121.458973</td>\n",
       "      <td>117.701803</td>\n",
       "      <td>132.833291</td>\n",
       "      <td>103.604210</td>\n",
       "      <td>92.130892</td>\n",
       "      <td>96.823597</td>\n",
       "      <td>134.277545</td>\n",
       "      <td>120.449068</td>\n",
       "      <td>122.370188</td>\n",
       "      <td>116.026382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72981-xolyazinskaya-shkola</th>\n",
       "      <td>123.720058</td>\n",
       "      <td>115.823127</td>\n",
       "      <td>117.546010</td>\n",
       "      <td>117.649458</td>\n",
       "      <td>134.471863</td>\n",
       "      <td>116.243516</td>\n",
       "      <td>144.827854</td>\n",
       "      <td>128.204140</td>\n",
       "      <td>138.759703</td>\n",
       "      <td>131.170195</td>\n",
       "      <td>...</td>\n",
       "      <td>117.191972</td>\n",
       "      <td>113.765678</td>\n",
       "      <td>129.002524</td>\n",
       "      <td>100.337598</td>\n",
       "      <td>88.381831</td>\n",
       "      <td>93.128736</td>\n",
       "      <td>130.258931</td>\n",
       "      <td>116.184689</td>\n",
       "      <td>119.259356</td>\n",
       "      <td>111.681204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72982-kishkinskaya-shkola</th>\n",
       "      <td>118.412264</td>\n",
       "      <td>112.124641</td>\n",
       "      <td>112.501179</td>\n",
       "      <td>112.726399</td>\n",
       "      <td>129.565667</td>\n",
       "      <td>110.337659</td>\n",
       "      <td>139.892652</td>\n",
       "      <td>123.062810</td>\n",
       "      <td>133.469609</td>\n",
       "      <td>125.592787</td>\n",
       "      <td>...</td>\n",
       "      <td>111.350746</td>\n",
       "      <td>108.785140</td>\n",
       "      <td>124.245367</td>\n",
       "      <td>96.933304</td>\n",
       "      <td>83.931064</td>\n",
       "      <td>88.787344</td>\n",
       "      <td>125.044115</td>\n",
       "      <td>110.352227</td>\n",
       "      <td>116.124489</td>\n",
       "      <td>105.629020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72983-sovetskaya-shkola</th>\n",
       "      <td>125.547781</td>\n",
       "      <td>118.591238</td>\n",
       "      <td>119.547172</td>\n",
       "      <td>119.728550</td>\n",
       "      <td>136.566682</td>\n",
       "      <td>117.629897</td>\n",
       "      <td>146.906802</td>\n",
       "      <td>130.145235</td>\n",
       "      <td>140.603053</td>\n",
       "      <td>132.808803</td>\n",
       "      <td>...</td>\n",
       "      <td>118.629160</td>\n",
       "      <td>115.806887</td>\n",
       "      <td>131.188492</td>\n",
       "      <td>103.240912</td>\n",
       "      <td>90.730090</td>\n",
       "      <td>95.542290</td>\n",
       "      <td>132.151483</td>\n",
       "      <td>117.628477</td>\n",
       "      <td>122.298962</td>\n",
       "      <td>112.948994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72984-karabatovskaya-shkola</th>\n",
       "      <td>128.138590</td>\n",
       "      <td>123.418979</td>\n",
       "      <td>122.566730</td>\n",
       "      <td>122.928302</td>\n",
       "      <td>139.735407</td>\n",
       "      <td>119.245118</td>\n",
       "      <td>150.004291</td>\n",
       "      <td>132.979666</td>\n",
       "      <td>143.171487</td>\n",
       "      <td>134.932790</td>\n",
       "      <td>...</td>\n",
       "      <td>120.355214</td>\n",
       "      <td>118.937253</td>\n",
       "      <td>134.590252</td>\n",
       "      <td>108.458941</td>\n",
       "      <td>94.722713</td>\n",
       "      <td>99.652593</td>\n",
       "      <td>134.865274</td>\n",
       "      <td>119.374763</td>\n",
       "      <td>127.767941</td>\n",
       "      <td>114.319733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74321-morenovskaya-sanatorno-lesnaya-shkola</th>\n",
       "      <td>109.968831</td>\n",
       "      <td>116.800653</td>\n",
       "      <td>106.948276</td>\n",
       "      <td>108.149707</td>\n",
       "      <td>123.425079</td>\n",
       "      <td>97.338667</td>\n",
       "      <td>132.673613</td>\n",
       "      <td>115.571593</td>\n",
       "      <td>123.769819</td>\n",
       "      <td>114.042900</td>\n",
       "      <td>...</td>\n",
       "      <td>98.851499</td>\n",
       "      <td>104.211814</td>\n",
       "      <td>119.796793</td>\n",
       "      <td>105.470310</td>\n",
       "      <td>87.379967</td>\n",
       "      <td>92.138507</td>\n",
       "      <td>116.737566</td>\n",
       "      <td>98.057401</td>\n",
       "      <td>124.171646</td>\n",
       "      <td>91.788609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74322-shkola-internat</th>\n",
       "      <td>104.968841</td>\n",
       "      <td>114.928398</td>\n",
       "      <td>102.785402</td>\n",
       "      <td>104.197396</td>\n",
       "      <td>118.640925</td>\n",
       "      <td>91.580269</td>\n",
       "      <td>127.413489</td>\n",
       "      <td>110.651597</td>\n",
       "      <td>118.089019</td>\n",
       "      <td>108.138781</td>\n",
       "      <td>...</td>\n",
       "      <td>93.169509</td>\n",
       "      <td>100.396198</td>\n",
       "      <td>115.530698</td>\n",
       "      <td>104.960729</td>\n",
       "      <td>86.403053</td>\n",
       "      <td>90.886306</td>\n",
       "      <td>111.579893</td>\n",
       "      <td>92.457350</td>\n",
       "      <td>122.939105</td>\n",
       "      <td>86.021124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74323-shkola-internat</th>\n",
       "      <td>120.463279</td>\n",
       "      <td>138.754476</td>\n",
       "      <td>121.059528</td>\n",
       "      <td>122.986539</td>\n",
       "      <td>133.820130</td>\n",
       "      <td>105.852909</td>\n",
       "      <td>140.460314</td>\n",
       "      <td>125.955933</td>\n",
       "      <td>130.299063</td>\n",
       "      <td>120.332582</td>\n",
       "      <td>...</td>\n",
       "      <td>107.527701</td>\n",
       "      <td>119.887320</td>\n",
       "      <td>132.554991</td>\n",
       "      <td>132.654529</td>\n",
       "      <td>114.263136</td>\n",
       "      <td>117.778936</td>\n",
       "      <td>126.038017</td>\n",
       "      <td>107.163618</td>\n",
       "      <td>147.985108</td>\n",
       "      <td>100.901045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/58100-shkola-131</th>\n",
       "      <td>106.284631</td>\n",
       "      <td>115.547045</td>\n",
       "      <td>103.909753</td>\n",
       "      <td>105.275720</td>\n",
       "      <td>119.920841</td>\n",
       "      <td>93.051856</td>\n",
       "      <td>128.806651</td>\n",
       "      <td>111.954990</td>\n",
       "      <td>119.569370</td>\n",
       "      <td>109.660819</td>\n",
       "      <td>...</td>\n",
       "      <td>94.625817</td>\n",
       "      <td>101.439049</td>\n",
       "      <td>116.691400</td>\n",
       "      <td>105.257912</td>\n",
       "      <td>86.777907</td>\n",
       "      <td>91.331990</td>\n",
       "      <td>112.937576</td>\n",
       "      <td>93.894249</td>\n",
       "      <td>123.420370</td>\n",
       "      <td>87.487281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/119073-soromovskaya-gimnaziya</th>\n",
       "      <td>109.033181</td>\n",
       "      <td>122.118390</td>\n",
       "      <td>107.818924</td>\n",
       "      <td>109.437242</td>\n",
       "      <td>122.773815</td>\n",
       "      <td>94.974386</td>\n",
       "      <td>130.897862</td>\n",
       "      <td>114.728346</td>\n",
       "      <td>121.172620</td>\n",
       "      <td>111.078790</td>\n",
       "      <td>...</td>\n",
       "      <td>96.625763</td>\n",
       "      <td>105.838130</td>\n",
       "      <td>120.280756</td>\n",
       "      <td>113.477611</td>\n",
       "      <td>94.780411</td>\n",
       "      <td>98.952228</td>\n",
       "      <td>115.368898</td>\n",
       "      <td>96.025768</td>\n",
       "      <td>130.639277</td>\n",
       "      <td>89.519101</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1222 rows × 158 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "oktmo                                               22622404111  22622408141  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   127.780010   119.201251   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   123.720058   115.823127   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   118.412264   112.124641   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   125.547781   118.591238   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   128.138590   123.418979   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   109.968831   116.800653   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   104.968841   114.928398   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   120.463279   138.754476   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   106.284631   115.547045   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   109.033181   122.118390   \n",
       "\n",
       "oktmo                                               22622440121  22622440151  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   121.505056   121.558613   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   117.546010   117.649458   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   112.501179   112.726399   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   119.547172   119.728550   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   122.566730   122.928302   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   106.948276   108.149707   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   102.785402   104.197396   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   121.059528   122.986539   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   103.909753   105.275720   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   107.818924   109.437242   \n",
       "\n",
       "oktmo                                               22622420111  22622416166  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   138.361254   120.534432   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   134.471863   116.243516   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   129.565667   110.337659   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   136.566682   117.629897   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   139.735407   119.245118   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   123.425079    97.338667   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   118.640925    91.580269   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   133.820130   105.852909   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   119.920841    93.051856   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   122.773815    94.974386   \n",
       "\n",
       "oktmo                                               22622420181  22622460141  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   148.722942   132.194424   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   144.827854   128.204140   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   139.892652   123.062810   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   146.906802   130.145235   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   150.004291   132.979666   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   132.673613   115.571593   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   127.413489   110.651597   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   140.460314   125.955933   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   128.806651   111.954990   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   130.897862   114.728346   \n",
       "\n",
       "oktmo                                               22622460111  22622404126  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   142.803590   135.330889   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   138.759703   131.170195   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   133.469609   125.592787   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   140.603053   132.808803   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   143.171487   134.932790   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   123.769819   114.042900   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   118.089019   108.138781   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   130.299063   120.332582   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   119.569370   109.660819   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   121.172620   111.078790   \n",
       "\n",
       "oktmo                                               ...  22622416131  \\\n",
       "url                                                 ...                \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   121.458973   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   117.191972   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   111.350746   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   118.629160   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   120.355214   \n",
       "...                                                 ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...    98.851499   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...    93.169509   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...   107.527701   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...    94.625817   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...  ...    96.625763   \n",
       "\n",
       "oktmo                                               22622452106  22622424161  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   117.701803   132.833291   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   113.765678   129.002524   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   108.785140   124.245367   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   115.806887   131.188492   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   118.937253   134.590252   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   104.211814   119.796793   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   100.396198   115.530698   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   119.887320   132.554991   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   101.439049   116.691400   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   105.838130   120.280756   \n",
       "\n",
       "oktmo                                               22622432101  22622456121  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   103.604210    92.130892   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   100.337598    88.381831   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    96.933304    83.931064   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   103.240912    90.730090   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   108.458941    94.722713   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   105.470310    87.379967   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   104.960729    86.403053   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   132.654529   114.263136   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   105.257912    86.777907   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   113.477611    94.780411   \n",
       "\n",
       "oktmo                                               22622456126  22622460136  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    96.823597   134.277545   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    93.128736   130.258931   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    88.787344   125.044115   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    95.542290   132.151483   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    99.652593   134.865274   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    92.138507   116.737566   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    90.886306   111.579893   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   117.778936   126.038017   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    91.331990   112.937576   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    98.952228   115.368898   \n",
       "\n",
       "oktmo                                               22622416106  22622408221  \\\n",
       "url                                                                            \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   120.449068   122.370188   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   116.184689   119.259356   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   110.352227   116.124489   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   117.628477   122.298962   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   119.374763   127.767941   \n",
       "...                                                         ...          ...   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    98.057401   124.171646   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    92.457350   122.939105   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   107.163618   147.985108   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    93.894249   123.420370   \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    96.025768   130.639277   \n",
       "\n",
       "oktmo                                               22622416176  \n",
       "url                                                              \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   116.026382  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   111.681204  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   105.629020  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   112.948994  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   114.319733  \n",
       "...                                                         ...  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    91.788609  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    86.021124  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...   100.901045  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    87.487281  \n",
       "https://schoolotzyv.ru/component/schools/9-russ...    89.519101  \n",
       "\n",
       "[1222 rows x 158 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_dist_matrix"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# нам нужно расстояние от населенных пунктов до школ, а не наоборот, поэтому транспонируем таблицу —\n",
    "# меняем индексы и колонки местами\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>url</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72980-bolshemurashkinskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72981-xolyazinskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72982-kishkinskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72983-sovetskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72984-karabatovskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72985-kurlakovskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72986-ivanovskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72987-grigorovskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72988-rozhdestvenskaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72990-bolshemurashkinskaya-shkola-internat-8-vida</th>\n",
       "      <th>...</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74316-gou-zolinskaya-shkola-internat</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74317-gou-popovskaya-shkola-internat</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74318-gou-bolshemurashkinskaya-shkola-internat-2-vida</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74319-gou-gorbatovskaya-shkola-internat-1-vida</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74320-licej-internat</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74321-morenovskaya-sanatorno-lesnaya-shkola</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74322-shkola-internat</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74323-shkola-internat</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/58100-shkola-131</th>\n",
       "      <th>https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/119073-soromovskaya-gimnaziya</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oktmo</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>22622404111</th>\n",
       "      <td>127.780010</td>\n",
       "      <td>123.720058</td>\n",
       "      <td>118.412264</td>\n",
       "      <td>125.547781</td>\n",
       "      <td>128.138590</td>\n",
       "      <td>125.811316</td>\n",
       "      <td>113.969575</td>\n",
       "      <td>130.605899</td>\n",
       "      <td>135.766169</td>\n",
       "      <td>128.110032</td>\n",
       "      <td>...</td>\n",
       "      <td>158.254617</td>\n",
       "      <td>592.453221</td>\n",
       "      <td>128.112606</td>\n",
       "      <td>161.816442</td>\n",
       "      <td>107.448775</td>\n",
       "      <td>109.968831</td>\n",
       "      <td>104.968841</td>\n",
       "      <td>120.463279</td>\n",
       "      <td>106.284631</td>\n",
       "      <td>109.033181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622408141</th>\n",
       "      <td>119.201251</td>\n",
       "      <td>115.823127</td>\n",
       "      <td>112.124641</td>\n",
       "      <td>118.591238</td>\n",
       "      <td>123.418979</td>\n",
       "      <td>119.756405</td>\n",
       "      <td>105.110305</td>\n",
       "      <td>124.029928</td>\n",
       "      <td>126.293517</td>\n",
       "      <td>119.669620</td>\n",
       "      <td>...</td>\n",
       "      <td>173.713819</td>\n",
       "      <td>562.871841</td>\n",
       "      <td>119.583388</td>\n",
       "      <td>174.645328</td>\n",
       "      <td>119.788583</td>\n",
       "      <td>116.800653</td>\n",
       "      <td>114.928398</td>\n",
       "      <td>138.754476</td>\n",
       "      <td>115.547045</td>\n",
       "      <td>122.118390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622440121</th>\n",
       "      <td>121.505056</td>\n",
       "      <td>117.546010</td>\n",
       "      <td>112.501179</td>\n",
       "      <td>119.547172</td>\n",
       "      <td>122.566730</td>\n",
       "      <td>119.976315</td>\n",
       "      <td>107.590143</td>\n",
       "      <td>124.694483</td>\n",
       "      <td>129.369383</td>\n",
       "      <td>121.859827</td>\n",
       "      <td>...</td>\n",
       "      <td>157.993814</td>\n",
       "      <td>585.299954</td>\n",
       "      <td>121.847301</td>\n",
       "      <td>160.731404</td>\n",
       "      <td>105.993029</td>\n",
       "      <td>106.948276</td>\n",
       "      <td>102.785402</td>\n",
       "      <td>121.059528</td>\n",
       "      <td>103.909753</td>\n",
       "      <td>107.818924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622440151</th>\n",
       "      <td>121.558613</td>\n",
       "      <td>117.649458</td>\n",
       "      <td>112.726399</td>\n",
       "      <td>119.728550</td>\n",
       "      <td>122.928302</td>\n",
       "      <td>120.229849</td>\n",
       "      <td>107.601107</td>\n",
       "      <td>124.912344</td>\n",
       "      <td>129.359699</td>\n",
       "      <td>121.925008</td>\n",
       "      <td>...</td>\n",
       "      <td>159.771042</td>\n",
       "      <td>583.279633</td>\n",
       "      <td>121.905291</td>\n",
       "      <td>162.353264</td>\n",
       "      <td>107.563081</td>\n",
       "      <td>108.149707</td>\n",
       "      <td>104.197396</td>\n",
       "      <td>122.986539</td>\n",
       "      <td>105.275720</td>\n",
       "      <td>109.437242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622420111</th>\n",
       "      <td>138.361254</td>\n",
       "      <td>134.471863</td>\n",
       "      <td>129.565667</td>\n",
       "      <td>136.566682</td>\n",
       "      <td>139.735407</td>\n",
       "      <td>137.066960</td>\n",
       "      <td>124.383904</td>\n",
       "      <td>141.751865</td>\n",
       "      <td>146.125952</td>\n",
       "      <td>138.732792</td>\n",
       "      <td>...</td>\n",
       "      <td>171.855176</td>\n",
       "      <td>589.431777</td>\n",
       "      <td>138.709916</td>\n",
       "      <td>175.545515</td>\n",
       "      <td>121.190330</td>\n",
       "      <td>123.425079</td>\n",
       "      <td>118.640925</td>\n",
       "      <td>133.820130</td>\n",
       "      <td>119.920841</td>\n",
       "      <td>122.773815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>22622456126</th>\n",
       "      <td>96.823597</td>\n",
       "      <td>93.128736</td>\n",
       "      <td>88.787344</td>\n",
       "      <td>95.542290</td>\n",
       "      <td>99.652593</td>\n",
       "      <td>96.390499</td>\n",
       "      <td>82.754205</td>\n",
       "      <td>100.874301</td>\n",
       "      <td>104.374345</td>\n",
       "      <td>97.233883</td>\n",
       "      <td>...</td>\n",
       "      <td>150.976500</td>\n",
       "      <td>566.898346</td>\n",
       "      <td>97.186256</td>\n",
       "      <td>150.967872</td>\n",
       "      <td>96.391696</td>\n",
       "      <td>92.138507</td>\n",
       "      <td>90.886306</td>\n",
       "      <td>117.778936</td>\n",
       "      <td>91.331990</td>\n",
       "      <td>98.952228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622460136</th>\n",
       "      <td>134.277545</td>\n",
       "      <td>130.258931</td>\n",
       "      <td>125.044115</td>\n",
       "      <td>132.151483</td>\n",
       "      <td>134.865274</td>\n",
       "      <td>132.468169</td>\n",
       "      <td>120.416777</td>\n",
       "      <td>137.240142</td>\n",
       "      <td>142.209125</td>\n",
       "      <td>134.618298</td>\n",
       "      <td>...</td>\n",
       "      <td>164.183923</td>\n",
       "      <td>593.557299</td>\n",
       "      <td>134.614389</td>\n",
       "      <td>168.065962</td>\n",
       "      <td>113.862255</td>\n",
       "      <td>116.737566</td>\n",
       "      <td>111.579893</td>\n",
       "      <td>126.038017</td>\n",
       "      <td>112.937576</td>\n",
       "      <td>115.368898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622416106</th>\n",
       "      <td>120.449068</td>\n",
       "      <td>116.184689</td>\n",
       "      <td>110.352227</td>\n",
       "      <td>117.628477</td>\n",
       "      <td>119.374763</td>\n",
       "      <td>117.555233</td>\n",
       "      <td>106.975473</td>\n",
       "      <td>122.476226</td>\n",
       "      <td>128.679408</td>\n",
       "      <td>120.720407</td>\n",
       "      <td>...</td>\n",
       "      <td>144.980027</td>\n",
       "      <td>598.368248</td>\n",
       "      <td>120.757552</td>\n",
       "      <td>148.720883</td>\n",
       "      <td>94.543092</td>\n",
       "      <td>98.057401</td>\n",
       "      <td>92.457350</td>\n",
       "      <td>107.163618</td>\n",
       "      <td>93.894249</td>\n",
       "      <td>96.025768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622408221</th>\n",
       "      <td>122.370188</td>\n",
       "      <td>119.259356</td>\n",
       "      <td>116.124489</td>\n",
       "      <td>122.298962</td>\n",
       "      <td>127.767941</td>\n",
       "      <td>123.735822</td>\n",
       "      <td>108.373063</td>\n",
       "      <td>127.797610</td>\n",
       "      <td>129.079182</td>\n",
       "      <td>122.879319</td>\n",
       "      <td>...</td>\n",
       "      <td>182.450789</td>\n",
       "      <td>554.579736</td>\n",
       "      <td>122.764409</td>\n",
       "      <td>182.921745</td>\n",
       "      <td>128.195964</td>\n",
       "      <td>124.171646</td>\n",
       "      <td>122.939105</td>\n",
       "      <td>147.985108</td>\n",
       "      <td>123.420370</td>\n",
       "      <td>130.639277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22622416176</th>\n",
       "      <td>116.026382</td>\n",
       "      <td>111.681204</td>\n",
       "      <td>105.629020</td>\n",
       "      <td>112.948994</td>\n",
       "      <td>114.319733</td>\n",
       "      <td>112.726422</td>\n",
       "      <td>102.747434</td>\n",
       "      <td>117.692032</td>\n",
       "      <td>124.346297</td>\n",
       "      <td>116.270551</td>\n",
       "      <td>...</td>\n",
       "      <td>138.555595</td>\n",
       "      <td>599.955419</td>\n",
       "      <td>116.323182</td>\n",
       "      <td>142.220419</td>\n",
       "      <td>88.040369</td>\n",
       "      <td>91.788609</td>\n",
       "      <td>86.021124</td>\n",
       "      <td>100.901045</td>\n",
       "      <td>87.487281</td>\n",
       "      <td>89.519101</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158 rows × 1222 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72980-bolshemurashkinskaya-shkola  \\\n",
       "oktmo                                                                                                                  \n",
       "22622404111                                         127.780010                                                         \n",
       "22622408141                                         119.201251                                                         \n",
       "22622440121                                         121.505056                                                         \n",
       "22622440151                                         121.558613                                                         \n",
       "22622420111                                         138.361254                                                         \n",
       "...                                                        ...                                                         \n",
       "22622456126                                          96.823597                                                         \n",
       "22622460136                                         134.277545                                                         \n",
       "22622416106                                         120.449068                                                         \n",
       "22622408221                                         122.370188                                                         \n",
       "22622416176                                         116.026382                                                         \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72981-xolyazinskaya-shkola  \\\n",
       "oktmo                                                                                                           \n",
       "22622404111                                         123.720058                                                  \n",
       "22622408141                                         115.823127                                                  \n",
       "22622440121                                         117.546010                                                  \n",
       "22622440151                                         117.649458                                                  \n",
       "22622420111                                         134.471863                                                  \n",
       "...                                                        ...                                                  \n",
       "22622456126                                          93.128736                                                  \n",
       "22622460136                                         130.258931                                                  \n",
       "22622416106                                         116.184689                                                  \n",
       "22622408221                                         119.259356                                                  \n",
       "22622416176                                         111.681204                                                  \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72982-kishkinskaya-shkola  \\\n",
       "oktmo                                                                                                          \n",
       "22622404111                                         118.412264                                                 \n",
       "22622408141                                         112.124641                                                 \n",
       "22622440121                                         112.501179                                                 \n",
       "22622440151                                         112.726399                                                 \n",
       "22622420111                                         129.565667                                                 \n",
       "...                                                        ...                                                 \n",
       "22622456126                                          88.787344                                                 \n",
       "22622460136                                         125.044115                                                 \n",
       "22622416106                                         110.352227                                                 \n",
       "22622408221                                         116.124489                                                 \n",
       "22622416176                                         105.629020                                                 \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72983-sovetskaya-shkola  \\\n",
       "oktmo                                                                                                        \n",
       "22622404111                                         125.547781                                               \n",
       "22622408141                                         118.591238                                               \n",
       "22622440121                                         119.547172                                               \n",
       "22622440151                                         119.728550                                               \n",
       "22622420111                                         136.566682                                               \n",
       "...                                                        ...                                               \n",
       "22622456126                                          95.542290                                               \n",
       "22622460136                                         132.151483                                               \n",
       "22622416106                                         117.628477                                               \n",
       "22622408221                                         122.298962                                               \n",
       "22622416176                                         112.948994                                               \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72984-karabatovskaya-shkola  \\\n",
       "oktmo                                                                                                            \n",
       "22622404111                                         128.138590                                                   \n",
       "22622408141                                         123.418979                                                   \n",
       "22622440121                                         122.566730                                                   \n",
       "22622440151                                         122.928302                                                   \n",
       "22622420111                                         139.735407                                                   \n",
       "...                                                        ...                                                   \n",
       "22622456126                                          99.652593                                                   \n",
       "22622460136                                         134.865274                                                   \n",
       "22622416106                                         119.374763                                                   \n",
       "22622408221                                         127.767941                                                   \n",
       "22622416176                                         114.319733                                                   \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72985-kurlakovskaya-shkola  \\\n",
       "oktmo                                                                                                           \n",
       "22622404111                                         125.811316                                                  \n",
       "22622408141                                         119.756405                                                  \n",
       "22622440121                                         119.976315                                                  \n",
       "22622440151                                         120.229849                                                  \n",
       "22622420111                                         137.066960                                                  \n",
       "...                                                        ...                                                  \n",
       "22622456126                                          96.390499                                                  \n",
       "22622460136                                         132.468169                                                  \n",
       "22622416106                                         117.555233                                                  \n",
       "22622408221                                         123.735822                                                  \n",
       "22622416176                                         112.726422                                                  \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72986-ivanovskaya-shkola  \\\n",
       "oktmo                                                                                                         \n",
       "22622404111                                         113.969575                                                \n",
       "22622408141                                         105.110305                                                \n",
       "22622440121                                         107.590143                                                \n",
       "22622440151                                         107.601107                                                \n",
       "22622420111                                         124.383904                                                \n",
       "...                                                        ...                                                \n",
       "22622456126                                          82.754205                                                \n",
       "22622460136                                         120.416777                                                \n",
       "22622416106                                         106.975473                                                \n",
       "22622408221                                         108.373063                                                \n",
       "22622416176                                         102.747434                                                \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72987-grigorovskaya-shkola  \\\n",
       "oktmo                                                                                                           \n",
       "22622404111                                         130.605899                                                  \n",
       "22622408141                                         124.029928                                                  \n",
       "22622440121                                         124.694483                                                  \n",
       "22622440151                                         124.912344                                                  \n",
       "22622420111                                         141.751865                                                  \n",
       "...                                                        ...                                                  \n",
       "22622456126                                         100.874301                                                  \n",
       "22622460136                                         137.240142                                                  \n",
       "22622416106                                         122.476226                                                  \n",
       "22622408221                                         127.797610                                                  \n",
       "22622416176                                         117.692032                                                  \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72988-rozhdestvenskaya-shkola  \\\n",
       "oktmo                                                                                                              \n",
       "22622404111                                         135.766169                                                     \n",
       "22622408141                                         126.293517                                                     \n",
       "22622440121                                         129.369383                                                     \n",
       "22622440151                                         129.359699                                                     \n",
       "22622420111                                         146.125952                                                     \n",
       "...                                                        ...                                                     \n",
       "22622456126                                         104.374345                                                     \n",
       "22622460136                                         142.209125                                                     \n",
       "22622416106                                         128.679408                                                     \n",
       "22622408221                                         129.079182                                                     \n",
       "22622416176                                         124.346297                                                     \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/72990-bolshemurashkinskaya-shkola-internat-8-vida  \\\n",
       "oktmo                                                                                                                                  \n",
       "22622404111                                         128.110032                                                                         \n",
       "22622408141                                         119.669620                                                                         \n",
       "22622440121                                         121.859827                                                                         \n",
       "22622440151                                         121.925008                                                                         \n",
       "22622420111                                         138.732792                                                                         \n",
       "...                                                        ...                                                                         \n",
       "22622456126                                          97.233883                                                                         \n",
       "22622460136                                         134.618298                                                                         \n",
       "22622416106                                         120.720407                                                                         \n",
       "22622408221                                         122.879319                                                                         \n",
       "22622416176                                         116.270551                                                                         \n",
       "\n",
       "url          ...  \\\n",
       "oktmo        ...   \n",
       "22622404111  ...   \n",
       "22622408141  ...   \n",
       "22622440121  ...   \n",
       "22622440151  ...   \n",
       "22622420111  ...   \n",
       "...          ...   \n",
       "22622456126  ...   \n",
       "22622460136  ...   \n",
       "22622416106  ...   \n",
       "22622408221  ...   \n",
       "22622416176  ...   \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74316-gou-zolinskaya-shkola-internat  \\\n",
       "oktmo                                                                                                                     \n",
       "22622404111                                         158.254617                                                            \n",
       "22622408141                                         173.713819                                                            \n",
       "22622440121                                         157.993814                                                            \n",
       "22622440151                                         159.771042                                                            \n",
       "22622420111                                         171.855176                                                            \n",
       "...                                                        ...                                                            \n",
       "22622456126                                         150.976500                                                            \n",
       "22622460136                                         164.183923                                                            \n",
       "22622416106                                         144.980027                                                            \n",
       "22622408221                                         182.450789                                                            \n",
       "22622416176                                         138.555595                                                            \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74317-gou-popovskaya-shkola-internat  \\\n",
       "oktmo                                                                                                                     \n",
       "22622404111                                         592.453221                                                            \n",
       "22622408141                                         562.871841                                                            \n",
       "22622440121                                         585.299954                                                            \n",
       "22622440151                                         583.279633                                                            \n",
       "22622420111                                         589.431777                                                            \n",
       "...                                                        ...                                                            \n",
       "22622456126                                         566.898346                                                            \n",
       "22622460136                                         593.557299                                                            \n",
       "22622416106                                         598.368248                                                            \n",
       "22622408221                                         554.579736                                                            \n",
       "22622416176                                         599.955419                                                            \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74318-gou-bolshemurashkinskaya-shkola-internat-2-vida  \\\n",
       "oktmo                                                                                                                                      \n",
       "22622404111                                         128.112606                                                                             \n",
       "22622408141                                         119.583388                                                                             \n",
       "22622440121                                         121.847301                                                                             \n",
       "22622440151                                         121.905291                                                                             \n",
       "22622420111                                         138.709916                                                                             \n",
       "...                                                        ...                                                                             \n",
       "22622456126                                          97.186256                                                                             \n",
       "22622460136                                         134.614389                                                                             \n",
       "22622416106                                         120.757552                                                                             \n",
       "22622408221                                         122.764409                                                                             \n",
       "22622416176                                         116.323182                                                                             \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74319-gou-gorbatovskaya-shkola-internat-1-vida  \\\n",
       "oktmo                                                                                                                               \n",
       "22622404111                                         161.816442                                                                      \n",
       "22622408141                                         174.645328                                                                      \n",
       "22622440121                                         160.731404                                                                      \n",
       "22622440151                                         162.353264                                                                      \n",
       "22622420111                                         175.545515                                                                      \n",
       "...                                                        ...                                                                      \n",
       "22622456126                                         150.967872                                                                      \n",
       "22622460136                                         168.065962                                                                      \n",
       "22622416106                                         148.720883                                                                      \n",
       "22622408221                                         182.921745                                                                      \n",
       "22622416176                                         142.220419                                                                      \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74320-licej-internat  \\\n",
       "oktmo                                                                                                     \n",
       "22622404111                                         107.448775                                            \n",
       "22622408141                                         119.788583                                            \n",
       "22622440121                                         105.993029                                            \n",
       "22622440151                                         107.563081                                            \n",
       "22622420111                                         121.190330                                            \n",
       "...                                                        ...                                            \n",
       "22622456126                                          96.391696                                            \n",
       "22622460136                                         113.862255                                            \n",
       "22622416106                                          94.543092                                            \n",
       "22622408221                                         128.195964                                            \n",
       "22622416176                                          88.040369                                            \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74321-morenovskaya-sanatorno-lesnaya-shkola  \\\n",
       "oktmo                                                                                                                            \n",
       "22622404111                                         109.968831                                                                   \n",
       "22622408141                                         116.800653                                                                   \n",
       "22622440121                                         106.948276                                                                   \n",
       "22622440151                                         108.149707                                                                   \n",
       "22622420111                                         123.425079                                                                   \n",
       "...                                                        ...                                                                   \n",
       "22622456126                                          92.138507                                                                   \n",
       "22622460136                                         116.737566                                                                   \n",
       "22622416106                                          98.057401                                                                   \n",
       "22622408221                                         124.171646                                                                   \n",
       "22622416176                                          91.788609                                                                   \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74322-shkola-internat  \\\n",
       "oktmo                                                                                                      \n",
       "22622404111                                         104.968841                                             \n",
       "22622408141                                         114.928398                                             \n",
       "22622440121                                         102.785402                                             \n",
       "22622440151                                         104.197396                                             \n",
       "22622420111                                         118.640925                                             \n",
       "...                                                        ...                                             \n",
       "22622456126                                          90.886306                                             \n",
       "22622460136                                         111.579893                                             \n",
       "22622416106                                          92.457350                                             \n",
       "22622408221                                         122.939105                                             \n",
       "22622416176                                          86.021124                                             \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/74323-shkola-internat  \\\n",
       "oktmo                                                                                                      \n",
       "22622404111                                         120.463279                                             \n",
       "22622408141                                         138.754476                                             \n",
       "22622440121                                         121.059528                                             \n",
       "22622440151                                         122.986539                                             \n",
       "22622420111                                         133.820130                                             \n",
       "...                                                        ...                                             \n",
       "22622456126                                         117.778936                                             \n",
       "22622460136                                         126.038017                                             \n",
       "22622416106                                         107.163618                                             \n",
       "22622408221                                         147.985108                                             \n",
       "22622416176                                         100.901045                                             \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/58100-shkola-131  \\\n",
       "oktmo                                                                                                 \n",
       "22622404111                                         106.284631                                        \n",
       "22622408141                                         115.547045                                        \n",
       "22622440121                                         103.909753                                        \n",
       "22622440151                                         105.275720                                        \n",
       "22622420111                                         119.920841                                        \n",
       "...                                                        ...                                        \n",
       "22622456126                                          91.331990                                        \n",
       "22622460136                                         112.937576                                        \n",
       "22622416106                                          93.894249                                        \n",
       "22622408221                                         123.420370                                        \n",
       "22622416176                                          87.487281                                        \n",
       "\n",
       "url          https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/119073-soromovskaya-gimnaziya  \n",
       "oktmo                                                                                                             \n",
       "22622404111                                         109.033181                                                    \n",
       "22622408141                                         122.118390                                                    \n",
       "22622440121                                         107.818924                                                    \n",
       "22622440151                                         109.437242                                                    \n",
       "22622420111                                         122.773815                                                    \n",
       "...                                                        ...                                                    \n",
       "22622456126                                          98.952228                                                    \n",
       "22622460136                                         115.368898                                                    \n",
       "22622416106                                          96.025768                                                    \n",
       "22622408221                                         130.639277                                                    \n",
       "22622416176                                          89.519101                                                    \n",
       "\n",
       "[158 rows x 1222 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "df_dist_matrix = df_dist_matrix.T\n",
    "df_dist_matrix"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 6. Выбор ближайшего объекта"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Выбираем ближайшую школу к каждому населенному пункту."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "158"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# дальше мы сравниваем каждое значение в строке с предыдущим, чтобы проверить, больше оно или меньше. Меньшее записываем в переменную\n",
    "\n",
    "schools_and_min_value_by_oktmo = {} # пустой словарь, где ключом будет код октмо, \n",
    "                                    #значениями — минимальное расстояние\n",
    "\n",
    "columns = df_dist_matrix.columns # список с названиями колонок (url школ)\n",
    "for current_oktmo in df_dist_matrix.index:\n",
    "    distances = df_dist_matrix.loc[current_oktmo]\n",
    "    min_distance = None # нужно для начала отсчета, чтобы было с чем сравнивать первое значение в строке\n",
    "    min_j = None\n",
    "    for j in range(len(columns)):\n",
    "        if min_distance is None or min_distance > distances[j]: # сравниваем каждое значение в строке с \n",
    "            # предыдущим, чтобы проверить, больше оно или меньше. Меньшее записываем в переменную\n",
    "            min_distance = distances[j]\n",
    "            min_j = j \n",
    "    schools_and_min_value_by_oktmo[current_oktmo] = (columns[min_j], min_distance)\n",
    "# заполняем словарь: ключ — код октмо, значение — url ближайшей школы и расстояние до нее\n",
    "len(schools_and_min_value_by_oktmo)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('https://schoolotzyv.ru/component/schools/9-russia/146-nizhegorodskaya/73604-chuxlomskaya-shkola',\n",
       " 0.014360770987876591)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schools_and_min_value_by_oktmo['22622440151'] # пример того, что выдает словарь по коду октмо"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "158"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# добавляем колонки с мин расстоянием и url школы в датафрейм places_voskresensk (с населенными пунктами)\n",
    "# создаем списки с полученными выше url и км, чтобы затем добавить их к датафрейму с населенными пунктами\n",
    "\n",
    "school_url_column = [] \n",
    "min_distance_column = []\n",
    "for oktmo in places_voskresensk['oktmo']:\n",
    "    (url, distns) = schools_and_min_value_by_oktmo[oktmo]\n",
    "    school_url_column.append(url) # берем из созданного выше словаря url ближайшей школы(url) и км до нее (distns),\n",
    "    # добавляем их в словари в том порядке, в каком соответствующие им коды октмо расположены в датафрейме places_voskresensk\n",
    "    min_distance_column.append(distns)\n",
    "places_voskresensk['school_url_column'] = school_url_column # добавляем новую колонку с url ближайших школ\n",
    "places_voskresensk['min_distance_column'] = min_distance_column # добавляем новую колонку с км до этих школ\n",
    "len(places_voskresensk)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>id</th>\n",
       "      <th>region</th>\n",
       "      <th>municipality</th>\n",
       "      <th>settlement</th>\n",
       "      <th>type</th>\n",
       "      <th>population</th>\n",
       "      <th>children</th>\n",
       "      <th>latitude_dms</th>\n",
       "      <th>longitude_dms</th>\n",
       "      <th>latitude_dd</th>\n",
       "      <th>longitude_dd</th>\n",
       "      <th>oktmo</th>\n",
       "      <th>dadata</th>\n",
       "      <th>rosstat</th>\n",
       "      <th>lat_radians_B</th>\n",
       "      <th>long_radians_B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Апариха</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.53.40</td>\n",
       "      <td>045.19.08</td>\n",
       "      <td>56.894444</td>\n",
       "      <td>45.318889</td>\n",
       "      <td>22622404111</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.992995</td>\n",
       "      <td>0.790964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1902</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Докукино</td>\n",
       "      <td>с</td>\n",
       "      <td>237</td>\n",
       "      <td>40</td>\n",
       "      <td>56.43.39</td>\n",
       "      <td>045.41.59</td>\n",
       "      <td>56.727500</td>\n",
       "      <td>45.699722</td>\n",
       "      <td>22622408141</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.990082</td>\n",
       "      <td>0.797611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2731</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Капустиха</td>\n",
       "      <td>д</td>\n",
       "      <td>215</td>\n",
       "      <td>41</td>\n",
       "      <td>56.49.41</td>\n",
       "      <td>045.21.58</td>\n",
       "      <td>56.828056</td>\n",
       "      <td>45.366111</td>\n",
       "      <td>22622440121</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991837</td>\n",
       "      <td>0.791788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2867</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Чухломка</td>\n",
       "      <td>д</td>\n",
       "      <td>187</td>\n",
       "      <td>50</td>\n",
       "      <td>56.49.20</td>\n",
       "      <td>045.24.06</td>\n",
       "      <td>56.822222</td>\n",
       "      <td>45.401667</td>\n",
       "      <td>22622440151</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991735</td>\n",
       "      <td>0.792409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4089</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Большие Отары</td>\n",
       "      <td>д</td>\n",
       "      <td>362</td>\n",
       "      <td>79</td>\n",
       "      <td>56.57.43</td>\n",
       "      <td>045.30.31</td>\n",
       "      <td>56.961944</td>\n",
       "      <td>45.508611</td>\n",
       "      <td>22622420111</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.994173</td>\n",
       "      <td>0.794275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>153214</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Клюкино</td>\n",
       "      <td>д</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>56.35.22</td>\n",
       "      <td>045.22.43</td>\n",
       "      <td>56.589444</td>\n",
       "      <td>45.378611</td>\n",
       "      <td>22622456126</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.987672</td>\n",
       "      <td>0.792006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>153490</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Раскаты</td>\n",
       "      <td>д</td>\n",
       "      <td>238</td>\n",
       "      <td>22</td>\n",
       "      <td>56.56.43</td>\n",
       "      <td>045.22.59</td>\n",
       "      <td>56.945278</td>\n",
       "      <td>45.383056</td>\n",
       "      <td>22622460136</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.993883</td>\n",
       "      <td>0.792084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>154465</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Александровка</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.51.07</td>\n",
       "      <td>045.06.51</td>\n",
       "      <td>56.851944</td>\n",
       "      <td>45.114167</td>\n",
       "      <td>22622416106</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.992254</td>\n",
       "      <td>0.787391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>154802</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Успенское</td>\n",
       "      <td>с</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56.42.32</td>\n",
       "      <td>045.51.24</td>\n",
       "      <td>56.708889</td>\n",
       "      <td>45.856667</td>\n",
       "      <td>22622408221</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989757</td>\n",
       "      <td>0.800350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>154867</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Шадрино</td>\n",
       "      <td>д</td>\n",
       "      <td>207</td>\n",
       "      <td>18</td>\n",
       "      <td>56.49.09</td>\n",
       "      <td>045.01.32</td>\n",
       "      <td>56.819167</td>\n",
       "      <td>45.025556</td>\n",
       "      <td>22622416176</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991682</td>\n",
       "      <td>0.785844</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                 region         municipality     settlement type  \\\n",
       "0         6  Нижегородская область  Воскресенский район        Апариха    д   \n",
       "1      1902  Нижегородская область  Воскресенский район       Докукино    с   \n",
       "2      2731  Нижегородская область  Воскресенский район      Капустиха    д   \n",
       "3      2867  Нижегородская область  Воскресенский район       Чухломка    д   \n",
       "4      4089  Нижегородская область  Воскресенский район  Большие Отары    д   \n",
       "..      ...                    ...                  ...            ...  ...   \n",
       "153  153214  Нижегородская область  Воскресенский район        Клюкино    д   \n",
       "154  153490  Нижегородская область  Воскресенский район        Раскаты    д   \n",
       "155  154465  Нижегородская область  Воскресенский район  Александровка    д   \n",
       "156  154802  Нижегородская область  Воскресенский район      Успенское    с   \n",
       "157  154867  Нижегородская область  Воскресенский район        Шадрино    д   \n",
       "\n",
       "     population  children latitude_dms longitude_dms  latitude_dd  \\\n",
       "0             0         0     56.53.40     045.19.08    56.894444   \n",
       "1           237        40     56.43.39     045.41.59    56.727500   \n",
       "2           215        41     56.49.41     045.21.58    56.828056   \n",
       "3           187        50     56.49.20     045.24.06    56.822222   \n",
       "4           362        79     56.57.43     045.30.31    56.961944   \n",
       "..          ...       ...          ...           ...          ...   \n",
       "153          29         2     56.35.22     045.22.43    56.589444   \n",
       "154         238        22     56.56.43     045.22.59    56.945278   \n",
       "155           0         0     56.51.07     045.06.51    56.851944   \n",
       "156           1         0     56.42.32     045.51.24    56.708889   \n",
       "157         207        18     56.49.09     045.01.32    56.819167   \n",
       "\n",
       "     longitude_dd        oktmo  dadata  rosstat  lat_radians_B  long_radians_B  \n",
       "0       45.318889  22622404111       0        1       0.992995        0.790964  \n",
       "1       45.699722  22622408141       0        1       0.990082        0.797611  \n",
       "2       45.366111  22622440121       0        1       0.991837        0.791788  \n",
       "3       45.401667  22622440151       0        1       0.991735        0.792409  \n",
       "4       45.508611  22622420111       0        1       0.994173        0.794275  \n",
       "..            ...          ...     ...      ...            ...             ...  \n",
       "153     45.378611  22622456126       0        1       0.987672        0.792006  \n",
       "154     45.383056  22622460136       0        1       0.993883        0.792084  \n",
       "155     45.114167  22622416106       0        1       0.992254        0.787391  \n",
       "156     45.856667  22622408221       0        1       0.989757        0.800350  \n",
       "157     45.025556  22622416176       0        1       0.991682        0.785844  \n",
       "\n",
       "[158 rows x 16 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places_voskresensk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# из словаря со школами достаем названия школ по url и тоже добавляем их к датафрейму places_voskresensk новой колонкой\n",
    "\n",
    "\n",
    "school_name = []\n",
    "\n",
    "for url in places_voskresensk['school_url_column']:\n",
    "    school_name.append(schools_by_url[url]['text'])\n",
    "places_voskresensk['school_name'] = school_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>id</th>\n",
       "      <th>region</th>\n",
       "      <th>municipality</th>\n",
       "      <th>settlement</th>\n",
       "      <th>type</th>\n",
       "      <th>population</th>\n",
       "      <th>children</th>\n",
       "      <th>latitude_dms</th>\n",
       "      <th>longitude_dms</th>\n",
       "      <th>latitude_dd</th>\n",
       "      <th>longitude_dd</th>\n",
       "      <th>oktmo</th>\n",
       "      <th>dadata</th>\n",
       "      <th>rosstat</th>\n",
       "      <th>lat_radians_B</th>\n",
       "      <th>long_radians_B</th>\n",
       "      <th>school_url_column</th>\n",
       "      <th>min_distance_column</th>\n",
       "      <th>school_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Апариха</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.53.40</td>\n",
       "      <td>045.19.08</td>\n",
       "      <td>56.894444</td>\n",
       "      <td>45.318889</td>\n",
       "      <td>22622404111</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.992995</td>\n",
       "      <td>0.790964</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>3.330156</td>\n",
       "      <td>Благовещенская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1902</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Докукино</td>\n",
       "      <td>с</td>\n",
       "      <td>237</td>\n",
       "      <td>40</td>\n",
       "      <td>56.43.39</td>\n",
       "      <td>045.41.59</td>\n",
       "      <td>56.727500</td>\n",
       "      <td>45.699722</td>\n",
       "      <td>22622408141</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.990082</td>\n",
       "      <td>0.797611</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>0.009381</td>\n",
       "      <td>Докукинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2731</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Капустиха</td>\n",
       "      <td>д</td>\n",
       "      <td>215</td>\n",
       "      <td>41</td>\n",
       "      <td>56.49.41</td>\n",
       "      <td>045.21.58</td>\n",
       "      <td>56.828056</td>\n",
       "      <td>45.366111</td>\n",
       "      <td>22622440121</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991837</td>\n",
       "      <td>0.791788</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>2.248417</td>\n",
       "      <td>Чухломская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2867</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Чухломка</td>\n",
       "      <td>д</td>\n",
       "      <td>187</td>\n",
       "      <td>50</td>\n",
       "      <td>56.49.20</td>\n",
       "      <td>045.24.06</td>\n",
       "      <td>56.822222</td>\n",
       "      <td>45.401667</td>\n",
       "      <td>22622440151</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991735</td>\n",
       "      <td>0.792409</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>0.014361</td>\n",
       "      <td>Чухломская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4089</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Большие Отары</td>\n",
       "      <td>д</td>\n",
       "      <td>362</td>\n",
       "      <td>79</td>\n",
       "      <td>56.57.43</td>\n",
       "      <td>045.30.31</td>\n",
       "      <td>56.961944</td>\n",
       "      <td>45.508611</td>\n",
       "      <td>22622420111</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.994173</td>\n",
       "      <td>0.794275</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>0.013753</td>\n",
       "      <td>Большеотарская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>153214</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Клюкино</td>\n",
       "      <td>д</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>56.35.22</td>\n",
       "      <td>045.22.43</td>\n",
       "      <td>56.589444</td>\n",
       "      <td>45.378611</td>\n",
       "      <td>22622456126</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.987672</td>\n",
       "      <td>0.792006</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>4.132106</td>\n",
       "      <td>Нестиарская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>153490</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Раскаты</td>\n",
       "      <td>д</td>\n",
       "      <td>238</td>\n",
       "      <td>22</td>\n",
       "      <td>56.56.43</td>\n",
       "      <td>045.22.59</td>\n",
       "      <td>56.945278</td>\n",
       "      <td>45.383056</td>\n",
       "      <td>22622460136</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.993883</td>\n",
       "      <td>0.792084</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>0.009641</td>\n",
       "      <td>Раскатская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>154465</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Александровка</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.51.07</td>\n",
       "      <td>045.06.51</td>\n",
       "      <td>56.851944</td>\n",
       "      <td>45.114167</td>\n",
       "      <td>22622416106</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.992254</td>\n",
       "      <td>0.787391</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>3.524948</td>\n",
       "      <td>Владимирская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>154802</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Успенское</td>\n",
       "      <td>с</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56.42.32</td>\n",
       "      <td>045.51.24</td>\n",
       "      <td>56.708889</td>\n",
       "      <td>45.856667</td>\n",
       "      <td>22622408221</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989757</td>\n",
       "      <td>0.800350</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>9.567901</td>\n",
       "      <td>Красноярская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>154867</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Шадрино</td>\n",
       "      <td>д</td>\n",
       "      <td>207</td>\n",
       "      <td>18</td>\n",
       "      <td>56.49.09</td>\n",
       "      <td>045.01.32</td>\n",
       "      <td>56.819167</td>\n",
       "      <td>45.025556</td>\n",
       "      <td>22622416176</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991682</td>\n",
       "      <td>0.785844</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>0.007929</td>\n",
       "      <td>Шадринская школа</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>158 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                 region         municipality     settlement type  \\\n",
       "0         6  Нижегородская область  Воскресенский район        Апариха    д   \n",
       "1      1902  Нижегородская область  Воскресенский район       Докукино    с   \n",
       "2      2731  Нижегородская область  Воскресенский район      Капустиха    д   \n",
       "3      2867  Нижегородская область  Воскресенский район       Чухломка    д   \n",
       "4      4089  Нижегородская область  Воскресенский район  Большие Отары    д   \n",
       "..      ...                    ...                  ...            ...  ...   \n",
       "153  153214  Нижегородская область  Воскресенский район        Клюкино    д   \n",
       "154  153490  Нижегородская область  Воскресенский район        Раскаты    д   \n",
       "155  154465  Нижегородская область  Воскресенский район  Александровка    д   \n",
       "156  154802  Нижегородская область  Воскресенский район      Успенское    с   \n",
       "157  154867  Нижегородская область  Воскресенский район        Шадрино    д   \n",
       "\n",
       "     population  children latitude_dms longitude_dms  latitude_dd  \\\n",
       "0             0         0     56.53.40     045.19.08    56.894444   \n",
       "1           237        40     56.43.39     045.41.59    56.727500   \n",
       "2           215        41     56.49.41     045.21.58    56.828056   \n",
       "3           187        50     56.49.20     045.24.06    56.822222   \n",
       "4           362        79     56.57.43     045.30.31    56.961944   \n",
       "..          ...       ...          ...           ...          ...   \n",
       "153          29         2     56.35.22     045.22.43    56.589444   \n",
       "154         238        22     56.56.43     045.22.59    56.945278   \n",
       "155           0         0     56.51.07     045.06.51    56.851944   \n",
       "156           1         0     56.42.32     045.51.24    56.708889   \n",
       "157         207        18     56.49.09     045.01.32    56.819167   \n",
       "\n",
       "     longitude_dd        oktmo  dadata  rosstat  lat_radians_B  \\\n",
       "0       45.318889  22622404111       0        1       0.992995   \n",
       "1       45.699722  22622408141       0        1       0.990082   \n",
       "2       45.366111  22622440121       0        1       0.991837   \n",
       "3       45.401667  22622440151       0        1       0.991735   \n",
       "4       45.508611  22622420111       0        1       0.994173   \n",
       "..            ...          ...     ...      ...            ...   \n",
       "153     45.378611  22622456126       0        1       0.987672   \n",
       "154     45.383056  22622460136       0        1       0.993883   \n",
       "155     45.114167  22622416106       0        1       0.992254   \n",
       "156     45.856667  22622408221       0        1       0.989757   \n",
       "157     45.025556  22622416176       0        1       0.991682   \n",
       "\n",
       "     long_radians_B                                  school_url_column  \\\n",
       "0          0.790964  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "1          0.797611  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "2          0.791788  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "3          0.792409  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "4          0.794275  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "..              ...                                                ...   \n",
       "153        0.792006  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "154        0.792084  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "155        0.787391  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "156        0.800350  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "157        0.785844  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "\n",
       "     min_distance_column           school_name  \n",
       "0               3.330156  Благовещенская школа  \n",
       "1               0.009381     Докукинская школа  \n",
       "2               2.248417      Чухломская школа  \n",
       "3               0.014361      Чухломская школа  \n",
       "4               0.013753  Большеотарская школа  \n",
       "..                   ...                   ...  \n",
       "153             4.132106     Нестиарская школа  \n",
       "154             0.009641      Раскатская школа  \n",
       "155             3.524948    Владимирская школа  \n",
       "156             9.567901    Красноярская школа  \n",
       "157             0.007929      Шадринская школа  \n",
       "\n",
       "[158 rows x 19 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# в конце появились 3 новые колонки — url ближайшей школы, сколько до нее км, название школы\n",
    "\n",
    "places_voskresensk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "# сохраним полученный результат в csv \n",
    "\n",
    "\n",
    "places_voskresensk.to_csv('voskresensk_closest_schools.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 7. Анализ данных"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Дальше можно анализировать данные.\n",
    "# Например, выбрать 15 наиболе удаленных от школ объектов методов nlarest\n",
    "# подробнее об nlargest и nsmallest https://istories.media/workshops/2021/03/19/python-biblioteka-pandas-chast-3/ "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>id</th>\n",
       "      <th>region</th>\n",
       "      <th>municipality</th>\n",
       "      <th>settlement</th>\n",
       "      <th>type</th>\n",
       "      <th>population</th>\n",
       "      <th>children</th>\n",
       "      <th>latitude_dms</th>\n",
       "      <th>longitude_dms</th>\n",
       "      <th>latitude_dd</th>\n",
       "      <th>longitude_dd</th>\n",
       "      <th>oktmo</th>\n",
       "      <th>dadata</th>\n",
       "      <th>rosstat</th>\n",
       "      <th>lat_radians_B</th>\n",
       "      <th>long_radians_B</th>\n",
       "      <th>school_url_column</th>\n",
       "      <th>min_distance_column</th>\n",
       "      <th>school_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41506</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Красная Звезда</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56.29.48</td>\n",
       "      <td>045.33.09</td>\n",
       "      <td>56.496667</td>\n",
       "      <td>45.552500</td>\n",
       "      <td>22622432126</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.986053</td>\n",
       "      <td>0.795041</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>11.260120</td>\n",
       "      <td>Егоровская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>25057</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Автулиха</td>\n",
       "      <td>д</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>56.37.54</td>\n",
       "      <td>045.27.45</td>\n",
       "      <td>56.631667</td>\n",
       "      <td>45.462500</td>\n",
       "      <td>22622456106</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.988409</td>\n",
       "      <td>0.793470</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>10.768442</td>\n",
       "      <td>Егоровская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>83050</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Томилиха</td>\n",
       "      <td>д</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>56.41.42</td>\n",
       "      <td>045.51.14</td>\n",
       "      <td>56.695000</td>\n",
       "      <td>45.853889</td>\n",
       "      <td>22622408206</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989514</td>\n",
       "      <td>0.800301</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>10.087465</td>\n",
       "      <td>Докукинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>138624</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Бахарево</td>\n",
       "      <td>д</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>56.41.55</td>\n",
       "      <td>045.51.08</td>\n",
       "      <td>56.698611</td>\n",
       "      <td>45.852222</td>\n",
       "      <td>22622408111</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989577</td>\n",
       "      <td>0.800272</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>9.853790</td>\n",
       "      <td>Докукинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4922</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Петрово</td>\n",
       "      <td>д</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>57.03.02</td>\n",
       "      <td>045.33.42</td>\n",
       "      <td>57.050556</td>\n",
       "      <td>45.561667</td>\n",
       "      <td>22622420181</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.995720</td>\n",
       "      <td>0.795201</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>9.822884</td>\n",
       "      <td>Староустинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>21738</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Красные Поляны</td>\n",
       "      <td>д</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56.50.53</td>\n",
       "      <td>045.46.25</td>\n",
       "      <td>56.848056</td>\n",
       "      <td>45.773611</td>\n",
       "      <td>22622424141</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.992186</td>\n",
       "      <td>0.798900</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>9.708871</td>\n",
       "      <td>Красноярская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>154802</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Успенское</td>\n",
       "      <td>с</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56.42.32</td>\n",
       "      <td>045.51.24</td>\n",
       "      <td>56.708889</td>\n",
       "      <td>45.856667</td>\n",
       "      <td>22622408221</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989757</td>\n",
       "      <td>0.800350</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>9.567901</td>\n",
       "      <td>Красноярская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>58690</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Завод</td>\n",
       "      <td>д</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>56.37.41</td>\n",
       "      <td>045.25.02</td>\n",
       "      <td>56.628056</td>\n",
       "      <td>45.417222</td>\n",
       "      <td>22622456116</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.988346</td>\n",
       "      <td>0.792680</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>8.986548</td>\n",
       "      <td>Нестиарская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27980</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Шурговаш</td>\n",
       "      <td>с</td>\n",
       "      <td>114</td>\n",
       "      <td>12</td>\n",
       "      <td>56.46.25</td>\n",
       "      <td>045.14.10</td>\n",
       "      <td>56.773611</td>\n",
       "      <td>45.236111</td>\n",
       "      <td>22622416186</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.990886</td>\n",
       "      <td>0.789519</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>8.894897</td>\n",
       "      <td>Владимирская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>60613</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Прудовские</td>\n",
       "      <td>д</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>57.03.11</td>\n",
       "      <td>045.31.26</td>\n",
       "      <td>57.053056</td>\n",
       "      <td>45.523889</td>\n",
       "      <td>22622420186</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.995764</td>\n",
       "      <td>0.794542</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>8.605541</td>\n",
       "      <td>Староустинская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>133929</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Малое Содомово</td>\n",
       "      <td>д</td>\n",
       "      <td>56</td>\n",
       "      <td>9</td>\n",
       "      <td>57.02.11</td>\n",
       "      <td>045.36.05</td>\n",
       "      <td>57.036389</td>\n",
       "      <td>45.601389</td>\n",
       "      <td>22622420161</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.995473</td>\n",
       "      <td>0.795894</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>8.483822</td>\n",
       "      <td>Воздвиженская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25860</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Марково</td>\n",
       "      <td>д</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>56.38.17</td>\n",
       "      <td>045.22.54</td>\n",
       "      <td>56.638056</td>\n",
       "      <td>45.381667</td>\n",
       "      <td>22622456131</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.988521</td>\n",
       "      <td>0.792060</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>8.310078</td>\n",
       "      <td>Елдежская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>53456</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Ладыгино</td>\n",
       "      <td>д</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>56.43.07</td>\n",
       "      <td>045.50.06</td>\n",
       "      <td>56.718611</td>\n",
       "      <td>45.835000</td>\n",
       "      <td>22622408176</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.989927</td>\n",
       "      <td>0.799972</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>7.859978</td>\n",
       "      <td>Красноярская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20401</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Бараново</td>\n",
       "      <td>д</td>\n",
       "      <td>191</td>\n",
       "      <td>35</td>\n",
       "      <td>56.48.35</td>\n",
       "      <td>045.14.41</td>\n",
       "      <td>56.809722</td>\n",
       "      <td>45.244722</td>\n",
       "      <td>22622416116</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991517</td>\n",
       "      <td>0.789669</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>7.832342</td>\n",
       "      <td>Владимирская школа</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>80366</td>\n",
       "      <td>Нижегородская область</td>\n",
       "      <td>Воскресенский район</td>\n",
       "      <td>Пузеево</td>\n",
       "      <td>д</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56.49.46</td>\n",
       "      <td>045.14.38</td>\n",
       "      <td>56.829444</td>\n",
       "      <td>45.243889</td>\n",
       "      <td>22622404176</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.991861</td>\n",
       "      <td>0.789655</td>\n",
       "      <td>https://schoolotzyv.ru/component/schools/9-rus...</td>\n",
       "      <td>7.757832</td>\n",
       "      <td>Владимирская школа</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         id                 region         municipality      settlement type  \\\n",
       "41    41506  Нижегородская область  Воскресенский район  Красная Звезда    д   \n",
       "22    25057  Нижегородская область  Воскресенский район        Автулиха    д   \n",
       "85    83050  Нижегородская область  Воскресенский район        Томилиха    д   \n",
       "141  138624  Нижегородская область  Воскресенский район        Бахарево    д   \n",
       "6      4922  Нижегородская область  Воскресенский район         Петрово    д   \n",
       "19    21738  Нижегородская область  Воскресенский район  Красные Поляны    д   \n",
       "156  154802  Нижегородская область  Воскресенский район       Успенское    с   \n",
       "62    58690  Нижегородская область  Воскресенский район           Завод    д   \n",
       "27    27980  Нижегородская область  Воскресенский район        Шурговаш    с   \n",
       "65    60613  Нижегородская область  Воскресенский район      Прудовские    д   \n",
       "134  133929  Нижегородская область  Воскресенский район  Малое Содомово    д   \n",
       "24    25860  Нижегородская область  Воскресенский район         Марково    д   \n",
       "57    53456  Нижегородская область  Воскресенский район        Ладыгино    д   \n",
       "18    20401  Нижегородская область  Воскресенский район        Бараново    д   \n",
       "81    80366  Нижегородская область  Воскресенский район         Пузеево    д   \n",
       "\n",
       "     population  children latitude_dms longitude_dms  latitude_dd  \\\n",
       "41            0         0     56.29.48     045.33.09    56.496667   \n",
       "22           10         0     56.37.54     045.27.45    56.631667   \n",
       "85            2         0     56.41.42     045.51.14    56.695000   \n",
       "141          22         2     56.41.55     045.51.08    56.698611   \n",
       "6             0         0     57.03.02     045.33.42    57.050556   \n",
       "19            1         0     56.50.53     045.46.25    56.848056   \n",
       "156           1         0     56.42.32     045.51.24    56.708889   \n",
       "62           15         0     56.37.41     045.25.02    56.628056   \n",
       "27          114        12     56.46.25     045.14.10    56.773611   \n",
       "65            3         0     57.03.11     045.31.26    57.053056   \n",
       "134          56         9     57.02.11     045.36.05    57.036389   \n",
       "24           28         0     56.38.17     045.22.54    56.638056   \n",
       "57           16         5     56.43.07     045.50.06    56.718611   \n",
       "18          191        35     56.48.35     045.14.41    56.809722   \n",
       "81            1         0     56.49.46     045.14.38    56.829444   \n",
       "\n",
       "     longitude_dd        oktmo  dadata  rosstat  lat_radians_B  \\\n",
       "41      45.552500  22622432126       0        1       0.986053   \n",
       "22      45.462500  22622456106       0        1       0.988409   \n",
       "85      45.853889  22622408206       0        1       0.989514   \n",
       "141     45.852222  22622408111       0        1       0.989577   \n",
       "6       45.561667  22622420181       0        1       0.995720   \n",
       "19      45.773611  22622424141       0        1       0.992186   \n",
       "156     45.856667  22622408221       0        1       0.989757   \n",
       "62      45.417222  22622456116       0        1       0.988346   \n",
       "27      45.236111  22622416186       1        0       0.990886   \n",
       "65      45.523889  22622420186       0        1       0.995764   \n",
       "134     45.601389  22622420161       0        1       0.995473   \n",
       "24      45.381667  22622456131       0        1       0.988521   \n",
       "57      45.835000  22622408176       0        1       0.989927   \n",
       "18      45.244722  22622416116       0        1       0.991517   \n",
       "81      45.243889  22622404176       0        1       0.991861   \n",
       "\n",
       "     long_radians_B                                  school_url_column  \\\n",
       "41         0.795041  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "22         0.793470  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "85         0.800301  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "141        0.800272  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "6          0.795201  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "19         0.798900  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "156        0.800350  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "62         0.792680  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "27         0.789519  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "65         0.794542  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "134        0.795894  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "24         0.792060  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "57         0.799972  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "18         0.789669  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "81         0.789655  https://schoolotzyv.ru/component/schools/9-rus...   \n",
       "\n",
       "     min_distance_column           school_name  \n",
       "41             11.260120      Егоровская школа  \n",
       "22             10.768442      Егоровская школа  \n",
       "85             10.087465     Докукинская школа  \n",
       "141             9.853790     Докукинская школа  \n",
       "6               9.822884  Староустинская школа  \n",
       "19              9.708871    Красноярская школа  \n",
       "156             9.567901    Красноярская школа  \n",
       "62              8.986548     Нестиарская школа  \n",
       "27              8.894897    Владимирская школа  \n",
       "65              8.605541  Староустинская школа  \n",
       "134             8.483822   Воздвиженская школа  \n",
       "24              8.310078       Елдежская школа  \n",
       "57              7.859978    Красноярская школа  \n",
       "18              7.832342    Владимирская школа  \n",
       "81              7.757832    Владимирская школа  "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places_voskresensk.nlargest(15,'min_distance_column')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3385\n",
      "269\n"
     ]
    }
   ],
   "source": [
    "# или посчитать, сколько детей в Воскресенском районе Нижегородской обл. живут дальше 5 км от школы\n",
    "\n",
    "km5 = places_voskresensk[places_voskresensk['min_distance_column'] > 5]\n",
    "print(places_voskresensk['children'].sum()) # всего детей\n",
    "print(km5['children'].sum()) # живут дальше 5 км"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.91580963122014"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# или среднее расстояние от населенного пункта до школы \n",
    "\n",
    "places_voskresensk['min_distance_column'].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}