{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"156fa8ac-9278-f321-2e63-fe0ab04115bf"},"outputs":[],"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 in \n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the \"../input/\" directory.\n# For example, running this (by clicking run or pressing Shift+Enter) will list the files in the input directory\n\nfrom subprocess import check_output\nprint(check_output([\"ls\", \"../input\"]).decode(\"utf8\"))\n\n# Any results you write to the current directory are saved as output."},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"8c527950-df2e-864c-3216-7cf1beeb1e30"},"outputs":[],"source":"df_test = pd.read_csv('../input/clicks_test.csv')\ndf_ad = pd.read_csv('../input/promoted_content.csv',\n    usecols  = ('ad_id','document_id'),\n    dtype={'ad_id': np.int, 'uuid': np.str, 'document_id': np.str})\ndf_events = pd.read_csv('../input/events.csv',\n    usecols  = ('display_id','uuid','timestamp'),\n    dtype={'display_id': np.int, 'uuid': np.str, 'timestamp': np.int})\n"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"19da2bc8-9a8f-3eb7-7bff-c3455cc47f0e"},"outputs":[],"source":"df_events"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"95eb2547-105c-c321-adf3-3d16dd61ed69"},"outputs":[],"source":"df_test = pd.merge(df_test, df_ad, on='ad_id', how='left')"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"a2eb6683-5c92-01e7-9cc0-a38a703c4c64"},"outputs":[],"source":"df_test"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"e2244f35-0e7a-da88-b77a-f41e0ad72eb3"},"outputs":[],"source":"df_test = pd.merge(df_test, df_events, on='display_id', how='left')"}],"metadata":{"_change_revision":0,"_is_fork":false,"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.5.2"}},"nbformat":4,"nbformat_minor":0}