{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['bollywood_full_1950-2019.csv',\n",
       " 'common_words.csv',\n",
       " 'MovieGenre.csv',\n",
       " 'Top_10000_Movies.csv']"
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dirc = 'data'\n",
    "os.listdir(dirc)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "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>imdbId</th>\n",
       "      <th>Imdb Link</th>\n",
       "      <th>Title</th>\n",
       "      <th>IMDB Score</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15367</th>\n",
       "      <td>1320082</td>\n",
       "      <td>http://www.imdb.com/title/tt1320082</td>\n",
       "      <td>Le concert (2009)</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Comedy|Drama|Music</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        imdbId                            Imdb Link              Title  \\\n",
       "15367  1320082  http://www.imdb.com/title/tt1320082  Le concert (2009)   \n",
       "\n",
       "       IMDB Score               Genre  \\\n",
       "15367         7.6  Comedy|Drama|Music   \n",
       "\n",
       "                                                  Poster  \n",
       "15367  https://images-na.ssl-images-amazon.com/images...  "
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('data/MovieGenre.csv', encoding='latin-1')\n",
    "df.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40108, 6)"
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 40108 entries, 0 to 40107\n",
      "Data columns (total 6 columns):\n",
      " #   Column      Non-Null Count  Dtype  \n",
      "---  ------      --------------  -----  \n",
      " 0   imdbId      40108 non-null  int64  \n",
      " 1   Imdb Link   40108 non-null  object \n",
      " 2   Title       40108 non-null  object \n",
      " 3   IMDB Score  40060 non-null  float64\n",
      " 4   Genre       39963 non-null  object \n",
      " 5   Poster      39383 non-null  object \n",
      "dtypes: float64(1), int64(1), object(4)\n",
      "memory usage: 1.8+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "593"
      ]
     },
     "execution_count": 197,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.duplicated().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "imdbId          0\n",
       "Imdb Link       0\n",
       "Title           0\n",
       "IMDB Score     48\n",
       "Genre         145\n",
       "Poster        724\n",
       "dtype: int64"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(38654, 6)"
      ]
     },
     "execution_count": 201,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [],
   "source": [
    "pop = df[df[\"IMDB Score\"] > 7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://images-na.ssl-images-amazon.com/images/M/MV5BMDU2ZWJlMjktMTRhMy00ZTA5LWEzNDgtYmNmZTEwZTViZWJkXkEyXkFqcGdeQXVyNDQ2OTk4MzI@._V1_UX182_CR0,0,182,268_AL_.jpg'"
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0,\"Poster\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(12345, 6)"
      ]
     },
     "execution_count": 204,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "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>imdbId</th>\n",
       "      <th>Imdb Link</th>\n",
       "      <th>Title</th>\n",
       "      <th>IMDB Score</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>114709</td>\n",
       "      <td>http://www.imdb.com/title/tt114709</td>\n",
       "      <td>Toy Story (1995)</td>\n",
       "      <td>8.3</td>\n",
       "      <td>Animation|Adventure|Comedy</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   imdbId                           Imdb Link             Title  IMDB Score  \\\n",
       "0  114709  http://www.imdb.com/title/tt114709  Toy Story (1995)         8.3   \n",
       "\n",
       "                        Genre  \\\n",
       "0  Animation|Adventure|Comedy   \n",
       "\n",
       "                                              Poster  \n",
       "0  https://images-na.ssl-images-amazon.com/images...  "
      ]
     },
     "execution_count": 205,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\4084604473.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop[\"year\"] = pop[\"Title\"].apply(lambda x: x[-5:-1])\n"
     ]
    },
    {
     "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>imdbId</th>\n",
       "      <th>Imdb Link</th>\n",
       "      <th>Title</th>\n",
       "      <th>IMDB Score</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>114709</td>\n",
       "      <td>http://www.imdb.com/title/tt114709</td>\n",
       "      <td>Toy Story (1995)</td>\n",
       "      <td>8.3</td>\n",
       "      <td>Animation|Adventure|Comedy</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   imdbId                           Imdb Link             Title  IMDB Score  \\\n",
       "0  114709  http://www.imdb.com/title/tt114709  Toy Story (1995)         8.3   \n",
       "\n",
       "                        Genre  \\\n",
       "0  Animation|Adventure|Comedy   \n",
       "\n",
       "                                              Poster  year  \n",
       "0  https://images-na.ssl-images-amazon.com/images...  1995  "
      ]
     },
     "execution_count": 206,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop[\"year\"] = pop[\"Title\"].apply(lambda x: x[-5:-1])\n",
    "pop.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1782434620.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(11987, 7)"
      ]
     },
     "execution_count": 207,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in pop[\"year\"]:\n",
    "    if not str(i).isdigit():\n",
    "        pop.drop(index = pop[pop[\"year\"]==i].index[0], inplace=True)\n",
    "pop.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "metadata": {},
   "outputs": [],
   "source": [
    "pop.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        1995\n",
       "1        1995\n",
       "2        1995\n",
       "3        1995\n",
       "4        1995\n",
       "         ... \n",
       "11982    2016\n",
       "11983    2009\n",
       "11984    1967\n",
       "11985    2014\n",
       "11986    2015\n",
       "Name: year, Length: 11987, dtype: int64"
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.to_numeric(pop[\"year\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2017'"
      ]
     },
     "execution_count": 210,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max(pop[\"year\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [],
   "source": [
    "l = []\n",
    "def year(df) : \n",
    "    try : \n",
    "        if int(df['year']) > 1999 : \n",
    "            l.append(df.name)\n",
    "    except : \n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        None\n",
       "1        None\n",
       "2        None\n",
       "3        None\n",
       "4        None\n",
       "         ... \n",
       "11982    None\n",
       "11983    None\n",
       "11984    None\n",
       "11985    None\n",
       "11986    None\n",
       "Length: 11987, dtype: object"
      ]
     },
     "execution_count": 212,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pop.apply(year, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies = pop.iloc[l,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5431, 7)"
      ]
     },
     "execution_count": 214,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "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>index</th>\n",
       "      <th>imdbId</th>\n",
       "      <th>Imdb Link</th>\n",
       "      <th>Title</th>\n",
       "      <th>IMDB Score</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>3999</td>\n",
       "      <td>424942</td>\n",
       "      <td>http://www.imdb.com/title/tt424942</td>\n",
       "      <td>Deep Sea (2006)</td>\n",
       "      <td>7.6</td>\n",
       "      <td>Documentary|Short</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2006</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  imdbId                           Imdb Link            Title  \\\n",
       "801   3999  424942  http://www.imdb.com/title/tt424942  Deep Sea (2006)   \n",
       "\n",
       "     IMDB Score              Genre  \\\n",
       "801         7.6  Documentary|Short   \n",
       "\n",
       "                                                Poster  year  \n",
       "801  https://images-na.ssl-images-amazon.com/images...  2006  "
      ]
     },
     "execution_count": 216,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\1213414677.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  movies.drop(columns=[\"index\", \"imdbId\", \"Imdb Link\", \"IMDB Score\"], inplace=True)\n"
     ]
    },
    {
     "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2291</th>\n",
       "      <td>Kongen av BastÌüy (2010)</td>\n",
       "      <td>Action|Drama</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title         Genre  \\\n",
       "2291  Kongen av BastÌüy (2010)  Action|Drama   \n",
       "\n",
       "                                                 Poster  year  \n",
       "2291  https://images-na.ssl-images-amazon.com/images...  2010  "
      ]
     },
     "execution_count": 217,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.drop(columns=[\"index\", \"imdbId\", \"Imdb Link\", \"IMDB Score\"], inplace=True)\n",
    "movies.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 218,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Title     0\n",
       "Genre     0\n",
       "Poster    0\n",
       "year      0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 218,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\2088150227.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  movies[\"Genre\"] = movies[\"Genre\"].apply(lambda row: str(row).split(\"|\"))\n"
     ]
    },
    {
     "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>Tian xia wu shuang (2002)</td>\n",
       "      <td>[Comedy, Romance, Action]</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title                      Genre  \\\n",
       "519  Tian xia wu shuang (2002)  [Comedy, Romance, Action]   \n",
       "\n",
       "                                                Poster  year  \n",
       "519  https://images-na.ssl-images-amazon.com/images...  2002  "
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[\"Genre\"] = movies[\"Genre\"].apply(lambda row: str(row).split(\"|\"))\n",
    "movies.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 220,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\290733750.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  movies[\"tags\"] = movies[\"Title\"].apply(lambda x: str(x)[:-6].split())\n"
     ]
    }
   ],
   "source": [
    "movies[\"tags\"] = movies[\"Title\"].apply(lambda x: str(x)[:-6].split())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 221,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\3437699301.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  movies[\"tags\"] = movies[\"tags\"] + movies[\"Genre\"]\n",
      "C:\\Users\\jaksh\\AppData\\Local\\Temp\\ipykernel_2556\\3437699301.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  movies[\"tags\"] = movies[\"tags\"].apply(lambda x: (\" \".join(x)).lower())\n"
     ]
    }
   ],
   "source": [
    "movies[\"tags\"] = movies[\"tags\"] + movies[\"Genre\"]\n",
    "movies[\"tags\"] = movies[\"tags\"].apply(lambda x: (\" \".join(x)).lower())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2192</th>\n",
       "      <td>Chak de! India (2007)</td>\n",
       "      <td>[Drama, Family, Sport]</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2007</td>\n",
       "      <td>chak de! india drama family sport</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Title                   Genre  \\\n",
       "2192  Chak de! India (2007)  [Drama, Family, Sport]   \n",
       "\n",
       "                                                 Poster  year  \\\n",
       "2192  https://images-na.ssl-images-amazon.com/images...  2007   \n",
       "\n",
       "                                   tags  \n",
       "2192  chak de! india drama family sport  "
      ]
     },
     "execution_count": 222,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pickle import load\n",
    "bolly = load(open(\"movie_info.pkl\",\"rb\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "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>poster_path</th>\n",
       "      <th>original_title</th>\n",
       "      <th>year_of_release</th>\n",
       "      <th>genres</th>\n",
       "      <th>imdb_rating</th>\n",
       "      <th>imdb_votes</th>\n",
       "      <th>summary</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>https://upload.wikimedia.org/wikipedia/en/c/c5...</td>\n",
       "      <td>Kisaan</td>\n",
       "      <td>2009</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "      <td>5.4</td>\n",
       "      <td>256.0</td>\n",
       "      <td>[Widower, farmer, Dayal, Singh, based, in, Pal...</td>\n",
       "      <td>action crime drama widow farmer dayal singh ba...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           poster_path original_title  \\\n",
       "946  https://upload.wikimedia.org/wikipedia/en/c/c5...         Kisaan   \n",
       "\n",
       "    year_of_release                  genres  imdb_rating  imdb_votes  \\\n",
       "946            2009  [Action, Crime, Drama]          5.4       256.0   \n",
       "\n",
       "                                               summary  \\\n",
       "946  [Widower, farmer, Dayal, Singh, based, in, Pal...   \n",
       "\n",
       "                                                  tags  \n",
       "946  action crime drama widow farmer dayal singh ba...  "
      ]
     },
     "execution_count": 224,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bolly = pd.DataFrame(bolly)\n",
    "bolly.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 225,
   "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>Title</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Poster</th>\n",
       "      <th>year</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4604</th>\n",
       "      <td>K̫kaku kid̫tai: Stand Alone Complex Solid St...</td>\n",
       "      <td>[Animation, Action, Adventure]</td>\n",
       "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
       "      <td>2006</td>\n",
       "      <td>kì«kaku kidì«tai: stand alone complex solid st...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Title  \\\n",
       "4604  K̫kaku kid̫tai: Stand Alone Complex Solid St...   \n",
       "\n",
       "                               Genre  \\\n",
       "4604  [Animation, Action, Adventure]   \n",
       "\n",
       "                                                 Poster  year  \\\n",
       "4604  https://images-na.ssl-images-amazon.com/images...  2006   \n",
       "\n",
       "                                                   tags  \n",
       "4604  kì«kaku kidì«tai: stand alone complex solid st...  "
      ]
     },
     "execution_count": 225,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "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>Poster</th>\n",
       "      <th>Title</th>\n",
       "      <th>year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>imdb_rating</th>\n",
       "      <th>imdb_votes</th>\n",
       "      <th>summary</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1558</th>\n",
       "      <td>https://indianbankseauction.com/PropertyImages...</td>\n",
       "      <td>Yeh Kaisi Mohabbat</td>\n",
       "      <td>2002</td>\n",
       "      <td>[Drama, Musical, Romance]</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>[Yeh, Kaisi, Mohabbat, (YKM), is, a, romantic,...</td>\n",
       "      <td>drama music romanc yeh kaisi mohabbat (ykm) is...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Poster               Title  \\\n",
       "1558  https://indianbankseauction.com/PropertyImages...  Yeh Kaisi Mohabbat   \n",
       "\n",
       "      year                      Genre  imdb_rating  imdb_votes  \\\n",
       "1558  2002  [Drama, Musical, Romance]          4.0        29.0   \n",
       "\n",
       "                                                summary  \\\n",
       "1558  [Yeh, Kaisi, Mohabbat, (YKM), is, a, romantic,...   \n",
       "\n",
       "                                                   tags  \n",
       "1558  drama music romanc yeh kaisi mohabbat (ykm) is...  "
      ]
     },
     "execution_count": 226,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bolly.rename(columns={\"poster_path\" : \"Poster\", \"original_title\" : \"Title\", \n",
    "                \"year_of_release\" : \"year\", \"genres\" : \"Genre\"}, inplace=True)\n",
    "\n",
    "bolly.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [],
   "source": [
    "bolly.shape \n",
    "bolly.reset_index(inplace=True)\n",
    "movies.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "new = pd.concat([bolly, movies]).drop(columns=[\"imdb_rating\",\"imdb_votes\",\"summary\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [],
   "source": [
    "new.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5431, 6)"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "level_0    0\n",
       "index      0\n",
       "Poster     0\n",
       "Title      0\n",
       "year       0\n",
       "Genre      0\n",
       "tags       0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 231,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7118 entries, 0 to 7117\n",
      "Data columns (total 7 columns):\n",
      " #   Column   Non-Null Count  Dtype \n",
      "---  ------   --------------  ----- \n",
      " 0   level_0  7118 non-null   int64 \n",
      " 1   index    7118 non-null   int64 \n",
      " 2   Poster   7118 non-null   object\n",
      " 3   Title    7118 non-null   object\n",
      " 4   year     7118 non-null   object\n",
      " 5   Genre    7118 non-null   object\n",
      " 6   tags     7118 non-null   object\n",
      "dtypes: int64(2), object(5)\n",
      "memory usage: 389.4+ KB\n"
     ]
    }
   ],
   "source": [
    "new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "new[\"year\"] = pd.to_numeric(new[\"year\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 7118 entries, 0 to 7117\n",
      "Data columns (total 7 columns):\n",
      " #   Column   Non-Null Count  Dtype \n",
      "---  ------   --------------  ----- \n",
      " 0   level_0  7118 non-null   int64 \n",
      " 1   index    7118 non-null   int64 \n",
      " 2   Poster   7118 non-null   object\n",
      " 3   Title    7118 non-null   object\n",
      " 4   year     7118 non-null   int64 \n",
      " 5   Genre    7118 non-null   object\n",
      " 6   tags     7118 non-null   object\n",
      "dtypes: int64(3), object(4)\n",
      "memory usage: 389.4+ KB\n"
     ]
    }
   ],
   "source": [
    "new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "cv = CountVectorizer(max_features=5000, stop_words='english')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [],
   "source": [
    "vectors = cv.fit_transform(new[\"tags\"]).toarray()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7118, 5000)"
      ]
     },
     "execution_count": 237,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vectors.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [],
   "source": [
    "most_common_words = cv.get_feature_names_out()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "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>000</th>\n",
       "      <th>10</th>\n",
       "      <th>100</th>\n",
       "      <th>10th</th>\n",
       "      <th>11</th>\n",
       "      <th>11th</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>13th</th>\n",
       "      <th>14</th>\n",
       "      <th>...</th>\n",
       "      <th>zero</th>\n",
       "      <th>zinda</th>\n",
       "      <th>zindagi</th>\n",
       "      <th>zinta</th>\n",
       "      <th>zone</th>\n",
       "      <th>zooni</th>\n",
       "      <th>zoya</th>\n",
       "      <th>zubeida</th>\n",
       "      <th>zulfi</th>\n",
       "      <th>ìê</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>7113</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7114</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7115</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7116</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7117</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7118 rows × 5000 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      000  10  100  10th  11  11th  12  13  13th  14  ...  zero  zinda  \\\n",
       "0       0   0    0     0   1     0   0   0     0   0  ...     0      0   \n",
       "1       0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "2       0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "3       0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "4       0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "...   ...  ..  ...   ...  ..   ...  ..  ..   ...  ..  ...   ...    ...   \n",
       "7113    0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "7114    0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "7115    0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "7116    0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "7117    0   0    0     0   0     0   0   0     0   0  ...     0      0   \n",
       "\n",
       "      zindagi  zinta  zone  zooni  zoya  zubeida  zulfi  ìê  \n",
       "0           0      0     0      0     0        0      0   0  \n",
       "1           0      0     0      0     0        0      0   0  \n",
       "2           0      0     0      0     0        0      0   0  \n",
       "3           0      0     0      0     0        0      0   0  \n",
       "4           0      0     0      0     0        0      0   0  \n",
       "...       ...    ...   ...    ...   ...      ...    ...  ..  \n",
       "7113        0      0     0      0     0        0      0   0  \n",
       "7114        0      0     0      0     0        0      0   0  \n",
       "7115        0      0     0      0     0        0      0   0  \n",
       "7116        0      0     0      0     0        0      0   0  \n",
       "7117        0      0     0      0     0        0      0   0  \n",
       "\n",
       "[7118 rows x 5000 columns]"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cs = pd.DataFrame(vectors, columns=most_common_words)\n",
    "cs.to_csv(\"data\\common_words.csv\")\n",
    "cs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {},
   "outputs": [],
   "source": [
    "similarity = cosine_similarity(vectors)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {},
   "outputs": [],
   "source": [
    "def recommended_movies(mov):\n",
    "    idx = new[new[\"Title\"] == mov].index[0]\n",
    "    corr = similarity[idx]\n",
    "    rec = sorted(list(enumerate(corr)), reverse=True, key=lambda x: x[1])[1:6]\n",
    "\n",
    "    for i in rec:\n",
    "        print(new.iloc[i[0]].Title)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Melancholian 3 huonetta (2004)\n",
      "The War on Democracy (2007)\n",
      "My First War (2008)\n",
      "Shooting War (2000)\n",
      "Armadillo (2010)\n"
     ]
    }
   ],
   "source": [
    "recommended_movies(\"Armadillo (2010)\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pickle import dump,load"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [],
   "source": [
    "dump(new, open(\"hollywood.pkl\", 'wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {},
   "outputs": [],
   "source": [
    "dump(similarity, open(\"sim_hollywood.pkl\", 'wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2 = load(open(\"hollywood.pkl\", 'rb'))\n",
    "holly = pd.DataFrame(data2)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>Poster</th>\n",
       "      <th>Title</th>\n",
       "      <th>year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>853</td>\n",
       "      <td>853</td>\n",
       "      <td>https://upload.wikimedia.org/wikipedia/en/thum...</td>\n",
       "      <td>Housefull</td>\n",
       "      <td>2010</td>\n",
       "      <td>[Comedy]</td>\n",
       "      <td>comedi houseful is a romant comedi entertain w...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     level_0  index                                             Poster  \\\n",
       "853      853    853  https://upload.wikimedia.org/wikipedia/en/thum...   \n",
       "\n",
       "         Title  year     Genre  \\\n",
       "853  Housefull  2010  [Comedy]   \n",
       "\n",
       "                                                  tags  \n",
       "853  comedi houseful is a romant comedi entertain w...  "
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly.sample()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(7118, 7)"
      ]
     },
     "execution_count": 249,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>Poster</th>\n",
       "      <th>Title</th>\n",
       "      <th>year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://upload.wikimedia.org/wikipedia/en/thum...</td>\n",
       "      <td>Uri: The Surgical Strike</td>\n",
       "      <td>2019</td>\n",
       "      <td>[Action, Drama, War]</td>\n",
       "      <td>action drama war divid over five chapter the f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   level_0  index                                             Poster  \\\n",
       "0        0      0  https://upload.wikimedia.org/wikipedia/en/thum...   \n",
       "\n",
       "                      Title  year                 Genre  \\\n",
       "0  Uri: The Surgical Strike  2019  [Action, Drama, War]   \n",
       "\n",
       "                                                tags  \n",
       "0  action drama war divid over five chapter the f...  "
      ]
     },
     "execution_count": 250,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([0], dtype='int64')"
      ]
     },
     "execution_count": 251,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly[holly[\"Title\"] == \"Uri: The Surgical Strike\"].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('Avatar (2009)',\n",
       " 'https://images-na.ssl-images-amazon.com/images/M/MV5BMTYwOTEwNjAzMl5BMl5BanBnXkFtZTcwODc5MTUwMw@@._V1_UX182_CR0,0,182,268_AL_.jpg',\n",
       " 'Action Adventure Fantasy',\n",
       " 2009,\n",
       " ' ',\n",
       " 3235)"
      ]
     },
     "execution_count": 252,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "idx = holly[holly[\"Title\"] == \"Avatar (2009)\"].index[0]\n",
    "p = holly.iloc[idx].Poster\n",
    "l = holly.iloc[idx].Title\n",
    "c = \" \".join([holly.iloc[idx].Genre][0])\n",
    "y = holly.iloc[idx].year\n",
    "s = \" \"\n",
    "l,p,c,y,s,idx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>Poster</th>\n",
       "      <th>Title</th>\n",
       "      <th>year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>https://upload.wikimedia.org/wikipedia/en/thum...</td>\n",
       "      <td>Uri: The Surgical Strike</td>\n",
       "      <td>2019</td>\n",
       "      <td>[Action, Drama, War]</td>\n",
       "      <td>action drama war divid over five chapter the f...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   level_0  index                                             Poster  \\\n",
       "0        0      0  https://upload.wikimedia.org/wikipedia/en/thum...   \n",
       "\n",
       "                      Title  year                 Genre  \\\n",
       "0  Uri: The Surgical Strike  2019  [Action, Drama, War]   \n",
       "\n",
       "                                                tags  \n",
       "0  action drama war divid over five chapter the f...  "
      ]
     },
     "execution_count": 253,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly[holly[\"Title\"] == \"Uri: The Surgical Strike\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 254,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "level_0                                                 1548\n",
       "index                                                   1548\n",
       "Poster     https://upload.wikimedia.org/wikipedia/en/thum...\n",
       "Title                                                 Pyaasa\n",
       "year                                                    2002\n",
       "Genre                                                [Drama]\n",
       "tags       drama suraj thakur (aftab shivdasani) is one o...\n",
       "Name: 1548, dtype: object"
      ]
     },
     "execution_count": 254,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "holly.iloc[1548]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "706654849fe4d07e215a38f448ee8e5d780794e2be3793e11d37ab3169b306ae"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}