{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.12","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":90906,"databundleVersionId":10646448,"sourceType":"competition"}],"dockerImageVersionId":30822,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import pandas as pd\nimport numpy as np\ndf=pd.read_csv(\"/kaggle/input/delaware-student-discipline-dataset/student_discipline.csv\")\ndef rmsle(y_true,y_pred):\n    return np.sqrt(np.mean((np.log1p(y_pred)-np.log1p(y_true))**2))\ndf=df.groupby(['School Year','School Code'])['Race'].count().reset_index().rename(columns={'Race':'Target'})\nprint(\"< use last year's Target to predict this year's Target.\")\nfor year in range(2015,2022):\n    print(rmsle(df[df['School Year']==year+1]['Target'].values,df[df['School Year']==year]['Target'].values))","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"execution":{"iopub.status.busy":"2024-12-31T03:22:45.319639Z","iopub.execute_input":"2024-12-31T03:22:45.320102Z","iopub.status.idle":"2024-12-31T03:22:47.272726Z","shell.execute_reply.started":"2024-12-31T03:22:45.320070Z","shell.execute_reply":"2024-12-31T03:22:47.271686Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"sub=df[df['School Year']==2022][['School Code','Target']]\nsub.to_csv(\"submission.csv\",index=None)\nsub.head()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2024-12-31T03:22:47.274200Z","iopub.execute_input":"2024-12-31T03:22:47.274578Z","iopub.status.idle":"2024-12-31T03:22:47.290103Z","shell.execute_reply.started":"2024-12-31T03:22:47.274539Z","shell.execute_reply":"2024-12-31T03:22:47.288961Z"}},"outputs":[],"execution_count":null}]}