{"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":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load\n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n\n","metadata":{"_uuid":"5da8702d-5228-46e6-a2bf-56035f1ce780","_cell_guid":"1e3f1640-34ea-4994-9a2e-ed07b4a86b40","execution":{"iopub.status.busy":"2021-09-01T16:16:50.693662Z","iopub.execute_input":"2021-09-01T16:16:50.694078Z","iopub.status.idle":"2021-09-01T16:16:50.698909Z","shell.execute_reply.started":"2021-09-01T16:16:50.693991Z","shell.execute_reply":"2021-09-01T16:16:50.697818Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"# Submssion","metadata":{}},{"cell_type":"markdown","source":"The idea of this notbook is to quickly submit a privatly calculatet file","metadata":{}},{"cell_type":"code","source":"def isNaN(num):\n    return num != num\n\nsample_submission = pd.read_csv('../input/landmark-recognition-2021/sample_submission.csv')\n\nlocal_df = pd.read_csv('../input/glm-submission/submission.csv',index_col=0)\n\n\nfor i, row in sample_submission.iterrows():\n    if row['id'] in local_df.index:\n        if isNaN(local_df.loc[row['id']].landmarks): continue\n        sample_submission.landmarks.loc[i] = local_df.loc[row['id']].landmarks\n\nsample_submission.to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2021-09-01T16:18:36.628295Z","iopub.execute_input":"2021-09-01T16:18:36.628649Z","iopub.status.idle":"2021-09-01T16:18:41.940806Z","shell.execute_reply.started":"2021-09-01T16:18:36.628616Z","shell.execute_reply":"2021-09-01T16:18:41.939867Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"local_df['landmarks'][0].split(' ')","metadata":{"execution":{"iopub.status.busy":"2021-09-01T16:20:02.062799Z","iopub.execute_input":"2021-09-01T16:20:02.063701Z","iopub.status.idle":"2021-09-01T16:20:02.070683Z","shell.execute_reply.started":"2021-09-01T16:20:02.063643Z","shell.execute_reply":"2021-09-01T16:20:02.069214Z"},"trusted":true},"execution_count":null,"outputs":[]}]}