{"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 numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\nimport os\n\nall_predictions = ['model-121-rgb-tpu-aug-kfold-0-smooth-255-224-v8-full.csv', \n                   'model-121-rgb-tpu-aug-kfold-0-smooth-255-224-v8.csv', \n                   'model-b0-rgb-tpu-aug-kfold-0-smooth-255-v8-224-full.csv', \n                   'model-b7-rgb-tpu-aug-kfold-0-smooth-255-v8-224.csv', \n                   'model-b0-rgb-tpu-aug-kfold-0-smooth-255-v8-224.csv', \n                   'model-b1-rgb-tpu-aug-kfold-0-smooth-255-v8-224.csv', \n                   'model-b7-rgb-tpu-aug-kfold-0-smooth-255-v8-224-full.csv', \n                   'model-121-rgb-tpu-aug-kfold-0-smooth-255-v8.csv']\ncur_pred = 7\nfolder = '../input/predictions/result'\n# file_path = f'{folder}/{all_predictions[cur_pred]}'\nfile_path = '../input/b7model/submission-run.csv'\nprint(file_path)\ndata = pd.read_csv(file_path)\nsample = pd.read_csv('../input/hpa-single-cell-image-classification/sample_submission.csv')\ndata = data[['ID', 'PredictionString']]\ndata = data.rename(columns={'PredictionString': 'pred'})\n\nsub = pd.merge(\n    sample,\n    data,\n    how=\"left\",\n    left_on='ID',\n    right_on='ID',\n)\n\nprint(sub.head())\n\ndef isNaN(num):\n    return num != num\n\nfor i, row in sub.iterrows():\n    if isNaN(row['pred']): continue\n    sub.PredictionString.loc[i] = row['pred']\n\nsub = sub[sample.columns]\nsub.to_csv('submission.csv', index=False)","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2021-06-01T05:38:05.85779Z","iopub.execute_input":"2021-06-01T05:38:05.858399Z","iopub.status.idle":"2021-06-01T05:38:08.840375Z","shell.execute_reply.started":"2021-06-01T05:38:05.858299Z","shell.execute_reply":"2021-06-01T05:38:08.839479Z"},"trusted":true},"execution_count":null,"outputs":[]}]}