{"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 os\nimport warnings\nimport pandas as pd\nimport numpy as np\nimport plotly.figure_factory as ff\nimport plotly.express as px\nwarnings.filterwarnings(\"ignore\") \n","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_kg_hide-input":true,"_kg_hide-output":true,"execution":{"iopub.status.busy":"2021-08-16T11:51:48.538245Z","iopub.execute_input":"2021-08-16T11:51:48.538671Z","iopub.status.idle":"2021-08-16T11:51:52.045079Z","shell.execute_reply.started":"2021-08-16T11:51:48.538586Z","shell.execute_reply":"2021-08-16T11:51:52.044044Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub1 = pd.read_csv('../input/g2net-eda-and-modeling/model_submission.csv').sort_values('id') \nsub2 = pd.read_csv('../input/k/yasufuminakama/g2net-efficientnet-b0-baseline-inference/submission.csv').sort_values('id') \nsub3 = pd.read_csv('../input/g2netsub/submission873.csv').sort_values('id') \nsub4 = pd.read_csv('../input/g2netsub/submission874.csv').sort_values('id') \nsub5 = pd.read_csv('../input/g2netsub/submission871.csv').sort_values('id') \nsub6 = pd.read_csv('../input/cqt-g2net-efficientnetb1-tpu-inference/submission.csv').sort_values('id') \nsub7 = pd.read_csv('../input/g2net-tf-on-the-fly-cqt-tpu-inference/submission.csv').sort_values('id') \nsub8 = pd.read_csv('../input/g2net-new-ensemble/submission.csv').sort_values('id') \n","metadata":{"_kg_hide-input":true,"execution":{"iopub.status.busy":"2021-08-16T11:51:52.046404Z","iopub.execute_input":"2021-08-16T11:51:52.046653Z","iopub.status.idle":"2021-08-16T11:51:56.498606Z","shell.execute_reply.started":"2021-08-16T11:51:52.046626Z","shell.execute_reply":"2021-08-16T11:51:56.49775Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"s1 = pd.read_csv('../input/1-g2net-smart-ensembling/submission2.csv').sort_values('id') \ns2 = pd.read_csv('../input/1-g2net-smart-ensembling/submission3.csv').sort_values('id') \ns3 = pd.read_csv('../input/1-g2net-smart-ensembling/submission4.csv').sort_values('id') \ns4 = pd.read_csv('../input/1-g2net-smart-ensembling/submission5.csv').sort_values('id') \ns5 = pd.read_csv('../input/g2netsub8779/submission.csv').sort_values('id') ","metadata":{"execution":{"iopub.status.busy":"2021-08-16T11:51:56.500525Z","iopub.execute_input":"2021-08-16T11:51:56.500944Z","iopub.status.idle":"2021-08-16T11:51:59.05234Z","shell.execute_reply.started":"2021-08-16T11:51:56.500898Z","shell.execute_reply":"2021-08-16T11:51:59.05116Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub = sub1.copy()\nsub.loc[:, 'target'] = (sub1.target * 0.1 + \n                        sub2.target * 0.05 + \n                        sub3.target * 0.05 + \n                        sub4.target * 0.1 + \n                        sub5.target * 0.05 + \n                        sub6.target * 0.15+sub7.target * 0.05+ sub8.target * 0.45)*0.99\n#sub.to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2021-08-16T11:51:59.053866Z","iopub.execute_input":"2021-08-16T11:51:59.05428Z","iopub.status.idle":"2021-08-16T11:51:59.147073Z","shell.execute_reply.started":"2021-08-16T11:51:59.054238Z","shell.execute_reply":"2021-08-16T11:51:59.146124Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"s = s1.copy()\ns.loc[:, 'target'] = (s1.target * 0.0 + \n                        s2.target * 0.0 + \n                        s3.target * 0.03 + \n                        s4.target * 0.07 + \n                        s5.target * 0.9)\nsub.loc[:, 'target'] = (s.target*0.45+sub.target*0.55)\nsub.to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2021-08-16T11:51:59.150535Z","iopub.execute_input":"2021-08-16T11:51:59.150841Z","iopub.status.idle":"2021-08-16T11:52:00.05897Z","shell.execute_reply.started":"2021-08-16T11:51:59.150812Z","shell.execute_reply":"2021-08-16T11:52:00.057523Z"},"trusted":true},"execution_count":null,"outputs":[]}]}