T2_Preparing_Library_Dataset_Team3.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "8a9d3638",
   "metadata": {},
   "source": [
    "# Tamrin-2 (Team 3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "03de5754",
   "metadata": {},
   "source": [
    "Team 3: Moein Atiabi, Ali Mehrjo, Mohammad Talebi"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2b58b31",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "# Import libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "459f4725",
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Libraries loaded.\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "print('Libraries loaded.')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a6aec29c",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "# Loading dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0e03724b",
   "metadata": {
    "hidden": 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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>شماره راهنما</td>\n",
       "      <td>NaN</td>\n",
       "      <td>تعداد نسخ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>عنوان</td>\n",
       "      <td>NaN</td>\n",
       "      <td>شماره مدرک</td>\n",
       "      <td>NaN</td>\n",
       "      <td>شماره رکورد</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>‭‭ص‌۱۶۸</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>۲۳۵۹</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2594.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   0    1        2             3    4          5   \\\n",
       "0 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "1 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "2 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "3 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "4 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "5 NaN  NaN      NaN  شماره راهنما  NaN  تعداد نسخ   \n",
       "6 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "7 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "8 NaN  NaN  ‭‭ص‌۱۶۸           NaN  4.0        NaN   \n",
       "9 NaN  NaN      NaN           NaN  NaN        NaN   \n",
       "\n",
       "                                                  6      7     8           9   \\\n",
       "0                                                NaN    NaN   NaN         NaN   \n",
       "1                                                NaN    NaN   NaN         NaN   \n",
       "2                                                NaN    NaN   NaN         NaN   \n",
       "3                                                NaN    NaN   NaN         NaN   \n",
       "4                                                NaN    NaN   NaN         NaN   \n",
       "5                                                NaN  عنوان   NaN  شماره مدرک   \n",
       "6                                                NaN    NaN   NaN         NaN   \n",
       "7                                                NaN    NaN   NaN         NaN   \n",
       "8  ‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...    NaN  ۲۳۵۹         NaN   \n",
       "9                                                NaN    NaN   NaN         NaN   \n",
       "\n",
       "       10           11  \n",
       "0     NaN          NaN  \n",
       "1     NaN          NaN  \n",
       "2     NaN          NaN  \n",
       "3     NaN          NaN  \n",
       "4     NaN          NaN  \n",
       "5     NaN  شماره رکورد  \n",
       "6     NaN          NaN  \n",
       "7     NaN          NaN  \n",
       "8  2594.0          NaN  \n",
       "9     NaN          NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df = pd.read_excel('Data/converted.xlsx', engine='openpyxl', header= None)\n",
    "\n",
    "library_df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7bcd2118",
   "metadata": {},
   "source": [
    "# Simple EDA"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d33607b1",
   "metadata": {},
   "source": [
    "## Checking size of dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b241ad5d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10355, 12)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4a7f5b10",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## Checking data types"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5f1e446e",
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     float64\n",
       "1      object\n",
       "2      object\n",
       "3      object\n",
       "4     float64\n",
       "5      object\n",
       "6      object\n",
       "7      object\n",
       "8      object\n",
       "9      object\n",
       "10    float64\n",
       "11     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "361f791c",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## Checking null columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "df9e4dff",
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     10355\n",
       "1     10302\n",
       "2      7824\n",
       "3     10354\n",
       "4      7823\n",
       "5     10354\n",
       "6      7823\n",
       "7     10354\n",
       "8      7824\n",
       "9     10354\n",
       "10     7824\n",
       "11    10354\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e759e3a9",
   "metadata": {},
   "source": [
    "## Checking null rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "89f2d5d1",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10347</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10349</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10350</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10352</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10353</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7769 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       0    1    2    3   4    5    6    7    8    9   10   11\n",
       "0     NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "1     NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "2     NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "3     NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "4     NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "...    ..  ...  ...  ...  ..  ...  ...  ...  ...  ...  ..  ...\n",
       "10347 NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "10349 NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "10350 NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "10352 NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "10353 NaN  NaN  NaN  NaN NaN  NaN  NaN  NaN  NaN  NaN NaN  NaN\n",
       "\n",
       "[7769 rows x 12 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df[library_df.isnull().all(axis= 1)]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "65288eea",
   "metadata": {},
   "source": [
    "## Dropping null rows & columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9dddd4d6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2     7824\n",
       "4     7823\n",
       "6     7823\n",
       "8     7824\n",
       "10    7824\n",
       "dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.drop([0, 1, 3, 5, 7, 9, 11], inplace= True, axis= 1)\n",
    "\n",
    "library_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "3bc08baa",
   "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>2</th>\n",
       "      <th>4</th>\n",
       "      <th>6</th>\n",
       "      <th>8</th>\n",
       "      <th>10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>‭‭ص‌۱۶۸</td>\n",
       "      <td>4.0</td>\n",
       "      <td>‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...</td>\n",
       "      <td>۲۳۵۹</td>\n",
       "      <td>2594.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌</td>\n",
       "      <td>۲۵۹۳</td>\n",
       "      <td>2729.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>3.0</td>\n",
       "      <td>‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...</td>\n",
       "      <td>۲۶۰۰</td>\n",
       "      <td>2736.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌</td>\n",
       "      <td>۲۶۱۶</td>\n",
       "      <td>2752.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌</td>\n",
       "      <td>۲۶۲۷</td>\n",
       "      <td>2763.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               2    4                                                  6   \\\n",
       "8         ‭‭ص‌۱۶۸  4.0  ‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...   \n",
       "12  ‭‭درادن‍ ه‌در  1.0  ‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌   \n",
       "16  ‭‭درادن‍ ه‌در  3.0  ‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...   \n",
       "20  ‭‭درادن‍ ه‌در  1.0                   ‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌   \n",
       "24  ‭‭درادن‍ ه‌در  1.0                        ‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌   \n",
       "\n",
       "      8       10  \n",
       "8   ۲۳۵۹  2594.0  \n",
       "12  ۲۵۹۳  2729.0  \n",
       "16  ۲۶۰۰  2736.0  \n",
       "20  ۲۶۱۶  2752.0  \n",
       "24  ۲۶۲۷  2763.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.drop(library_df[library_df.isnull().all(axis= 1)].index, inplace= True)\n",
    "\n",
    "library_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69ea44b8",
   "metadata": {},
   "source": [
    "## Evaluating droped Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d034b286",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "67e392b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2     1\n",
       "4     0\n",
       "6     0\n",
       "8     1\n",
       "10    1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "248ea59d",
   "metadata": {},
   "source": [
    "# Renaming columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "fb830fb9",
   "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>#Guidance</th>\n",
       "      <th>Count</th>\n",
       "      <th>#Title</th>\n",
       "      <th>#Document</th>\n",
       "      <th>#Record</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>‭‭ص‌۱۶۸</td>\n",
       "      <td>4.0</td>\n",
       "      <td>‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...</td>\n",
       "      <td>۲۳۵۹</td>\n",
       "      <td>2594.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌</td>\n",
       "      <td>۲۵۹۳</td>\n",
       "      <td>2729.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>3.0</td>\n",
       "      <td>‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...</td>\n",
       "      <td>۲۶۰۰</td>\n",
       "      <td>2736.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌</td>\n",
       "      <td>۲۶۱۶</td>\n",
       "      <td>2752.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌</td>\n",
       "      <td>۲۶۲۷</td>\n",
       "      <td>2763.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        #Guidance  Count                                             #Title  \\\n",
       "8         ‭‭ص‌۱۶۸    4.0  ‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...   \n",
       "12  ‭‭درادن‍ ه‌در    1.0  ‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌   \n",
       "16  ‭‭درادن‍ ه‌در    3.0  ‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...   \n",
       "20  ‭‭درادن‍ ه‌در    1.0                   ‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌   \n",
       "24  ‭‭درادن‍ ه‌در    1.0                        ‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌   \n",
       "\n",
       "   #Document  #Record  \n",
       "8       ۲۳۵۹   2594.0  \n",
       "12      ۲۵۹۳   2729.0  \n",
       "16      ۲۶۰۰   2736.0  \n",
       "20      ۲۶۱۶   2752.0  \n",
       "24      ۲۶۲۷   2763.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.rename(columns= {2: '#Guidance', 4: 'Count', 6: '#Title', 8: '#Document', 10: '#Record'}, inplace= True)\n",
    "\n",
    "library_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6e0ab2ec",
   "metadata": {},
   "source": [
    "# Reset index column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "c182839b",
   "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>#Guidance</th>\n",
       "      <th>Count</th>\n",
       "      <th>#Title</th>\n",
       "      <th>#Document</th>\n",
       "      <th>#Record</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>‭‭ص‌۱۶۸</td>\n",
       "      <td>4.0</td>\n",
       "      <td>‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...</td>\n",
       "      <td>۲۳۵۹</td>\n",
       "      <td>2594.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌</td>\n",
       "      <td>۲۵۹۳</td>\n",
       "      <td>2729.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>3.0</td>\n",
       "      <td>‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...</td>\n",
       "      <td>۲۶۰۰</td>\n",
       "      <td>2736.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌</td>\n",
       "      <td>۲۶۱۶</td>\n",
       "      <td>2752.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>‭‭درادن‍ ه‌در</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌</td>\n",
       "      <td>۲۶۲۷</td>\n",
       "      <td>2763.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       #Guidance  Count                                             #Title  \\\n",
       "0        ‭‭ص‌۱۶۸    4.0  ‮ح‍ل‌ م‍س‍ائ‍ل‌ ف‍ی‍زی‍ک‌ ب‍رای‌ ع‍ل‍وم‌ زی‍س‍...   \n",
       "1  ‭‭درادن‍ ه‌در    1.0  ‮آش‍ن‍ای‍ی‌ ب‍ا م‍س‍ی‍ری‍اب‌ ه‍ای‌ م‍ی‍ک‍روت‍ی‍ک‌   \n",
       "2  ‭‭درادن‍ ه‌در    3.0  ‮ک‍ش‍ت‌ و پ‍رورش‌ گ‍ی‍اه‍ان‌ داروی‍ی‌ : آم‍ادگ...   \n",
       "3  ‭‭درادن‍ ه‌در    1.0                   ‮ب‍ی‍وت‍ک‍ن‍ول‍وژی‌ م‍ی‍ک‍روب‍ی‌   \n",
       "4  ‭‭درادن‍ ه‌در    1.0                        ‮زی‍س‍ت‌ ف‍ن‍اوری‌ غ‍ذای‍ی‌   \n",
       "\n",
       "  #Document  #Record  \n",
       "0      ۲۳۵۹   2594.0  \n",
       "1      ۲۵۹۳   2729.0  \n",
       "2      ۲۶۰۰   2736.0  \n",
       "3      ۲۶۱۶   2752.0  \n",
       "4      ۲۶۲۷   2763.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.reset_index(inplace= True, drop= True)\n",
    "\n",
    "library_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "49907c8c",
   "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>#Guidance</th>\n",
       "      <th>Count</th>\n",
       "      <th>#Title</th>\n",
       "      <th>#Document</th>\n",
       "      <th>#Record</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2522</th>\n",
       "      <td>‭‭U،۱۶۲،/گ‌۴س‌۲،۱۳۸۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮س‍اخ‍ت‍ار ش‍ن‍اس‍ی‌ راه‍ب‍رد</td>\n",
       "      <td>۲۰۳۸</td>\n",
       "      <td>2260.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2523</th>\n",
       "      <td>‭‭VT،۱۷۴،/ف‌۴ف‌۹،۱۳۸۹</td>\n",
       "      <td>2.0</td>\n",
       "      <td>‮ف‍ن‌ آوری‌ ن‍ان‍و: م‍اش‍ی‍ن‍ه‍ای‌ ن‍ام‍رئ‍ی‌</td>\n",
       "      <td>۶۴۲</td>\n",
       "      <td>699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2524</th>\n",
       "      <td>‭‭WP،۱۴۰،/ز۶۵،۱۳۷۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ت‍ظاه‍رات‌ اص‍ل‍ی‌ و درم‍ان‌ ب‍ی‍م‍اری‍ه‍ا- ز...</td>\n",
       "      <td>۲۰۴۹</td>\n",
       "      <td>2271.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2525</th>\n",
       "      <td>‭‭Z،۶۷۵،/د۲ ف‌ل‍ا۵،۱۳۹۰</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮اس‍ت‍ان‍دارده‍ای‌ ک‍ت‍اب‍خ‍ان‍ه‌ دان‍ش‍گ‍اه‍ی...</td>\n",
       "      <td>۱۸۱۷</td>\n",
       "      <td>2029.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2526</th>\n",
       "      <td>‭‭Z،۵۲/۵،/و۳۷خ‌۸،۱۳۸۳</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮رای‍ان‍ه‌ ک‍ار واژن‍ام‍ه‌ پ‍ردازی‌ word xp</td>\n",
       "      <td>۲۰۱۶</td>\n",
       "      <td>2234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2527</th>\n",
       "      <td>‭‭Z،۵۲/۵،/و۳۷م‌۶،۱۳۸۳</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ک‍ل‍ی‍د ورد</td>\n",
       "      <td>۲۰۵۹</td>\n",
       "      <td>2284.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2528</th>\n",
       "      <td>‭‭Z،۵۲/۵،/ع‌۷آ۸،۱۳۹۰</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮آم‍وزش‌ ت‍ص‍وی‍ری‌ ورد۲۰۱۰</td>\n",
       "      <td>۳۰</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2529</th>\n",
       "      <td>‭‭Z،۱،/م‌۳۲۵گ‌،۱۳۷۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮درم‍ان‌ ب‍ا گ‍ی‍اه‍ان‌ داروی‍ی‌</td>\n",
       "      <td>۲۲۰۹</td>\n",
       "      <td>2445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2530</th>\n",
       "      <td>‭‭اد،۳۰۰،/ب‌۴ب‌۲،۱۳۹۲</td>\n",
       "      <td>2.0</td>\n",
       "      <td>‮ب‍اغ‌ ب‍ی‌ ان‍ت‍ه‍ا</td>\n",
       "      <td>۱۴۰۹</td>\n",
       "      <td>1595.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2531</th>\n",
       "      <td>NaN</td>\n",
       "      <td>6161.0</td>\n",
       "      <td>جمـــــــــــــع کــل نســــخ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    #Guidance   Count  \\\n",
       "2522     ‭‭U،۱۶۲،/گ‌۴س‌۲،۱۳۸۵     1.0   \n",
       "2523    ‭‭VT،۱۷۴،/ف‌۴ف‌۹،۱۳۸۹     2.0   \n",
       "2524       ‭‭WP،۱۴۰،/ز۶۵،۱۳۷۵     1.0   \n",
       "2525  ‭‭Z،۶۷۵،/د۲ ف‌ل‍ا۵،۱۳۹۰     1.0   \n",
       "2526    ‭‭Z،۵۲/۵،/و۳۷خ‌۸،۱۳۸۳     1.0   \n",
       "2527    ‭‭Z،۵۲/۵،/و۳۷م‌۶،۱۳۸۳     1.0   \n",
       "2528     ‭‭Z،۵۲/۵،/ع‌۷آ۸،۱۳۹۰     1.0   \n",
       "2529      ‭‭Z،۱،/م‌۳۲۵گ‌،۱۳۷۵     1.0   \n",
       "2530    ‭‭اد،۳۰۰،/ب‌۴ب‌۲،۱۳۹۲     2.0   \n",
       "2531                      NaN  6161.0   \n",
       "\n",
       "                                                 #Title #Document  #Record  \n",
       "2522                      ‮س‍اخ‍ت‍ار ش‍ن‍اس‍ی‌ راه‍ب‍رد      ۲۰۳۸   2260.0  \n",
       "2523      ‮ف‍ن‌ آوری‌ ن‍ان‍و: م‍اش‍ی‍ن‍ه‍ای‌ ن‍ام‍رئ‍ی‌       ۶۴۲    699.0  \n",
       "2524  ‮ت‍ظاه‍رات‌ اص‍ل‍ی‌ و درم‍ان‌ ب‍ی‍م‍اری‍ه‍ا- ز...      ۲۰۴۹   2271.0  \n",
       "2525  ‮اس‍ت‍ان‍دارده‍ای‌ ک‍ت‍اب‍خ‍ان‍ه‌ دان‍ش‍گ‍اه‍ی...      ۱۸۱۷   2029.0  \n",
       "2526        ‮رای‍ان‍ه‌ ک‍ار واژن‍ام‍ه‌ پ‍ردازی‌ word xp      ۲۰۱۶   2234.0  \n",
       "2527                                       ‮ک‍ل‍ی‍د ورد      ۲۰۵۹   2284.0  \n",
       "2528                       ‮آم‍وزش‌ ت‍ص‍وی‍ری‌ ورد۲۰۱۰         ۳۰     37.0  \n",
       "2529                   ‮درم‍ان‌ ب‍ا گ‍ی‍اه‍ان‌ داروی‍ی‌      ۲۲۰۹   2445.0  \n",
       "2530                               ‮ب‍اغ‌ ب‍ی‌ ان‍ت‍ه‍ا      ۱۴۰۹   1595.0  \n",
       "2531                      جمـــــــــــــع کــل نســــخ       NaN      NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "08334da6",
   "metadata": {},
   "source": [
    "# Droping last row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "342a01c4",
   "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>#Guidance</th>\n",
       "      <th>Count</th>\n",
       "      <th>#Title</th>\n",
       "      <th>#Document</th>\n",
       "      <th>#Record</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2521</th>\n",
       "      <td>‭‭U،۵۵،/۳۱۳۹۶آ۵ح‌،۱۳۹۶</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮روزه‍ای‌ ب‍ه‌ ی‍ادم‍ان‍دن‍ی‌ س‍رب‍ازی‌</td>\n",
       "      <td>۲۰۴۳</td>\n",
       "      <td>2265.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2522</th>\n",
       "      <td>‭‭U،۱۶۲،/گ‌۴س‌۲،۱۳۸۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮س‍اخ‍ت‍ار ش‍ن‍اس‍ی‌ راه‍ب‍رد</td>\n",
       "      <td>۲۰۳۸</td>\n",
       "      <td>2260.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2523</th>\n",
       "      <td>‭‭VT،۱۷۴،/ف‌۴ف‌۹،۱۳۸۹</td>\n",
       "      <td>2.0</td>\n",
       "      <td>‮ف‍ن‌ آوری‌ ن‍ان‍و: م‍اش‍ی‍ن‍ه‍ای‌ ن‍ام‍رئ‍ی‌</td>\n",
       "      <td>۶۴۲</td>\n",
       "      <td>699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2524</th>\n",
       "      <td>‭‭WP،۱۴۰،/ز۶۵،۱۳۷۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ت‍ظاه‍رات‌ اص‍ل‍ی‌ و درم‍ان‌ ب‍ی‍م‍اری‍ه‍ا- ز...</td>\n",
       "      <td>۲۰۴۹</td>\n",
       "      <td>2271.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2525</th>\n",
       "      <td>‭‭Z،۶۷۵،/د۲ ف‌ل‍ا۵،۱۳۹۰</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮اس‍ت‍ان‍دارده‍ای‌ ک‍ت‍اب‍خ‍ان‍ه‌ دان‍ش‍گ‍اه‍ی...</td>\n",
       "      <td>۱۸۱۷</td>\n",
       "      <td>2029.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2526</th>\n",
       "      <td>‭‭Z،۵۲/۵،/و۳۷خ‌۸،۱۳۸۳</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮رای‍ان‍ه‌ ک‍ار واژن‍ام‍ه‌ پ‍ردازی‌ word xp</td>\n",
       "      <td>۲۰۱۶</td>\n",
       "      <td>2234.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2527</th>\n",
       "      <td>‭‭Z،۵۲/۵،/و۳۷م‌۶،۱۳۸۳</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮ک‍ل‍ی‍د ورد</td>\n",
       "      <td>۲۰۵۹</td>\n",
       "      <td>2284.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2528</th>\n",
       "      <td>‭‭Z،۵۲/۵،/ع‌۷آ۸،۱۳۹۰</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮آم‍وزش‌ ت‍ص‍وی‍ری‌ ورد۲۰۱۰</td>\n",
       "      <td>۳۰</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2529</th>\n",
       "      <td>‭‭Z،۱،/م‌۳۲۵گ‌،۱۳۷۵</td>\n",
       "      <td>1.0</td>\n",
       "      <td>‮درم‍ان‌ ب‍ا گ‍ی‍اه‍ان‌ داروی‍ی‌</td>\n",
       "      <td>۲۲۰۹</td>\n",
       "      <td>2445.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2530</th>\n",
       "      <td>‭‭اد،۳۰۰،/ب‌۴ب‌۲،۱۳۹۲</td>\n",
       "      <td>2.0</td>\n",
       "      <td>‮ب‍اغ‌ ب‍ی‌ ان‍ت‍ه‍ا</td>\n",
       "      <td>۱۴۰۹</td>\n",
       "      <td>1595.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    #Guidance  Count  \\\n",
       "2521   ‭‭U،۵۵،/۳۱۳۹۶آ۵ح‌،۱۳۹۶    1.0   \n",
       "2522     ‭‭U،۱۶۲،/گ‌۴س‌۲،۱۳۸۵    1.0   \n",
       "2523    ‭‭VT،۱۷۴،/ف‌۴ف‌۹،۱۳۸۹    2.0   \n",
       "2524       ‭‭WP،۱۴۰،/ز۶۵،۱۳۷۵    1.0   \n",
       "2525  ‭‭Z،۶۷۵،/د۲ ف‌ل‍ا۵،۱۳۹۰    1.0   \n",
       "2526    ‭‭Z،۵۲/۵،/و۳۷خ‌۸،۱۳۸۳    1.0   \n",
       "2527    ‭‭Z،۵۲/۵،/و۳۷م‌۶،۱۳۸۳    1.0   \n",
       "2528     ‭‭Z،۵۲/۵،/ع‌۷آ۸،۱۳۹۰    1.0   \n",
       "2529      ‭‭Z،۱،/م‌۳۲۵گ‌،۱۳۷۵    1.0   \n",
       "2530    ‭‭اد،۳۰۰،/ب‌۴ب‌۲،۱۳۹۲    2.0   \n",
       "\n",
       "                                                 #Title #Document  #Record  \n",
       "2521            ‮روزه‍ای‌ ب‍ه‌ ی‍ادم‍ان‍دن‍ی‌ س‍رب‍ازی‌      ۲۰۴۳   2265.0  \n",
       "2522                      ‮س‍اخ‍ت‍ار ش‍ن‍اس‍ی‌ راه‍ب‍رد      ۲۰۳۸   2260.0  \n",
       "2523      ‮ف‍ن‌ آوری‌ ن‍ان‍و: م‍اش‍ی‍ن‍ه‍ای‌ ن‍ام‍رئ‍ی‌       ۶۴۲    699.0  \n",
       "2524  ‮ت‍ظاه‍رات‌ اص‍ل‍ی‌ و درم‍ان‌ ب‍ی‍م‍اری‍ه‍ا- ز...      ۲۰۴۹   2271.0  \n",
       "2525  ‮اس‍ت‍ان‍دارده‍ای‌ ک‍ت‍اب‍خ‍ان‍ه‌ دان‍ش‍گ‍اه‍ی...      ۱۸۱۷   2029.0  \n",
       "2526        ‮رای‍ان‍ه‌ ک‍ار واژن‍ام‍ه‌ پ‍ردازی‌ word xp      ۲۰۱۶   2234.0  \n",
       "2527                                       ‮ک‍ل‍ی‍د ورد      ۲۰۵۹   2284.0  \n",
       "2528                       ‮آم‍وزش‌ ت‍ص‍وی‍ری‌ ورد۲۰۱۰         ۳۰     37.0  \n",
       "2529                   ‮درم‍ان‌ ب‍ا گ‍ی‍اه‍ان‌ داروی‍ی‌      ۲۲۰۹   2445.0  \n",
       "2530                               ‮ب‍اغ‌ ب‍ی‌ ان‍ت‍ه‍ا      ۱۴۰۹   1595.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "library_df.drop(index= library_df.shape[0] - 1, inplace= True)\n",
    "\n",
    "library_df.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1515fd77",
   "metadata": {},
   "source": [
    "# Exercise"
   ]
  },
  {
   "cell_type": "raw",
   "id": "c304f08b",
   "metadata": {},
   "source": [
    "فراوانی سال انتشار کتاب های موجود در کتابخانه را بدست بیاورید. به عنوان مثال بگوئید در کتابخانه چند کتاب سال انتشارشان مربوط به سال 1375 است؟\n",
    "این مقدار را برای همه سال هایی که  نسخه از آن در کتابخانه موجود است بدست بیاورید."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d659a0a9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "۱۴۰۰= 12\n"
     ]
    }
   ],
   "source": [
    "x = library_df['#Guidance'].values.tolist()\n",
    "y = '۱۴۰۰'\n",
    "k = 0\n",
    "\n",
    "for i in range(0, 2531): # start for()\n",
    "    if y == x[i][-4:]: # start if\n",
    "        k+=1\n",
    "    # end if\n",
    "#end for()\n",
    "\n",
    "print(y+'= '+str(k))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "72f57e89",
   "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>Year</th>\n",
       "      <th>Number Of Books</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>۱۳۳۷</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>۱۳۴۵</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>۱۳۴۸</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>۱۳۵۵</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>۱۳۵۷</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>۱۳۶۲</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>۱۳۶۳</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>۱۳۶۴</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>۱۳۶۵</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>۱۳۶۶</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>۱۳۶۷</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>۱۳۶۸</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>۱۳۶۹</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>۱۳۷۰</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>۱۳۷۱</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>۱۳۷۲</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>۱۳۷۳</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>۱۳۷۴</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>۱۳۷۵</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>۱۳۷۶</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>۱۳۷۷</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>۱۳۷۸</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>۱۳۷۹</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>۱۳۸۰</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>۱۳۸۱</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>۱۳۸۲</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>۱۳۸۳</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>۱۳۸۴</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>۱۳۸۵</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>۱۳۸۶</td>\n",
       "      <td>147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>۱۳۸۷</td>\n",
       "      <td>174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>۱۳۸۸</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>۱۳۸۹</td>\n",
       "      <td>232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>۱۳۹۰</td>\n",
       "      <td>203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>۱۳۹۱</td>\n",
       "      <td>214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>۱۳۹۲</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>۱۳۹۳</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>۱۳۹۴</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>۱۳۹۵</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>۱۳۹۶</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>۱۳۹۷</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>۱۳۹۸</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>۱۳۹۹</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>۱۴۰۰</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>۱۴۰۱</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Year  Number Of Books\n",
       "0   ۱۳۳۷                1\n",
       "1   ۱۳۴۵                1\n",
       "2   ۱۳۴۸                1\n",
       "3   ۱۳۵۵                1\n",
       "4   ۱۳۵۷                1\n",
       "5   ۱۳۶۲                1\n",
       "6   ۱۳۶۳                4\n",
       "7   ۱۳۶۴                1\n",
       "8   ۱۳۶۵                3\n",
       "9   ۱۳۶۶                5\n",
       "10  ۱۳۶۷                5\n",
       "11  ۱۳۶۸                3\n",
       "12  ۱۳۶۹                8\n",
       "13  ۱۳۷۰               10\n",
       "14  ۱۳۷۱                6\n",
       "15  ۱۳۷۲                5\n",
       "16  ۱۳۷۳               21\n",
       "17  ۱۳۷۴               28\n",
       "18  ۱۳۷۵               18\n",
       "19  ۱۳۷۶               18\n",
       "20  ۱۳۷۷               25\n",
       "21  ۱۳۷۸               35\n",
       "22  ۱۳۷۹               46\n",
       "23  ۱۳۸۰               45\n",
       "24  ۱۳۸۱               51\n",
       "25  ۱۳۸۲               60\n",
       "26  ۱۳۸۳               73\n",
       "27  ۱۳۸۴              102\n",
       "28  ۱۳۸۵               81\n",
       "29  ۱۳۸۶              147\n",
       "30  ۱۳۸۷              174\n",
       "31  ۱۳۸۸              206\n",
       "32  ۱۳۸۹              232\n",
       "33  ۱۳۹۰              203\n",
       "34  ۱۳۹۱              214\n",
       "35  ۱۳۹۲              206\n",
       "36  ۱۳۹۳              127\n",
       "37  ۱۳۹۴               81\n",
       "38  ۱۳۹۵               73\n",
       "39  ۱۳۹۶               63\n",
       "40  ۱۳۹۷               30\n",
       "41  ۱۳۹۸               17\n",
       "42  ۱۳۹۹                7\n",
       "43  ۱۴۰۰               12\n",
       "44  ۱۴۰۱                3"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = library_df['#Guidance'].values.tolist()\n",
    "y = ['۰','۱','۲','۳','۴','۵','۶','۷','۸','۹']\n",
    "z = {'Year':[], 'Number Of Books':[]}\n",
    "\n",
    "for i in range (3, 5): # start for1() / baraye ragham sevom sal ya 3 ya 4\n",
    "    for j in range (0, 10): # start for2() / baraye ragham dovom sal az 0 ta 9\n",
    "        for k in range (0, 10): # start for3() / baraye ragham aval sal az 0 ta 9\n",
    "            s = 0\n",
    "            for n in range (0, 2531): # start for4() / baraye moghayese adad ba sal ketabha\n",
    "                if '۱'+y[i]+y[j]+y[k] == x[n][-4:]: # start if\n",
    "                    s+=1\n",
    "                # end if\n",
    "            z['Year'].append('۱'+y[i]+y[j]+y[k])\n",
    "            z['Number Of Books'].append(s)\n",
    "            # end for4()\n",
    "        # end for3()\n",
    "    # end for2()\n",
    "# end for1()\n",
    "\n",
    "Books_df = pd.DataFrame(z)\n",
    "for i in range(0, 200): # start for()\n",
    "    if Books_df.loc[i]['Number Of Books'] == 0: # start if\n",
    "        Books_df.drop(i, inplace=True)\n",
    "    # end if\n",
    "# end for()\n",
    "\n",
    "Books_df.reset_index(inplace= True, drop= True)\n",
    "Books_df # print Number of books"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.5 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.5"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  },
  "vscode": {
   "interpreter": {
    "hash": "73c10509234451b7c9059ae5f54ad33529ef7b4c9c761939e46712064d00bc14"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}