{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.13","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":71549,"databundleVersionId":8561470,"sourceType":"competition"}],"dockerImageVersionId":30698,"isInternetEnabled":false,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"# Testing submission with only mean\n### Besties 2024 Summer Kaggle","metadata":{}},{"cell_type":"code","source":"import pandas as pd\nimport numpy as np","metadata":{"execution":{"iopub.status.busy":"2024-07-26T05:44:55.174199Z","iopub.execute_input":"2024-07-26T05:44:55.174595Z","iopub.status.idle":"2024-07-26T05:44:55.180096Z","shell.execute_reply.started":"2024-07-26T05:44:55.174560Z","shell.execute_reply":"2024-07-26T05:44:55.178847Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# read data\ntrain_path = '/kaggle/input/rsna-2024-lumbar-spine-degenerative-classification/'\n\ntrain  = pd.read_csv(train_path + 'train.csv')\nlabel = pd.read_csv(train_path + 'train_label_coordinates.csv')\ntrain_desc  = pd.read_csv(train_path + 'train_series_descriptions.csv')\ntest_desc   = pd.read_csv(train_path + 'test_series_descriptions.csv')\nsub         = pd.read_csv(train_path + 'sample_submission.csv')\nsub","metadata":{"execution":{"iopub.status.busy":"2024-07-26T05:44:55.182485Z","iopub.execute_input":"2024-07-26T05:44:55.183048Z","iopub.status.idle":"2024-07-26T05:44:55.298344Z","shell.execute_reply.started":"2024-07-26T05:44:55.183003Z","shell.execute_reply":"2024-07-26T05:44:55.296798Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"severity = ['Normal/Mild','Moderate', 'Severe']\nsource = []\nfor col in train.columns[1:]:\n    nums = ['44036939_'+col]\n    for item in severity:\n        info = train[col]==item\n        proba = info.sum()/len(info)\n        nums.append(proba)\n    source.append(nums)\n\n\ndf = pd.DataFrame(source) \ndf.columns = ['row_id']+severity\ndf = df.sort_values('row_id').reset_index(drop=1)","metadata":{"execution":{"iopub.status.busy":"2024-07-26T05:44:55.299907Z","iopub.execute_input":"2024-07-26T05:44:55.301393Z","iopub.status.idle":"2024-07-26T05:44:55.334310Z","shell.execute_reply.started":"2024-07-26T05:44:55.301340Z","shell.execute_reply":"2024-07-26T05:44:55.333004Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"sub['normal_mild'] = df['Normal/Mild']\nsub['moderate'] = df['Moderate']\nsub['severe'] = df['Severe']","metadata":{"execution":{"iopub.status.busy":"2024-07-26T05:44:55.336412Z","iopub.execute_input":"2024-07-26T05:44:55.336809Z","iopub.status.idle":"2024-07-26T05:44:55.349217Z","shell.execute_reply.started":"2024-07-26T05:44:55.336774Z","shell.execute_reply":"2024-07-26T05:44:55.348092Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Save the DataFrame to \"submission.csv\" in the desired directory\npred = sub.copy()\npred.to_csv(\"submission.csv\", index=False)\npred\n","metadata":{"execution":{"iopub.status.busy":"2024-07-26T05:44:55.350382Z","iopub.execute_input":"2024-07-26T05:44:55.350712Z","iopub.status.idle":"2024-07-26T05:44:55.373967Z","shell.execute_reply.started":"2024-07-26T05:44:55.350684Z","shell.execute_reply":"2024-07-26T05:44:55.372771Z"},"trusted":true},"execution_count":null,"outputs":[]}]}