{"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 pandas as pd","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2022-10-07T09:17:38.863721Z","iopub.execute_input":"2022-10-07T09:17:38.864127Z","iopub.status.idle":"2022-10-07T09:17:38.869716Z","shell.execute_reply.started":"2022-10-07T09:17:38.864095Z","shell.execute_reply":"2022-10-07T09:17:38.868572Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df1 = pd.read_csv(\"../input/tps-2022-10-fastai/model_fastai_v2.csv\") # 0.19443\ndf2 = pd.read_csv(\"../input/019674/model_fastai_v2.csv\") # 0.19674\ndf3 = pd.read_csv(\"../input/tabular-playground-catb-inference/submission.csv\") # 0.19778\ndf4 = pd.read_csv(\"../input/rocket-league-xgboost-feat-engineering-cv/submission.csv\") # 0.19895","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:17:39.115937Z","iopub.execute_input":"2022-10-07T09:17:39.116401Z","iopub.status.idle":"2022-10-07T09:17:41.038230Z","shell.execute_reply.started":"2022-10-07T09:17:39.116361Z","shell.execute_reply":"2022-10-07T09:17:41.037295Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"scores = [0.19443, 0.19674, 0.19778, 0.19895]","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:23:58.422328Z","iopub.execute_input":"2022-10-07T09:23:58.423369Z","iopub.status.idle":"2022-10-07T09:23:58.428018Z","shell.execute_reply.started":"2022-10-07T09:23:58.423327Z","shell.execute_reply":"2022-10-07T09:23:58.426954Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"(1 - scores[0]) / (len(scores) - sum(scores))","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:24:27.721479Z","iopub.execute_input":"2022-10-07T09:24:27.721889Z","iopub.status.idle":"2022-10-07T09:24:27.729782Z","shell.execute_reply.started":"2022-10-07T09:24:27.721857Z","shell.execute_reply":"2022-10-07T09:24:27.728437Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result_df = pd.DataFrame()\nresult_df[\"id\"] = df1.id\nresult_df[\"team_A_scoring_within_10sec\"] = df1.team_A_scoring_within_10sec * ((1 - scores[0]) / (len(scores) - sum(scores))) + df2.team_A_scoring_within_10sec * ((1 - scores[1]) / (len(scores) - sum(scores))) + df3.team_A_scoring_within_10sec * ((1 - scores[2]) / (len(scores) - sum(scores))) + df4.team_A_scoring_within_10sec * ((1 - scores[3]) / (len(scores) - sum(scores)))\nresult_df[\"team_B_scoring_within_10sec\"] = df1.team_B_scoring_within_10sec * ((1 - scores[0]) / (len(scores) - sum(scores))) + df2.team_B_scoring_within_10sec * ((1 - scores[1]) / (len(scores) - sum(scores))) + df3.team_B_scoring_within_10sec * ((1 - scores[2]) / (len(scores) - sum(scores))) + df4.team_B_scoring_within_10sec * ((1 - scores[3]) / (len(scores) - sum(scores)))","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:26:17.874086Z","iopub.execute_input":"2022-10-07T09:26:17.874529Z","iopub.status.idle":"2022-10-07T09:26:17.966908Z","shell.execute_reply.started":"2022-10-07T09:26:17.874496Z","shell.execute_reply":"2022-10-07T09:26:17.965847Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result_df.head()","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:26:18.971513Z","iopub.execute_input":"2022-10-07T09:26:18.972581Z","iopub.status.idle":"2022-10-07T09:26:18.984057Z","shell.execute_reply.started":"2022-10-07T09:26:18.972517Z","shell.execute_reply":"2022-10-07T09:26:18.982885Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"result_df.to_csv(\"submission.csv\", index=False)","metadata":{"execution":{"iopub.status.busy":"2022-10-07T09:17:41.550013Z","iopub.execute_input":"2022-10-07T09:17:41.550430Z","iopub.status.idle":"2022-10-07T09:17:44.201323Z","shell.execute_reply.started":"2022-10-07T09:17:41.550393Z","shell.execute_reply":"2022-10-07T09:17:44.200009Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}