{"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":"gpu","dataSources":[{"sourceId":71549,"databundleVersionId":8561470,"sourceType":"competition"}],"dockerImageVersionId":30746,"isInternetEnabled":false,"language":"python","sourceType":"notebook","isGpuEnabled":true}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import pandas as pd\nimport numpy as np","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2024-07-22T14:13:21.306487Z","iopub.execute_input":"2024-07-22T14:13:21.307731Z","iopub.status.idle":"2024-07-22T14:13:21.312993Z","shell.execute_reply.started":"2024-07-22T14:13:21.307683Z","shell.execute_reply":"2024-07-22T14:13:21.311582Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"test_description = pd.read_csv('/kaggle/input/rsna-2024-lumbar-spine-degenerative-classification/test_series_descriptions.csv')\ntest_description.head()","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.315572Z","iopub.execute_input":"2024-07-22T14:13:21.316070Z","iopub.status.idle":"2024-07-22T14:13:21.343275Z","shell.execute_reply.started":"2024-07-22T14:13:21.316022Z","shell.execute_reply":"2024-07-22T14:13:21.341550Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train = pd.read_csv('/kaggle/input/rsna-2024-lumbar-spine-degenerative-classification/train.csv')\ntrain.columns","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.345851Z","iopub.execute_input":"2024-07-22T14:13:21.346844Z","iopub.status.idle":"2024-07-22T14:13:21.376846Z","shell.execute_reply.started":"2024-07-22T14:13:21.346798Z","shell.execute_reply":"2024-07-22T14:13:21.375671Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"diagnosis = train.columns[1:]\ndiagnosis","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.378237Z","iopub.execute_input":"2024-07-22T14:13:21.378646Z","iopub.status.idle":"2024-07-22T14:13:21.387553Z","shell.execute_reply.started":"2024-07-22T14:13:21.378612Z","shell.execute_reply":"2024-07-22T14:13:21.386092Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission = pd.DataFrame()\nsubmission['study_id'] = test_description['study_id'].unique()\nN = len(submission)\nsubmission[diagnosis] = 1/3\nnormal_scores = submission.copy()\nmoderate_scores = submission.copy()\nsevere_scores = submission.copy()\nids = []\nfor study_id in submission.study_id:\n    ids = ids + (str(study_id) + '_' + diagnosis).tolist() ","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.391043Z","iopub.execute_input":"2024-07-22T14:13:21.391629Z","iopub.status.idle":"2024-07-22T14:13:21.414696Z","shell.execute_reply.started":"2024-07-22T14:13:21.391584Z","shell.execute_reply":"2024-07-22T14:13:21.413215Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"That's the base line with score 1.02\n\nNow make your predicitions and store them in each normal/moderate/severe df\n\nFor example, let's try the means for each patology and location.","metadata":{}},{"cell_type":"code","source":"train = pd.read_csv('/kaggle/input/rsna-2024-lumbar-spine-degenerative-classification/train.csv')\ntrain.head()","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.416447Z","iopub.execute_input":"2024-07-22T14:13:21.416944Z","iopub.status.idle":"2024-07-22T14:13:21.468935Z","shell.execute_reply.started":"2024-07-22T14:13:21.416898Z","shell.execute_reply":"2024-07-22T14:13:21.467608Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"normal = (train[diagnosis] == 'Normal/Mild').sum()\nmoderate = (train[diagnosis] == 'Moderate').sum()\nsevere = (train[diagnosis] == 'Severe').sum()\ntotal = normal + moderate + severe\nnormal /= total\nmoderate /= total\nsevere /= total","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.470675Z","iopub.execute_input":"2024-07-22T14:13:21.471100Z","iopub.status.idle":"2024-07-22T14:13:21.514283Z","shell.execute_reply.started":"2024-07-22T14:13:21.471071Z","shell.execute_reply":"2024-07-22T14:13:21.513031Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"normal","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.515736Z","iopub.execute_input":"2024-07-22T14:13:21.516073Z","iopub.status.idle":"2024-07-22T14:13:21.526281Z","shell.execute_reply.started":"2024-07-22T14:13:21.516044Z","shell.execute_reply":"2024-07-22T14:13:21.525100Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"moderate","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.527806Z","iopub.execute_input":"2024-07-22T14:13:21.528150Z","iopub.status.idle":"2024-07-22T14:13:21.542332Z","shell.execute_reply.started":"2024-07-22T14:13:21.528120Z","shell.execute_reply":"2024-07-22T14:13:21.541145Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"severe","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.544378Z","iopub.execute_input":"2024-07-22T14:13:21.545578Z","iopub.status.idle":"2024-07-22T14:13:21.560107Z","shell.execute_reply.started":"2024-07-22T14:13:21.545507Z","shell.execute_reply":"2024-07-22T14:13:21.558714Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"normal_scores.loc[:,diagnosis] = np.stack([normal]*N)\nmoderate_scores.loc[:,diagnosis] = np.stack([moderate]*N)\nsevere_scores.loc[:,diagnosis] = np.stack([severe]*N)","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.563608Z","iopub.execute_input":"2024-07-22T14:13:21.563988Z","iopub.status.idle":"2024-07-22T14:13:21.577903Z","shell.execute_reply.started":"2024-07-22T14:13:21.563957Z","shell.execute_reply":"2024-07-22T14:13:21.576597Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"Now, make the csv","metadata":{}},{"cell_type":"code","source":"sample = pd.read_csv('/kaggle/input/rsna-2024-lumbar-spine-degenerative-classification/sample_submission.csv')\nsample.columns","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.580272Z","iopub.execute_input":"2024-07-22T14:13:21.581223Z","iopub.status.idle":"2024-07-22T14:13:21.597449Z","shell.execute_reply.started":"2024-07-22T14:13:21.581176Z","shell.execute_reply":"2024-07-22T14:13:21.595657Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"pd.DataFrame({\n    'row_id':ids,\n    'normal_mild':normal_scores[diagnosis].values.flatten(),\n    'moderate':moderate_scores[diagnosis].values.flatten(),\n    'severe':severe_scores[diagnosis].values.flatten()\n}).to_csv('submission.csv',index=False)","metadata":{"execution":{"iopub.status.busy":"2024-07-22T14:13:21.599123Z","iopub.execute_input":"2024-07-22T14:13:21.600259Z","iopub.status.idle":"2024-07-22T14:13:21.610398Z","shell.execute_reply.started":"2024-07-22T14:13:21.600224Z","shell.execute_reply":"2024-07-22T14:13:21.609172Z"},"trusted":true},"execution_count":null,"outputs":[]}]}