get_word_and_meaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ast\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>madde_id</th>\n",
       "      <th>kac</th>\n",
       "      <th>kelime_no</th>\n",
       "      <th>cesit</th>\n",
       "      <th>anlam_gor</th>\n",
       "      <th>on_taki</th>\n",
       "      <th>madde</th>\n",
       "      <th>cesit_say</th>\n",
       "      <th>anlam_say</th>\n",
       "      <th>taki</th>\n",
       "      <th>...</th>\n",
       "      <th>ozel_mi</th>\n",
       "      <th>lisan_kodu</th>\n",
       "      <th>lisan</th>\n",
       "      <th>telaffuz</th>\n",
       "      <th>birlesikler</th>\n",
       "      <th>font</th>\n",
       "      <th>madde_duz</th>\n",
       "      <th>gosterim_tarihi</th>\n",
       "      <th>anlamlarListe</th>\n",
       "      <th>atasozu</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6142</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>acınılma</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>acinilma</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'anlam_id': '1', 'madde_id': '6142', 'anlam_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6143</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>acube</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>Arapça uʿcūbe</td>\n",
       "      <td>acu:be</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>acube</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'anlam_id': '2', 'madde_id': '6143', 'anlam_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6144</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>açık fikirlilik</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>ği</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>acik fikirlilik</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'anlam_id': '4', 'madde_id': '6144', 'anlam_...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   madde_id  kac  kelime_no  cesit  anlam_gor on_taki            madde  \\\n",
       "0      6142    0          5      0          0     NaN         acınılma   \n",
       "1      6143    0          6      0          0     NaN            acube   \n",
       "2      6144    0          7      0          0     NaN  açık fikirlilik   \n",
       "\n",
       "   cesit_say  anlam_say taki  ...  ozel_mi  lisan_kodu          lisan  \\\n",
       "0          0          1  NaN  ...        0           0            NaN   \n",
       "1          0          2  NaN  ...        0          11  Arapça uʿcūbe   \n",
       "2          0          1   ği  ...        0           0            NaN   \n",
       "\n",
       "  telaffuz birlesikler font        madde_duz gosterim_tarihi  \\\n",
       "0      NaN         NaN  NaN         acinilma             NaN   \n",
       "1   acu:be         NaN  NaN            acube             NaN   \n",
       "2      NaN         NaN  NaN  acik fikirlilik             NaN   \n",
       "\n",
       "                                       anlamlarListe atasozu  \n",
       "0  [{'anlam_id': '1', 'madde_id': '6142', 'anlam_...     NaN  \n",
       "1  [{'anlam_id': '2', 'madde_id': '6143', 'anlam_...     NaN  \n",
       "2  [{'anlam_id': '4', 'madde_id': '6144', 'anlam_...     NaN  \n",
       "\n",
       "[3 rows x 21 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('tdk_word_data_all.csv')\n",
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>madde</th>\n",
       "      <th>anlamlarListe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>acınılma</td>\n",
       "      <td>[{'anlam_id': '1', 'madde_id': '6142', 'anlam_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>acube</td>\n",
       "      <td>[{'anlam_id': '2', 'madde_id': '6143', 'anlam_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>açık fikirlilik</td>\n",
       "      <td>[{'anlam_id': '4', 'madde_id': '6144', 'anlam_...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             madde                                      anlamlarListe\n",
       "0         acınılma  [{'anlam_id': '1', 'madde_id': '6142', 'anlam_...\n",
       "1            acube  [{'anlam_id': '2', 'madde_id': '6143', 'anlam_...\n",
       "2  açık fikirlilik  [{'anlam_id': '4', 'madde_id': '6144', 'anlam_..."
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df[['madde', 'anlamlarListe']]\n",
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>madde</th>\n",
       "      <th>anlam</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>acınılma</td>\n",
       "      <td>Acınılmak işi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>acube</td>\n",
       "      <td>Tuhaf kimse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>açık fikirlilik</td>\n",
       "      <td>Açık fikirli olma durumu</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             madde                     anlam\n",
       "0         acınılma             Acınılmak işi\n",
       "1            acube               Tuhaf kimse\n",
       "2  açık fikirlilik  Açık fikirli olma durumu"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['anlamlarListe'].fillna('[]', inplace=True)\n",
    "df['anlamlarListe'] = df['anlamlarListe'].apply(ast.literal_eval)\n",
    "anlam_list = df['anlamlarListe'].apply(lambda x: x[0]['anlam'] if x else 'No Data')\n",
    "df['anlam'] = anlam_list\n",
    "df.drop('anlamlarListe', axis=1, inplace=True)\n",
    "\n",
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>madde</th>\n",
       "      <th>anlam</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>acınılma</td>\n",
       "      <td>Acınılmak işi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>acube</td>\n",
       "      <td>Tuhaf kimse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>açık fikirlilik</td>\n",
       "      <td>Açık fikirli olma durumu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>adaklanma</td>\n",
       "      <td>Nişanlanma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>adaletlilik</td>\n",
       "      <td>Adaletli olma durumu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>addetme</td>\n",
       "      <td>Sayma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>addolunma</td>\n",
       "      <td>Sayılma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>adli polis</td>\n",
       "      <td>Adliye içerisinde güvenliği sağlayıp cumhuriye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>aforozlama</td>\n",
       "      <td>Aforozlamak işi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>afsunlama</td>\n",
       "      <td>Büyüleme</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             madde                                              anlam\n",
       "0         acınılma                                      Acınılmak işi\n",
       "1            acube                                        Tuhaf kimse\n",
       "2  açık fikirlilik                           Açık fikirli olma durumu\n",
       "3        adaklanma                                         Nişanlanma\n",
       "4      adaletlilik                               Adaletli olma durumu\n",
       "5          addetme                                              Sayma\n",
       "6        addolunma                                            Sayılma\n",
       "7       adli polis  Adliye içerisinde güvenliği sağlayıp cumhuriye...\n",
       "8       aforozlama                                    Aforozlamak işi\n",
       "9        afsunlama                                           Büyüleme"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('tdk_word_meaning_data.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "datascience",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.16"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}