{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "20ff68a8", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "import plotly.express as px\n", "import plotly.graph_objects as go\n", "\n", "\n", "import datetime\n", "import matplotlib.dates as mdates\n", "from matplotlib.dates import DateFormatter\n", "sns.set()" ] }, { "cell_type": "code", "execution_count": 2, "id": "cae9f407", "metadata": {}, "outputs": [], "source": [ "# Load the dataset\n", "df = pd.read_csv('../data/join_02.csv')" ] }, { "cell_type": "code", "execution_count": 3, "id": "c56d3c48", "metadata": {}, "outputs": [], "source": [ "# date format preparation\n", "df['date'] = pd.to_datetime(df['date'])\n", "df['release_date'] = pd.to_datetime(df['release_date'])" ] }, { "cell_type": "code", "execution_count": 4, "id": "d81c9761", "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "Index(['gamename', 'year', 'month', 'avg', 'gain', 'peak', 'avg_peak_perc',\n", " 'date', 'release_date', 'required_age', 'price', 'dlc_count', 'windows',\n", " 'mac', 'linux', 'metacritic_score', 'positive', 'negative',\n", " 'developers', 'publishers', 'average_playtime_forever',\n", " 'average_playtime_two_weeks', 'median_playtime_forever',\n", " 'median_playtime_two_weeks', 'multi_player', 'pvp', 'co-op',\n", " 'genre_action', 'genre_adventure', 'genre_casual',\n", " 'genre_sexual_content', 'genre_strategy', 'genre_sports',\n", " 'genre_racing', 'genre_rpg', 'genre_simulation', 'indie', 'full_audio',\n", " 'full_controller_support', 'age_0_plus', 'age_13_plus', 'age_18_plus'],\n", " dtype='object')" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "code", "execution_count": 6, "id": "dadb63ea", "metadata": {}, "outputs": [ { "ename": "NameError", "evalue": "name 'y' is not defined", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mNameError\u001b[0m Traceback (most recent call last)", "Cell \u001b[1;32mIn[6], line 3\u001b[0m\n\u001b[0;32m 1\u001b[0m ax \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mage_0_plus\u001b[39m\u001b[38;5;124m'\u001b[39m\n\u001b[0;32m 2\u001b[0m df_ax \u001b[38;5;241m=\u001b[39m df[df[ax]\u001b[38;5;241m==\u001b[39m\u001b[38;5;241m1\u001b[39m]\n\u001b[1;32m----> 3\u001b[0m df_ax \u001b[38;5;241m=\u001b[39m df_ax[[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mgamename\u001b[39m\u001b[38;5;124m'\u001b[39m, \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mdate\u001b[39m\u001b[38;5;124m'\u001b[39m, \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mavg\u001b[39m\u001b[38;5;124m'\u001b[39m, ax]]\u001b[38;5;241m.\u001b[39msort_values(by\u001b[38;5;241m=\u001b[39my, ascending\u001b[38;5;241m=\u001b[39morder)\u001b[38;5;241m.\u001b[39mreset_index() \u001b[38;5;66;03m# Data - Plot 1\u001b[39;00m\n\u001b[0;32m 4\u001b[0m \u001b[38;5;28mmax\u001b[39m \u001b[38;5;241m=\u001b[39m df_ax\u001b[38;5;241m.\u001b[39mgamename\u001b[38;5;241m.\u001b[39munique()\u001b[38;5;241m.\u001b[39mlen()\n\u001b[0;32m 5\u001b[0m \u001b[38;5;28mmax\u001b[39m\n", "\u001b[1;31mNameError\u001b[0m: name 'y' is not defined" ] } ], "source": [ "ax = 'age_0_plus'\n", "y = 'avg'\n", "df_ax = df[df[ax]==1]\n", "df_ax = df_ax[['gamename', 'date', y, ax]].sort_values(by=y, ascending=order).reset_index() # Data - Plot 1\n", "max = df_ax.gamename.unique().len()\n", "max" ] }, { "cell_type": "code", "execution_count": 216, "id": "bfe90d8d", "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "['Devolver Digital',\n", " 'SNK CORPORATION',\n", " 'Fullbright',\n", " 'PlayWay S.A.',\n", " 'Galactic Cafe']" ] }, "execution_count": 216, "metadata": {}, "output_type": "execute_result" } ], "source": [ "genres = df.sort_values(by='avg').publishers.unique()[0:5].tolist()\n", "genres" ] }, { "cell_type": "code", "execution_count": 217, "id": "c18a98fb", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['Devolver Digital',\n", " 'SNK CORPORATION',\n", " 'Fullbright',\n", " 'PlayWay S.A.',\n", " 'Galactic Cafe']" ] }, "execution_count": 217, "metadata": {}, "output_type": "execute_result" } ], "source": [ "for publisher in genres:\n", " # gb[publisher.strip('.').replace(' ', '_')] = (df['publishers']==publisher)*1\n", " df[publisher] = (df['publishers']==publisher)*1\n", "genres" ] }, { "cell_type": "code", "execution_count": 196, "id": "2e9db838", "metadata": { "scrolled": true }, "outputs": [ { "ename": "ValueError", "evalue": "operands could not be broadcast together with shapes (3,) (5,) ", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mValueError\u001b[0m Traceback (most recent call last)", "Cell \u001b[1;32mIn[196], line 2\u001b[0m\n\u001b[0;32m 1\u001b[0m y \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mavg\u001b[39m\u001b[38;5;124m'\u001b[39m\n\u001b[1;32m----> 2\u001b[0m [\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mgamename\u001b[39m\u001b[38;5;124m'\u001b[39m, \u001b[38;5;124m'\u001b[39m\u001b[38;5;124mdate\u001b[39m\u001b[38;5;124m'\u001b[39m, y]\u001b[38;5;241m+\u001b[39mgenres\n", "\u001b[1;31mValueError\u001b[0m: operands could not be broadcast together with shapes (3,) (5,) " ] } ], "source": [ "y = 'avg'\n", "['gamename', 'date', y]+genres" ] }, { "cell_type": "code", "execution_count": null, "id": "e2e2332e", "metadata": {}, "outputs": [], "source": [ "df_bx = df[['gamename', 'date', y]+genres].sort_values(by=y, ascending=order).reset_index() " ] }, { "cell_type": "code", "execution_count": 173, "id": "bef7a2c9", "metadata": {}, "outputs": [], "source": [ "ax = 'pvp'\n", "y = 'avg_peak_perc'\n", "genres = ['multi_player', 'pvp', 'co-op']\n", "gb_ax = df[df[ax]==1]\n", "gb_ax = gb_ax[['gamename', 'date', y, ax]].sort_values(by=y, ascending=True).reset_index()\n", "gb_ax = gb_ax.gamename.unique()[0:5]\n", "df_bx = df[['gamename', 'date', y]+genres].sort_values(by=y, ascending=True).reset_index() # Data - Plot 2" ] }, { "cell_type": "code", "execution_count": 174, "id": "60e10f02", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | date | \n", "index | \n", "multi_player | \n", "pvp | \n", "co-op | \n", "
---|---|---|---|---|---|
0 | \n", "2012-07-01 | \n", "38419.272727 | \n", "1.0 | \n", "1.0 | \n", "0.681818 | \n", "
1 | \n", "2012-08-01 | \n", "39756.833333 | \n", "1.0 | \n", "1.0 | \n", "0.666667 | \n", "
2 | \n", "2012-09-01 | \n", "38476.111111 | \n", "1.0 | \n", "1.0 | \n", "0.629630 | \n", "
3 | \n", "2012-10-01 | \n", "38960.642857 | \n", "1.0 | \n", "1.0 | \n", "0.607143 | \n", "
4 | \n", "2012-11-01 | \n", "37933.451613 | \n", "1.0 | \n", "1.0 | \n", "0.548387 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
99 | \n", "2020-10-01 | \n", "31665.257042 | \n", "1.0 | \n", "1.0 | \n", "0.556338 | \n", "
100 | \n", "2020-11-01 | \n", "31656.761404 | \n", "1.0 | \n", "1.0 | \n", "0.557895 | \n", "
101 | \n", "2020-12-01 | \n", "31943.610526 | \n", "1.0 | \n", "1.0 | \n", "0.557895 | \n", "
102 | \n", "2021-01-01 | \n", "31865.765734 | \n", "1.0 | \n", "1.0 | \n", "0.559441 | \n", "
103 | \n", "2021-02-01 | \n", "31765.275261 | \n", "1.0 | \n", "1.0 | \n", "0.557491 | \n", "
104 rows × 5 columns
\n", "\n", " | index | \n", "gamename | \n", "year | \n", "month | \n", "avg | \n", "gain | \n", "peak | \n", "avg_peak_perc | \n", "date | \n", "release_date | \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", "10427 | \n", "Counter-Strike: Global Offensive | \n", "2020 | \n", "April | \n", "857604.22 | \n", "186570.94 | \n", "1305714 | \n", "65.6809% | \n", "2020-04-01 | \n", "2012-08-21 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
1 | \n", "10426 | \n", "Counter-Strike: Global Offensive | \n", "2020 | \n", "May | \n", "768795.25 | \n", "-88808.97 | \n", "1193359 | \n", "64.4228% | \n", "2020-05-01 | \n", "2012-08-21 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
2 | \n", "10418 | \n", "Counter-Strike: Global Offensive | \n", "2021 | \n", "January | \n", "743209.66 | \n", "25405.91 | \n", "1124553 | \n", "66.0893% | \n", "2021-01-01 | \n", "2012-08-21 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
3 | \n", "10417 | \n", "Counter-Strike: Global Offensive | \n", "2021 | \n", "February | \n", "741013.24 | \n", "-2196.42 | \n", "1123485 | \n", "65.9567% | \n", "2021-02-01 | \n", "2012-08-21 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
4 | \n", "10419 | \n", "Counter-Strike: Global Offensive | \n", "2020 | \n", "December | \n", "717803.75 | \n", "49049.17 | \n", "1164396 | \n", "61.646% | \n", "2020-12-01 | \n", "2012-08-21 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
5 rows × 43 columns
\n", "\n", " | date | \n", "index | \n", "year | \n", "avg | \n", "gain | \n", "peak | \n", "required_age | \n", "price | \n", "dlc_count | \n", "windows | \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", "2012-07-01 | \n", "38419.272727 | \n", "2012.0 | \n", "3948.582273 | \n", "NaN | \n", "6573.863636 | \n", "2.318182 | \n", "11.855455 | \n", "1.818182 | \n", "1.0 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.318182 | \n", "0.090909 | \n", "0.409091 | \n", "0.818182 | \n", "0.181818 | \n", "0.863636 | \n", "0.136364 | \n", "0.000000 | \n", "
1 | \n", "2012-08-01 | \n", "39756.833333 | \n", "2012.0 | \n", "3043.825833 | \n", "-638.028182 | \n", "5068.166667 | \n", "2.125000 | \n", "11.492083 | \n", "1.791667 | \n", "1.0 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.333333 | \n", "0.083333 | \n", "0.375000 | \n", "0.833333 | \n", "0.166667 | \n", "0.875000 | \n", "0.125000 | \n", "0.000000 | \n", "
2 | \n", "2012-09-01 | \n", "38476.111111 | \n", "2012.0 | \n", "2270.342963 | \n", "-509.308333 | \n", "4443.407407 | \n", "2.518519 | \n", "12.621481 | \n", "2.370370 | \n", "1.0 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.296296 | \n", "0.074074 | \n", "0.407407 | \n", "0.814815 | \n", "0.148148 | \n", "0.851852 | \n", "0.148148 | \n", "0.000000 | \n", "
3 | \n", "2012-10-01 | \n", "38960.642857 | \n", "2012.0 | \n", "2266.883571 | \n", "80.501852 | \n", "6134.714286 | \n", "2.428571 | \n", "12.884643 | \n", "2.285714 | \n", "1.0 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.285714 | \n", "0.071429 | \n", "0.392857 | \n", "0.821429 | \n", "0.178571 | \n", "0.857143 | \n", "0.142857 | \n", "0.000000 | \n", "
4 | \n", "2012-11-01 | \n", "37933.451613 | \n", "2012.0 | \n", "2875.010968 | \n", "329.993929 | \n", "5925.258065 | \n", "2.193548 | \n", "11.798710 | \n", "2.387097 | \n", "1.0 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.258065 | \n", "0.064516 | \n", "0.419355 | \n", "0.806452 | \n", "0.161290 | \n", "0.870968 | \n", "0.129032 | \n", "0.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
99 | \n", "2020-10-01 | \n", "31665.257042 | \n", "2020.0 | \n", "3010.679930 | \n", "-95.880356 | \n", "5947.271127 | \n", "1.679577 | \n", "15.852641 | \n", "6.394366 | \n", "1.0 | \n", "... | \n", "0.073944 | \n", "0.052817 | \n", "0.257042 | \n", "0.278169 | \n", "0.507042 | \n", "0.658451 | \n", "0.306338 | \n", "0.897887 | \n", "0.098592 | \n", "0.003521 | \n", "
100 | \n", "2020-11-01 | \n", "31656.761404 | \n", "2020.0 | \n", "3252.520281 | \n", "250.749155 | \n", "6525.863158 | \n", "1.673684 | \n", "15.867158 | \n", "6.371930 | \n", "1.0 | \n", "... | \n", "0.073684 | \n", "0.052632 | \n", "0.256140 | \n", "0.280702 | \n", "0.508772 | \n", "0.656140 | \n", "0.305263 | \n", "0.898246 | \n", "0.098246 | \n", "0.003509 | \n", "
101 | \n", "2020-12-01 | \n", "31943.610526 | \n", "2020.0 | \n", "3386.813719 | \n", "86.572367 | \n", "6717.368421 | \n", "1.733333 | \n", "15.902211 | \n", "6.371930 | \n", "1.0 | \n", "... | \n", "0.073684 | \n", "0.052632 | \n", "0.256140 | \n", "0.280702 | \n", "0.508772 | \n", "0.656140 | \n", "0.305263 | \n", "0.894737 | \n", "0.101754 | \n", "0.003509 | \n", "
102 | \n", "2021-01-01 | \n", "31865.765734 | \n", "2021.0 | \n", "3927.748217 | \n", "551.905860 | \n", "7334.255245 | \n", "1.727273 | \n", "15.846608 | \n", "6.367133 | \n", "1.0 | \n", "... | \n", "0.073427 | \n", "0.052448 | \n", "0.258741 | \n", "0.279720 | \n", "0.506993 | \n", "0.657343 | \n", "0.304196 | \n", "0.895105 | \n", "0.101399 | \n", "0.003497 | \n", "
103 | \n", "2021-02-01 | \n", "31765.275261 | \n", "2021.0 | \n", "3758.608223 | \n", "-155.456620 | \n", "8125.515679 | \n", "1.721254 | \n", "15.791394 | \n", "6.344948 | \n", "1.0 | \n", "... | \n", "0.073171 | \n", "0.052265 | \n", "0.257840 | \n", "0.278746 | \n", "0.505226 | \n", "0.658537 | \n", "0.303136 | \n", "0.895470 | \n", "0.101045 | \n", "0.003484 | \n", "
104 rows × 37 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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2862 | \n", "Arma 2: Operation Arrowhead | \n", "2012 | \n", "July | \n", "3625.94 | \n", "NaN | \n", "6739 | \n", "53.8053% | \n", "2012-07-01 | \n", "2010-06-29 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
10130 | \n", "Counter-Strike | \n", "2012 | \n", "July | \n", "34139.20 | \n", "NaN | \n", "53967 | \n", "63.2594% | \n", "2012-07-01 | \n", "2000-11-01 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
16832 | \n", "E.Y.E: Divine Cybermancy | \n", "2012 | \n", "July | \n", "230.31 | \n", "NaN | \n", "758 | \n", "30.3839% | \n", "2012-07-01 | \n", "2011-07-29 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
36666 | \n", "ORION: Prelude | \n", "2012 | \n", "July | \n", "20.72 | \n", "NaN | \n", "88 | \n", "23.5455% | \n", "2012-07-01 | \n", "2013-04-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
1666 | \n", "AirMech Strike | \n", "2012 | \n", "July | \n", "10.21 | \n", "NaN | \n", "29 | \n", "35.2069% | \n", "2012-07-01 | \n", "2018-03-30 | \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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2862 | \n", "Arma 2: Operation Arrowhead | \n", "2012 | \n", "July | \n", "3625.94 | \n", "NaN | \n", "6739 | \n", "53.8053% | \n", "2012-07-01 | \n", "2010-06-29 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
10130 | \n", "Counter-Strike | \n", "2012 | \n", "July | \n", "34139.20 | \n", "NaN | \n", "53967 | \n", "63.2594% | \n", "2012-07-01 | \n", "2000-11-01 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
16832 | \n", "E.Y.E: Divine Cybermancy | \n", "2012 | \n", "July | \n", "230.31 | \n", "NaN | \n", "758 | \n", "30.3839% | \n", "2012-07-01 | \n", "2011-07-29 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
36666 | \n", "ORION: Prelude | \n", "2012 | \n", "July | \n", "20.72 | \n", "NaN | \n", "88 | \n", "23.5455% | \n", "2012-07-01 | \n", "2013-04-16 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
1666 | \n", "AirMech Strike | \n", "2012 | \n", "July | \n", "10.21 | \n", "NaN | \n", "29 | \n", "35.2069% | \n", "2012-07-01 | \n", "2018-03-30 | \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", "
9665 | \n", "Conqueror's Blade | \n", "2021 | \n", "February | \n", "3816.37 | \n", "-132.30 | \n", "10592 | \n", "36.0307% | \n", "2021-02-01 | \n", "2019-05-30 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
35151 | \n", "NARUTO SHIPPUDEN: Ultimate Ninja STORM 4 | \n", "2021 | \n", "February | \n", "1497.51 | \n", "70.64 | \n", "3641 | \n", "41.1291% | \n", "2021-02-01 | \n", "2016-02-04 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
3723 | \n", "BATTLETECH | \n", "2021 | \n", "February | \n", "1927.71 | \n", "-261.79 | \n", "3141 | \n", "61.3725% | \n", "2021-02-01 | \n", "2018-04-24 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
35291 | \n", "NBA 2K21 | \n", "2021 | \n", "February | \n", "13009.57 | \n", "2567.95 | \n", "22954 | \n", "56.6767% | \n", "2021-02-01 | \n", "2020-09-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \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", "
16420 rows × 42 columns
\n", "\n", " | index | \n", "gamename | \n", "date | \n", "avg_peak_perc | \n", "
---|---|---|---|---|
144 | \n", "114 | \n", "12 is Better Than 6 | \n", "2018-08-01 | \n", "9.9888% | \n", "
145 | \n", "60803 | \n", "War for the Overworld | \n", "2013-08-01 | \n", "9.9839% | \n", "
146 | \n", "55596 | \n", "The Witness | \n", "2016-01-01 | \n", "9.982% | \n", "
147 | \n", "63501 | \n", "Zup! 2 | \n", "2018-07-01 | \n", "9.9706% | \n", "
148 | \n", "62018 | \n", "Woodle Tree Adventures | \n", "2017-05-01 | \n", "9.9699% | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
63849 | \n", "36776 | \n", "Octodad: Dadliest Catch | \n", "2012-12-01 | \n", "0% | \n", "
63850 | \n", "6368 | \n", "Blood Bowl 2 | \n", "2013-05-01 | \n", "0% | \n", "
63851 | \n", "54947 | \n", "The Stanley Parable | \n", "2013-03-01 | \n", "0% | \n", "
63852 | \n", "54948 | \n", "The Stanley Parable | \n", "2013-02-01 | \n", "0% | \n", "
63853 | \n", "36999 | \n", "OneShot | \n", "2016-04-01 | \n", "0% | \n", "
63710 rows × 4 columns
\n", "\n", " | index | \n", "gamename | \n", "date | \n", "avg_peak_perc | \n", "
---|---|---|---|---|
0 | \n", "18005 | \n", "Europa Universalis IV | \n", "2013-05-01 | \n", "NaN% | \n", "
1 | \n", "50427 | \n", "Streets of Rogue | \n", "2016-12-01 | \n", "NaN% | \n", "
2 | \n", "38544 | \n", "Pavlov VR | \n", "2016-12-01 | \n", "NaN% | \n", "
3 | \n", "7482 | \n", "Broken Age | \n", "2013-09-01 | \n", "NaN% | \n", "
4 | \n", "1512 | \n", "Age of Wonders III | \n", "2013-10-01 | \n", "NaN% | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
63849 | \n", "36776 | \n", "Octodad: Dadliest Catch | \n", "2012-12-01 | \n", "0% | \n", "
63850 | \n", "6368 | \n", "Blood Bowl 2 | \n", "2013-05-01 | \n", "0% | \n", "
63851 | \n", "54947 | \n", "The Stanley Parable | \n", "2013-03-01 | \n", "0% | \n", "
63852 | \n", "54948 | \n", "The Stanley Parable | \n", "2013-02-01 | \n", "0% | \n", "
63853 | \n", "36999 | \n", "OneShot | \n", "2016-04-01 | \n", "0% | \n", "
63854 rows × 4 columns
\n", "\n", " | index | \n", "gamename | \n", "date | \n", "avg | \n", "
---|---|---|---|---|
28067 | \n", "34550 | \n", "Mount & Blade | \n", "2012-07-01 | \n", "248.73 | \n", "
36605 | \n", "18594 | \n", "F.E.A.R. 2: Project Origin | \n", "2012-07-01 | \n", "121.24 | \n", "
10396 | \n", "32900 | \n", "Max Payne 3 | \n", "2012-07-01 | \n", "1446.18 | \n", "
25757 | \n", "49599 | \n", "Star Wars: Battlefront 2 (Classic, 2005) | \n", "2012-07-01 | \n", "303.06 | \n", "
36810 | \n", "18490 | \n", "F.E.A.R. | \n", "2012-07-01 | \n", "119.23 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
48031 | \n", "44107 | \n", "Road Redemption | \n", "2021-02-01 | \n", "44.25 | \n", "
7272 | \n", "57018 | \n", "Total War: ATTILA | \n", "2021-02-01 | \n", "2453.03 | \n", "
10170 | \n", "48006 | \n", "Slime Rancher | \n", "2021-02-01 | \n", "1497.59 | \n", "
22465 | \n", "29531 | \n", "Kingdoms Reborn | \n", "2021-02-01 | \n", "404.05 | \n", "
14120 | \n", "28251 | \n", "Ironsight | \n", "2021-02-01 | \n", "905.29 | \n", "
63854 rows × 4 columns
\n", "\n", " | index | \n", "gamename | \n", "date | \n", "gain | \n", "
---|---|---|---|---|
0 | \n", "11535 | \n", "Cyberpunk 2077 | \n", "2021-01-01 | \n", "-250248.99 | \n", "
1 | \n", "19830 | \n", "Fallout 4 | \n", "2015-12-01 | \n", "-132161.46 | \n", "
2 | \n", "33997 | \n", "Monster Hunter: World | \n", "2018-09-01 | \n", "-99716.06 | \n", "
3 | \n", "23425 | \n", "Grand Theft Auto V | \n", "2015-05-01 | \n", "-99352.39 | \n", "
4 | \n", "15670 | \n", "Dota 2 | \n", "2015-09-01 | \n", "-98787.12 | \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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11535 | \n", "Cyberpunk 2077 | \n", "2021 | \n", "January | \n", "82146.66 | \n", "-250248.99 | \n", "225670 | \n", "36.4012% | \n", "2021-01-01 | \n", "2020-12-09 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
19830 | \n", "Fallout 4 | \n", "2015 | \n", "December | \n", "94136.37 | \n", "-132161.46 | \n", "201635 | \n", "46.6865% | \n", "2015-12-01 | \n", "2015-11-09 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "
33997 | \n", "Monster Hunter: World | \n", "2018 | \n", "September | \n", "88575.17 | \n", "-99716.06 | \n", "227644 | \n", "38.9095% | \n", "2018-09-01 | \n", "2018-08-09 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
23425 | \n", "Grand Theft Auto V | \n", "2015 | \n", "May | \n", "93361.62 | \n", "-99352.39 | \n", "215966 | \n", "43.2298% | \n", "2015-05-01 | \n", "2015-04-13 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "
15670 | \n", "Dota 2 | \n", "2015 | \n", "September | \n", "508156.85 | \n", "-98787.12 | \n", "888728 | \n", "57.178% | \n", "2015-09-01 | \n", "2013-07-09 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \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", "
63570 | \n", "Zup! 3 | \n", "2017 | \n", "January | \n", "91.49 | \n", "NaN | \n", "687 | \n", "13.3173% | \n", "2017-01-01 | \n", "2017-01-12 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63652 | \n", "ibb & obb | \n", "2014 | \n", "May | \n", "16.25 | \n", "NaN | \n", "186 | \n", "8.7366% | \n", "2014-05-01 | \n", "2014-05-26 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
63708 | \n", "klocki | \n", "2016 | \n", "July | \n", "38.36 | \n", "NaN | \n", "121 | \n", "31.7025% | \n", "2016-07-01 | \n", "2016-07-13 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63772 | \n", "rFactor 2 | \n", "2015 | \n", "November | \n", "112.81 | \n", "NaN | \n", "313 | \n", "36.0415% | \n", "2015-11-01 | \n", "2015-11-12 | \n", "0 | \n", "... | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63853 | \n", "theHunter Classic | \n", "2014 | \n", "June | \n", "1162.48 | \n", "NaN | \n", "2648 | \n", "43.9003% | \n", "2014-06-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", "
63854 rows × 42 columns
\n", "