{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "12d5e6b1", "metadata": {}, "outputs": [], "source": [ "import os\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 27, "id": "c1bf2ce1", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['01 Home_max_slidebar.py',\n", " '02 Category.py',\n", " '03 Genre.py',\n", " '04 DLC_Counts.py',\n", " '05 Price.py',\n", " '06 Age_Restriction.py',\n", " '07 Settings.py',\n", " '08 OS.py',\n", " '09 Developer.py',\n", " '10 Publisher.py',\n", " '11 ForcaSteam.py',\n", " '12 Tensorflow.py',\n", " '13 switch_page_text.py']" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# os.listdir('.\\pages')\n", "files = os.listdir('..\\pages')\n", "files.sort()\n", "files" ] }, { "cell_type": "code", "execution_count": 20, "id": "e7b90f67", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['Home max slidebar',\n", " 'Publisher',\n", " 'ForcaSteam',\n", " 'Tensorflow',\n", " 'switch page text',\n", " 'Category',\n", " 'Genre',\n", " 'DLC Counts',\n", " 'Price',\n", " 'Age Restriction',\n", " 'Settings',\n", " 'OS',\n", " 'Developer']" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "names = []\n", "for name in files:\n", " name = name.split()[1].replace('.py', '').replace('_', ' ')\n", " names.append(name)\n", " \n", "names" ] }, { "cell_type": "code", "execution_count": 24, "id": "7372f9fc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'ipykernel_launcher.py'" ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import sys\n", "os.path.basename(sys.argv[0])" ] }, { "cell_type": "code", "execution_count": 2, "id": "59b468b7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | gamename | \n", "year | \n", "month | \n", "avg | \n", "gain | \n", "peak | \n", "avg_peak_perc | \n", "date | \n", "release_date | \n", "required_age | \n", "... | \n", "genre_sports | \n", "genre_racing | \n", "genre_rpg | \n", "genre_simulation | \n", "indie | \n", "full_audio | \n", "full_controller_support | \n", "age_0_plus | \n", "age_13_plus | \n", "age_18_plus | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "100% Orange Juice | \n", "2021 | \n", "February | \n", "278.67 | \n", "-25.23 | \n", "645 | \n", "43.2047% | \n", "2021-02-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
1 | \n", "100% Orange Juice | \n", "2021 | \n", "January | \n", "303.89 | \n", "-4.16 | \n", "614 | \n", "49.4935% | \n", "2021-01-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
2 | \n", "100% Orange Juice | \n", "2020 | \n", "December | \n", "308.05 | \n", "23.02 | \n", "743 | \n", "41.4603% | \n", "2020-12-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
3 | \n", "100% Orange Juice | \n", "2020 | \n", "November | \n", "285.03 | \n", "-7.41 | \n", "621 | \n", "45.8986% | \n", "2020-11-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
4 | \n", "100% Orange Juice | \n", "2020 | \n", "October | \n", "292.45 | \n", "46.68 | \n", "900 | \n", "32.4944% | \n", "2020-10-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
5 rows × 42 columns
\n", "\n", " | gamename | \n", "year | \n", "month | \n", "avg | \n", "gain | \n", "peak | \n", "avg_peak_perc | \n", "date | \n", "release_date | \n", "required_age | \n", "... | \n", "genre_sports | \n", "genre_racing | \n", "genre_rpg | \n", "genre_simulation | \n", "indie | \n", "full_audio | \n", "full_controller_support | \n", "age_0_plus | \n", "age_13_plus | \n", "age_18_plus | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "100% Orange Juice | \n", "2021 | \n", "February | \n", "278.67 | \n", "-25.23 | \n", "645 | \n", "43.2047 | \n", "2021-02-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
1 | \n", "100% Orange Juice | \n", "2021 | \n", "January | \n", "303.89 | \n", "-4.16 | \n", "614 | \n", "49.4935 | \n", "2021-01-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
2 | \n", "100% Orange Juice | \n", "2020 | \n", "December | \n", "308.05 | \n", "23.02 | \n", "743 | \n", "41.4603 | \n", "2020-12-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
3 | \n", "100% Orange Juice | \n", "2020 | \n", "November | \n", "285.03 | \n", "-7.41 | \n", "621 | \n", "45.8986 | \n", "2020-11-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
4 | \n", "100% Orange Juice | \n", "2020 | \n", "October | \n", "292.45 | \n", "46.68 | \n", "900 | \n", "32.4944 | \n", "2020-10-01 | \n", "2014-05-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
63848 | \n", "theHunter Classic | \n", "2014 | \n", "November | \n", "844.43 | \n", "-65.03 | \n", "1683 | \n", "50.1741 | \n", "2014-11-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63849 | \n", "theHunter Classic | \n", "2014 | \n", "October | \n", "909.46 | \n", "258.77 | \n", "2293 | \n", "39.6625 | \n", "2014-10-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63850 | \n", "theHunter Classic | \n", "2014 | \n", "September | \n", "650.69 | \n", "-63.60 | \n", "1717 | \n", "37.8969 | \n", "2014-09-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63851 | \n", "theHunter Classic | \n", "2014 | \n", "August | \n", "714.29 | \n", "-337.67 | \n", "1181 | \n", "60.4818 | \n", "2014-08-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63852 | \n", "theHunter Classic | \n", "2014 | \n", "July | \n", "1051.96 | \n", "-110.53 | \n", "2059 | \n", "51.0908 | \n", "2014-07-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
62567 rows × 42 columns
\n", "\n", " | gamename | \n", "year | \n", "month | \n", "avg | \n", "gain | \n", "peak | \n", "avg_peak_perc | \n", "date | \n", "release_date | \n", "required_age | \n", "... | \n", "genre_sports | \n", "genre_racing | \n", "genre_rpg | \n", "genre_simulation | \n", "indie | \n", "full_audio | \n", "full_controller_support | \n", "age_0_plus | \n", "age_13_plus | \n", "age_18_plus | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | \n", "12 is Better Than 6 | \n", "2021 | \n", "February | \n", "5.24 | \n", "-0.70 | \n", "13 | \n", "40.3077 | \n", "2021-02-01 | \n", "2015-11-20 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
85 | \n", "12 is Better Than 6 | \n", "2021 | \n", "January | \n", "5.94 | \n", "0.78 | \n", "18 | \n", "33.0000 | \n", "2021-01-01 | \n", "2015-11-20 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
86 | \n", "12 is Better Than 6 | \n", "2020 | \n", "December | \n", "5.16 | \n", "-0.08 | \n", "21 | \n", "24.5714 | \n", "2020-12-01 | \n", "2015-11-20 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
87 | \n", "12 is Better Than 6 | \n", "2020 | \n", "November | \n", "5.24 | \n", "0.89 | \n", "18 | \n", "29.1111 | \n", "2020-11-01 | \n", "2015-11-20 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
88 | \n", "12 is Better Than 6 | \n", "2020 | \n", "October | \n", "4.35 | \n", "0.64 | \n", "38 | \n", "11.4474 | \n", "2020-10-01 | \n", "2015-11-20 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
5 rows × 42 columns
\n", "