{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "_cell_guid": "ae0ffa26-219b-c218-63a4-65435a758944"
      },
      "source": [
        " 1.  ad_id:  Key to concat with the promoted_content.csv\n",
        " 2. display_id:  Key to concat with the events.csv"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3b814b5a-7e78-3bea-f80d-4e27161679b5"
      },
      "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",
        "\n",
        "import numpy as np # linear algebra\n",
        "import 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",
        "\n",
        "from subprocess import check_output\n",
        "print(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": "5d46ad13-c548-aee8-d74d-88ebccaa8daa"
      },
      "outputs": [],
      "source": [
        "df_click_test = pd.read_csv('../input/clicks_test.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "a3468e10-3498-1cce-ae6f-37848d377925"
      },
      "outputs": [],
      "source": [
        "df_click_test.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "5d36ff75-bfeb-09f9-85d4-62f277ec704b"
      },
      "outputs": [],
      "source": [
        "df_click_test.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "b9ebcab3-1025-1f2d-182b-7f297cae78b4"
      },
      "outputs": [],
      "source": [
        "del df_click_test"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "c300bf38-c8b4-e009-7270-08b2d9946c82"
      },
      "outputs": [],
      "source": [
        "df_click_train = pd.read_csv('../input/clicks_train.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "c9d5bad8-2e52-9f4d-a112-4ef71ab016a2"
      },
      "outputs": [],
      "source": [
        "df_click_train.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "429ac5ee-989c-a4ca-889a-c1d8ba929d4e"
      },
      "outputs": [],
      "source": [
        "df_click_train.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "f668e101-9795-83f7-2f22-47ca9406aa4b"
      },
      "outputs": [],
      "source": [
        "del df_click_train\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "11b972ad-348d-dee7-663b-97e36f7ea2d4"
      },
      "outputs": [],
      "source": [
        "df_documents_categories = pd.read_csv('../input/documents_categories.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "f449e969-2e4f-8137-d9e5-b99d578b6e13"
      },
      "outputs": [],
      "source": [
        "df_documents_categories.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "56ef944e-cd19-2bdd-efb3-17451077d166"
      },
      "outputs": [],
      "source": [
        "df_documents_categories.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "484806ca-235c-6087-eeee-de955935f5be"
      },
      "outputs": [],
      "source": [
        "df_documents_entities=pd.read_csv('../input/documents_entities.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "2121877b-2a64-31fe-cff7-2877ee4303ae"
      },
      "outputs": [],
      "source": [
        "df_documents_entities.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "1bda04e8-f6c7-d769-8434-ea79d27f9498"
      },
      "outputs": [],
      "source": [
        "df_documents_meta = pd.read_csv('../input/documents_meta.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "b60169f5-6abe-914b-372e-ed16b2963745"
      },
      "outputs": [],
      "source": [
        "df_documents_meta.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "e30ef9bc-392a-52ac-b4ed-b757cf55a70a"
      },
      "outputs": [],
      "source": [
        "df_documents_meta.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "20d407c0-f240-6c0f-3baf-092a8bc43e80"
      },
      "outputs": [],
      "source": [
        "df_documents_meta.describe()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "84ffc055-b0f0-61f0-dfe3-eae8e246fbd7"
      },
      "outputs": [],
      "source": [
        "del df_documents_categories\n",
        "del df_documents_meta"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "d6e062de-45fa-4b25-37f7-7f97ff154315"
      },
      "outputs": [],
      "source": [
        "df_documents_topics = pd.read_csv('../input/documents_topics.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "2e577910-21e4-da82-a671-393a960bd7da"
      },
      "outputs": [],
      "source": [
        "df_documents_topics.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "2b6a365d-ee54-6d89-5736-0137f27eaaa9"
      },
      "outputs": [],
      "source": [
        "df_documents_topics.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "0f5161e2-ad6c-2d76-eead-a8f0fea69540"
      },
      "outputs": [],
      "source": [
        "df_documents_topics.describe()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8183acfe-1d08-b579-dd0f-044edae6a171"
      },
      "outputs": [],
      "source": [
        "df_events = pd.read_csv('../input/events.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3f7d4afb-cfc8-5986-367c-1e81080c5dc0"
      },
      "outputs": [],
      "source": [
        "df_events.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "e32a26b6-7f91-917d-2cf8-72e736956ad7"
      },
      "outputs": [],
      "source": [
        "df_events.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3b1c954f-f66a-01f3-cab8-1a8581824f77"
      },
      "outputs": [],
      "source": [
        "df_events.describe()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "12c4bf84-c28d-09b8-61ff-3ca467890e94"
      },
      "outputs": [],
      "source": [
        "del df_events\n",
        "del df_documents_topics"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "32788657-9163-8a24-c7a1-22744fb6a1a4"
      },
      "outputs": [],
      "source": [
        "df_page_views_sample = pd.read_csv('../input/page_views_sample.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "b86b7951-5180-f94e-eb97-fa0246d3db95"
      },
      "outputs": [],
      "source": [
        "df_page_views_sample.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "58df5863-921e-a1d1-3a35-211649a640b7"
      },
      "outputs": [],
      "source": [
        "df_page_views_sample.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "2ee534f1-3cca-b4bb-c6ff-8d1ebb39c331"
      },
      "outputs": [],
      "source": [
        "del df_page_views_sample"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "37e0e822-8a05-59d1-6c7b-9b8f0aa748d9"
      },
      "outputs": [],
      "source": [
        "df_promoted_content = pd.read_csv('../input/promoted_content.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "6fed5753-ef97-10cc-8cd7-fe3c1b952ccd"
      },
      "outputs": [],
      "source": [
        "df_promoted_content.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "385d1911-22b2-0961-5289-0106982815ce"
      },
      "outputs": [],
      "source": [
        "df_promoted_content.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8191b73f-1a8c-d9d2-e728-cbdbc948df31"
      },
      "outputs": [],
      "source": [
        "df_sample_submission = pd.read_csv('../input/sample_submission.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "dd867e22-03ba-0933-3262-900b988012dc"
      },
      "outputs": [],
      "source": [
        "df_sample_submission.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "e7374dbf-caff-7678-c20a-2d1b5c67df57"
      },
      "outputs": [],
      "source": [
        "df_sample_submission.shape"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "_cell_guid": "15625ac3-54ec-1875-8281-2d159ed13e2d"
      },
      "source": [
        "#\n",
        " 1.  ad_id:  Key to concat with the promoted_content.csv\n",
        " 2. display_id:  Key to concat with the events.csv"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "4e0c1314-dd30-390d-eb0e-2fdb9e2f1a76"
      },
      "outputs": [],
      "source": ""
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "47b0fe7f-fb99-d1b0-efc0-af2e028e017f"
      },
      "outputs": [],
      "source": ""
    }
  ],
  "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
}