{"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\n# Input data files are available in the read-only \"../input/\" directory\n# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n\nsample_sub = pd.read_csv('../input/hubmap-kidney-segmentation/sample_submission.csv', index_col='id')\nsubmission = pd.read_csv('../input/d48-from-public/d48_hand_labelled.csv', index_col='id')","metadata":{"_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","papermill":{"duration":0.066811,"end_time":"2021-05-09T03:58:49.235323","exception":false,"start_time":"2021-05-09T03:58:49.168512","status":"completed"},"tags":[],"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission.index.values","metadata":{"papermill":{"duration":0.013615,"end_time":"2021-05-09T03:58:49.253003","exception":false,"start_time":"2021-05-09T03:58:49.239388","status":"completed"},"tags":[],"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pub_ids = submission.index.values\npub_ids","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"predictions = submission.values\n","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample_sub.loc[pub_ids] = predictions\n","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pub_ids = submission.index.values\npredictions = submission.values\n# sample_sub.loc[pub_ids[4]] = predictions[4]\nsample_sub.loc[pub_ids] = predictions\nsample_sub.to_csv('submission.csv')\n","metadata":{"papermill":{"duration":0.366809,"end_time":"2021-05-09T03:58:49.624090","exception":false,"start_time":"2021-05-09T03:58:49.257281","status":"completed"},"tags":[],"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample_sub","metadata":{"papermill":{"duration":0.022299,"end_time":"2021-05-09T03:58:49.650682","exception":false,"start_time":"2021-05-09T03:58:49.628383","status":"completed"},"tags":[],"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{"papermill":{"duration":0.004394,"end_time":"2021-05-09T03:58:49.659804","exception":false,"start_time":"2021-05-09T03:58:49.655410","status":"completed"},"tags":[]},"execution_count":null,"outputs":[]}]}