{"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":"markdown","source":"Just an example from this discussion https://www.kaggle.com/c/bms-molecular-translation/discussion/238551.\n\nI used the top 5 public notebooks for this example.\n","metadata":{}},{"cell_type":"code","source":"\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"subs = ['../input/inchi-efficientnetb7-25-epochs-inference/submission.csv',\n        '../input/efficientnet-multi-layer-lstm-inference/submission.csv',\n        '../input/batched-beam-search-inference-changed-parameters/submission.csv',\n        '../input/batched-beam-search-inference/submission.csv',\n        '../input/subbeem/submission.789.csv']","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"for ii in range(len(subs)):\n    vars()['sub'+str(ii)] = pd.read_csv(subs[ii])\n    vars()['sub'+str(ii)] = vars()['sub'+str(ii)].sort_values(by='image_id', ascending=True)\n    vars()['sub'+str(ii)].reset_index(inplace=True)\n    vars()['sub'+str(ii)] = vars()['sub'+str(ii)].drop('index',axis=1)","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sums = []\nsubfinal = sub0.copy()\nfor ii in range(len(subs)):\n    subfinal[f'InChI{ii}'] = vars()['sub'+str(ii)]['InChI']\n    subfinal[f'InChI{ii}sum'] = 0\n    sums.append(f'InChI{ii}')","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"for ii in range(len(subs)):\n    sums2 = sums.copy()\n    sums2.remove(f'InChI{ii}')\n    for obj in sums2:\n        subfinal[f'InChI{ii}sum'][subfinal[f'InChI{ii}'] == subfinal[obj]] += 1","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"subfinal['InChI'][subfinal['InChI1sum'] > subfinal['InChI0sum']] = subfinal['InChI1']","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"\nsubfinal[['image_id', 'InChI']].to_csv('submission.csv', index=False)","metadata":{"trusted":true},"execution_count":null,"outputs":[]}]}