{"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":"#import library\nimport pandas as pd\nimport numpy as np\nimport seaborn as sns\nimport warnings\nwarnings.filterwarnings('ignore')","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:35.386378Z","iopub.execute_input":"2022-05-23T01:07:35.386722Z","iopub.status.idle":"2022-05-23T01:07:36.549192Z","shell.execute_reply.started":"2022-05-23T01:07:35.386629Z","shell.execute_reply":"2022-05-23T01:07:36.548325Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train = pd.read_csv(\"../input/football-match-probability-prediction/train.csv\")\ntest = pd.read_csv(\"../input/football-match-probability-prediction/test.csv\")","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:36.55082Z","iopub.execute_input":"2022-05-23T01:07:36.551137Z","iopub.status.idle":"2022-05-23T01:07:46.484811Z","shell.execute_reply.started":"2022-05-23T01:07:36.551096Z","shell.execute_reply":"2022-05-23T01:07:46.484049Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"test.head()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:46.48584Z","iopub.execute_input":"2022-05-23T01:07:46.486046Z","iopub.status.idle":"2022-05-23T01:07:46.527469Z","shell.execute_reply.started":"2022-05-23T01:07:46.48602Z","shell.execute_reply":"2022-05-23T01:07:46.526614Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"def features_filtred(data,column_name):\n    features_filtred = [_ for _ in data.columns if str(column_name) in _]\n    return features_filtred","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:46.52925Z","iopub.execute_input":"2022-05-23T01:07:46.529459Z","iopub.status.idle":"2022-05-23T01:07:46.533919Z","shell.execute_reply.started":"2022-05-23T01:07:46.529432Z","shell.execute_reply":"2022-05-23T01:07:46.533076Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"all_id_features = features_filtred(train,\"_id\")\ntrain = train.drop(all_id_features, 1)\n\nall_name_features1 = features_filtred(train,\"_name\")\ntrain = train.drop(all_name_features1, 1)\n\nall_date_features2 = features_filtred(train,\"date\")\ntrain = train.drop(all_date_features2, 1)\n\n# test-dataset\nall_id_features3 = features_filtred(test,\"_id\")\ntest = test.drop(all_id_features3, 1)\n\nall_name_features4 = features_filtred(test,\"_name\")\ntest = test.drop(all_name_features4, 1)\n\nall_date_features5 = features_filtred(test,\"date\")\ntest = test.drop(all_date_features5, 1)\n\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:46.535248Z","iopub.execute_input":"2022-05-23T01:07:46.535702Z","iopub.status.idle":"2022-05-23T01:07:46.909536Z","shell.execute_reply.started":"2022-05-23T01:07:46.535655Z","shell.execute_reply":"2022-05-23T01:07:46.908797Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train.isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:46.910786Z","iopub.execute_input":"2022-05-23T01:07:46.911109Z","iopub.status.idle":"2022-05-23T01:07:46.97544Z","shell.execute_reply.started":"2022-05-23T01:07:46.911068Z","shell.execute_reply":"2022-05-23T01:07:46.97467Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"test.isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:46.976508Z","iopub.execute_input":"2022-05-23T01:07:46.976794Z","iopub.status.idle":"2022-05-23T01:07:47.00701Z","shell.execute_reply.started":"2022-05-23T01:07:46.976763Z","shell.execute_reply":"2022-05-23T01:07:47.006284Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train[\"is_cup\"].fillna(True, inplace=True)\ntrain.fillna(train.mean(), inplace=True)\ntest.fillna(test.mean(), inplace=True)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:47.008009Z","iopub.execute_input":"2022-05-23T01:07:47.008301Z","iopub.status.idle":"2022-05-23T01:07:48.370387Z","shell.execute_reply.started":"2022-05-23T01:07:47.008271Z","shell.execute_reply":"2022-05-23T01:07:48.369627Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train.isnull().sum()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.371548Z","iopub.execute_input":"2022-05-23T01:07:48.371832Z","iopub.status.idle":"2022-05-23T01:07:48.425086Z","shell.execute_reply.started":"2022-05-23T01:07:48.371793Z","shell.execute_reply":"2022-05-23T01:07:48.424384Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"from sklearn.preprocessing import LabelEncoder\nlabelencoder = LabelEncoder()\n\ntest['is_cup']  = labelencoder.fit_transform(test['is_cup'])\ntrain['is_cup'] = labelencoder.fit_transform(train['is_cup'])\ntrain['target'] = labelencoder.fit_transform(train['target'])","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.42754Z","iopub.execute_input":"2022-05-23T01:07:48.427749Z","iopub.status.idle":"2022-05-23T01:07:48.620671Z","shell.execute_reply.started":"2022-05-23T01:07:48.427723Z","shell.execute_reply":"2022-05-23T01:07:48.619938Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train['is_cup'].unique()\ntest['is_cup'].unique()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.622002Z","iopub.execute_input":"2022-05-23T01:07:48.622479Z","iopub.status.idle":"2022-05-23T01:07:48.630876Z","shell.execute_reply.started":"2022-05-23T01:07:48.622434Z","shell.execute_reply":"2022-05-23T01:07:48.630026Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train['target'].unique()","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.63225Z","iopub.execute_input":"2022-05-23T01:07:48.632662Z","iopub.status.idle":"2022-05-23T01:07:48.642305Z","shell.execute_reply.started":"2022-05-23T01:07:48.632618Z","shell.execute_reply":"2022-05-23T01:07:48.641464Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"ID = train['id']\nY = train['target']\nX = train.iloc[:, 2:]","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.643692Z","iopub.execute_input":"2022-05-23T01:07:48.644003Z","iopub.status.idle":"2022-05-23T01:07:48.688716Z","shell.execute_reply.started":"2022-05-23T01:07:48.643963Z","shell.execute_reply":"2022-05-23T01:07:48.687791Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"X","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.690087Z","iopub.execute_input":"2022-05-23T01:07:48.690345Z","iopub.status.idle":"2022-05-23T01:07:48.753227Z","shell.execute_reply.started":"2022-05-23T01:07:48.690315Z","shell.execute_reply":"2022-05-23T01:07:48.752352Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"from sklearn.feature_selection import SelectKBest\nfrom sklearn.feature_selection import chi2\nSKB = SelectKBest(score_func=chi2, k=4)\nfit = SKB.fit(X, Y)\nnp.set_printoptions(precision=3)\nprint(fit.scores_)\nfeatures = fit.transform(X)\nprint(features[0:5,:])\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:48.754221Z","iopub.execute_input":"2022-05-23T01:07:48.75442Z","iopub.status.idle":"2022-05-23T01:07:49.203498Z","shell.execute_reply.started":"2022-05-23T01:07:48.754395Z","shell.execute_reply":"2022-05-23T01:07:49.202914Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"all_history_coach_features = features_filtred(X,\"history_coach_\")\nX = X.drop(all_history_coach_features, 1)\n\nall_history_rating_features = features_filtred(X,\"rating_\")\nX = X.drop(all_history_rating_features, 1)\n\nall_history_coach_features_test = features_filtred(test,\"history_coach_\")\ntest = test.drop(all_history_coach_features_test, 1)\n\nall_history_rating_features_test = features_filtred(test,\"rating_\")\ntest = test.drop(all_history_rating_features_test, 1)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.20451Z","iopub.execute_input":"2022-05-23T01:07:49.20484Z","iopub.status.idle":"2022-05-23T01:07:49.316937Z","shell.execute_reply.started":"2022-05-23T01:07:49.204812Z","shell.execute_reply":"2022-05-23T01:07:49.316088Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#create sub-tables for features of Home team\nhome_team_history_is_play_home = features_filtred(train,\"home_team_history_is_play_home\")\nX_HTPH = X[home_team_history_is_play_home]\n\nhome_team_history_is_cup = features_filtred(train,\"home_team_history_is_cup_\")\nX_HTC = X[home_team_history_is_cup]\n\nhome_team_history_goal = features_filtred(train,\"home_team_history_goal_\")\nX_HTG = X[home_team_history_goal]\n\nhome_team_history_opponent_goal = features_filtred(train,\"home_team_history_opponent_goal\")\nX_HTOG = X[home_team_history_opponent_goal]\n\n\n#create sub-tables for features of Away team\n\naway_team_history_is_play_home = features_filtred(train,\"away_team_history_is_play_home\")\nX_ATPH = X[away_team_history_is_play_home]\n\naway_team_history_is_cup = features_filtred(train,\"away_team_history_is_cup_\")\nX_ATC = X[away_team_history_is_cup]\n\naway_team_history_goal = features_filtred(train,\"away_team_history_goal_\")\nX_ATG = X[away_team_history_goal]\n\naway_team_history_opponent_goal = features_filtred(train,\"away_team_history_opponent_goal\")\nX_ATOG = X[away_team_history_opponent_goal]\n\n\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.318251Z","iopub.execute_input":"2022-05-23T01:07:49.318733Z","iopub.status.idle":"2022-05-23T01:07:49.347832Z","shell.execute_reply.started":"2022-05-23T01:07:49.318687Z","shell.execute_reply":"2022-05-23T01:07:49.347213Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#create sub-tables for features of Home team\nhome_team_history_is_play_home = features_filtred(test,\"home_team_history_is_play_home\")\nX_HTPH_test = test[home_team_history_is_play_home]\n\nhome_team_history_is_cup = features_filtred(test,\"home_team_history_is_cup_\")\nX_HTC_test = test[home_team_history_is_cup]\n\nhome_team_history_goal = features_filtred(test,\"home_team_history_goal_\")\nX_HTG_test = test[home_team_history_goal]\n\nhome_team_history_opponent_goal = features_filtred(test,\"home_team_history_opponent_goal\")\nX_HTOG_test = test[home_team_history_opponent_goal]\n\n\n#create sub-tables for features of Away team\n\naway_team_history_is_play_home = features_filtred(test,\"away_team_history_is_play_home\")\nX_ATPH_test = test[away_team_history_is_play_home]\n\naway_team_history_is_cup = features_filtred(test,\"away_team_history_is_cup_\")\nX_ATC_test = test[away_team_history_is_cup]\n\naway_team_history_goal = features_filtred(test,\"away_team_history_goal_\")\nX_ATG_test = test[away_team_history_goal]\n\naway_team_history_opponent_goal = features_filtred(test,\"away_team_history_opponent_goal\")\nX_ATOG_test = test[away_team_history_opponent_goal]\n\n\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.348869Z","iopub.execute_input":"2022-05-23T01:07:49.349224Z","iopub.status.idle":"2022-05-23T01:07:49.374886Z","shell.execute_reply.started":"2022-05-23T01:07:49.349196Z","shell.execute_reply":"2022-05-23T01:07:49.374259Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"X_HTPH_test","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.375896Z","iopub.execute_input":"2022-05-23T01:07:49.376209Z","iopub.status.idle":"2022-05-23T01:07:49.404985Z","shell.execute_reply.started":"2022-05-23T01:07:49.376182Z","shell.execute_reply":"2022-05-23T01:07:49.404243Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"from sklearn.decomposition import PCA","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.406027Z","iopub.execute_input":"2022-05-23T01:07:49.406233Z","iopub.status.idle":"2022-05-23T01:07:49.412996Z","shell.execute_reply.started":"2022-05-23T01:07:49.406207Z","shell.execute_reply":"2022-05-23T01:07:49.412137Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pca = PCA(n_components=1)\n\n#PCA for Home_Team_Features\nX_HTPH_C = pca.fit_transform(X_HTPH)\nX_HTC_C = pca.fit_transform(X_HTC)\nX_HTG_C = pca.fit_transform(X_HTG)\nX_HTOG_C = pca.fit_transform(X_HTOG)\n\n#PCA for Home_Team_Features\nX_ATPH_C = pca.fit_transform(X_ATPH)\nX_ATC_C = pca.fit_transform(X_ATC)\nX_ATG_C = pca.fit_transform(X_ATG)\nX_ATOG_C = pca.fit_transform(X_ATOG)\n\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:49.414711Z","iopub.execute_input":"2022-05-23T01:07:49.415294Z","iopub.status.idle":"2022-05-23T01:07:51.805038Z","shell.execute_reply.started":"2022-05-23T01:07:49.41523Z","shell.execute_reply":"2022-05-23T01:07:51.804071Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pca_test = PCA(n_components=1)\n\n#PCA for Home_Team_Features\nX_HTPH_C_test = pca_test.fit_transform(X_HTPH_test)\nX_HTC_C_test = pca_test.fit_transform(X_HTC_test)\nX_HTG_C_test = pca_test.fit_transform(X_HTG_test)\nX_HTOG_C_test = pca_test.fit_transform(X_HTOG_test)\n\n#PCA for Home_Team_Features\nX_ATPH_C_test = pca_test.fit_transform(X_ATPH_test)\nX_ATC_C_test = pca_test.fit_transform(X_ATC_test)\nX_ATG_C_test = pca_test.fit_transform(X_ATG_test)\nX_ATOG_C_test = pca_test.fit_transform(X_ATOG_test)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:51.80633Z","iopub.execute_input":"2022-05-23T01:07:51.806777Z","iopub.status.idle":"2022-05-23T01:07:53.437422Z","shell.execute_reply.started":"2022-05-23T01:07:51.806735Z","shell.execute_reply":"2022-05-23T01:07:53.436541Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# create a new feature that replaces the 10 old features through PCA\nX[\"home_team_is_play_home\"] = X_HTPH_C\nhome_team_history_is_play_home = features_filtred(train,\"home_team_history_is_play_home_\")\nX = X.drop(home_team_history_is_play_home,1)\n\nX[\"home_team_is_cup\"] = X_HTC_C\nhome_team_history_is_cup = features_filtred(train,\"home_team_history_is_cup_\")\nX = X.drop(home_team_history_is_cup,1)\n\nX[\"home_team_goal\"] = X_HTG_C\nhome_team_history_goal = features_filtred(train,\"home_team_history_goal_\")\nX = X.drop(home_team_history_goal,1)\n\nX[\"home_team_opponent_goal\"] = X_HTOG_C\nhome_team_history_opponent_goal = features_filtred(train,\"home_team_history_opponent_goal\")\nX = X.drop(home_team_history_opponent_goal,1)\n\n\n\nX[\"away_team_is_play_home\"] = X_ATPH_C\naway_team_history_is_play_home = features_filtred(train,\"away_team_history_is_play_home_\")\nX = X.drop(away_team_history_is_play_home,1)\n\nX[\"away_team_is_cup\"] = X_ATC_C\naway_team_history_is_cup = features_filtred(train,\"away_team_history_is_cup_\")\nX = X.drop(away_team_history_is_cup,1)\n\nX[\"away_team_goal\"] = X_ATG_C\naway_team_history_goal = features_filtred(train,\"away_team_history_goal_\")\nX = X.drop(away_team_history_goal,1)\n\nX[\"away_team_opponent_goal\"] = X_ATOG_C\naway_team_history_opponent_goal = features_filtred(train,\"away_team_history_opponent_goal\")\nX = X.drop(away_team_history_opponent_goal,1)\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:53.44307Z","iopub.execute_input":"2022-05-23T01:07:53.445622Z","iopub.status.idle":"2022-05-23T01:07:53.851747Z","shell.execute_reply.started":"2022-05-23T01:07:53.445566Z","shell.execute_reply":"2022-05-23T01:07:53.850876Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# create a new feature that replaces the 10 old features through PCA\ntest[\"home_team_is_play_home\"] = X_HTPH_C_test\nhome_team_history_is_play_home = features_filtred(test,\"home_team_history_is_play_home_\")\ntest = test.drop(home_team_history_is_play_home,1)\n\ntest[\"home_team_is_cup\"] = X_HTC_C_test\nhome_team_history_is_cup = features_filtred(test,\"home_team_history_is_cup_\")\ntest = test.drop(home_team_history_is_cup,1)\n\ntest[\"home_team_goal\"] = X_HTG_C_test\nhome_team_history_goal = features_filtred(test,\"home_team_history_goal_\")\ntest = test.drop(home_team_history_goal,1)\n\ntest[\"home_team_opponent_goal\"] = X_HTOG_C_test\nhome_team_history_opponent_goal = features_filtred(test,\"home_team_history_opponent_goal\")\ntest = test.drop(home_team_history_opponent_goal,1)\n\n\n\ntest[\"away_team_is_play_home\"] = X_ATPH_C_test\naway_team_history_is_play_home = features_filtred(test,\"away_team_history_is_play_home_\")\ntest = test.drop(away_team_history_is_play_home,1)\n\ntest[\"away_team_is_cup\"] = X_ATC_C_test\naway_team_history_is_cup = features_filtred(test,\"away_team_history_is_cup_\")\ntest = test.drop(away_team_history_is_cup,1)\n\ntest[\"away_team_goal\"] = X_ATG_C_test\naway_team_history_goal = features_filtred(test,\"away_team_history_goal_\")\ntest = test.drop(away_team_history_goal,1)\n\ntest[\"away_team_opponent_goal\"] = X_ATOG_C_test\naway_team_history_opponent_goal = features_filtred(test,\"away_team_history_opponent_goal\")\ntest = test.drop(away_team_history_opponent_goal,1)\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:53.85305Z","iopub.execute_input":"2022-05-23T01:07:53.853338Z","iopub.status.idle":"2022-05-23T01:07:54.083539Z","shell.execute_reply.started":"2022-05-23T01:07:53.853297Z","shell.execute_reply":"2022-05-23T01:07:54.082921Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"X","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:54.084929Z","iopub.execute_input":"2022-05-23T01:07:54.085414Z","iopub.status.idle":"2022-05-23T01:07:54.106807Z","shell.execute_reply.started":"2022-05-23T01:07:54.085369Z","shell.execute_reply":"2022-05-23T01:07:54.106219Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"ID_test = test['id']\nID_train = ID\nx_train = X\ny_train = Y\nx_test = test.iloc[:,1:]\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:54.108284Z","iopub.execute_input":"2022-05-23T01:07:54.108754Z","iopub.status.idle":"2022-05-23T01:07:54.117975Z","shell.execute_reply.started":"2022-05-23T01:07:54.10871Z","shell.execute_reply":"2022-05-23T01:07:54.117162Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# from sklearn.feature_selection import RFE\n# from sklearn.linear_model import LogisticRegression\n\n# model = LogisticRegression()\n# rfe = RFE(model, 3)\n\n# fit = rfe.fit(X, Y)\n# print(\"Num Features: %d\" % fit.n_features_)\n# print(\"Selected Features: %s\" % fit.support_)\n# print(\"Feature Ranking: %s\" % fit.ranking_)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:54.12012Z","iopub.execute_input":"2022-05-23T01:07:54.120352Z","iopub.status.idle":"2022-05-23T01:07:54.128455Z","shell.execute_reply.started":"2022-05-23T01:07:54.120324Z","shell.execute_reply":"2022-05-23T01:07:54.127874Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"from sklearn.linear_model import LogisticRegression\n\n#USING LOGISTICREGRESSION FOR PREDICTION\nlg = LogisticRegression()\nlg.fit(x_train, y_train)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:54.132444Z","iopub.execute_input":"2022-05-23T01:07:54.133112Z","iopub.status.idle":"2022-05-23T01:07:56.020138Z","shell.execute_reply.started":"2022-05-23T01:07:54.133074Z","shell.execute_reply":"2022-05-23T01:07:56.019302Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"y_prop_pred = lg.predict_proba(x_test)\ny_prop_pred\n","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:07:56.021382Z","iopub.execute_input":"2022-05-23T01:07:56.021838Z","iopub.status.idle":"2022-05-23T01:07:56.056945Z","shell.execute_reply.started":"2022-05-23T01:07:56.021797Z","shell.execute_reply":"2022-05-23T01:07:56.056116Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission_test = pd.DataFrame(y_prop_pred,columns=['away', 'draw', 'home'])\nsubmission = pd.DataFrame()\nsubmission['id'] = test[['id']]\nsubmission['away'] = submission_test['away']\nsubmission['draw'] = submission_test['draw']\nsubmission['home'] = submission_test['home']\n\n\n# submission[['id', 'home', 'away', 'draw']].to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:08:07.883751Z","iopub.execute_input":"2022-05-23T01:08:07.884027Z","iopub.status.idle":"2022-05-23T01:08:07.903546Z","shell.execute_reply.started":"2022-05-23T01:08:07.883998Z","shell.execute_reply":"2022-05-23T01:08:07.902932Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission","metadata":{"execution":{"iopub.status.busy":"2022-05-23T01:08:11.140148Z","iopub.execute_input":"2022-05-23T01:08:11.140404Z","iopub.status.idle":"2022-05-23T01:08:11.153616Z","shell.execute_reply.started":"2022-05-23T01:08:11.140376Z","shell.execute_reply":"2022-05-23T01:08:11.152758Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"","metadata":{}},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}