{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load\n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the read-only \"../input/\" directory\n# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))\n\n# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using \"Save & Run All\" \n# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2021-07-30T12:35:15.603974Z","iopub.execute_input":"2021-07-30T12:35:15.604687Z","iopub.status.idle":"2021-07-30T12:35:15.626764Z","shell.execute_reply.started":"2021-07-30T12:35:15.604559Z","shell.execute_reply":"2021-07-30T12:35:15.625557Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport matplotlib.pyplot as plt\nimport seaborn as sns\n\nplt.style.use('seaborn')\nsns.set(font_scale=2.5)\n\nimport missingno as msno\n\n# ignore warnings\nimport warnings\nwarnings.filterwarnings('ignore')\n\n%matplotlib inline","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:35:15.628615Z","iopub.execute_input":"2021-07-30T12:35:15.628956Z","iopub.status.idle":"2021-07-30T12:35:16.790901Z","shell.execute_reply.started":"2021-07-30T12:35:15.628922Z","shell.execute_reply":"2021-07-30T12:35:16.789983Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train = pd.read_csv('../input/mlb-player-digital-engagement-forecasting/train.csv')\ndf_test = pd.read_csv('../input/mlb-player-digital-engagement-forecasting/example_test.csv')","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:35:16.792925Z","iopub.execute_input":"2021-07-30T12:35:16.793609Z","iopub.status.idle":"2021-07-30T12:36:42.727093Z","shell.execute_reply.started":"2021-07-30T12:35:16.79356Z","shell.execute_reply":"2021-07-30T12:36:42.72579Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.729468Z","iopub.execute_input":"2021-07-30T12:36:42.730159Z","iopub.status.idle":"2021-07-30T12:36:42.830143Z","shell.execute_reply.started":"2021-07-30T12:36:42.730087Z","shell.execute_reply":"2021-07-30T12:36:42.829152Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.describe()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.831445Z","iopub.execute_input":"2021-07-30T12:36:42.831751Z","iopub.status.idle":"2021-07-30T12:36:42.86079Z","shell.execute_reply.started":"2021-07-30T12:36:42.831712Z","shell.execute_reply":"2021-07-30T12:36:42.85953Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.max()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.862395Z","iopub.execute_input":"2021-07-30T12:36:42.862731Z","iopub.status.idle":"2021-07-30T12:36:42.877597Z","shell.execute_reply.started":"2021-07-30T12:36:42.862696Z","shell.execute_reply":"2021-07-30T12:36:42.876857Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.columns","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.878829Z","iopub.execute_input":"2021-07-30T12:36:42.879277Z","iopub.status.idle":"2021-07-30T12:36:42.893855Z","shell.execute_reply.started":"2021-07-30T12:36:42.879236Z","shell.execute_reply":"2021-07-30T12:36:42.892735Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"for col in df_test.columns:\n    msg = 'column : {:>10}\\t Percent of NaN value: {:.2f}%'.format(col, 100*(df_train[col].isnull().sum() / df_train[col].shape[0]))\n    print(msg)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.914695Z","iopub.execute_input":"2021-07-30T12:36:42.914989Z","iopub.status.idle":"2021-07-30T12:36:42.930901Z","shell.execute_reply.started":"2021-07-30T12:36:42.914959Z","shell.execute_reply":"2021-07-30T12:36:42.92973Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players = pd.read_csv('../input/mlb-player-digital-engagement-forecasting/players.csv')","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.932522Z","iopub.execute_input":"2021-07-30T12:36:42.932945Z","iopub.status.idle":"2021-07-30T12:36:42.952176Z","shell.execute_reply.started":"2021-07-30T12:36:42.932899Z","shell.execute_reply":"2021-07-30T12:36:42.95131Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.95327Z","iopub.execute_input":"2021-07-30T12:36:42.953767Z","iopub.status.idle":"2021-07-30T12:36:42.978824Z","shell.execute_reply.started":"2021-07-30T12:36:42.953723Z","shell.execute_reply":"2021-07-30T12:36:42.977623Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.shape","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.980641Z","iopub.execute_input":"2021-07-30T12:36:42.981049Z","iopub.status.idle":"2021-07-30T12:36:42.996525Z","shell.execute_reply.started":"2021-07-30T12:36:42.981012Z","shell.execute_reply":"2021-07-30T12:36:42.995456Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.groupby(['heightInches'], as_index=True).count()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:42.998063Z","iopub.execute_input":"2021-07-30T12:36:42.99847Z","iopub.status.idle":"2021-07-30T12:36:43.036398Z","shell.execute_reply.started":"2021-07-30T12:36:42.998439Z","shell.execute_reply":"2021-07-30T12:36:43.03526Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.groupby(['birthCity'], as_index=True).count()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.037708Z","iopub.execute_input":"2021-07-30T12:36:43.037987Z","iopub.status.idle":"2021-07-30T12:36:43.066932Z","shell.execute_reply.started":"2021-07-30T12:36:43.037959Z","shell.execute_reply":"2021-07-30T12:36:43.065923Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players[['birthCity', 'playerId']].groupby(['birthCity']).count()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.068306Z","iopub.execute_input":"2021-07-30T12:36:43.068624Z","iopub.status.idle":"2021-07-30T12:36:43.085474Z","shell.execute_reply.started":"2021-07-30T12:36:43.068592Z","shell.execute_reply":"2021-07-30T12:36:43.084338Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.groupby(['primaryPositionCode'], as_index=True).count()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.08671Z","iopub.execute_input":"2021-07-30T12:36:43.087258Z","iopub.status.idle":"2021-07-30T12:36:43.115868Z","shell.execute_reply.started":"2021-07-30T12:36:43.087217Z","shell.execute_reply":"2021-07-30T12:36:43.114766Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"birthCountry = df_train_players.groupby(['birthCountry'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.117123Z","iopub.execute_input":"2021-07-30T12:36:43.11744Z","iopub.status.idle":"2021-07-30T12:36:43.122381Z","shell.execute_reply.started":"2021-07-30T12:36:43.117408Z","shell.execute_reply":"2021-07-30T12:36:43.121393Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"birthCountry.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.127492Z","iopub.execute_input":"2021-07-30T12:36:43.128048Z","iopub.status.idle":"2021-07-30T12:36:43.14002Z","shell.execute_reply.started":"2021-07-30T12:36:43.128003Z","shell.execute_reply":"2021-07-30T12:36:43.139149Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"PositionName = df_train_players.groupby(['primaryPositionName'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.142705Z","iopub.execute_input":"2021-07-30T12:36:43.143193Z","iopub.status.idle":"2021-07-30T12:36:43.15278Z","shell.execute_reply.started":"2021-07-30T12:36:43.143148Z","shell.execute_reply":"2021-07-30T12:36:43.151923Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"PositionName.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.153878Z","iopub.execute_input":"2021-07-30T12:36:43.154463Z","iopub.status.idle":"2021-07-30T12:36:43.168493Z","shell.execute_reply.started":"2021-07-30T12:36:43.154415Z","shell.execute_reply":"2021-07-30T12:36:43.167254Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(df_train_players['primaryPositionName'], df_train_players['birthCountry'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.169945Z","iopub.execute_input":"2021-07-30T12:36:43.170293Z","iopub.status.idle":"2021-07-30T12:36:43.295096Z","shell.execute_reply.started":"2021-07-30T12:36:43.170258Z","shell.execute_reply":"2021-07-30T12:36:43.294339Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.groupby(['primaryPositionName'], as_index=True).count()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.296311Z","iopub.execute_input":"2021-07-30T12:36:43.29681Z","iopub.status.idle":"2021-07-30T12:36:43.318047Z","shell.execute_reply.started":"2021-07-30T12:36:43.296743Z","shell.execute_reply":"2021-07-30T12:36:43.31733Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.loc[:, 'primaryPositionName']","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.319156Z","iopub.execute_input":"2021-07-30T12:36:43.319585Z","iopub.status.idle":"2021-07-30T12:36:43.327588Z","shell.execute_reply.started":"2021-07-30T12:36:43.319543Z","shell.execute_reply":"2021-07-30T12:36:43.32643Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"USA_players_country = df_train_players['birthCountry'] == 'USA'","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.329327Z","iopub.execute_input":"2021-07-30T12:36:43.329804Z","iopub.status.idle":"2021-07-30T12:36:43.340789Z","shell.execute_reply.started":"2021-07-30T12:36:43.329759Z","shell.execute_reply":"2021-07-30T12:36:43.339824Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"USA_players = df_train_players[USA_players_country]\nUSA_players","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.342376Z","iopub.execute_input":"2021-07-30T12:36:43.342712Z","iopub.status.idle":"2021-07-30T12:36:43.373538Z","shell.execute_reply.started":"2021-07-30T12:36:43.342683Z","shell.execute_reply":"2021-07-30T12:36:43.372506Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"USA_players_position = USA_players.groupby(['primaryPositionName'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.375299Z","iopub.execute_input":"2021-07-30T12:36:43.375635Z","iopub.status.idle":"2021-07-30T12:36:43.386343Z","shell.execute_reply.started":"2021-07-30T12:36:43.375603Z","shell.execute_reply":"2021-07-30T12:36:43.384994Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"USA_players_position.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.387812Z","iopub.execute_input":"2021-07-30T12:36:43.388512Z","iopub.status.idle":"2021-07-30T12:36:43.402738Z","shell.execute_reply.started":"2021-07-30T12:36:43.388465Z","shell.execute_reply":"2021-07-30T12:36:43.401864Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Dominican_Republic_players = df_train_players['birthCountry'] == 'Dominican Republic'","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.404137Z","iopub.execute_input":"2021-07-30T12:36:43.404524Z","iopub.status.idle":"2021-07-30T12:36:43.414849Z","shell.execute_reply.started":"2021-07-30T12:36:43.40449Z","shell.execute_reply":"2021-07-30T12:36:43.413802Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Dominican_Republic_players = df_train_players[Dominican_Republic_players]\nDominican_Republic_players","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.416296Z","iopub.execute_input":"2021-07-30T12:36:43.416644Z","iopub.status.idle":"2021-07-30T12:36:43.447978Z","shell.execute_reply.started":"2021-07-30T12:36:43.416611Z","shell.execute_reply":"2021-07-30T12:36:43.446942Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Dominican_Republic_players_position = Dominican_Republic_players.groupby(['primaryPositionName'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.449243Z","iopub.execute_input":"2021-07-30T12:36:43.449526Z","iopub.status.idle":"2021-07-30T12:36:43.454486Z","shell.execute_reply.started":"2021-07-30T12:36:43.449498Z","shell.execute_reply":"2021-07-30T12:36:43.453391Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Dominican_Republic_players_position = Dominican_Republic_players.groupby(['primaryPositionName'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.455847Z","iopub.execute_input":"2021-07-30T12:36:43.456189Z","iopub.status.idle":"2021-07-30T12:36:43.465331Z","shell.execute_reply.started":"2021-07-30T12:36:43.456158Z","shell.execute_reply":"2021-07-30T12:36:43.46433Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Dominican_Republic_players_position.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.466498Z","iopub.execute_input":"2021-07-30T12:36:43.466907Z","iopub.status.idle":"2021-07-30T12:36:43.480187Z","shell.execute_reply.started":"2021-07-30T12:36:43.466876Z","shell.execute_reply":"2021-07-30T12:36:43.479148Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(25,15))\n\nplt.title('Dominican_Republic_players_Position' , fontsize=10)\n\nplt.ylabel('Counts' , fontsize=15)\nplt.xlabel('Positions_Counts' , fontsize=15)\n\nDominican_Republic_players_position['primaryPositionName'].value_counts().plot.barh(color = ['lightblue', 'tomato'])\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.481831Z","iopub.execute_input":"2021-07-30T12:36:43.482166Z","iopub.status.idle":"2021-07-30T12:36:43.950426Z","shell.execute_reply.started":"2021-07-30T12:36:43.482118Z","shell.execute_reply":"2021-07-30T12:36:43.949448Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(25,15))\n\nplt.title('Dominican_Republic_players_Position' , fontsize=10)\n\nplt.ylabel('Counts' , fontsize=15)\nplt.xlabel('Positions' , fontsize=15)\n\nDominican_Republic_players_position['primaryPositionName'].value_counts().plot.bar(color = ['lightblue', 'tomato'])\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:43.952032Z","iopub.execute_input":"2021-07-30T12:36:43.952454Z","iopub.status.idle":"2021-07-30T12:36:44.365964Z","shell.execute_reply.started":"2021-07-30T12:36:43.952418Z","shell.execute_reply":"2021-07-30T12:36:44.364968Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(7,7))\n\nplt.title('Dominican_Republic_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nDominican_Republic_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.367421Z","iopub.execute_input":"2021-07-30T12:36:44.367731Z","iopub.status.idle":"2021-07-30T12:36:44.640547Z","shell.execute_reply.started":"2021-07-30T12:36:44.367701Z","shell.execute_reply":"2021-07-30T12:36:44.639298Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(7,7))\n\nplt.title('USA_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nUSA_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.641907Z","iopub.execute_input":"2021-07-30T12:36:44.642239Z","iopub.status.idle":"2021-07-30T12:36:44.878942Z","shell.execute_reply.started":"2021-07-30T12:36:44.642206Z","shell.execute_reply":"2021-07-30T12:36:44.877839Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players = df_train_players['birthCountry'] == 'Japan'","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.880364Z","iopub.execute_input":"2021-07-30T12:36:44.880662Z","iopub.status.idle":"2021-07-30T12:36:44.886443Z","shell.execute_reply.started":"2021-07-30T12:36:44.880633Z","shell.execute_reply":"2021-07-30T12:36:44.88498Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players = df_train_players[Japan_players]\nJapan_players","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.888073Z","iopub.execute_input":"2021-07-30T12:36:44.888442Z","iopub.status.idle":"2021-07-30T12:36:44.92546Z","shell.execute_reply.started":"2021-07-30T12:36:44.88841Z","shell.execute_reply":"2021-07-30T12:36:44.924006Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players_position = Japan_players.groupby(['primaryPositionName'], as_index=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.927332Z","iopub.execute_input":"2021-07-30T12:36:44.92781Z","iopub.status.idle":"2021-07-30T12:36:44.93943Z","shell.execute_reply.started":"2021-07-30T12:36:44.927671Z","shell.execute_reply":"2021-07-30T12:36:44.938189Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players_position.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.940877Z","iopub.execute_input":"2021-07-30T12:36:44.94127Z","iopub.status.idle":"2021-07-30T12:36:44.957525Z","shell.execute_reply.started":"2021-07-30T12:36:44.941238Z","shell.execute_reply":"2021-07-30T12:36:44.956471Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(25,15))\n\nplt.title('Japan_players_Position' , fontsize=10)\n\nplt.ylabel('Count' , fontsize=15)\nplt.xlabel('Positions_Counts' , fontsize=15)\n\nJapan_players_position['primaryPositionName'].value_counts().plot.barh(color = ['lightblue', 'tomato'])\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:44.958861Z","iopub.execute_input":"2021-07-30T12:36:44.959278Z","iopub.status.idle":"2021-07-30T12:36:45.290794Z","shell.execute_reply.started":"2021-07-30T12:36:44.959235Z","shell.execute_reply":"2021-07-30T12:36:45.29005Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(7,7))\n\nplt.title('Japan_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nJapan_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:45.291952Z","iopub.execute_input":"2021-07-30T12:36:45.292423Z","iopub.status.idle":"2021-07-30T12:36:45.595982Z","shell.execute_reply.started":"2021-07-30T12:36:45.292377Z","shell.execute_reply":"2021-07-30T12:36:45.59486Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.figure(figsize=(7,7))\n\nplt.title('Dominican_Republic_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nDominican_Republic_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\n\nplt.figure(figsize=(7,7))\n\nplt.title('USA_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nUSA_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\n\nplt.figure(figsize=(7,7))\n\nplt.title('Japan_players_Position' , fontsize=20)\n\nplt.ylabel('' , fontsize=15)\n\nJapan_players_position['primaryPositionName'].value_counts().plot.pie(autopct = '%.2f%%' , \n                                         colors = ['lightblue', 'tomato'] , \n                                         textprops = {'fontsize' : 12 , \n                                                      'weight' : 'bold'})\n\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:45.5973Z","iopub.execute_input":"2021-07-30T12:36:45.597801Z","iopub.status.idle":"2021-07-30T12:36:46.182913Z","shell.execute_reply.started":"2021-07-30T12:36:45.597739Z","shell.execute_reply":"2021-07-30T12:36:46.182163Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"f, ax = plt.subplots(1, 2, figsize = (18, 8))\nsns.violinplot('Pclass', 'primaryPositionName', hue='Survived', data = df_train, scale='count', split=False, ax=ax[0])\nax[0].set_title('Pclass and Age vs Survived')\nax[0].set_yticks(range(0, 110, 10))\n\nsns.violinplot('Sex', 'Age', hue='Survived', data=df_train, scale='count', split=True, ax=ax[1])\nax[1].set_title('Sex and Age vs Survived')\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.184542Z","iopub.execute_input":"2021-07-30T12:36:46.184969Z","iopub.status.idle":"2021-07-30T12:36:46.734975Z","shell.execute_reply.started":"2021-07-30T12:36:46.184935Z","shell.execute_reply":"2021-07-30T12:36:46.733233Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players_position.size()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.735952Z","iopub.status.idle":"2021-07-30T12:36:46.736599Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players.head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.737533Z","iopub.status.idle":"2021-07-30T12:36:46.73817Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(Japan_players['birthCity'], Japan_players['primaryPositionName'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.739048Z","iopub.status.idle":"2021-07-30T12:36:46.739685Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(USA_players['birthCity'], USA_players['primaryPositionName'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.740576Z","iopub.status.idle":"2021-07-30T12:36:46.74121Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(Dominican_Republic_players['birthCity'], Dominican_Republic_players['primaryPositionName'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.742104Z","iopub.status.idle":"2021-07-30T12:36:46.74271Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_players = pd.read_csv('../input/mlb-player-digital-engagement-forecasting/players.csv')","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.743602Z","iopub.status.idle":"2021-07-30T12:36:46.74422Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_players.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.745121Z","iopub.status.idle":"2021-07-30T12:36:46.745725Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_players.shape","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.746609Z","iopub.status.idle":"2021-07-30T12:36:46.747225Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_players.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.748095Z","iopub.status.idle":"2021-07-30T12:36:46.748687Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.plot('weight',  # x\n         'heightInches',  # y\n         data=Japan_players, \n         linestyle='none', \n         marker='o', \n         markersize=10,\n         color='blue', \n         alpha=0.5)\n\nplt.title('weight & heightInches', fontsize=20)\nplt.xlabel('Weight (lb)', fontsize=14)\nplt.ylabel('Height', fontsize=14)\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.749563Z","iopub.status.idle":"2021-07-30T12:36:46.750194Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"plt.plot('weight',  # x\n         'heightInches',  # y\n         data=Dominican_Republic_players, \n         linestyle='none', \n         marker='o', \n         markersize=10,\n         color='blue', \n         alpha=0.5)\n\nplt.title('weight & heightInches', fontsize=20)\nplt.xlabel('Weight (lb)', fontsize=14)\nplt.ylabel('Height', fontsize=14)\nplt.show()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.751047Z","iopub.status.idle":"2021-07-30T12:36:46.751657Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"weight_mean_df = Dominican_Republic_players['weight'].mean()\nheight_mean_df = Dominican_Republic_players['heightInches'].mean()\nprint(\"Mean of Domonican Republic Players weight %.2lf lb\" %weight_mean_df)\nprint(\"Mean of Domonican Republic Players height %.2lf inches\" %height_mean_df)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.752523Z","iopub.status.idle":"2021-07-30T12:36:46.753161Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"212 파운드 = 약 96키로\n73 인치 = 약 1.85 미터","metadata":{}},{"cell_type":"code","source":"weight_mean_df = Japan_players['weight'].mean()\nheight_mean_df = Japan_players['heightInches'].mean()\nprint(\"Mean of Japan Players height %.2lf lb\" %weight_mean_df)\nprint(\"Mean of Japan Players height %.2lf inches\" %height_mean_df)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.754016Z","iopub.status.idle":"2021-07-30T12:36:46.754637Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"weight_mean_df = USA_players['weight'].mean()\nheight_mean_df = USA_players['heightInches'].mean()\nprint(\"Mean of USA Players height %.2lf lb\" %weight_mean_df)\nprint(\"Mean of USA Players height %.2lf inches\" %height_mean_df)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.755514Z","iopub.status.idle":"2021-07-30T12:36:46.756129Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_players.columns","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.756979Z","iopub.status.idle":"2021-07-30T12:36:46.757587Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(USA_players['birthStateProvince'], USA_players['playerId'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.758467Z","iopub.status.idle":"2021-07-30T12:36:46.759068Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"CA: Califonia\nFL: Florida\nTX: Texas","metadata":{}},{"cell_type":"code","source":"Japan_players.columns","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.759963Z","iopub.status.idle":"2021-07-30T12:36:46.760575Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"Japan_players['birthStateProvince']","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.761464Z","iopub.status.idle":"2021-07-30T12:36:46.762058Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(Japan_players['birthCity'], Japan_players['playerId'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.762956Z","iopub.status.idle":"2021-07-30T12:36:46.763584Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.crosstab(Dominican_Republic_players['birthCity'], Dominican_Republic_players['playerId'], margins=True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:36:46.764443Z","iopub.status.idle":"2021-07-30T12:36:46.765041Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"20210730","metadata":{}},{"cell_type":"code","source":"df_train.columns","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:38:50.40228Z","iopub.execute_input":"2021-07-30T12:38:50.402667Z","iopub.status.idle":"2021-07-30T12:38:50.409401Z","shell.execute_reply.started":"2021-07-30T12:38:50.402637Z","shell.execute_reply":"2021-07-30T12:38:50.408393Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:54:22.460735Z","iopub.execute_input":"2021-07-30T13:54:22.461171Z","iopub.status.idle":"2021-07-30T13:54:22.50185Z","shell.execute_reply.started":"2021-07-30T13:54:22.461131Z","shell.execute_reply":"2021-07-30T13:54:22.501035Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train['games'].head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:42:41.788288Z","iopub.execute_input":"2021-07-30T12:42:41.788661Z","iopub.status.idle":"2021-07-30T12:42:41.797179Z","shell.execute_reply.started":"2021-07-30T12:42:41.788625Z","shell.execute_reply":"2021-07-30T12:42:41.796019Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train.head(30)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:44:00.443779Z","iopub.execute_input":"2021-07-30T12:44:00.444521Z","iopub.status.idle":"2021-07-30T12:44:00.546864Z","shell.execute_reply.started":"2021-07-30T12:44:00.444484Z","shell.execute_reply":"2021-07-30T12:44:00.546124Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train['awards'].head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:43:23.10579Z","iopub.execute_input":"2021-07-30T12:43:23.106223Z","iopub.status.idle":"2021-07-30T12:43:23.114369Z","shell.execute_reply.started":"2021-07-30T12:43:23.106185Z","shell.execute_reply":"2021-07-30T12:43:23.113383Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:47:07.233891Z","iopub.execute_input":"2021-07-30T12:47:07.23431Z","iopub.status.idle":"2021-07-30T12:47:07.25474Z","shell.execute_reply.started":"2021-07-30T12:47:07.234277Z","shell.execute_reply":"2021-07-30T12:47:07.253798Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:14:28.563966Z","iopub.execute_input":"2021-07-30T13:14:28.567351Z","iopub.status.idle":"2021-07-30T13:14:28.573782Z","shell.execute_reply.started":"2021-07-30T13:14:28.567299Z","shell.execute_reply":"2021-07-30T13:14:28.573023Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].isnull()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:56:13.028153Z","iopub.execute_input":"2021-07-30T12:56:13.028549Z","iopub.status.idle":"2021-07-30T12:56:13.038596Z","shell.execute_reply.started":"2021-07-30T12:56:13.028513Z","shell.execute_reply":"2021-07-30T12:56:13.037434Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:14:21.253319Z","iopub.execute_input":"2021-07-30T13:14:21.253858Z","iopub.status.idle":"2021-07-30T13:14:21.263861Z","shell.execute_reply.started":"2021-07-30T13:14:21.25381Z","shell.execute_reply":"2021-07-30T13:14:21.263161Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].fillna(\"미국 외 국가 선수\", inplace = True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T12:59:52.544189Z","iopub.execute_input":"2021-07-30T12:59:52.544556Z","iopub.status.idle":"2021-07-30T12:59:52.550493Z","shell.execute_reply.started":"2021-07-30T12:59:52.544524Z","shell.execute_reply":"2021-07-30T12:59:52.549276Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:00:06.698113Z","iopub.execute_input":"2021-07-30T13:00:06.698468Z","iopub.status.idle":"2021-07-30T13:00:06.706142Z","shell.execute_reply.started":"2021-07-30T13:00:06.698437Z","shell.execute_reply":"2021-07-30T13:00:06.70506Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:00:13.336238Z","iopub.execute_input":"2021-07-30T13:00:13.3367Z","iopub.status.idle":"2021-07-30T13:00:13.361667Z","shell.execute_reply.started":"2021-07-30T13:00:13.33666Z","shell.execute_reply":"2021-07-30T13:00:13.360715Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].value_counts()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:05:08.583306Z","iopub.execute_input":"2021-07-30T13:05:08.583665Z","iopub.status.idle":"2021-07-30T13:05:08.59576Z","shell.execute_reply.started":"2021-07-30T13:05:08.583631Z","shell.execute_reply":"2021-07-30T13:05:08.594609Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"most_freq = df_train_players['birthStateProvince'].value_counts(dropna=True).idxmax()\ndf_train_players['birthStateProvince'].fillna(most_freq, inplace = True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:06:30.121402Z","iopub.execute_input":"2021-07-30T13:06:30.122264Z","iopub.status.idle":"2021-07-30T13:06:30.131915Z","shell.execute_reply.started":"2021-07-30T13:06:30.122212Z","shell.execute_reply":"2021-07-30T13:06:30.13085Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"print(most_freq)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:07:02.293515Z","iopub.execute_input":"2021-07-30T13:07:02.294395Z","iopub.status.idle":"2021-07-30T13:07:02.300792Z","shell.execute_reply.started":"2021-07-30T13:07:02.294346Z","shell.execute_reply":"2021-07-30T13:07:02.29952Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(10)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:06:40.299528Z","iopub.execute_input":"2021-07-30T13:06:40.300362Z","iopub.status.idle":"2021-07-30T13:06:40.329352Z","shell.execute_reply.started":"2021-07-30T13:06:40.300313Z","shell.execute_reply":"2021-07-30T13:06:40.327658Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'].fillna(method = 'ffill', inplace = True)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:13:04.998423Z","iopub.execute_input":"2021-07-30T13:13:04.999011Z","iopub.status.idle":"2021-07-30T13:13:05.009052Z","shell.execute_reply.started":"2021-07-30T13:13:04.998968Z","shell.execute_reply":"2021-07-30T13:13:05.00722Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:13:33.186404Z","iopub.execute_input":"2021-07-30T13:13:33.186761Z","iopub.status.idle":"2021-07-30T13:13:33.218312Z","shell.execute_reply.started":"2021-07-30T13:13:33.18673Z","shell.execute_reply":"2021-07-30T13:13:33.217176Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'] = np.nan","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:26:14.044295Z","iopub.execute_input":"2021-07-30T13:26:14.044674Z","iopub.status.idle":"2021-07-30T13:26:14.052398Z","shell.execute_reply.started":"2021-07-30T13:26:14.044642Z","shell.execute_reply":"2021-07-30T13:26:14.050994Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head()","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:26:16.010909Z","iopub.execute_input":"2021-07-30T13:26:16.011282Z","iopub.status.idle":"2021-07-30T13:26:16.036265Z","shell.execute_reply.started":"2021-07-30T13:26:16.011249Z","shell.execute_reply":"2021-07-30T13:26:16.034302Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players['birthStateProvince'] = 0.0","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:32:51.568657Z","iopub.execute_input":"2021-07-30T13:32:51.56902Z","iopub.status.idle":"2021-07-30T13:32:51.573908Z","shell.execute_reply.started":"2021-07-30T13:32:51.568989Z","shell.execute_reply":"2021-07-30T13:32:51.572651Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(10)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:33:10.524607Z","iopub.execute_input":"2021-07-30T13:33:10.524999Z","iopub.status.idle":"2021-07-30T13:33:10.54786Z","shell.execute_reply.started":"2021-07-30T13:33:10.524966Z","shell.execute_reply":"2021-07-30T13:33:10.547004Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players = pd.read_csv('../input/mlb-player-digital-engagement-forecasting/players.csv')","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:33:36.270171Z","iopub.execute_input":"2021-07-30T13:33:36.270722Z","iopub.status.idle":"2021-07-30T13:33:36.300412Z","shell.execute_reply.started":"2021-07-30T13:33:36.270679Z","shell.execute_reply":"2021-07-30T13:33:36.299232Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(10)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:33:44.40418Z","iopub.execute_input":"2021-07-30T13:33:44.404727Z","iopub.status.idle":"2021-07-30T13:33:44.425426Z","shell.execute_reply.started":"2021-07-30T13:33:44.404692Z","shell.execute_reply":"2021-07-30T13:33:44.423952Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.fillna(method='ffill')","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:34:04.404921Z","iopub.execute_input":"2021-07-30T13:34:04.405468Z","iopub.status.idle":"2021-07-30T13:34:04.440868Z","shell.execute_reply.started":"2021-07-30T13:34:04.405432Z","shell.execute_reply":"2021-07-30T13:34:04.439994Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.head(20)","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:34:21.763431Z","iopub.execute_input":"2021-07-30T13:34:21.764187Z","iopub.status.idle":"2021-07-30T13:34:21.789916Z","shell.execute_reply.started":"2021-07-30T13:34:21.764145Z","shell.execute_reply":"2021-07-30T13:34:21.789173Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df_train_players.replace(to_replace = np.nan, value=\"테스트\")","metadata":{"execution":{"iopub.status.busy":"2021-07-30T13:59:35.558644Z","iopub.execute_input":"2021-07-30T13:59:35.559437Z","iopub.status.idle":"2021-07-30T13:59:35.603579Z","shell.execute_reply.started":"2021-07-30T13:59:35.55939Z","shell.execute_reply":"2021-07-30T13:59:35.602281Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}