{"cells":[{"metadata":{},"cell_type":"markdown","source":"# Blending some of the top Kernels"},{"metadata":{},"cell_type":"markdown","source":"More Blending inspired from Giba's Kernel: [https://www.kaggle.com/titericz/blend-or-not-to-blend-that-is-the-question].\n\n\nI grabbed output submissions files from following public kernels:\n\n- https://www.kaggle.com/titericz/giba-r-data-table-simple-features-1-17-lb\n- https://www.kaggle.com/todnewman/keras-neural-net-for-champs\n- https://www.kaggle.com/scaomath/no-memory-reduction-workflow-for-each-type-lb-1-28\n- https://www.kaggle.com/vicensgaitan/giba-r-data-table-simplefeat-cyv-interaction"},{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"cell_type":"code","source":"#loading packages\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport os\nprint(os.listdir(\"../input\"))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"#reading all submission files\nsub1 = pd.read_csv('../input/giba-r-data-table-simple-features-1-17-lb/submission-giba-1.csv')\nsub2 = pd.read_csv('../input/keras-neural-net-for-champs/workingsubmission-test.csv')\nsub3 = pd.read_csv('../input/no-memory-reduction-workflow-for-each-type-lb-1-28/LGB_2019-07-11_-1.4378.csv')\nsub4 = pd.read_csv('../input/giba-r-data-table-simplefeat-cyv-interaction/submission-2.csv')\nprint( sub1['scalar_coupling_constant'].describe() )\nprint( sub2['scalar_coupling_constant'].describe() )\nprint( sub3['scalar_coupling_constant'].describe() )\nprint( sub4['scalar_coupling_constant'].describe() )","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"# Random weights to each submission by trying and experimenting\nsub1['scalar_coupling_constant'] = 0.25*sub1['scalar_coupling_constant'] + 0.2*sub2['scalar_coupling_constant'] + 0.3*sub3['scalar_coupling_constant'] + 0.25*sub4['scalar_coupling_constant']\nsub1.to_csv('submission.csv', index=False )","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"#plotting histogram\nsub1['scalar_coupling_constant'].plot('hist', bins=100)","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.4","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}