{"cells":[{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"cell_type":"code","source":"import numpy as np\nimport sys\nimport pandas as pd\nfrom skimage.io import imread, imsave\nfrom skimage.color import gray2rgb\nfrom skimage.color import rgb2gray\nimport matplotlib.pyplot as plt\nfrom functools import reduce\nimport os","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","trusted":true},"cell_type":"code","source":"# Upload submission\nsub = pd.read_csv(\"../input/ashrae-energy-prediction/sample_submission.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"#Dataset loaded for blending \n#https://www.kaggle.com/yamsam/ashrae-highway-kernel-route2\n#https://www.kaggle.com/purist1024/ashrae-simple-data-cleanup-lb-1-08-no-leaks\n#https://www.kaggle.com/wentixiaogege/ashrae-maybe-this-can-make-public-lb-some-useful\n#https://www.kaggle.com/huanglinyan/ashrae-may-make-it-up-to-1-0\n#https://www.kaggle.com/khoongweihao/ashrae-leak-validation-bruteforce-heuristic-search/output\n#https://www.kaggle.com/yamsam/ashrae-leak-validation-and-more","execution_count":null,"outputs":[]},{"metadata":{"_cell_guid":"","_uuid":"","trusted":true},"cell_type":"code","source":"df0 = pd.read_csv(\"../input/ashrae-public/ashrae-highway-kernel-route2.csv\") #1.03\ndf1 = pd.read_csv(\"../input/ashrae-public/ashrae-leak-validation-and-more.csv\") #0.99\ndf2 = pd.read_csv(\"../input/ashrae-public/ashrae-leak-validation-bruteforce-heuristic-search.csv\") #0.98\ndf3 = pd.read_csv(\"../input/ashrae-public/ashrae-may-make-it-up-to-1-0.csv\") #1\ndf4 = pd.read_csv(\"../input/ashrae-public/ashrae-maybe-this-can-make-public-lb-some-useful.csv\") #1.1\ndf5 = pd.read_csv(\"../input/ashrae-public/ashrae-simple-data-cleanup-lb-1-08-no-leaks.csv\") #1.08\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"blend1 = df0['meter_reading']*0.5 + df4['meter_reading']*0.3 + df5['meter_reading']*0.2","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"sub['meter_reading'] = blend1\ndf11 = sub","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"blend2 = df11['meter_reading']*0.1 + df1['meter_reading']*0.15 + df2['meter_reading']*0.6 + df3['meter_reading']*0.15","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"sub1 = pd.read_csv(\"../input/ashrae-energy-prediction/sample_submission.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"sub1['meter_reading'] = blend2\nsub1.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"sub1.to_csv(f'submission.csv', index=False, float_format='%g')","execution_count":null,"outputs":[]}],"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":4,"nbformat_minor":1}