Skip to content

Instantly share code, notes, and snippets.

@errows

errows/gist:10309707

Created April 9, 2014 20:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save errows/10309707 to your computer and use it in GitHub Desktop.
Save errows/10309707 to your computer and use it in GitHub Desktop.
Download ZIP
Divvy experimentation during Pycon 2014 in Montreal
Raw
gistfile1.txt
{
"metadata": {
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"import numpy as np\n",
"import collections\n",
"\n",
"data = pd.read_csv('Divvy_Trips_2013.csv')\n",
"data.head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>trip_id</th>\n",
" <th>starttime</th>\n",
" <th>stoptime</th>\n",
" <th>bikeid</th>\n",
" <th>tripduration</th>\n",
" <th>from_station_id</th>\n",
" <th>from_station_name</th>\n",
" <th>to_station_id</th>\n",
" <th>to_station_name</th>\n",
" <th>usertype</th>\n",
" <th>gender</th>\n",
" <th>birthday</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> 4118</td>\n",
" <td> 2013-06-27 12:11</td>\n",
" <td> 2013-06-27 12:16</td>\n",
" <td> 480</td>\n",
" <td> 316</td>\n",
" <td> 85</td>\n",
" <td> Michigan Ave &amp; Oak St</td>\n",
" <td> 28</td>\n",
" <td> Larrabee St &amp; Menomonee St</td>\n",
" <td> Customer</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> 4275</td>\n",
" <td> 2013-06-27 14:44</td>\n",
" <td> 2013-06-27 14:45</td>\n",
" <td> 77</td>\n",
" <td> 64</td>\n",
" <td> 32</td>\n",
" <td> Racine Ave &amp; Congress Pkwy</td>\n",
" <td> 32</td>\n",
" <td> Racine Ave &amp; Congress Pkwy</td>\n",
" <td> Customer</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> 4291</td>\n",
" <td> 2013-06-27 14:58</td>\n",
" <td> 2013-06-27 15:05</td>\n",
" <td> 77</td>\n",
" <td> 433</td>\n",
" <td> 32</td>\n",
" <td> Racine Ave &amp; Congress Pkwy</td>\n",
" <td> 19</td>\n",
" <td> Loomis St &amp; Taylor St</td>\n",
" <td> Customer</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td> 4316</td>\n",
" <td> 2013-06-27 15:06</td>\n",
" <td> 2013-06-27 15:09</td>\n",
" <td> 77</td>\n",
" <td> 123</td>\n",
" <td> 19</td>\n",
" <td> Loomis St &amp; Taylor St</td>\n",
" <td> 19</td>\n",
" <td> Loomis St &amp; Taylor St</td>\n",
" <td> Customer</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td> 4342</td>\n",
" <td> 2013-06-27 15:13</td>\n",
" <td> 2013-06-27 15:27</td>\n",
" <td> 77</td>\n",
" <td> 852</td>\n",
" <td> 19</td>\n",
" <td> Loomis St &amp; Taylor St</td>\n",
" <td> 55</td>\n",
" <td> Halsted St &amp; James M Rochford St</td>\n",
" <td> Customer</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows \u00d7 12 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 88,
"text": [
" trip_id starttime stoptime bikeid tripduration \\\n",
"0 4118 2013-06-27 12:11 2013-06-27 12:16 480 316 \n",
"1 4275 2013-06-27 14:44 2013-06-27 14:45 77 64 \n",
"2 4291 2013-06-27 14:58 2013-06-27 15:05 77 433 \n",
"3 4316 2013-06-27 15:06 2013-06-27 15:09 77 123 \n",
"4 4342 2013-06-27 15:13 2013-06-27 15:27 77 852 \n",
"\n",
" from_station_id from_station_name to_station_id \\\n",
"0 85 Michigan Ave & Oak St 28 \n",
"1 32 Racine Ave & Congress Pkwy 32 \n",
"2 32 Racine Ave & Congress Pkwy 19 \n",
"3 19 Loomis St & Taylor St 19 \n",
"4 19 Loomis St & Taylor St 55 \n",
"\n",
" to_station_name usertype gender birthday \n",
"0 Larrabee St & Menomonee St Customer NaN NaN \n",
"1 Racine Ave & Congress Pkwy Customer NaN NaN \n",
"2 Loomis St & Taylor St Customer NaN NaN \n",
"3 Loomis St & Taylor St Customer NaN NaN \n",
"4 Halsted St & James M Rochford St Customer NaN NaN \n",
"\n",
"[5 rows x 12 columns]"
]
}
],
"prompt_number": 88
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#Questions we'd like to answer\n",
"##Identify most frequently used bikes\n",
"###Sum the trip durations for each bike id\n",
"##Identify least popular stations\n",
"###Count the number of arrivals and departures for each station\n",
"\n",
"##Fill least popular stations with most popular bikes\n",
"###Merge stations_pop with station capacity\n",
"###Loop through the stations\n",
"\n",
"##Identify last station for each bike\n",
"###Create a collection of bikeid and last to_station_id\n"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"sums = data[['bikeid', 'tripduration']].groupby('bikeid').aggregate(np.sum)\n",
"sorted = sums.sort('tripduration', ascending=False)\n",
"sorted"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>tripduration</th>\n",
" </tr>\n",
" <tr>\n",
" <th>bikeid</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>199</th>\n",
" <td> 819017</td>\n",
" </tr>\n",
" <tr>\n",
" <th>682</th>\n",
" <td> 818411</td>\n",
" </tr>\n",
" <tr>\n",
" <th>520</th>\n",
" <td> 806751</td>\n",
" </tr>\n",
" <tr>\n",
" <th>905</th>\n",
" <td> 802907</td>\n",
" </tr>\n",
" <tr>\n",
" <th>321</th>\n",
" <td> 799946</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td> 797796</td>\n",
" </tr>\n",
" <tr>\n",
" <th>189</th>\n",
" <td> 782346</td>\n",
" </tr>\n",
" <tr>\n",
" <th>416</th>\n",
" <td> 780118</td>\n",
" </tr>\n",
" <tr>\n",
" <th>755</th>\n",
" <td> 768277</td>\n",
" </tr>\n",
" <tr>\n",
" <th>448</th>\n",
" <td> 761110</td>\n",
" </tr>\n",
" <tr>\n",
" <th>661</th>\n",
" <td> 757963</td>\n",
" </tr>\n",
" <tr>\n",
" <th>572</th>\n",
" <td> 756885</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53 </th>\n",
" <td> 754477</td>\n",
" </tr>\n",
" <tr>\n",
" <th>872</th>\n",
" <td> 754297</td>\n",
" </tr>\n",
" <tr>\n",
" <th>141</th>\n",
" <td> 754191</td>\n",
" </tr>\n",
" <tr>\n",
" <th>743</th>\n",
" <td> 753693</td>\n",
" </tr>\n",
" <tr>\n",
" <th>383</th>\n",
" <td> 751342</td>\n",
" </tr>\n",
" <tr>\n",
" <th>446</th>\n",
" <td> 743649</td>\n",
" </tr>\n",
" <tr>\n",
" <th>148</th>\n",
" <td> 742350</td>\n",
" </tr>\n",
" <tr>\n",
" <th>284</th>\n",
" <td> 739552</td>\n",
" </tr>\n",
" <tr>\n",
" <th>887</th>\n",
" <td> 737254</td>\n",
" </tr>\n",
" <tr>\n",
" <th>735</th>\n",
" <td> 735084</td>\n",
" </tr>\n",
" <tr>\n",
" <th>206</th>\n",
" <td> 734047</td>\n",
" </tr>\n",
" <tr>\n",
" <th>140</th>\n",
" <td> 730132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>599</th>\n",
" <td> 729621</td>\n",
" </tr>\n",
" <tr>\n",
" <th>338</th>\n",
" <td> 727098</td>\n",
" </tr>\n",
" <tr>\n",
" <th>561</th>\n",
" <td> 724224</td>\n",
" </tr>\n",
" <tr>\n",
" <th>768</th>\n",
" <td> 722377</td>\n",
" </tr>\n",
" <tr>\n",
" <th>633</th>\n",
" <td> 721693</td>\n",
" </tr>\n",
" <tr>\n",
" <th>461</th>\n",
" <td> 719209</td>\n",
" </tr>\n",
" <tr>\n",
" <th>491</th>\n",
" <td> 716825</td>\n",
" </tr>\n",
" <tr>\n",
" <th>258</th>\n",
" <td> 716382</td>\n",
" </tr>\n",
" <tr>\n",
" <th>476</th>\n",
" <td> 714461</td>\n",
" </tr>\n",
" <tr>\n",
" <th>654</th>\n",
" <td> 714158</td>\n",
" </tr>\n",
" <tr>\n",
" <th>475</th>\n",
" <td> 713094</td>\n",
" </tr>\n",
" <tr>\n",
" <th>712</th>\n",
" <td> 711371</td>\n",
" </tr>\n",
" <tr>\n",
" <th>611</th>\n",
" <td> 708408</td>\n",
" </tr>\n",
" <tr>\n",
" <th>565</th>\n",
" <td> 707360</td>\n",
" </tr>\n",
" <tr>\n",
" <th>570</th>\n",
" <td> 707049</td>\n",
" </tr>\n",
" <tr>\n",
" <th>163</th>\n",
" <td> 706964</td>\n",
" </tr>\n",
" <tr>\n",
" <th>880</th>\n",
" <td> 706181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>752</th>\n",
" <td> 706021</td>\n",
" </tr>\n",
" <tr>\n",
" <th>296</th>\n",
" <td> 704734</td>\n",
" </tr>\n",
" <tr>\n",
" <th>473</th>\n",
" <td> 703437</td>\n",
" </tr>\n",
" <tr>\n",
" <th>294</th>\n",
" <td> 700685</td>\n",
" </tr>\n",
" <tr>\n",
" <th>888</th>\n",
" <td> 699282</td>\n",
" </tr>\n",
" <tr>\n",
" <th>151</th>\n",
" <td> 699203</td>\n",
" </tr>\n",
" <tr>\n",
" <th>463</th>\n",
" <td> 698924</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43 </th>\n",
" <td> 698067</td>\n",
" </tr>\n",
" <tr>\n",
" <th>744</th>\n",
" <td> 697814</td>\n",
" </tr>\n",
" <tr>\n",
" <th>512</th>\n",
" <td> 696815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68 </th>\n",
" <td> 695827</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50 </th>\n",
" <td> 694619</td>\n",
" </tr>\n",
" <tr>\n",
" <th>914</th>\n",
" <td> 693615</td>\n",
" </tr>\n",
" <tr>\n",
" <th>339</th>\n",
" <td> 693128</td>\n",
" </tr>\n",
" <tr>\n",
" <th>722</th>\n",
" <td> 692307</td>\n",
" </tr>\n",
" <tr>\n",
" <th>311</th>\n",
" <td> 691469</td>\n",
" </tr>\n",
" <tr>\n",
" <th>597</th>\n",
" <td> 690850</td>\n",
" </tr>\n",
" <tr>\n",
" <th>300</th>\n",
" <td> 688733</td>\n",
" </tr>\n",
" <tr>\n",
" <th>433</th>\n",
" <td> 687669</td>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <td>...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>2887 rows \u00d7 1 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 89,
"text": [
" tripduration\n",
"bikeid \n",
"199 819017\n",
"682 818411\n",
"520 806751\n",
"905 802907\n",
"321 799946\n",
"244 797796\n",
"189 782346\n",
"416 780118\n",
"755 768277\n",
"448 761110\n",
"661 757963\n",
"572 756885\n",
"53 754477\n",
"872 754297\n",
"141 754191\n",
"743 753693\n",
"383 751342\n",
"446 743649\n",
"148 742350\n",
"284 739552\n",
"887 737254\n",
"735 735084\n",
"206 734047\n",
"140 730132\n",
"599 729621\n",
"338 727098\n",
"561 724224\n",
"768 722377\n",
"633 721693\n",
"461 719209\n",
"491 716825\n",
"258 716382\n",
"476 714461\n",
"654 714158\n",
"475 713094\n",
"712 711371\n",
"611 708408\n",
"565 707360\n",
"570 707049\n",
"163 706964\n",
"880 706181\n",
"752 706021\n",
"296 704734\n",
"473 703437\n",
"294 700685\n",
"888 699282\n",
"151 699203\n",
"463 698924\n",
"43 698067\n",
"744 697814\n",
"512 696815\n",
"68 695827\n",
"50 694619\n",
"914 693615\n",
"339 693128\n",
"722 692307\n",
"311 691469\n",
"597 690850\n",
"300 688733\n",
"433 687669\n",
" ...\n",
"\n",
"[2887 rows x 1 columns]"
]
}
],
"prompt_number": 89
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from_id = data[['from_station_id']].groupby('from_station_id')\n",
"from_id_sum = from_id.count()\n",
"from_id_sum\n",
"from_id_sum.index.name = 'station_id'\n",
"from_id_sum"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>from_station_id</th>\n",
" </tr>\n",
" <tr>\n",
" <th>station_id</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 5030</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> 3705</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> 1521</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> 1689</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 1737</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> 2750</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> 1845</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 2747</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> 2774</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> 2215</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> 2007</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> 6870</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> 8487</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> 10847</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 1420</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> 2078</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 2672</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> 2082</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> 5200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> 1851</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> 5983</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> 6182</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> 16710</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> 9784</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> 8112</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> 1815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> 8629</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> 6879</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> 6474</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 3288</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> 7930</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> 6354</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> 7989</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 5055</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> 7280</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> 10760</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> 5918</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> 2561</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> 1804</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> 5879</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> 2329</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> 3752</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td> 8059</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td> 4054</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td> 2604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td> 4065</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td> 6327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td> 5962</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td> 2249</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td> 5401</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td> 3043</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td> 2846</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td> 4285</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td> 5977</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td> 10141</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td> 15673</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td> 8327</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td> 4175</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td> 8810</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td> 2238</td>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <td>...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>300 rows \u00d7 1 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 90,
"text": [
" from_station_id\n",
"station_id \n",
"5 5030\n",
"13 3705\n",
"14 1521\n",
"15 1689\n",
"16 1737\n",
"17 2750\n",
"19 1845\n",
"20 2747\n",
"21 2774\n",
"22 2215\n",
"23 2007\n",
"24 6870\n",
"25 8487\n",
"26 10847\n",
"27 1420\n",
"28 2078\n",
"29 2672\n",
"30 2082\n",
"31 5200\n",
"32 1851\n",
"33 5983\n",
"34 6182\n",
"35 16710\n",
"36 9784\n",
"37 8112\n",
"42 1815\n",
"43 8629\n",
"44 6879\n",
"45 6474\n",
"46 3288\n",
"47 7930\n",
"48 6354\n",
"49 7989\n",
"50 5055\n",
"51 7280\n",
"52 10760\n",
"53 5918\n",
"54 2561\n",
"55 1804\n",
"56 5879\n",
"57 2329\n",
"58 3752\n",
"59 8059\n",
"60 4054\n",
"61 2604\n",
"62 4065\n",
"66 6327\n",
"67 5962\n",
"68 2249\n",
"69 5401\n",
"71 3043\n",
"72 2846\n",
"73 4285\n",
"74 5977\n",
"75 10141\n",
"76 15673\n",
"77 8327\n",
"80 4175\n",
"81 8810\n",
"84 2238\n",
" ...\n",
"\n",
"[300 rows x 1 columns]"
]
}
],
"prompt_number": 90
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"to_id = data[['to_station_id']].groupby('to_station_id')\n",
"to_id_sum = to_id.count()\n",
"to_id_sum.index.name = 'station_id'\n",
"to_id_sum"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>to_station_id</th>\n",
" </tr>\n",
" <tr>\n",
" <th>station_id</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 5116</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> 4291</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> 1448</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> 1652</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 1627</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> 2894</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> 1902</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 3027</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> 2574</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> 2296</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> 2022</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> 6985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> 8632</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> 11528</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 1485</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> 2100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 2773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> 2040</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> 5076</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> 1610</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> 5823</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> 6593</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> 18544</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> 9189</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> 7214</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> 1811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> 8102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> 6298</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> 6425</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 2934</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> 8571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> 6443</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> 7232</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 4878</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> 7009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> 10463</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> 5604</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> 2566</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> 1681</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> 5539</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> 2705</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> 3445</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td> 8637</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td> 4248</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td> 2869</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td> 3878</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td> 5981</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td> 6078</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td> 2063</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td> 6163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td> 2917</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td> 3163</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td> 3785</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td> 5552</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td> 10114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td> 15457</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td> 8142</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td> 4522</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td> 7995</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td> 2127</td>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <td>...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>300 rows \u00d7 1 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 91,
"text": [
" to_station_id\n",
"station_id \n",
"5 5116\n",
"13 4291\n",
"14 1448\n",
"15 1652\n",
"16 1627\n",
"17 2894\n",
"19 1902\n",
"20 3027\n",
"21 2574\n",
"22 2296\n",
"23 2022\n",
"24 6985\n",
"25 8632\n",
"26 11528\n",
"27 1485\n",
"28 2100\n",
"29 2773\n",
"30 2040\n",
"31 5076\n",
"32 1610\n",
"33 5823\n",
"34 6593\n",
"35 18544\n",
"36 9189\n",
"37 7214\n",
"42 1811\n",
"43 8102\n",
"44 6298\n",
"45 6425\n",
"46 2934\n",
"47 8571\n",
"48 6443\n",
"49 7232\n",
"50 4878\n",
"51 7009\n",
"52 10463\n",
"53 5604\n",
"54 2566\n",
"55 1681\n",
"56 5539\n",
"57 2705\n",
"58 3445\n",
"59 8637\n",
"60 4248\n",
"61 2869\n",
"62 3878\n",
"66 5981\n",
"67 6078\n",
"68 2063\n",
"69 6163\n",
"71 2917\n",
"72 3163\n",
"73 3785\n",
"74 5552\n",
"75 10114\n",
"76 15457\n",
"77 8142\n",
"80 4522\n",
"81 7995\n",
"84 2127\n",
" ...\n",
"\n",
"[300 rows x 1 columns]"
]
}
],
"prompt_number": 91
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"stations = collections.defaultdict(collections.Counter)\n",
"# for row in data.iterrows():\n",
"# stations[row[1]['from_station_id']][\"count\"] +=1\n",
"# stations[row[1]['to_station_id']][\"count\"] +=1\n",
" \n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 118
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"frame = pd.DataFrame(stations)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 110
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"least_pop_stations = frame.T\n",
"least_pop_stations.sort('count').head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>count</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>335</th>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>336</th>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>281</th>\n",
" <td> 89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td> 120</td>\n",
" </tr>\n",
" <tr>\n",
" <th>262</th>\n",
" <td> 194</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows \u00d7 1 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 117,
"text": [
" count\n",
"335 66\n",
"336 66\n",
"281 89\n",
"271 120\n",
"262 194\n",
"\n",
"[5 rows x 1 columns]"
]
}
],
"prompt_number": 117
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data2 = pd.read_csv('Divvy_Stations_2013.csv')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 119
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"least_pop_stations.index.name = 'id'\n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 123
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# least_pop_stations\n",
"data2 = data2.set_index('id')\n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 129
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data2['count'] = least_pop_stations['count']"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 130
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"data2"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>name</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>dpcapacity</th>\n",
" <th>landmark</th>\n",
" <th>online date</th>\n",
" <th>count</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> State St &amp; Harrison St</td>\n",
" <td> 41.873958</td>\n",
" <td>-87.627739</td>\n",
" <td> 19</td>\n",
" <td> 30</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 10146</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> Wilton Ave &amp; Diversey Pkwy</td>\n",
" <td> 41.932500</td>\n",
" <td>-87.652681</td>\n",
" <td> 19</td>\n",
" <td> 66</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 7996</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> Morgan St &amp; 18th St</td>\n",
" <td> 41.858086</td>\n",
" <td>-87.651073</td>\n",
" <td> 15</td>\n",
" <td> 163</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 2969</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> Racine Ave &amp; 18th St</td>\n",
" <td> 41.858181</td>\n",
" <td>-87.656487</td>\n",
" <td> 15</td>\n",
" <td> 164</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 3341</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> Wood St &amp; North Ave</td>\n",
" <td> 41.910329</td>\n",
" <td>-87.672516</td>\n",
" <td> 15</td>\n",
" <td> 223</td>\n",
" <td> 8/12/2013</td>\n",
" <td> 3364</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> Wood St &amp; Division St</td>\n",
" <td> 41.903320</td>\n",
" <td>-87.672730</td>\n",
" <td> 15</td>\n",
" <td> 246</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5644</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> Loomis St &amp; Taylor St</td>\n",
" <td> 41.869417</td>\n",
" <td>-87.660996</td>\n",
" <td> 15</td>\n",
" <td> 139</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 3747</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> Sheffield Ave &amp; Kingsbury St</td>\n",
" <td> 41.909592</td>\n",
" <td>-87.653497</td>\n",
" <td> 15</td>\n",
" <td> 154</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5774</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> Aberdeen St &amp; Jackson Blvd</td>\n",
" <td> 41.877726</td>\n",
" <td>-87.654787</td>\n",
" <td> 15</td>\n",
" <td> 157</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5348</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> May St &amp; Taylor St</td>\n",
" <td> 41.869482</td>\n",
" <td>-87.655486</td>\n",
" <td> 15</td>\n",
" <td> 160</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4511</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> Orleans St &amp; Elm St</td>\n",
" <td> 41.902924</td>\n",
" <td>-87.637715</td>\n",
" <td> 15</td>\n",
" <td> 172</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4029</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> Fairbanks Ct &amp; Grand Ave</td>\n",
" <td> 41.891860</td>\n",
" <td>-87.620620</td>\n",
" <td> 15</td>\n",
" <td> 262</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 13855</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> Michigan Ave &amp; Pearson St</td>\n",
" <td> 41.897660</td>\n",
" <td>-87.623510</td>\n",
" <td> 23</td>\n",
" <td> 34</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 17119</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> McClurg Ct &amp; Illinois St</td>\n",
" <td> 41.891020</td>\n",
" <td>-87.617300</td>\n",
" <td> 23</td>\n",
" <td> 51</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 22375</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> Larrabee St &amp; North Ave</td>\n",
" <td> 41.910210</td>\n",
" <td>-87.643500</td>\n",
" <td> 19</td>\n",
" <td> 174</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 2905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> Larrabee St &amp; Menomonee St</td>\n",
" <td> 41.914680</td>\n",
" <td>-87.643320</td>\n",
" <td> 15</td>\n",
" <td> 282</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4178</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> Noble St &amp; Milwaukee Ave</td>\n",
" <td> 41.900680</td>\n",
" <td>-87.662600</td>\n",
" <td> 15</td>\n",
" <td> 290</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5445</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> Ashland Ave &amp; Augusta Blvd</td>\n",
" <td> 41.899643</td>\n",
" <td>-87.667700</td>\n",
" <td> 15</td>\n",
" <td> 248</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4122</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> Franklin St &amp; Chicago Ave</td>\n",
" <td> 41.896802</td>\n",
" <td>-87.635638</td>\n",
" <td> 23</td>\n",
" <td> 17</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 10276</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> Racine Ave &amp; Congress Pkwy</td>\n",
" <td> 41.874640</td>\n",
" <td>-87.657030</td>\n",
" <td> 19</td>\n",
" <td> 76</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 3461</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> State St &amp; Van Buren St</td>\n",
" <td> 41.877181</td>\n",
" <td>-87.627844</td>\n",
" <td> 27</td>\n",
" <td> 3</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 11806</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> Cannon Dr &amp; Fullerton Ave</td>\n",
" <td> 41.926756</td>\n",
" <td>-87.634429</td>\n",
" <td> 15</td>\n",
" <td> 124</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 12775</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> Streeter Dr &amp; Illinois St</td>\n",
" <td> 41.891071</td>\n",
" <td>-87.612200</td>\n",
" <td> 35</td>\n",
" <td> 22</td>\n",
" <td> 8/5/2013</td>\n",
" <td> 35254</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> Franklin St &amp; Jackson Blvd</td>\n",
" <td> 41.877708</td>\n",
" <td>-87.635321</td>\n",
" <td> 27</td>\n",
" <td> 19</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 18973</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> Dearborn St &amp; Adams St</td>\n",
" <td> 41.879356</td>\n",
" <td>-87.629791</td>\n",
" <td> 19</td>\n",
" <td> 20</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 15326</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> Wabash Ave &amp; Cermak Rd</td>\n",
" <td> 41.853239</td>\n",
" <td>-87.625337</td>\n",
" <td> 15</td>\n",
" <td> 170</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 3626</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> Michigan Ave &amp; Washington St</td>\n",
" <td> 41.883893</td>\n",
" <td>-87.624649</td>\n",
" <td> 43</td>\n",
" <td> 1</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 16731</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> State St &amp; Randolph St</td>\n",
" <td> 41.884730</td>\n",
" <td>-87.627734</td>\n",
" <td> 27</td>\n",
" <td> 2</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 13177</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> Michigan Ave &amp; Congress Pkwy</td>\n",
" <td> 41.876066</td>\n",
" <td>-87.624433</td>\n",
" <td> 15</td>\n",
" <td> 40</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 12899</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> Wells St &amp; Walton St</td>\n",
" <td> 41.899930</td>\n",
" <td>-87.634430</td>\n",
" <td> 19</td>\n",
" <td> 46</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 6222</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> State St &amp; Kinzie St</td>\n",
" <td> 41.889180</td>\n",
" <td>-87.627700</td>\n",
" <td> 15</td>\n",
" <td> 50</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 16501</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> Larrabee St &amp; Kingsbury St</td>\n",
" <td> 41.897764</td>\n",
" <td>-87.642884</td>\n",
" <td> 27</td>\n",
" <td> 12</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 12797</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> Dearborn St &amp; Monroe St</td>\n",
" <td> 41.881320</td>\n",
" <td>-87.629521</td>\n",
" <td> 23</td>\n",
" <td> 49</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 15221</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> Clark St &amp; Congress Pkwy</td>\n",
" <td> 41.875933</td>\n",
" <td>-87.630585</td>\n",
" <td> 27</td>\n",
" <td> 9</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 9933</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> Clark St &amp; Randolph St</td>\n",
" <td> 41.884576</td>\n",
" <td>-87.631890</td>\n",
" <td> 31</td>\n",
" <td> 5</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 14289</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> Michigan Ave &amp; Lake St</td>\n",
" <td> 41.886058</td>\n",
" <td>-87.624289</td>\n",
" <td> 23</td>\n",
" <td> 43</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 21223</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> Wells St &amp; Erie St</td>\n",
" <td> 41.893832</td>\n",
" <td>-87.634195</td>\n",
" <td> 19</td>\n",
" <td> 64</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 11522</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> Ogden Ave &amp; Chicago Ave</td>\n",
" <td> 41.896362</td>\n",
" <td>-87.654061</td>\n",
" <td> 19</td>\n",
" <td> 44</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5127</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> Halsted St &amp; James M Rochford St</td>\n",
" <td> 41.865861</td>\n",
" <td>-87.646611</td>\n",
" <td> 15</td>\n",
" <td> 166</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 3485</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> Desplaines St &amp; Kinzie St</td>\n",
" <td> 41.888716</td>\n",
" <td>-87.644448</td>\n",
" <td> 19</td>\n",
" <td> 39</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 11418</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> Clinton St &amp; Roosevelt Rd</td>\n",
" <td> 41.867118</td>\n",
" <td>-87.641088</td>\n",
" <td> 15</td>\n",
" <td> 327</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5034</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> Ashland Ave &amp; Armitage Ave</td>\n",
" <td> 41.917859</td>\n",
" <td>-87.668919</td>\n",
" <td> 15</td>\n",
" <td> 25</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 7197</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td> Wabash Ave &amp; Roosevelt Rd</td>\n",
" <td> 41.867173</td>\n",
" <td>-87.625955</td>\n",
" <td> 19</td>\n",
" <td> 31</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 16696</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td> Dayton St &amp; North Ave</td>\n",
" <td> 41.910578</td>\n",
" <td>-87.649422</td>\n",
" <td> 19</td>\n",
" <td> 58</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 8302</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td> Wood St &amp; Milwaukee Ave</td>\n",
" <td> 41.907655</td>\n",
" <td>-87.672552</td>\n",
" <td> 15</td>\n",
" <td> 221</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5473</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td> McCormick Place</td>\n",
" <td> 41.851375</td>\n",
" <td>-87.618835</td>\n",
" <td> 15</td>\n",
" <td> 106</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 7943</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td> Clinton St &amp; Lake St</td>\n",
" <td> 41.885833</td>\n",
" <td>-87.641382</td>\n",
" <td> 19</td>\n",
" <td> 21</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 12308</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td> Sheffield Ave &amp; Fullerton Ave</td>\n",
" <td> 41.925602</td>\n",
" <td>-87.653708</td>\n",
" <td> 15</td>\n",
" <td> 60</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 12040</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td> Clinton St &amp; Tilden St</td>\n",
" <td> 41.875885</td>\n",
" <td>-87.640795</td>\n",
" <td> 23</td>\n",
" <td> 37</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4312</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td> Damen Ave &amp; Pierce Ave</td>\n",
" <td> 41.909396</td>\n",
" <td>-87.677692</td>\n",
" <td> 19</td>\n",
" <td> 65</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 11564</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td> Morgan St &amp; Lake St</td>\n",
" <td> 41.885483</td>\n",
" <td>-87.652305</td>\n",
" <td> 15</td>\n",
" <td> 72</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 5960</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td> State St &amp; 16th St</td>\n",
" <td> 41.860121</td>\n",
" <td>-87.627729</td>\n",
" <td> 15</td>\n",
" <td> 148</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 6009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td> Jefferson St &amp; Monroe St</td>\n",
" <td> 41.880422</td>\n",
" <td>-87.642746</td>\n",
" <td> 19</td>\n",
" <td> 38</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 8070</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td> Kingsbury St &amp; Erie St</td>\n",
" <td> 41.893843</td>\n",
" <td>-87.641851</td>\n",
" <td> 23</td>\n",
" <td> 265</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 11529</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td> Canal St &amp; Jackson Blvd</td>\n",
" <td> 41.878114</td>\n",
" <td>-87.639971</td>\n",
" <td> 35</td>\n",
" <td> 138</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 20255</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td> Lake Shore Dr &amp; Monroe St</td>\n",
" <td> 41.881050</td>\n",
" <td>-87.616970</td>\n",
" <td> 11</td>\n",
" <td> 300</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 31130</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td> Clinton St &amp; Madison St</td>\n",
" <td> 41.881582</td>\n",
" <td>-87.641277</td>\n",
" <td> 23</td>\n",
" <td> 301</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 16469</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td> Aberdeen St &amp; Madison St</td>\n",
" <td> 41.881487</td>\n",
" <td>-87.654752</td>\n",
" <td> 19</td>\n",
" <td> 156</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 8697</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td> Daley Center Plaza</td>\n",
" <td> 41.884337</td>\n",
" <td>-87.630183</td>\n",
" <td> 47</td>\n",
" <td> 23</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 16805</td>\n",
" </tr>\n",
" <tr>\n",
" <th>84</th>\n",
" <td> Green St &amp; Milwaukee Ave</td>\n",
" <td> 41.891733</td>\n",
" <td>-87.648727</td>\n",
" <td> 19</td>\n",
" <td> 33</td>\n",
" <td> 6/28/2013</td>\n",
" <td> 4365</td>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>300 rows \u00d7 7 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 131,
"text": [
" name latitude longitude dpcapacity \\\n",
"id \n",
"5 State St & Harrison St 41.873958 -87.627739 19 \n",
"13 Wilton Ave & Diversey Pkwy 41.932500 -87.652681 19 \n",
"14 Morgan St & 18th St 41.858086 -87.651073 15 \n",
"15 Racine Ave & 18th St 41.858181 -87.656487 15 \n",
"16 Wood St & North Ave 41.910329 -87.672516 15 \n",
"17 Wood St & Division St 41.903320 -87.672730 15 \n",
"19 Loomis St & Taylor St 41.869417 -87.660996 15 \n",
"20 Sheffield Ave & Kingsbury St 41.909592 -87.653497 15 \n",
"21 Aberdeen St & Jackson Blvd 41.877726 -87.654787 15 \n",
"22 May St & Taylor St 41.869482 -87.655486 15 \n",
"23 Orleans St & Elm St 41.902924 -87.637715 15 \n",
"24 Fairbanks Ct & Grand Ave 41.891860 -87.620620 15 \n",
"25 Michigan Ave & Pearson St 41.897660 -87.623510 23 \n",
"26 McClurg Ct & Illinois St 41.891020 -87.617300 23 \n",
"27 Larrabee St & North Ave 41.910210 -87.643500 19 \n",
"28 Larrabee St & Menomonee St 41.914680 -87.643320 15 \n",
"29 Noble St & Milwaukee Ave 41.900680 -87.662600 15 \n",
"30 Ashland Ave & Augusta Blvd 41.899643 -87.667700 15 \n",
"31 Franklin St & Chicago Ave 41.896802 -87.635638 23 \n",
"32 Racine Ave & Congress Pkwy 41.874640 -87.657030 19 \n",
"33 State St & Van Buren St 41.877181 -87.627844 27 \n",
"34 Cannon Dr & Fullerton Ave 41.926756 -87.634429 15 \n",
"35 Streeter Dr & Illinois St 41.891071 -87.612200 35 \n",
"36 Franklin St & Jackson Blvd 41.877708 -87.635321 27 \n",
"37 Dearborn St & Adams St 41.879356 -87.629791 19 \n",
"42 Wabash Ave & Cermak Rd 41.853239 -87.625337 15 \n",
"43 Michigan Ave & Washington St 41.883893 -87.624649 43 \n",
"44 State St & Randolph St 41.884730 -87.627734 27 \n",
"45 Michigan Ave & Congress Pkwy 41.876066 -87.624433 15 \n",
"46 Wells St & Walton St 41.899930 -87.634430 19 \n",
"47 State St & Kinzie St 41.889180 -87.627700 15 \n",
"48 Larrabee St & Kingsbury St 41.897764 -87.642884 27 \n",
"49 Dearborn St & Monroe St 41.881320 -87.629521 23 \n",
"50 Clark St & Congress Pkwy 41.875933 -87.630585 27 \n",
"51 Clark St & Randolph St 41.884576 -87.631890 31 \n",
"52 Michigan Ave & Lake St 41.886058 -87.624289 23 \n",
"53 Wells St & Erie St 41.893832 -87.634195 19 \n",
"54 Ogden Ave & Chicago Ave 41.896362 -87.654061 19 \n",
"55 Halsted St & James M Rochford St 41.865861 -87.646611 15 \n",
"56 Desplaines St & Kinzie St 41.888716 -87.644448 19 \n",
"57 Clinton St & Roosevelt Rd 41.867118 -87.641088 15 \n",
"58 Ashland Ave & Armitage Ave 41.917859 -87.668919 15 \n",
"59 Wabash Ave & Roosevelt Rd 41.867173 -87.625955 19 \n",
"60 Dayton St & North Ave 41.910578 -87.649422 19 \n",
"61 Wood St & Milwaukee Ave 41.907655 -87.672552 15 \n",
"62 McCormick Place 41.851375 -87.618835 15 \n",
"66 Clinton St & Lake St 41.885833 -87.641382 19 \n",
"67 Sheffield Ave & Fullerton Ave 41.925602 -87.653708 15 \n",
"68 Clinton St & Tilden St 41.875885 -87.640795 23 \n",
"69 Damen Ave & Pierce Ave 41.909396 -87.677692 19 \n",
"71 Morgan St & Lake St 41.885483 -87.652305 15 \n",
"72 State St & 16th St 41.860121 -87.627729 15 \n",
"73 Jefferson St & Monroe St 41.880422 -87.642746 19 \n",
"74 Kingsbury St & Erie St 41.893843 -87.641851 23 \n",
"75 Canal St & Jackson Blvd 41.878114 -87.639971 35 \n",
"76 Lake Shore Dr & Monroe St 41.881050 -87.616970 11 \n",
"77 Clinton St & Madison St 41.881582 -87.641277 23 \n",
"80 Aberdeen St & Madison St 41.881487 -87.654752 19 \n",
"81 Daley Center Plaza 41.884337 -87.630183 47 \n",
"84 Green St & Milwaukee Ave 41.891733 -87.648727 19 \n",
" ... ... ... ... \n",
"\n",
" landmark online date count \n",
"id \n",
"5 30 6/28/2013 10146 \n",
"13 66 6/28/2013 7996 \n",
"14 163 6/28/2013 2969 \n",
"15 164 6/28/2013 3341 \n",
"16 223 8/12/2013 3364 \n",
"17 246 6/28/2013 5644 \n",
"19 139 6/28/2013 3747 \n",
"20 154 6/28/2013 5774 \n",
"21 157 6/28/2013 5348 \n",
"22 160 6/28/2013 4511 \n",
"23 172 6/28/2013 4029 \n",
"24 262 6/28/2013 13855 \n",
"25 34 6/28/2013 17119 \n",
"26 51 6/28/2013 22375 \n",
"27 174 6/28/2013 2905 \n",
"28 282 6/28/2013 4178 \n",
"29 290 6/28/2013 5445 \n",
"30 248 6/28/2013 4122 \n",
"31 17 6/28/2013 10276 \n",
"32 76 6/28/2013 3461 \n",
"33 3 6/28/2013 11806 \n",
"34 124 6/28/2013 12775 \n",
"35 22 8/5/2013 35254 \n",
"36 19 6/28/2013 18973 \n",
"37 20 6/28/2013 15326 \n",
"42 170 6/28/2013 3626 \n",
"43 1 6/28/2013 16731 \n",
"44 2 6/28/2013 13177 \n",
"45 40 6/28/2013 12899 \n",
"46 46 6/28/2013 6222 \n",
"47 50 6/28/2013 16501 \n",
"48 12 6/28/2013 12797 \n",
"49 49 6/28/2013 15221 \n",
"50 9 6/28/2013 9933 \n",
"51 5 6/28/2013 14289 \n",
"52 43 6/28/2013 21223 \n",
"53 64 6/28/2013 11522 \n",
"54 44 6/28/2013 5127 \n",
"55 166 6/28/2013 3485 \n",
"56 39 6/28/2013 11418 \n",
"57 327 6/28/2013 5034 \n",
"58 25 6/28/2013 7197 \n",
"59 31 6/28/2013 16696 \n",
"60 58 6/28/2013 8302 \n",
"61 221 6/28/2013 5473 \n",
"62 106 6/28/2013 7943 \n",
"66 21 6/28/2013 12308 \n",
"67 60 6/28/2013 12040 \n",
"68 37 6/28/2013 4312 \n",
"69 65 6/28/2013 11564 \n",
"71 72 6/28/2013 5960 \n",
"72 148 6/28/2013 6009 \n",
"73 38 6/28/2013 8070 \n",
"74 265 6/28/2013 11529 \n",
"75 138 6/28/2013 20255 \n",
"76 300 6/28/2013 31130 \n",
"77 301 6/28/2013 16469 \n",
"80 156 6/28/2013 8697 \n",
"81 23 6/28/2013 16805 \n",
"84 33 6/28/2013 4365 \n",
" ... ... ... \n",
"\n",
"[300 rows x 7 columns]"
]
}
],
"prompt_number": 131
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# for station in data2.sort('count').iterrows():\n",
"# for i in np.arange(station[1]['count']):\n",
"# print i"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment