{"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":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load\n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n# !pip install duckdb\n# import duckdb","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2022-06-17T08:46:10.368156Z","iopub.execute_input":"2022-06-17T08:46:10.369326Z","iopub.status.idle":"2022-06-17T08:46:10.374754Z","shell.execute_reply.started":"2022-06-17T08:46:10.369276Z","shell.execute_reply":"2022-06-17T08:46:10.373708Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"%%time\nbalance_columns = ['B_'+ str(x) for x in list(range(1,34))+list(range(36,43))]\ncolumns_required = ['customer_ID', 'S_2', 'target']+balance_columns\ntrain = pd.read_feather('../input/amexfeather/train_data.ftr', columns = columns_required)\n# test = pd.read_feather('../input/amexfeather/test_data.ftr')\nwith pd.option_context(\"display.min_rows\", 6):\n    display(train)\n#     display(test)","metadata":{"execution":{"iopub.status.busy":"2022-06-17T08:49:08.379012Z","iopub.execute_input":"2022-06-17T08:49:08.37956Z","iopub.status.idle":"2022-06-17T08:49:26.61045Z","shell.execute_reply.started":"2022-06-17T08:49:08.37952Z","shell.execute_reply":"2022-06-17T08:49:26.609432Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"train.info(max_cols=200, show_counts=True)","metadata":{"execution":{"iopub.status.busy":"2022-06-17T08:50:37.684111Z","iopub.execute_input":"2022-06-17T08:50:37.684658Z","iopub.status.idle":"2022-06-17T08:50:39.604229Z","shell.execute_reply.started":"2022-06-17T08:50:37.684617Z","shell.execute_reply":"2022-06-17T08:50:39.602994Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}