{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "a0cfc56e-d453-6878-c0b4-a0c89d989c4f"
      },
      "outputs": [],
      "source": [
        "import numpy as np # linear algebra\n",
        "import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n",
        "from sklearn import tree\n",
        "# Input data files are available in the \"../input/\" directory.\n",
        "\n",
        "from subprocess import check_output\n",
        "print(check_output([\"ls\", \"../input\"]).decode(\"utf8\"))\n",
        "\n",
        "#train = pd.read_csv('../input/train.csv')\n",
        "#train_target = train['label']\n",
        "#train_features = train.ix[:,'pixel0':]\n",
        "\n",
        "clicks_train = pd.read_csv('../input/clicks_train.csv')\n",
        "docs_categories = pd.read_csv('../input/documents_categories.csv')\n",
        "docs_entities = pd.read_csv('../input/documents_entities.csv', nrows=5000)\n",
        "docs_meta = pd.read_csv('../input/documents_meta.csv', nrows=5000)\n",
        "docs_topics = pd.read_csv('../input/documents_topics.csv', nrows=5000)\n",
        "events = pd.read_csv('../input/events.csv', nrows=5000)\n",
        "page_views = pd.read_csv('../input/page_views_sample.csv', nrows=5000)\n",
        "promoted_content = pd.read_csv('../input/promoted_content.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "555b21f9-47af-8ca9-bd9b-9b535a8d5abf"
      },
      "outputs": [],
      "source": [
        "print('CLICKS')\n",
        "clicks_train.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "765b49b0-bebe-9aab-7d18-6ac102405abc"
      },
      "outputs": [],
      "source": [
        "print('DOC CATEGORY')\n",
        "docs_categories.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8a807fe2-c233-4888-d27a-5599ac62f266"
      },
      "outputs": [],
      "source": [
        "print('DOC ENTITY')\n",
        "docs_entities.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "34a57195-97ed-9c4b-db75-3d573fe5e4c7"
      },
      "outputs": [],
      "source": [
        "print('DOC META')\n",
        "docs_meta.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "3ff8441d-88da-0d3b-6a88-bc0a943ee41d"
      },
      "outputs": [],
      "source": [
        "print('DOC TOPIC')\n",
        "docs_topics.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "d03c8397-e90b-bbf5-aa38-8052d6dde552"
      },
      "outputs": [],
      "source": [
        "print('EVENT')\n",
        "events.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "6f931b19-8cd1-efd1-b327-7cc95fbb4447"
      },
      "outputs": [],
      "source": [
        "print('PAGE VIEW')\n",
        "page_views.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "6e386389-bcda-2f22-c088-561a1c86e13c"
      },
      "outputs": [],
      "source": [
        "print('PROMOTED CONTENT')\n",
        "promoted_content.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "93296fb3-c765-7beb-efc2-3878417092e3"
      },
      "outputs": [],
      "source": [
        "new = promoted_content.join(clicks_train, on='ad_id', rsuffix=2)\n",
        "new = new.join(docs_categories, on='document_id', rsuffix=2)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8fc0a022-4a47-4a9e-b906-44f725b413d3"
      },
      "outputs": [],
      "source": [
        "new.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "686bde4d-0c07-ea75-42f0-a6fa7fcf491b"
      },
      "outputs": [],
      "source": [
        "new.count"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "55d5e92f-7e75-5191-ef6f-1a22811219f4"
      },
      "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
}