{"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":"# i cannot invite my teammate to join the team. \n# is it becuase he did not make a submission?\n# this is the first time he join kaggle and is not familiar with the system\n# i create this zero-submission to debug the problem","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2023-02-18T11:48:29.336897Z","iopub.execute_input":"2023-02-18T11:48:29.3377Z","iopub.status.idle":"2023-02-18T11:48:29.360868Z","shell.execute_reply.started":"2023-02-18T11:48:29.337592Z","shell.execute_reply":"2023-02-18T11:48:29.359671Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"\nimport pandas as pd\ncsv_file = '/kaggle/input/rsna-breast-cancer-detection/test.csv'\ntest_df = pd.read_csv(csv_file)\n\nsubmit_df = pd.DataFrame({\n        'prediction_id': test_df.prediction_id,\n})\nsubmit_df.loc[:,'cancer']=0\nsubmit_df = submit_df.groupby(['prediction_id']).mean()\nsubmit_df = submit_df.reset_index(drop=False)\n\n\nsubmit_df[['prediction_id','cancer']].to_csv('submission.csv', index=False)\nprint('submit_df\\n', submit_df)\nprint('')\n","metadata":{"execution":{"iopub.status.busy":"2023-02-18T11:49:01.463356Z","iopub.execute_input":"2023-02-18T11:49:01.463737Z","iopub.status.idle":"2023-02-18T11:49:01.508453Z","shell.execute_reply.started":"2023-02-18T11:49:01.463706Z","shell.execute_reply":"2023-02-18T11:49:01.507333Z"},"trusted":true},"execution_count":null,"outputs":[]}]}