{"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"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import pandas as pd\nmnist_test = pd.read_csv(\"../input/mnistincsv/mnist_test.csv\")\nmnist_train = pd.read_csv(\"../input/mnistincsv/mnist_train.csv\")","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2021-11-24T18:17:52.455651Z","iopub.execute_input":"2021-11-24T18:17:52.456139Z","iopub.status.idle":"2021-11-24T18:17:59.021703Z","shell.execute_reply.started":"2021-11-24T18:17:52.456052Z","shell.execute_reply":"2021-11-24T18:17:59.020751Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission = pd.read_csv(\"../input/digit-recognizer/sample_submission.csv\")\ntest = pd.read_csv(\"../input/digit-recognizer/test.csv\")\ntrain = pd.read_csv(\"../input/digit-recognizer/train.csv\")","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:17:59.023627Z","iopub.execute_input":"2021-11-24T18:17:59.024055Z","iopub.status.idle":"2021-11-24T18:18:05.438048Z","shell.execute_reply.started":"2021-11-24T18:17:59.024011Z","shell.execute_reply":"2021-11-24T18:18:05.437220Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"cols = test.columns","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:05.439137Z","iopub.execute_input":"2021-11-24T18:18:05.439390Z","iopub.status.idle":"2021-11-24T18:18:05.443946Z","shell.execute_reply.started":"2021-11-24T18:18:05.439361Z","shell.execute_reply":"2021-11-24T18:18:05.443160Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"test['dataset'] = 'test'\ntrain['dataset'] = 'train'","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:05.445810Z","iopub.execute_input":"2021-11-24T18:18:05.446165Z","iopub.status.idle":"2021-11-24T18:18:05.462962Z","shell.execute_reply.started":"2021-11-24T18:18:05.446135Z","shell.execute_reply":"2021-11-24T18:18:05.462121Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"dataset = pd.concat([train.drop('label', axis=1), test]).reset_index()","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:05.464505Z","iopub.execute_input":"2021-11-24T18:18:05.464819Z","iopub.status.idle":"2021-11-24T18:18:05.954219Z","shell.execute_reply.started":"2021-11-24T18:18:05.464788Z","shell.execute_reply":"2021-11-24T18:18:05.953383Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"mnist = pd.concat([mnist_train, mnist_test]).reset_index(drop=True)\nlabels = mnist['label'].values\nmnist.drop('label', axis=1, inplace=True)\nmnist.columns = cols","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:05.955409Z","iopub.execute_input":"2021-11-24T18:18:05.955642Z","iopub.status.idle":"2021-11-24T18:18:06.434453Z","shell.execute_reply.started":"2021-11-24T18:18:05.955613Z","shell.execute_reply":"2021-11-24T18:18:06.433678Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"idx_mnist = mnist.sort_values(by=list(mnist.columns)).index\ndataset_from = dataset.sort_values(by=list(mnist.columns))['dataset'].values\noriginal_idx = dataset.sort_values(by=list(mnist.columns))['index'].values","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:06.435944Z","iopub.execute_input":"2021-11-24T18:18:06.436205Z","iopub.status.idle":"2021-11-24T18:18:14.479555Z","shell.execute_reply.started":"2021-11-24T18:18:06.436177Z","shell.execute_reply":"2021-11-24T18:18:14.478819Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"for i in range(len(idx_mnist)):\n    if dataset_from[i] == 'test':\n        submission.loc[original_idx[i], 'Label'] = labels[idx_mnist[i]]","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:14.480920Z","iopub.execute_input":"2021-11-24T18:18:14.481159Z","iopub.status.idle":"2021-11-24T18:18:16.497824Z","shell.execute_reply.started":"2021-11-24T18:18:14.481131Z","shell.execute_reply":"2021-11-24T18:18:16.497073Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:18:16.498920Z","iopub.execute_input":"2021-11-24T18:18:16.499168Z","iopub.status.idle":"2021-11-24T18:18:16.515457Z","shell.execute_reply.started":"2021-11-24T18:18:16.499139Z","shell.execute_reply":"2021-11-24T18:18:16.514407Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"submission.to_csv('submission.csv', index=False)","metadata":{"execution":{"iopub.status.busy":"2021-11-24T18:19:01.406429Z","iopub.execute_input":"2021-11-24T18:19:01.406752Z","iopub.status.idle":"2021-11-24T18:19:01.463792Z","shell.execute_reply.started":"2021-11-24T18:19:01.406723Z","shell.execute_reply":"2021-11-24T18:19:01.462983Z"},"trusted":true},"execution_count":null,"outputs":[]}]}