{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.11.11","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":10384,"databundleVersionId":120379,"sourceType":"competition"},{"sourceId":11944265,"sourceType":"datasetVersion","datasetId":7508796},{"sourceId":11945673,"sourceType":"datasetVersion","datasetId":7509753},{"sourceId":11951142,"sourceType":"datasetVersion","datasetId":7513614},{"sourceId":11951496,"sourceType":"datasetVersion","datasetId":7513807},{"sourceId":11951708,"sourceType":"datasetVersion","datasetId":7513948}],"dockerImageVersionId":31040,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import numpy as np\nimport pandas as pd","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"execution":{"iopub.status.busy":"2025-05-26T01:27:05.817138Z","iopub.execute_input":"2025-05-26T01:27:05.817455Z","iopub.status.idle":"2025-05-26T01:27:05.821633Z","shell.execute_reply.started":"2025-05-26T01:27:05.817433Z","shell.execute_reply":"2025-05-26T01:27:05.820702Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"predictions = pd.DataFrame()\n\ncolumns = [\"object_id\", \"class_6\", \"class_15\", \"class_16\", \"class_42\", \"class_52\", \"class_53\", \"class_62\", \"class_64\", \"class_65\", \"class_67\", \"class_88\", \"class_90\", \"class_92\", \"class_95\", \"class_99\"]\n\npredictions = pd.DataFrame()\nfor column in columns:\n    predictions[column] = 0\n    \nfor i in range(1,12):\n    batch = np.load(f\"/kaggle/input/predictions5/predictions_batch{i}.npy\") #xgbpredictions or predictions\n\n    predictions_batch_DataFrame = pd.DataFrame()\n    for column in columns:\n        predictions_batch_DataFrame[column] = 0\n        \n    predictions_batch = []\n    \n    for item in batch:\n        star_class = 'class_' + str(int(item[1]))\n        predictions_batch.append({'object_id': int(item[0]), star_class: 1})\n\n    predictions_batch = pd.DataFrame(predictions_batch)\n    predictions_batch_DataFrame = pd.concat((predictions_batch_DataFrame, predictions_batch), ignore_index = True)\n    \n    predictions_batch_DataFrame.fillna(0, inplace=True)\n    predictions = pd.concat((predictions, predictions_batch_DataFrame), ignore_index = True)\n\n    #print(predictions.loc[10])\n    print(f\"done with batch {i}\")\n    #print(predictions_batch_DataFrame)\n\nfor item in predictions.columns:\n    predictions[item] = pd.to_numeric(predictions[item], downcast='integer', errors='coerce')\n    \nprint(predictions.loc[:10])\npredictions.to_csv(\"submission.csv\", index=False)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-05-26T01:27:06.030181Z","iopub.execute_input":"2025-05-26T01:27:06.030469Z","iopub.status.idle":"2025-05-26T01:27:29.843053Z","shell.execute_reply.started":"2025-05-26T01:27:06.030449Z","shell.execute_reply":"2025-05-26T01:27:29.842282Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"print(predictions)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-05-26T01:27:29.844662Z","iopub.execute_input":"2025-05-26T01:27:29.845499Z","iopub.status.idle":"2025-05-26T01:27:29.855384Z","shell.execute_reply.started":"2025-05-26T01:27:29.845474Z","shell.execute_reply":"2025-05-26T01:27:29.854420Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"train = pd.read_csv('/kaggle/working/submission.csv', index_col=None)\nprint(train.loc[:10])","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-05-26T01:27:29.856388Z","iopub.execute_input":"2025-05-26T01:27:29.856964Z","iopub.status.idle":"2025-05-26T01:27:32.187336Z","shell.execute_reply.started":"2025-05-26T01:27:29.856935Z","shell.execute_reply":"2025-05-26T01:27:32.186320Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"","metadata":{"trusted":true},"outputs":[],"execution_count":null}]}