{"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 numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport polars as pl\nfrom matplotlib import pyplot as plt\nimport seaborn as sns\nplt.style.use('fivethirtyeight')\nplt.rcParams['figure.figsize'] = (30, 20)\nsns.set_style('darkgrid')\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2023-05-05T12:22:03.847641Z","iopub.execute_input":"2023-05-05T12:22:03.848802Z","iopub.status.idle":"2023-05-05T12:22:03.858693Z","shell.execute_reply.started":"2023-05-05T12:22:03.848754Z","shell.execute_reply":"2023-05-05T12:22:03.857955Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train_id = pl.read_csv('/kaggle/input/predict-student-performance-from-game-play/train.csv', columns = ['index'])\ndisplay(train_id)","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:22:09.788976Z","iopub.execute_input":"2023-05-05T12:22:09.789300Z","iopub.status.idle":"2023-05-05T12:22:14.293253Z","shell.execute_reply.started":"2023-05-05T12:22:09.789270Z","shell.execute_reply":"2023-05-05T12:22:14.292454Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"tmp = pd.read_csv('/kaggle/input/predict-student-performance-from-game-play/train.csv', usecols=[0])\ntmp.head()","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:22:14.295299Z","iopub.execute_input":"2023-05-05T12:22:14.295829Z","iopub.status.idle":"2023-05-05T12:22:41.984031Z","shell.execute_reply.started":"2023-05-05T12:22:14.295754Z","shell.execute_reply":"2023-05-05T12:22:41.982736Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"tmp = pd.read_csv('/kaggle/input/predict-student-performance-from-game-play/train.csv', usecols=[3])\ntmp.head()","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:22:41.985279Z","iopub.execute_input":"2023-05-05T12:22:41.985570Z","iopub.status.idle":"2023-05-05T12:23:11.016965Z","shell.execute_reply.started":"2023-05-05T12:22:41.985545Z","shell.execute_reply":"2023-05-05T12:23:11.016155Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"tmp.describe().T","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:23:11.018081Z","iopub.execute_input":"2023-05-05T12:23:11.018532Z","iopub.status.idle":"2023-05-05T12:23:13.956360Z","shell.execute_reply.started":"2023-05-05T12:23:11.018505Z","shell.execute_reply":"2023-05-05T12:23:13.955486Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"tmp['event_name'].hist(bins = 25)","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:23:13.957588Z","iopub.execute_input":"2023-05-05T12:23:13.958072Z","iopub.status.idle":"2023-05-05T12:23:25.276590Z","shell.execute_reply.started":"2023-05-05T12:23:13.958043Z","shell.execute_reply":"2023-05-05T12:23:25.275802Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"dtyping = {\n    'session_id' : np.uint64,\n    'index' : np.uint16,\n    'elapsed_time' : np.uint16,\n    'event_name' : 'category',\n    'name' : 'category',\n    'level' : np.uint8,\n    'page' : np.uint16,\n    'room_coor_x' : np.float16,\n    'room_coor_y' : np.float16,\n    'screen_coor_x' : np.float16,\n    'screen_coor_y' : np.float16,\n    'hover_duration' : np.float16,\n    'text' : 'category',\n    'fqid' : 'category',\n    'room_fqid' : 'category',\n    'text_fqid' : 'category',\n    'fullscreen' : np.bool8,\n    'hq' : np.bool8,\n    'music' : np.bool8,\n    'level_group' : 'category'\n}","metadata":{"execution":{"iopub.status.busy":"2023-05-05T12:23:25.277753Z","iopub.execute_input":"2023-05-05T12:23:25.278220Z","iopub.status.idle":"2023-05-05T12:23:25.283570Z","shell.execute_reply.started":"2023-05-05T12:23:25.278193Z","shell.execute_reply":"2023-05-05T12:23:25.282732Z"},"trusted":true},"execution_count":null,"outputs":[]}]}