Tráfico de la página - Dia de semana vs. Horario y Mes vs. Día de semana.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "datos = pd.read_csv('events.csv')\n",
    "datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['timestamp'] = pd.to_datetime(data['timestamp'])\n",
    "data['hour'] = data['timestamp'].dt.hour\n",
    "data['weekday_name'] = data['timestamp'].dt.weekday_name\n",
    "\n",
    "weekdays = [\"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\", \"Saturday\", \"Sunday\"]\n",
    "\n",
    "cross = pd.crosstab(data.hour, data.weekday_name)\n",
    "cross = cross.reindex(columns=weekdays)\n",
    "cross.head()\n",
    "\n",
    "g = sb.heatmap(cross,  cmap=\"YlGnBu\")\n",
    "g.set_title(\"Cantidad de tráfico por hora y día de semana\", fontsize=22)\n",
    "g.set_xlabel(\"Día de semana\",fontsize=16)\n",
    "g.set_ylabel(\"Horario\", fontsize=16)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data['month'] = data['timestamp'].dt.month\n",
    "\n",
    "cross = pd.crosstab(data.month, data.weekday_name)\n",
    "cross = cross.reindex(columns=weekdays)\n",
    "cross.head()\n",
    "\n",
    "g = sb.heatmap(cross,  cmap=\"YlGnBu\")\n",
    "g.set_title(\"Cantidad de tráfico por mes y día de semana\", fontsize=22)\n",
    "g.set_xlabel(\"Día de semana\",fontsize=16)\n",
    "g.set_ylabel(\"Mes\", fontsize=16)"
   ]
  }
 ],
 "metadata": {
  "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}