{"cells":[{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"cell_type":"code","source":"import numpy as np\nimport pandas as pd\nimport matplotlib.pyplot as plt\nimport seaborn as sns\n\nimport os\nprint(os.listdir(\"../input\"))","execution_count":null,"outputs":[]},{"metadata":{"_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","trusted":true},"cell_type":"code","source":"train = pd.read_csv('../input/train.csv')\ntest = pd.read_csv('../input/test.csv')\nmerchants = pd.read_csv('../input/merchants.csv')\nnew_merchant_t = pd.read_csv('../input/new_merchant_transactions.csv')\nhis_trans = pd.read_csv('../input/historical_transactions.csv')","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5b346bc1cf9a36f53c7cc910d55a4e5ee1d97852"},"cell_type":"code","source":"print(train.shape)\nprint(test.shape)\nprint(merchants.shape)\nprint(new_merchant_t.shape)\nprint(his_trans.shape)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"a3ca2b88d15a05910e2167389de03ec85b572974"},"cell_type":"code","source":"train.dtypes","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c5ba2c2510a3617fb4a07b00d8b3bb832d4f8da2"},"cell_type":"code","source":"train['first_active_month'] = pd.to_datetime(train['first_active_month']).apply(lambda x: x.strftime('%Y-%m'))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"a14d9d7e4e92f3b13ad38670c00c4382580f77bc"},"cell_type":"code","source":"new_merchant_t['city_id'] = new_merchant_t['city_id'].astype(object)\nnew_merchant_t['merchant_category_id'] = new_merchant_t['merchant_category_id'].astype(object)\nnew_merchant_t['category_2'] = new_merchant_t['category_2'].astype(object)\nnew_merchant_t['state_id'] = new_merchant_t['state_id'].astype(object)\nnew_merchant_t['subsector_id'] = new_merchant_t['subsector_id'].astype(object)\nnew_merchant_t['purchase_date'] = pd.to_datetime(new_merchant_t['purchase_date'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1694abbcd537320deee3166620ec2ab6367d7965"},"cell_type":"code","source":"his_trans['city_id'] = his_trans['city_id'].astype(object)\nhis_trans['merchant_category_id'] = his_trans['merchant_category_id'].astype(object)\nhis_trans['category_2'] = his_trans['category_2'].astype(object)\nhis_trans['state_id'] = his_trans['state_id'].astype(object)\nhis_trans['subsector_id'] = his_trans['subsector_id'].astype(object)\nhis_trans['purchase_date'] = pd.to_datetime(his_trans['purchase_date'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c15c4a16677ba624cc2b2159b562b098ef28da23"},"cell_type":"code","source":"merchants['merchant_group_id'] = merchants['merchant_group_id'].astype(object)\nmerchants['merchant_category_id'] = merchants['merchant_category_id'].astype(object)\nmerchants['subsector_id'] = merchants['subsector_id'].astype(object)\nmerchants['city_id'] = merchants['city_id'].astype(object)\nmerchants['state_id'] = merchants['state_id'].astype(object)\nmerchants['category_2'] = merchants['category_2'].astype(object)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e31856106b79e6474085bbe026887679cecce45d"},"cell_type":"code","source":"# train, test, ,merchants, new_merchant_t, his_trans\ntrain.columns","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c1ecdf3aec7ad5e06c54412413c7ba2f0269239d"},"cell_type":"code","source":"test.columns","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"92a7c033a123856986325865730d35fd610a42f8"},"cell_type":"code","source":"merchants.columns","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"scrolled":true,"_uuid":"fa2c0188c1bc6cc94a5cbae88d0b8137fa1cfc02"},"cell_type":"code","source":"new_merchant_t.columns","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d52e8add3015c260619b66033652f44d357052c2"},"cell_type":"code","source":"his_trans.columns","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.6","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}