{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "9ddafffd-ee8f-43b2-153b-0cc4914329aa"
      },
      "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"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "846d0648-815c-d3e7-c85c-40de2ad8bb5a"
      },
      "outputs": [],
      "source": [
        "pvs = pd.read_csv('../input/page_views_sample.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "0b0b3799-1952-19cc-28ea-f9496dbf43b2"
      },
      "outputs": [],
      "source": [
        "pvs.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "7c9a1726-ef1b-3aff-06a6-c61aaffd67bc"
      },
      "outputs": [],
      "source": [
        "pvs.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "9c3bc29f-7e20-2ed4-b68e-43ffbeeb90f0"
      },
      "outputs": [],
      "source": [
        "pvs.document_id.value_counts(normalize=True).head(n=15)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "679c0551-7bee-c4a3-d1e4-5ae413d63a86"
      },
      "outputs": [],
      "source": [
        "len(pvs.document_id.unique()) / pvs.shape[0]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "d85f386c-d0b9-4526-3386-98b68fcfeadf"
      },
      "outputs": [],
      "source": [
        "len(pvs.document_id.unique())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "f064720a-8489-c31b-5cac-0b29b7263f7e"
      },
      "outputs": [],
      "source": [
        "docs = pvs.document_id.value_counts(normalize=True).head(n=100)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "54d38ab9-7f68-1e63-89f6-f5899e5fa3fa"
      },
      "outputs": [],
      "source": [
        "docs.hist()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "52871032-3b1a-3c72-4ffc-30cf0a779f48"
      },
      "outputs": [],
      "source": [
        "pvs.document_id.value_counts().tail(n=10)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "592637be-7e35-a5c2-5fff-782308b402fe"
      },
      "outputs": [],
      "source": [
        "vc = pvs.document_id.value_counts()\n",
        "len(vc == 1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "52391f45-cda2-b0c1-b108-03a0a72001f1"
      },
      "outputs": [],
      "source": [
        "len(vc[vc == 1])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "70252780-5f47-361c-ba83-3d6346fcd6e8"
      },
      "outputs": [],
      "source": [
        "len(vc[vc < 10])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "e45e3932-9d76-94e8-0da8-cbf8133368e9"
      },
      "outputs": [],
      "source": ""
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "_cell_guid": "8d1cd96c-f46f-fbda-f657-63ec5322162a"
      },
      "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
}