05_Eksik_Kayip_Veri_Yontemleri.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f70fba10",
   "metadata": {},
   "source": [
    "# Eksik / Kayıp Veri Tespiti ve Düzenleme Yöntemleri\n",
    "Veri çerçevemizde eksik veri (excel tablosundaki boş hücre gibi düşünebiliriz) olup olmadığını, varsa kaç adet olduğunu tespit edebileceğimiz Pandas yöntemleri mevcuttur. Bunları incelemeye başlayalım.\n",
    "\n",
    "## isnull() Fonksiyonu\n",
    "\n",
    "Veri çerçevemizde eksik verileri **isnull()** fonksiyonu ile tespit edebiliriz. **isnull** ifadesini, **boş mu?, geçersiz mi?, kayıp/eksik mi?** sorusu olarak düşünebilirsiniz.\n",
    "Hemen inceleyelim bakalım, acaba **IMDB** listemizde eksik veri var mı? varsa hangi sütunda ne kadar eksik veri var?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d9689dab",
   "metadata": {
    "scrolled": false
   },
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>247 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Film_Adı    Yıl   Puan  Oylayan_Kişi\n",
       "0       False  False  False         False\n",
       "1       False  False  False         False\n",
       "2       False  False  False         False\n",
       "3       False  False  False         False\n",
       "4       False  False  False         False\n",
       "..        ...    ...    ...           ...\n",
       "242     False  False  False         False\n",
       "243     False  False  False         False\n",
       "244     False  False  False         False\n",
       "245     False  False  False         False\n",
       "246     False  False  False         False\n",
       "\n",
       "[247 rows x 4 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "imdb = pd.read_excel(\"Veri_Setleri/imdb.xlsx\")\n",
    "imdb.isnull()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "28e38eb7",
   "metadata": {},
   "source": [
    "Görüldüğü üzere, bu fonksiyon, veri çerçevesindeki her hücreye, kayıp/eksik veri olup olmadığı verisini yazıyor. **False** Yanlış, yani Eksik/Kayıp veri **YOK**, **True** ise Doğru yan, Eksik/Kayıp veri **VAR** anlamına gelir.\n",
    "Tabloya tek tek bakmak yerine, tüm sütunlardaki eksik/kayıp verileri python'a saydırıp, sonucu görüntüleyebiliriz.\n",
    "Python'da aşina olduğumuz **sum()** fonksiyonu işimize yarayacaktır."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "aa9371cb",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Film_Adı        0\n",
       "Yıl             0\n",
       "Puan            0\n",
       "Oylayan_Kişi    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdb.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7248dfb8",
   "metadata": {},
   "source": [
    "Gördüğümüz kadarıyla tüm sonuçlar sıfır, yani veri çerçevemizde hiç eksik/kayıp veri bulunmamaktadır.\n",
    "\n",
    "İçerisinde Kayıp/Eksik veri olan bir **Calc** tablosunu, veri çerçevesine dönüştürerek inceleyelim."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f4fe9bcc",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1957.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,7</td>\n",
       "      <td>161969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan  \\\n",
       "0                           The Shawshank Redemption   1994.0  9,2   \n",
       "1                                      The Godfather   1972.0  9,2   \n",
       "2                             The Godfather: Part II   1974.0    9   \n",
       "3                                       Pulp Fiction   1994.0  8,9   \n",
       "4                                    The Dark Knight   2008.0  8,9   \n",
       "5                                       12 Angry Men   1957.0  8,9   \n",
       "6                                   Schindler's List   1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8   \n",
       "8                                         Fight Club   1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7   \n",
       "12                                        Goodfellas   1990.0  8,7   \n",
       "13                                     Seven Samurai      NaN  8,7   \n",
       "14                                         Inception   2010.0  8,7   \n",
       "15                                         Star Wars   1977.0  8,7   \n",
       "16                                      Forrest Gump   1994.0  8,7   \n",
       "17                                        The Matrix   1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7   \n",
       "\n",
       "    Oylayan_Kişi  \n",
       "0      1071904.0  \n",
       "1       751381.0  \n",
       "2       488889.0  \n",
       "3       830504.0  \n",
       "4      1045186.0  \n",
       "5            NaN  \n",
       "6       545703.0  \n",
       "7       758388.0  \n",
       "8       814389.0  \n",
       "9       519895.0  \n",
       "10      784999.0  \n",
       "11      447005.0  \n",
       "12      465445.0  \n",
       "13      161969.0  \n",
       "14      844938.0  \n",
       "15           NaN  \n",
       "16      711386.0  \n",
       "17      770559.0  \n",
       "18      680983.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri = pd.read_excel(\"Veri_Setleri/eksik_veri.ods\")\n",
    "veri"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "93d63d8b",
   "metadata": {},
   "source": [
    "**isnull().sum()** metodlarıyla, yeni veri çerçevemizdeki eksik verilerin bilgilerini görelim "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7f717867",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Film_Adı        0\n",
       "Yıl             1\n",
       "Puan            0\n",
       "Oylayan_Kişi    2\n",
       "dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "59c67269",
   "metadata": {},
   "source": [
    "**Yıl** sütununda 1, **Oylayan_Kişi** sütununda 2 adet eksik veri olduğu görünüyor. Eksik veri olan satır ve sütunları silmeye / temizlemeye çalışalım.\n",
    "\n",
    "## dropna() Fonksiyonu\n",
    "\n",
    "Veri çerçevelerinde istediğimiz satır ve sütunları **drop()** metodu yardımı ile nasıl silebildiğimizi daha önce öğrenmiştik. İlgili sayfa [buradan](Duzenleme_Yontemleri.ipynb) erişebilirsiniz.\n",
    "\n",
    "Eksik veri barındıran Veri Çerçevelerinin hem satır hemde sütunlarını otomatik olarak silmek için **dropna()** metodunu kullanabiliriz. Metodun kullanım şekli aşağıdaki gibidir.\n",
    "\n",
    "***VeriÇerçevesi_Adı.dropna(axis = 0 ya da 1, inplace = True ya da False)*** \n",
    "\n",
    "### axis Parametresi\n",
    "Eksenleri tanımlayan parametredir. Sıfır (0) Satırları, Bir (1) Sütunları temsil eder. Varsayılan değer Sıfır(0) yani Satırlardır.\n",
    "\n",
    "### inplace Parametresi\n",
    "Gerçekleştirilen silme işleminin veri çerçevesinde kalıcı ya da geçici olmasını ayarladığımız parametredir. **inplace = True** yazılırsa, yapılan işlem kalıcı hale gelecektir."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "9119c71d",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan  \\\n",
       "0                           The Shawshank Redemption   1994.0  9,2   \n",
       "1                                      The Godfather   1972.0  9,2   \n",
       "2                             The Godfather: Part II   1974.0    9   \n",
       "3                                       Pulp Fiction   1994.0  8,9   \n",
       "4                                    The Dark Knight   2008.0  8,9   \n",
       "6                                   Schindler's List   1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8   \n",
       "8                                         Fight Club   1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7   \n",
       "12                                        Goodfellas   1990.0  8,7   \n",
       "14                                         Inception   2010.0  8,7   \n",
       "16                                      Forrest Gump   1994.0  8,7   \n",
       "17                                        The Matrix   1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7   \n",
       "\n",
       "    Oylayan_Kişi  \n",
       "0      1071904.0  \n",
       "1       751381.0  \n",
       "2       488889.0  \n",
       "3       830504.0  \n",
       "4      1045186.0  \n",
       "6       545703.0  \n",
       "7       758388.0  \n",
       "8       814389.0  \n",
       "9       519895.0  \n",
       "10      784999.0  \n",
       "11      447005.0  \n",
       "12      465445.0  \n",
       "14      844938.0  \n",
       "16      711386.0  \n",
       "17      770559.0  \n",
       "18      680983.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.dropna()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0e344b02",
   "metadata": {},
   "source": [
    "**dropna()** metodunu parametresiz olarak kullandığımızda ( *veri.dropna()* ), sadece eksik veri tespit edilen **satırlar** silindi. Bir de eksik veri bulunan sütunları silmeye çalışalım."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ad3e2bba",
   "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>Film_Adı</th>\n",
       "      <th>Puan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>9,2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>9,2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı Puan\n",
       "0                           The Shawshank Redemption   9,2\n",
       "1                                      The Godfather   9,2\n",
       "2                             The Godfather: Part II     9\n",
       "3                                       Pulp Fiction   8,9\n",
       "4                                    The Dark Knight   8,9\n",
       "5                                       12 Angry Men   8,9\n",
       "6                                   Schindler's List   8,9\n",
       "7      The Lord of the Rings: The Return of the King   8,8\n",
       "8                                         Fight Club   8,8\n",
       "9     Star Wars: Episode V - The Empire Strikes Back   8,8\n",
       "10  The Lord of the Rings: The Fellowship of the R...  8,8\n",
       "11                   One Flew Over the Cuckoo's Nest   8,7\n",
       "12                                        Goodfellas   8,7\n",
       "13                                     Seven Samurai   8,7\n",
       "14                                         Inception   8,7\n",
       "15                                         Star Wars   8,7\n",
       "16                                      Forrest Gump   8,7\n",
       "17                                        The Matrix   8,7\n",
       "18             The Lord of the Rings: The Two Towers   8,7"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.dropna(axis = 1)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "54d67a51",
   "metadata": {},
   "source": [
    "### thresh Parametresi\n",
    "\n",
    "**dropna()** Metodunun, **thresh** parametresi, veri çerçevesinde en az kaç adet veri varsa satır ya da sütunun silinmemesi gerektiğini belirtir. Bu parametreyi de hem satır hem de sütun için uygulayalım."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ea001c07",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1957.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,7</td>\n",
       "      <td>161969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan  \\\n",
       "0                           The Shawshank Redemption   1994.0  9,2   \n",
       "1                                      The Godfather   1972.0  9,2   \n",
       "2                             The Godfather: Part II   1974.0    9   \n",
       "3                                       Pulp Fiction   1994.0  8,9   \n",
       "4                                    The Dark Knight   2008.0  8,9   \n",
       "5                                       12 Angry Men   1957.0  8,9   \n",
       "6                                   Schindler's List   1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8   \n",
       "8                                         Fight Club   1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7   \n",
       "12                                        Goodfellas   1990.0  8,7   \n",
       "13                                     Seven Samurai      NaN  8,7   \n",
       "14                                         Inception   2010.0  8,7   \n",
       "15                                         Star Wars   1977.0  8,7   \n",
       "16                                      Forrest Gump   1994.0  8,7   \n",
       "17                                        The Matrix   1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7   \n",
       "\n",
       "    Oylayan_Kişi  \n",
       "0      1071904.0  \n",
       "1       751381.0  \n",
       "2       488889.0  \n",
       "3       830504.0  \n",
       "4      1045186.0  \n",
       "5            NaN  \n",
       "6       545703.0  \n",
       "7       758388.0  \n",
       "8       814389.0  \n",
       "9       519895.0  \n",
       "10      784999.0  \n",
       "11      447005.0  \n",
       "12      465445.0  \n",
       "13      161969.0  \n",
       "14      844938.0  \n",
       "15           NaN  \n",
       "16      711386.0  \n",
       "17      770559.0  \n",
       "18      680983.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.dropna(thresh=3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1ccc7749",
   "metadata": {},
   "source": [
    "**veri.dropna(thresh=3)**: Bu kod,en az 3 sağlam veri barındıran **satırları** silme demek oluyor. Aynı işlemi, **axis** parametresi kullanarak uygulamak istesek kodu şu şekilde yazmamız gerekecekti: ***veri.dropna(axis=0, thresh=3)***\n",
    "\n",
    "Bir de en az 4 sağlam veri isteyelim bakalım ne sonuç alacağız. Veri çerçevemizde 4 adet sütun bulunduğu için,  tümü geçerli, sağlam veri bulunan (dolu) sütunları bulmak istediğimiz anlamına geliyor."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "6b2b55f1",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan  \\\n",
       "0                           The Shawshank Redemption   1994.0  9,2   \n",
       "1                                      The Godfather   1972.0  9,2   \n",
       "2                             The Godfather: Part II   1974.0    9   \n",
       "3                                       Pulp Fiction   1994.0  8,9   \n",
       "4                                    The Dark Knight   2008.0  8,9   \n",
       "6                                   Schindler's List   1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8   \n",
       "8                                         Fight Club   1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7   \n",
       "12                                        Goodfellas   1990.0  8,7   \n",
       "14                                         Inception   2010.0  8,7   \n",
       "16                                      Forrest Gump   1994.0  8,7   \n",
       "17                                        The Matrix   1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7   \n",
       "\n",
       "    Oylayan_Kişi  \n",
       "0      1071904.0  \n",
       "1       751381.0  \n",
       "2       488889.0  \n",
       "3       830504.0  \n",
       "4      1045186.0  \n",
       "6       545703.0  \n",
       "7       758388.0  \n",
       "8       814389.0  \n",
       "9       519895.0  \n",
       "10      784999.0  \n",
       "11      447005.0  \n",
       "12      465445.0  \n",
       "14      844938.0  \n",
       "16      711386.0  \n",
       "17      770559.0  \n",
       "18      680983.0  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.dropna(thresh=4)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6bff0426",
   "metadata": {},
   "source": [
    "Tahmin ettiğiniz gibi, her satırda 4 bilgi bulunan satırlar kaldı, geri kalan **satırlar** silindi.\n",
    "\n",
    "Bu metodu bir de **sütunlarda** uygulayalım. Veri çerçevemizde 19 satır veri bulunmaktadır. En az 18 adet veri bulunan (yani sütünlarda en fazla 1 adet eksik veriye izin verdiğimiz durumdaki) sütunlar kalsın, geri kalanlar silinsin istersek;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "a2a708d2",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1957.0</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan\n",
       "0                           The Shawshank Redemption   1994.0  9,2\n",
       "1                                      The Godfather   1972.0  9,2\n",
       "2                             The Godfather: Part II   1974.0    9\n",
       "3                                       Pulp Fiction   1994.0  8,9\n",
       "4                                    The Dark Knight   2008.0  8,9\n",
       "5                                       12 Angry Men   1957.0  8,9\n",
       "6                                   Schindler's List   1993.0  8,9\n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8\n",
       "8                                         Fight Club   1999.0  8,8\n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8\n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8\n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7\n",
       "12                                        Goodfellas   1990.0  8,7\n",
       "13                                     Seven Samurai      NaN  8,7\n",
       "14                                         Inception   2010.0  8,7\n",
       "15                                         Star Wars   1977.0  8,7\n",
       "16                                      Forrest Gump   1994.0  8,7\n",
       "17                                        The Matrix   1999.0  8,7\n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.dropna(axis=1, thresh=18)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f8a44cdb",
   "metadata": {},
   "source": [
    "**Oylayan_Kişi** sütununda 2 adet eksik veri bulunduğu için o sütun silindi.\n",
    "\n",
    "## fillna() Fonksiyonu\n",
    "Veri Çerçevelerimizde eksik veri bulunması durumunda, her zaman satır ve sütunları silmeye çalışmayız. Bazen eksik verilerin yerine, yeni değer atamamız gerekebilir. Örneğin matematiksel işlemlerde, Pandas ile satır ya da sütunların ortalama değerlerini hesaplatıp, eksik verilerin yerine ( eksik veriyi, Excel programındaki boş hüçreler gibi düşünülebilir) yazdırabiliriz/atayabiliriz. \n",
    "\n",
    "### value Parametresi\n",
    "**value** parametresi, Eksik verilerin yerine istersek yazdırmak istediğimiz değerin belirtildiği kısımdır. **value** parametresine sayısal değer yazacağımız zaman doğrudan değerin kendisini, **metinsel (string)** ifadeler de yazacağımız zaman ise **tırnak işareti \"** kullanmamız gerektiğini unutmamalıyız. Şimdiki örnekte, Veri çerçevemizdeki eksik verilerin yerine **Mustafa Halil** ismini yazdıracağım."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b41c49ed",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1957.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>Mustafa Halil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>Mustafa Halil</td>\n",
       "      <td>8,7</td>\n",
       "      <td>161969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>Mustafa Halil</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı            Yıl Puan  \\\n",
       "0                           The Shawshank Redemption          1994.0  9,2   \n",
       "1                                      The Godfather          1972.0  9,2   \n",
       "2                             The Godfather: Part II          1974.0    9   \n",
       "3                                       Pulp Fiction          1994.0  8,9   \n",
       "4                                    The Dark Knight          2008.0  8,9   \n",
       "5                                       12 Angry Men          1957.0  8,9   \n",
       "6                                   Schindler's List          1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King          2003.0  8,8   \n",
       "8                                         Fight Club          1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back          1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...         2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest          1975.0  8,7   \n",
       "12                                        Goodfellas          1990.0  8,7   \n",
       "13                                     Seven Samurai   Mustafa Halil  8,7   \n",
       "14                                         Inception          2010.0  8,7   \n",
       "15                                         Star Wars          1977.0  8,7   \n",
       "16                                      Forrest Gump          1994.0  8,7   \n",
       "17                                        The Matrix          1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers          2002.0  8,7   \n",
       "\n",
       "     Oylayan_Kişi  \n",
       "0       1071904.0  \n",
       "1        751381.0  \n",
       "2        488889.0  \n",
       "3        830504.0  \n",
       "4       1045186.0  \n",
       "5   Mustafa Halil  \n",
       "6        545703.0  \n",
       "7        758388.0  \n",
       "8        814389.0  \n",
       "9        519895.0  \n",
       "10       784999.0  \n",
       "11       447005.0  \n",
       "12       465445.0  \n",
       "13       161969.0  \n",
       "14       844938.0  \n",
       "15  Mustafa Halil  \n",
       "16       711386.0  \n",
       "17       770559.0  \n",
       "18       680983.0  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri.fillna(value=\"Mustafa Halil\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "72abbc00",
   "metadata": {},
   "source": [
    "Boş hücrelere yani eksik verilerin yerine, **Yıl** sütununun ortalama değerini (1885.0) atamak isteseydik (saçma bir atama işlemi olduğunun farkındayım :) ), aşağıdaki gibi kodlarımızı düzenlememiz gerekecekti."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "84c91e45",
   "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>Film_Adı</th>\n",
       "      <th>Yıl</th>\n",
       "      <th>Puan</th>\n",
       "      <th>Oylayan_Kişi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>1071904.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>1972.0</td>\n",
       "      <td>9,2</td>\n",
       "      <td>751381.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>1974.0</td>\n",
       "      <td>9</td>\n",
       "      <td>488889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>830504.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1045186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>1957.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>1885.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>8,9</td>\n",
       "      <td>545703.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>758388.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>814389.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>519895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the R...</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>8,8</td>\n",
       "      <td>784999.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>447005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>1990.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>465445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>1885.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>161969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Inception</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>844938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Star Wars</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>1885.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>711386.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>770559.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>8,7</td>\n",
       "      <td>680983.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Film_Adı     Yıl Puan  \\\n",
       "0                           The Shawshank Redemption   1994.0  9,2   \n",
       "1                                      The Godfather   1972.0  9,2   \n",
       "2                             The Godfather: Part II   1974.0    9   \n",
       "3                                       Pulp Fiction   1994.0  8,9   \n",
       "4                                    The Dark Knight   2008.0  8,9   \n",
       "5                                       12 Angry Men   1957.0  8,9   \n",
       "6                                   Schindler's List   1993.0  8,9   \n",
       "7      The Lord of the Rings: The Return of the King   2003.0  8,8   \n",
       "8                                         Fight Club   1999.0  8,8   \n",
       "9     Star Wars: Episode V - The Empire Strikes Back   1980.0  8,8   \n",
       "10  The Lord of the Rings: The Fellowship of the R...  2001.0  8,8   \n",
       "11                   One Flew Over the Cuckoo's Nest   1975.0  8,7   \n",
       "12                                        Goodfellas   1990.0  8,7   \n",
       "13                                     Seven Samurai   1885.0  8,7   \n",
       "14                                         Inception   2010.0  8,7   \n",
       "15                                         Star Wars   1977.0  8,7   \n",
       "16                                      Forrest Gump   1994.0  8,7   \n",
       "17                                        The Matrix   1999.0  8,7   \n",
       "18             The Lord of the Rings: The Two Towers   2002.0  8,7   \n",
       "\n",
       "    Oylayan_Kişi  \n",
       "0      1071904.0  \n",
       "1       751381.0  \n",
       "2       488889.0  \n",
       "3       830504.0  \n",
       "4      1045186.0  \n",
       "5         1885.0  \n",
       "6       545703.0  \n",
       "7       758388.0  \n",
       "8       814389.0  \n",
       "9       519895.0  \n",
       "10      784999.0  \n",
       "11      447005.0  \n",
       "12      465445.0  \n",
       "13      161969.0  \n",
       "14      844938.0  \n",
       "15        1885.0  \n",
       "16      711386.0  \n",
       "17      770559.0  \n",
       "18      680983.0  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ortalama = int(veri[\"Yıl\"].sum()/19)\n",
    "veri.fillna(value=ortalama)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c17151bb",
   "metadata": {},
   "source": [
    "### method Parametresi\n",
    "\n",
    "Veri çerçevesinde değer girilmemiş hücreleri (boşlukları) doldurmak, başka bir ifadeyle, değer atamak için `method` parametresi kullanılabilir.\n",
    "\n",
    "`method` parametresinin alabileceği değerler;\n",
    "* backfill\n",
    "* bfill\n",
    "* pad\n",
    "* ffill\n",
    "* None\n",
    "Varsayılan (öntanımlı) değer None'dır.\n",
    "\n",
    "Öncelikle Veri çerçevesi oluşturup inceleyelim;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "3cabf153",
   "metadata": {
    "scrolled": false
   },
   "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>isim</th>\n",
       "      <th>yaş</th>\n",
       "      <th>iş-meslek</th>\n",
       "      <th>kategori</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mustafa</td>\n",
       "      <td>25</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Halil</td>\n",
       "      <td>38</td>\n",
       "      <td>programcı</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Burak</td>\n",
       "      <td>41</td>\n",
       "      <td>akademisyen</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Emre</td>\n",
       "      <td>23</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ersin</td>\n",
       "      <td>37</td>\n",
       "      <td>amir</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sertaç</td>\n",
       "      <td>52</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Furkan</td>\n",
       "      <td>30</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Murat</td>\n",
       "      <td>23</td>\n",
       "      <td>müdür</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ahmet</td>\n",
       "      <td>40</td>\n",
       "      <td>veteriner</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Abdülkadir</td>\n",
       "      <td>38</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         isim  yaş    iş-meslek    kategori\n",
       "0     Mustafa   25     mühendis  Kategori_1\n",
       "1       Halil   38    programcı        None\n",
       "2       Burak   41  akademisyen  Kategori_3\n",
       "3        Emre   23     yönetici  Kategori_4\n",
       "4       Ersin   37         amir  Kategori_5\n",
       "5      Sertaç   52     mühendis        None\n",
       "6      Furkan   30     yönetici        None\n",
       "7       Murat   23        müdür  Kategori_8\n",
       "8       Ahmet   40    veteriner  Kategori_9\n",
       "9  Abdülkadir   38     yönetici        None"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sozluk = {\"isim\" : [\"Mustafa\", \"Halil\", \"Burak\", \"Emre\", \"Ersin\", \"Sertaç\", \"Furkan\",\"Murat\",\"Ahmet\",\"Abdülkadir\"],\n",
    "                    \"yaş\" : [25, 38, 41, 23, 37, 52, 30, 23, 40, 38],\n",
    "                   \"iş-meslek\" : [\"mühendis\", \"programcı\", \"akademisyen\", \"yönetici\",\"amir\",\"mühendis\", \"yönetici\",\"müdür\",\"veteriner\",\"yönetici\"],\n",
    "                     \"kategori\" : [\"Kategori_1\", None, \"Kategori_3\", \"Kategori_4\", \"Kategori_5\", None, None, \"Kategori_8\", \"Kategori_9\", None]}\n",
    "veri = pd.DataFrame(sozluk)\n",
    "veri"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f584ebfb",
   "metadata": {},
   "source": [
    "Veri çerçevesini incelediğimzde, Halil, Sertaç, Furkan ve Ahmet'in **kategori** bilgilerinin, geçerli değere sahip olmadığını görüyoruz. Bu değerleri `method` parametresinin seçeneklerini kullanarak doldurmaya çalışalım.\n",
    "\n",
    "Öncelikle **backfill** ve **bfill** seçeneklerini inceleyelim."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "bd62c5d3",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>isim</th>\n",
       "      <th>yaş</th>\n",
       "      <th>iş-meslek</th>\n",
       "      <th>kategori</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mustafa</td>\n",
       "      <td>25</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Halil</td>\n",
       "      <td>38</td>\n",
       "      <td>programcı</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Burak</td>\n",
       "      <td>41</td>\n",
       "      <td>akademisyen</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Emre</td>\n",
       "      <td>23</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ersin</td>\n",
       "      <td>37</td>\n",
       "      <td>amir</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sertaç</td>\n",
       "      <td>52</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Furkan</td>\n",
       "      <td>30</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Murat</td>\n",
       "      <td>23</td>\n",
       "      <td>müdür</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ahmet</td>\n",
       "      <td>40</td>\n",
       "      <td>veteriner</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Abdülkadir</td>\n",
       "      <td>38</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         isim  yaş    iş-meslek    kategori\n",
       "0     Mustafa   25     mühendis  Kategori_1\n",
       "1       Halil   38    programcı  Kategori_3\n",
       "2       Burak   41  akademisyen  Kategori_3\n",
       "3        Emre   23     yönetici  Kategori_4\n",
       "4       Ersin   37         amir  Kategori_5\n",
       "5      Sertaç   52     mühendis  Kategori_8\n",
       "6      Furkan   30     yönetici  Kategori_8\n",
       "7       Murat   23        müdür  Kategori_8\n",
       "8       Ahmet   40    veteriner  Kategori_9\n",
       "9  Abdülkadir   38     yönetici        None"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri = veri.fillna(method=\"backfill\")\n",
    "veri"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "e3536a5c",
   "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>isim</th>\n",
       "      <th>yaş</th>\n",
       "      <th>iş-meslek</th>\n",
       "      <th>kategori</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mustafa</td>\n",
       "      <td>25</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Halil</td>\n",
       "      <td>38</td>\n",
       "      <td>programcı</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Burak</td>\n",
       "      <td>41</td>\n",
       "      <td>akademisyen</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Emre</td>\n",
       "      <td>23</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ersin</td>\n",
       "      <td>37</td>\n",
       "      <td>amir</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sertaç</td>\n",
       "      <td>52</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Furkan</td>\n",
       "      <td>30</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Murat</td>\n",
       "      <td>23</td>\n",
       "      <td>müdür</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ahmet</td>\n",
       "      <td>40</td>\n",
       "      <td>veteriner</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Abdülkadir</td>\n",
       "      <td>38</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         isim  yaş    iş-meslek    kategori\n",
       "0     Mustafa   25     mühendis  Kategori_1\n",
       "1       Halil   38    programcı  Kategori_3\n",
       "2       Burak   41  akademisyen  Kategori_3\n",
       "3        Emre   23     yönetici  Kategori_4\n",
       "4       Ersin   37         amir  Kategori_5\n",
       "5      Sertaç   52     mühendis  Kategori_8\n",
       "6      Furkan   30     yönetici  Kategori_8\n",
       "7       Murat   23        müdür  Kategori_8\n",
       "8       Ahmet   40    veteriner  Kategori_9\n",
       "9  Abdülkadir   38     yönetici        None"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri = veri.fillna(method=\"bfill\")\n",
    "veri"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7abc90d9",
   "metadata": {},
   "source": [
    "Görüldüğü üzere, **backfill** ve **bfill** seçenekleri sayesinde boş (geçersiz değere sahip) hücreler, kendinden sonraki son geçerli (altında bulunan) hücrenin değeri ile dolduruldu.\n",
    "\n",
    "Şimdi sıra **pad** ve **ffill** seçeneklerinde;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "608f28a7",
   "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>isim</th>\n",
       "      <th>yaş</th>\n",
       "      <th>iş-meslek</th>\n",
       "      <th>kategori</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mustafa</td>\n",
       "      <td>25</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Halil</td>\n",
       "      <td>38</td>\n",
       "      <td>programcı</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Burak</td>\n",
       "      <td>41</td>\n",
       "      <td>akademisyen</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Emre</td>\n",
       "      <td>23</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ersin</td>\n",
       "      <td>37</td>\n",
       "      <td>amir</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sertaç</td>\n",
       "      <td>52</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Furkan</td>\n",
       "      <td>30</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Murat</td>\n",
       "      <td>23</td>\n",
       "      <td>müdür</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ahmet</td>\n",
       "      <td>40</td>\n",
       "      <td>veteriner</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Abdülkadir</td>\n",
       "      <td>38</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         isim  yaş    iş-meslek    kategori\n",
       "0     Mustafa   25     mühendis  Kategori_1\n",
       "1       Halil   38    programcı  Kategori_1\n",
       "2       Burak   41  akademisyen  Kategori_3\n",
       "3        Emre   23     yönetici  Kategori_4\n",
       "4       Ersin   37         amir  Kategori_5\n",
       "5      Sertaç   52     mühendis  Kategori_5\n",
       "6      Furkan   30     yönetici  Kategori_5\n",
       "7       Murat   23        müdür  Kategori_8\n",
       "8       Ahmet   40    veteriner  Kategori_9\n",
       "9  Abdülkadir   38     yönetici  Kategori_9"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri = veri.fillna(method=\"pad\")\n",
    "veri"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "a034af84",
   "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>isim</th>\n",
       "      <th>yaş</th>\n",
       "      <th>iş-meslek</th>\n",
       "      <th>kategori</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mustafa</td>\n",
       "      <td>25</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Halil</td>\n",
       "      <td>38</td>\n",
       "      <td>programcı</td>\n",
       "      <td>Kategori_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Burak</td>\n",
       "      <td>41</td>\n",
       "      <td>akademisyen</td>\n",
       "      <td>Kategori_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Emre</td>\n",
       "      <td>23</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ersin</td>\n",
       "      <td>37</td>\n",
       "      <td>amir</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Sertaç</td>\n",
       "      <td>52</td>\n",
       "      <td>mühendis</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Furkan</td>\n",
       "      <td>30</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Murat</td>\n",
       "      <td>23</td>\n",
       "      <td>müdür</td>\n",
       "      <td>Kategori_8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ahmet</td>\n",
       "      <td>40</td>\n",
       "      <td>veteriner</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Abdülkadir</td>\n",
       "      <td>38</td>\n",
       "      <td>yönetici</td>\n",
       "      <td>Kategori_9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         isim  yaş    iş-meslek    kategori\n",
       "0     Mustafa   25     mühendis  Kategori_1\n",
       "1       Halil   38    programcı  Kategori_1\n",
       "2       Burak   41  akademisyen  Kategori_3\n",
       "3        Emre   23     yönetici  Kategori_4\n",
       "4       Ersin   37         amir  Kategori_5\n",
       "5      Sertaç   52     mühendis  Kategori_5\n",
       "6      Furkan   30     yönetici  Kategori_5\n",
       "7       Murat   23        müdür  Kategori_8\n",
       "8       Ahmet   40    veteriner  Kategori_9\n",
       "9  Abdülkadir   38     yönetici  Kategori_9"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "veri = veri.fillna(method=\"ffill\")\n",
    "veri"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "34890320",
   "metadata": {},
   "source": [
    "**backfill** ve **bfill** seçeneklerinin tersine **pad** ve **ffill** seçenekleri ile sayesinde ise boş (geçersiz değere sahip) hücreler, kendinden önceki son geçerli (üstünde bulunan) hücrenin değeri ile dolduruldu."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}