{ "cells": [ { "cell_type": "code", "execution_count": 78, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/tmp/ipykernel_16887/3839686170.py:21: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead\n", " df = json_normalize(data, sep = \"_\")\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "done\n" ] } ], "source": [ "import json\n", "import os\n", "from pandas.io.json import json_normalize\n", "import numpy as np\n", "import seaborn as sns\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "from matplotlib.patches import Arc, Rectangle, ConnectionPatch\n", "from matplotlib.offsetbox import OffsetImage\n", "#import squarify\n", "from functools import reduce\n", "path = \"\"\"my_events/\"\"\"\n", "Xg_req = pd.DataFrame(data=None)\n", "for filename in (os.listdir(path)):\n", " #print(filename)\n", " \n", " with open(\"%s\" % path + filename,encoding=\"utf8\") as data_file: \n", " data = json.load(data_file)\n", " df = pd.DataFrame(data=None)\n", " \n", " df = json_normalize(data, sep = \"_\")\n", " \n", " #df = df[(df['type_name'] == \"Shot\")]\n", " #df = df.loc[:,['location','shot_body_part_id','shot_end_location','shot_one_on_one','shot_technique_id','shot_type_id','under_pressure','shot_outcome_id']]\n", " #print(df.shape)\n", " Xg_req = Xg_req.append(df,ignore_index=True,sort=False)\n", " #df.drop(df.index, inplace=True)\n", " \n", "print(\"done\")\n", "df = Xg_req" ] }, { "cell_type": "code", "execution_count": 79, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "/home/mikolaj/2ait_tech/sportowe/Football-Analytics\n" ] } ], "source": [ "!pwd" ] }, { "cell_type": "code", "execution_count": 80, "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | id | \n", "index | \n", "period | \n", "timestamp | \n", "minute | \n", "second | \n", "possession | \n", "duration | \n", "type_id | \n", "type_name | \n", "... | \n", "substitution_replacement_name | \n", "50_50_outcome_id | \n", "50_50_outcome_name | \n", "foul_committed_offensive | \n", "foul_committed_card_id | \n", "foul_committed_card_name | \n", "pass_inswinging | \n", "shot_redirect | \n", "block_save_block | \n", "pass_goal_assist | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
907 | \n", "27622bee-3beb-45b5-a8e9-4353a3c48cf4 | \n", "908 | \n", "1 | \n", "00:29:57.022 | \n", "29 | \n", "57 | \n", "63 | \n", "0.602922 | \n", "16 | \n", "Shot | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2589 | \n", "7ec34223-fb09-47a9-998f-568ba958ef0d | \n", "2590 | \n", "2 | \n", "00:44:46.358 | \n", "89 | \n", "46 | \n", "194 | \n", "1.080860 | \n", "16 | \n", "Shot | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2764 | \n", "f66400ca-02a4-4121-92d4-991cb225d885 | \n", "2765 | \n", "2 | \n", "00:49:59.483 | \n", "94 | \n", "59 | \n", "209 | \n", "0.663063 | \n", "16 | \n", "Shot | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
3 rows × 117 columns
\n", "