{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"fb57beaa-140f-5c10-fcda-56454648db50"},"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\npromoted_content = pd.read_csv('../input/promoted_content.csv')\n\n# Any results you write to the current directory are saved as output."},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"c9a6457e-d567-5f54-3d61-d7e2dce3266b"},"outputs":[],"source":"promoted_content.columns"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"847e57e9-2caa-596c-c3e2-269855393aeb"},"outputs":[],"source":"advs = promoted_content['advertiser_id'].unique()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"3b7030ba-402c-41b2-41bd-01f38a12187b"},"outputs":[],"source":"len(advs)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"70ad6288-6830-4718-7391-0a9fa16c7491"},"outputs":[],"source":"pc = promoted_content"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"d2ed7841-3d42-cb38-ef39-cb9932420c0a"},"outputs":[],"source":"clks = pd.read_csv('../input/clicks_train.csv')\n\nlen(clks)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"b938b278-51df-f26a-51e5-f39aa9073627"},"outputs":[],"source":"uadi = clks['ad_id'].unique()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"78ed8634-35cb-62b2-daa6-63dd6e8617a4"},"outputs":[],"source":"len(uadi)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"981a54c4-7ee1-4b47-9467-d8c54f1379a4"},"outputs":[],"source":"len(pc)"}],"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}