rename_charid.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b4f5a48d",
   "metadata": {},
   "source": [
    "# Charidを振り直す"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7864b8db",
   "metadata": {},
   "source": [
    "もともとのcharidは東方Wikiのリストに上から番号を付けたもので旧作や非常にマイナーなキャラは含まれていたかった。\n",
    "\n",
    "ので人気投票の出現順(char_points_ratio)を新たなcharidとする"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bf71a97b",
   "metadata": {},
   "source": [
    "旧charid\n",
    "\n",
    "https://docs.google.com/spreadsheets/d/1YKpwyCOLRWiC9jucljunxS41i75zUYojI3qx1JnIpVI/edit#gid=1451040548"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4efe776c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f5affa5e",
   "metadata": {},
   "source": [
    "char_points_ratioこれはいじらなくて良い"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "57000084",
   "metadata": {},
   "outputs": [],
   "source": [
    "char_points_ratio=pd.read_csv(\"data/char_points_ratio.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "9522ce96",
   "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>charid</th>\n",
       "      <th>名前</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>十六夜 咲夜</td>\n",
       "      <td>0.174632</td>\n",
       "      <td>0.148538</td>\n",
       "      <td>0.119437</td>\n",
       "      <td>0.066389</td>\n",
       "      <td>0.043986</td>\n",
       "      <td>0.041815</td>\n",
       "      <td>0.034421</td>\n",
       "      <td>0.034349</td>\n",
       "      <td>0.033745</td>\n",
       "      <td>0.032236</td>\n",
       "      <td>0.033342</td>\n",
       "      <td>0.031858</td>\n",
       "      <td>0.031279</td>\n",
       "      <td>0.028652</td>\n",
       "      <td>0.028881</td>\n",
       "      <td>0.031512</td>\n",
       "      <td>0.034703</td>\n",
       "      <td>0.037877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>霧雨 魔理沙</td>\n",
       "      <td>0.174632</td>\n",
       "      <td>0.140111</td>\n",
       "      <td>0.160269</td>\n",
       "      <td>0.074140</td>\n",
       "      <td>0.053930</td>\n",
       "      <td>0.041407</td>\n",
       "      <td>0.034437</td>\n",
       "      <td>0.031998</td>\n",
       "      <td>0.031373</td>\n",
       "      <td>0.035802</td>\n",
       "      <td>0.038609</td>\n",
       "      <td>0.034277</td>\n",
       "      <td>0.033953</td>\n",
       "      <td>0.032413</td>\n",
       "      <td>0.033570</td>\n",
       "      <td>0.034614</td>\n",
       "      <td>0.040944</td>\n",
       "      <td>0.045544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>博麗 霊夢</td>\n",
       "      <td>0.113971</td>\n",
       "      <td>0.077166</td>\n",
       "      <td>0.086974</td>\n",
       "      <td>0.070948</td>\n",
       "      <td>0.054767</td>\n",
       "      <td>0.044170</td>\n",
       "      <td>0.039348</td>\n",
       "      <td>0.038753</td>\n",
       "      <td>0.037450</td>\n",
       "      <td>0.040317</td>\n",
       "      <td>0.039170</td>\n",
       "      <td>0.048207</td>\n",
       "      <td>0.040313</td>\n",
       "      <td>0.037626</td>\n",
       "      <td>0.038856</td>\n",
       "      <td>0.035766</td>\n",
       "      <td>0.039516</td>\n",
       "      <td>0.043074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>チルノ</td>\n",
       "      <td>0.093750</td>\n",
       "      <td>0.017119</td>\n",
       "      <td>0.010821</td>\n",
       "      <td>0.018806</td>\n",
       "      <td>0.028938</td>\n",
       "      <td>0.020041</td>\n",
       "      <td>0.016506</td>\n",
       "      <td>0.015151</td>\n",
       "      <td>0.014084</td>\n",
       "      <td>0.011058</td>\n",
       "      <td>0.011080</td>\n",
       "      <td>0.010234</td>\n",
       "      <td>0.010118</td>\n",
       "      <td>0.010923</td>\n",
       "      <td>0.012773</td>\n",
       "      <td>0.012119</td>\n",
       "      <td>0.014644</td>\n",
       "      <td>0.016072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>パチュリー・ノーレッジ</td>\n",
       "      <td>0.084559</td>\n",
       "      <td>0.051356</td>\n",
       "      <td>0.021233</td>\n",
       "      <td>0.042341</td>\n",
       "      <td>0.034503</td>\n",
       "      <td>0.026553</td>\n",
       "      <td>0.021677</td>\n",
       "      <td>0.020374</td>\n",
       "      <td>0.018668</td>\n",
       "      <td>0.016752</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.014046</td>\n",
       "      <td>0.013883</td>\n",
       "      <td>0.013262</td>\n",
       "      <td>0.013614</td>\n",
       "      <td>0.014173</td>\n",
       "      <td>0.014304</td>\n",
       "      <td>0.014269</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   charid           名前         1         2         3         4         5  \\\n",
       "0       0       十六夜 咲夜  0.174632  0.148538  0.119437  0.066389  0.043986   \n",
       "1       1       霧雨 魔理沙  0.174632  0.140111  0.160269  0.074140  0.053930   \n",
       "2       2        博麗 霊夢  0.113971  0.077166  0.086974  0.070948  0.054767   \n",
       "3       3          チルノ  0.093750  0.017119  0.010821  0.018806  0.028938   \n",
       "4       4  パチュリー・ノーレッジ  0.084559  0.051356  0.021233  0.042341  0.034503   \n",
       "\n",
       "          6         7         8         9        10        11        12  \\\n",
       "0  0.041815  0.034421  0.034349  0.033745  0.032236  0.033342  0.031858   \n",
       "1  0.041407  0.034437  0.031998  0.031373  0.035802  0.038609  0.034277   \n",
       "2  0.044170  0.039348  0.038753  0.037450  0.040317  0.039170  0.048207   \n",
       "3  0.020041  0.016506  0.015151  0.014084  0.011058  0.011080  0.010234   \n",
       "4  0.026553  0.021677  0.020374  0.018668  0.016752  0.015082  0.014046   \n",
       "\n",
       "         13        14        15        16        17        18  \n",
       "0  0.031279  0.028652  0.028881  0.031512  0.034703  0.037877  \n",
       "1  0.033953  0.032413  0.033570  0.034614  0.040944  0.045544  \n",
       "2  0.040313  0.037626  0.038856  0.035766  0.039516  0.043074  \n",
       "3  0.010118  0.010923  0.012773  0.012119  0.014644  0.016072  \n",
       "4  0.013883  0.013262  0.013614  0.014173  0.014304  0.014269  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "char_points_ratio.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "d825ef8a",
   "metadata": {},
   "outputs": [],
   "source": [
    "char_points_ratio = char_points_ratio.rename(columns={'Unnamed: 0': 'charid'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "a18316f8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['charid', '名前', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11',\n",
       "       '12', '13', '14', '15', '16', '17', '18'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "char_points_ratio.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "id": "9b49cb74",
   "metadata": {},
   "outputs": [],
   "source": [
    "char_points_ratio.to_csv(\"data/char_points_ratio.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "998250ba",
   "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>名前</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>十六夜咲夜</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>チルノ</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>パチュリー・ノーレッジ</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>玉造魅須丸</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>山城たかね</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>駒草山如</td>\n",
       "      <td>267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>饕餮尤魔</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>宮出口瑞霊</td>\n",
       "      <td>269</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>270 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              名前 charid\n",
       "0          十六夜咲夜      0\n",
       "1          霧雨魔理沙      1\n",
       "2           博麗霊夢      2\n",
       "3            チルノ      3\n",
       "4    パチュリー・ノーレッジ      4\n",
       "..           ...    ...\n",
       "265        玉造魅須丸    265\n",
       "266        山城たかね    266\n",
       "267         駒草山如    267\n",
       "268         饕餮尤魔    268\n",
       "269        宮出口瑞霊    269\n",
       "\n",
       "[270 rows x 2 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "charid_name=pd.DataFrame([char_points_ratio[\"名前\"],char_points_ratio[\"charid\"]]).T\n",
    "charid_name[\"名前\"]=charid_name[\"名前\"].str.replace(\" \",\"\")\n",
    "charid_name"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7bb956e3",
   "metadata": {},
   "source": [
    "# 本、CD(秘封)の抽出"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "d3673abd",
   "metadata": {},
   "outputs": [],
   "source": [
    "charlist=pd.read_csv(\"data/charlist.csv\")\n",
    "charlist[\"名前\"]=charlist[\"名前\"].str.replace(\" \",\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "ba3dcb90",
   "metadata": {},
   "outputs": [],
   "source": [
    "bookcharlist=charlist[charlist[\"書籍のみ\"]==1]\n",
    "bookcharlist=pd.merge(charid_name,bookcharlist,how=\"right\")\n",
    "bookcharlist.to_csv(\"data/bookchar_list.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "928ba594",
   "metadata": {},
   "outputs": [],
   "source": [
    "hifuulist=charlist[charlist[\"CD(秘封)\"]==1]\n",
    "\n",
    "hifuulist=pd.merge(charid_name,hifuulist,how=\"right\")\n",
    "hifuulist.to_csv(\"data/hifuu_list.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "f3c03ef0",
   "metadata": {},
   "outputs": [],
   "source": [
    "mainchar_ineger=pd.read_csv(\"data/mainchar_integer_list.csv\")\n",
    "bosslist=pd.read_csv(\"data/bosslist.csv\")\n",
    "subchardata=pd.read_csv(\"data/char_noninteger_list.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "92efe3bc",
   "metadata": {},
   "source": [
    "## 旧作、misc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "c3a602a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=charid_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "id": "6c624f08",
   "metadata": {},
   "outputs": [],
   "source": [
    "def remove_list(df1,df2,nacol=\"初投票回\"):\n",
    "        df=pd.merge(df1,df2,\"left\")\n",
    "        df=df[df[nacol].isna()]\n",
    "        df=pd.DataFrame([df[\"名前\"],df[\"charid\"]]).T        \n",
    "        return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "id": "01d73dc7",
   "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>名前</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>魅魔</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>小兎姫</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>めい＆まい</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>幽香</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>エーリッヒ</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>奥野田美宵</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>カワウソ霊</td>\n",
       "      <td>254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>影華扇（断善修悪の怪腕-茨木童子の腕）</td>\n",
       "      <td>257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>オオカミ霊</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>オオワシ霊</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>147 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      名前 charid\n",
       "0                     魅魔      9\n",
       "1                    小兎姫     11\n",
       "2                  めい＆まい     12\n",
       "3                     幽香     14\n",
       "4                  エーリッヒ     15\n",
       "..                   ...    ...\n",
       "145                奥野田美宵    253\n",
       "146                カワウソ霊    254\n",
       "147  影華扇（断善修悪の怪腕-茨木童子の腕）    257\n",
       "148                オオカミ霊    258\n",
       "149                オオワシ霊    259\n",
       "\n",
       "[147 rows x 2 columns]"
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=remove_list(charid_name,bosslist)\n",
    "df=remove_list(df,mainchar_ineger)\n",
    "df=remove_list(df,subchardata,\"番号\")\n",
    "df=remove_list(df,bookcharlist,\"初出番号\")\n",
    "df=remove_list(df,hifuulist,\"初出番号\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "id": "6a9262ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"data/misc_chars.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "3a1f6746",
   "metadata": {},
   "outputs": [],
   "source": [
    "def oldid(df):\n",
    "        df=df.rename(columns={\"charid\":\"old_charid\"})\n",
    "        df[\"名前\"]=df[\"名前\"].str.replace(\" \",\"\")\n",
    "        return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "1b12045a",
   "metadata": {},
   "outputs": [],
   "source": [
    "mainchar_ineger=oldid(mainchar_ineger)\n",
    "bosslist=oldid(bossliset)\n",
    "subchardata=oldid(subchardata)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "ac3824d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#how=\"outer\"\n",
    "mainchar_ineger=pd.merge(mainchar_ineger,charid_name)\n",
    "subchardata=pd.merge(subchardata,charid_name)\n",
    "bosslist=pd.merge(bosslist,charid_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "67f882cd",
   "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>Unnamed: 0</th>\n",
       "      <th>名前</th>\n",
       "      <th>old_charid</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>番号</th>\n",
       "      <th>年</th>\n",
       "      <th>初投票回</th>\n",
       "      <th>作品</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>旧作-西方</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>2002</td>\n",
       "      <td>1</td>\n",
       "      <td>紅魔郷</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>2003</td>\n",
       "      <td>2</td>\n",
       "      <td>妖々夢</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>永夜抄</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>花映塚</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>2007</td>\n",
       "      <td>5</td>\n",
       "      <td>風神録</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>11</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>地霊殿</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>2009</td>\n",
       "      <td>6</td>\n",
       "      <td>星蓮船</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>13</td>\n",
       "      <td>2011</td>\n",
       "      <td>8</td>\n",
       "      <td>神霊廟</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>14</td>\n",
       "      <td>2013</td>\n",
       "      <td>9</td>\n",
       "      <td>輝針城</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>2015</td>\n",
       "      <td>11</td>\n",
       "      <td>紺珠伝</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>16</td>\n",
       "      <td>2017</td>\n",
       "      <td>13</td>\n",
       "      <td>天空璋</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>17</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>鬼形獣</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>18</td>\n",
       "      <td>2021</td>\n",
       "      <td>16</td>\n",
       "      <td>虹龍洞</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>2000</td>\n",
       "      <td>1</td>\n",
       "      <td>旧作-西方</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>2002</td>\n",
       "      <td>1</td>\n",
       "      <td>紅魔郷</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>2003</td>\n",
       "      <td>2</td>\n",
       "      <td>妖々夢</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>永夜抄</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>2005</td>\n",
       "      <td>4</td>\n",
       "      <td>花映塚</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>10</td>\n",
       "      <td>2007</td>\n",
       "      <td>5</td>\n",
       "      <td>風神録</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>地霊殿</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>12</td>\n",
       "      <td>2009</td>\n",
       "      <td>6</td>\n",
       "      <td>星蓮船</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>13</td>\n",
       "      <td>2011</td>\n",
       "      <td>8</td>\n",
       "      <td>神霊廟</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>37</td>\n",
       "      <td>14</td>\n",
       "      <td>2013</td>\n",
       "      <td>9</td>\n",
       "      <td>輝針城</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>15</td>\n",
       "      <td>2015</td>\n",
       "      <td>11</td>\n",
       "      <td>紺珠伝</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>16</td>\n",
       "      <td>2017</td>\n",
       "      <td>13</td>\n",
       "      <td>天空璋</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>鬼形獣</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>霧雨魔理沙</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>18</td>\n",
       "      <td>2021</td>\n",
       "      <td>16</td>\n",
       "      <td>虹龍洞</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>チルノ</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>16</td>\n",
       "      <td>2017</td>\n",
       "      <td>13</td>\n",
       "      <td>天空璋</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>十六夜咲夜</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>2003</td>\n",
       "      <td>2</td>\n",
       "      <td>妖々夢</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>十六夜咲夜</td>\n",
       "      <td>8</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>永夜抄</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>31</td>\n",
       "      <td>十六夜咲夜</td>\n",
       "      <td>8</td>\n",
       "      <td>38</td>\n",
       "      <td>14</td>\n",
       "      <td>2013</td>\n",
       "      <td>9</td>\n",
       "      <td>輝針城</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>32</td>\n",
       "      <td>十六夜咲夜</td>\n",
       "      <td>8</td>\n",
       "      <td>54</td>\n",
       "      <td>18</td>\n",
       "      <td>2021</td>\n",
       "      <td>16</td>\n",
       "      <td>虹龍洞</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>魂魄妖夢</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>永夜抄</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>魂魄妖夢</td>\n",
       "      <td>18</td>\n",
       "      <td>34</td>\n",
       "      <td>13</td>\n",
       "      <td>2011</td>\n",
       "      <td>8</td>\n",
       "      <td>神霊廟</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>魂魄妖夢</td>\n",
       "      <td>18</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>鬼形獣</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>鈴仙・優曇華院・イナバ</td>\n",
       "      <td>26</td>\n",
       "      <td>42</td>\n",
       "      <td>15</td>\n",
       "      <td>2015</td>\n",
       "      <td>11</td>\n",
       "      <td>紺珠伝</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>東風谷早苗</td>\n",
       "      <td>41</td>\n",
       "      <td>30</td>\n",
       "      <td>12</td>\n",
       "      <td>2009</td>\n",
       "      <td>6</td>\n",
       "      <td>星蓮船</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>東風谷早苗</td>\n",
       "      <td>41</td>\n",
       "      <td>35</td>\n",
       "      <td>13</td>\n",
       "      <td>2011</td>\n",
       "      <td>8</td>\n",
       "      <td>神霊廟</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>東風谷早苗</td>\n",
       "      <td>41</td>\n",
       "      <td>43</td>\n",
       "      <td>15</td>\n",
       "      <td>2015</td>\n",
       "      <td>11</td>\n",
       "      <td>紺珠伝</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>東風谷早苗</td>\n",
       "      <td>41</td>\n",
       "      <td>55</td>\n",
       "      <td>18</td>\n",
       "      <td>2021</td>\n",
       "      <td>16</td>\n",
       "      <td>虹龍洞</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0           名前  old_charid  Unnamed: 0.1  番号     年  初投票回     作品  \\\n",
       "0            0         博麗霊夢           0             0   5  2000     1  旧作-西方   \n",
       "1            1         博麗霊夢           0             4   6  2002     1    紅魔郷   \n",
       "2            2         博麗霊夢           0             8   7  2003     2    妖々夢   \n",
       "3            3         博麗霊夢           0            12   8  2004     2    永夜抄   \n",
       "4            4         博麗霊夢           0            16   9  2005     4    花映塚   \n",
       "5            5         博麗霊夢           0            20  10  2007     5    風神録   \n",
       "6            6         博麗霊夢           0            24  11  2008     5    地霊殿   \n",
       "7            7         博麗霊夢           0            28  12  2009     6    星蓮船   \n",
       "8            8         博麗霊夢           0            32  13  2011     8    神霊廟   \n",
       "9            9         博麗霊夢           0            36  14  2013     9    輝針城   \n",
       "10          10         博麗霊夢           0            40  15  2015    11    紺珠伝   \n",
       "11          11         博麗霊夢           0            44  16  2017    13    天空璋   \n",
       "12          12         博麗霊夢           0            48  17  2019    15    鬼形獣   \n",
       "13          13         博麗霊夢           0            52  18  2021    16    虹龍洞   \n",
       "14          14        霧雨魔理沙           1             1   5  2000     1  旧作-西方   \n",
       "15          15        霧雨魔理沙           1             5   6  2002     1    紅魔郷   \n",
       "16          16        霧雨魔理沙           1             9   7  2003     2    妖々夢   \n",
       "17          17        霧雨魔理沙           1            13   8  2004     2    永夜抄   \n",
       "18          18        霧雨魔理沙           1            17   9  2005     4    花映塚   \n",
       "19          19        霧雨魔理沙           1            21  10  2007     5    風神録   \n",
       "20          20        霧雨魔理沙           1            25  11  2008     5    地霊殿   \n",
       "21          21        霧雨魔理沙           1            29  12  2009     6    星蓮船   \n",
       "22          22        霧雨魔理沙           1            33  13  2011     8    神霊廟   \n",
       "23          23        霧雨魔理沙           1            37  14  2013     9    輝針城   \n",
       "24          24        霧雨魔理沙           1            41  15  2015    11    紺珠伝   \n",
       "25          25        霧雨魔理沙           1            45  16  2017    13    天空璋   \n",
       "26          26        霧雨魔理沙           1            49  17  2019    15    鬼形獣   \n",
       "27          27        霧雨魔理沙           1            53  18  2021    16    虹龍洞   \n",
       "28          28          チルノ           4            46  16  2017    13    天空璋   \n",
       "29          29        十六夜咲夜           8            10   7  2003     2    妖々夢   \n",
       "30          30        十六夜咲夜           8            14   8  2004     2    永夜抄   \n",
       "31          31        十六夜咲夜           8            38  14  2013     9    輝針城   \n",
       "32          32        十六夜咲夜           8            54  18  2021    16    虹龍洞   \n",
       "33          33         魂魄妖夢          18            15   8  2004     2    永夜抄   \n",
       "34          34         魂魄妖夢          18            34  13  2011     8    神霊廟   \n",
       "35          35         魂魄妖夢          18            50  17  2019    15    鬼形獣   \n",
       "36          36  鈴仙・優曇華院・イナバ          26            42  15  2015    11    紺珠伝   \n",
       "37          37        東風谷早苗          41            30  12  2009     6    星蓮船   \n",
       "38          38        東風谷早苗          41            35  13  2011     8    神霊廟   \n",
       "39          39        東風谷早苗          41            43  15  2015    11    紺珠伝   \n",
       "40          40        東風谷早苗          41            55  18  2021    16    虹龍洞   \n",
       "\n",
       "   charid  \n",
       "0       2  \n",
       "1       2  \n",
       "2       2  \n",
       "3       2  \n",
       "4       2  \n",
       "5       2  \n",
       "6       2  \n",
       "7       2  \n",
       "8       2  \n",
       "9       2  \n",
       "10      2  \n",
       "11      2  \n",
       "12      2  \n",
       "13      2  \n",
       "14      1  \n",
       "15      1  \n",
       "16      1  \n",
       "17      1  \n",
       "18      1  \n",
       "19      1  \n",
       "20      1  \n",
       "21      1  \n",
       "22      1  \n",
       "23      1  \n",
       "24      1  \n",
       "25      1  \n",
       "26      1  \n",
       "27      1  \n",
       "28      3  \n",
       "29      0  \n",
       "30      0  \n",
       "31      0  \n",
       "32      0  \n",
       "33     26  \n",
       "34     26  \n",
       "35     26  \n",
       "36     48  \n",
       "37     92  \n",
       "38     92  \n",
       "39     92  \n",
       "40     92  "
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mainchar_ineger"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "53594910",
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>名前</th>\n",
       "      <th>番号</th>\n",
       "      <th>old_charid</th>\n",
       "      <th>bosslevel</th>\n",
       "      <th>初投票回</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>アリス・マーガトロイド</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>ルーミア</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>大妖精</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>チルノ</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>紅美鈴</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>10</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>95</td>\n",
       "      <td>119</td>\n",
       "      <td>玉造魅須丸</td>\n",
       "      <td>18.0</td>\n",
       "      <td>119</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>96</td>\n",
       "      <td>120</td>\n",
       "      <td>飯綱丸龍</td>\n",
       "      <td>18.0</td>\n",
       "      <td>120</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>97</td>\n",
       "      <td>121</td>\n",
       "      <td>菅牧典</td>\n",
       "      <td>18.0</td>\n",
       "      <td>121</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>98</td>\n",
       "      <td>122</td>\n",
       "      <td>天弓千亦</td>\n",
       "      <td>18.0</td>\n",
       "      <td>122</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>123</td>\n",
       "      <td>姫虫百々世</td>\n",
       "      <td>18.0</td>\n",
       "      <td>123</td>\n",
       "      <td>7</td>\n",
       "      <td>16</td>\n",
       "      <td>263</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0  Unnamed: 0.1           名前    番号  old_charid  bosslevel  初投票回  \\\n",
       "0            0            13  アリス・マーガトロイド   5.0          13          3     1   \n",
       "1            1             2         ルーミア   6.0           2          1     1   \n",
       "2            2             3          大妖精   6.0           3          2     1   \n",
       "3            3             4          チルノ   6.0           4          2     1   \n",
       "4            4             5          紅美鈴   6.0           5          3     1   \n",
       "..         ...           ...          ...   ...         ...        ...   ...   \n",
       "95          95           119        玉造魅須丸  18.0         119          4    16   \n",
       "96          96           120         飯綱丸龍  18.0         120          5    16   \n",
       "97          97           121          菅牧典  18.0         121          5    16   \n",
       "98          98           122         天弓千亦  18.0         122          6    16   \n",
       "99          99           123        姫虫百々世  18.0         123          7    16   \n",
       "\n",
       "   charid  \n",
       "0       8  \n",
       "1      13  \n",
       "2      59  \n",
       "3       3  \n",
       "4      10  \n",
       "..    ...  \n",
       "95    265  \n",
       "96    262  \n",
       "97    261  \n",
       "98    260  \n",
       "99    263  \n",
       "\n",
       "[100 rows x 8 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bosslist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "f4608855",
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>番号</th>\n",
       "      <th>年</th>\n",
       "      <th>初登場回</th>\n",
       "      <th>作品</th>\n",
       "      <th>名前</th>\n",
       "      <th>old_charid</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.5</td>\n",
       "      <td>2004</td>\n",
       "      <td>3</td>\n",
       "      <td>萃夢想</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>216</td>\n",
       "      <td>12.5</td>\n",
       "      <td>2010</td>\n",
       "      <td>7</td>\n",
       "      <td>ダブルスポイラー</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>338</td>\n",
       "      <td>14.3</td>\n",
       "      <td>2014</td>\n",
       "      <td>10</td>\n",
       "      <td>天邪鬼</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>376</td>\n",
       "      <td>14.5</td>\n",
       "      <td>2015</td>\n",
       "      <td>11</td>\n",
       "      <td>深秘録</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>423</td>\n",
       "      <td>15.5</td>\n",
       "      <td>2017</td>\n",
       "      <td>13</td>\n",
       "      <td>憑依華</td>\n",
       "      <td>博麗霊夢</td>\n",
       "      <td>0</td>\n",
       "      <td>2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>222</td>\n",
       "      <td>576</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2022</td>\n",
       "      <td>18</td>\n",
       "      <td>バレットフィリア達の闇市場</td>\n",
       "      <td>飯綱丸龍</td>\n",
       "      <td>120</td>\n",
       "      <td>262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>223</td>\n",
       "      <td>579</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2022</td>\n",
       "      <td>18</td>\n",
       "      <td>バレットフィリア達の闇市場</td>\n",
       "      <td>牛崎潤美</td>\n",
       "      <td>109</td>\n",
       "      <td>255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>224</td>\n",
       "      <td>583</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2022</td>\n",
       "      <td>18</td>\n",
       "      <td>バレットフィリア達の闇市場</td>\n",
       "      <td>驪駒早鬼</td>\n",
       "      <td>114</td>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>225</td>\n",
       "      <td>589</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2022</td>\n",
       "      <td>18</td>\n",
       "      <td>バレットフィリア達の闇市場</td>\n",
       "      <td>姫虫百々世</td>\n",
       "      <td>123</td>\n",
       "      <td>263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>226</td>\n",
       "      <td>591</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2022</td>\n",
       "      <td>18</td>\n",
       "      <td>バレットフィリア達の闇市場</td>\n",
       "      <td>山城たかね</td>\n",
       "      <td>117</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0  Unnamed: 0.1    番号     年  初登場回             作品     名前  \\\n",
       "0             0             0   7.5  2004     3            萃夢想   博麗霊夢   \n",
       "1             1           216  12.5  2010     7       ダブルスポイラー   博麗霊夢   \n",
       "2             2           338  14.3  2014    10            天邪鬼   博麗霊夢   \n",
       "3             3           376  14.5  2015    11            深秘録   博麗霊夢   \n",
       "4             4           423  15.5  2017    13            憑依華   博麗霊夢   \n",
       "..          ...           ...   ...   ...   ...            ...    ...   \n",
       "222         222           576  18.5  2022    18  バレットフィリア達の闇市場   飯綱丸龍   \n",
       "223         223           579  18.5  2022    18  バレットフィリア達の闇市場   牛崎潤美   \n",
       "224         224           583  18.5  2022    18  バレットフィリア達の闇市場   驪駒早鬼   \n",
       "225         225           589  18.5  2022    18  バレットフィリア達の闇市場  姫虫百々世   \n",
       "226         226           591  18.5  2022    18  バレットフィリア達の闇市場  山城たかね   \n",
       "\n",
       "     old_charid charid  \n",
       "0             0      2  \n",
       "1             0      2  \n",
       "2             0      2  \n",
       "3             0      2  \n",
       "4             0      2  \n",
       "..          ...    ...  \n",
       "222         120    262  \n",
       "223         109    255  \n",
       "224         114    252  \n",
       "225         123    263  \n",
       "226         117    266  \n",
       "\n",
       "[227 rows x 9 columns]"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subchardata\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "a00d649b",
   "metadata": {},
   "outputs": [],
   "source": [
    "mainchar_ineger.to_csv(\"data/mainchar_integer_list.csv\")\n",
    "bosslist.to_csv(\"data/bosslist.csv\")\n",
    "subchardata.to_csv(\"data/char_noninteger_list.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "44478410",
   "metadata": {},
   "source": [
    "おわり."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "93c0c244",
   "metadata": {},
   "source": [
    "# Old charid"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ddc1fee0",
   "metadata": {},
   "source": [
    "東方Wikiのリストからのデータ"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "70689db0",
   "metadata": {},
   "outputs": [],
   "source": [
    "charlist=pd.read_csv(\"data/charlist.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c1caced0",
   "metadata": {
    "scrolled": false
   },
   "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>名前</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>博麗 霊夢</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>霧雨 魔理沙</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ルーミア</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>大妖精</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>チルノ</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>玉造 魅須丸</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>飯綱丸 龍</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>菅牧 典</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>天弓 千亦</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>姫虫 百々世</td>\n",
       "      <td>123</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>124 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         名前 charid\n",
       "0     博麗 霊夢      0\n",
       "1    霧雨 魔理沙      1\n",
       "2      ルーミア      2\n",
       "3       大妖精      3\n",
       "4       チルノ      4\n",
       "..      ...    ...\n",
       "119  玉造 魅須丸    119\n",
       "120   飯綱丸 龍    120\n",
       "121    菅牧 典    121\n",
       "122   天弓 千亦    122\n",
       "123  姫虫 百々世    123\n",
       "\n",
       "[124 rows x 2 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "charids=pd.DataFrame([charlist[\"名前\"],charlist[\"charid\"]]).T\n",
    "charids"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e0b71bba",
   "metadata": {},
   "outputs": [],
   "source": [
    "char_points_ratio_id=pd.merge(char_points_ratio,charids,how=\"outer\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "172e9b66",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      0.0\n",
       "1      1.0\n",
       "2      2.0\n",
       "3      3.0\n",
       "4      4.0\n",
       "      ... \n",
       "274    NaN\n",
       "275    NaN\n",
       "276    NaN\n",
       "277    NaN\n",
       "278    NaN\n",
       "Name: Unnamed: 0, Length: 279, dtype: float64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "char_points_ratio_id[\"Unnamed: 0\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d35c5751",
   "metadata": {},
   "outputs": [],
   "source": [
    "char_points_ratio_id.to_csv(\"data/char_points_ratio_id.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "3c941093",
   "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>Unnamed: 0</th>\n",
       "      <th>名前</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>...</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>charid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>十六夜 咲夜</td>\n",
       "      <td>0.174632</td>\n",
       "      <td>0.148538</td>\n",
       "      <td>0.119437</td>\n",
       "      <td>0.066389</td>\n",
       "      <td>0.043986</td>\n",
       "      <td>0.041815</td>\n",
       "      <td>0.034421</td>\n",
       "      <td>0.034349</td>\n",
       "      <td>...</td>\n",
       "      <td>0.032236</td>\n",
       "      <td>0.033342</td>\n",
       "      <td>0.031858</td>\n",
       "      <td>0.031279</td>\n",
       "      <td>0.028652</td>\n",
       "      <td>0.028881</td>\n",
       "      <td>0.031512</td>\n",
       "      <td>0.034703</td>\n",
       "      <td>0.037877</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>霧雨 魔理沙</td>\n",
       "      <td>0.174632</td>\n",
       "      <td>0.140111</td>\n",
       "      <td>0.160269</td>\n",
       "      <td>0.074140</td>\n",
       "      <td>0.053930</td>\n",
       "      <td>0.041407</td>\n",
       "      <td>0.034437</td>\n",
       "      <td>0.031998</td>\n",
       "      <td>...</td>\n",
       "      <td>0.035802</td>\n",
       "      <td>0.038609</td>\n",
       "      <td>0.034277</td>\n",
       "      <td>0.033953</td>\n",
       "      <td>0.032413</td>\n",
       "      <td>0.033570</td>\n",
       "      <td>0.034614</td>\n",
       "      <td>0.040944</td>\n",
       "      <td>0.045544</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.0</td>\n",
       "      <td>博麗 霊夢</td>\n",
       "      <td>0.113971</td>\n",
       "      <td>0.077166</td>\n",
       "      <td>0.086974</td>\n",
       "      <td>0.070948</td>\n",
       "      <td>0.054767</td>\n",
       "      <td>0.044170</td>\n",
       "      <td>0.039348</td>\n",
       "      <td>0.038753</td>\n",
       "      <td>...</td>\n",
       "      <td>0.040317</td>\n",
       "      <td>0.039170</td>\n",
       "      <td>0.048207</td>\n",
       "      <td>0.040313</td>\n",
       "      <td>0.037626</td>\n",
       "      <td>0.038856</td>\n",
       "      <td>0.035766</td>\n",
       "      <td>0.039516</td>\n",
       "      <td>0.043074</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.0</td>\n",
       "      <td>チルノ</td>\n",
       "      <td>0.093750</td>\n",
       "      <td>0.017119</td>\n",
       "      <td>0.010821</td>\n",
       "      <td>0.018806</td>\n",
       "      <td>0.028938</td>\n",
       "      <td>0.020041</td>\n",
       "      <td>0.016506</td>\n",
       "      <td>0.015151</td>\n",
       "      <td>...</td>\n",
       "      <td>0.011058</td>\n",
       "      <td>0.011080</td>\n",
       "      <td>0.010234</td>\n",
       "      <td>0.010118</td>\n",
       "      <td>0.010923</td>\n",
       "      <td>0.012773</td>\n",
       "      <td>0.012119</td>\n",
       "      <td>0.014644</td>\n",
       "      <td>0.016072</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4.0</td>\n",
       "      <td>パチュリー・ノーレッジ</td>\n",
       "      <td>0.084559</td>\n",
       "      <td>0.051356</td>\n",
       "      <td>0.021233</td>\n",
       "      <td>0.042341</td>\n",
       "      <td>0.034503</td>\n",
       "      <td>0.026553</td>\n",
       "      <td>0.021677</td>\n",
       "      <td>0.020374</td>\n",
       "      <td>...</td>\n",
       "      <td>0.016752</td>\n",
       "      <td>0.015082</td>\n",
       "      <td>0.014046</td>\n",
       "      <td>0.013883</td>\n",
       "      <td>0.013262</td>\n",
       "      <td>0.013614</td>\n",
       "      <td>0.014173</td>\n",
       "      <td>0.014304</td>\n",
       "      <td>0.014269</td>\n",
       "      <td>7</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>NaN</td>\n",
       "      <td>丁礼田 舞</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>NaN</td>\n",
       "      <td>摩多羅 隠岐奈</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>NaN</td>\n",
       "      <td>依神 女苑</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>NaN</td>\n",
       "      <td>依神 紫苑</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>NaN</td>\n",
       "      <td>饕餮 尤魔</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>115</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>279 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0           名前         1         2         3         4  \\\n",
       "0           0.0       十六夜 咲夜  0.174632  0.148538  0.119437  0.066389   \n",
       "1           1.0       霧雨 魔理沙  0.174632  0.140111  0.160269  0.074140   \n",
       "2           2.0        博麗 霊夢  0.113971  0.077166  0.086974  0.070948   \n",
       "3           3.0          チルノ  0.093750  0.017119  0.010821  0.018806   \n",
       "4           4.0  パチュリー・ノーレッジ  0.084559  0.051356  0.021233  0.042341   \n",
       "..          ...          ...       ...       ...       ...       ...   \n",
       "274         NaN        丁礼田 舞       NaN       NaN       NaN       NaN   \n",
       "275         NaN      摩多羅 隠岐奈       NaN       NaN       NaN       NaN   \n",
       "276         NaN        依神 女苑       NaN       NaN       NaN       NaN   \n",
       "277         NaN        依神 紫苑       NaN       NaN       NaN       NaN   \n",
       "278         NaN        饕餮 尤魔       NaN       NaN       NaN       NaN   \n",
       "\n",
       "            5         6         7         8  ...        10        11  \\\n",
       "0    0.043986  0.041815  0.034421  0.034349  ...  0.032236  0.033342   \n",
       "1    0.053930  0.041407  0.034437  0.031998  ...  0.035802  0.038609   \n",
       "2    0.054767  0.044170  0.039348  0.038753  ...  0.040317  0.039170   \n",
       "3    0.028938  0.020041  0.016506  0.015151  ...  0.011058  0.011080   \n",
       "4    0.034503  0.026553  0.021677  0.020374  ...  0.016752  0.015082   \n",
       "..        ...       ...       ...       ...  ...       ...       ...   \n",
       "274       NaN       NaN       NaN       NaN  ...       NaN       NaN   \n",
       "275       NaN       NaN       NaN       NaN  ...       NaN       NaN   \n",
       "276       NaN       NaN       NaN       NaN  ...       NaN       NaN   \n",
       "277       NaN       NaN       NaN       NaN  ...       NaN       NaN   \n",
       "278       NaN       NaN       NaN       NaN  ...       NaN       NaN   \n",
       "\n",
       "           12        13        14        15        16        17        18  \\\n",
       "0    0.031858  0.031279  0.028652  0.028881  0.031512  0.034703  0.037877   \n",
       "1    0.034277  0.033953  0.032413  0.033570  0.034614  0.040944  0.045544   \n",
       "2    0.048207  0.040313  0.037626  0.038856  0.035766  0.039516  0.043074   \n",
       "3    0.010234  0.010118  0.010923  0.012773  0.012119  0.014644  0.016072   \n",
       "4    0.014046  0.013883  0.013262  0.013614  0.014173  0.014304  0.014269   \n",
       "..        ...       ...       ...       ...       ...       ...       ...   \n",
       "274       NaN       NaN       NaN       NaN       NaN       NaN       NaN   \n",
       "275       NaN       NaN       NaN       NaN       NaN       NaN       NaN   \n",
       "276       NaN       NaN       NaN       NaN       NaN       NaN       NaN   \n",
       "277       NaN       NaN       NaN       NaN       NaN       NaN       NaN   \n",
       "278       NaN       NaN       NaN       NaN       NaN       NaN       NaN   \n",
       "\n",
       "     charid  \n",
       "0         8  \n",
       "1         1  \n",
       "2         0  \n",
       "3         4  \n",
       "4         7  \n",
       "..      ...  \n",
       "274     104  \n",
       "275     105  \n",
       "276     106  \n",
       "277     107  \n",
       "278     115  \n",
       "\n",
       "[279 rows x 21 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "char_points_ratio_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e7f4c8cc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}