{"cells":[
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\ndf_train = pd.read_csv('../input/train.csv')\ndf_test = pd.read_csv('../input/test.csv')"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "df_train.describe()\ndf_test.describe()"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "x = df_train[df_train.time < 20000]\ny = x[x.time > 10000]\ny['x'].plot.hist(bins=50)"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "ax = df_train[df_train.place_id == 8772469670].plot.scatter(x='time',y='y',c='red', s=0.1, figsize=(18,6))\ndf_train[df_train.place_id == 1623394281].plot.scatter(x='time',y='y',c='green', ax=ax,s=0.1)\ndf_train[df_train.place_id == 1308450003].plot.scatter(x='time',y='y',c='black', ax=ax,s=0.1)\ndf_train[df_train.place_id == 4823777529].plot.scatter(x='time',y='y',c='yellow', ax=ax,s=0.1)\ndf_train[df_train.place_id == 9586338177].plot.scatter(x='time',y='y',c='blue', ax=ax,s=0.1)\n"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "#df_train.groupby(['place_id']).agg(['count']).describe()\n#df_train.groupby(['place_id'])['place_id'].agg(['count']).sort(['count'], ascending=[0]).head(10)\ndf_train.groupby(['place_id'])['place_id'].agg(['count'])['count'].plot.hist(bins=300, xlim=(0,100))"
 },
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "df_train[df_train['place_id'].isin([5351837004]) ]['time'].apply(lambda x: x%(60*24)).plot.hist(bins = 24)"
 }
],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"}}, "nbformat": 4, "nbformat_minor": 0}