{"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":"markdown","source":"Link - [Here](https://www.kaggle.com/code/mishazybin/simple-baseline-submit-medians/notebook)","metadata":{}},{"cell_type":"code","source":"import numpy as np\nimport pandas as pd","metadata":{"_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","papermill":{"duration":0.33912,"end_time":"2023-09-29T12:38:55.681880","exception":false,"start_time":"2023-09-29T12:38:55.342760","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:15:01.178681Z","iopub.execute_input":"2023-10-16T11:15:01.179548Z","iopub.status.idle":"2023-10-16T11:15:01.603160Z","shell.execute_reply.started":"2023-10-16T11:15:01.179496Z","shell.execute_reply":"2023-10-16T11:15:01.601824Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_data = pd.read_csv(\"/kaggle/input/stanford-ribonanza-rna-folding/train_data.csv\")\nsample_submission = pd.read_csv('/kaggle/input/stanford-ribonanza-rna-folding/sample_submission.csv')","metadata":{"papermill":{"duration":171.137641,"end_time":"2023-09-29T12:41:46.833945","exception":false,"start_time":"2023-09-29T12:38:55.696304","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:15:46.495451Z","iopub.execute_input":"2023-10-16T11:15:46.496134Z","iopub.status.idle":"2023-10-16T11:19:09.365684Z","shell.execute_reply.started":"2023-10-16T11:15:46.496090Z","shell.execute_reply":"2023-10-16T11:19:09.364351Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"reactivity_columns = train_data.columns[train_data.columns.str.startswith('reactivity_0')]\nsn_filter = (train_data.SN_filter == 1)\nexp_type = (train_data.experiment_type == '2A3_MaP')\ntwoA3 = train_data[sn_filter & exp_type][reactivity_columns].median().median()\nDMS_MaP = train_data[sn_filter & ~exp_type][reactivity_columns].median().median()","metadata":{"papermill":{"duration":2.382339,"end_time":"2023-09-29T12:41:49.223512","exception":false,"start_time":"2023-09-29T12:41:46.841173","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:19:16.356097Z","iopub.execute_input":"2023-10-16T11:19:16.356591Z","iopub.status.idle":"2023-10-16T11:19:19.094458Z","shell.execute_reply.started":"2023-10-16T11:19:16.356551Z","shell.execute_reply":"2023-10-16T11:19:19.093364Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"print(twoA3, DMS_MaP)","metadata":{"papermill":{"duration":0.010344,"end_time":"2023-09-29T12:41:49.236460","exception":false,"start_time":"2023-09-29T12:41:49.226116","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:19:23.241547Z","iopub.execute_input":"2023-10-16T11:19:23.242036Z","iopub.status.idle":"2023-10-16T11:19:23.248827Z","shell.execute_reply.started":"2023-10-16T11:19:23.241998Z","shell.execute_reply":"2023-10-16T11:19:23.247446Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample_submission['reactivity_2A3_MaP'] = twoA3\nsample_submission['reactivity_DMS_MaP'] = DMS_MaP","metadata":{"papermill":{"duration":0.97399,"end_time":"2023-09-29T12:41:50.217559","exception":false,"start_time":"2023-09-29T12:41:49.243569","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:19:26.353731Z","iopub.execute_input":"2023-10-16T11:19:26.354148Z","iopub.status.idle":"2023-10-16T11:19:27.777162Z","shell.execute_reply.started":"2023-10-16T11:19:26.354119Z","shell.execute_reply":"2023-10-16T11:19:27.775906Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sample_submission.to_csv('submission.csv', index=None)","metadata":{"papermill":{"duration":635.571121,"end_time":"2023-09-29T12:52:25.791466","exception":false,"start_time":"2023-09-29T12:41:50.220345","status":"completed"},"tags":[],"execution":{"iopub.status.busy":"2023-10-16T11:19:29.903617Z","iopub.execute_input":"2023-10-16T11:19:29.904078Z","iopub.status.idle":"2023-10-16T11:30:56.327020Z","shell.execute_reply.started":"2023-10-16T11:19:29.904023Z","shell.execute_reply":"2023-10-16T11:30:56.326133Z"},"trusted":true},"execution_count":null,"outputs":[]}]}