{"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\nimport numpy as np\nimport os\nos.listdir('../input/')","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:28:28.207936Z","iopub.execute_input":"2022-11-25T12:28:28.208418Z","iopub.status.idle":"2022-11-25T12:28:28.23871Z","shell.execute_reply.started":"2022-11-25T12:28:28.208312Z","shell.execute_reply":"2022-11-25T12:28:28.237745Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"path = '../input/gravity/'\ndata1 = pd.read_csv(path + 'submission(6).csv')\ndata2 = pd.read_csv(path + 'submission(5).csv')\n","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:28:33.966896Z","iopub.execute_input":"2022-11-25T12:28:33.967283Z","iopub.status.idle":"2022-11-25T12:28:34.008405Z","shell.execute_reply.started":"2022-11-25T12:28:33.967251Z","shell.execute_reply":"2022-11-25T12:28:34.007187Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data1.head()","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:28:37.363276Z","iopub.execute_input":"2022-11-25T12:28:37.36367Z","iopub.status.idle":"2022-11-25T12:28:37.388688Z","shell.execute_reply.started":"2022-11-25T12:28:37.363629Z","shell.execute_reply":"2022-11-25T12:28:37.387479Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"data2.head()","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:28:41.6939Z","iopub.execute_input":"2022-11-25T12:28:41.694571Z","iopub.status.idle":"2022-11-25T12:28:41.705444Z","shell.execute_reply.started":"2022-11-25T12:28:41.694532Z","shell.execute_reply":"2022-11-25T12:28:41.704363Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission = data1.copy()","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:28:48.301791Z","iopub.execute_input":"2022-11-25T12:28:48.302176Z","iopub.status.idle":"2022-11-25T12:28:48.307694Z","shell.execute_reply.started":"2022-11-25T12:28:48.302144Z","shell.execute_reply":"2022-11-25T12:28:48.30645Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission['target'] = 1/4*data1['target'] + 3/4*data2['target']","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:29:17.377866Z","iopub.execute_input":"2022-11-25T12:29:17.379035Z","iopub.status.idle":"2022-11-25T12:29:17.388803Z","shell.execute_reply.started":"2022-11-25T12:29:17.378948Z","shell.execute_reply":"2022-11-25T12:29:17.387966Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission.head()","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:29:20.550493Z","iopub.execute_input":"2022-11-25T12:29:20.551186Z","iopub.status.idle":"2022-11-25T12:29:20.560785Z","shell.execute_reply.started":"2022-11-25T12:29:20.551145Z","shell.execute_reply":"2022-11-25T12:29:20.559962Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission.to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2022-11-25T12:29:26.989966Z","iopub.execute_input":"2022-11-25T12:29:26.990361Z","iopub.status.idle":"2022-11-25T12:29:27.013793Z","shell.execute_reply.started":"2022-11-25T12:29:26.990328Z","shell.execute_reply":"2022-11-25T12:29:27.012397Z"},"trusted":true},"execution_count":null,"outputs":[]}]}