{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"47f52464-517f-facc-6f3b-88e20dce114c"},"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\ntrain=pd.read_csv('../input/clicks_train.csv')\ntrain.head()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"431cd4c6-2b7f-21f4-857d-b1df1d2a35f2"},"outputs":[],"source":"pro=pd.read_csv('../input/promoted_content.csv')\npro.head()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"e62fe247-3f01-55ce-5fff-c064804add47"},"outputs":[],"source":"mergeddf=pd.merge(train,pro,how=\"inner\",by=\"ad_id\")\nmergedf.head()"}],"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}