student profile spreadsheet.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "621d821e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "8d1e334d",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('./skills.json', 'r', encoding='utf-8') as f2:\n",
    "    enData = json.load(f2)\n",
    "f2.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "10e6367b",
   "metadata": {},
   "outputs": [],
   "source": [
    "prevPath = \"../SchaleDB/images/skill/\"\n",
    "newPath = \"./images/icons/skills/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3b6a56c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "skillCounter = 0\n",
    "\n",
    "color = {\n",
    "    \"Explosion\": \"Red\",\n",
    "    \"Pierce\": \"Yellow\",\n",
    "    \"Mystic\": \"Blue\"\n",
    "}\n",
    "allSkills = [s[\"Icon\"] if \"Icon\" in s.keys() else None for student in enData for s in student[\"Skills\"]]\n",
    "\n",
    "for item in os.listdir(prevPath):\n",
    "    if item.endswith(\".png\"):\n",
    "        img = item[:-4]\n",
    "\n",
    "        if img in allSkills:\n",
    "            skillCounter += 1\n",
    "            # os.rename(f'{prevPath}{img}.png', f'{newPath}skill{skillCounter}.png')\n",
    "            for student in enData:\n",
    "                for s in student[\"Skills\"]:\n",
    "                    if \"Icon\" in s.keys():\n",
    "                        if s[\"Icon\"] == img:\n",
    "                            s[\"Icon\"] = f'skill{skillCounter}{color[student[\"BulletType\"]]}'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "ccee3b73",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "students[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0cd304e5",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(\"./skills.json\", \"w\", encoding=\"utf-8\") as f:\n",
    "    json.dump(enData, f, ensure_ascii=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a667c790",
   "metadata": {},
   "outputs": [],
   "source": [
    "varTable = [\"Shiroko\",\n",
    "    \"Serika\",\n",
    "    \"Hoshino\",\n",
    "    \"Nonomi\",\n",
    "    \"Ayane\",\n",
    "    \"Aru\",\n",
    "    \"Mutsuki\",\n",
    "    \"Kayoko\",\n",
    "    \"Haruka\",\n",
    "    \"Fuuka\",\n",
    "    \"Juri\",\n",
    "    \"Akari\",\n",
    "    \"Haruna\",\n",
    "    \"Junko\",\n",
    "    \"Izumi\",\n",
    "    \"Hina\",\n",
    "    \"Iori\",\n",
    "    \"Chinatsu\",\n",
    "    \"Hifumi\",\n",
    "    \"Tsurugi\",\n",
    "    \"Hasumi\",\n",
    "    \"Airi\",\n",
    "    \"Yoshimi\",\n",
    "    \"Hanae\",\n",
    "    \"Serina\",\n",
    "    \"Suzumi\",\n",
    "    \"Shimiko\",\n",
    "    \"Karin\",\n",
    "    \"Neru\",\n",
    "    \"Akane\",\n",
    "    \"Asuna\",\n",
    "    \"Maki\",\n",
    "    \"Hare\",\n",
    "    \"Kotama\",\n",
    "    \"Hibiki\",\n",
    "    \"Utaha\",\n",
    "    \"Kotori\",\n",
    "    \"Sumire\",\n",
    "    \"Eimi\",\n",
    "    \"Yuuka\",\n",
    "    \"Shun\",\n",
    "    \"Saya\",\n",
    "    \"Chise\",\n",
    "    \"Tsubaki\",\n",
    "    \"Pina\",\n",
    "    \"Mashiro\",\n",
    "    \"Izuna\",\n",
    "    \"Shizuko\",\n",
    "    \"Aris\",\n",
    "    \"Momoi\",\n",
    "    \"Midori\",\n",
    "    \"Cherino\",\n",
    "    \"Nodoka\",\n",
    "    \"Yuzu\",\n",
    "    \"Azusa\",\n",
    "    \"Hanako\",\n",
    "    \"Koharu\",\n",
    "    \"AzusaSwimsuit\",\n",
    "    \"MashiroSwimsuit\",\n",
    "    \"TsurugiSwimsuit\",\n",
    "    \"HifumiSwimsuit\",\n",
    "    \"HinaSwimsuit\",\n",
    "    \"IoriSwimsuit\",\n",
    "    \"IzumiSwimsuit\",\n",
    "    \"ShirokoRiding\",\n",
    "    \"Kirino\",\n",
    "    \"ShunYoung\",\n",
    "    \"SayaCasual\",\n",
    "    \"NeruBunny\",\n",
    "    \"KarinBunny\",\n",
    "    \"AsunaBunny\",\n",
    "    \"Natsu\",\n",
    "    \"Mari\",\n",
    "    \"HatsuneMiku\",\n",
    "    \"Ako\",\n",
    "    \"CherinoHotspring\",\n",
    "    \"ChinatsuHotspring\",\n",
    "    \"Tomoe\",\n",
    "    \"NodokaHotspring\",\n",
    "    \"AruNewyear\",\n",
    "    \"MutsukiNewyear\",\n",
    "    \"SerikaNewyear\",\n",
    "    \"Fubuki\",\n",
    "    \"Wakamo\",\n",
    "    \"Sena\",\n",
    "    \"Chihiro\",\n",
    "    \"Mimori\",\n",
    "    \"Ui\",\n",
    "    \"Hinata\",\n",
    "    \"Marina\",\n",
    "    \"Saki\",\n",
    "    \"Miyako\",\n",
    "    \"Miyu\",\n",
    "    \"Kaede\",\n",
    "    \"Iroha\",\n",
    "    \"Michiru\",\n",
    "    \"Tsukuyo\",\n",
    "    \"Misaki\",\n",
    "    \"Hiyori\",\n",
    "    \"Atsuko\",\n",
    "    \"NonomiSwimsuit\",\n",
    "    \"WakamoSwimsuit\",\n",
    "    \"AyaneSwimsuit\",\n",
    "    \"HoshinoSwimsuit\",\n",
    "    \"ShizukoSwimsuit\",\n",
    "    \"IzunaSwimsuit\",\n",
    "    \"ChiseSwimsuit\",\n",
    "    \"Saori\",\n",
    "    \"Moe\",\n",
    "    \"Kazusa\",\n",
    "    \"Kokona\",\n",
    "    \"UtahaCheerleader\",\n",
    "    \"Noa\",\n",
    "    \"HibikiCheerleader\",\n",
    "    \"AkaneBunny\",\n",
    "    \"YuukaTrack\",\n",
    "    \"MariTrack\",\n",
    "    \"HasumiTrack\",\n",
    "    \"Himari\",\n",
    "    \"Shigure\",\n",
    "    \"SerinaChristmas\",\n",
    "    \"HanaeChristmas\",\n",
    "    \"HarunaNewyear\",\n",
    "    \"JunkoNewyear\",\n",
    "    \"FuukaNewyear\",\n",
    "    \"Mine\",\n",
    "    \"Mika\",\n",
    "    \"Megu\",\n",
    "    \"Kanna\",\n",
    "    \"Sakurako\",\n",
    "    \"Toki\",\n",
    "    \"Nagisa\",\n",
    "    \"Koyuki\",\n",
    "    \"KayokoNewyear\",\n",
    "    \"HarukaNewyear\",\n",
    "    \"Kaho\",\n",
    "    \"ArisMaid\",\n",
    "    \"YuzuMaid\",\n",
    "    \"TokiBunny\",\n",
    "    \"Reisa\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ea134b53",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "skill9Red\n",
      "skill39Red\n",
      "skill15Yellow\n",
      "skill41Yellow\n",
      "skill36Yellow\n",
      "skill39Red\n",
      "skill3Red\n",
      "skill20Red\n",
      "skill36Red\n",
      "skill36Red\n",
      "skill42Red\n",
      "skill41Red\n",
      "skill39Blue\n",
      "skill26Yellow\n",
      "skill39Red\n",
      "skill34Red\n",
      "skill39Yellow\n",
      "skill36Yellow\n",
      "skill42Yellow\n",
      "skill24Yellow\n",
      "skill34Yellow\n",
      "skill37Red\n",
      "skill9Yellow\n",
      "skill36Red\n",
      "skill24Blue\n",
      "skill39Red\n",
      "skill35Red\n",
      "skill39Yellow\n",
      "skill23Yellow\n",
      "skill39Yellow\n",
      "skill39Blue\n",
      "skill28Yellow\n",
      "skill37Red\n",
      "skill42Red\n",
      "skill9Red\n",
      "skill75Yellow\n",
      "skill19Yellow\n",
      "skill41Yellow\n",
      "skill19Red\n",
      "skill39Red\n",
      "skill33Red\n",
      "skill30Red\n",
      "skill9Blue\n",
      "skill24Yellow\n",
      "skill24Yellow\n",
      "skill9Red\n",
      "skill9Blue\n",
      "skill42Blue\n",
      "skill47Blue\n",
      "skill41Yellow\n",
      "skill24Yellow\n",
      "skill28Yellow\n",
      "skill37Red\n",
      "skill9Yellow\n",
      "skill37Red\n",
      "skill36Yellow\n",
      "skill24Red\n",
      "skill41Blue\n",
      "skill41Blue\n",
      "skill39Blue\n",
      "skill9Yellow\n",
      "skill38Red\n",
      "skill8Red\n",
      "skill41Red\n",
      "skill27Blue\n",
      "skill42Red\n",
      "skill39Red\n",
      "skill9Yellow\n",
      "skill36Red\n",
      "skill9Blue\n",
      "skill41Blue\n",
      "skill41Blue\n",
      "skill9Blue\n",
      "skill65Red\n",
      "skill24Blue\n",
      "skill9Red\n",
      "skill41Blue\n",
      "skill39Yellow\n",
      "skill36Red\n",
      "skill9Yellow\n",
      "skill27Blue\n",
      "skill41Yellow\n",
      "skill39Yellow\n",
      "skill39Blue\n",
      "skill41Blue\n",
      "skill42Yellow\n",
      "skill24Blue\n",
      "skill41Red\n",
      "skill39Blue\n",
      "skill26Yellow\n",
      "skill7Yellow\n",
      "skill19Yellow\n",
      "skill39Yellow\n",
      "skill36Red\n",
      "skill9Blue\n",
      "skill41Blue\n",
      "skill39Blue\n",
      "skill41Red\n",
      "skill37Red\n",
      "skill11Red\n",
      "skill41Red\n",
      "skill57Yellow\n",
      "skill39Yellow\n",
      "skill39Red\n",
      "skill41Blue\n",
      "skill39Blue\n",
      "skill39Blue\n",
      "skill2Red\n",
      "skill38Yellow\n",
      "skill41Yellow\n",
      "skill24Yellow\n",
      "skill39Blue\n",
      "skill39Blue\n",
      "skill41Red\n",
      "skill9Blue\n",
      "skill35Blue\n",
      "skill36Blue\n",
      "skill39Blue\n",
      "skill37Yellow\n",
      "skill43Red\n",
      "skill41Yellow\n",
      "skill36Blue\n",
      "skill41Red\n",
      "skill39Blue\n",
      "skill35Yellow\n",
      "skill37Red\n",
      "skill39Yellow\n",
      "skill44Red\n",
      "skill37Yellow\n",
      "skill41Blue\n",
      "skill39Red\n",
      "skill24Red\n",
      "skill5Blue\n",
      "skill41Blue\n",
      "skill37Red\n",
      "skill41Blue\n",
      "skill6Blue\n",
      "skill9Red\n",
      "skill37Red\n",
      "skill15Yellow\n"
     ]
    }
   ],
   "source": [
    "c = 0\n",
    "collection = []\n",
    "for row in varTable:\n",
    "    for student in enData:\n",
    "        if (student[\"Name\"] == row):\n",
    "            for skill in student[\"Skills\"]:\n",
    "                if skill['SkillType'] == 'normal':\n",
    "                    print(\"skill\"+skill[\"Icon\"][5:])\n",
    "            \n",
    "            c += 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "68afb560",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Id': 10000,\n",
       " 'IsReleased': [True, True],\n",
       " 'DefaultOrder': 0,\n",
       " 'PathName': 'Aru',\n",
       " 'DevName': 'Aru',\n",
       " 'Name': 'Aru',\n",
       " 'School': 'Gehenna',\n",
       " 'Club': 'Kohshinjo68',\n",
       " 'StarGrade': 3,\n",
       " 'SquadType': 'Main',\n",
       " 'TacticRole': 'DamageDealer',\n",
       " 'Summons': [],\n",
       " 'Position': 'Back',\n",
       " 'BulletType': 'Explosion',\n",
       " 'ArmorType': 'LightArmor',\n",
       " 'StreetBattleAdaptation': 4,\n",
       " 'OutdoorBattleAdaptation': 2,\n",
       " 'IndoorBattleAdaptation': 0,\n",
       " 'WeaponType': 'SR',\n",
       " 'WeaponImg': 'Weapon_Icon_10000',\n",
       " 'Cover': True,\n",
       " 'Equipment': ['Hat', 'Hairpin', 'Watch'],\n",
       " 'CollectionBG': 'BG_Gehenna_Collection',\n",
       " 'CollectionTexture': 'Student_Portrait_Aru_Collection',\n",
       " 'FamilyName': 'Rikuhachima',\n",
       " 'FamilyNameRuby': '',\n",
       " 'PersonalName': 'Aru',\n",
       " 'SchoolYear': '2nd Year',\n",
       " 'CharacterAge': '16 years old',\n",
       " 'Birthday': 'March 12th',\n",
       " 'CharacterSSRNew': 'Heh heh. Good choice.',\n",
       " 'ProfileIntroduction': 'The self-proclaimed boss of Problem Solver 68.\\n\\nAru expanded the Gehenna Academy&#x27;s Problem Solver 68 club without permission to conduct illegal business activities. She aspires to be seen as a dashing and debonair villain, but her frequent blunders always expose her as a poser.',\n",
       " 'Hobby': 'Studying management',\n",
       " 'CharacterVoice': 'Reina Kondō',\n",
       " 'BirthDay': '3/12',\n",
       " 'Illustrator': 'DoReMi',\n",
       " 'Designer': 'DoReMi',\n",
       " 'CharHeightMetric': '160cm',\n",
       " 'CharHeightImperial': '5&#x27;2&quot;',\n",
       " 'StabilityPoint': 1988,\n",
       " 'AttackPower1': 369,\n",
       " 'AttackPower100': 3690,\n",
       " 'MaxHP1': 2236,\n",
       " 'MaxHP100': 19390,\n",
       " 'DefensePower1': 19,\n",
       " 'DefensePower100': 119,\n",
       " 'HealPower1': 1408,\n",
       " 'HealPower100': 4225,\n",
       " 'DodgePoint': 201,\n",
       " 'AccuracyPoint': 905,\n",
       " 'CriticalPoint': 201,\n",
       " 'CriticalDamageRate': 20000,\n",
       " 'AmmoCount': 5,\n",
       " 'AmmoCost': 1,\n",
       " 'Range': 750,\n",
       " 'RegenCost': 700,\n",
       " 'Skills': [{'SkillType': 'autoattack',\n",
       "   'Effects': [{'Type': 'DMGSingle',\n",
       "     'Hits': [10000],\n",
       "     'Scale': [10000],\n",
       "     'Frames': {'AttackEnterDuration': 45,\n",
       "      'AttackStartDuration': 15,\n",
       "      'AttackEndDuration': 16,\n",
       "      'AttackBurstRoundOverDelay': 50,\n",
       "      'AttackIngDuration': 42,\n",
       "      'AttackReloadDuration': 70},\n",
       "     'CriticalCheck': 'Check'}]},\n",
       "  {'SkillType': 'ex',\n",
       "   'Name': 'Hard-Boiled Shot',\n",
       "   'Desc': 'Fires a shot that deals <?1> damage to one enemy and explodes for an additional <?2> damage to enemies in a circular area around the target.',\n",
       "   'Parameters': [['274%',\n",
       "     '315%',\n",
       "     '397%',\n",
       "     '438%',\n",
       "     '521%',\n",
       "     '562%',\n",
       "     '644%',\n",
       "     '685%',\n",
       "     '768%',\n",
       "     '809%'],\n",
       "    ['292%',\n",
       "     '335%',\n",
       "     '423%',\n",
       "     '467%',\n",
       "     '554%',\n",
       "     '598%',\n",
       "     '686%',\n",
       "     '730%',\n",
       "     '817%',\n",
       "     '861%']],\n",
       "   'Cost': [4, 4, 4, 4, 4],\n",
       "   'Icon': 'skill9Red',\n",
       "   'Effects': [{'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [27438,\n",
       "      31554,\n",
       "      39781,\n",
       "      43898,\n",
       "      52125,\n",
       "      56241,\n",
       "      64474,\n",
       "      68585,\n",
       "      76818,\n",
       "      80934]},\n",
       "    {'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [29207,\n",
       "      33584,\n",
       "      42344,\n",
       "      46727,\n",
       "      55487,\n",
       "      59864,\n",
       "      68625,\n",
       "      73007,\n",
       "      81768,\n",
       "      86150]}]},\n",
       "  {'SkillType': 'normal',\n",
       "   'Name': 'Noir Attack',\n",
       "   'Desc': 'Every 25s, fires a shot that deals <?1> damage to one enemy with a 50% chance to explode for an additional <?2> damage to enemies in a circular area around the target.',\n",
       "   'Parameters': [['152%',\n",
       "     '160%',\n",
       "     '168%',\n",
       "     '198%',\n",
       "     '206%',\n",
       "     '213%',\n",
       "     '244%',\n",
       "     '251%',\n",
       "     '259%',\n",
       "     '290%'],\n",
       "    ['251%',\n",
       "     '263%',\n",
       "     '276%',\n",
       "     '326%',\n",
       "     '338%',\n",
       "     '351%',\n",
       "     '401%',\n",
       "     '414%',\n",
       "     '426%',\n",
       "     '476%']],\n",
       "   'Icon': 'skill39Red',\n",
       "   'Effects': [{'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [15270,\n",
       "      16035,\n",
       "      16801,\n",
       "      19851,\n",
       "      20617,\n",
       "      21376,\n",
       "      24433,\n",
       "      25198,\n",
       "      25958,\n",
       "      29014]},\n",
       "    {'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [25102,\n",
       "      26355,\n",
       "      27608,\n",
       "      32631,\n",
       "      33884,\n",
       "      35137,\n",
       "      40155,\n",
       "      41414,\n",
       "      42667,\n",
       "      47685]}]},\n",
       "  {'SkillType': 'gearnormal',\n",
       "   'Name': 'Noir Attack+',\n",
       "   'Desc': 'Every 25s, fires a shot that deals <?1> damage to one enemy with a 100% chance to explode for an additional <?2> damage to enemies in a circular area around the target.',\n",
       "   'Parameters': [['156%',\n",
       "     '163%',\n",
       "     '171%',\n",
       "     '203%',\n",
       "     '210%',\n",
       "     '218%',\n",
       "     '249%',\n",
       "     '257%',\n",
       "     '265%',\n",
       "     '296%'],\n",
       "    ['256%',\n",
       "     '269%',\n",
       "     '282%',\n",
       "     '333%',\n",
       "     '346%',\n",
       "     '359%',\n",
       "     '410%',\n",
       "     '423%',\n",
       "     '436%',\n",
       "     '487%']],\n",
       "   'Icon': 'skill39Red',\n",
       "   'Effects': [{'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [15616,\n",
       "      16398,\n",
       "      17181,\n",
       "      20305,\n",
       "      21082,\n",
       "      21864,\n",
       "      24988,\n",
       "      25771,\n",
       "      26547,\n",
       "      29672]},\n",
       "    {'Type': 'DMGSingle',\n",
       "     'CriticalCheck': 'Check',\n",
       "     'Scale': [25669,\n",
       "      26956,\n",
       "      28237,\n",
       "      33368,\n",
       "      34656,\n",
       "      35937,\n",
       "      41068,\n",
       "      42355,\n",
       "      43637,\n",
       "      48768]}]},\n",
       "  {'SkillType': 'passive',\n",
       "   'Name': 'The Gravity of a Boss',\n",
       "   'Desc': 'Increases <b:CriticalDamage> by <?1>.',\n",
       "   'Parameters': [['14%',\n",
       "     '14.7%',\n",
       "     '15.4%',\n",
       "     '18.2%',\n",
       "     '18.9%',\n",
       "     '19.6%',\n",
       "     '22.4%',\n",
       "     '23.1%',\n",
       "     '23.8%',\n",
       "     '26.6%']],\n",
       "   'Icon': 'skill41Red',\n",
       "   'Effects': [{'Type': 'BuffSelf',\n",
       "     'Stat': 'CriticalDamageRate_Coefficient',\n",
       "     'Scale': [1400, 1470, 1540, 1820, 1890, 1960, 2240, 2310, 2380, 2660]}]},\n",
       "  {'SkillType': 'weaponpassive',\n",
       "   'Name': 'The Gravity of a Boss+',\n",
       "   'Desc': 'Increases <b:CriticalDamage> by <?1> plus a further <?2>.',\n",
       "   'Parameters': [['2000',\n",
       "     '2100',\n",
       "     '2200',\n",
       "     '2600',\n",
       "     '2700',\n",
       "     '2800',\n",
       "     '3200',\n",
       "     '3300',\n",
       "     '3400',\n",
       "     '3800'],\n",
       "    ['14%',\n",
       "     '14.7%',\n",
       "     '15.4%',\n",
       "     '18.2%',\n",
       "     '18.9%',\n",
       "     '19.6%',\n",
       "     '22.4%',\n",
       "     '23.1%',\n",
       "     '23.8%',\n",
       "     '26.6%']],\n",
       "   'Icon': 'skill41Red',\n",
       "   'Effects': [{'Type': 'BuffSelf',\n",
       "     'Stat': 'CriticalDamageRate_Base',\n",
       "     'Scale': [2000, 2100, 2200, 2600, 2700, 2800, 3200, 3300, 3400, 3800]}]},\n",
       "  {'SkillType': 'sub',\n",
       "   'Name': 'Way of the Outlaw',\n",
       "   'Desc': \"Increases <b:CriticalChance> by <?1> for the duration of Aru's EX skill.\",\n",
       "   'Parameters': [['20.1%',\n",
       "     '21.1%',\n",
       "     '22.1%',\n",
       "     '26.2%',\n",
       "     '27.2%',\n",
       "     '28.2%',\n",
       "     '32.2%',\n",
       "     '33.2%',\n",
       "     '34.2%',\n",
       "     '38.3%']],\n",
       "   'Icon': 'skill41Red',\n",
       "   'Effects': [{'Type': 'BuffSelf',\n",
       "     'Value': [[2016, 2117, 2218, 2621, 2722, 2823, 3226, 3327, 3428, 3831]],\n",
       "     'Stat': 'CriticalPoint_Coefficient',\n",
       "     'Channel': 9}]}],\n",
       " 'FavorStatType': ['AttackPower', 'MaxHP'],\n",
       " 'FavorStatValue': [[4, 0],\n",
       "  [6, 0],\n",
       "  [7, 48],\n",
       "  [9, 58],\n",
       "  [2, 10],\n",
       "  [4, 15],\n",
       "  [6, 25]],\n",
       " 'FavorAlts': [10031],\n",
       " 'MemoryLobby': [6, 6],\n",
       " 'MemoryLobbyBGM': 'Guruguru Usagi',\n",
       " 'FurnitureInteraction': [[], []],\n",
       " 'FavorItemTags': ['Curios', 'Roman'],\n",
       " 'FavorItemUniqueTags': ['F_Aru'],\n",
       " 'IsLimited': 0,\n",
       " 'Weapon': {'Name': 'Wine Red/Admire',\n",
       "  'Desc': 'A semi-automatic sniper rifle with an antique design cherished by Aru.\\n\\nHer hard-boiled nature intensifies just by carrying it.',\n",
       "  'AdaptationType': 'Street',\n",
       "  'AdaptationValue': 1,\n",
       "  'AttackPower1': 162,\n",
       "  'AttackPower100': 1621,\n",
       "  'MaxHP1': 561,\n",
       "  'MaxHP100': 5607,\n",
       "  'HealPower1': 0,\n",
       "  'HealPower100': 0,\n",
       "  'StatLevelUpType': 'Standard'},\n",
       " 'Gear': {'Released': [True, True],\n",
       "  'StatType': ['AccuracyPoint_Base'],\n",
       "  'StatValue': [[150, 150]],\n",
       "  'Name': \"Aru's Very Precious Wallet\",\n",
       "  'Desc': \"A high-quality wallet Aru loves. Although it's made of fine material, it's faded and scratched due to long use. Haruka, Kayoko, and Mutsuki saved up and gave it to Aru as a gift after Problem Solver 68 was first established, so it's irreplaceable to her.\",\n",
       "  'Icon': 'Gear_Icon_10000',\n",
       "  'TierUpMaterial': [[5017, 150, 151]],\n",
       "  'TierUpMaterialAmount': [[4, 80, 25]]},\n",
       " 'SkillExMaterial': [[3030, 150],\n",
       "  [3031, 3030, 151, 150],\n",
       "  [3032, 3031, 152, 151],\n",
       "  [3033, 3032, 153, 152]],\n",
       " 'SkillExMaterialAmount': [[12, 17],\n",
       "  [12, 18, 14, 28],\n",
       "  [12, 18, 12, 24],\n",
       "  [8, 18, 9, 18]],\n",
       " 'SkillMaterial': [[4030],\n",
       "  [4030],\n",
       "  [4031, 4030, 150],\n",
       "  [4031, 151, 150],\n",
       "  [4032, 4031, 151, 150],\n",
       "  [4032, 152, 151],\n",
       "  [4033, 4032, 153, 152],\n",
       "  [4033, 153, 152]],\n",
       " 'SkillMaterialAmount': [[5],\n",
       "  [8],\n",
       "  [5, 12, 6],\n",
       "  [8, 4, 14],\n",
       "  [5, 12, 10, 16],\n",
       "  [8, 4, 18],\n",
       "  [8, 12, 4, 7],\n",
       "  [12, 9, 16]]}"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "enData[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "4e7dcfa5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "560"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(collection)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "b445f288",
   "metadata": {},
   "outputs": [],
   "source": [
    "final = set(collection)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "66975e68",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = 0\n",
    "for item in os.listdir(\"./images/icons/skills/\"):\n",
    "    if (item[:-4] not in final):\n",
    "        try:\n",
    "            os.remove(\"./images/icons/skills/\" + item)\n",
    "        except:\n",
    "            pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "1c0293ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "155"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "8bdab1a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "155"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(final)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "40661a6a",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}