Anilist_DataHandling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "27694ff8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import scipy as sc\n",
    "import numpy as np\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4eb9646f",
   "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>anime_name</th>\n",
       "      <th>Format</th>\n",
       "      <th>Number Of Episodes</th>\n",
       "      <th>Episode Duration</th>\n",
       "      <th>status</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>Studios</th>\n",
       "      <th>Genres</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>source</th>\n",
       "      <th>Creator</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shingeki no Kyojin</td>\n",
       "      <td>TV</td>\n",
       "      <td>25.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>522270.0</td>\n",
       "      <td>47674.0</td>\n",
       "      <td>Wit Studio</td>\n",
       "      <td>Action|Drama|Fantasy|Mystery</td>\n",
       "      <td>85%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Hajime Isayama</td>\n",
       "      <td>436995.0</td>\n",
       "      <td>30979.0</td>\n",
       "      <td>36842.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>8263.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DEATH NOTE</td>\n",
       "      <td>TV</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>474846.0</td>\n",
       "      <td>35688.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Mystery|Psychological|Supernatural|Thriller</td>\n",
       "      <td>84%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Tsugumi Ooba</td>\n",
       "      <td>369357.0</td>\n",
       "      <td>26960.0</td>\n",
       "      <td>47004.0</td>\n",
       "      <td>16808.0</td>\n",
       "      <td>14717.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boku no Hero Academia</td>\n",
       "      <td>TV</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>471660.0</td>\n",
       "      <td>23789.0</td>\n",
       "      <td>bones</td>\n",
       "      <td>Action|Adventure|Comedy</td>\n",
       "      <td>79%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Kouhei Horikoshi</td>\n",
       "      <td>388606.0</td>\n",
       "      <td>29172.0</td>\n",
       "      <td>39132.0</td>\n",
       "      <td>7484.0</td>\n",
       "      <td>7266.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kimetsu no Yaiba</td>\n",
       "      <td>TV</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>468624.0</td>\n",
       "      <td>40432.0</td>\n",
       "      <td>ufotable</td>\n",
       "      <td>Action|Adventure|Drama|Fantasy|Supernatural</td>\n",
       "      <td>85%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Koyoharu Gotouge</td>\n",
       "      <td>362290.0</td>\n",
       "      <td>41180.0</td>\n",
       "      <td>48672.0</td>\n",
       "      <td>9883.0</td>\n",
       "      <td>6599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HUNTER×HUNTER (2011)</td>\n",
       "      <td>TV</td>\n",
       "      <td>148.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>433766.0</td>\n",
       "      <td>56845.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Action|Adventure|Fantasy</td>\n",
       "      <td>90%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Yoshihiro Togashi</td>\n",
       "      <td>258701.0</td>\n",
       "      <td>65347.0</td>\n",
       "      <td>72050.0</td>\n",
       "      <td>28800.0</td>\n",
       "      <td>8868.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6075</th>\n",
       "      <td>NOMAD: Megalo Box 2 - Hachidori to tabibito.</td>\n",
       "      <td>Special</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72%</td>\n",
       "      <td>Original</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6076</th>\n",
       "      <td>The Big O (2003)</td>\n",
       "      <td>TV</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Action|Mecha|Mystery|Psychological|Sci-Fi</td>\n",
       "      <td>73%</td>\n",
       "      <td>Original</td>\n",
       "      <td>Hajime Yatate</td>\n",
       "      <td>818.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6077</th>\n",
       "      <td>Zoids Wild</td>\n",
       "      <td>TV</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>OLM</td>\n",
       "      <td>Action|Adventure|Mecha|Sci-Fi</td>\n",
       "      <td>51%</td>\n",
       "      <td>Original</td>\n",
       "      <td>Norihiko Sudo</td>\n",
       "      <td>157.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>225.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6078</th>\n",
       "      <td>Sanctuary</td>\n",
       "      <td>OVA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1 hour, 7 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Pastel</td>\n",
       "      <td>Action|Drama|Thriller</td>\n",
       "      <td>58%</td>\n",
       "      <td>Manga</td>\n",
       "      <td>Yoshiyuki Okamura</td>\n",
       "      <td>503.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>672.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6079</th>\n",
       "      <td>Be-Boy Kidnapp'n Idol</td>\n",
       "      <td>OVA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drama|Romance</td>\n",
       "      <td>49%</td>\n",
       "      <td>Original</td>\n",
       "      <td>Kenichi Yatagai</td>\n",
       "      <td>872.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>307.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6080 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        anime_name   Format  \\\n",
       "0                               Shingeki no Kyojin       TV   \n",
       "1                                       DEATH NOTE       TV   \n",
       "2                            Boku no Hero Academia       TV   \n",
       "3                                 Kimetsu no Yaiba       TV   \n",
       "4                             HUNTER×HUNTER (2011)       TV   \n",
       "...                                            ...      ...   \n",
       "6075  NOMAD: Megalo Box 2 - Hachidori to tabibito.  Special   \n",
       "6076                              The Big O (2003)       TV   \n",
       "6077                                    Zoids Wild       TV   \n",
       "6078                                     Sanctuary      OVA   \n",
       "6079                         Be-Boy Kidnapp'n Idol      OVA   \n",
       "\n",
       "      Number Of Episodes Episode Duration    status  Popularity  favorites  \\\n",
       "0                   25.0          24 mins  Finished    522270.0    47674.0   \n",
       "1                   37.0          23 mins  Finished    474846.0    35688.0   \n",
       "2                   13.0          24 mins  Finished    471660.0    23789.0   \n",
       "3                   26.0          24 mins  Finished    468624.0    40432.0   \n",
       "4                  148.0          24 mins  Finished    433766.0    56845.0   \n",
       "...                  ...              ...       ...         ...        ...   \n",
       "6075                 1.0              NaN  Finished      1225.0       11.0   \n",
       "6076                13.0          24 mins  Finished      1225.0       54.0   \n",
       "6077                50.0          25 mins  Finished      1225.0       10.0   \n",
       "6078                 1.0   1 hour, 7 mins  Finished      1225.0        9.0   \n",
       "6079                 1.0          26 mins  Finished      1225.0        9.0   \n",
       "\n",
       "         Studios                                       Genres mean_score  \\\n",
       "0     Wit Studio                 Action|Drama|Fantasy|Mystery        85%   \n",
       "1       MADHOUSE  Mystery|Psychological|Supernatural|Thriller        84%   \n",
       "2          bones                      Action|Adventure|Comedy        79%   \n",
       "3       ufotable  Action|Adventure|Drama|Fantasy|Supernatural        85%   \n",
       "4       MADHOUSE                     Action|Adventure|Fantasy        90%   \n",
       "...          ...                                          ...        ...   \n",
       "6075         NaN                                          NaN        72%   \n",
       "6076     Sunrise    Action|Mecha|Mystery|Psychological|Sci-Fi        73%   \n",
       "6077         OLM                Action|Adventure|Mecha|Sci-Fi        51%   \n",
       "6078      Pastel                        Action|Drama|Thriller        58%   \n",
       "6079         NaN                                Drama|Romance        49%   \n",
       "\n",
       "        source            Creator  Completed  Current  Planning   Paused  \\\n",
       "0        Manga     Hajime Isayama   436995.0  30979.0   36842.0   9191.0   \n",
       "1        Manga       Tsugumi Ooba   369357.0  26960.0   47004.0  16808.0   \n",
       "2        Manga   Kouhei Horikoshi   388606.0  29172.0   39132.0   7484.0   \n",
       "3        Manga   Koyoharu Gotouge   362290.0  41180.0   48672.0   9883.0   \n",
       "4        Manga  Yoshihiro Togashi   258701.0  65347.0   72050.0  28800.0   \n",
       "...        ...                ...        ...      ...       ...      ...   \n",
       "6075  Original                NaN       81.0     73.0    1046.0     16.0   \n",
       "6076  Original      Hajime Yatate      818.0     55.0     326.0     17.0   \n",
       "6077  Original      Norihiko Sudo      157.0    135.0     621.0     87.0   \n",
       "6078     Manga  Yoshiyuki Okamura      503.0     18.0     672.0     16.0   \n",
       "6079  Original    Kenichi Yatagai      872.0     16.0     307.0     10.0   \n",
       "\n",
       "      Dropped  \n",
       "0      8263.0  \n",
       "1     14717.0  \n",
       "2      7266.0  \n",
       "3      6599.0  \n",
       "4      8868.0  \n",
       "...       ...  \n",
       "6075      9.0  \n",
       "6076      9.0  \n",
       "6077    225.0  \n",
       "6078     16.0  \n",
       "6079     20.0  \n",
       "\n",
       "[6080 rows x 17 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df = pd.read_csv('anilist_csv')\n",
    "anime_df_copy = anime_df.copy()\n",
    "anime_df_copy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1e5486d1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6080 entries, 0 to 6079\n",
      "Data columns (total 17 columns):\n",
      " #   Column              Non-Null Count  Dtype  \n",
      "---  ------              --------------  -----  \n",
      " 0   anime_name          6080 non-null   object \n",
      " 1   Format              5935 non-null   object \n",
      " 2   Number Of Episodes  5780 non-null   float64\n",
      " 3   Episode Duration    5720 non-null   object \n",
      " 4   status              5948 non-null   object \n",
      " 5   Popularity          5948 non-null   float64\n",
      " 6   favorites           5928 non-null   float64\n",
      " 7   Studios             4923 non-null   object \n",
      " 8   Genres              5860 non-null   object \n",
      " 9   mean_score          5736 non-null   object \n",
      " 10  source              5701 non-null   object \n",
      " 11  Creator             5657 non-null   object \n",
      " 12  Completed           5948 non-null   float64\n",
      " 13  Current             5948 non-null   float64\n",
      " 14  Planning            5948 non-null   float64\n",
      " 15  Paused              5948 non-null   float64\n",
      " 16  Dropped             5948 non-null   float64\n",
      "dtypes: float64(8), object(9)\n",
      "memory usage: 807.6+ KB\n"
     ]
    }
   ],
   "source": [
    "anime_df_copy.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7938c81c",
   "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>Number Of Episodes</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5780.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5928.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>13.279066</td>\n",
       "      <td>20637.395763</td>\n",
       "      <td>575.748650</td>\n",
       "      <td>12415.424344</td>\n",
       "      <td>1139.655683</td>\n",
       "      <td>5811.624916</td>\n",
       "      <td>572.656187</td>\n",
       "      <td>698.034633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>33.522225</td>\n",
       "      <td>41634.222731</td>\n",
       "      <td>2426.701066</td>\n",
       "      <td>29271.735961</td>\n",
       "      <td>4329.280999</td>\n",
       "      <td>9381.100630</td>\n",
       "      <td>1550.693438</td>\n",
       "      <td>1554.324971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1225.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>65.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>2608.750000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>1206.750000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>915.750000</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>38.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>6337.500000</td>\n",
       "      <td>52.000000</td>\n",
       "      <td>3248.500000</td>\n",
       "      <td>169.000000</td>\n",
       "      <td>2064.000000</td>\n",
       "      <td>109.000000</td>\n",
       "      <td>111.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>13.000000</td>\n",
       "      <td>19124.750000</td>\n",
       "      <td>222.000000</td>\n",
       "      <td>10344.750000</td>\n",
       "      <td>690.000000</td>\n",
       "      <td>6267.500000</td>\n",
       "      <td>461.000000</td>\n",
       "      <td>622.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1787.000000</td>\n",
       "      <td>522270.000000</td>\n",
       "      <td>56845.000000</td>\n",
       "      <td>436995.000000</td>\n",
       "      <td>171725.000000</td>\n",
       "      <td>100161.000000</td>\n",
       "      <td>41227.000000</td>\n",
       "      <td>26245.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Number Of Episodes     Popularity     favorites      Completed  \\\n",
       "count         5780.000000    5948.000000   5928.000000    5948.000000   \n",
       "mean            13.279066   20637.395763    575.748650   12415.424344   \n",
       "std             33.522225   41634.222731   2426.701066   29271.735961   \n",
       "min              1.000000    1225.000000      1.000000       0.000000   \n",
       "25%              1.000000    2608.750000     16.000000    1206.750000   \n",
       "50%             12.000000    6337.500000     52.000000    3248.500000   \n",
       "75%             13.000000   19124.750000    222.000000   10344.750000   \n",
       "max           1787.000000  522270.000000  56845.000000  436995.000000   \n",
       "\n",
       "             Current       Planning        Paused       Dropped  \n",
       "count    5948.000000    5948.000000   5948.000000   5948.000000  \n",
       "mean     1139.655683    5811.624916    572.656187    698.034633  \n",
       "std      4329.280999    9381.100630   1550.693438   1554.324971  \n",
       "min         2.000000      65.000000      0.000000      0.000000  \n",
       "25%        64.000000     915.750000     41.000000     38.000000  \n",
       "50%       169.000000    2064.000000    109.000000    111.000000  \n",
       "75%       690.000000    6267.500000    461.000000    622.000000  \n",
       "max    171725.000000  100161.000000  41227.000000  26245.000000  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df_copy.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "79f45313",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Erasing Rows with more than 5 NaN values.\n",
    "anime_df_copy.dropna(axis = 0, thresh = 5, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f43497d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1 - TV , 2 - Movie , 3 - Special , 4 - OVA , 5 - TV Short, 6 - ONA , 7 - Music . . . 0 - NaN (added later)\n",
    "format_replace_map = {'TV':1, 'TV(Chinese)':1, 'TV(South Korean)':1, 'TV ':1, ' TV':1,\n",
    "                      'Movie':2, 'Movie(Chinese)':2, 'Movie(South Korean)':2, ' Movie':2,\n",
    "                      'Special':3,\n",
    "                      'OVA':4, 'OVA(South Korean)':4, 'OVA ':4, ' OVA':4,\n",
    "                      'TV Short':5, 'TV Short(South Korean)':5,\n",
    "                      'ONA':6, 'ONA(Chinese)':6, 'ONA(South Korean)':6, 'ONA(Doujin)':6, ' ONA':6,\n",
    "                      'Music':7}\n",
    "\n",
    "anime_df_copy.replace(format_replace_map, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "13e3c1be",
   "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>anime_name</th>\n",
       "      <th>Format</th>\n",
       "      <th>Number Of Episodes</th>\n",
       "      <th>Episode Duration</th>\n",
       "      <th>status</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>Studios</th>\n",
       "      <th>Genres</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>source</th>\n",
       "      <th>Creator</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shingeki no Kyojin</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>522270.0</td>\n",
       "      <td>47674.0</td>\n",
       "      <td>Wit Studio</td>\n",
       "      <td>Action|Drama|Fantasy|Mystery</td>\n",
       "      <td>85%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hajime Isayama</td>\n",
       "      <td>436995.0</td>\n",
       "      <td>30979.0</td>\n",
       "      <td>36842.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>8263.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DEATH NOTE</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>474846.0</td>\n",
       "      <td>35688.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Mystery|Psychological|Supernatural|Thriller</td>\n",
       "      <td>84%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tsugumi Ooba</td>\n",
       "      <td>369357.0</td>\n",
       "      <td>26960.0</td>\n",
       "      <td>47004.0</td>\n",
       "      <td>16808.0</td>\n",
       "      <td>14717.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boku no Hero Academia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>471660.0</td>\n",
       "      <td>23789.0</td>\n",
       "      <td>bones</td>\n",
       "      <td>Action|Adventure|Comedy</td>\n",
       "      <td>79%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kouhei Horikoshi</td>\n",
       "      <td>388606.0</td>\n",
       "      <td>29172.0</td>\n",
       "      <td>39132.0</td>\n",
       "      <td>7484.0</td>\n",
       "      <td>7266.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kimetsu no Yaiba</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>468624.0</td>\n",
       "      <td>40432.0</td>\n",
       "      <td>ufotable</td>\n",
       "      <td>Action|Adventure|Drama|Fantasy|Supernatural</td>\n",
       "      <td>85%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Koyoharu Gotouge</td>\n",
       "      <td>362290.0</td>\n",
       "      <td>41180.0</td>\n",
       "      <td>48672.0</td>\n",
       "      <td>9883.0</td>\n",
       "      <td>6599.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HUNTER×HUNTER (2011)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>433766.0</td>\n",
       "      <td>56845.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Action|Adventure|Fantasy</td>\n",
       "      <td>90%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshihiro Togashi</td>\n",
       "      <td>258701.0</td>\n",
       "      <td>65347.0</td>\n",
       "      <td>72050.0</td>\n",
       "      <td>28800.0</td>\n",
       "      <td>8868.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6075</th>\n",
       "      <td>NOMAD: Megalo Box 2 - Hachidori to tabibito.</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72%</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6076</th>\n",
       "      <td>The Big O (2003)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Action|Mecha|Mystery|Psychological|Sci-Fi</td>\n",
       "      <td>73%</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Hajime Yatate</td>\n",
       "      <td>818.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6077</th>\n",
       "      <td>Zoids Wild</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>OLM</td>\n",
       "      <td>Action|Adventure|Mecha|Sci-Fi</td>\n",
       "      <td>51%</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Norihiko Sudo</td>\n",
       "      <td>157.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>225.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6078</th>\n",
       "      <td>Sanctuary</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1 hour, 7 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Pastel</td>\n",
       "      <td>Action|Drama|Thriller</td>\n",
       "      <td>58%</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshiyuki Okamura</td>\n",
       "      <td>503.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>672.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6079</th>\n",
       "      <td>Be-Boy Kidnapp'n Idol</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26 mins</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drama|Romance</td>\n",
       "      <td>49%</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Kenichi Yatagai</td>\n",
       "      <td>872.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>307.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5948 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        anime_name  Format  \\\n",
       "0                               Shingeki no Kyojin     1.0   \n",
       "1                                       DEATH NOTE     1.0   \n",
       "2                            Boku no Hero Academia     1.0   \n",
       "3                                 Kimetsu no Yaiba     1.0   \n",
       "4                             HUNTER×HUNTER (2011)     1.0   \n",
       "...                                            ...     ...   \n",
       "6075  NOMAD: Megalo Box 2 - Hachidori to tabibito.     3.0   \n",
       "6076                              The Big O (2003)     1.0   \n",
       "6077                                    Zoids Wild     1.0   \n",
       "6078                                     Sanctuary     4.0   \n",
       "6079                         Be-Boy Kidnapp'n Idol     4.0   \n",
       "\n",
       "      Number Of Episodes Episode Duration    status  Popularity  favorites  \\\n",
       "0                   25.0          24 mins  Finished    522270.0    47674.0   \n",
       "1                   37.0          23 mins  Finished    474846.0    35688.0   \n",
       "2                   13.0          24 mins  Finished    471660.0    23789.0   \n",
       "3                   26.0          24 mins  Finished    468624.0    40432.0   \n",
       "4                  148.0          24 mins  Finished    433766.0    56845.0   \n",
       "...                  ...              ...       ...         ...        ...   \n",
       "6075                 1.0              NaN  Finished      1225.0       11.0   \n",
       "6076                13.0          24 mins  Finished      1225.0       54.0   \n",
       "6077                50.0          25 mins  Finished      1225.0       10.0   \n",
       "6078                 1.0   1 hour, 7 mins  Finished      1225.0        9.0   \n",
       "6079                 1.0          26 mins  Finished      1225.0        9.0   \n",
       "\n",
       "         Studios                                       Genres mean_score  \\\n",
       "0     Wit Studio                 Action|Drama|Fantasy|Mystery        85%   \n",
       "1       MADHOUSE  Mystery|Psychological|Supernatural|Thriller        84%   \n",
       "2          bones                      Action|Adventure|Comedy        79%   \n",
       "3       ufotable  Action|Adventure|Drama|Fantasy|Supernatural        85%   \n",
       "4       MADHOUSE                     Action|Adventure|Fantasy        90%   \n",
       "...          ...                                          ...        ...   \n",
       "6075         NaN                                          NaN        72%   \n",
       "6076     Sunrise    Action|Mecha|Mystery|Psychological|Sci-Fi        73%   \n",
       "6077         OLM                Action|Adventure|Mecha|Sci-Fi        51%   \n",
       "6078      Pastel                        Action|Drama|Thriller        58%   \n",
       "6079         NaN                                Drama|Romance        49%   \n",
       "\n",
       "      source            Creator  Completed  Current  Planning   Paused  \\\n",
       "0        1.0     Hajime Isayama   436995.0  30979.0   36842.0   9191.0   \n",
       "1        1.0       Tsugumi Ooba   369357.0  26960.0   47004.0  16808.0   \n",
       "2        1.0   Kouhei Horikoshi   388606.0  29172.0   39132.0   7484.0   \n",
       "3        1.0   Koyoharu Gotouge   362290.0  41180.0   48672.0   9883.0   \n",
       "4        1.0  Yoshihiro Togashi   258701.0  65347.0   72050.0  28800.0   \n",
       "...      ...                ...        ...      ...       ...      ...   \n",
       "6075     3.0                NaN       81.0     73.0    1046.0     16.0   \n",
       "6076     3.0      Hajime Yatate      818.0     55.0     326.0     17.0   \n",
       "6077     3.0      Norihiko Sudo      157.0    135.0     621.0     87.0   \n",
       "6078     1.0  Yoshiyuki Okamura      503.0     18.0     672.0     16.0   \n",
       "6079     3.0    Kenichi Yatagai      872.0     16.0     307.0     10.0   \n",
       "\n",
       "      Dropped  \n",
       "0      8263.0  \n",
       "1     14717.0  \n",
       "2      7266.0  \n",
       "3      6599.0  \n",
       "4      8868.0  \n",
       "...       ...  \n",
       "6075      9.0  \n",
       "6076      9.0  \n",
       "6077    225.0  \n",
       "6078     16.0  \n",
       "6079     20.0  \n",
       "\n",
       "[5948 rows x 17 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 1 - Manga , 2 - Light Novel , 3 - Original , 4 - Visual Novel , 5 - Video Game , 6 - Novel , 7 - Other . . . 0 - NaN(added later)\n",
    "Source_replace_map = {'Manga':1, 'Light Novel':2, 'Original':3, \n",
    "                      'Visual Novel':4, 'Video Game':5, 'Novel':6,\n",
    "                      'Multimedia Project':7, 'Web Novel':7, 'Doujinshi':7, \n",
    "                      'Live Action':7, 'Comic':7, 'Picture Book':7, 'Game':7, 'Anime':7, 'Other':7}\n",
    "\n",
    "anime_df_copy.replace(Source_replace_map, inplace=True)\n",
    "anime_df_copy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "019b3b7b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Replacing String values in columns Mean Score and Episode Duration with Float values.\n",
    "Episode_Duration_mins=[]\n",
    "for ep_dur in anime_df_copy[\"Episode Duration\"]:\n",
    "    mins = 0\n",
    "    itr = 0\n",
    "    try:\n",
    "        str_split = ep_dur.split(',')\n",
    "        if(len(str_split)>1):\n",
    "            str_split2 = str_split[itr].split(' ')\n",
    "            mins += 60*int(str_split2[itr])\n",
    "            itr += 1\n",
    "        str_split2 = str_split[itr].split(' ')\n",
    "        mins += int(str_split2[itr])\n",
    "        Episode_Duration_mins.append(mins)\n",
    "    except:\n",
    "        Episode_Duration_mins.append(0)\n",
    "#replacing NaNs with 0\n",
    "\n",
    "anime_df_copy[\"Episode Duration\"] = Episode_Duration_mins"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c8771dfa",
   "metadata": {},
   "outputs": [],
   "source": [
    "# changing mean_score into a binned column. categories are 0,1,2,3,4,5,6,7,8,9,10.\n",
    "\n",
    "anime_df_copy['mean_score'] = anime_df_copy['mean_score'].str.rstrip('%').astype('float')\n",
    "anime_df_copy['mean_score'].fillna(0, inplace=True)\n",
    "\n",
    "bins = [0,10,20,30,40,50,60,70,80,90,100]\n",
    "labels = [1,2,3,4,5,6,7,8,9,10]\n",
    "\n",
    "anime_df_copy['mean_score_binned'] = pd.cut(anime_df_copy['mean_score'], bins, labels=labels)\n",
    "\n",
    "# replacing NaNs with 0 category\n",
    "anime_df_copy.mean_score_binned = anime_df_copy.mean_score_binned.values.add_categories(0)\n",
    "anime_df_copy.mean_score_binned = anime_df_copy.mean_score_binned.fillna(0)\n",
    "\n",
    "# deleting the previous mean_score column (only from the copied df)\n",
    "#anime_df_copy = anime_df_copy.drop('mean_score', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "3f6bd24a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7     2604\n",
       "8     1745\n",
       "6      869\n",
       "9      306\n",
       "0      212\n",
       "5      169\n",
       "4       26\n",
       "3        9\n",
       "2        5\n",
       "10       3\n",
       "1        0\n",
       "Name: mean_score_binned, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df_copy.mean_score_binned.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "738910ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "#replacing remaining NaN values with XX for strings and 0 for Floats.\n",
    "anime_df_copy.anime_name.fillna('XX', inplace = True)\n",
    "anime_df_copy.status.fillna('XX', inplace = True)\n",
    "anime_df_copy.Studios.fillna('XX', inplace = True)\n",
    "anime_df_copy.Genres.fillna('XX', inplace = True)\n",
    "anime_df_copy.Creator.fillna('XX', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0fc1c734",
   "metadata": {},
   "outputs": [],
   "source": [
    "anime_df_copy.Popularity.fillna(0, inplace = True)\n",
    "anime_df_copy.favorites.fillna(0, inplace = True)\n",
    "anime_df_copy[\"Number Of Episodes\"].fillna(0, inplace = True)\n",
    "anime_df_copy.Completed.fillna(0, inplace = True)\n",
    "anime_df_copy.Current.fillna(0, inplace = True)\n",
    "anime_df_copy.Planning.fillna(0, inplace = True)\n",
    "anime_df_copy.Paused.fillna(0, inplace = True)\n",
    "anime_df_copy.Dropped.fillna(0, inplace = True)\n",
    "anime_df_copy.Format.fillna(0, inplace = True)\n",
    "anime_df_copy.source.fillna(0, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "fc02123f",
   "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>anime_name</th>\n",
       "      <th>Format</th>\n",
       "      <th>Number Of Episodes</th>\n",
       "      <th>Episode Duration</th>\n",
       "      <th>status</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>Studios</th>\n",
       "      <th>Genres</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>source</th>\n",
       "      <th>Creator</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "      <th>mean_score_binned</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shingeki no Kyojin</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>522270.0</td>\n",
       "      <td>47674.0</td>\n",
       "      <td>Wit Studio</td>\n",
       "      <td>Action|Drama|Fantasy|Mystery</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hajime Isayama</td>\n",
       "      <td>436995.0</td>\n",
       "      <td>30979.0</td>\n",
       "      <td>36842.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>8263.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DEATH NOTE</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23</td>\n",
       "      <td>Finished</td>\n",
       "      <td>474846.0</td>\n",
       "      <td>35688.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Mystery|Psychological|Supernatural|Thriller</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tsugumi Ooba</td>\n",
       "      <td>369357.0</td>\n",
       "      <td>26960.0</td>\n",
       "      <td>47004.0</td>\n",
       "      <td>16808.0</td>\n",
       "      <td>14717.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boku no Hero Academia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>471660.0</td>\n",
       "      <td>23789.0</td>\n",
       "      <td>bones</td>\n",
       "      <td>Action|Adventure|Comedy</td>\n",
       "      <td>79.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kouhei Horikoshi</td>\n",
       "      <td>388606.0</td>\n",
       "      <td>29172.0</td>\n",
       "      <td>39132.0</td>\n",
       "      <td>7484.0</td>\n",
       "      <td>7266.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kimetsu no Yaiba</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>468624.0</td>\n",
       "      <td>40432.0</td>\n",
       "      <td>ufotable</td>\n",
       "      <td>Action|Adventure|Drama|Fantasy|Supernatural</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Koyoharu Gotouge</td>\n",
       "      <td>362290.0</td>\n",
       "      <td>41180.0</td>\n",
       "      <td>48672.0</td>\n",
       "      <td>9883.0</td>\n",
       "      <td>6599.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HUNTER×HUNTER (2011)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>433766.0</td>\n",
       "      <td>56845.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Action|Adventure|Fantasy</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshihiro Togashi</td>\n",
       "      <td>258701.0</td>\n",
       "      <td>65347.0</td>\n",
       "      <td>72050.0</td>\n",
       "      <td>28800.0</td>\n",
       "      <td>8868.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6075</th>\n",
       "      <td>NOMAD: Megalo Box 2 - Hachidori to tabibito.</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>XX</td>\n",
       "      <td>72.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>81.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6076</th>\n",
       "      <td>The Big O (2003)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Action|Mecha|Mystery|Psychological|Sci-Fi</td>\n",
       "      <td>73.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Hajime Yatate</td>\n",
       "      <td>818.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6077</th>\n",
       "      <td>Zoids Wild</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>OLM</td>\n",
       "      <td>Action|Adventure|Mecha|Sci-Fi</td>\n",
       "      <td>51.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Norihiko Sudo</td>\n",
       "      <td>157.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6078</th>\n",
       "      <td>Sanctuary</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>67</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Pastel</td>\n",
       "      <td>Action|Drama|Thriller</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshiyuki Okamura</td>\n",
       "      <td>503.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>672.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6079</th>\n",
       "      <td>Be-Boy Kidnapp'n Idol</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>Drama|Romance</td>\n",
       "      <td>49.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Kenichi Yatagai</td>\n",
       "      <td>872.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>307.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5948 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        anime_name  Format  \\\n",
       "0                               Shingeki no Kyojin     1.0   \n",
       "1                                       DEATH NOTE     1.0   \n",
       "2                            Boku no Hero Academia     1.0   \n",
       "3                                 Kimetsu no Yaiba     1.0   \n",
       "4                             HUNTER×HUNTER (2011)     1.0   \n",
       "...                                            ...     ...   \n",
       "6075  NOMAD: Megalo Box 2 - Hachidori to tabibito.     3.0   \n",
       "6076                              The Big O (2003)     1.0   \n",
       "6077                                    Zoids Wild     1.0   \n",
       "6078                                     Sanctuary     4.0   \n",
       "6079                         Be-Boy Kidnapp'n Idol     4.0   \n",
       "\n",
       "      Number Of Episodes  Episode Duration    status  Popularity  favorites  \\\n",
       "0                   25.0                24  Finished    522270.0    47674.0   \n",
       "1                   37.0                23  Finished    474846.0    35688.0   \n",
       "2                   13.0                24  Finished    471660.0    23789.0   \n",
       "3                   26.0                24  Finished    468624.0    40432.0   \n",
       "4                  148.0                24  Finished    433766.0    56845.0   \n",
       "...                  ...               ...       ...         ...        ...   \n",
       "6075                 1.0                 0  Finished      1225.0       11.0   \n",
       "6076                13.0                24  Finished      1225.0       54.0   \n",
       "6077                50.0                25  Finished      1225.0       10.0   \n",
       "6078                 1.0                67  Finished      1225.0        9.0   \n",
       "6079                 1.0                26  Finished      1225.0        9.0   \n",
       "\n",
       "         Studios                                       Genres  mean_score  \\\n",
       "0     Wit Studio                 Action|Drama|Fantasy|Mystery        85.0   \n",
       "1       MADHOUSE  Mystery|Psychological|Supernatural|Thriller        84.0   \n",
       "2          bones                      Action|Adventure|Comedy        79.0   \n",
       "3       ufotable  Action|Adventure|Drama|Fantasy|Supernatural        85.0   \n",
       "4       MADHOUSE                     Action|Adventure|Fantasy        90.0   \n",
       "...          ...                                          ...         ...   \n",
       "6075          XX                                           XX        72.0   \n",
       "6076     Sunrise    Action|Mecha|Mystery|Psychological|Sci-Fi        73.0   \n",
       "6077         OLM                Action|Adventure|Mecha|Sci-Fi        51.0   \n",
       "6078      Pastel                        Action|Drama|Thriller        58.0   \n",
       "6079          XX                                Drama|Romance        49.0   \n",
       "\n",
       "      source            Creator  Completed  Current  Planning   Paused  \\\n",
       "0        1.0     Hajime Isayama   436995.0  30979.0   36842.0   9191.0   \n",
       "1        1.0       Tsugumi Ooba   369357.0  26960.0   47004.0  16808.0   \n",
       "2        1.0   Kouhei Horikoshi   388606.0  29172.0   39132.0   7484.0   \n",
       "3        1.0   Koyoharu Gotouge   362290.0  41180.0   48672.0   9883.0   \n",
       "4        1.0  Yoshihiro Togashi   258701.0  65347.0   72050.0  28800.0   \n",
       "...      ...                ...        ...      ...       ...      ...   \n",
       "6075     3.0                 XX       81.0     73.0    1046.0     16.0   \n",
       "6076     3.0      Hajime Yatate      818.0     55.0     326.0     17.0   \n",
       "6077     3.0      Norihiko Sudo      157.0    135.0     621.0     87.0   \n",
       "6078     1.0  Yoshiyuki Okamura      503.0     18.0     672.0     16.0   \n",
       "6079     3.0    Kenichi Yatagai      872.0     16.0     307.0     10.0   \n",
       "\n",
       "      Dropped mean_score_binned  \n",
       "0      8263.0                 9  \n",
       "1     14717.0                 9  \n",
       "2      7266.0                 8  \n",
       "3      6599.0                 9  \n",
       "4      8868.0                 9  \n",
       "...       ...               ...  \n",
       "6075      9.0                 8  \n",
       "6076      9.0                 8  \n",
       "6077    225.0                 6  \n",
       "6078     16.0                 6  \n",
       "6079     20.0                 5  \n",
       "\n",
       "[5948 rows x 18 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df_copy.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "26f76fe0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 5948 entries, 0 to 6079\n",
      "Data columns (total 18 columns):\n",
      " #   Column              Non-Null Count  Dtype   \n",
      "---  ------              --------------  -----   \n",
      " 0   anime_name          5948 non-null   object  \n",
      " 1   Format              5948 non-null   float64 \n",
      " 2   Number Of Episodes  5948 non-null   float64 \n",
      " 3   Episode Duration    5948 non-null   int64   \n",
      " 4   status              5948 non-null   object  \n",
      " 5   Popularity          5948 non-null   float64 \n",
      " 6   favorites           5948 non-null   float64 \n",
      " 7   Studios             5948 non-null   object  \n",
      " 8   Genres              5948 non-null   object  \n",
      " 9   mean_score          5948 non-null   float64 \n",
      " 10  source              5948 non-null   float64 \n",
      " 11  Creator             5948 non-null   object  \n",
      " 12  Completed           5948 non-null   float64 \n",
      " 13  Current             5948 non-null   float64 \n",
      " 14  Planning            5948 non-null   float64 \n",
      " 15  Paused              5948 non-null   float64 \n",
      " 16  Dropped             5948 non-null   float64 \n",
      " 17  mean_score_binned   5948 non-null   category\n",
      "dtypes: category(1), float64(11), int64(1), object(5)\n",
      "memory usage: 842.6+ KB\n"
     ]
    }
   ],
   "source": [
    "anime_df_copy.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "0530434f",
   "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>Format</th>\n",
       "      <th>Number Of Episodes</th>\n",
       "      <th>Episode Duration</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>source</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "      <td>5948.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.452757</td>\n",
       "      <td>12.904001</td>\n",
       "      <td>29.081708</td>\n",
       "      <td>20637.395763</td>\n",
       "      <td>573.812710</td>\n",
       "      <td>64.836752</td>\n",
       "      <td>2.378951</td>\n",
       "      <td>12415.424344</td>\n",
       "      <td>1139.655683</td>\n",
       "      <td>5811.624916</td>\n",
       "      <td>572.656187</td>\n",
       "      <td>698.034633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.675736</td>\n",
       "      <td>33.118500</td>\n",
       "      <td>27.179752</td>\n",
       "      <td>41634.222731</td>\n",
       "      <td>2422.846381</td>\n",
       "      <td>15.128242</td>\n",
       "      <td>1.781104</td>\n",
       "      <td>29271.735961</td>\n",
       "      <td>4329.280999</td>\n",
       "      <td>9381.100630</td>\n",
       "      <td>1550.693438</td>\n",
       "      <td>1554.324971</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>1225.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>65.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>1.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>2608.750000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>61.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1206.750000</td>\n",
       "      <td>64.000000</td>\n",
       "      <td>915.750000</td>\n",
       "      <td>41.000000</td>\n",
       "      <td>38.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>6337.500000</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>67.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3248.500000</td>\n",
       "      <td>169.000000</td>\n",
       "      <td>2064.000000</td>\n",
       "      <td>109.000000</td>\n",
       "      <td>111.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>25.000000</td>\n",
       "      <td>19124.750000</td>\n",
       "      <td>220.000000</td>\n",
       "      <td>73.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>10344.750000</td>\n",
       "      <td>690.000000</td>\n",
       "      <td>6267.500000</td>\n",
       "      <td>461.000000</td>\n",
       "      <td>622.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>7.000000</td>\n",
       "      <td>1787.000000</td>\n",
       "      <td>168.000000</td>\n",
       "      <td>522270.000000</td>\n",
       "      <td>56845.000000</td>\n",
       "      <td>93.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>436995.000000</td>\n",
       "      <td>171725.000000</td>\n",
       "      <td>100161.000000</td>\n",
       "      <td>41227.000000</td>\n",
       "      <td>26245.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Format  Number Of Episodes  Episode Duration     Popularity  \\\n",
       "count  5948.000000         5948.000000       5948.000000    5948.000000   \n",
       "mean      2.452757           12.904001         29.081708   20637.395763   \n",
       "std       1.675736           33.118500         27.179752   41634.222731   \n",
       "min       0.000000            0.000000          0.000000    1225.000000   \n",
       "25%       1.000000            1.000000         20.000000    2608.750000   \n",
       "50%       2.000000           10.000000         24.000000    6337.500000   \n",
       "75%       4.000000           13.000000         25.000000   19124.750000   \n",
       "max       7.000000         1787.000000        168.000000  522270.000000   \n",
       "\n",
       "          favorites   mean_score       source      Completed        Current  \\\n",
       "count   5948.000000  5948.000000  5948.000000    5948.000000    5948.000000   \n",
       "mean     573.812710    64.836752     2.378951   12415.424344    1139.655683   \n",
       "std     2422.846381    15.128242     1.781104   29271.735961    4329.280999   \n",
       "min        0.000000     0.000000     0.000000       0.000000       2.000000   \n",
       "25%       16.000000    61.000000     1.000000    1206.750000      64.000000   \n",
       "50%       51.000000    67.000000     2.000000    3248.500000     169.000000   \n",
       "75%      220.000000    73.000000     3.000000   10344.750000     690.000000   \n",
       "max    56845.000000    93.000000     7.000000  436995.000000  171725.000000   \n",
       "\n",
       "            Planning        Paused       Dropped  \n",
       "count    5948.000000   5948.000000   5948.000000  \n",
       "mean     5811.624916    572.656187    698.034633  \n",
       "std      9381.100630   1550.693438   1554.324971  \n",
       "min        65.000000      0.000000      0.000000  \n",
       "25%       915.750000     41.000000     38.000000  \n",
       "50%      2064.000000    109.000000    111.000000  \n",
       "75%      6267.500000    461.000000    622.000000  \n",
       "max    100161.000000  41227.000000  26245.000000  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df_copy.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "10337caf",
   "metadata": {},
   "outputs": [],
   "source": [
    "anime_df_copy.to_csv('anime_df_copy_csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6933f504",
   "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>anime_name</th>\n",
       "      <th>Format</th>\n",
       "      <th>Number Of Episodes</th>\n",
       "      <th>Episode Duration</th>\n",
       "      <th>status</th>\n",
       "      <th>Popularity</th>\n",
       "      <th>favorites</th>\n",
       "      <th>Studios</th>\n",
       "      <th>Genres</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>source</th>\n",
       "      <th>Creator</th>\n",
       "      <th>Completed</th>\n",
       "      <th>Current</th>\n",
       "      <th>Planning</th>\n",
       "      <th>Paused</th>\n",
       "      <th>Dropped</th>\n",
       "      <th>mean_score_binned</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Shingeki no Kyojin</td>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>522270.0</td>\n",
       "      <td>47674.0</td>\n",
       "      <td>Wit Studio</td>\n",
       "      <td>Action|Drama|Fantasy|Mystery</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Hajime Isayama</td>\n",
       "      <td>436995.0</td>\n",
       "      <td>30979.0</td>\n",
       "      <td>36842.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>8263.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DEATH NOTE</td>\n",
       "      <td>1.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>23</td>\n",
       "      <td>Finished</td>\n",
       "      <td>474846.0</td>\n",
       "      <td>35688.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Mystery|Psychological|Supernatural|Thriller</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tsugumi Ooba</td>\n",
       "      <td>369357.0</td>\n",
       "      <td>26960.0</td>\n",
       "      <td>47004.0</td>\n",
       "      <td>16808.0</td>\n",
       "      <td>14717.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Boku no Hero Academia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>471660.0</td>\n",
       "      <td>23789.0</td>\n",
       "      <td>bones</td>\n",
       "      <td>Action|Adventure|Comedy</td>\n",
       "      <td>79.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kouhei Horikoshi</td>\n",
       "      <td>388606.0</td>\n",
       "      <td>29172.0</td>\n",
       "      <td>39132.0</td>\n",
       "      <td>7484.0</td>\n",
       "      <td>7266.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kimetsu no Yaiba</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>468624.0</td>\n",
       "      <td>40432.0</td>\n",
       "      <td>ufotable</td>\n",
       "      <td>Action|Adventure|Drama|Fantasy|Supernatural</td>\n",
       "      <td>85.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Koyoharu Gotouge</td>\n",
       "      <td>362290.0</td>\n",
       "      <td>41180.0</td>\n",
       "      <td>48672.0</td>\n",
       "      <td>9883.0</td>\n",
       "      <td>6599.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HUNTER×HUNTER (2011)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>148.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>433766.0</td>\n",
       "      <td>56845.0</td>\n",
       "      <td>MADHOUSE</td>\n",
       "      <td>Action|Adventure|Fantasy</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshihiro Togashi</td>\n",
       "      <td>258701.0</td>\n",
       "      <td>65347.0</td>\n",
       "      <td>72050.0</td>\n",
       "      <td>28800.0</td>\n",
       "      <td>8868.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6075</th>\n",
       "      <td>NOMAD: Megalo Box 2 - Hachidori to tabibito.</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>XX</td>\n",
       "      <td>72.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>81.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1046.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6076</th>\n",
       "      <td>The Big O (2003)</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>24</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Action|Mecha|Mystery|Psychological|Sci-Fi</td>\n",
       "      <td>73.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Hajime Yatate</td>\n",
       "      <td>818.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>326.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6077</th>\n",
       "      <td>Zoids Wild</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>OLM</td>\n",
       "      <td>Action|Adventure|Mecha|Sci-Fi</td>\n",
       "      <td>51.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Norihiko Sudo</td>\n",
       "      <td>157.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>621.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6078</th>\n",
       "      <td>Sanctuary</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>67</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Pastel</td>\n",
       "      <td>Action|Drama|Thriller</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yoshiyuki Okamura</td>\n",
       "      <td>503.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>672.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6079</th>\n",
       "      <td>Be-Boy Kidnapp'n Idol</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26</td>\n",
       "      <td>Finished</td>\n",
       "      <td>1225.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>XX</td>\n",
       "      <td>Drama|Romance</td>\n",
       "      <td>49.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Kenichi Yatagai</td>\n",
       "      <td>872.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>307.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5948 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        anime_name  Format  \\\n",
       "0                               Shingeki no Kyojin     1.0   \n",
       "1                                       DEATH NOTE     1.0   \n",
       "2                            Boku no Hero Academia     1.0   \n",
       "3                                 Kimetsu no Yaiba     1.0   \n",
       "4                             HUNTER×HUNTER (2011)     1.0   \n",
       "...                                            ...     ...   \n",
       "6075  NOMAD: Megalo Box 2 - Hachidori to tabibito.     3.0   \n",
       "6076                              The Big O (2003)     1.0   \n",
       "6077                                    Zoids Wild     1.0   \n",
       "6078                                     Sanctuary     4.0   \n",
       "6079                         Be-Boy Kidnapp'n Idol     4.0   \n",
       "\n",
       "      Number Of Episodes  Episode Duration    status  Popularity  favorites  \\\n",
       "0                   25.0                24  Finished    522270.0    47674.0   \n",
       "1                   37.0                23  Finished    474846.0    35688.0   \n",
       "2                   13.0                24  Finished    471660.0    23789.0   \n",
       "3                   26.0                24  Finished    468624.0    40432.0   \n",
       "4                  148.0                24  Finished    433766.0    56845.0   \n",
       "...                  ...               ...       ...         ...        ...   \n",
       "6075                 1.0                 0  Finished      1225.0       11.0   \n",
       "6076                13.0                24  Finished      1225.0       54.0   \n",
       "6077                50.0                25  Finished      1225.0       10.0   \n",
       "6078                 1.0                67  Finished      1225.0        9.0   \n",
       "6079                 1.0                26  Finished      1225.0        9.0   \n",
       "\n",
       "         Studios                                       Genres  mean_score  \\\n",
       "0     Wit Studio                 Action|Drama|Fantasy|Mystery        85.0   \n",
       "1       MADHOUSE  Mystery|Psychological|Supernatural|Thriller        84.0   \n",
       "2          bones                      Action|Adventure|Comedy        79.0   \n",
       "3       ufotable  Action|Adventure|Drama|Fantasy|Supernatural        85.0   \n",
       "4       MADHOUSE                     Action|Adventure|Fantasy        90.0   \n",
       "...          ...                                          ...         ...   \n",
       "6075          XX                                           XX        72.0   \n",
       "6076     Sunrise    Action|Mecha|Mystery|Psychological|Sci-Fi        73.0   \n",
       "6077         OLM                Action|Adventure|Mecha|Sci-Fi        51.0   \n",
       "6078      Pastel                        Action|Drama|Thriller        58.0   \n",
       "6079          XX                                Drama|Romance        49.0   \n",
       "\n",
       "      source            Creator  Completed  Current  Planning   Paused  \\\n",
       "0        1.0     Hajime Isayama   436995.0  30979.0   36842.0   9191.0   \n",
       "1        1.0       Tsugumi Ooba   369357.0  26960.0   47004.0  16808.0   \n",
       "2        1.0   Kouhei Horikoshi   388606.0  29172.0   39132.0   7484.0   \n",
       "3        1.0   Koyoharu Gotouge   362290.0  41180.0   48672.0   9883.0   \n",
       "4        1.0  Yoshihiro Togashi   258701.0  65347.0   72050.0  28800.0   \n",
       "...      ...                ...        ...      ...       ...      ...   \n",
       "6075     3.0                 XX       81.0     73.0    1046.0     16.0   \n",
       "6076     3.0      Hajime Yatate      818.0     55.0     326.0     17.0   \n",
       "6077     3.0      Norihiko Sudo      157.0    135.0     621.0     87.0   \n",
       "6078     1.0  Yoshiyuki Okamura      503.0     18.0     672.0     16.0   \n",
       "6079     3.0    Kenichi Yatagai      872.0     16.0     307.0     10.0   \n",
       "\n",
       "      Dropped mean_score_binned  \n",
       "0      8263.0                 9  \n",
       "1     14717.0                 9  \n",
       "2      7266.0                 8  \n",
       "3      6599.0                 9  \n",
       "4      8868.0                 9  \n",
       "...       ...               ...  \n",
       "6075      9.0                 8  \n",
       "6076      9.0                 8  \n",
       "6077    225.0                 6  \n",
       "6078     16.0                 6  \n",
       "6079     20.0                 5  \n",
       "\n",
       "[5948 rows x 18 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "anime_df_copy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dadc72d6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5b746cdf",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}