{"cells":[
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "# if timestamp represents minutes"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "%matplotlib inline\n\nimport numpy as np\nimport pandas as pd\nimport matplotlib.pyplot as plt\n\ntypes = {'row_id': np.dtype(int),\n         'x': np.dtype(float),\n         'y' : np.dtype(float),\n         'accuracy': np.dtype(int),\n         'place_id': np.dtype(int) }\n\ntrain = pd.read_csv('../input/train.csv', dtype=types, index_col=0)\n#test = pd.read_csv('../input/test.csv', dtype=types, index_col=0)"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "def add_data(df):\n    df['hour'] = df.time//60%24\n    df['day'] = df.time//60//24\n    df['weekday'] = df.time//60//24%7\n\nadd_data(train)"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "# hourly\n\nplace_hourly = train.groupby(['place_id', 'hour']).size().unstack()"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "place_hourly.head(5)"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "fig, axes = plt.subplots(nrows=3, ncols=1, figsize=(8,5))\nplace_hourly.ix[1000015801].plot.bar(ax=axes[0])\nplace_hourly.ix[1000025138].plot.bar(ax=axes[1])\nplace_hourly.ix[1000063498].plot.bar(ax=axes[2])"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "# weekday\n\nplace_weekly = train.groupby(['place_id', 'weekday']).size().unstack()\nfig, axes = plt.subplots(nrows=3, ncols=1, figsize=(8,5))\nplace_weekly.ix[1000015801].plot.bar(ax=axes[0])\nplace_weekly.ix[1000025138].plot.bar(ax=axes[1])\nplace_weekly.ix[1000063498].plot.bar(ax=axes[2])"
 }
],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"}}, "nbformat": 4, "nbformat_minor": 0}