{"cells":[{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"cd0d40a6-ea78-6be9-64a4-57c84526518d"},"outputs":[],"source":"import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"9db17d55-a729-5d33-0cf1-45936d438348"},"outputs":[],"source":"clicks = pd.read_csv('../input/clicks_train.csv')\nprint(clicks.shape)\nprint(clicks.head())"},{"cell_type":"markdown","metadata":{"_cell_guid":"c1dd496e-b03f-67a1-8fd0-669aa913217c"},"source":"How many unique display_id's are there?"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"4407686e-b817-9c2a-cee1-4b49da58d777"},"outputs":[],"source":"len(clicks.display_id.unique()) / clicks.shape[0]"},{"cell_type":"markdown","metadata":{"_cell_guid":"4aae59ce-f18a-3a4f-cc63-e1d57b98d7fc"},"source":"Are all of the ad_id's unique?"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"692c10ff-6373-faa7-921d-bb3df22a0808"},"outputs":[],"source":"len(clicks.ad_id.unique()) / clicks.shape[0]"},{"cell_type":"markdown","metadata":{"_cell_guid":"e7c73266-3d03-8e27-4092-0560fe470b70"},"source":"Nope, quite the opposite. The ad_id is repeated a lot"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"ea265de1-df3d-d70d-29f2-c0ed0d42505e"},"outputs":[],"source":"events = pd.read_csv('../input/events.csv')\nprint(events.shape)"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"5a1a874e-1205-475f-6db5-2620a9b7f699"},"outputs":[],"source":"events.head()"},{"cell_type":"code","execution_count":null,"metadata":{"_cell_guid":"147f14c5-5677-bca5-0bad-beab4709d09c"},"outputs":[],"source":"events.dtypes"}],"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}