{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "![alt text](http://library.columbia.edu/content/libraryweb/locations/business/_jcr_content/layout_featuredcontent/image.img.jpg/1369336790208.jpg)\n", "#What do we know about Density's data?" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import pandas as pd\n", "import datetime\n", "import seaborn as sns\n", "import pylab as plt\n", "import numpy as np\n", "import requests\n", "%matplotlib inline \n", "plt.rcParams.update({'font.size': 28})\n", "sns.set_context(\"talk\")\n", "sns.set_style('darkgrid')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##[CUIT](https://cuit.columbia.edu/) has supplied us with our data set\n", "\n", "###We receive device counts from specific routers aggregated into 15 minute intervals\n", "\n", "Devices connect to wifi routers across Columbia's campus. CUIT aggregates device collection data by building and by floor and supplies with a live count of the number of devices connected at each location every 15 minutes.\n", "\n", "Below is an example query from the API showing how data is shared publicly" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | client_count | \n", "group_id | \n", "group_name | \n", "parent_id | \n", "parent_name | \n", "percent_full | \n", "
---|---|---|---|---|---|---|
dump_time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2014-10-10 21:15:00 | \n", "3 | \n", "125 | \n", "John Jay Dining Hall | \n", "75 | \n", "John Jay | \n", "1.500000 | \n", "
2014-10-10 21:15:00 | \n", "4 | \n", "155 | \n", "JJ's Place | \n", "75 | \n", "John Jay | \n", "3.100775 | \n", "
2014-10-10 21:00:00 | \n", "1 | \n", "125 | \n", "John Jay Dining Hall | \n", "75 | \n", "John Jay | \n", "0.500000 | \n", "
2014-10-10 21:00:00 | \n", "2 | \n", "155 | \n", "JJ's Place | \n", "75 | \n", "John Jay | \n", "1.550388 | \n", "
2014-10-10 20:45:00 | \n", "8 | \n", "125 | \n", "John Jay Dining Hall | \n", "75 | \n", "John Jay | \n", "4.000000 | \n", "