{"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","trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub0 = pd.read_csv('../input/lb4522/submission.csv')\nsub1 = pd.read_csv('../input/lb4555/submission.csv')\nsub2 = pd.read_csv('../input/lb4722/submission.csv')","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"print(sub0.head())","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub0 = sub0.set_index('site_path_timestamp')\nsub1 = sub1.set_index('site_path_timestamp')\nsub2 = sub2.set_index('site_path_timestamp')","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub0['x'] = 0.4*sub0['x'].values + 0.4*sub1.loc[sub0.index, 'x'].values + 0.2*sub2.loc[sub0.index, 'x'].values\nsub0['y'] = 0.4*sub0['y'].values + 0.4*sub1.loc[sub0.index,'y'].values + 0.2*sub2.loc[sub0.index,'y'].values","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub0 = sub0.reset_index(drop=False)\nsub0.to_csv('submission.csv', index=False)","metadata":{"trusted":true},"execution_count":null,"outputs":[]}]}