Make anonymous data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "from zero.dataset import Dataset\n",
    "from mangaki.utils.values import rating_values\n",
    "\n",
    "\n",
    "queryset = Rating.objects.exclude(choice__in=['willsee', 'wontsee'])  # Security if the dataset is public\n",
    "triplets = queryset.values_list('user_id', 'work_id', 'choice')\n",
    "titles = Work.objects.order_by('id').values_list('id', 'title')\n",
    "categories = Work.objects.order_by('id').values_list('id', 'category__slug')\n",
    "dataset = Dataset()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "# anonymized = dataset.make_anonymous_data(triplets, convert=lambda choice: rating_values[choice], ordered=True)\n",
    "anonymized = dataset.make_anonymous_data(triplets, convert=str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "AnonymizedData(X=array([[ 339, 1626],\n",
       "       [2057, 7939],\n",
       "       [1382, 8120],\n",
       "       ...,\n",
       "       [1997,  406],\n",
       "       [1747, 6798],\n",
       "       [1136, 4655]]), y=array(['favorite', 'neutral', 'like', ..., 'favorite', 'like', 'like'],\n",
       "      dtype='<U8'), y_text=array(['favorite', 'neutral', 'like', ..., 'favorite', 'like', 'like'],\n",
       "      dtype='<U8'), nb_users=2289, nb_works=9174)"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.anonymized"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "df = pd.DataFrame(np.column_stack((dataset.anonymized.X, dataset.anonymized.y)), columns=('user', 'item', 'rating'))\n",
    "df['user'] = df['user'].astype(np.int32)\n",
    "df['item'] = df['item'].astype(np.int32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user              1958\n",
       "item              2939\n",
       "rating               4\n",
       "items_per_user     391\n",
       "users_per_item     355\n",
       "dtype: int64"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "\n",
    "df['items_per_user'] = df.groupby('user')['item'].transform('count')\n",
    "df['users_per_item'] = df.groupby('item')['user'].transform('count')\n",
    "\n",
    "df = df.query('items_per_user >= 10 and users_per_item >= 10')\n",
    "df.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f82f776aa10>"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAD4CAYAAAAAczaOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAWQ0lEQVR4nO3dfbBcdX3H8feniaByNQlGb2MSe0MnOsNDjeQO4vgwewUhICPQcWwyjBCfohVmtDIjQWyhWmaiolYGC0ZJhYK5UBBJA5RGyh10pgESGkkCBC5wqbmNRB5MetFhDHz7x/4Wluve3H04u3fN7/Oa2dlzfr/z8N0D+9mzv3PuRhGBmZnl4U+mugAzM+sch76ZWUYc+mZmGXHom5llxKFvZpaR6VNdwGRmz54dfX19Da3z3HPPccghh7SnoIK4xmK4xmK4xmJ0S42bN29+KiLeWLMzIrr6sXjx4mjUnXfe2fA6neYai+Eai+Eai9EtNQKbYoJM9fCOmVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGHPpmZhlx6JuZZWTS0Je0RtJuSduq2q6TtCU9RiRtSe19kn5X1XdF1TqLJW2VNCzpUklqz0syM7OJ1PMXuT8ELgOurjRExF9VpiV9E9hTtfyjEbGoxnYuBz4F3A3cCiwBbmu8ZDMza9akoR8Rd0nqq9WXztY/Arx/f9uQNAd4fURsTPNXA6fR5tDvW3lLzfaRVR9s527NzLqWoo5/OSuF/vqIOHJc+/uAb0VEf9Vy24GHgb3AlyPiZ5L6gVURcXxa7r3AeRFxygT7WwGsAOjt7V08ODjY0IsaGxujp6eHraN7avYfNXdGQ9trh0qN3cw1FsM1FsM11m9gYGBzJZfHa/UH15YBa6vmdwFviYinJS0GfiLpiEY3GhGrgdUA/f39USqVGlp/aGiIUqnE8onO9M9obHvtUKmxm7nGYrjGYrjGYjQd+pKmA38JLK60RcTzwPNperOkR4G3AqPAvKrV56U2MzProFZu2TweeCgidlYaJL1R0rQ0fRiwEHgsInYBeyUdm64DnAnc3MK+zcysCfXcsrkW+C/gbZJ2SvpE6lrKK4d2AN4H3J9u4bwB+ExEPJP6Pgv8ABgGHsV37piZdVw9d+8sm6B9eY22G4EbJ1h+E3BkrT4zM+sM/0WumVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGHPpmZhlx6JuZZcShb2aWEYe+mVlGJg19SWsk7Za0rartIkmjkrakx8lVfedLGpa0Q9KJVe1LUtuwpJXFvxQzM5tMPWf6PwSW1Gj/dkQsSo9bASQdDiwFjkjr/JOkaZKmAd8FTgIOB5alZc3MrIOmT7ZARNwlqa/O7Z0KDEbE88DjkoaBY1LfcEQ8BiBpMC37QMMVm5lZ0xQRky9UDv31EXFkmr8IWA7sBTYB50bEs5IuAzZGxDVpuSuB29JmlkTEJ1P7R4F3RsQ5E+xvBbACoLe3d/Hg4GBDL2psbIyenh62ju6p2X/U3BkNba8dKjV2M9dYDNdYDNdYv4GBgc0R0V+rb9Iz/QlcDnwViPT8TeDjTW7rD0TEamA1QH9/f5RKpYbWHxoaolQqsXzlLTX7R85obHvtUKmxm7nGYrjGYrjGYjQV+hHxZGVa0veB9Wl2FJhftei81MZ+2s3MrEOaumVT0pyq2dOByp0964Clkg6WtABYCNwD3AsslLRA0kGUL/aua75sMzNrxqRn+pLWAiVgtqSdwIVASdIiysM7I8CnASJiu6TrKV+g3QecHREvpO2cA9wOTAPWRMT2wl+NmZntVz137yyr0Xzlfpa/GLi4RvutwK0NVWdmZoXyX+SamWXEoW9mlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRhz6ZmYZmTT0Ja2RtFvStqq2b0h6SNL9km6SNDO190n6naQt6XFF1TqLJW2VNCzpUklqz0syM7OJ1HOm/0Ngybi2DcCREfEXwMPA+VV9j0bEovT4TFX75cCngIXpMX6bZmbWZpOGfkTcBTwzru0/ImJfmt0IzNvfNiTNAV4fERsjIoCrgdOaK9nMzJqlcgZPspDUB6yPiCNr9P0bcF1EXJOW20757H8v8OWI+JmkfmBVRByf1nkvcF5EnDLB/lYAKwB6e3sXDw4ONvSixsbG6OnpYevonpr9R82d0dD22qFSYzdzjcVwjcVwjfUbGBjYHBH9tfqmt7JhSRcA+4BrU9Mu4C0R8bSkxcBPJB3R6HYjYjWwGqC/vz9KpVJD6w8NDVEqlVi+8paa/SNnNLa9dqjU2M1cYzFcYzFcYzGaDn1Jy4FTgOPSkA0R8TzwfJreLOlR4K3AKK8cApqX2szMrIOaumVT0hLgi8CHIuK3Ve1vlDQtTR9G+YLtYxGxC9gr6dh0186ZwM0tV29mZg2Z9Exf0lqgBMyWtBO4kPLdOgcDG9KdlxvTnTrvA74i6ffAi8BnIqJyEfizlO8Eeg1wW3qYmVkHTRr6EbGsRvOVEyx7I3DjBH2bgD+4EGxmZp3jv8g1M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwyUlfoS1ojabekbVVth0raIOmR9DwrtUvSpZKGJd0v6eiqdc5Kyz8i6aziX46Zme1PvWf6PwSWjGtbCdwREQuBO9I8wEnAwvRYAVwO5Q8J4ELgncAxwIWVDwozM+uMukI/Iu4CnhnXfCpwVZq+Cjitqv3qKNsIzJQ0BzgR2BARz0TEs8AG/vCDxMzM2kgRUd+CUh+wPiKOTPO/iYiZaVrAsxExU9J6YFVE/Dz13QGcB5SAV0fEP6T2vwV+FxGX1NjXCsrfEujt7V08ODjY0IsaGxujp6eHraN7avYfNXdGQ9trh0qN3cw1FsM1FsM11m9gYGBzRPTX6ptexA4iIiTV9+lR3/ZWA6sB+vv7o1QqNbT+0NAQpVKJ5Stvqdk/ckZj22uHSo3dzDUWwzUWwzUWo5W7d55Mwzak592pfRSYX7XcvNQ2UbuZmXVIK6G/DqjcgXMWcHNV+5npLp5jgT0RsQu4HThB0qx0AfeE1GZmZh1S1/COpLWUx+RnS9pJ+S6cVcD1kj4BPAF8JC1+K3AyMAz8FvgYQEQ8I+mrwL1pua9ExPiLw2Zm1kZ1hX5ELJug67gaywZw9gTbWQOsqbs6MzMrlP8i18wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsI02HvqS3SdpS9dgr6fOSLpI0WtV+ctU650salrRD0onFvAQzM6vX9GZXjIgdwCIASdOAUeAm4GPAtyPikurlJR0OLAWOAN4M/FTSWyPihWZrMDOzxhQ1vHMc8GhEPLGfZU4FBiPi+Yh4HBgGjilo/2ZmVgdFROsbkdYA90XEZZIuApYDe4FNwLkR8ayky4CNEXFNWudK4LaIuKHG9lYAKwB6e3sXDw4ONlTP2NgYPT09bB3dU7P/qLkzGtpeO1Rq7GausRiusRiusX4DAwObI6K/Vl/LoS/pIOB/gSMi4klJvcBTQABfBeZExMcbCf1q/f39sWnTpoZqGhoaolQq0bfylpr9I6s+2ND22qFSYzdzjcVwjcVwjfWTNGHoFzG8cxLls/wnASLiyYh4ISJeBL7Py0M4o8D8qvXmpTYzM+uQIkJ/GbC2MiNpTlXf6cC2NL0OWCrpYEkLgIXAPQXs38zM6tT03TsAkg4BPgB8uqr565IWUR7eGan0RcR2SdcDDwD7gLN9546ZWWe1FPoR8RzwhnFtH93P8hcDF7eyTzMza57/ItfMLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8uIQ9/MLCMOfTOzjDj0zcwy4tA3M8tIy6EvaUTSVklbJG1KbYdK2iDpkfQ8K7VL0qWShiXdL+noVvdvZmb1K+pMfyAiFkVEf5pfCdwREQuBO9I8wEnAwvRYAVxe0P7NzKwO7RreORW4Kk1fBZxW1X51lG0EZkqa06YazMxsHEVEaxuQHgeeBQL4XkSslvSbiJiZ+gU8GxEzJa0HVkXEz1PfHcB5EbFp3DZXUP4mQG9v7+LBwcGGahobG6Onp4eto3tq9h81d0ZD22uHSo3dzDUWwzUWwzXWb2BgYHPVyMsrTC9g+++JiFFJbwI2SHqoujMiQlJDnywRsRpYDdDf3x+lUqmhgoaGhiiVSixfeUvN/pEzGtteO1Rq7GausRiusRiusRgtD+9ExGh63g3cBBwDPFkZtknPu9Pio8D8qtXnpTYzM+uAlkJf0iGSXleZBk4AtgHrgLPSYmcBN6fpdcCZ6S6eY4E9EbGrlRrMzKx+rQ7v9AI3lYftmQ78KCL+XdK9wPWSPgE8AXwkLX8rcDIwDPwW+FiL+29K30TDPqs+2OFKzMw6q6XQj4jHgLfXaH8aOK5GewBnt7JPMzNrnv8i18wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy4hD38wsIw59M7OMOPTNzDLi0Dczy0jToS9pvqQ7JT0gabukz6X2iySNStqSHidXrXO+pGFJOySdWMQLMDOz+k1vYd19wLkRcZ+k1wGbJW1Ifd+OiEuqF5Z0OLAUOAJ4M/BTSW+NiBdaqMHMzBrQ9Jl+ROyKiPvS9P8BDwJz97PKqcBgRDwfEY8Dw8Axze7fzMwap4hofSNSH3AXcCTwBWA5sBfYRPnbwLOSLgM2RsQ1aZ0rgdsi4oYa21sBrADo7e1dPDg42FA9Y2Nj9PT0sHV0T0PrHTV3RkPLt6JSYzdzjcVwjcVwjfUbGBjYHBH9tfpaGd4BQFIPcCPw+YjYK+ly4KtApOdvAh9vZJsRsRpYDdDf3x+lUqmhmoaGhiiVSixfeUtD642c0dh+WlGpsZu5xmK4xmK4xmK0dPeOpFdRDvxrI+LHABHxZES8EBEvAt/n5SGcUWB+1erzUpuZmXVIK3fvCLgSeDAivlXVPqdqsdOBbWl6HbBU0sGSFgALgXua3b+ZmTWuleGddwMfBbZK2pLavgQsk7SI8vDOCPBpgIjYLul64AHKd/6c7Tt3zMw6q+nQj4ifA6rRdet+1rkYuLjZfZqZWWtavpB7IOmb4MLvyKoPdrgSM7P28M8wmJllxKFvZpYRh76ZWUYc+mZmGXHom5llxKFvZpYRh76ZWUYc+mZmGXHom5llxKFvZpYRh76ZWUb82zt18G/ymNmBwmf6ZmYZ8Zl+C/wNwMz+2PhM38wsIz7TbwN/AzCzbuUzfTOzjDj0zcwy4uGdDqoe9jn3qH0sT/Me9jGzTnHod4GJrgHsjz8ozKwZHQ99SUuA7wDTgB9ExKpO13Ag8MViM2tGR0Nf0jTgu8AHgJ3AvZLWRcQDnazjQNboh8H+vmVUD0FNth0z++PQ6TP9Y4DhiHgMQNIgcCrg0G+zZoaQ2rmdiTT64VTrg6nZfTSqqG9b/tZmnaSI6NzOpA8DSyLik2n+o8A7I+KcccutAFak2bcBOxrc1WzgqRbLbTfXWAzXWAzXWIxuqfHPIuKNtTq68kJuRKwGVje7vqRNEdFfYEmFc43FcI3FcI3F+GOosdP36Y8C86vm56U2MzPrgE6H/r3AQkkLJB0ELAXWdbgGM7NsdXR4JyL2SToHuJ3yLZtrImJ7G3bV9NBQB7nGYrjGYrjGYnR9jR29kGtmZlPLv71jZpYRh76ZWUYOqNCXtETSDknDklZOYR3zJd0p6QFJ2yV9LrUfKmmDpEfS86zULkmXprrvl3R0B2udJum/Ja1P8wsk3Z1quS5dcEfSwWl+OPX3dai+mZJukPSQpAclvavbjqOkv0n/nbdJWivp1VN9HCWtkbRb0raqtoaPm6Sz0vKPSDqrAzV+I/23vl/STZJmVvWdn2rcIenEqva2ve9r1VjVd66kkDQ7zU/JcWxYRBwQD8oXhh8FDgMOAn4BHD5FtcwBjk7TrwMeBg4Hvg6sTO0rga+l6ZOB2wABxwJ3d7DWLwA/Atan+euBpWn6CuCv0/RngSvS9FLgug7VdxXwyTR9EDCzm44jMBd4HHhN1fFbPtXHEXgfcDSwraqtoeMGHAo8lp5npelZba7xBGB6mv5aVY2Hp/f0wcCC9F6f1u73fa0aU/t8yjekPAHMnsrj2PBrmqodF/5C4F3A7VXz5wPnT3VdqZabKf/e0A5gTmqbA+xI098DllUt/9Jyba5rHnAH8H5gffqf9amqN91LxzT9D/6uND09Lac21zcjBarGtXfNcaQc+r9Mb+jp6Tie2A3HEegbF6gNHTdgGfC9qvZXLNeOGsf1nQ5cm6Zf8X6uHMdOvO9r1QjcALwdGOHl0J+y49jI40Aa3qm8+Sp2prYplb6+vwO4G+iNiF2p61dAb5qeqtr/Efgi8GKafwPwm4jYV6OOl2pM/XvS8u20APg18M9pCOoHkg6hi45jRIwClwD/A+yifFw2013HsaLR4zbV76mPUz5zZj+1dLxGSacCoxHxi3FdXVPj/hxIod91JPUANwKfj4i91X1R/sifsvtlJZ0C7I6IzVNVQx2mU/5qfXlEvAN4jvKwxEu64DjOovyjgQuANwOHAEumqp56TfVxm4ykC4B9wLVTXUs1Sa8FvgT83VTX0qwDKfS76iceJL2KcuBfGxE/Ts1PSpqT+ucAu1P7VNT+buBDkkaAQcpDPN8BZkqq/NFedR0v1Zj6ZwBPt7nGncDOiLg7zd9A+UOgm47j8cDjEfHriPg98GPKx7abjmNFo8dtSt5TkpYDpwBnpA+nbqrxzyl/wP8ivXfmAfdJ+tMuqnG/DqTQ75qfeJAk4ErgwYj4VlXXOqBy5f4symP9lfYz09X/Y4E9VV/D2yIizo+IeRHRR/lY/WdEnAHcCXx4ghortX84Ld/WM8WI+BXwS0lvS03HUf4Z7q45jpSHdY6V9Nr0371SY9ccxyqNHrfbgRMkzUrfaE5IbW2j8j+y9EXgQxHx23G1L013Py0AFgL30OH3fURsjYg3RURfeu/spHzTxq/oouO4X1N1MaEdD8pXzx+mfDX/gims4z2UvzrfD2xJj5Mpj93eATwC/BQ4NC0vyv+4zKPAVqC/w/WWePnuncMov5mGgX8FDk7tr07zw6n/sA7VtgjYlI7lTyjf/dBVxxH4e+AhYBvwL5TvMJnS4wispXyN4feUg+kTzRw3yuPqw+nxsQ7UOEx5/LvyvrmiavkLUo07gJOq2tv2vq9V47j+EV6+kDslx7HRh3+GwcwsIwfS8I6ZmU3CoW9mlhGHvplZRhz6ZmYZceibmWXEoW9mlhGHvplZRv4fg/5wVMgi22cAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df.groupby('item')['users_per_item'].first().hist(bins=50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.to_csv('/Users/jilljenn/code/vae/data/mangaki/data.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(user              1958\n",
       " item              2939\n",
       " rating               4\n",
       " items_per_user     391\n",
       " users_per_item     355\n",
       " dtype: int64, user                 1957\n",
       " item                 2938\n",
       " rating            neutral\n",
       " items_per_user       2102\n",
       " users_per_item       1495\n",
       " dtype: object)"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for field in {'user', 'item'}:\n",
    "    df[field] = np.unique(df[field], return_inverse=True)[1]\n",
    "df.nunique(), df.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['favorite', 'neutral', 'like', ..., 'favorite', 'like', 'like'],\n",
       "      dtype='<U8')"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.anonymized.y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset.titles = dict(titles)\n",
    "dataset.categories = dict(categories)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset.save_csv('', suffix='-2020')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{1: 'Death Note',\n",
       " 2: 'Code Geass: Hangyaku no Lelouch',\n",
       " 3: 'Sword Art Online',\n",
       " 4: 'Naruto',\n",
       " 5: \"L'Attaque des Titans\",\n",
       " 6: 'Bleach',\n",
       " 7: 'Fullmetal Alchemist: Brotherhood',\n",
       " 8: 'Fullmetal Alchemist',\n",
       " 9: 'Elfen Lied',\n",
       " 10: 'Angel Beats!',\n",
       " 11: 'Clannad',\n",
       " 12: 'Toradora!',\n",
       " 13: 'Code Geass: Hangyaku no Lelouch R2',\n",
       " 14: 'Soul Eater',\n",
       " 15: 'Tengen Toppa Gurren Lagann',\n",
       " 16: 'Steins;Gate',\n",
       " 17: 'Naruto: Shippuuden',\n",
       " 18: 'Fairy Tail',\n",
       " 19: 'The Future Diary',\n",
       " 20: 'Durarara!!',\n",
       " 21: 'Highschool of the Dead',\n",
       " 22: 'Ao no Exorcist',\n",
       " 23: 'La mélancolie de Haruhi Suzumiya',\n",
       " 24: 'Bakemonogatari',\n",
       " 25: 'Neon Genesis Evangelion',\n",
       " 26: 'Cowboy Bebop',\n",
       " 27: 'One Piece',\n",
       " 28: 'Ouran Koukou Host Club',\n",
       " 29: 'Darker than Black: Kuro no Keiyakusha',\n",
       " 30: 'Spirited Away',\n",
       " 31: 'Clannad: After Story',\n",
       " 32: 'Another',\n",
       " 33: 'Mahou Shoujo Madoka★Magica',\n",
       " 34: 'K-On!',\n",
       " 35: 'Black Butler',\n",
       " 36: 'Ano Hi Mita Hana no Namae wo Bokutachi wa Mada Shiranai.',\n",
       " 37: 'Guilty Crown',\n",
       " 38: 'Higurashi no Naku Koro ni',\n",
       " 39: 'Deadman Wonderland',\n",
       " 40: 'Fate/stay night',\n",
       " 41: 'Samurai Champloo',\n",
       " 42: 'Kaichou wa Maid-sama!',\n",
       " 43: 'KILL la KILL',\n",
       " 44: 'Dragon Ball Z',\n",
       " 45: 'Lucky☆Star',\n",
       " 46: 'Psycho-Pass',\n",
       " 47: 'Baccano!',\n",
       " 48: 'D.Gray-man',\n",
       " 49: 'Fate/Zero',\n",
       " 50: 'Zero no Tsukaima',\n",
       " 51: 'Claymore',\n",
       " 52: 'Hellsing',\n",
       " 53: 'Le Château ambulant',\n",
       " 54: 'Shakugan no Shana',\n",
       " 55: 'No Game No Life',\n",
       " 56: 'Vampire Knight',\n",
       " 57: 'Ore no Imouto ga Konnani Kawaii Wake ga Nai',\n",
       " 58: 'Spice & Wolf',\n",
       " 59: 'FLCL',\n",
       " 60: 'Princess Mononoke',\n",
       " 61: 'Black Lagoon',\n",
       " 62: 'Chobits',\n",
       " 63: '5 centimètres par seconde',\n",
       " 64: 'Chuunibyou demo Koi ga Shitai!',\n",
       " 65: 'Toaru Majutsu no Index',\n",
       " 66: 'Rosario to Vampire',\n",
       " 67: 'Hyouka',\n",
       " 68: 'Full Metal Panic!',\n",
       " 69: 'Dragon Ball',\n",
       " 70: 'Baka to Test to Shoukanjuu',\n",
       " 71: 'Higashi no Eden',\n",
       " 72: 'Trigun',\n",
       " 73: 'Gintama',\n",
       " 74: 'Kimi ni Todoke',\n",
       " 75: 'High School DxD',\n",
       " 76: 'Boku wa Tomodachi ga Sukunai',\n",
       " 77: 'Accel World',\n",
       " 78: 'NHK ni Youkoso!',\n",
       " 79: 'InuYasha',\n",
       " 80: 'School Days',\n",
       " 81: 'Hataraku Maou-sama!',\n",
       " 82: 'Toki wo Kakeru Shoujo',\n",
       " 83: 'Kami nomi zo Shiru Sekai (Que sa volonté soit faite)',\n",
       " 84: 'Tonari no Kaibutsu-kun',\n",
       " 85: 'Fruits Basket',\n",
       " 86: 'Is this a Zombie ?',\n",
       " 87: 'Sword Art Online II',\n",
       " 88: 'Sakurasou no Pet na Kanojo',\n",
       " 89: 'Mushishi',\n",
       " 90: 'Great Teacher Onizuka',\n",
       " 91: 'Log Horizon',\n",
       " 92: 'Suzumiya Haruhi no Yuuutsu (2009)',\n",
       " 93: 'Btooom!',\n",
       " 94: 'Katekyo Hitman Reborn!',\n",
       " 95: 'Noragami',\n",
       " 96: 'Eureka Seven',\n",
       " 97: 'Ergo Proxy',\n",
       " 98: 'Hellsing Ultimate',\n",
       " 99: 'Kyoukai no Kanata',\n",
       " 100: 'Tokyo Ghoul',\n",
       " 101: 'K-On!!',\n",
       " 102: 'Fate/Zero 2nd Season',\n",
       " 103: 'Pandora Hearts',\n",
       " 104: 'Blood+',\n",
       " 105: 'Rurouni Kenshin: Meiji Kenkaku Romantan',\n",
       " 106: 'Mon voisin Totoro',\n",
       " 107: 'Kuroko no Basket',\n",
       " 108: 'Zero no Tsukaima: Futatsuki no Kishi',\n",
       " 109: 'IS: Infinite Stratos',\n",
       " 110: 'Suzumiya Haruhi no Shoushitsu',\n",
       " 111: 'Lovely★Complex',\n",
       " 112: 'Higurashi no Naku Koro ni Kai',\n",
       " 113: 'Air',\n",
       " 114: 'Darker than Black: Ryuusei no Gemini',\n",
       " 115: 'Toaru Kagaku no Railgun',\n",
       " 116: 'Nisemonogatari',\n",
       " 117: 'K',\n",
       " 118: 'Vampire Knight Guilty',\n",
       " 119: 'Bakuman.',\n",
       " 120: 'Kokoro Connect',\n",
       " 121: 'Shiki',\n",
       " 122: 'Magi: The Labyrinth of Magic',\n",
       " 123: 'Pokemon',\n",
       " 124: 'Kuroshitsuji II',\n",
       " 125: 'Fullmetal Alchemist: The Conqueror of Shamballa',\n",
       " 126: 'Dragon Ball GT',\n",
       " 127: 'Hunter x Hunter',\n",
       " 128: 'My Teen Romantic Comedy SNAFU',\n",
       " 129: 'Gosick',\n",
       " 130: 'Air Gear',\n",
       " 131: 'Free!',\n",
       " 132: 'Neon Genesis Evangelion: The End of Evangelion',\n",
       " 133: 'Danganronpa: Kibou no Gakuen to Zetsubou no Koukousei',\n",
       " 134: 'Summer Wars',\n",
       " 135: 'Date A Live',\n",
       " 136: 'Azumanga Daioh',\n",
       " 137: 'Shinsekai yori',\n",
       " 138: 'Zero no Tsukaima: Princesses no Rondo',\n",
       " 139: 'Full Metal Panic? Fumoffu',\n",
       " 140: 'Akame ga Kill!',\n",
       " 141: 'Zetsuen no Tempest',\n",
       " 142: 'Sora no Otoshimono',\n",
       " 143: 'To LOVE-Ru',\n",
       " 144: 'Rosario to Vampire Capu2',\n",
       " 145: 'Shakugan no Shana II',\n",
       " 146: 'Watashi ga Motenai no wa Dou Kangaetemo Omaera ga Warui!',\n",
       " 147: 'Serial Experiments Lain',\n",
       " 148: 'Black Lagoon: The Second Barrage',\n",
       " 149: 'Nisekoi',\n",
       " 150: 'Danshi Koukousei no Nichijou',\n",
       " 151: 'The Tatami Galaxy',\n",
       " 152: 'The Tatami Galaxy Specials',\n",
       " 153: 'D.C.S.S. ~Da Capo Second Season~',\n",
       " 154: 'Armitage III: Dual-Matrix',\n",
       " 155: 'Dual! Parallel Trouble Adventure',\n",
       " 156: 'Dual Parallel! Trouble Adventures Special',\n",
       " 157: 'Sailor Victory',\n",
       " 158: 'Ghost in the Shell: S.A.C. 2nd GIG - Individual Eleven',\n",
       " 159: 'Graduation',\n",
       " 160: 'Sotsugyou M: Oretachi no Carnival',\n",
       " 161: 'Doukyuusei 2 Special: Sotsugyousei',\n",
       " 162: 'Omoide no Album',\n",
       " 163: 'Ghost in the Shell: Stand Alone Complex 2nd GIG - Individual Eleven - Tachikomatic Days',\n",
       " 164: 'Manga Jinbutsushi',\n",
       " 165: 'Die Now',\n",
       " 166: 'Code Geass: Lelouch of the Rebellion Picture Drama',\n",
       " 167: 'Code Geass: Hangyaku no Lelouch Recaps',\n",
       " 168: 'Bleach the Movie 2: The DiamondDust Rebellion',\n",
       " 169: 'Toshokan Sensou',\n",
       " 170: 'Code Geass: Lelouch of the Rebellion Special Edition Black Rebellion',\n",
       " 171: 'Fuuma no Kojirou: Fuuma Hanran-hen',\n",
       " 172: 'Code Geass: Lelouch of the Rebellion R2 Special Edition Zero Requiem',\n",
       " 173: 'Spooky Kitaro: Crash!! The Great Rebellion of the Multi-Dimensional Yōkai',\n",
       " 174: 'Code Geass: Lelouch of the Rebellion R2 Extra Flash - Baba Theater Redux',\n",
       " 175: \"Queen's Blade: Rebellion\",\n",
       " 176: 'Puella Magi Madoka Magica the Movie Part 3: Rebellion',\n",
       " 177: \"Queen's Blade: Rebellion Specials\",\n",
       " 178: \"Queen's Blade Rebellion vs. Hagure Yuusha no Estetica\",\n",
       " 179: 'Puella Magi Madoka Magica the Movie Part 1: Beginnings',\n",
       " 180: 'Puella Magi Madoka Magica the Movie Part 2: Eternal',\n",
       " 181: 'Mahou Shoujo Madoka★Magica Movie 3: Hangyaku no Monogatari - Magica Quartet x Nisioisin',\n",
       " 182: 'Step Up Love Story',\n",
       " 183: 'Clannad - Movie',\n",
       " 184: 'Clannad: Another World, Tomoyo Chapter',\n",
       " 185: 'Clannad After Story: Another World, Kyou Chapter',\n",
       " 186: 'Saikano: Another Love Song',\n",
       " 187: 'King of Fighters: Another Day',\n",
       " 188: '.hack//Intermezzo',\n",
       " 189: 'Wild 7 Another',\n",
       " 190: 'Another Lady Innocent',\n",
       " 191: 'Gift: Eternal Rainbow Special',\n",
       " 192: 'ToHeart 2 AD',\n",
       " 193: 'To Heart 2 AD Plus',\n",
       " 194: 'Prince of Tennis: Another Story - Messages From Past and Future',\n",
       " 195: 'Fullmetal Alchemist: Brotherhood OVA Collection',\n",
       " 196: 'Usavich Special',\n",
       " 197: 'Prince of Tennis: Another Story - Messages From Past and Future OVA Bonus',\n",
       " 198: 'Ichiban Ushiro no Daimaou Specials',\n",
       " 199: 'Angel Beats!: Another Epilogue',\n",
       " 200: 'Prince of Tennis: Another Story II - Ano Toki no Bokura',\n",
       " 201: 'Another: The Other',\n",
       " 202: 'Nyaruko: Crawling With Love!',\n",
       " 203: 'Prince of Tennis: Another Story II - Ano Toki no Bokura OVA Bonus',\n",
       " 204: \"Problem Children Are Coming From Another World, Aren't They?\",\n",
       " 205: 'Nyaruko: Crawling With Love! Second Season',\n",
       " 206: 'Lupin III: Touhou Kenbunroku - Another Page',\n",
       " 207: 'Sengoku Basara Movie: 4-Koma Gekijou - Another Last Party',\n",
       " 208: 'Ghost in the Shell: Arise - Another Mission',\n",
       " 209: 'Another Special',\n",
       " 210: 'Goannai Shimasu Another World e',\n",
       " 211: 'Detective Conan Movie 18: The Sniper from Another Dimension',\n",
       " 212: 'Persona 4 The Golden Animation: Thank you Mr. Accomplice',\n",
       " 213: 'Mobile Suit Gundam 0083: The Afterglow Of Zeon',\n",
       " 214: 'Matou Kitan Zankan!',\n",
       " 215: 'Terror in Resonance',\n",
       " 216: 'Crush Gear Turbo The Movie - Kaiservern’s Ultimate Challenge',\n",
       " 217: 'Monster',\n",
       " 218: 'Beck',\n",
       " 219: 'Destiny of the Shrine Maiden',\n",
       " 220: 'Diamond Daydreams',\n",
       " 221: \"Welcome to Pia Carrot! Sayaka's Love Story\",\n",
       " 222: 'Gankutsuou: The Count of Monte Cristo',\n",
       " 223: 'Mahoromatic - Something More Beautiful',\n",
       " 224: 'Requiem from the Darkness',\n",
       " 225: 'Crest of the Stars',\n",
       " 226: \"Akahori's Heretical Hour Love Game\",\n",
       " 227: 'Emma: A Victorian Romance',\n",
       " 228: 'Kaleido Star: Legend of Phoenix - The Layla Hamilton Story',\n",
       " 229: 'Yu-Gi-Oh!',\n",
       " 230: 'Yu-Gi-Oh! GX',\n",
       " 231: 'Saiyuki: Requiem',\n",
       " 232: 'Demon City Shinjuku',\n",
       " 233: 'Doraemon',\n",
       " 234: 'Pokemon: The First Movie',\n",
       " 235: 'Digimon Adventure',\n",
       " 236: 'Key Princess Story Eternal Alice Rondo',\n",
       " 237: 'PopoloCrois',\n",
       " 238: \"I'm Gonna Be an Angel!\",\n",
       " 239: 'Lemon Angel Project',\n",
       " 240: 'First Kiss Story',\n",
       " 241: 'RahXephon: Harmonic Convergence',\n",
       " 242: 'Kishin Houkou Demonbane',\n",
       " 243: 'Tenamonya Voyagers',\n",
       " 244: 'Prince of Tennis: Atobe Kara no Okurimono',\n",
       " 245: 'Milk Money',\n",
       " 246: 'Gash Bell The 1st Movie: Unlisted Demon',\n",
       " 247: 'Neighborhood Stories',\n",
       " 248: 'The One Being Sung',\n",
       " 249: 'Digimon Data Squad',\n",
       " 250: 'Digimon Tamers',\n",
       " 251: 'The Story of Saiunkoku',\n",
       " 252: 'Those Who Hunt Elves',\n",
       " 253: 'Those Who Hunt Elves II',\n",
       " 254: 'Tokyo Daigaku Monogatari',\n",
       " 255: 'Roar of the Machine God Demonbane (2006)',\n",
       " 256: 'Netrun-mon the Movie',\n",
       " 257: 'Wicked City',\n",
       " 258: 'Monster Extra',\n",
       " 259: 'Pokemon: The Movie 2000',\n",
       " 260: 'Pokemon 3: The Movie',\n",
       " 261: 'Pokemon 4Ever',\n",
       " 262: 'Rose of Versailles',\n",
       " 263: 'One Piece: Baron Omatsuri and the Secret Island',\n",
       " 264: 'Zatch Bell Movie 2',\n",
       " 265: 'Dragon Ball Z Special 1: Bardock, The Father of Goku',\n",
       " 266: 'Lupin III: Farewell to Nostradamus',\n",
       " 267: 'Bartender',\n",
       " 268: 'Harlock Saga: The Ring of the Nibelung',\n",
       " 269: 'Barom One',\n",
       " 271: \"Gen d'Hiroshima\",\n",
       " 272: \"Gen d'Hiroshima 2\",\n",
       " 273: 'Yu Yu Hakusho: Eizou Hakusho II',\n",
       " 274: 'Red Baron',\n",
       " 275: 'Akihabara Dennou Gumi',\n",
       " 276: 'Akihabara Dennou Gumi: 2011 Nen no Natsuyasumi',\n",
       " 277: 'Doraemon: Ganbare! Gian!!',\n",
       " 278: 'Barbapapa',\n",
       " 279: 'Barbapapa Around the World',\n",
       " 280: 'Pokemon Mystery Dungeon: Team Go-Getters Out of the Gate!',\n",
       " 281: 'Legend of the Mystical Ninja',\n",
       " 282: 'Energetic Bomb Ganbaruger',\n",
       " 283: 'Fight! Kickers',\n",
       " 284: 'Ganbare Genki',\n",
       " 285: 'Kinnikuman: Ooabare! Seigi Choujin',\n",
       " 286: 'Stop!! Hibari-kun!',\n",
       " 287: 'Ganbarist! Shun',\n",
       " 289: 'Linebarrels of Iron',\n",
       " 290: 'Nabari no Ou',\n",
       " 291: 'Moonlight Pierce',\n",
       " 292: 'Rose of Versailles Movie',\n",
       " 293: 'Suna no Bara: Yuki no Mokushiroku',\n",
       " 294: 'Hoero! Bun Bun',\n",
       " 296: 'Bari Bari Densetsu',\n",
       " 297: 'La Rose de Versailles',\n",
       " 298: 'Yobarete Tobidete Akubi-chan',\n",
       " 299: 'Chounouryoku Shoujo Barabanba',\n",
       " 300: 'Minami-ke Betsubara',\n",
       " 301: \"The Larks' Moving Day\",\n",
       " 302: 'Maiden Rose',\n",
       " 303: '21-Emon: To Space! The Barefoot Princess',\n",
       " 304: 'Psychoarmor Govarian',\n",
       " 305: 'Minky Momo: The Station of Your Memories',\n",
       " 306: 'King of Thorn',\n",
       " 307: 'Choujin Sentai Baratack',\n",
       " 308: 'Briar-Rose or The Sleeping Beauty',\n",
       " 309: 'Lady Oscar Special',\n",
       " 310: 'Julie the Wild Rose',\n",
       " 311: 'Bara no Hana to Joe',\n",
       " 312: 'Agukaru',\n",
       " 313: 'The Mystic Archives of Dantalian: Ibarahime',\n",
       " 314: 'Sasami-san@Ganbaranai',\n",
       " 315: 'Maiden Rose Specials',\n",
       " 316: 'Glass no Kamen Desu ga the Movie: Onna Spy no Koi! Murasaki no Bara wa Kiken na Kaori!?',\n",
       " 317: 'Senbon Matsubara',\n",
       " 318: 'Barakamon',\n",
       " 319: 'Subarashii Sekai Ryokou: Alaska no Tabi \"Daigo Hyougaki\"',\n",
       " 320: 'Agukaru Agriculture Angel Baraki: Play with Ibaraki Hen',\n",
       " 321: 'Barakamon: Mijikamon',\n",
       " 322: 'Kinken Chochiku Shiobara Tasuke',\n",
       " 323: 'Ikiteirutte Subarashii!',\n",
       " 324: 'Paprika',\n",
       " 325: 'Millennium Actress',\n",
       " 326: 'Perfect Blue',\n",
       " 327: 'Tokyo Underground',\n",
       " 328: 'Bubblegum Crisis Tokyo 2040',\n",
       " 329: 'Tokyo Mew Mew',\n",
       " 330: 'Tokyo Godfathers',\n",
       " 331: 'Tokyo Babylon',\n",
       " 332: 'Ten Tokyo Warriors',\n",
       " 333: 'Tokyo Revelation',\n",
       " 334: 'Lupin III: Crisis in Tokyo',\n",
       " 335: 'Tokyo Tribe 2',\n",
       " 336: 'Tokyo Majin Gakuen Kenpucho: Tou',\n",
       " 337: 'The Tokyo Project',\n",
       " 338: 'Tokyo Pig',\n",
       " 339: 'Tokyo Majin Gakuen Kenpucho: Tou Dai Ni Maku',\n",
       " 340: 'Tsubasa: Tokyo Revelations',\n",
       " 341: 'Tokyo Marble Chocolate',\n",
       " 342: 'Chu2',\n",
       " 343: 'Momone',\n",
       " 344: 'Tokyo Requiem',\n",
       " 345: 'Shin SOS Dai Tokyo Tankentai',\n",
       " 346: 'Tokyo Loop',\n",
       " 347: 'Tokyo Magnitude 8.0',\n",
       " 348: 'Tokyo Magnitude 8.0 Recap',\n",
       " 349: 'Shin Tenchi Muyo! Specials',\n",
       " 350: 'GYO: Tokyo Fish Attack',\n",
       " 351: 'Detective Conan Magic File 5: Niigata - Tokyo Omiyage Capriccio',\n",
       " 352: 'Where Dreams Come True',\n",
       " 353: 'Tokyo Ravens',\n",
       " 354: 'Boku no Imouto wa \"Osaka Okan\": Uchi no Onii-chan wa Tokyo Rule',\n",
       " 355: 'Marginal Prince: Gekkeiju no Ouji-tachi - Tokyo Merry-Go-Round',\n",
       " 356: 'Tokyo ESP',\n",
       " 357: 'Tokyo Ravens Specials',\n",
       " 358: 'Passage of Time: Tokyo Station',\n",
       " 359: 'Tokyo Babylon: Vision',\n",
       " 360: 'Tokyo Juushouden: Fuuma Gogyou Denshou',\n",
       " 361: 'Tokyo Ghoul √A',\n",
       " 362: 'Tokyo Fantasia',\n",
       " 363: 'Iriya no Sora, UFO no Natsu',\n",
       " 364: 'Sandglass of Summer Colors',\n",
       " 365: 'Mahoromatic Summer Special',\n",
       " 366: 'Air in Summer',\n",
       " 367: 'True Love Story Summer Days, and yet...',\n",
       " 368: \"xxxHOLiC - A Midsummer Night's Dream\",\n",
       " 369: 'Sugar: A Little Snow Fairy Summer Special',\n",
       " 370: 'Nasu: Summer in Andalusia',\n",
       " 371: 'Wet Summer Days',\n",
       " 372: 'Can Can Bunny',\n",
       " 373: 'Lupin III: Nusumareta Lupin',\n",
       " 374: 'Magic Teacher Negima! Summer OVA',\n",
       " 375: 'Di Gi Charat Summer Special 2000',\n",
       " 376: 'Doraemon: Summer Holiday',\n",
       " 377: \"Candy Candy: Candy's Summer Vacation\",\n",
       " 378: 'Un été avec Coo',\n",
       " 379: \"La Corda D'Oro: Primo Passo - A Summer Encore\",\n",
       " 380: 'Crayon Shin-Chan: Den-O vs. Shin-O',\n",
       " 381: 'Kuro ga Ita Natsu',\n",
       " 382: 'Nodame Cantabile Special',\n",
       " 383: \"Someday's Dreamers II Sora\",\n",
       " 384: 'Septem Charm Magical Kanan: SP Summer Camp',\n",
       " 385: 'End of Summer 2',\n",
       " 386: 'Hell Teacher Nube: Summer Holiday of Fear! Legend of the Sea of Suspicion',\n",
       " 387: 'Suika',\n",
       " 388: \"Pokemon: Pikachu's Summer Vacation\",\n",
       " 389: 'Summer Storm!',\n",
       " 390: \"Pokemon: Pikachu's Summer Festival!\",\n",
       " 391: 'Nijiiro Hotaru: Eien no Natsuyasumi',\n",
       " 392: 'Pico: My Little Summer Story',\n",
       " 393: 'Summer Storm! Open for Business',\n",
       " 394: 'Ookiku Furikabutte: Natsu no Taikai Hen',\n",
       " 395: 'Mahou Shoujo Lalabel: Umi ga Yobu Natsuyasumi',\n",
       " 396: 'Natsufuku No Shoujotachi',\n",
       " 397: 'The Summer of Dioxin',\n",
       " 398: 'Touhou Niji Sousaku Doujin Anime: Musou Kakyou',\n",
       " 399: 'Samurai X Recap',\n",
       " 400: 'Tantei Opera Milky Holmes: Summer Special',\n",
       " 401: \"Pokemon: Pikachu's Summer Bridge Story\",\n",
       " 402: 'Paper Rabbit Rope: Wait Last One For Summer Vacation For Real!?',\n",
       " 403: 'Prince Mackaroo the Movie: The Promised Summer - Ojaru and Semira',\n",
       " 404: \"Ein's Summer Vacation\",\n",
       " 405: 'Natsuyasumi.',\n",
       " 406: \"Persona 3 the Movie: #2 Midsummer Knight's Dream\",\n",
       " 407: 'A Gaze in Summer 1942',\n",
       " 408: 'Dragon Ball Z: Summer Vacation Special',\n",
       " 409: 'Kara no Kyoukai: Mirai Fukuin - Extra Chorus',\n",
       " 410: 'Porco Rosso',\n",
       " 411: 'Shin Kyouhaku 2 The Animation: Kizu ni Saku Hana Senketsu no Kurenai',\n",
       " 412: 'Harukanaru Toki no Naka de 3: Kurenai no Tsuki',\n",
       " 413: 'Kurenai',\n",
       " 414: 'Harukanaru Toki no Naka de 3: Onsen Chibi Special',\n",
       " 415: 'Judo Boy',\n",
       " 416: 'Kure-nai OVA',\n",
       " 417: 'Piano no Mori',\n",
       " 418: 'Nanmu Ichibyousokusai',\n",
       " 419: 'Mawaru Penguindrum',\n",
       " 420: 'Okane wa Mawaru: Kurashi to Kinyuu',\n",
       " 421: '.hack//Sign',\n",
       " 423: '.hack//Liminality',\n",
       " 424: '.hack//Gift',\n",
       " 425: '.hack//roots',\n",
       " 426: '.hack//Unison',\n",
       " 427: '.hack//Legend of the Twilight Offline Meeting Special',\n",
       " 428: '.hack//G.U. Returner',\n",
       " 429: '.hack//G.U. Trilogy',\n",
       " 430: '.hack//G.U. Trilogy: Parody Mode',\n",
       " 431: '.hack//Quantum',\n",
       " 432: '.hack//Quantum Specials',\n",
       " 433: '.hack//The Movie: Sekai no Mukou ni',\n",
       " 434: '.hack//Versus: The Thanatos Report',\n",
       " 435: 'Machine Robo: Butchigiri Battle Hackers',\n",
       " 436: 'Hacka Doll',\n",
       " 437: 'Lupin the Third :  Lupin Sansei no Theme',\n",
       " 438: 'Lupin tai Holmes',\n",
       " 439: 'Lupin the Third, The Woman Called Fujiko Mine',\n",
       " 440: 'Kaitou Lupin: 813 no Nazo',\n",
       " 441: 'Lupin the IIIrd: Jigen Daisuke no Bohyou',\n",
       " 442: 'Lupin the Third (2015)',\n",
       " 443: 'Lupin III',\n",
       " 444: 'Lupin III: Alcatraz Connection',\n",
       " 445: 'Lupin III: Angel Tactics',\n",
       " 446: 'Lupin III: Goodbye Lady Liberty',\n",
       " 447: 'Lupin III: Dead or Alive',\n",
       " 448: 'Lupin III: Dragon of Doom',\n",
       " 449: 'Lupin III Episode 0: The First Contact',\n",
       " 450: 'Lupin III: Bank of Liberty',\n",
       " 451: 'Lupin III: The Hemingway Paper Mystery',\n",
       " 452: 'Lupin III: Missed by a Dollar',\n",
       " 453: 'Lupin III: Napoleon',\n",
       " 454: 'Lupin III: Otakara Henkyaku Daisakusen!!',\n",
       " 455: 'Lupin III: Part II',\n",
       " 456: 'Lupin III: Part III',\n",
       " 457: 'Lupin III: Return of Pycal',\n",
       " 458: 'Lupin III: Secret File',\n",
       " 459: 'Lupin III: The Castle of Cagliostro',\n",
       " 460: 'Lupin III: The Columbus Files',\n",
       " 461: 'Lupin III: The Fuma Conspiracy',\n",
       " 462: 'Lupin III: The Legend of the Gold of Babylon',\n",
       " 463: \"Lupin III: The Pursuit of Harimao's Treasure\",\n",
       " 464: 'Lupin III: The Secret of Mamo',\n",
       " 465: 'Lupin III: The Secret of Twilight Gemini',\n",
       " 466: 'Lupin III: Voyage to Danger',\n",
       " 467: 'Lupin III: Island of Assassins',\n",
       " 468: 'Lupin III: Elusiveness of the Fog',\n",
       " 469: 'Lupin III: Green vs. Red',\n",
       " 470: 'Lupin III: Seven Days Rhapsody',\n",
       " 471: 'Lupin III: Sweet Lost Night',\n",
       " 472: 'Lupin III: Pilot Film',\n",
       " 473: 'Lupin III vs. Detective Conan',\n",
       " 474: 'Lupin III: The Last Job',\n",
       " 475: 'Lupin III: Chi no Kokuin - Eien no Mermaid',\n",
       " 476: 'Lupin III: Lupin Ikka Seizoroi',\n",
       " 477: 'Lupin VIII',\n",
       " 478: 'Lupin Shanshei',\n",
       " 479: 'Lupin III vs. Detective Conan: The Movie',\n",
       " 480: 'Lupin III: Princess of the Breeze - Kakusareta Kuuchuu Toshi',\n",
       " 481: 'Black Cat',\n",
       " 482: 'Black Cat Special',\n",
       " 483: 'The Black Cat',\n",
       " 484: 'Tsuritama',\n",
       " 485: 'Nozoki Ana',\n",
       " 486: 'Nozo x Kimi',\n",
       " 487: 'Fullmetal Alchemist: Premium OVA Collection',\n",
       " 488: 'Yawara! Sore Yuke Koshinuke Kids!!',\n",
       " 489: \"Rock'n Roll Kids\",\n",
       " 490: 'Dorami-chan: Hello Kyouryuu Kids!!',\n",
       " 491: 'Master Hamsters',\n",
       " 492: 'Vampiyan Kids',\n",
       " 493: 'Dinosaur King',\n",
       " 494: 'Vampiyan Kids: Pilot',\n",
       " 495: 'Emergency Departure Rescue Kids',\n",
       " 496: 'Dinosaur King D-Kids Adevnture: Pterosaur Legend',\n",
       " 497: 'Ultraman Kids no Kotowaza Monogatari',\n",
       " 498: 'Ultraman Kids Looking for Mother for 30000000 Light Years',\n",
       " 499: 'Golden Kids',\n",
       " 500: 'Ultraman Kids: M7.8 Sei no Yukai na Nakama',\n",
       " 501: 'Kids on the Slope',\n",
       " 502: 'Shinjuku Shin-chan: Yoiko no Koutsuu Anzen',\n",
       " 503: 'Konpora Kid',\n",
       " 504: 'Kappamaki and the Sushi Kids',\n",
       " 505: 'Vampiyan Kids Specials',\n",
       " 506: 'Vampiyan Kids Promotion',\n",
       " 507: 'Chinese Kids',\n",
       " 508: 'Boys Over Flowers',\n",
       " 509: 'Hanaukyo Maids',\n",
       " 510: 'Hanaukyo Maid-Tai: La Verite',\n",
       " 511: 'Kanon Kazahana',\n",
       " 512: 'Ranma ½: Nihao My Concubine',\n",
       " 513: 'Maid in Hanaukyo',\n",
       " 514: 'A Little Snow Fairy Sugar',\n",
       " 515: 'Yonna in the Solitary Fortress',\n",
       " 516: 'Shakugan no Shana Specials',\n",
       " 517: \"UFO Ultramaiden Valkyrie 3: Bride of Celestial Souls' Day\",\n",
       " 518: 'Shakugan no Shana SP: Koi to Onsen no Kougai Gakushuu!',\n",
       " 519: 'Di Gi Charat Ohanami Special',\n",
       " 520: 'Bride of Darkness',\n",
       " 521: 'Shakugan no Shana: The Movie',\n",
       " 522: 'Slam Dunk Movie 2',\n",
       " 523: 'Hanada Shounen-shi',\n",
       " 524: 'Hana Yori Dango (Movie)',\n",
       " 525: 'The Fashion Boy is Cool',\n",
       " 526: 'My Bride is a Mermaid',\n",
       " 527: 'Kakyuusei 2: Ki Hanashi Atsumari (Anthology)',\n",
       " 528: 'Flower Angel',\n",
       " 529: 'Slam Dunk Movie 3',\n",
       " 530: 'Slam Dunk Movie 4',\n",
       " 531: 'Hana no Mahou Tsukai Mary Bell',\n",
       " 532: 'The Secret Garden',\n",
       " 533: 'Foxy Nudes',\n",
       " 534: 'Shakugan no Shana Movie Special',\n",
       " 535: 'Hana Dorei',\n",
       " 536: 'Flower & Snake The Animation',\n",
       " 537: 'Shakugan no Shana II (Second) Specials',\n",
       " 538: 'Pokemon: Giratina and the Sky Warrior',\n",
       " 539: 'Hanappe Bazooka',\n",
       " 540: 'Seto no Hanayome OVA',\n",
       " 541: 'Watt Poe',\n",
       " 542: 'Seto no Hanayome Fan Disc',\n",
       " 543: 'Hanasakeru Seishounen',\n",
       " 544: 'Bride of Deimos',\n",
       " 545: 'Sweet Blue Flowers',\n",
       " 546: 'Shakugan no Shana: Naze Nani Shana',\n",
       " 547: 'Scary High School Rumors',\n",
       " 548: 'Tamagotchi Honto no Hanashi',\n",
       " 549: 'Usahana: Yumemiru Ballerina',\n",
       " 550: 'Shakugan no Shana S: OVA Series',\n",
       " 551: 'Hanamaru Kindergarten',\n",
       " 552: 'Namakura Gatana',\n",
       " 553: 'Hanasakeru Seishounen Recaps',\n",
       " 554: 'Prétear: The New Legend of Snow White',\n",
       " 555: 'Saiyuki',\n",
       " 556: 'Saiyuki Reload',\n",
       " 557: 'Saiyuki Gunlock',\n",
       " 558: 'Naruto the Movie: Ninja Clash in the Land of Snow',\n",
       " 559: 'The Snow Queen',\n",
       " 560: 'Patalliro Saiyuuki!',\n",
       " 561: 'Yukikaze',\n",
       " 562: 'Spaceketeers',\n",
       " 563: 'Miyuki-chan in Wonderland',\n",
       " 564: 'Futari wa Precure: Max Heart Movie 2 - Yukizora no Tomodachi',\n",
       " 565: 'Super Pig',\n",
       " 566: 'Saiyuuki Reload: Burial',\n",
       " 567: 'Miyuki',\n",
       " 568: 'Hidden Leaf Village Grand Sports Festival',\n",
       " 569: 'Gokudo',\n",
       " 570: 'Doraemon: Nobita no Parallel Saiyuuki',\n",
       " 571: 'Karma Saiyuki',\n",
       " 572: 'Gensoumaden Saiyuuki OVA',\n",
       " 573: 'Ai Yori Aoshi: Enishi - Miyuki',\n",
       " 574: 'The Legend of Snow White',\n",
       " 575: 'Kama Sutra',\n",
       " 576: 'Dragoon',\n",
       " 577: 'Saiyuki Interactive',\n",
       " 578: 'Alakazam the Great',\n",
       " 579: 'Snow Night Stories',\n",
       " 580: 'Adrift in the Pacific',\n",
       " 581: 'Pyu to Fuku! Jaguar: Ima, Fuki ni Yukimasu',\n",
       " 582: 'Masaru Ashita no Yukinojou 2',\n",
       " 583: 'Shin Ruri-iro no Yuki',\n",
       " 584: \"Tomorrow's Yukinojou\",\n",
       " 585: 'King Fang',\n",
       " 586: 'Yuki Terai',\n",
       " 587: 'Saiyuuki: Son Gokuu Monogatari',\n",
       " 588: 'Yuki: Snow Fairy',\n",
       " 589: 'Saiyuuki Gaiden',\n",
       " 590: 'Tie Shan Gongzhu',\n",
       " 591: 'Les Enfants Loups : Ame & Yuki',\n",
       " 592: 'Bishoujo Animerama: Miyuki-chan SOS-H Shichauzo',\n",
       " 593: 'Natsuyuki Rendezvous',\n",
       " 594: 'Yuki no Taiyou Pilot',\n",
       " 595: 'Yukiwatari',\n",
       " 596: 'Saiyuuki Gaiden: Tokubetsu-hen - Kouga no Shou',\n",
       " 597: 'Hello Kitty in Snow White',\n",
       " 598: 'Viva Namida',\n",
       " 599: 'Natsume Yuujinchou: Itsuka Yuki no Hi ni',\n",
       " 600: 'Sailor Moon',\n",
       " 601: 'Sailor Moon R: The Movie - The Promise of the Rose',\n",
       " 602: 'Sailor Moon S',\n",
       " 603: 'Sailor Moon R',\n",
       " 604: 'Sailor Moon Sailor Stars',\n",
       " 605: 'Sailor Moon S Movie: Hearts in Ice',\n",
       " 606: 'Sailor Moon SuperS',\n",
       " 607: 'Sailor Moon SuperS the Movie: Black Dream Hole',\n",
       " 608: \"Sailor Moon SuperS Plus: Ami's First Love\",\n",
       " 609: 'Arabian Nights: Sindbad no Bouken (TV)',\n",
       " 610: 'Bishoujo Senshi Sailor Moon R: Make Up! Sailor Senshi',\n",
       " 611: 'Bishoujo Senshi Sailor Moon SuperS Special',\n",
       " 612: 'Sexy Sailor Soldiers',\n",
       " 613: 'Venus 5',\n",
       " 614: 'Pretty Soldier Sailor Moon Memorial',\n",
       " 615: 'Sailor Fuku Shinryou Tsumaka',\n",
       " 616: 'Bishoujo Senshi Sailor Moon: Sailor Stars - Hero Club',\n",
       " 617: 'Pretty Guardian Sailor Moon: Crystal',\n",
       " 618: 'Chiisana Ahiru no Ooki na Ai no Monogatari: Ahiru no Kwak',\n",
       " 619: 'Winter Sonata',\n",
       " 620: 'Winter Sonata Episode 0',\n",
       " 621: 'The Kabocha Wine: Nita no Aijou Monogatari',\n",
       " 622: 'Tamako Love Story',\n",
       " 623: 'Megumi to Taiyou: Kajuu Gummi Tweet Love Story',\n",
       " 624: 'Ore Monogatari!!',\n",
       " 625: 'Junjou Romantica',\n",
       " 626: 'Junjou Romantica 2',\n",
       " 627: 'Junjou Romantica Special',\n",
       " 628: 'Junjou Romantica (OVA)',\n",
       " 629: 'Junjou Shoujo Et Cetera',\n",
       " 630: 'Junjou Romantica 3',\n",
       " 631: 'Love Stage!!',\n",
       " 632: 'Love Stage!! OVA',\n",
       " 633: 'RahXephon',\n",
       " 634: 'Maburaho',\n",
       " 635: 'RahXephon Interlude: Her and Herself/Thatness and Thereness',\n",
       " 636: 'Gude Crest: The Emblem of Gude',\n",
       " 637: 'A Little Princess Sara',\n",
       " 638: 'Neko Rahmen',\n",
       " 639: 'Uchuu Kaizoku Sara',\n",
       " 640: 'RahXephon Specials',\n",
       " 641: 'Pandora Hearts Specials',\n",
       " 642: 'Shirahata no Shoujo Ryuuko',\n",
       " 643: 'Uchuu Kaizoku Sara: Bonus Video',\n",
       " 644: 'Neko Ramen: Ore no Shouyu Aji',\n",
       " 645: 'Martian Successor Nadesico: The Prince of Darkness',\n",
       " 646: 'Bastard!!',\n",
       " 647: 'Traveller Yami, Hat and Book',\n",
       " 648: 'Descendants of Darkness',\n",
       " 649: 'Nightwalker: The Midnight Detective',\n",
       " 650: 'Touhai Densetsu Akagi: Yami ni Maiorita Tensai',\n",
       " 651: 'Papa to Kiss in the Dark',\n",
       " 652: 'Blade of the Phantom Master',\n",
       " 653: 'Tenchi the Movie 2: Daughter of Darkness',\n",
       " 654: 'Ankoku Shinden Takegami',\n",
       " 655: 'Twilight Of The Dark Master',\n",
       " 656: 'Judge',\n",
       " 657: 'Dark Warrior',\n",
       " 658: 'Darkside Blues',\n",
       " 659: \"Night Warriors: Darkstalkers' Revenge\",\n",
       " 660: 'Ankoku Shinwa',\n",
       " 661: 'Black Jack: Futari no Kuroi Isha',\n",
       " 662: 'Rockman.EXE Movie: Hikari to Yami no Program',\n",
       " 663: 'Yu Yu Hakusho: Eizou Hakusho',\n",
       " 664: 'Alien from the Darkness',\n",
       " 665: 'Akakichi no Eleven',\n",
       " 666: 'Angel Blade',\n",
       " 667: 'Shin Cutey Honey',\n",
       " 668: 'Mazinkaiser: Deathmatch! General Dark',\n",
       " 669: 'Dark Love',\n",
       " 670: 'Pokemon: The Rise Of Darkrai',\n",
       " 671: 'Dark Future',\n",
       " 672: 'Dark Shell: Lust in the Cage',\n",
       " 673: 'Dark',\n",
       " 674: 'Spy of Darkness',\n",
       " 675: 'Dark Tours',\n",
       " 676: 'Idol of Darkness',\n",
       " 677: 'Shina Dark: Kuroki Tsuki no Ou to Souheki no Tsuki no Himegimi',\n",
       " 678: 'Dark Chapel',\n",
       " 679: 'Dracula: Sovereign of the Damned',\n",
       " 680: 'Angel Of Darkness',\n",
       " 681: 'Mission of Darkness',\n",
       " 682: 'Shin Megami Tensei Devil Children: Light & Dark',\n",
       " 683: 'Darker than Black: Kuro no Keiyakusha Special',\n",
       " 684: 'Mazinger Z vs. General Dark',\n",
       " 685: 'Darkness of the Sea, Shadow of the Moon',\n",
       " 686: 'Dark Cat',\n",
       " 687: 'Legends of the Dark King: A Fist of the North Star Story',\n",
       " 688: 'Grope: Yami no naka no Kotoritachi',\n",
       " 689: 'Gunslinger Girl: Il Teatrino OVA',\n",
       " 690: 'Lesson of Darkness',\n",
       " 691: 'Black God',\n",
       " 692: 'Hyouka: Motsubeki Mono wa',\n",
       " 693: 'Jikuu Ihoujin Kyoko: Chocola ni Omakase!',\n",
       " 694: 'Sword of the Stranger',\n",
       " 695: 'Time Stranger',\n",
       " 696: 'Toki no Tabibito: Time Stranger',\n",
       " 697: 'Detective Conan OVA 09: The Stranger in 10 Years...',\n",
       " 698: 'Sword of the Stranger Pilot',\n",
       " 699: 'Vampire Hunter D: Bloodlust',\n",
       " 700: 'Vampire Hunter D',\n",
       " 701: 'Trinity Blood',\n",
       " 702: 'Blood: The Last Vampire',\n",
       " 703: 'Dragon Ball Movie 1: Curse of the Blood Rubies',\n",
       " 704: 'Blood Royale',\n",
       " 705: 'Master Keaton',\n",
       " 706: 'Blood Reign: Curse of the Yoma',\n",
       " 707: 'Black Blood Brothers',\n",
       " 708: 'Blood Shadow',\n",
       " 709: 'Uchuu no Kishi Tekkaman Blade OVA: Twin Blood',\n",
       " 710: 'Pigeon Blood',\n",
       " 711: 'Shion no Ou',\n",
       " 712: 'Hurricane Polymar: Holy Blood',\n",
       " 713: \"JoJo's Bizarre Adventure: Phantom Blood\",\n",
       " 714: \"Black Lagoon: Roberta's Blood Trail\",\n",
       " 715: 'Nekketsu Saikyou Go-Saurer',\n",
       " 716: 'Hot-blooded Alien',\n",
       " 717: 'Hakuoki: Record of the Jade Blood',\n",
       " 718: 'Burning Blood',\n",
       " 719: 'Blood-C',\n",
       " 720: 'Naruto: Shippuuden Movie 5 - Blood Prison',\n",
       " 721: 'Blood-C: The Last Dark',\n",
       " 722: 'Bloods: Inraku no Ketsuzoku 2',\n",
       " 723: 'Tekken: Blood Vengeance',\n",
       " 724: 'Blood Lad',\n",
       " 725: 'Bloody Date',\n",
       " 726: 'Dragon Age: Dawn of the Seeker',\n",
       " 727: 'Bloody Night',\n",
       " 728: 'Within the Bloody Woods',\n",
       " 729: 'Gregory Horror Show: The Bloody Karte',\n",
       " 730: 'Blood-C: None-None Gekijou',\n",
       " 731: 'Blood-C: Special Edition',\n",
       " 732: 'Strike the Blood',\n",
       " 733: 'Blood Lad OVA',\n",
       " 734: 'Naniwa Yuukyouden: Nekketsu!! Bakushou Mankai-hen',\n",
       " 735: 'Bayonetta: Bloody Fate',\n",
       " 736: 'Kekkai Sensen',\n",
       " 737: 'Bloody Bunny',\n",
       " 738: 'Ghost in the Shell',\n",
       " 739: 'Three Little Ghosts',\n",
       " 740: 'A Chinese Ghost Story',\n",
       " 741: 'Yu Yu Hakusho',\n",
       " 742: 'Ghost in the Shell: Stand Alone Complex',\n",
       " 743: 'Ghost in the Shell 2: Innocence',\n",
       " 744: 'Ghost in the Shell: Stand Alone Complex 2nd GIG',\n",
       " 745: 'Ghost Stories',\n",
       " 746: 'Ghost in the Shell: Stand Alone Complex - Tachikoma na Hibi',\n",
       " 747: \"Ghost Talker's Daydream\",\n",
       " 748: 'Obake no Q-tarou',\n",
       " 749: 'Ghost in the Shell: Stand Alone Complex - Solid State Society',\n",
       " 750: 'Ghost Hunt',\n",
       " 751: 'Ghost Slayers Ayashi',\n",
       " 752: 'Ghost Sweeper GS Mikami',\n",
       " 753: 'Ghost in the Shell: Stand Alone Complex - The Laughing Man',\n",
       " 754: 'Ghost Hound',\n",
       " 755: 'Soratobu Yuureisen',\n",
       " 756: 'Ghost Sweeper Mikami Movie',\n",
       " 757: 'Ghost in the Shell: Stand Alone Complex - Solid State Society: Uchikomatic Days',\n",
       " 758: 'Ghost in the Shell: Stand Alone Complex 2nd GIG - Tachikomatic Days',\n",
       " 759: 'Web Ghosts PiPoPa',\n",
       " 760: 'Ghost in the Shell 2.0',\n",
       " 761: '07-Ghost',\n",
       " 762: \"Pokemon: Pikachu's Ghost Festival!\",\n",
       " 763: 'Uchurei!',\n",
       " 764: 'Bakemonogatari Recap',\n",
       " 765: 'Onbu Obake',\n",
       " 766: 'Spooky Kitarou: The Strongest Ghost Army! Landing in Japan!!',\n",
       " 767: \"Gegege no Kitarou: Kitarou's Ghost Train\",\n",
       " 768: 'Ryuuichi Manga Gekijou Onbu Obake',\n",
       " 769: 'O-bake no... Holly',\n",
       " 770: 'Ghost in the Shell: Stand Alone Complex: Solid State Society 3D',\n",
       " 771: 'Grandma and Her Ghosts',\n",
       " 772: 'Little Ghostly Adventures Of The Tofu Boy',\n",
       " 773: 'Ghost in the Shell: Stand Alone Complex - Tachikoma na Hibi (TV)',\n",
       " 774: 'Ghost Messenger',\n",
       " 775: 'Cat God: Ohanami Ghostbusters',\n",
       " 776: 'Ghost in the Shell: Stand Alone Complex - The Laughing Man - Tachikomatic Days',\n",
       " 777: 'Ghost in the Shell: Stand Alone Complex: Tachikomatic Days Fan Disc',\n",
       " 778: 'Ghost in the Shell: Stand Alone Complex: Solid State Society 3D: Tachikomatic Days',\n",
       " 779: 'Ghost in the Shell: Arise - Border:1 Ghost Pain',\n",
       " 780: 'Ghost in the Shell: Arise - Border:2 Ghost Whispers',\n",
       " 781: 'Ghost in the Shell: Arise - Border:3 Ghost Tears',\n",
       " 782: 'Ghost in the Shell: Arise - Border:4 Ghost Stands Alone',\n",
       " 783: 'Yamishibai: Japanese Ghost Stories',\n",
       " 784: 'Patema Inverted',\n",
       " 785: 'Patema Inverted: Beginning of the Day',\n",
       " 786: 'Time of Eve',\n",
       " 788: \"Sheep's Song\",\n",
       " 789: 'The Poem of Wind and Trees',\n",
       " 790: 'Nightsong of Splendor',\n",
       " 791: 'Maiden of Deliverance',\n",
       " 792: 'Song of the Ladybug',\n",
       " 793: 'Uchuu Hikoushi no Uta',\n",
       " 794: 'Raiyantsuuri no Uta',\n",
       " 795: 'Yakyuukyou no Uta',\n",
       " 796: \"The Pilot's Love Song\",\n",
       " 797: 'Obake Entotsu no Uta',\n",
       " 798: 'Ajisai no Uta',\n",
       " 799: 'Moeyo Ken',\n",
       " 800: 'Steel Angel Kurumi',\n",
       " 801: 'Steel Angel Kurumi Zero',\n",
       " 802: 'Steel Angel Kurumi Encore',\n",
       " 803: 'Mermaid Forest',\n",
       " 804: 'Funny Faces in High School',\n",
       " 805: 'The Ocean Waves',\n",
       " 806: 'Kidou Shinsengumi Moeyo Ken',\n",
       " 807: 'Nadia: Secret of Blue Water',\n",
       " 808: 'Nadia: The Secret of Blue Water - The Motion Picture',\n",
       " 809: 'Cool Devices',\n",
       " 810: 'Aoi Umi no Tristia',\n",
       " 811: 'Di Gi Charat Natsuyasumi Special',\n",
       " 812: 'Shonan Junai Gumi!',\n",
       " 813: 'Sakura Wars: ~Su~Mi~Re~',\n",
       " 814: 'Mermaid Forest OVA',\n",
       " 815: \"Mermaid's Scar\",\n",
       " 816: 'Laughing Target',\n",
       " 817: 'Coo: Tooi Umi kara Kita Coo',\n",
       " 818: 'Majokko Club Yoningumi: A Kuukan kara no Alien X',\n",
       " 819: 'Tanoshii Muumin Ikka',\n",
       " 820: 'Kono Aozora ni Yakusoku wo',\n",
       " 821: 'Pokemon: Pokemon Ranger and the Temple of the Sea',\n",
       " 822: 'Muumindani no Suisei',\n",
       " 823: 'The Hills Have Size',\n",
       " 824: \"Yoshinaga-san'chi no Gargoyle Specials\",\n",
       " 825: 'Rumiko Takahashi Anthology',\n",
       " 826: 'Hot for Teacher',\n",
       " 827: 'Genmukan: The Sin of Desire & Shame',\n",
       " 828: 'Kenkou Zenrakei Suieibu Umishou',\n",
       " 829: 'Doraemon: Treasure of the Shinugumi Mountain',\n",
       " 830: 'Triton of the Sea',\n",
       " 831: 'Kasumin 3rd Season',\n",
       " 832: 'Momotarou: Umi no Shinpei',\n",
       " 833: 'St. Luminous Mission High School',\n",
       " 834: 'Angel Core',\n",
       " 835: 'Fire Tripper',\n",
       " 836: 'Harumi-chan no Oita',\n",
       " 837: 'Daigo of Fire Company',\n",
       " 838: 'Swan Lake',\n",
       " 839: 'Nanatsu no Umi no Tico',\n",
       " 840: 'Nadia: Secret of Blue Water Specials',\n",
       " 841: 'Hoshi no Umi no Amuri',\n",
       " 842: 'Miyazawa Kenji Collection - The Acorns and the Wildcat',\n",
       " 843: 'Miyazaki Maya Daizukan',\n",
       " 844: 'Cardcaptor Sakura',\n",
       " 845: 'Cardcaptor Sakura: The Movie',\n",
       " 846: 'Card Captor Sakura Movie 2: The Sealed Card',\n",
       " 847: 'Cardcaptor Sakura: Leave It to Kero-chan',\n",
       " 848: 'Wild Cardz',\n",
       " 849: 'Cardcaptor Sakura Specials',\n",
       " 850: 'Five Card',\n",
       " 851: 'Live On Cardliver Kakeru',\n",
       " 852: 'Little Battlers eXperience',\n",
       " 853: 'Mix Master King of Cards',\n",
       " 854: 'Cardfight!! Vanguard',\n",
       " 855: 'Cardfight!! Vanguard Asia Circuit',\n",
       " 856: 'Cardfight!! Vanguard: Link Joker-hen',\n",
       " 857: 'Inazuma Eleven Go: TCG CM NG-shuu',\n",
       " 858: 'Future Card Buddyfight',\n",
       " 859: 'Cardfight!! Vanguard: Legion Mate-hen',\n",
       " 860: 'Cardfight!! Vanguard Movie: Neon Messiah',\n",
       " 861: 'Future Card Buddyfight Recap',\n",
       " 862: 'Cardfight!! Vanguard G',\n",
       " 863: 'Nenga no Kizuna',\n",
       " 864: 'Atama wa Tsukaiyou. Card mo Tsukaiyou.',\n",
       " 865: 'The Seven Metamorphoses of Yamato Nadeshiko',\n",
       " 866: 'Otome Nadeshiko Koi Techou',\n",
       " 867: 'Dragon Ball Z: Saiya-jin Zetsumetsu Keikaku',\n",
       " 868: 'Dragon Ball Z Special 2: The History of Trunks',\n",
       " 869: 'Zetsuai 1989',\n",
       " 870: 'Bronze: Zetsuai Since 1989',\n",
       " 871: 'Maid no Yakata: Zetsubou-hen',\n",
       " 872: 'Sayonara Zetsubou Sensei',\n",
       " 873: 'Digimon Adventure 02: Digimon Hurricane Jouriku!!/Chouzetsu Shinka!! Ougon no Digimental',\n",
       " 874: 'Zoku Sayonara Zetsubou Sensei',\n",
       " 875: 'Sayonara Zetsubou Sensei Jo: Zetsubou Shoujo Senshuu',\n",
       " 876: 'Hentai Express',\n",
       " 877: 'Goodbye Mr. Despair OAD',\n",
       " 878: 'Zan Sayonara Zetsubou Sensei',\n",
       " 879: 'Zan Sayonara Zetsubou Sensei Bangaichi',\n",
       " 880: 'Sayonara Zetsubou Sensei Jo: Zoku Zetsubou Shoujo Senshuu',\n",
       " 881: 'Dragon Ball: Super Saiya-jin Zetsumetsu Keikaku',\n",
       " 882: 'Super Doll Licca-chan: Licca-chan Zettai Zetsumei! Doll Knights no Kiseki',\n",
       " 883: 'Sayonara Zetsubou Sensei Special',\n",
       " 884: 'Towanoquon: The Return of the Invincible',\n",
       " 885: 'Zettai Zetsumei Dangerous Jiisan (2004)',\n",
       " 886: 'Sayonara Zetsubou Sensei Special Omake',\n",
       " 887: 'Zetsumetsu Kigu Shoujo: Amazing Twins',\n",
       " 888: 'Zettai Zetsumei Dangerous Jiisan (2005)',\n",
       " 889: 'Zettai Zetsumei Dangerous Jiisan',\n",
       " 890: 'Zettai Zetsumei Dangerous Jiisan Special Ban',\n",
       " 891: 'Bleach: The Sealed Sword Frenzy',\n",
       " 892: 'Soul Hunter',\n",
       " 893: \"Wolf's Rain\",\n",
       " 894: \"Wolf's Rain OVA\",\n",
       " 895: 'Chobits: Chibits - Sumomo and Kotoko Deliver',\n",
       " 896: 'Momo, Girl God of Death',\n",
       " 897: 'Sumomomo Momomo: Chijou Saikyou no Yome',\n",
       " 898: 'Sumomomo Momomo: Chijou Saikyou no Yome Specials',\n",
       " 899: 'Minky Momo in the Bridge Over Dreams',\n",
       " 900: 'Bonobono: Kumomo no Ki no Koto',\n",
       " 901: 'Mahou no Princess Minky Momo vs. Mahou no Tenshi Creamy Mami',\n",
       " 902: 'A Letter to Momo',\n",
       " 903: 'Zumomo to Nupepe',\n",
       " 904: 'Momokyun Sword',\n",
       " 905: 'Mahou no Princess Minky Momo: Hitomi no Seiza - Minky Momo Song Special',\n",
       " 906: 'The Vision of Escaflowne',\n",
       " 907: 'Escaflowne: A Girl in Gaea',\n",
       " 908: 'Magical Princess Minky Momo',\n",
       " 909: 'Momoiro Sisters',\n",
       " 910: 'PostPet Momobin',\n",
       " 911: 'Magical Princess Minky Momo: La Ronde in my Dream',\n",
       " 912: 'Doraemon: What Am I for Momotarou',\n",
       " 913: 'Coji-Coji',\n",
       " 914: \"Momotaro's Sky Adventure\",\n",
       " 915: 'Momotaro the Undefeated',\n",
       " 916: \"Momotaro's Underwater Adventure\",\n",
       " 917: 'Magical Princess Minky Momo: Hold on to Your Dreams',\n",
       " 918: 'Momotarou no Umiwashi',\n",
       " 919: '11eyes: Momoiro Genmutan',\n",
       " 920: 'My Sister Momoko',\n",
       " 921: 'Momoko',\n",
       " 922: 'Battle Girls: Time Paradox',\n",
       " 923: 'Momotarou',\n",
       " 924: 'Momotarou Densetsu',\n",
       " 925: '3 Choume no Tama: Onegai! Momo-chan wo Sagashite!!',\n",
       " 926: 'Ikeike! Momon-chan',\n",
       " 927: 'Ikeike! Momon-chan Specials',\n",
       " 928: 'Momoya x Peeping Life: Go en Desu yo!',\n",
       " 929: 'Wonder Momo',\n",
       " 930: 'Hello Kitty in Momotaro',\n",
       " 931: 'Peeping Life: This Is Fate! II',\n",
       " 932: \"Momon's Sand Witch\",\n",
       " 933: \"Momon's Sand Witch Episode 0\",\n",
       " 934: \"Momon's Sand Witch Specials\",\n",
       " 935: 'Momotarou no Hi Asobi Yameyou! Hi no Youjin',\n",
       " 936: 'Momonga-mon',\n",
       " 937: 'Ame to Shoujo to Watashi no Tegami',\n",
       " 938: 'Letter Bee: Light and Blue Night Fantasy',\n",
       " 940: 'Letter Bee Academy',\n",
       " 941: 'Letter Bee Reverse',\n",
       " 942: 'Tegami: Haikei Juugo no Kimi e',\n",
       " 943: 'Letter Bee Reverse Specials',\n",
       " 944: 'Tegami',\n",
       " 945: \"Hikaru's Go\",\n",
       " 946: 'Hikaru no Go: Journey to the North Star Cup',\n",
       " 947: 'Figure 17: Tsubasa & Hikaru',\n",
       " 948: 'Campus Special Investigator Hikaruon',\n",
       " 949: 'Hikaru no Go: New Year Special',\n",
       " 950: 'Passion',\n",
       " 951: 'Seitokaichou Hikaru',\n",
       " 952: 'Mahou no Star Magical Emi: Kumo Hikaru',\n",
       " 953: 'Hikaru no Go Special',\n",
       " 954: 'Hotarubi no Mori e',\n",
       " 955: 'Kaguya-hime: Taketori Monogatari',\n",
       " 956: 'The Tale of The Princess Kaguya',\n",
       " 957: 'Hello Kitty in the Bamboo Princess',\n",
       " 958: 'Le Vent se lève',\n",
       " 959: 'Redline',\n",
       " 960: 'Redline Pilot',\n",
       " 961: 'Mujaki no Rakuen',\n",
       " 962: 'Jin-Roh: The Wolf Brigade',\n",
       " 963: 'Magical DoReMi',\n",
       " 964: 'Ojamajo Doremi Sharp',\n",
       " 965: 'More! Useless Witch Doremi',\n",
       " 966: 'Useless Witch Doremi Kaboom!',\n",
       " 967: 'Kiki la petite sorcière',\n",
       " 968: 'Major S2',\n",
       " 969: 'Major S1',\n",
       " 970: 'The Good Witch Of The West',\n",
       " 971: 'Ojamajo Doremi Na-i-sho',\n",
       " 972: 'Major S3',\n",
       " 973: 'Ail Maniax: Inma Seifukugari & Majogari no Yoru ni',\n",
       " 974: 'Majokko Tsukune-chan',\n",
       " 975: 'Ojamajo Doremi Sharp Movie',\n",
       " 976: 'More! Ojamajo Doremi: Secret of the Frog Stone',\n",
       " 977: 'Major S4',\n",
       " 978: 'Fashionable Witches Love and Berry: Magic of Happiness',\n",
       " 979: 'Majokko Megu-chan',\n",
       " 980: 'Locke the Superman',\n",
       " 981: 'Majokko Tickle',\n",
       " 982: 'Major S5',\n",
       " 983: 'Major: Yuujou no Ikkyuu',\n",
       " 984: 'Wake Up! Aria',\n",
       " 985: 'Major S6',\n",
       " 986: 'Majo Demo Steady',\n",
       " 987: 'Major: Message',\n",
       " 988: 'Major: World Series',\n",
       " 989: 'Ojamajo Doremi OVA',\n",
       " 990: 'Here Comes the Black Witch!!',\n",
       " 991: 'Koutetsu no Majo Annerose',\n",
       " 992: 'Magical Sisters Yoyo & Nene',\n",
       " 993: 'Toki no Daichi: Hana no Oukoku no Majo',\n",
       " 994: 'Yamada-kun to 7-nin no Majo',\n",
       " 995: 'Yamada-kun to 7-nin no Majo (OVA)',\n",
       " 996: 'Majokko Shimai no Yoyo to Nene Movie Extra: Hatsukoi - Mikako Komatsu',\n",
       " 997: 'Yamada-kun to 7-nin no Majo (TV)',\n",
       " 998: 'Ippatsu Kiki Musume',\n",
       " 999: 'Kinnikuman: New York Kikiippatsu!',\n",
       " 1000: 'Futari wa Precure: Splash☆Star Movie - Tick Tack Kiki Ippatsu!',\n",
       " 1001: \"Ham Ham Grand Prix - The Miracle of Aurora Valley ~Ribon-chan's Close Call~\",\n",
       " 1002: 'Digimon Savers 3D: Digital World Kiki Ippatsu!',\n",
       " 1003: 'MonHun Nikki Girigiri Airuu Mura: Airuu Kiki Ippatsu',\n",
       " 1004: 'Kiki to Lala no Aoi Tori',\n",
       " 1005: 'MonHun Nikki Girigiri Airuu Mura: Airuu Kiki Ippatsu Specials',\n",
       " 1006: 'Listen to Me, Girls. I Am Your Father!',\n",
       " ...}"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict(titles)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.decode_work[3312]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user              1958\n",
       "item              2939\n",
       "rating               4\n",
       "items_per_user     391\n",
       "users_per_item     355\n",
       "dtype: int64"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "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>user</th>\n",
       "      <th>item</th>\n",
       "      <th>rating</th>\n",
       "      <th>items_per_user</th>\n",
       "      <th>users_per_item</th>\n",
       "      <th>decoded_item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26102</th>\n",
       "      <td>1650</td>\n",
       "      <td>674</td>\n",
       "      <td>dislike</td>\n",
       "      <td>2102</td>\n",
       "      <td>14</td>\n",
       "      <td>15320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102937</th>\n",
       "      <td>1650</td>\n",
       "      <td>1670</td>\n",
       "      <td>dislike</td>\n",
       "      <td>2102</td>\n",
       "      <td>340</td>\n",
       "      <td>8346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68327</th>\n",
       "      <td>1650</td>\n",
       "      <td>288</td>\n",
       "      <td>dislike</td>\n",
       "      <td>2102</td>\n",
       "      <td>89</td>\n",
       "      <td>18294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102923</th>\n",
       "      <td>1650</td>\n",
       "      <td>1760</td>\n",
       "      <td>like</td>\n",
       "      <td>2102</td>\n",
       "      <td>21</td>\n",
       "      <td>16786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203833</th>\n",
       "      <td>1650</td>\n",
       "      <td>2778</td>\n",
       "      <td>dislike</td>\n",
       "      <td>2102</td>\n",
       "      <td>34</td>\n",
       "      <td>12143</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122211</th>\n",
       "      <td>979</td>\n",
       "      <td>1988</td>\n",
       "      <td>favorite</td>\n",
       "      <td>10</td>\n",
       "      <td>976</td>\n",
       "      <td>20811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145300</th>\n",
       "      <td>183</td>\n",
       "      <td>863</td>\n",
       "      <td>like</td>\n",
       "      <td>10</td>\n",
       "      <td>861</td>\n",
       "      <td>6620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163844</th>\n",
       "      <td>1488</td>\n",
       "      <td>177</td>\n",
       "      <td>neutral</td>\n",
       "      <td>10</td>\n",
       "      <td>378</td>\n",
       "      <td>6723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233719</th>\n",
       "      <td>1346</td>\n",
       "      <td>2362</td>\n",
       "      <td>like</td>\n",
       "      <td>10</td>\n",
       "      <td>871</td>\n",
       "      <td>5180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188815</th>\n",
       "      <td>1342</td>\n",
       "      <td>2366</td>\n",
       "      <td>like</td>\n",
       "      <td>10</td>\n",
       "      <td>772</td>\n",
       "      <td>10728</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>213445 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user  item    rating  items_per_user  users_per_item  decoded_item\n",
       "26102   1650   674   dislike            2102              14         15320\n",
       "102937  1650  1670   dislike            2102             340          8346\n",
       "68327   1650   288   dislike            2102              89         18294\n",
       "102923  1650  1760      like            2102              21         16786\n",
       "203833  1650  2778   dislike            2102              34         12143\n",
       "...      ...   ...       ...             ...             ...           ...\n",
       "122211   979  1988  favorite              10             976         20811\n",
       "145300   183   863      like              10             861          6620\n",
       "163844  1488   177   neutral              10             378          6723\n",
       "233719  1346  2362      like              10             871          5180\n",
       "188815  1342  2366      like              10             772         10728\n",
       "\n",
       "[213445 rows x 6 columns]"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['decoded_item'] = df['item'].map(dataset.decode_work)\n",
    "df.sort_values('items_per_user', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "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>user</th>\n",
       "      <th>item</th>\n",
       "      <th>rating</th>\n",
       "      <th>items_per_user</th>\n",
       "      <th>users_per_item</th>\n",
       "      <th>decoded_item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [user, item, rating, items_per_user, users_per_item, decoded_item]\n",
       "Index: []"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('item == 3312')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "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>user</th>\n",
       "      <th>item</th>\n",
       "      <th>rating</th>\n",
       "      <th>items_per_user</th>\n",
       "      <th>users_per_item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>339</td>\n",
       "      <td>1626</td>\n",
       "      <td>favorite</td>\n",
       "      <td>223</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2057</td>\n",
       "      <td>7939</td>\n",
       "      <td>neutral</td>\n",
       "      <td>187</td>\n",
       "      <td>147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1382</td>\n",
       "      <td>8120</td>\n",
       "      <td>like</td>\n",
       "      <td>284</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1455</td>\n",
       "      <td>8588</td>\n",
       "      <td>like</td>\n",
       "      <td>114</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>223</td>\n",
       "      <td>5575</td>\n",
       "      <td>dislike</td>\n",
       "      <td>114</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234809</th>\n",
       "      <td>472</td>\n",
       "      <td>4509</td>\n",
       "      <td>dislike</td>\n",
       "      <td>780</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234810</th>\n",
       "      <td>1926</td>\n",
       "      <td>74</td>\n",
       "      <td>dislike</td>\n",
       "      <td>5001</td>\n",
       "      <td>438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234811</th>\n",
       "      <td>1997</td>\n",
       "      <td>406</td>\n",
       "      <td>favorite</td>\n",
       "      <td>159</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234812</th>\n",
       "      <td>1747</td>\n",
       "      <td>6798</td>\n",
       "      <td>like</td>\n",
       "      <td>708</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234813</th>\n",
       "      <td>1136</td>\n",
       "      <td>4655</td>\n",
       "      <td>like</td>\n",
       "      <td>319</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234814 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user  item    rating  items_per_user  users_per_item\n",
       "0        339  1626  favorite             223               8\n",
       "1       2057  7939   neutral             187             147\n",
       "2       1382  8120      like             284              62\n",
       "3       1455  8588      like             114             241\n",
       "4        223  5575   dislike             114              88\n",
       "...      ...   ...       ...             ...             ...\n",
       "234809   472  4509   dislike             780              29\n",
       "234810  1926    74   dislike            5001             438\n",
       "234811  1997   406  favorite             159              17\n",
       "234812  1747  6798      like             708              81\n",
       "234813  1136  4655      like             319             285\n",
       "\n",
       "[234814 rows x 5 columns]"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0 = pd.read_csv('ratings-2020.csv', names=('user', 'item', 'rating'))\n",
    "df0['items_per_user'] = df0.groupby('user')['item'].transform('count')\n",
    "df0['users_per_item'] = df0.groupby('item')['user'].transform('count')\n",
    "df0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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>user</th>\n",
       "      <th>item</th>\n",
       "      <th>rating</th>\n",
       "      <th>items_per_user</th>\n",
       "      <th>users_per_item</th>\n",
       "      <th>decoded_item</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>166430</th>\n",
       "      <td>1738</td>\n",
       "      <td>3312</td>\n",
       "      <td>favorite</td>\n",
       "      <td>32</td>\n",
       "      <td>1634</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131102</th>\n",
       "      <td>1260</td>\n",
       "      <td>3312</td>\n",
       "      <td>like</td>\n",
       "      <td>12</td>\n",
       "      <td>1634</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153194</th>\n",
       "      <td>1991</td>\n",
       "      <td>3312</td>\n",
       "      <td>neutral</td>\n",
       "      <td>173</td>\n",
       "      <td>1634</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86370</th>\n",
       "      <td>1399</td>\n",
       "      <td>3312</td>\n",
       "      <td>favorite</td>\n",
       "      <td>9</td>\n",
       "      <td>1634</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34568</th>\n",
       "      <td>1646</td>\n",
       "      <td>3312</td>\n",
       "      <td>like</td>\n",
       "      <td>53</td>\n",
       "      <td>1634</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151651</th>\n",
       "      <td>2199</td>\n",
       "      <td>6959</td>\n",
       "      <td>like</td>\n",
       "      <td>284</td>\n",
       "      <td>1</td>\n",
       "      <td>14097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187731</th>\n",
       "      <td>1763</td>\n",
       "      <td>8790</td>\n",
       "      <td>like</td>\n",
       "      <td>720</td>\n",
       "      <td>1</td>\n",
       "      <td>14026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83223</th>\n",
       "      <td>248</td>\n",
       "      <td>5963</td>\n",
       "      <td>dislike</td>\n",
       "      <td>1853</td>\n",
       "      <td>1</td>\n",
       "      <td>20732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13285</th>\n",
       "      <td>248</td>\n",
       "      <td>7617</td>\n",
       "      <td>dislike</td>\n",
       "      <td>1853</td>\n",
       "      <td>1</td>\n",
       "      <td>15277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19294</th>\n",
       "      <td>1722</td>\n",
       "      <td>4634</td>\n",
       "      <td>favorite</td>\n",
       "      <td>69</td>\n",
       "      <td>1</td>\n",
       "      <td>21080</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234814 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        user  item    rating  items_per_user  users_per_item  decoded_item\n",
       "166430  1738  3312  favorite              32            1634             1\n",
       "131102  1260  3312      like              12            1634             1\n",
       "153194  1991  3312   neutral             173            1634             1\n",
       "86370   1399  3312  favorite               9            1634             1\n",
       "34568   1646  3312      like              53            1634             1\n",
       "...      ...   ...       ...             ...             ...           ...\n",
       "151651  2199  6959      like             284               1         14097\n",
       "187731  1763  8790      like             720               1         14026\n",
       "83223    248  5963   dislike            1853               1         20732\n",
       "13285    248  7617   dislike            1853               1         15277\n",
       "19294   1722  4634  favorite              69               1         21080\n",
       "\n",
       "[234814 rows x 6 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0['decoded_item'] = df0['item'].map(dataset.decode_work)\n",
    "df0.sort_values('users_per_item', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9174"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0['item'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         1626\n",
       "1         7939\n",
       "2         8120\n",
       "3         8588\n",
       "4         5575\n",
       "          ... \n",
       "234809    4509\n",
       "234810      74\n",
       "234811     406\n",
       "234812    6798\n",
       "234813    4655\n",
       "Name: item, Length: 234814, dtype: int64"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0['item']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15500"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_work_ids = set(Work.objects.values_list('id', flat=True))\n",
    "len(all_work_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12489"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "\n",
    "have_poster = set(int(filename.replace('.jpg', '')) for filename in os.listdir('real_posters'))\n",
    "len(have_poster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "248"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(have_poster - all_work_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3259"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_work_ids - have_poster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9174"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset_ids = set(df0['decoded_item'].unique().tolist())\n",
    "len(dataset_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1831"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dataset_ids - have_poster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5146"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(have_poster - dataset_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7343"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dataset_ids & have_poster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.8004142140832788"
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dataset_ids & have_poster) / len(dataset_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3312"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset.encode_work[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [],
   "source": [
    "for work_id in dataset_ids & have_poster:\n",
    "    os.system(f'cp real_posters/{work_id}.jpg posters/{dataset.encode_work[work_id]}.jpg')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [],
   "source": [
    "df0.to_csv('decoder-2020.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Django Shell-Plus",
   "language": "python",
   "name": "django_extensions"
  },
  "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.7.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}