{"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"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":81933,"databundleVersionId":9643020,"sourceType":"competition"}],"dockerImageVersionId":30786,"isInternetEnabled":false,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"In this version just assign every sii to 0","metadata":{}},{"cell_type":"markdown","source":"9 of the 20 ids in the test set are in the training set. Let's make a submission that takes the 11 that exist in the training, and assign 0 to the other 9.","metadata":{}},{"cell_type":"code","source":"import pandas as pd\n\n# Load the existing submission.csv\nsubmission = pd.read_csv('/kaggle/input/child-mind-institute-problematic-internet-use/sample_submission.csv')\n\n# Ensure the required columns are present\nif 'sii' not in submission.columns:\n    raise ValueError(\"The column 'sii' is missing from the submission file.\")\n\n# Set all 'sii' values to 0\nsubmission['sii'] = 0\n\n# Save the updated submission.csv\nsubmission.to_csv('submission.csv', index=False)\n\nprint(\"All 'sii' values have been set to 0. Updated file saved as 'submission_zeroed.csv'.\")\n\n\n","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"outputs":[],"execution_count":null}]}