Multilabel_Classification (with Konya agricultural data).ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "354e631c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from functools import reduce\n",
    "import glob\n",
    "import os\n",
    "\n",
    "pd.set_option('display.max_rows', None)\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b534a23b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import sklearn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "498eb0a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r'C:\\Users\\Dilemre\\GitHub\\donem\\data'                    \n",
    "all_files = glob.glob(os.path.join(path, \"*.csv\"))    \n",
    "dfList = [pd.read_csv(f,  sep=\";\", encoding='iso-8859-9', usecols=range(3),\n",
    "                      lineterminator='\\n', skip_blank_lines=True) for f in all_files]\n",
    "data = reduce(lambda x, y: pd.merge(x, y), dfList)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3d700a5a",
   "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>İLÇE ADI</th>\n",
       "      <th>MAHALLE ADI</th>\n",
       "      <th>ARICILIK\\r</th>\n",
       "      <th>BESLENEN HAYVAN TÜRLERİ\\r</th>\n",
       "      <th>SULAMA SUYU KAYNAĞI YÖNETİMİ\\r</th>\n",
       "      <th>HAYVAN BESLEMEDE KULLANILAN ÜRÜNLER\\r</th>\n",
       "      <th>SULANABİLİR ALANDA YETİŞTİRİLEN ÜRÜNLER\\r</th>\n",
       "      <th>TARIMSAL SULAMA SUYU KAYNAĞI\\r</th>\n",
       "      <th>İYİ TARIM UYGULAMALARI\\r</th>\n",
       "      <th>TARIMSAL SULAMA SUYU\\r</th>\n",
       "      <th>DOĞRUDAN SATIN ALINABİLECEK ÜRÜNLER\\r</th>\n",
       "      <th>SULAK ALAN MİKTARI\\r</th>\n",
       "      <th>MEŞHUR ÜRÜNLER\\r</th>\n",
       "      <th>EN ÇOK YETİŞTİRİLEN ÜRÜNLER\\r</th>\n",
       "      <th>TRAKTÖR SAYISI\\r</th>\n",
       "      <th>BİREYSEL ARAZİ ORTALAMASI\\r</th>\n",
       "      <th>ALTERNATİF YENİ ÜRÜN ÇEŞİTLERİ ÜRETİMİ\\r</th>\n",
       "      <th>ENDEMİK (SADECE BU BÖLGEDE YETİŞEN) BİTKİLER\\r</th>\n",
       "      <th>TALEP EDİLEN TARIMSAL EĞİTİMLER\\r</th>\n",
       "      <th>TIBBİ VE AROMATİK BİTKİ YETİŞTİRİCİLİĞİ\\r</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>HAYIR\\r</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>HAYIR\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE\\r</td>\n",
       "      <td>0%\\r</td>\n",
       "      <td>SÜT, PEYNİR\\r</td>\n",
       "      <td>BUĞDAY, ARPA, KİMYON\\r</td>\n",
       "      <td>75 Adet\\r</td>\n",
       "      <td>75 Dekar\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>KEKİK, ADA ÇAYI, KİMYON\\r</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>EVET\\r</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>BUĞDAY, ARPA, SAMAN, HAZIR YEM\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>HAYIR\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>BUĞDAY, ARPA, ANASON\\r</td>\n",
       "      <td>0%\\r</td>\n",
       "      <td>YOĞURT, PEYNİR\\r</td>\n",
       "      <td>BUĞDAY, ARPA\\r</td>\n",
       "      <td>55 Adet\\r</td>\n",
       "      <td>200 Dekar\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...</td>\n",
       "      <td>REZENE, KİMYON\\r</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>HAYIR\\r</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ\\r</td>\n",
       "      <td>ŞAHSİ KUYULAR\\r</td>\n",
       "      <td>YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM\\r</td>\n",
       "      <td>ŞEKER PANCARI, MISIR, FASULYE, DOMATES\\r</td>\n",
       "      <td>ŞAHSİ KUYULAR\\r</td>\n",
       "      <td>EVET\\r</td>\n",
       "      <td>VAR\\r</td>\n",
       "      <td>MISIR, BUĞDAY, DOMATES, ARPA, FASULYE\\r</td>\n",
       "      <td>50%\\r</td>\n",
       "      <td>SÜT, YAĞ, PEYNİR\\r</td>\n",
       "      <td>MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE\\r</td>\n",
       "      <td>35 Adet\\r</td>\n",
       "      <td>100 Dekar\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...</td>\n",
       "      <td>ANASON, KEKİK, KİMYON\\r</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>EVET\\r</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ\\r</td>\n",
       "      <td>ŞAHSİ KUYULAR\\r</td>\n",
       "      <td>BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM\\r</td>\n",
       "      <td>FASULYE\\r</td>\n",
       "      <td>YERALTI SULARI\\r</td>\n",
       "      <td>EVET\\r</td>\n",
       "      <td>VAR\\r</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE\\r</td>\n",
       "      <td>10%\\r</td>\n",
       "      <td>SÜT\\r</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE\\r</td>\n",
       "      <td>20 Adet\\r</td>\n",
       "      <td>200 Dekar\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>YOK\\r</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>ÇÖREKOTU\\r</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "      <td>\\r</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    İLÇE ADI MAHALLE ADI ARICILIK\\r BESLENEN HAYVAN TÜRLERİ\\r  \\\n",
       "358    Yunak      SEVİNÇ    HAYIR\\r      BÜYÜKBAŞ, KÜÇÜKBAŞ\\r   \n",
       "359    Yunak       SIRAM     EVET\\r      BÜYÜKBAŞ, KÜÇÜKBAŞ\\r   \n",
       "360    Yunak    YEŞİLOBA    HAYIR\\r      BÜYÜKBAŞ, KÜÇÜKBAŞ\\r   \n",
       "361    Yunak  YEŞİLYAYLA     EVET\\r      BÜYÜKBAŞ, KÜÇÜKBAŞ\\r   \n",
       "362      NaN         NaN         \\r                        \\r   \n",
       "\n",
       "    SULAMA SUYU KAYNAĞI YÖNETİMİ\\r     HAYVAN BESLEMEDE KULLANILAN ÜRÜNLER\\r  \\\n",
       "358                          YOK\\r   ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM\\r   \n",
       "359                          YOK\\r          BUĞDAY, ARPA, SAMAN, HAZIR YEM\\r   \n",
       "360                ŞAHSİ KUYULAR\\r  YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM\\r   \n",
       "361                ŞAHSİ KUYULAR\\r   BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM\\r   \n",
       "362                             \\r                                        \\r   \n",
       "\n",
       "    SULANABİLİR ALANDA YETİŞTİRİLEN ÜRÜNLER\\r TARIMSAL SULAMA SUYU KAYNAĞI\\r  \\\n",
       "358                                     YOK\\r                          YOK\\r   \n",
       "359                                     YOK\\r                          YOK\\r   \n",
       "360  ŞEKER PANCARI, MISIR, FASULYE, DOMATES\\r                ŞAHSİ KUYULAR\\r   \n",
       "361                                 FASULYE\\r               YERALTI SULARI\\r   \n",
       "362                                        \\r                             \\r   \n",
       "\n",
       "    İYİ TARIM UYGULAMALARI\\r TARIMSAL SULAMA SUYU\\r  \\\n",
       "358                  HAYIR\\r                  YOK\\r   \n",
       "359                  HAYIR\\r                  YOK\\r   \n",
       "360                   EVET\\r                  VAR\\r   \n",
       "361                   EVET\\r                  VAR\\r   \n",
       "362                       \\r                     \\r   \n",
       "\n",
       "              DOĞRUDAN SATIN ALINABİLECEK ÜRÜNLER\\r SULAK ALAN MİKTARI\\r  \\\n",
       "358  BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE\\r                 0%\\r   \n",
       "359                          BUĞDAY, ARPA, ANASON\\r                 0%\\r   \n",
       "360         MISIR, BUĞDAY, DOMATES, ARPA, FASULYE\\r                50%\\r   \n",
       "361                         BUĞDAY, ARPA, FASULYE\\r                10%\\r   \n",
       "362                                              \\r                   \\r   \n",
       "\n",
       "       MEŞHUR ÜRÜNLER\\r                  EN ÇOK YETİŞTİRİLEN ÜRÜNLER\\r  \\\n",
       "358       SÜT, PEYNİR\\r                         BUĞDAY, ARPA, KİMYON\\r   \n",
       "359    YOĞURT, PEYNİR\\r                                 BUĞDAY, ARPA\\r   \n",
       "360  SÜT, YAĞ, PEYNİR\\r  MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE\\r   \n",
       "361               SÜT\\r                        BUĞDAY, ARPA, FASULYE\\r   \n",
       "362                  \\r                                             \\r   \n",
       "\n",
       "    TRAKTÖR SAYISI\\r BİREYSEL ARAZİ ORTALAMASI\\r  \\\n",
       "358        75 Adet\\r                  75 Dekar\\r   \n",
       "359        55 Adet\\r                 200 Dekar\\r   \n",
       "360        35 Adet\\r                 100 Dekar\\r   \n",
       "361        20 Adet\\r                 200 Dekar\\r   \n",
       "362               \\r                          \\r   \n",
       "\n",
       "    ALTERNATİF YENİ ÜRÜN ÇEŞİTLERİ ÜRETİMİ\\r  \\\n",
       "358                                    YOK\\r   \n",
       "359                                    YOK\\r   \n",
       "360                                    YOK\\r   \n",
       "361                                    YOK\\r   \n",
       "362                                       \\r   \n",
       "\n",
       "    ENDEMİK (SADECE BU BÖLGEDE YETİŞEN) BİTKİLER\\r  \\\n",
       "358                                          YOK\\r   \n",
       "359                                          YOK\\r   \n",
       "360                                          YOK\\r   \n",
       "361                                          YOK\\r   \n",
       "362                                             \\r   \n",
       "\n",
       "                     TALEP EDİLEN TARIMSAL EĞİTİMLER\\r  \\\n",
       "358  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "359  MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...   \n",
       "360  MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...   \n",
       "361  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "362                                                 \\r   \n",
       "\n",
       "    TIBBİ VE AROMATİK BİTKİ YETİŞTİRİCİLİĞİ\\r  \n",
       "358                 KEKİK, ADA ÇAYI, KİMYON\\r  \n",
       "359                          REZENE, KİMYON\\r  \n",
       "360                   ANASON, KEKİK, KİMYON\\r  \n",
       "361                                ÇÖREKOTU\\r  \n",
       "362                                        \\r  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "8fd67ed4",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_csv(\"raw_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "2214c467",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.replace({'\\r':''}, regex=True)\n",
    "data = data.replace({' Adet':''}, regex=True)\n",
    "data = data.replace({' Dekar':''}, regex=True)\n",
    "data = data.replace({'%':''}, regex=True)\n",
    "data = data.replace({'': np.nan}, regex=True)\n",
    "\n",
    "data.columns = data.columns.str.replace('\\r', '')\n",
    "data.columns = data.columns.str.replace(' ', '_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "d219d8d9",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ</th>\n",
       "      <th>HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER</th>\n",
       "      <th>SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU_KAYNAĞI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>MEŞHUR_ÜRÜNLER</th>\n",
       "      <th>EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "      <th>ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ</th>\n",
       "      <th>ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER</th>\n",
       "      <th>TALEP_EDİLEN_TARIMSAL_EĞİTİMLER</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>YOK</td>\n",
       "      <td>ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>YOK</td>\n",
       "      <td>BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE</td>\n",
       "      <td>0</td>\n",
       "      <td>SÜT, PEYNİR</td>\n",
       "      <td>BUĞDAY, ARPA, KİMYON</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>KEKİK, ADA ÇAYI, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>EVET</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>YOK</td>\n",
       "      <td>BUĞDAY, ARPA, SAMAN, HAZIR YEM</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>YOK</td>\n",
       "      <td>BUĞDAY, ARPA, ANASON</td>\n",
       "      <td>0</td>\n",
       "      <td>YOĞURT, PEYNİR</td>\n",
       "      <td>BUĞDAY, ARPA</td>\n",
       "      <td>55</td>\n",
       "      <td>200</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...</td>\n",
       "      <td>REZENE, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM</td>\n",
       "      <td>ŞEKER PANCARI, MISIR, FASULYE, DOMATES</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>EVET</td>\n",
       "      <td>VAR</td>\n",
       "      <td>MISIR, BUĞDAY, DOMATES, ARPA, FASULYE</td>\n",
       "      <td>50</td>\n",
       "      <td>SÜT, YAĞ, PEYNİR</td>\n",
       "      <td>MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE</td>\n",
       "      <td>35</td>\n",
       "      <td>100</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...</td>\n",
       "      <td>ANASON, KEKİK, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>EVET</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM</td>\n",
       "      <td>FASULYE</td>\n",
       "      <td>YERALTI SULARI</td>\n",
       "      <td>EVET</td>\n",
       "      <td>VAR</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE</td>\n",
       "      <td>10</td>\n",
       "      <td>SÜT</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE</td>\n",
       "      <td>20</td>\n",
       "      <td>200</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>ÇÖREKOTU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    İLÇE_ADI MAHALLE_ADI ARICILIK BESLENEN_HAYVAN_TÜRLERİ  \\\n",
       "358    Yunak      SEVİNÇ    HAYIR      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "359    Yunak       SIRAM     EVET      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "360    Yunak    YEŞİLOBA    HAYIR      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "361    Yunak  YEŞİLYAYLA     EVET      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "362      NaN         NaN      NaN                     NaN   \n",
       "\n",
       "    SULAMA_SUYU_KAYNAĞI_YÖNETİMİ     HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER  \\\n",
       "358                          YOK   ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM   \n",
       "359                          YOK          BUĞDAY, ARPA, SAMAN, HAZIR YEM   \n",
       "360                ŞAHSİ KUYULAR  YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM   \n",
       "361                ŞAHSİ KUYULAR   BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM   \n",
       "362                          NaN                                     NaN   \n",
       "\n",
       "    SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER TARIMSAL_SULAMA_SUYU_KAYNAĞI  \\\n",
       "358                                     YOK                          YOK   \n",
       "359                                     YOK                          YOK   \n",
       "360  ŞEKER PANCARI, MISIR, FASULYE, DOMATES                ŞAHSİ KUYULAR   \n",
       "361                                 FASULYE               YERALTI SULARI   \n",
       "362                                     NaN                          NaN   \n",
       "\n",
       "    İYİ_TARIM_UYGULAMALARI TARIMSAL_SULAMA_SUYU  \\\n",
       "358                  HAYIR                  YOK   \n",
       "359                  HAYIR                  YOK   \n",
       "360                   EVET                  VAR   \n",
       "361                   EVET                  VAR   \n",
       "362                    NaN                  NaN   \n",
       "\n",
       "              DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER SULAK_ALAN_MİKTARI  \\\n",
       "358  BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE                  0   \n",
       "359                          BUĞDAY, ARPA, ANASON                  0   \n",
       "360         MISIR, BUĞDAY, DOMATES, ARPA, FASULYE                 50   \n",
       "361                         BUĞDAY, ARPA, FASULYE                 10   \n",
       "362                                           NaN                NaN   \n",
       "\n",
       "       MEŞHUR_ÜRÜNLER                  EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER  \\\n",
       "358       SÜT, PEYNİR                         BUĞDAY, ARPA, KİMYON   \n",
       "359    YOĞURT, PEYNİR                                 BUĞDAY, ARPA   \n",
       "360  SÜT, YAĞ, PEYNİR  MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE   \n",
       "361               SÜT                        BUĞDAY, ARPA, FASULYE   \n",
       "362               NaN                                          NaN   \n",
       "\n",
       "    TRAKTÖR_SAYISI BİREYSEL_ARAZİ_ORTALAMASI  \\\n",
       "358             75                        75   \n",
       "359             55                       200   \n",
       "360             35                       100   \n",
       "361             20                       200   \n",
       "362            NaN                       NaN   \n",
       "\n",
       "    ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ  \\\n",
       "358                                    YOK   \n",
       "359                                    YOK   \n",
       "360                                    YOK   \n",
       "361                                    YOK   \n",
       "362                                    NaN   \n",
       "\n",
       "    ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER  \\\n",
       "358                                          YOK   \n",
       "359                                          YOK   \n",
       "360                                          YOK   \n",
       "361                                          YOK   \n",
       "362                                          NaN   \n",
       "\n",
       "                       TALEP_EDİLEN_TARIMSAL_EĞİTİMLER  \\\n",
       "358  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "359  MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...   \n",
       "360  MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...   \n",
       "361  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "362                                                NaN   \n",
       "\n",
       "    TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ  \n",
       "358                 KEKİK, ADA ÇAYI, KİMYON  \n",
       "359                          REZENE, KİMYON  \n",
       "360                   ANASON, KEKİK, KİMYON  \n",
       "361                                ÇÖREKOTU  \n",
       "362                                     NaN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "85e409a4",
   "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>count</th>\n",
       "      <th>unique</th>\n",
       "      <th>top</th>\n",
       "      <th>freq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>İLÇE_ADI</th>\n",
       "      <td>362</td>\n",
       "      <td>30</td>\n",
       "      <td>Ilgın</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <td>362</td>\n",
       "      <td>346</td>\n",
       "      <td>ORHANİYE</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ARICILIK</th>\n",
       "      <td>360</td>\n",
       "      <td>2</td>\n",
       "      <td>EVET</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ</th>\n",
       "      <td>360</td>\n",
       "      <td>7</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ</th>\n",
       "      <td>360</td>\n",
       "      <td>10</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER</th>\n",
       "      <td>360</td>\n",
       "      <td>145</td>\n",
       "      <td>ARPA, HAZIR YEM</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <td>360</td>\n",
       "      <td>196</td>\n",
       "      <td>YOK</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TARIMSAL_SULAMA_SUYU_KAYNAĞI</th>\n",
       "      <td>360</td>\n",
       "      <td>38</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <td>359</td>\n",
       "      <td>2</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <td>359</td>\n",
       "      <td>2</td>\n",
       "      <td>VAR</td>\n",
       "      <td>314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER</th>\n",
       "      <td>362</td>\n",
       "      <td>260</td>\n",
       "      <td>BUĞDAY, ARPA</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <td>360</td>\n",
       "      <td>21</td>\n",
       "      <td>10</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEŞHUR_ÜRÜNLER</th>\n",
       "      <td>362</td>\n",
       "      <td>103</td>\n",
       "      <td>SÜT</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <td>361</td>\n",
       "      <td>204</td>\n",
       "      <td>BUĞDAY, ARPA</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <td>362</td>\n",
       "      <td>53</td>\n",
       "      <td>100</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "      <td>362</td>\n",
       "      <td>41</td>\n",
       "      <td>20</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ</th>\n",
       "      <td>360</td>\n",
       "      <td>84</td>\n",
       "      <td>YOK</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER</th>\n",
       "      <td>360</td>\n",
       "      <td>7</td>\n",
       "      <td>YOK</td>\n",
       "      <td>354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TALEP_EDİLEN_TARIMSAL_EĞİTİMLER</th>\n",
       "      <td>360</td>\n",
       "      <td>106</td>\n",
       "      <td>HAYVANCILIK</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ</th>\n",
       "      <td>360</td>\n",
       "      <td>63</td>\n",
       "      <td>YOK</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             count unique                 top  \\\n",
       "İLÇE_ADI                                       362     30               Ilgın   \n",
       "MAHALLE_ADI                                    362    346            ORHANİYE   \n",
       "ARICILIK                                       360      2                EVET   \n",
       "BESLENEN_HAYVAN_TÜRLERİ                        360      7  BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ                   360     10       ŞAHSİ KUYULAR   \n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER            360    145     ARPA, HAZIR YEM   \n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER        360    196                 YOK   \n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI                   360     38       ŞAHSİ KUYULAR   \n",
       "İYİ_TARIM_UYGULAMALARI                         359      2               HAYIR   \n",
       "TARIMSAL_SULAMA_SUYU                           359      2                 VAR   \n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER            362    260        BUĞDAY, ARPA   \n",
       "SULAK_ALAN_MİKTARI                             360     21                  10   \n",
       "MEŞHUR_ÜRÜNLER                                 362    103                 SÜT   \n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER                    361    204        BUĞDAY, ARPA   \n",
       "TRAKTÖR_SAYISI                                 362     53                 100   \n",
       "BİREYSEL_ARAZİ_ORTALAMASI                      362     41                  20   \n",
       "ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ         360     84                 YOK   \n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER   360      7                 YOK   \n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER                360    106         HAYVANCILIK   \n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ        360     63                 YOK   \n",
       "\n",
       "                                             freq  \n",
       "İLÇE_ADI                                       31  \n",
       "MAHALLE_ADI                                     3  \n",
       "ARICILIK                                      220  \n",
       "BESLENEN_HAYVAN_TÜRLERİ                       265  \n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ                  167  \n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER            17  \n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER        49  \n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI                   97  \n",
       "İYİ_TARIM_UYGULAMALARI                        331  \n",
       "TARIMSAL_SULAMA_SUYU                          314  \n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER            32  \n",
       "SULAK_ALAN_MİKTARI                             60  \n",
       "MEŞHUR_ÜRÜNLER                                 73  \n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER                    61  \n",
       "TRAKTÖR_SAYISI                                 25  \n",
       "BİREYSEL_ARAZİ_ORTALAMASI                      37  \n",
       "ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ        208  \n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER  354  \n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER                50  \n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ       198  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b99c05ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "İLÇE_ADI                                        1\n",
       "MAHALLE_ADI                                     1\n",
       "ARICILIK                                        3\n",
       "BESLENEN_HAYVAN_TÜRLERİ                         3\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ                    3\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER             3\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER         3\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI                    3\n",
       "İYİ_TARIM_UYGULAMALARI                          4\n",
       "TARIMSAL_SULAMA_SUYU                            4\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER             1\n",
       "SULAK_ALAN_MİKTARI                              3\n",
       "MEŞHUR_ÜRÜNLER                                  1\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER                     2\n",
       "TRAKTÖR_SAYISI                                  1\n",
       "BİREYSEL_ARAZİ_ORTALAMASI                       1\n",
       "ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ          3\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER    3\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER                 3\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ         3\n",
       "dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "c0313b65",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ</th>\n",
       "      <th>HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER</th>\n",
       "      <th>SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU_KAYNAĞI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>MEŞHUR_ÜRÜNLER</th>\n",
       "      <th>EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "      <th>ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ</th>\n",
       "      <th>ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER</th>\n",
       "      <th>TALEP_EDİLEN_TARIMSAL_EĞİTİMLER</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>Selçuklu</td>\n",
       "      <td>BAŞARAKAVAK</td>\n",
       "      <td>EVET</td>\n",
       "      <td>KÜÇÜKBAŞ</td>\n",
       "      <td>SULAMA KOOPERATİFİ</td>\n",
       "      <td>ARPA, YONCA, HAZIR YEM</td>\n",
       "      <td>NOHUT, DOMATES, BİBER, PATLICAN, PATATES, SOĞAN</td>\n",
       "      <td>AKARSU</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUĞDAY, ELMA, DOMATES, CEVİZ, FASULYE</td>\n",
       "      <td>30</td>\n",
       "      <td>BAL</td>\n",
       "      <td>PATATES, NOHUT, FASULYE</td>\n",
       "      <td>100</td>\n",
       "      <td>60</td>\n",
       "      <td>ŞEKER PANCARI, ÜZÜM</td>\n",
       "      <td>YOK, KONGUR</td>\n",
       "      <td>HAYVANCILIK</td>\n",
       "      <td>NANE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>Selçuklu</td>\n",
       "      <td>hasan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASPİR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BAL, CANLI HAYVAN</td>\n",
       "      <td>BEYAZ KİRAZ</td>\n",
       "      <td>Adet</td>\n",
       "      <td>Dekar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>Selçuklu</td>\n",
       "      <td>Mehmet Fatih</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PATATES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Adet</td>\n",
       "      <td>Dekar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     İLÇE_ADI   MAHALLE_ADI ARICILIK BESLENEN_HAYVAN_TÜRLERİ  \\\n",
       "287  Selçuklu   BAŞARAKAVAK     EVET                KÜÇÜKBAŞ   \n",
       "288  Selçuklu         hasan      NaN                     NaN   \n",
       "309  Selçuklu  Mehmet Fatih      NaN                     NaN   \n",
       "362       NaN           NaN      NaN                     NaN   \n",
       "\n",
       "    SULAMA_SUYU_KAYNAĞI_YÖNETİMİ HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER  \\\n",
       "287           SULAMA KOOPERATİFİ              ARPA, YONCA, HAZIR YEM   \n",
       "288                          NaN                                 NaN   \n",
       "309                          NaN                                 NaN   \n",
       "362                          NaN                                 NaN   \n",
       "\n",
       "             SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER  \\\n",
       "287  NOHUT, DOMATES, BİBER, PATLICAN, PATATES, SOĞAN   \n",
       "288                                              NaN   \n",
       "309                                              NaN   \n",
       "362                                              NaN   \n",
       "\n",
       "    TARIMSAL_SULAMA_SUYU_KAYNAĞI İYİ_TARIM_UYGULAMALARI TARIMSAL_SULAMA_SUYU  \\\n",
       "287                       AKARSU                    NaN                  NaN   \n",
       "288                          NaN                    NaN                  NaN   \n",
       "309                          NaN                    NaN                  NaN   \n",
       "362                          NaN                    NaN                  NaN   \n",
       "\n",
       "       DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER SULAK_ALAN_MİKTARI  \\\n",
       "287  BUĞDAY, ELMA, DOMATES, CEVİZ, FASULYE                 30   \n",
       "288                                  ASPİR                NaN   \n",
       "309                                PATATES                NaN   \n",
       "362                                    NaN                NaN   \n",
       "\n",
       "        MEŞHUR_ÜRÜNLER EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER TRAKTÖR_SAYISI  \\\n",
       "287                BAL     PATATES, NOHUT, FASULYE            100   \n",
       "288  BAL, CANLI HAYVAN                 BEYAZ KİRAZ           Adet   \n",
       "309                BAL                         NaN           Adet   \n",
       "362                NaN                         NaN            NaN   \n",
       "\n",
       "    BİREYSEL_ARAZİ_ORTALAMASI ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ  \\\n",
       "287                        60                    ŞEKER PANCARI, ÜZÜM   \n",
       "288                     Dekar                                    NaN   \n",
       "309                     Dekar                                    NaN   \n",
       "362                       NaN                                    NaN   \n",
       "\n",
       "    ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER  \\\n",
       "287                                  YOK, KONGUR   \n",
       "288                                          NaN   \n",
       "309                                          NaN   \n",
       "362                                          NaN   \n",
       "\n",
       "    TALEP_EDİLEN_TARIMSAL_EĞİTİMLER TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ  \n",
       "287                     HAYVANCILIK                                    NANE  \n",
       "288                             NaN                                     NaN  \n",
       "309                             NaN                                     NaN  \n",
       "362                             NaN                                     NaN  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dropped_rows = data[data.isna().any(axis=1)]\n",
    "dropped_rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "68dad8cb",
   "metadata": {},
   "outputs": [],
   "source": [
    "dropped_rows.to_csv(\"dropped_rows.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "8358dea0",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.dropna().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "18bf0524",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index                                           0\n",
       "İLÇE_ADI                                        0\n",
       "MAHALLE_ADI                                     0\n",
       "ARICILIK                                        0\n",
       "BESLENEN_HAYVAN_TÜRLERİ                         0\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ                    0\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER             0\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER         0\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI                    0\n",
       "İYİ_TARIM_UYGULAMALARI                          0\n",
       "TARIMSAL_SULAMA_SUYU                            0\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER             0\n",
       "SULAK_ALAN_MİKTARI                              0\n",
       "MEŞHUR_ÜRÜNLER                                  0\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER                     0\n",
       "TRAKTÖR_SAYISI                                  0\n",
       "BİREYSEL_ARAZİ_ORTALAMASI                       0\n",
       "ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ          0\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER    0\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER                 0\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ         0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "cac38859",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ</th>\n",
       "      <th>HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER</th>\n",
       "      <th>SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU_KAYNAĞI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>...</th>\n",
       "      <th>DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>MEŞHUR_ÜRÜNLER</th>\n",
       "      <th>EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "      <th>ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ</th>\n",
       "      <th>ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER</th>\n",
       "      <th>TALEP_EDİLEN_TARIMSAL_EĞİTİMLER</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>357</td>\n",
       "      <td>Yunak</td>\n",
       "      <td>SERTLER</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>ARPA, SAMAN, YONCA, SİLAJLIK MISIR, HAZIR YEM</td>\n",
       "      <td>ŞEKER PANCARI</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>EVET</td>\n",
       "      <td>...</td>\n",
       "      <td>MISIR, ŞEKER PANCARI, BUĞDAY, ARPA, KİMYON</td>\n",
       "      <td>20</td>\n",
       "      <td>SÜT, YOĞURT, PEYNİR</td>\n",
       "      <td>BUĞDAY, ARPA, KİMYON, ŞEKER PANCARI</td>\n",
       "      <td>15</td>\n",
       "      <td>60</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, KIRSALDAN KENTE GÜVE...</td>\n",
       "      <td>KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>358</td>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>YOK</td>\n",
       "      <td>ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>...</td>\n",
       "      <td>BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE</td>\n",
       "      <td>0</td>\n",
       "      <td>SÜT, PEYNİR</td>\n",
       "      <td>BUĞDAY, ARPA, KİMYON</td>\n",
       "      <td>75</td>\n",
       "      <td>75</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>KEKİK, ADA ÇAYI, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>359</td>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>EVET</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>YOK</td>\n",
       "      <td>BUĞDAY, ARPA, SAMAN, HAZIR YEM</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>...</td>\n",
       "      <td>BUĞDAY, ARPA, ANASON</td>\n",
       "      <td>0</td>\n",
       "      <td>YOĞURT, PEYNİR</td>\n",
       "      <td>BUĞDAY, ARPA</td>\n",
       "      <td>55</td>\n",
       "      <td>200</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...</td>\n",
       "      <td>REZENE, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>360</td>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM</td>\n",
       "      <td>ŞEKER PANCARI, MISIR, FASULYE, DOMATES</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>EVET</td>\n",
       "      <td>...</td>\n",
       "      <td>MISIR, BUĞDAY, DOMATES, ARPA, FASULYE</td>\n",
       "      <td>50</td>\n",
       "      <td>SÜT, YAĞ, PEYNİR</td>\n",
       "      <td>MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE</td>\n",
       "      <td>35</td>\n",
       "      <td>100</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...</td>\n",
       "      <td>ANASON, KEKİK, KİMYON</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>361</td>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>EVET</td>\n",
       "      <td>BÜYÜKBAŞ, KÜÇÜKBAŞ</td>\n",
       "      <td>ŞAHSİ KUYULAR</td>\n",
       "      <td>BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM</td>\n",
       "      <td>FASULYE</td>\n",
       "      <td>YERALTI SULARI</td>\n",
       "      <td>EVET</td>\n",
       "      <td>...</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE</td>\n",
       "      <td>10</td>\n",
       "      <td>SÜT</td>\n",
       "      <td>BUĞDAY, ARPA, FASULYE</td>\n",
       "      <td>20</td>\n",
       "      <td>200</td>\n",
       "      <td>YOK</td>\n",
       "      <td>YOK</td>\n",
       "      <td>MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...</td>\n",
       "      <td>ÇÖREKOTU</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index İLÇE_ADI MAHALLE_ADI ARICILIK BESLENEN_HAYVAN_TÜRLERİ  \\\n",
       "354    357    Yunak     SERTLER    HAYIR      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "355    358    Yunak      SEVİNÇ    HAYIR      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "356    359    Yunak       SIRAM     EVET      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "357    360    Yunak    YEŞİLOBA    HAYIR      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "358    361    Yunak  YEŞİLYAYLA     EVET      BÜYÜKBAŞ, KÜÇÜKBAŞ   \n",
       "\n",
       "    SULAMA_SUYU_KAYNAĞI_YÖNETİMİ  \\\n",
       "354                ŞAHSİ KUYULAR   \n",
       "355                          YOK   \n",
       "356                          YOK   \n",
       "357                ŞAHSİ KUYULAR   \n",
       "358                ŞAHSİ KUYULAR   \n",
       "\n",
       "               HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER  \\\n",
       "354  ARPA, SAMAN, YONCA, SİLAJLIK MISIR, HAZIR YEM   \n",
       "355          ARPA, ÇAVDAR, SAMAN, YONCA, HAZIR YEM   \n",
       "356                 BUĞDAY, ARPA, SAMAN, HAZIR YEM   \n",
       "357         YULAF, ARPA, SİLAJLIK MISIR, HAZIR YEM   \n",
       "358          BUĞDAY, KÜSPE, ARPA, SAMAN, HAZIR YEM   \n",
       "\n",
       "    SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER TARIMSAL_SULAMA_SUYU_KAYNAĞI  \\\n",
       "354                           ŞEKER PANCARI                ŞAHSİ KUYULAR   \n",
       "355                                     YOK                          YOK   \n",
       "356                                     YOK                          YOK   \n",
       "357  ŞEKER PANCARI, MISIR, FASULYE, DOMATES                ŞAHSİ KUYULAR   \n",
       "358                                 FASULYE               YERALTI SULARI   \n",
       "\n",
       "    İYİ_TARIM_UYGULAMALARI  ...           DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER  \\\n",
       "354                   EVET  ...    MISIR, ŞEKER PANCARI, BUĞDAY, ARPA, KİMYON   \n",
       "355                  HAYIR  ...  BUĞDAY, ARPA, KİRAZ, MERCİMEK, KİMYON, VİŞNE   \n",
       "356                  HAYIR  ...                          BUĞDAY, ARPA, ANASON   \n",
       "357                   EVET  ...         MISIR, BUĞDAY, DOMATES, ARPA, FASULYE   \n",
       "358                   EVET  ...                         BUĞDAY, ARPA, FASULYE   \n",
       "\n",
       "    SULAK_ALAN_MİKTARI       MEŞHUR_ÜRÜNLER  \\\n",
       "354                 20  SÜT, YOĞURT, PEYNİR   \n",
       "355                  0          SÜT, PEYNİR   \n",
       "356                  0       YOĞURT, PEYNİR   \n",
       "357                 50     SÜT, YAĞ, PEYNİR   \n",
       "358                 10                  SÜT   \n",
       "\n",
       "                     EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER TRAKTÖR_SAYISI  \\\n",
       "354          BUĞDAY, ARPA, KİMYON, ŞEKER PANCARI             15   \n",
       "355                         BUĞDAY, ARPA, KİMYON             75   \n",
       "356                                 BUĞDAY, ARPA             55   \n",
       "357  MISIR, BUĞDAY, ARPA, ŞEKER PANCARI, FASULYE             35   \n",
       "358                        BUĞDAY, ARPA, FASULYE             20   \n",
       "\n",
       "    BİREYSEL_ARAZİ_ORTALAMASI ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ  \\\n",
       "354                        60                                    YOK   \n",
       "355                        75                                    YOK   \n",
       "356                       200                                    YOK   \n",
       "357                       100                                    YOK   \n",
       "358                       200                                    YOK   \n",
       "\n",
       "    ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER  \\\n",
       "354                                          YOK   \n",
       "355                                          YOK   \n",
       "356                                          YOK   \n",
       "357                                          YOK   \n",
       "358                                          YOK   \n",
       "\n",
       "                       TALEP_EDİLEN_TARIMSAL_EĞİTİMLER  \\\n",
       "354  MODERN SULAMA SİSTEMLERİ, KIRSALDAN KENTE GÜVE...   \n",
       "355  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "356  MODERN SULAMA SİSTEMLERİ, TARLA BİTKİLERİ YETİ...   \n",
       "357  MODERN SULAMA SİSTEMLERİ, MODERN MEYVECİLİK, H...   \n",
       "358  MODERN SULAMA SİSTEMLERİ, HAYVANCILIK, TIBBİ V...   \n",
       "\n",
       "    TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ  \n",
       "354                                  KİMYON  \n",
       "355                 KEKİK, ADA ÇAYI, KİMYON  \n",
       "356                          REZENE, KİMYON  \n",
       "357                   ANASON, KEKİK, KİMYON  \n",
       "358                                ÇÖREKOTU  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "eb748310",
   "metadata": {},
   "outputs": [],
   "source": [
    "convert_list = [\"BESLENEN_HAYVAN_TÜRLERİ\", \"SULAMA_SUYU_KAYNAĞI_YÖNETİMİ\", \"HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER\",\n",
    "                \"SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER\", \"TARIMSAL_SULAMA_SUYU_KAYNAĞI\", \n",
    "                \"DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER\", \"MEŞHUR_ÜRÜNLER\", \"EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER\", \n",
    "                \"ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER\", \"TALEP_EDİLEN_TARIMSAL_EĞİTİMLER\", \n",
    "                \"TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ\"]\n",
    "\n",
    "other_list = [\"İLÇE_ADI\", \"MAHALLE_ADI\", \"ARICILIK\", \"TARIMSAL_SULAMA_SUYU\", \"SULAK_ALAN_MİKTARI\", \"TRAKTÖR_SAYISI\", \n",
    "              \"İYİ_TARIM_UYGULAMALARI\", \"BİREYSEL_ARAZİ_ORTALAMASI\"]\n",
    "\n",
    "new = data.loc[:, (\"İLÇE_ADI\", \"MAHALLE_ADI\")].copy().astype('category')\n",
    "\n",
    "for colm in convert_list:\n",
    "    temp = np.unique(', '.join(data[colm]).split(', '))\n",
    "    \n",
    "    for ctgr in temp:\n",
    "        new[colm+\"_\"+ctgr] = data[colm].str.contains(ctgr).astype('int')\n",
    "        \n",
    "new = pd.merge(new, data[other_list])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "de02494e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                                                  [YOK]\n",
       "1                                                  [YOK]\n",
       "2                                                  [YOK]\n",
       "3                                                  [YOK]\n",
       "4                                                  [YOK]\n",
       "5                                                [ASPİR]\n",
       "6                             [KİNOA,  ASPİR,  ÇÖREKOTU]\n",
       "7                                                  [YOK]\n",
       "8                                                  [YOK]\n",
       "9                                                [ÇİLEK]\n",
       "10                                       [MISIR,  ASPİR]\n",
       "11                                                 [YOK]\n",
       "12                                    [SARIMSAK,  ASPİR]\n",
       "13                                                 [YOK]\n",
       "14                                                 [YOK]\n",
       "15                                               [ASPİR]\n",
       "16                                                 [YOK]\n",
       "17                                                 [YOK]\n",
       "18                                                 [YOK]\n",
       "19                                                 [YOK]\n",
       "20                                                 [YOK]\n",
       "21                                                 [YOK]\n",
       "22                                                 [YOK]\n",
       "23                                               [ASPİR]\n",
       "24                                                 [YOK]\n",
       "25                                                 [YOK]\n",
       "26                                                 [YOK]\n",
       "27                            [SİLAJLIK MISIR,  FASULYE]\n",
       "28                                      [KANOLA,  ASPİR]\n",
       "29                                                 [YOK]\n",
       "30                   [SİLAJLIK MISIR,  KİNOA,  ÇÖREKOTU]\n",
       "31                                                 [YOK]\n",
       "32                                                 [YOK]\n",
       "33                                       [ŞEKER PANCARI]\n",
       "34                                                 [YOK]\n",
       "35                                                 [YOK]\n",
       "36                                    [KANOLA,  LAVANTA]\n",
       "37                      [SİLAJLIK MISIR,  FİĞ,  KORUNGA]\n",
       "38                                                 [YOK]\n",
       "39                                      [KANOLA,  ASPİR]\n",
       "40                                             [BEZELYE]\n",
       "41                                                 [YOK]\n",
       "42                                                 [YOK]\n",
       "43                                                 [YOK]\n",
       "44                                               [ASPİR]\n",
       "45                                        [ÜZÜM,  CEVİZ]\n",
       "46                                    [MERCİMEK,  ASPİR]\n",
       "47                                                 [YOK]\n",
       "48                                               [ASPİR]\n",
       "49                                                 [YOK]\n",
       "50                                     [BEZELYE,  ASPİR]\n",
       "51                                                 [YOK]\n",
       "52                                                 [YOK]\n",
       "53                                                 [YOK]\n",
       "54                                               [ASPİR]\n",
       "55            [SARIMSAK,  AHUDUDU,  BÖĞÜRTLEN,  KORUNGA]\n",
       "56                                                 [YOK]\n",
       "57                                                 [YOK]\n",
       "58                                                 [YOK]\n",
       "59                                                 [YOK]\n",
       "60                                                 [YOK]\n",
       "61                                       [CEVİZ,  BADEM]\n",
       "62                                                 [YOK]\n",
       "63                                                 [YOK]\n",
       "64                                  [GOJİ BERRY,  ÇİLEK]\n",
       "65                                                 [YOK]\n",
       "66                                               [KİRAZ]\n",
       "67                                                 [YOK]\n",
       "68                                                 [YOK]\n",
       "69                                               [ÇİLEK]\n",
       "70                                     [ÇİLEK,  AHUDUDU]\n",
       "71                                               [ÇİLEK]\n",
       "72                                                 [YOK]\n",
       "73                                                 [YOK]\n",
       "74                                                 [YOK]\n",
       "75                                              [REZENE]\n",
       "76                                               [ASPİR]\n",
       "77                                     [REZENE,  KANOLA]\n",
       "78                                              [KANOLA]\n",
       "79                                              [REZENE]\n",
       "80                                                 [YOK]\n",
       "81                                                 [YOK]\n",
       "82                                               [ÇİLEK]\n",
       "83                                               [ASPİR]\n",
       "84                                                 [YOK]\n",
       "85                                                 [YOK]\n",
       "86                                                 [YOK]\n",
       "87                                                 [YOK]\n",
       "88                                            [AYÇİÇEĞİ]\n",
       "89                                      [KANOLA,  ASPİR]\n",
       "90                                               [ASPİR]\n",
       "91                                               [ASPİR]\n",
       "92                                               [ASPİR]\n",
       "93                                                 [YOK]\n",
       "94                                                 [YOK]\n",
       "95                                                 [YOK]\n",
       "96                                      [ANASON,  ASPİR]\n",
       "97                                               [ASPİR]\n",
       "98                                      [KANOLA,  ASPİR]\n",
       "99                                      [KANOLA,  ASPİR]\n",
       "100                                                [YOK]\n",
       "101                                                [YOK]\n",
       "102                                              [ASPİR]\n",
       "103                                     [KANOLA,  ASPİR]\n",
       "104                                                [YOK]\n",
       "105                                           [MERCİMEK]\n",
       "106                                     [FİĞ,  AYÇİÇEĞİ]\n",
       "107                                             [KANOLA]\n",
       "108                                           [AYÇİÇEĞİ]\n",
       "109                                                [YOK]\n",
       "110                                       [FİĞ,  KANOLA]\n",
       "111                                                [YOK]\n",
       "112                                                [YOK]\n",
       "113                                                [YOK]\n",
       "114                                                [YOK]\n",
       "115                                                [YOK]\n",
       "116                                        [FİĞ,  ÇİLEK]\n",
       "117                                  [ÇİLEK,  BÖĞÜRTLEN]\n",
       "118                                                [YOK]\n",
       "119                                                [YOK]\n",
       "120                                              [KİNOA]\n",
       "121                                              [ASPİR]\n",
       "122                                   [AYÇİÇEĞİ,  ASPİR]\n",
       "123                                     [KÜLTÜR MANTARI]\n",
       "124                                          [TRİTİKALE]\n",
       "125                                                [YOK]\n",
       "126                                                [YOK]\n",
       "127                                                [YOK]\n",
       "128                                                [YOK]\n",
       "129                                                [YOK]\n",
       "130                                                [YOK]\n",
       "131                                                [YOK]\n",
       "132                                                [YOK]\n",
       "133                                                [YOK]\n",
       "134                                                [YOK]\n",
       "135                                                [YOK]\n",
       "136                                                [YOK]\n",
       "137                                                [YOK]\n",
       "138                                                [YOK]\n",
       "139                                                [YOK]\n",
       "140                                        [ALTIN ÇİLEK]\n",
       "141                                     [SİLAJLIK MISIR]\n",
       "142                                       [JAPON ARMUDU]\n",
       "143                                                [YOK]\n",
       "144                                                [YOK]\n",
       "145                                                [YOK]\n",
       "146                                                [YOK]\n",
       "147                                 [FASULYE,  ÇÖREKOTU]\n",
       "148                                                [YOK]\n",
       "149                                              [ÇİLEK]\n",
       "150                                                [YOK]\n",
       "151                                              [CEVİZ]\n",
       "152                                                [YOK]\n",
       "153                                              [ÇİLEK]\n",
       "154                                              [ÇİLEK]\n",
       "155                                                [YOK]\n",
       "156                     [SARIMSAK,  AYÇİÇEĞİ,  ÇÖREKOTU]\n",
       "157                                                [YOK]\n",
       "158                                                [YOK]\n",
       "159                                                [YOK]\n",
       "160                                                [YOK]\n",
       "161                                                [YOK]\n",
       "162                                                [YOK]\n",
       "163                                                [YOK]\n",
       "164                                                [YOK]\n",
       "165                                                [YOK]\n",
       "166                                                [YOK]\n",
       "167                                         [GOJİ BERRY]\n",
       "168                                         [GOJİ BERRY]\n",
       "169                                                [YOK]\n",
       "170                                              [CEVİZ]\n",
       "171                                                [YOK]\n",
       "172                                                [YOK]\n",
       "173                                                [YOK]\n",
       "174                                                [YOK]\n",
       "175                                                [YOK]\n",
       "176                                                [YOK]\n",
       "177                                                [YOK]\n",
       "178                                              [ÇİLEK]\n",
       "179                                                [YOK]\n",
       "180                                      [MISIR,  ÇİLEK]\n",
       "181                      [FASULYE,  AHUDUDU,  BÖĞÜRTLEN]\n",
       "182                                              [CEVİZ]\n",
       "183                                                [YOK]\n",
       "184                                               [ÜZÜM]\n",
       "185                                              [ÇİLEK]\n",
       "186                                            [AHUDUDU]\n",
       "187        [MERCİMEK,  ÇİLEK,  KANOLA,  AHUDUDU,  ASPİR]\n",
       "188                                     [LAVANTA,  LALE]\n",
       "189                                     [CEVİZ,  KANOLA]\n",
       "190                                              [CEVİZ]\n",
       "191                                                [YOK]\n",
       "192                     [SİLAJLIK MISIR,  ÇİLEK,  YONCA]\n",
       "193                                                [YOK]\n",
       "194                                                [YOK]\n",
       "195                                [AHUDUDU,  BÖĞÜRTLEN]\n",
       "196                                           [ÇÖREKOTU]\n",
       "197        [PATATES,  ASPİR,  ÇÖREKOTU,  ÇEREZLİK KABAK]\n",
       "198                               [SİLAJLIK MISIR,  FİĞ]\n",
       "199                                                [YOK]\n",
       "200                                                [YOK]\n",
       "201                                      [CEVİZ,  VİŞNE]\n",
       "202                                      [ŞEKER PANCARI]\n",
       "203                                                [YOK]\n",
       "204                                             [KİMYON]\n",
       "205                                     [KİMYON,  ASPİR]\n",
       "206                                                [YOK]\n",
       "207                                                [YOK]\n",
       "208                                   [AYÇİÇEĞİ,  ASPİR]\n",
       "209                                                [YOK]\n",
       "210                                              [ÇİLEK]\n",
       "211                                          [TRİTİKALE]\n",
       "212                                              [ÇİLEK]\n",
       "213                                                [YOK]\n",
       "214                                   [MERCİMEK,  ASPİR]\n",
       "215                                           [ÇÖREKOTU]\n",
       "216                                           [AYÇİÇEĞİ]\n",
       "217                             [FİĞ,  ASPİR,  ÇÖREKOTU]\n",
       "218                                                [YOK]\n",
       "219                                     [FİĞ,  ÇÖREKOTU]\n",
       "220                                                [YOK]\n",
       "221                                                [YOK]\n",
       "222                                              [BADEM]\n",
       "223                                  [PATATES,  FASULYE]\n",
       "224                                                [YOK]\n",
       "225                                                [YOK]\n",
       "226                [KİRAZ,  AHUDUDU,  ASPİR,  BÖĞÜRTLEN]\n",
       "227                                                [YOK]\n",
       "228                                                [YOK]\n",
       "229                                                [YOK]\n",
       "230                                                [YOK]\n",
       "231                                                [YOK]\n",
       "232                                                [YOK]\n",
       "233                                                [YOK]\n",
       "234                                                [YOK]\n",
       "235                                                [YOK]\n",
       "236                                                [YOK]\n",
       "237                                                [YOK]\n",
       "238                                                [YOK]\n",
       "239                                                [YOK]\n",
       "240                                                [YOK]\n",
       "241                                                [YOK]\n",
       "242                                                [YOK]\n",
       "243                                                [YOK]\n",
       "244                                             [KANOLA]\n",
       "245                                                [YOK]\n",
       "246                                                [YOK]\n",
       "247                                   [PATATES,  KANOLA]\n",
       "248                                                [YOK]\n",
       "249                                     [SİLAJLIK MISIR]\n",
       "250                                             [KANOLA]\n",
       "251                                                [YOK]\n",
       "252                                                [YOK]\n",
       "253                                             [KANOLA]\n",
       "254                                           [SARIMSAK]\n",
       "255                                                [YOK]\n",
       "256                                   [ASPİR,  ÇÖREKOTU]\n",
       "257                                    [BEZELYE,  ASPİR]\n",
       "258                                                [YOK]\n",
       "259                                                [YOK]\n",
       "260                                                [YOK]\n",
       "261                        [MISIR,  AYÇİÇEĞİ,  ÇÖREKOTU]\n",
       "262                                           [ÇÖREKOTU]\n",
       "263    [AHUDUDU,  SUSAM,  ALTIN ÇİLEK,  BÖĞÜRTLEN,  Ç...\n",
       "264                                                [YOK]\n",
       "265                      [KİMYON,  BÖĞÜRTLEN,  ÇÖREKOTU]\n",
       "266                              [GOJİ BERRY,  BARBUNYA]\n",
       "267                                          [BÖĞÜRTLEN]\n",
       "268                                     [SİLAJLIK MISIR]\n",
       "269                                                [YOK]\n",
       "270                                                [YOK]\n",
       "271                                              [ÇİLEK]\n",
       "272                                                [YOK]\n",
       "273                                              [ÇİLEK]\n",
       "274                                              [ÇİLEK]\n",
       "275                                              [ASPİR]\n",
       "276                          [KİNOA,  ANASON,  ÇÖREKOTU]\n",
       "277                                                [YOK]\n",
       "278                        [AYÇİÇEĞİ,  ASPİR,  ÇÖREKOTU]\n",
       "279                                                [YOK]\n",
       "280                                                [YOK]\n",
       "281                                                [YOK]\n",
       "282                                              [ASPİR]\n",
       "283                                                [YOK]\n",
       "284                                                [YOK]\n",
       "285                                                [YOK]\n",
       "286                                                [YOK]\n",
       "287                                               [ÜZÜM]\n",
       "288                                                [YOK]\n",
       "289                                                [YOK]\n",
       "290                                                [YOK]\n",
       "291                                                [YOK]\n",
       "292                                                [FİĞ]\n",
       "293                                                [YOK]\n",
       "294                                                [YOK]\n",
       "295                                                [YOK]\n",
       "296                                                [YOK]\n",
       "297                                                [YOK]\n",
       "298                                                [YOK]\n",
       "299                                                [YOK]\n",
       "300                                                [YOK]\n",
       "301                                                [YOK]\n",
       "302                                              [ASPİR]\n",
       "303                                             [KANOLA]\n",
       "304                                                [YOK]\n",
       "305                                                [YOK]\n",
       "306                                           [MERCİMEK]\n",
       "307                                                [YOK]\n",
       "308                                                [YOK]\n",
       "309            [ŞEKER PANCARI,  HAŞHAŞ,  ÇEREZLİK KABAK]\n",
       "310                                                [YOK]\n",
       "311                                              [ÇİLEK]\n",
       "312                                              [ÇİLEK]\n",
       "313                                              [ÇİLEK]\n",
       "314                                          [BÖĞÜRTLEN]\n",
       "315                              [CEVİZ,  KİRAZ,  ÇİLEK]\n",
       "316                                                [YOK]\n",
       "317                                                [YOK]\n",
       "318                                                [YOK]\n",
       "319                                                [YOK]\n",
       "320                                                [YOK]\n",
       "321                   [GOJİ BERRY,  AHUDUDU,  BÖĞÜRTLEN]\n",
       "322                                              [ÇİLEK]\n",
       "323                                              [ÇİLEK]\n",
       "324                                                [YOK]\n",
       "325                                              [ÇİLEK]\n",
       "326                                                [YOK]\n",
       "327                                                [YOK]\n",
       "328                                                [YOK]\n",
       "329                                                [YOK]\n",
       "330                                                [YOK]\n",
       "331                                                [YOK]\n",
       "332                                     [SİLAJLIK MISIR]\n",
       "333                                                [YOK]\n",
       "334                                                [FİĞ]\n",
       "335                            [ANASON,  KİMYON,  ASPİR]\n",
       "336                                  [REZENE,  ÇÖREKOTU]\n",
       "337                                                [YOK]\n",
       "338                                  [KİMYON,  ÇÖREKOTU]\n",
       "339                                                [YOK]\n",
       "340                                                [YOK]\n",
       "341                                                [YOK]\n",
       "342                                                [YOK]\n",
       "343                                 [ANASON,  TRİTİKALE]\n",
       "344                                                [YOK]\n",
       "345                                              [MISIR]\n",
       "346                                             [KANOLA]\n",
       "347                                                [YOK]\n",
       "348                                             [ANASON]\n",
       "349                                     [ANASON,  ASPİR]\n",
       "350                                             [ANASON]\n",
       "351                         [ANASON,  KİMYON,  ÇÖREKOTU]\n",
       "352                                                [YOK]\n",
       "353                                                [YOK]\n",
       "354                                                [YOK]\n",
       "355                                                [YOK]\n",
       "356                                                [YOK]\n",
       "357                                                [YOK]\n",
       "358                                                [YOK]\n",
       "Name: ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "target = data[\"ALTERNATİF_YENİ_ÜRÜN_ÇEŞİTLERİ_ÜRETİMİ\"].str.strip().str.split(\",\")\n",
    "target"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7165fb4d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([' AHUDUDU', ' ALTIN ÇİLEK', ' ANASON', ' ASPİR', ' AYÇİÇEĞİ',\n",
       "       ' BADEM', ' BARBUNYA', ' BÖĞÜRTLEN', ' CEVİZ', ' FASULYE', ' FİĞ',\n",
       "       ' HAŞHAŞ', ' KANOLA', ' KORUNGA', ' KİMYON', ' KİNOA', ' KİRAZ',\n",
       "       ' LALE', ' LAVANTA', ' SUSAM', ' TRİTİKALE', ' VİŞNE', ' YONCA',\n",
       "       ' ÇEREZLİK KABAK', ' ÇÖREKOTU', ' ÇİLEK', 'AHUDUDU', 'ALTIN ÇİLEK',\n",
       "       'ANASON', 'ASPİR', 'AYÇİÇEĞİ', 'BADEM', 'BEZELYE', 'BÖĞÜRTLEN',\n",
       "       'CEVİZ', 'FASULYE', 'FİĞ', 'GOJİ BERRY', 'JAPON ARMUDU', 'KANOLA',\n",
       "       'KÜLTÜR MANTARI', 'KİMYON', 'KİNOA', 'KİRAZ', 'LAVANTA',\n",
       "       'MERCİMEK', 'MISIR', 'PATATES', 'REZENE', 'SARIMSAK',\n",
       "       'SİLAJLIK MISIR', 'TRİTİKALE', 'YOK', 'ÇÖREKOTU', 'ÇİLEK', 'ÜZÜM',\n",
       "       'ŞEKER PANCARI'], dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.preprocessing import MultiLabelBinarizer\n",
    "mlb = MultiLabelBinarizer()\n",
    "target = mlb.fit_transform(target)\n",
    "mlb.classes_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "7764c86b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0, 0, 0, ..., 0, 0, 0],\n",
       "       [0, 0, 0, ..., 0, 0, 0],\n",
       "       [0, 0, 0, ..., 0, 0, 0],\n",
       "       ...,\n",
       "       [0, 0, 0, ..., 0, 0, 0],\n",
       "       [0, 0, 0, ..., 0, 0, 0],\n",
       "       [0, 0, 0, ..., 0, 0, 0]])"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "target"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "aab5e86d",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KANATLI HAYVAN</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_YOK</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA BİRLİĞİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA KOOPERATİFİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK</th>\n",
       "      <th>...</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SERTLER</td>\n",
       "      <td>1</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>HAYIR</td>\n",
       "      <td>VAR</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>EVET</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>YOK</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>EVET</td>\n",
       "      <td>YOK</td>\n",
       "      <td>0</td>\n",
       "      <td>55</td>\n",
       "      <td>HAYIR</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>1</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>HAYIR</td>\n",
       "      <td>VAR</td>\n",
       "      <td>50</td>\n",
       "      <td>35</td>\n",
       "      <td>EVET</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>EVET</td>\n",
       "      <td>VAR</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>EVET</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 243 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    İLÇE_ADI MAHALLE_ADI  BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ  \\\n",
       "354    Yunak     SERTLER                                 1   \n",
       "355    Yunak      SEVİNÇ                                 1   \n",
       "356    Yunak       SIRAM                                 1   \n",
       "357    Yunak    YEŞİLOBA                                 1   \n",
       "358    Yunak  YEŞİLYAYLA                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_KANATLI HAYVAN  BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ  \\\n",
       "354                                       0                                 1   \n",
       "355                                       0                                 1   \n",
       "356                                       0                                 1   \n",
       "357                                       0                                 1   \n",
       "358                                       0                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_YOK  SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE  \\\n",
       "354                            0                                      0   \n",
       "355                            0                                      0   \n",
       "356                            0                                      0   \n",
       "357                            0                                      0   \n",
       "358                            0                                      0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA BİRLİĞİ  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA KOOPERATİFİ  \\\n",
       "354                                                0   \n",
       "355                                                0   \n",
       "356                                                0   \n",
       "357                                                0   \n",
       "358                                                0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK  ...  \\\n",
       "354                                 0  ...   \n",
       "355                                 1  ...   \n",
       "356                                 1  ...   \n",
       "357                                 0  ...   \n",
       "358                                 0  ...   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU  ARICILIK  \\\n",
       "354                                                 0     HAYIR   \n",
       "355                                                 0     HAYIR   \n",
       "356                                                 0      EVET   \n",
       "357                                                 0     HAYIR   \n",
       "358                                                 1      EVET   \n",
       "\n",
       "     TARIMSAL_SULAMA_SUYU  SULAK_ALAN_MİKTARI  TRAKTÖR_SAYISI  \\\n",
       "354                   VAR                  20              15   \n",
       "355                   YOK                   0              75   \n",
       "356                   YOK                   0              55   \n",
       "357                   VAR                  50              35   \n",
       "358                   VAR                  10              20   \n",
       "\n",
       "     İYİ_TARIM_UYGULAMALARI  BİREYSEL_ARAZİ_ORTALAMASI  \n",
       "354                    EVET                         60  \n",
       "355                   HAYIR                         75  \n",
       "356                   HAYIR                        200  \n",
       "357                    EVET                        100  \n",
       "358                    EVET                        200  \n",
       "\n",
       "[5 rows x 243 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b695d8aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "new.columns = new.columns.str.replace(' ', '_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d50d23a1",
   "metadata": {},
   "outputs": [],
   "source": [
    "for colm in [\"ARICILIK\", \"TARIMSAL_SULAMA_SUYU\", \"İYİ_TARIM_UYGULAMALARI\"]:\n",
    "    new[colm]  = [1 if (i == \"EVET\" or i == \"VAR\") else 0 for i in new[colm]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "26f2e197",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_YOK</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK</th>\n",
       "      <th>...</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SERTLER</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>1</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>1</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>75</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>...</td>\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>55</td>\n",
       "      <td>0</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>50</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 243 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    İLÇE_ADI MAHALLE_ADI  BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ  \\\n",
       "354    Yunak     SERTLER                                 1   \n",
       "355    Yunak      SEVİNÇ                                 1   \n",
       "356    Yunak       SIRAM                                 1   \n",
       "357    Yunak    YEŞİLOBA                                 1   \n",
       "358    Yunak  YEŞİLYAYLA                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN  BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ  \\\n",
       "354                                       0                                 1   \n",
       "355                                       0                                 1   \n",
       "356                                       0                                 1   \n",
       "357                                       0                                 1   \n",
       "358                                       0                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_YOK  SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE  \\\n",
       "354                            0                                      0   \n",
       "355                            0                                      0   \n",
       "356                            0                                      0   \n",
       "357                            0                                      0   \n",
       "358                            0                                      0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ  \\\n",
       "354                                                0   \n",
       "355                                                0   \n",
       "356                                                0   \n",
       "357                                                0   \n",
       "358                                                0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK  ...  \\\n",
       "354                                 0  ...   \n",
       "355                                 1  ...   \n",
       "356                                 1  ...   \n",
       "357                                 0  ...   \n",
       "358                                 0  ...   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU  ARICILIK  \\\n",
       "354                                                 0         0   \n",
       "355                                                 0         0   \n",
       "356                                                 0         1   \n",
       "357                                                 0         0   \n",
       "358                                                 1         1   \n",
       "\n",
       "     TARIMSAL_SULAMA_SUYU  SULAK_ALAN_MİKTARI  TRAKTÖR_SAYISI  \\\n",
       "354                     1                  20              15   \n",
       "355                     0                   0              75   \n",
       "356                     0                   0              55   \n",
       "357                     1                  50              35   \n",
       "358                     1                  10              20   \n",
       "\n",
       "     İYİ_TARIM_UYGULAMALARI  BİREYSEL_ARAZİ_ORTALAMASI  \n",
       "354                       1                         60  \n",
       "355                       0                         75  \n",
       "356                       0                        200  \n",
       "357                       1                        100  \n",
       "358                       1                        200  \n",
       "\n",
       "[5 rows x 243 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "785e9df0",
   "metadata": {},
   "outputs": [],
   "source": [
    "new.SULAK_ALAN_MİKTARI = new.SULAK_ALAN_MİKTARI.astype('int')\n",
    "new.TRAKTÖR_SAYISI = new.TRAKTÖR_SAYISI.astype('int')\n",
    "new.BİREYSEL_ARAZİ_ORTALAMASI = new.BİREYSEL_ARAZİ_ORTALAMASI.astype('int')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "700e348e",
   "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>İLÇE_ADI</th>\n",
       "      <th>MAHALLE_ADI</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_YOK</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK</th>\n",
       "      <th>...</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SERTLER</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SEVİNÇ</td>\n",
       "      <td>1</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>1</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>75</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>SIRAM</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>...</td>\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>55</td>\n",
       "      <td>0</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLOBA</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>50</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>Yunak</td>\n",
       "      <td>YEŞİLYAYLA</td>\n",
       "      <td>1</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 243 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    İLÇE_ADI MAHALLE_ADI  BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ  \\\n",
       "354    Yunak     SERTLER                                 1   \n",
       "355    Yunak      SEVİNÇ                                 1   \n",
       "356    Yunak       SIRAM                                 1   \n",
       "357    Yunak    YEŞİLOBA                                 1   \n",
       "358    Yunak  YEŞİLYAYLA                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN  BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ  \\\n",
       "354                                       0                                 1   \n",
       "355                                       0                                 1   \n",
       "356                                       0                                 1   \n",
       "357                                       0                                 1   \n",
       "358                                       0                                 1   \n",
       "\n",
       "     BESLENEN_HAYVAN_TÜRLERİ_YOK  SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE  \\\n",
       "354                            0                                      0   \n",
       "355                            0                                      0   \n",
       "356                            0                                      0   \n",
       "357                            0                                      0   \n",
       "358                            0                                      0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ  \\\n",
       "354                                                0   \n",
       "355                                                0   \n",
       "356                                                0   \n",
       "357                                                0   \n",
       "358                                                0   \n",
       "\n",
       "     SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK  ...  \\\n",
       "354                                 0  ...   \n",
       "355                                 1  ...   \n",
       "356                                 1  ...   \n",
       "357                                 0  ...   \n",
       "358                                 0  ...   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK  \\\n",
       "354                                            0   \n",
       "355                                            0   \n",
       "356                                            0   \n",
       "357                                            0   \n",
       "358                                            0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN  \\\n",
       "354                                              0   \n",
       "355                                              0   \n",
       "356                                              0   \n",
       "357                                              0   \n",
       "358                                              0   \n",
       "\n",
       "     TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU  ARICILIK  \\\n",
       "354                                                 0         0   \n",
       "355                                                 0         0   \n",
       "356                                                 0         1   \n",
       "357                                                 0         0   \n",
       "358                                                 1         1   \n",
       "\n",
       "     TARIMSAL_SULAMA_SUYU  SULAK_ALAN_MİKTARI  TRAKTÖR_SAYISI  \\\n",
       "354                     1                  20              15   \n",
       "355                     0                   0              75   \n",
       "356                     0                   0              55   \n",
       "357                     1                  50              35   \n",
       "358                     1                  10              20   \n",
       "\n",
       "     İYİ_TARIM_UYGULAMALARI  BİREYSEL_ARAZİ_ORTALAMASI  \n",
       "354                       1                         60  \n",
       "355                       0                         75  \n",
       "356                       0                        200  \n",
       "357                       1                        100  \n",
       "358                       1                        200  \n",
       "\n",
       "[5 rows x 243 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "1a8956aa",
   "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>BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ</th>\n",
       "      <th>BESLENEN_HAYVAN_TÜRLERİ_YOK</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK</th>\n",
       "      <th>SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_ŞAHSİ_KUYULAR</th>\n",
       "      <th>HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_ARPA</th>\n",
       "      <th>...</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN</th>\n",
       "      <th>TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU</th>\n",
       "      <th>ARICILIK</th>\n",
       "      <th>TARIMSAL_SULAMA_SUYU</th>\n",
       "      <th>SULAK_ALAN_MİKTARI</th>\n",
       "      <th>TRAKTÖR_SAYISI</th>\n",
       "      <th>İYİ_TARIM_UYGULAMALARI</th>\n",
       "      <th>BİREYSEL_ARAZİ_ORTALAMASI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "      <td>359.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>0.969359</td>\n",
       "      <td>0.058496</td>\n",
       "      <td>0.810585</td>\n",
       "      <td>0.008357</td>\n",
       "      <td>0.016713</td>\n",
       "      <td>0.142061</td>\n",
       "      <td>0.256267</td>\n",
       "      <td>0.136490</td>\n",
       "      <td>0.582173</td>\n",
       "      <td>0.668524</td>\n",
       "      <td>...</td>\n",
       "      <td>0.005571</td>\n",
       "      <td>0.551532</td>\n",
       "      <td>0.002786</td>\n",
       "      <td>0.116992</td>\n",
       "      <td>0.610028</td>\n",
       "      <td>0.874652</td>\n",
       "      <td>31.908078</td>\n",
       "      <td>100.431755</td>\n",
       "      <td>0.077994</td>\n",
       "      <td>75.359331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.172583</td>\n",
       "      <td>0.235006</td>\n",
       "      <td>0.392385</td>\n",
       "      <td>0.091158</td>\n",
       "      <td>0.128373</td>\n",
       "      <td>0.349600</td>\n",
       "      <td>0.437181</td>\n",
       "      <td>0.343788</td>\n",
       "      <td>0.493890</td>\n",
       "      <td>0.471401</td>\n",
       "      <td>...</td>\n",
       "      <td>0.074535</td>\n",
       "      <td>0.498031</td>\n",
       "      <td>0.052778</td>\n",
       "      <td>0.321859</td>\n",
       "      <td>0.488424</td>\n",
       "      <td>0.331575</td>\n",
       "      <td>26.402978</td>\n",
       "      <td>157.336916</td>\n",
       "      <td>0.268537</td>\n",
       "      <td>83.943960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>105.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>1200.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>600.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 241 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ  \\\n",
       "count                        359.000000   \n",
       "mean                           0.969359   \n",
       "std                            0.172583   \n",
       "min                            0.000000   \n",
       "25%                            1.000000   \n",
       "50%                            1.000000   \n",
       "75%                            1.000000   \n",
       "max                            1.000000   \n",
       "\n",
       "       BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN  \\\n",
       "count                              359.000000   \n",
       "mean                                 0.058496   \n",
       "std                                  0.235006   \n",
       "min                                  0.000000   \n",
       "25%                                  0.000000   \n",
       "50%                                  0.000000   \n",
       "75%                                  0.000000   \n",
       "max                                  1.000000   \n",
       "\n",
       "       BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ  BESLENEN_HAYVAN_TÜRLERİ_YOK  \\\n",
       "count                        359.000000                   359.000000   \n",
       "mean                           0.810585                     0.008357   \n",
       "std                            0.392385                     0.091158   \n",
       "min                            0.000000                     0.000000   \n",
       "25%                            1.000000                     0.000000   \n",
       "50%                            1.000000                     0.000000   \n",
       "75%                            1.000000                     0.000000   \n",
       "max                            1.000000                     1.000000   \n",
       "\n",
       "       SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE  \\\n",
       "count                             359.000000   \n",
       "mean                                0.016713   \n",
       "std                                 0.128373   \n",
       "min                                 0.000000   \n",
       "25%                                 0.000000   \n",
       "50%                                 0.000000   \n",
       "75%                                 0.000000   \n",
       "max                                 1.000000   \n",
       "\n",
       "       SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ  \\\n",
       "count                                   359.000000   \n",
       "mean                                      0.142061   \n",
       "std                                       0.349600   \n",
       "min                                       0.000000   \n",
       "25%                                       0.000000   \n",
       "50%                                       0.000000   \n",
       "75%                                       0.000000   \n",
       "max                                       1.000000   \n",
       "\n",
       "       SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ  \\\n",
       "count                                       359.000000   \n",
       "mean                                          0.256267   \n",
       "std                                           0.437181   \n",
       "min                                           0.000000   \n",
       "25%                                           0.000000   \n",
       "50%                                           0.000000   \n",
       "75%                                           1.000000   \n",
       "max                                           1.000000   \n",
       "\n",
       "       SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK  \\\n",
       "count                        359.000000   \n",
       "mean                           0.136490   \n",
       "std                            0.343788   \n",
       "min                            0.000000   \n",
       "25%                            0.000000   \n",
       "50%                            0.000000   \n",
       "75%                            0.000000   \n",
       "max                            1.000000   \n",
       "\n",
       "       SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_ŞAHSİ_KUYULAR  \\\n",
       "count                                  359.000000   \n",
       "mean                                     0.582173   \n",
       "std                                      0.493890   \n",
       "min                                      0.000000   \n",
       "25%                                      0.000000   \n",
       "50%                                      1.000000   \n",
       "75%                                      1.000000   \n",
       "max                                      1.000000   \n",
       "\n",
       "       HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_ARPA  ...  \\\n",
       "count                                359.000000  ...   \n",
       "mean                                   0.668524  ...   \n",
       "std                                    0.471401  ...   \n",
       "min                                    0.000000  ...   \n",
       "25%                                    0.000000  ...   \n",
       "50%                                    1.000000  ...   \n",
       "75%                                    1.000000  ...   \n",
       "max                                    1.000000  ...   \n",
       "\n",
       "       TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK  \\\n",
       "count                                     359.000000   \n",
       "mean                                        0.005571   \n",
       "std                                         0.074535   \n",
       "min                                         0.000000   \n",
       "25%                                         0.000000   \n",
       "50%                                         0.000000   \n",
       "75%                                         0.000000   \n",
       "max                                         1.000000   \n",
       "\n",
       "       TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK  \\\n",
       "count                                   359.000000   \n",
       "mean                                      0.551532   \n",
       "std                                       0.498031   \n",
       "min                                       0.000000   \n",
       "25%                                       0.000000   \n",
       "50%                                       1.000000   \n",
       "75%                                       1.000000   \n",
       "max                                       1.000000   \n",
       "\n",
       "       TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN  \\\n",
       "count                                     359.000000   \n",
       "mean                                        0.002786   \n",
       "std                                         0.052778   \n",
       "min                                         0.000000   \n",
       "25%                                         0.000000   \n",
       "50%                                         0.000000   \n",
       "75%                                         0.000000   \n",
       "max                                         1.000000   \n",
       "\n",
       "       TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU    ARICILIK  \\\n",
       "count                                        359.000000  359.000000   \n",
       "mean                                           0.116992    0.610028   \n",
       "std                                            0.321859    0.488424   \n",
       "min                                            0.000000    0.000000   \n",
       "25%                                            0.000000    0.000000   \n",
       "50%                                            0.000000    1.000000   \n",
       "75%                                            0.000000    1.000000   \n",
       "max                                            1.000000    1.000000   \n",
       "\n",
       "       TARIMSAL_SULAMA_SUYU  SULAK_ALAN_MİKTARI  TRAKTÖR_SAYISI  \\\n",
       "count            359.000000          359.000000      359.000000   \n",
       "mean               0.874652           31.908078      100.431755   \n",
       "std                0.331575           26.402978      157.336916   \n",
       "min                0.000000            0.000000        0.000000   \n",
       "25%                1.000000           10.000000       15.000000   \n",
       "50%                1.000000           25.000000       50.000000   \n",
       "75%                1.000000           50.000000      105.000000   \n",
       "max                1.000000          100.000000     1200.000000   \n",
       "\n",
       "       İYİ_TARIM_UYGULAMALARI  BİREYSEL_ARAZİ_ORTALAMASI  \n",
       "count              359.000000                 359.000000  \n",
       "mean                 0.077994                  75.359331  \n",
       "std                  0.268537                  83.943960  \n",
       "min                  0.000000                   0.000000  \n",
       "25%                  0.000000                  20.000000  \n",
       "50%                  0.000000                  50.000000  \n",
       "75%                  0.000000                 100.000000  \n",
       "max                  1.000000                 600.000000  \n",
       "\n",
       "[8 rows x 241 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "a7b43e71",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 359 entries, 0 to 358\n",
      "Columns: 243 entries, İLÇE_ADI to BİREYSEL_ARAZİ_ORTALAMASI\n",
      "dtypes: int32(238), int64(3), object(2)\n",
      "memory usage: 350.6+ KB\n"
     ]
    }
   ],
   "source": [
    "new.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "7f4d7950",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "İLÇE_ADI                                                                        object\n",
       "MAHALLE_ADI                                                                     object\n",
       "BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ                                                 int32\n",
       "BESLENEN_HAYVAN_TÜRLERİ_KANATLI_HAYVAN                                           int32\n",
       "BESLENEN_HAYVAN_TÜRLERİ_KÜÇÜKBAŞ                                                 int32\n",
       "BESLENEN_HAYVAN_TÜRLERİ_YOK                                                      int32\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_BELEDİYE                                            int32\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_BİRLİĞİ                                      int32\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_SULAMA_KOOPERATİFİ                                  int32\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_YOK                                                 int32\n",
       "SULAMA_SUYU_KAYNAĞI_YÖNETİMİ_ŞAHSİ_KUYULAR                                       int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_ARPA                                         int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_BUĞDAY                                       int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_FİĞ                                          int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_HAZIR_YEM                                    int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_KEPEK                                        int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_KÜSPE                                        int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_SAMAN                                        int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_SİLAJLIK_MISIR                               int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_YOK                                          int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_YONCA                                        int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_YULAF                                        int32\n",
       "HAYVAN_BESLEMEDE_KULLANILAN_ÜRÜNLER_ÇAVDAR                                       int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ARMUT                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ARPA                                     int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ASPİR                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_AYÇİÇEĞİ                                 int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_BUĞDAY                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_BİBER                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_CEVİZ                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_DOMATES                                  int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ELMA                                     int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ERİK                                     int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_FASULYE                                  int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_HAŞHAŞ                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KABAK                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KANOLA                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KARPUZ                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KAVUN                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KAYISI                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KİMYON                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_KİRAZ                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_MERCİMEK                                 int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_MISIR                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_NOHUT                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_PATATES                                  int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_PATLICAN                                 int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_REZENE                                   int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_SALATALIK                                int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_SARIMSAK                                 int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_SOĞAN                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_VİŞNE                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_YOK                                      int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_YONCA                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_YULAF                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ÇEREZLİK_KABAK                           int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ÇİLEK                                    int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ÜZÜM                                     int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ŞEFTALİ                                  int32\n",
       "SULANABİLİR_ALANDA_YETİŞTİRİLEN_ÜRÜNLER_ŞEKER_PANCARI                            int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_AKARSU                                              int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_BARAJ                                               int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_DERE                                                int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_GÖL                                                 int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_GÖLET                                               int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_KANAL                                               int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_KOOPERATİF_KUYULARI                                 int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_YERALTI_SULARI                                      int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_YOK                                                 int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_ÇAY                                                 int32\n",
       "TARIMSAL_SULAMA_SUYU_KAYNAĞI_ŞAHSİ_KUYULAR                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ANASON                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ARMUT                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ARPA                                         int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ASPİR                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_AYÇİÇEĞİ                                     int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_BADEM                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_BAMYA                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_BEYAZ_KİRAZ                                  int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_BUĞDAY                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_BİBER                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_CEVİZ                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_DOMATES                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ELMA                                         int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ERİK                                         int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_FASULYE                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_FİĞ                                          int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_GÜL                                          int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_HAVUÇ                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_HAŞHAŞ                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_HIRTLAK                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KABAK                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KANOLA                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KARPUZ                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KAVUN                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KAYISI                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KÜLTÜR_MANTARI                               int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KİMYON                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_KİRAZ                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_MERCİMEK                                     int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_MISIR                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_NOHUT                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_PATATES                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_PATLICAN                                     int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_SALATALIK                                    int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_SARIMSAK                                     int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_SOĞAN                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_SUSAM                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_TERMİYE                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_TURP                                         int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_VİŞNE                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_YOK                                          int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_YONCA                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_YULAF                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ÇAVDAR                                       int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ÇEREZLİK_KABAK                               int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ÇÖREK_OTU                                    int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ÇİLEK                                        int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ÜZÜM                                         int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ŞEFTALİ                                      int32\n",
       "DOĞRUDAN_SATIN_ALINABİLECEK_ÜRÜNLER_ŞEKER_PANCARI                                int32\n",
       "MEŞHUR_ÜRÜNLER_ASMA_YAPRAĞI                                                      int32\n",
       "MEŞHUR_ÜRÜNLER_BAL                                                               int32\n",
       "MEŞHUR_ÜRÜNLER_BALIK                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_BULGUR                                                            int32\n",
       "MEŞHUR_ÜRÜNLER_CANLI_HAYVAN                                                      int32\n",
       "MEŞHUR_ÜRÜNLER_CEVİZLİ_SUCUK(BANDIRMA)                                           int32\n",
       "MEŞHUR_ÜRÜNLER_KARADUT                                                           int32\n",
       "MEŞHUR_ÜRÜNLER_KAYMAK                                                            int32\n",
       "MEŞHUR_ÜRÜNLER_KURU_ÜZÜM                                                         int32\n",
       "MEŞHUR_ÜRÜNLER_MEYVE_KURUSU                                                      int32\n",
       "MEŞHUR_ÜRÜNLER_PEKMEZ                                                            int32\n",
       "MEŞHUR_ÜRÜNLER_PEYNİR                                                            int32\n",
       "MEŞHUR_ÜRÜNLER_SALÇA                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_SUCUK                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_SÜT                                                               int32\n",
       "MEŞHUR_ÜRÜNLER_SÜT_REÇELİ                                                        int32\n",
       "MEŞHUR_ÜRÜNLER_TAHİN                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_TANDIR_EKMEĞİ                                                     int32\n",
       "MEŞHUR_ÜRÜNLER_TARHANA                                                           int32\n",
       "MEŞHUR_ÜRÜNLER_TÜFEK                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_YAĞ                                                               int32\n",
       "MEŞHUR_ÜRÜNLER_YOĞURT                                                            int32\n",
       "MEŞHUR_ÜRÜNLER_YUFKA                                                             int32\n",
       "MEŞHUR_ÜRÜNLER_YUMURTA                                                           int32\n",
       "MEŞHUR_ÜRÜNLER_ŞEKER_FASULYE                                                     int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ANASON                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ARPA                                                 int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ASPİR                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_AYÇİÇEĞİ                                             int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_BEYAZ_KİRAZ                                          int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_BUĞDAY                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_BİBER                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_CEVİZ                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_DOMATES                                              int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ELMA                                                 int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ERİK                                                 int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_FASULYE                                              int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_HAVUÇ                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_HAŞHAŞ                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_HIRTLAK                                              int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_KANOLA                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_KAVUN                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_KAYISI                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_KİMYON                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_KİRAZ                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_MERCİMEK                                             int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_MISIR                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_NOHUT                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_PATATES                                              int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_PATLICAN                                             int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_REZENE                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_SALATALIK                                            int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_SARIMSAK                                             int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_SOĞAN                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_VİŞNE                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_YOK                                                  int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_YONCA                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_YULAF                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÇAVDAR                                               int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÇEMEN                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÇEREZLİK_KABAK                                       int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÇÖREK_OTU                                            int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÇİLEK                                                int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ÜZÜM                                                 int32\n",
       "EN_ÇOK_YETİŞTİRİLEN_ÜRÜNLER_ŞEKER_PANCARI                                        int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_ERENLER_ÇİÇEĞİ                      int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_HASRET_GÜLÜ                         int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_KONGUR                              int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_SAZ_SÜMBÜLÜ                         int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_TERS_LALE                           int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_YOK                                 int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_ÇATRIK_BİTKİSİ                      int32\n",
       "ENDEMİK_(SADECE_BU_BÖLGEDE_YETİŞEN)_BİTKİLER_ÇOBAN_DÖŞEĞİ                        int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_ARI_YETİŞTİRİCİLİĞİ                              int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_BİOTEKNİK_MÜCADELE_VE_İYİ_TARIM_UYGULAMALARI     int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_HAYVANCILIK                                      int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_KIRSALDAN_KENTE_GÜVENLİ_GIDA                     int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_MANTAR_YETİŞTİRİCİLİĞİ                           int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_MODERN_BAĞCILIK                                  int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_MODERN_MEYVECİLİK                                int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_MODERN_SULAMA_SİSTEMLERİ                         int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_SEBZE_YETİŞTİRİCİLİĞİ                            int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_TARLA_BİTKİLERİ_YETİŞTİRİCİLİĞİ                  int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ          int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_YOK                                              int32\n",
       "TALEP_EDİLEN_TARIMSAL_EĞİTİMLER_ÇİLEK_YETİŞTİRİCİLİĞİ                            int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ADA_ÇAYI                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ALIÇ                                     int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ANASON                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ASPİR                                    int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_BİBERİYE                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_DAĞ_ÇAYI                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ELMACIK                                  int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_FESLEĞEN                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_GOJİ_BERRY                               int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_GİLABURU                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_HAŞHAŞ                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_IHLAMUR                                  int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KANTARON                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KATRAN                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KEKİK                                    int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KIRKKİLİT_OTU                            int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KIZILCIK                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KUŞBURNU                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KİMYON                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_KİŞNİŞ                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_LAVANTA                                  int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_NANE                                     int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_OĞUL_OTU                                 int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_PAPATYA                                  int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_REZENE                                   int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SALEP                                    int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_SUMAK                                    int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_YOK                                      int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇEMEN                                    int32\n",
       "TIBBİ_VE_AROMATİK_BİTKİ_YETİŞTİRİCİLİĞİ_ÇÖREKOTU                                 int32\n",
       "ARICILIK                                                                         int64\n",
       "TARIMSAL_SULAMA_SUYU                                                             int64\n",
       "SULAK_ALAN_MİKTARI                                                               int32\n",
       "TRAKTÖR_SAYISI                                                                   int32\n",
       "İYİ_TARIM_UYGULAMALARI                                                           int64\n",
       "BİREYSEL_ARAZİ_ORTALAMASI                                                        int32\n",
       "dtype: object"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "0177974c",
   "metadata": {},
   "outputs": [],
   "source": [
    "new.to_csv('clean_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "acde205c",
   "metadata": {},
   "outputs": [],
   "source": [
    "target = target\n",
    "data = new.loc[:, \"BESLENEN_HAYVAN_TÜRLERİ_BÜYÜKBAŞ\" : \"BİREYSEL_ARAZİ_ORTALAMASI\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "7c3b833e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "import tensorflow as tf\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(data, target, test_size=0.33, random_state=42)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "b565d26e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<keras.callbacks.History at 0x1e04476c220>"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from keras.models import Sequential\n",
    "from keras.layers import Dense\n",
    "\n",
    "def get_model(n_inputs, n_outputs):\n",
    "    model = Sequential()\n",
    "    model.add(Dense(20, input_dim=n_inputs, kernel_initializer='he_uniform', activation='relu'))\n",
    "    model.add(Dense(n_outputs, activation='sigmoid'))\n",
    "    model.compile(loss='binary_crossentropy', optimizer='adam')\n",
    "    return model\n",
    "\n",
    "n_inputs, n_outputs = X_train.shape[1], y_train.shape[1]\n",
    "# get model\n",
    "model = get_model(n_inputs, n_outputs)\n",
    "# fit the model on all data\n",
    "model.fit(X_train, y_train, verbose=0, epochs=100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "67bdad83",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4/4 - 0s - loss: 0.0886 - 173ms/epoch - 43ms/step\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0.08857975155115128"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.evaluate(X_test,  y_test, verbose=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b7a9407c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}