{"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\nsub = pd.read_csv('../input/siim-test/covid-19 submission.csv')\nsub.head()","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:23:09.017790Z","iopub.execute_input":"2021-06-27T11:23:09.018140Z","iopub.status.idle":"2021-06-27T11:23:09.034965Z","shell.execute_reply.started":"2021-06-27T11:23:09.018105Z","shell.execute_reply":"2021-06-27T11:23:09.033952Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample = pd.read_csv('../input/siim-covid19-detection/sample_submission.csv')\nsample.head()","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:23:04.654747Z","iopub.execute_input":"2021-06-27T11:23:04.655087Z","iopub.status.idle":"2021-06-27T11:23:04.670118Z","shell.execute_reply.started":"2021-06-27T11:23:04.655059Z","shell.execute_reply":"2021-06-27T11:23:04.669387Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample['PredictionString'] = sub.PredictionString.values","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:25:27.089017Z","iopub.execute_input":"2021-06-27T11:25:27.089439Z","iopub.status.idle":"2021-06-27T11:25:27.094448Z","shell.execute_reply.started":"2021-06-27T11:25:27.089402Z","shell.execute_reply":"2021-06-27T11:25:27.093400Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample.loc[sample.id.str.contains('study'), 'PredictionString'] = 'typical 1.0 0 0 1 1'","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:45:51.832351Z","iopub.execute_input":"2021-06-27T11:45:51.832707Z","iopub.status.idle":"2021-06-27T11:45:51.839903Z","shell.execute_reply.started":"2021-06-27T11:45:51.832679Z","shell.execute_reply":"2021-06-27T11:45:51.838673Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:45:54.645613Z","iopub.execute_input":"2021-06-27T11:45:54.646096Z","iopub.status.idle":"2021-06-27T11:45:54.658340Z","shell.execute_reply.started":"2021-06-27T11:45:54.646066Z","shell.execute_reply":"2021-06-27T11:45:54.657248Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# sub.to_csv('submission.csv', index=None)","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:05:42.278398Z","iopub.execute_input":"2021-06-27T11:05:42.278748Z","iopub.status.idle":"2021-06-27T11:05:42.296798Z","shell.execute_reply.started":"2021-06-27T11:05:42.278719Z","shell.execute_reply":"2021-06-27T11:05:42.296003Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample.to_csv('submission.csv', index=None)","metadata":{"execution":{"iopub.status.busy":"2021-06-27T11:45:56.943791Z","iopub.execute_input":"2021-06-27T11:45:56.944129Z","iopub.status.idle":"2021-06-27T11:45:56.957091Z","shell.execute_reply.started":"2021-06-27T11:45:56.944101Z","shell.execute_reply":"2021-06-27T11:45:56.956112Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}