{"cells":[{"metadata":{"trusted":true},"cell_type":"code","source":"import pandas as pd\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"for i in range(10):\n    globals()[f'df{i}'] = pd.read_csv(f'../input/vin-15-cnn-predict/submission{i}.csv')\nfor i in range(10,15):\n\n    globals()[f'df{i}'] = pd.read_csv(f'../input/vin-15-cnn-predict-1/submission{i - 10}.csv')\n    \n    \nlist1 = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10','11', '12', '13', '14']\n\n\ndf0[list1] = df0[list1] * 0.05 + df1[list1] * 0.05 + df2[list1] * 0.05 + df3[list1] * 0.05 + df4[list1] * 0.05 + df5[list1] * 0.1 + df6[list1] * 0.1 + df7[list1] * 0.1 + df8[list1] * 0.1 + df9[list1] * 0.1 + df10[list1] * 0.05 + df11[list1] * 0.05 + df12[list1] * 0.05 + df13[list1] * 0.05 + df14[list1] * 0.05\ndf = df0.copy()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"df","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"\ndf3 = pd.read_csv('../input/0-286-private-norm/df_rcnn286.csv')","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"df4 = pd.merge(df, df3, on = 'image_id', how = 'left')","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"list1 = [0,1,2,3,4,5, 6, 7, 8, 9, 10, 11, 12, 13, 14]\n\n\nfor i in range(df4.shape[0]):\n    if df4.loc[i,'PredictionString'] == '14 1 0 0 1 1':\n        continue\n    a = df4.loc[i,'PredictionString']\n    b = a.split()\n    for j in range(int(len(a.split())/6)):\n        for k in list1:\n            if int(b[0 + 6 * j]) == k:\n\n                c = b[0 + 6 * j + 1]               \n                b[0 + 6 * j + 1] = str(df4.loc[i,f'{k}'] * 0.05 + float(c) * 0.95)# * 0.9 + float(c) * 0.1\n\n                \n\n        \n    df4.loc[i,'PredictionString'] = ' '.join(b)\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"\ndf_final = df4[['image_id', 'PredictionString']]\ndf_final.to_csv('submission.csv',index = False)\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"df_final\n","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"","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":4}