{"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\nimport pandas as pd \nimport os\n\nids1 = []\npreds1 = []\nids2 = []\npreds2 = []\nfor dirname, _, filenames in os.walk(f'../input/siim-covid19-detection/test'):\n    for file in filenames:\n        study_id = dirname.split('/')[-2] + '_study'\n        if study_id not in ids1:\n            ids1.append(study_id)\n            preds1.append('negative 1 0 0 1 1 typical 1 0 0 1 1 indeterminate 1 0 0 1 1 atypical 1 0 0 1 1')\n            \n        image_id = file.replace('.dcm', '_image')\n        ids2.append(image_id)\n        preds2.append('OMG 1 0 0 1 1 Bug 1 0 0 1 1 ? 1 0 0 1 1')\nout_csv = pd.DataFrame({\n    'id': ids1,\n    'PredictionString': preds1,\n})\nout_csv.to_csv('./submission_study.csv', index=False)\n\nout_csv = pd.DataFrame({\n    'id': ids2,\n    'PredictionString': preds2,\n})\nout_csv.to_csv('./submission_image.csv', index=False)\n\nimg_csv = pd.read_csv('./submission_image.csv')\nstudy_csv = pd.read_csv('./submission_study.csv')\nfinal_csv = pd.concat([study_csv, img_csv])\nfinal_csv.to_csv('./submission.csv', index=False)\nprint(final_csv)\n","metadata":{"execution":{"iopub.status.busy":"2021-06-04T09:35:20.860332Z","iopub.execute_input":"2021-06-04T09:35:20.861135Z","iopub.status.idle":"2021-06-04T09:35:24.479405Z","shell.execute_reply.started":"2021-06-04T09:35:20.861087Z","shell.execute_reply":"2021-06-04T09:35:24.478332Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"execution":{"iopub.status.busy":"2021-06-02T10:08:21.548183Z","iopub.execute_input":"2021-06-02T10:08:21.548763Z","iopub.status.idle":"2021-06-02T10:09:14.420773Z","shell.execute_reply.started":"2021-06-02T10:08:21.548676Z","shell.execute_reply":"2021-06-02T10:09:14.419437Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}