{"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, numpy as np\nimport polars as pl\n# from sklearn.model_selection import KFold, GroupKFold\n# from sklearn.ensemble import RandomForestClassifier\n# from sklearn.metrics import f1_score","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2023-03-22T07:09:40.691854Z","iopub.execute_input":"2023-03-22T07:09:40.692283Z","iopub.status.idle":"2023-03-22T07:09:40.888364Z","shell.execute_reply.started":"2023-03-22T07:09:40.692246Z","shell.execute_reply":"2023-03-22T07:09:40.887332Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train = pl.read_csv('/kaggle/input/pspgp-raw-train/train.csv')","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:09:41.373775Z","iopub.execute_input":"2023-03-22T07:09:41.374196Z","iopub.status.idle":"2023-03-22T07:10:10.907535Z","shell.execute_reply.started":"2023-03-22T07:09:41.374159Z","shell.execute_reply":"2023-03-22T07:10:10.906092Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# del train['fullscreen'], train['hq'], train['music']\nprint( train.shape )\n# train.head()","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:27:58.328420Z","iopub.execute_input":"2023-03-22T07:27:58.329527Z","iopub.status.idle":"2023-03-22T07:27:58.335021Z","shell.execute_reply.started":"2023-03-22T07:27:58.329480Z","shell.execute_reply":"2023-03-22T07:27:58.333899Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train = train.with_columns(train['index'].cast(pl.Int32))\nfor f in ['level', 'fullscreen', 'hq', 'music']:\n    train = train.with_columns(train[f].cast(pl.Int8))\n\nfor f in ['page', 'room_coor_x', 'room_coor_y', 'screen_coor_x', 'screen_coor_y', 'hover_duration']:\n    train = train.with_columns(train[f].cast(pl.Float32))\nfor f in ['event_name', 'name', 'text', 'fqid', 'room_fqid', 'text_fqid']:\n    train = train.with_columns(train[f].cast(pl.Categorical))\ntrain","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:27:16.183104Z","iopub.execute_input":"2023-03-22T07:27:16.183552Z","iopub.status.idle":"2023-03-22T07:27:25.391214Z","shell.execute_reply.started":"2023-03-22T07:27:16.183512Z","shell.execute_reply":"2023-03-22T07:27:25.389910Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# train['index'] = train['index'].astype('int32')\n# train['elapsed_time'] = train['elapsed_time'].astype('int32')\n# train['level'] = train['level'].astype('int8')\n# train['fullscreen'] = train['fullscreen'].astype('int8')\n# train['hq'] = train['hq'].astype('int8')\n# train['music'] = train['music'].astype('int8')\n\n# for f in ['page', 'room_coor_x', 'room_coor_y', 'screen_coor_x', 'screen_coor_y', 'hover_duration']:\n#     train[f] = train[f].astype('float32')","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:27:59.934069Z","iopub.execute_input":"2023-03-22T07:27:59.934788Z","iopub.status.idle":"2023-03-22T07:28:00.011773Z","shell.execute_reply.started":"2023-03-22T07:27:59.934750Z","shell.execute_reply":"2023-03-22T07:28:00.010071Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train.write_parquet('train.parquet')","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:31:06.388250Z","iopub.execute_input":"2023-03-22T07:31:06.388721Z","iopub.status.idle":"2023-03-22T07:31:18.351058Z","shell.execute_reply.started":"2023-03-22T07:31:06.388680Z","shell.execute_reply":"2023-03-22T07:31:18.349686Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# train1 = pl.read_parquet('train.parquet')","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:32:19.266452Z","iopub.execute_input":"2023-03-22T07:32:19.266877Z","iopub.status.idle":"2023-03-22T07:32:24.819023Z","shell.execute_reply.started":"2023-03-22T07:32:19.266841Z","shell.execute_reply":"2023-03-22T07:32:24.817657Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# train1","metadata":{"execution":{"iopub.status.busy":"2023-03-22T07:32:43.334607Z","iopub.execute_input":"2023-03-22T07:32:43.335007Z","iopub.status.idle":"2023-03-22T07:32:43.351525Z","shell.execute_reply.started":"2023-03-22T07:32:43.334974Z","shell.execute_reply":"2023-03-22T07:32:43.350339Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}