{ "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", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
gamenameyearmonthavggainpeakavg_peak_percdaterelease_daterequired_age...genre_sportsgenre_racinggenre_rpggenre_simulationindiefull_audiofull_controller_supportage_0_plusage_13_plusage_18_plus
0100% Orange Juice2021February278.67-25.2364543.2047%2021-02-012014-05-160...0000110100
1100% Orange Juice2021January303.89-4.1661449.4935%2021-01-012014-05-160...0000110100
2100% Orange Juice2020December308.0523.0274341.4603%2020-12-012014-05-160...0000110100
3100% Orange Juice2020November285.03-7.4162145.8986%2020-11-012014-05-160...0000110100
4100% Orange Juice2020October292.4546.6890032.4944%2020-10-012014-05-160...0000110100
\n", "

5 rows × 42 columns

\n", "
" ], "text/plain": [ " gamename year month avg gain peak avg_peak_perc \\\n", "0 100% Orange Juice 2021 February 278.67 -25.23 645 43.2047% \n", "1 100% Orange Juice 2021 January 303.89 -4.16 614 49.4935% \n", "2 100% Orange Juice 2020 December 308.05 23.02 743 41.4603% \n", "3 100% Orange Juice 2020 November 285.03 -7.41 621 45.8986% \n", "4 100% Orange Juice 2020 October 292.45 46.68 900 32.4944% \n", "\n", " date release_date required_age ... genre_sports genre_racing \\\n", "0 2021-02-01 2014-05-16 0 ... 0 0 \n", "1 2021-01-01 2014-05-16 0 ... 0 0 \n", "2 2020-12-01 2014-05-16 0 ... 0 0 \n", "3 2020-11-01 2014-05-16 0 ... 0 0 \n", "4 2020-10-01 2014-05-16 0 ... 0 0 \n", "\n", " genre_rpg genre_simulation indie full_audio full_controller_support \\\n", "0 0 0 1 1 0 \n", "1 0 0 1 1 0 \n", "2 0 0 1 1 0 \n", "3 0 0 1 1 0 \n", "4 0 0 1 1 0 \n", "\n", " age_0_plus age_13_plus age_18_plus \n", "0 1 0 0 \n", "1 1 0 0 \n", "2 1 0 0 \n", "3 1 0 0 \n", "4 1 0 0 \n", "\n", "[5 rows x 42 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = pd.read_csv('../data/join_02.csv')\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 3, "id": "6e7bbe77", "metadata": {}, "outputs": [], "source": [ "# Format preparation\n", "df['date'] = pd.to_datetime(df['date'])\n", "df['release_date'] = pd.to_datetime(df['release_date'])\n", "df['avg_peak_perc'] = df['avg_peak_perc'].str.rstrip('%').astype('float') \n", "df = df.dropna()" ] }, { "cell_type": "code", "execution_count": 16, "id": "a4482277", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'100% Orange Juice'" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "gamenames = df['gamename'].unique()\n", "\n", "def search(target):\n", " result = []\n", " for gamename in gamenames:\n", " if target.lower() in gamename.lower():\n", " result.append(gamename)\n", " return result \n", "\n", "favorite_game = search(\"orange\")[0]\n", "favorite_game" ] }, { "cell_type": "code", "execution_count": 20, "id": "00cf591f", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
gamenameyearmonthavggainpeakavg_peak_percdaterelease_daterequired_age...genre_sportsgenre_racinggenre_rpggenre_simulationindiefull_audiofull_controller_supportage_0_plusage_13_plusage_18_plus
0100% Orange Juice2021February278.67-25.2364543.20472021-02-012014-05-160...0000110100
1100% Orange Juice2021January303.89-4.1661449.49352021-01-012014-05-160...0000110100
2100% Orange Juice2020December308.0523.0274341.46032020-12-012014-05-160...0000110100
3100% Orange Juice2020November285.03-7.4162145.89862020-11-012014-05-160...0000110100
4100% Orange Juice2020October292.4546.6890032.49442020-10-012014-05-160...0000110100
..................................................................
63848theHunter Classic2014November844.43-65.03168350.17412014-11-012014-06-030...1001010100
63849theHunter Classic2014October909.46258.77229339.66252014-10-012014-06-030...1001010100
63850theHunter Classic2014September650.69-63.60171737.89692014-09-012014-06-030...1001010100
63851theHunter Classic2014August714.29-337.67118160.48182014-08-012014-06-030...1001010100
63852theHunter Classic2014July1051.96-110.53205951.09082014-07-012014-06-030...1001010100
\n", "

62567 rows × 42 columns

\n", "
" ], "text/plain": [ " gamename year month avg gain peak \\\n", "0 100% Orange Juice 2021 February 278.67 -25.23 645 \n", "1 100% Orange Juice 2021 January 303.89 -4.16 614 \n", "2 100% Orange Juice 2020 December 308.05 23.02 743 \n", "3 100% Orange Juice 2020 November 285.03 -7.41 621 \n", "4 100% Orange Juice 2020 October 292.45 46.68 900 \n", "... ... ... ... ... ... ... \n", "63848 theHunter Classic 2014 November 844.43 -65.03 1683 \n", "63849 theHunter Classic 2014 October 909.46 258.77 2293 \n", "63850 theHunter Classic 2014 September 650.69 -63.60 1717 \n", "63851 theHunter Classic 2014 August 714.29 -337.67 1181 \n", "63852 theHunter Classic 2014 July 1051.96 -110.53 2059 \n", "\n", " avg_peak_perc date release_date required_age ... genre_sports \\\n", "0 43.2047 2021-02-01 2014-05-16 0 ... 0 \n", "1 49.4935 2021-01-01 2014-05-16 0 ... 0 \n", "2 41.4603 2020-12-01 2014-05-16 0 ... 0 \n", "3 45.8986 2020-11-01 2014-05-16 0 ... 0 \n", "4 32.4944 2020-10-01 2014-05-16 0 ... 0 \n", "... ... ... ... ... ... ... \n", "63848 50.1741 2014-11-01 2014-06-03 0 ... 1 \n", "63849 39.6625 2014-10-01 2014-06-03 0 ... 1 \n", "63850 37.8969 2014-09-01 2014-06-03 0 ... 1 \n", "63851 60.4818 2014-08-01 2014-06-03 0 ... 1 \n", "63852 51.0908 2014-07-01 2014-06-03 0 ... 1 \n", "\n", " genre_racing genre_rpg genre_simulation indie full_audio \\\n", "0 0 0 0 1 1 \n", "1 0 0 0 1 1 \n", "2 0 0 0 1 1 \n", "3 0 0 0 1 1 \n", "4 0 0 0 1 1 \n", "... ... ... ... ... ... \n", "63848 0 0 1 0 1 \n", "63849 0 0 1 0 1 \n", "63850 0 0 1 0 1 \n", "63851 0 0 1 0 1 \n", "63852 0 0 1 0 1 \n", "\n", " full_controller_support age_0_plus age_13_plus age_18_plus \n", "0 0 1 0 0 \n", "1 0 1 0 0 \n", "2 0 1 0 0 \n", "3 0 1 0 0 \n", "4 0 1 0 0 \n", "... ... ... ... ... \n", "63848 0 1 0 0 \n", "63849 0 1 0 0 \n", "63850 0 1 0 0 \n", "63851 0 1 0 0 \n", "63852 0 1 0 0 \n", "\n", "[62567 rows x 42 columns]" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": 21, "id": "ad7114d2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
gamenameyearmonthavggainpeakavg_peak_percdaterelease_daterequired_age...genre_sportsgenre_racinggenre_rpggenre_simulationindiefull_audiofull_controller_supportage_0_plusage_13_plusage_18_plus
8412 is Better Than 62021February5.24-0.701340.30772021-02-012015-11-200...0000101100
8512 is Better Than 62021January5.940.781833.00002021-01-012015-11-200...0000101100
8612 is Better Than 62020December5.16-0.082124.57142020-12-012015-11-200...0000101100
8712 is Better Than 62020November5.240.891829.11112020-11-012015-11-200...0000101100
8812 is Better Than 62020October4.350.643811.44742020-10-012015-11-200...0000101100
\n", "

5 rows × 42 columns

\n", "
" ], "text/plain": [ " gamename year month avg gain peak avg_peak_perc \\\n", "84 12 is Better Than 6 2021 February 5.24 -0.70 13 40.3077 \n", "85 12 is Better Than 6 2021 January 5.94 0.78 18 33.0000 \n", "86 12 is Better Than 6 2020 December 5.16 -0.08 21 24.5714 \n", "87 12 is Better Than 6 2020 November 5.24 0.89 18 29.1111 \n", "88 12 is Better Than 6 2020 October 4.35 0.64 38 11.4474 \n", "\n", " date release_date required_age ... genre_sports genre_racing \\\n", "84 2021-02-01 2015-11-20 0 ... 0 0 \n", "85 2021-01-01 2015-11-20 0 ... 0 0 \n", "86 2020-12-01 2015-11-20 0 ... 0 0 \n", "87 2020-11-01 2015-11-20 0 ... 0 0 \n", "88 2020-10-01 2015-11-20 0 ... 0 0 \n", "\n", " genre_rpg genre_simulation indie full_audio full_controller_support \\\n", "84 0 0 1 0 1 \n", "85 0 0 1 0 1 \n", "86 0 0 1 0 1 \n", "87 0 0 1 0 1 \n", "88 0 0 1 0 1 \n", "\n", " age_0_plus age_13_plus age_18_plus \n", "84 1 0 0 \n", "85 1 0 0 \n", "86 1 0 0 \n", "87 1 0 0 \n", "88 1 0 0 \n", "\n", "[5 rows x 42 columns]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_filter = df[df['gamename']!=favorite_game]\n", "df_filter.head()" ] }, { "cell_type": "code", "execution_count": 35, "id": "2ceb810a", "metadata": {}, "outputs": [], "source": [ "import numpy" ] }, { "cell_type": "code", "execution_count": 37, "id": "073ede90", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "array(['100% Orange Juice', '12 is Better Than 6', '140', '60 Seconds!',\n", " '7 Days to Die', '100% Orange Juice'], dtype=object)" ] }, "execution_count": 37, "metadata": {}, "output_type": "execute_result" } ], "source": [ "top_games = df.gamename.unique()[0:5]\n", "# top_games.append(favorite_game)\n", "top_games = numpy.append(top_games, favorite_game)\n", "top_games" ] }, { "cell_type": "code", "execution_count": null, "id": "cc15f96c", "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.11.5" } }, "nbformat": 4, "nbformat_minor": 5 }