{
 "metadata": {
  "name": "Transjakarta"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Import pandas library"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "import pandas as pd",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Read CSV file and save it as `tj`"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tj = pd.read_csv('/home/za/dev/github/hackjak2015/transjakarta/data/processed-data-lokasi-busway-jakarta-beserta-keterangan-per-februari-2013.csv')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tj",
     "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>koridor</th>\n      <th>rute_koridor</th>\n      <th>nama_halte</th>\n      <th>lokasi_halte</th>\n      <th>dibangun_tahun</th>\n      <th>keterangan</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                TERMINAL BLOK M</td>\n      <td>         TERMINAL BLOK M</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>1 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                MESJID AL-AZHAR</td>\n      <td>    JL. SISINGAMANGARAJA</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP,TANGGA )</td>\n    </tr>\n    <tr>\n      <th>2 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>               BUNDARAN SENAYAN</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>3 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                        GELORA </td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>4 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                          POLDA</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>5 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                         BENHIL</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>6 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                          KARET</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>      JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>7 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                     SETIA BUDI</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>8 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                     DUKUH ATAS</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>9 </th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                         TOSARI</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                    BUNDARAN HI</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>           JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                        SARINAH</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>           JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                             BI</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                          MONAS</td>\n      <td>       JL. MERDEKA BARAT</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td> HARMONI CENTRAL BUSWAY ( HCB )</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                    SAWAH BESAR</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                   MANGGA BESAR</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                          OLIMO</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                         GLODOK</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td> Koridor 1</td>\n      <td>           Blok M - Kota</td>\n      <td>                   STASIUN KOTA</td>\n      <td>             JL.STASIUN </td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>            TERMINAL PULOGADUNG</td>\n      <td>     TERMINAL PULOGADUNG</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         BERMIS</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                        POLUMAS</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                           ASMI</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                    PEDONGKELAN</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>    CEMPAKA TIMUR (Cempaka Mas)</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>      RUMAH SAKIT ISLAM (Yarsi)</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>        CEMPAKA TENGAH (LIPPO )</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>           PASAR CEMPAKA  PUTIH</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                   RAWA SELATAN</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          GALUR</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BAJA / PEMBANGUNAN BARU ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          SENEN</td>\n      <td>       JL.BUNDARAN SENEN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         ATRIUM</td>\n      <td>           JL.SENEN RAYA</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          RSPAD</td>\n      <td>                 JL.KIWI</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                            NaN</td>\n      <td>                     NaN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          DEPLU</td>\n      <td>             JL.PEJAMBON</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                       GAMBIR 1</td>\n      <td>        JL.MERDEKA TIMUR</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>             ISTIQLAL (Perwira)</td>\n      <td>              JL.PERWIRA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         JUANDA</td>\n      <td>               JL.JUANDA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                     PECENONGAN</td>\n      <td>               JL.JUANDA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                      BALAIKOTA</td>\n      <td>      JL.MERDEKA SELATAN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                       GAMBIR 2</td>\n      <td>      JL.MERDEKA SELATAN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td> Koridor 2</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                        KWITANG</td>\n      <td>              JL.KWITANG</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>             TERMINAL KALIDERES</td>\n      <td>       TERMINAL KALIDRES</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                        PESAKIH</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                      SUMUR BOR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     RAWA BUAYA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>    JPO BAJA / PEMB BARU TH 2010 ( RAMP, TANGGA )</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                  JEMBATAN BARU</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       DISPENDA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>      JPO BAJA / PEMBANGUNAN BARU ( RAMP, SEMUA )</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>               JEMBATAN GANTUNG</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>             JPO BAJA / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     TAMAN KOTA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       INDOSIAR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BAJA / PEMBANGUNAN BARU ( RAMP, TANGGA )</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       JELAMBAR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BETON / EKSISTING ( TANGGA BETON SEMUA )</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       GROGOL 1</td>\n      <td>            JL.KYAI TAPA</td>\n      <td> 2004 dan 2005</td>\n      <td> JPO BETON / EKSISTING ( Halte Bangun Thn 2007 ) </td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                RS.SUMBER WARAS</td>\n      <td>            JL.KYAI TAPA</td>\n      <td> 2004 dan 2005</td>\n      <td>  JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td> Koridor 3</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     PASAR BARU</td>\n      <td>              JL.SOETOMO</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td> Koridor 4</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                   DUKUH ATAS 2</td>\n      <td>          JL.DUKUH BAWAH</td>\n      <td>          2006</td>\n      <td>              SKY WOLK / PEMABNGUNAN BARU/PELICAN</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td> Koridor 4</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                        HALIMUN</td>\n      <td>           JL.GALUNGGUNG</td>\n      <td>          2006</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>58</th>\n      <td> Koridor 4</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                   PASAR RUMPUT</td>\n      <td>           JL.GALUNGGUNG</td>\n      <td>          2006</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>59</th>\n      <td> Koridor 4</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                      MANGGARAI</td>\n      <td>      TERMINAL MANGGARAI</td>\n      <td>          2006</td>\n      <td>                                          PELICAN</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    </tr>\n  </tbody>\n</table>\n<p>210 rows \u00d7 6 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 3,
       "text": "      koridor             rute_koridor                      nama_halte  \\\n0   Koridor 1            Blok M - Kota                 TERMINAL BLOK M   \n1   Koridor 1            Blok M - Kota                 MESJID AL-AZHAR   \n2   Koridor 1            Blok M - Kota                BUNDARAN SENAYAN   \n3   Koridor 1            Blok M - Kota                         GELORA    \n4   Koridor 1            Blok M - Kota                           POLDA   \n5   Koridor 1            Blok M - Kota                          BENHIL   \n6   Koridor 1            Blok M - Kota                           KARET   \n7   Koridor 1            Blok M - Kota                      SETIA BUDI   \n8   Koridor 1            Blok M - Kota                      DUKUH ATAS   \n9   Koridor 1            Blok M - Kota                          TOSARI   \n10  Koridor 1            Blok M - Kota                     BUNDARAN HI   \n11  Koridor 1            Blok M - Kota                         SARINAH   \n12  Koridor 1            Blok M - Kota                              BI   \n13  Koridor 1            Blok M - Kota                           MONAS   \n14  Koridor 1            Blok M - Kota  HARMONI CENTRAL BUSWAY ( HCB )   \n15  Koridor 1            Blok M - Kota                     SAWAH BESAR   \n16  Koridor 1            Blok M - Kota                    MANGGA BESAR   \n17  Koridor 1            Blok M - Kota                           OLIMO   \n18  Koridor 1            Blok M - Kota                          GLODOK   \n19  Koridor 1            Blok M - Kota                    STASIUN KOTA   \n20  Koridor 2     Harmoni - Pulogadung             TERMINAL PULOGADUNG   \n21  Koridor 2     Harmoni - Pulogadung                          BERMIS   \n22  Koridor 2     Harmoni - Pulogadung                         POLUMAS   \n23  Koridor 2     Harmoni - Pulogadung                            ASMI   \n24  Koridor 2     Harmoni - Pulogadung                     PEDONGKELAN   \n25  Koridor 2     Harmoni - Pulogadung     CEMPAKA TIMUR (Cempaka Mas)   \n26  Koridor 2     Harmoni - Pulogadung       RUMAH SAKIT ISLAM (Yarsi)   \n27  Koridor 2     Harmoni - Pulogadung         CEMPAKA TENGAH (LIPPO )   \n28  Koridor 2     Harmoni - Pulogadung            PASAR CEMPAKA  PUTIH   \n29  Koridor 2     Harmoni - Pulogadung                    RAWA SELATAN   \n30  Koridor 2     Harmoni - Pulogadung                           GALUR   \n31  Koridor 2     Harmoni - Pulogadung                           SENEN   \n32  Koridor 2     Harmoni - Pulogadung                          ATRIUM   \n33  Koridor 2     Harmoni - Pulogadung                           RSPAD   \n34  Koridor 2     Harmoni - Pulogadung                             NaN   \n35  Koridor 2     Harmoni - Pulogadung                           DEPLU   \n36  Koridor 2     Harmoni - Pulogadung                        GAMBIR 1   \n37  Koridor 2     Harmoni - Pulogadung              ISTIQLAL (Perwira)   \n38  Koridor 2     Harmoni - Pulogadung                          JUANDA   \n39  Koridor 2     Harmoni - Pulogadung                      PECENONGAN   \n40  Koridor 2     Harmoni - Pulogadung                       BALAIKOTA   \n41  Koridor 2     Harmoni - Pulogadung                        GAMBIR 2   \n42  Koridor 2     Harmoni - Pulogadung                         KWITANG   \n43  Koridor 3      Kalideres - Harmoni              TERMINAL KALIDERES   \n44  Koridor 3      Kalideres - Harmoni                         PESAKIH   \n45  Koridor 3      Kalideres - Harmoni                       SUMUR BOR   \n46  Koridor 3      Kalideres - Harmoni                      RAWA BUAYA   \n47  Koridor 3      Kalideres - Harmoni                   JEMBATAN BARU   \n48  Koridor 3      Kalideres - Harmoni                        DISPENDA   \n49  Koridor 3      Kalideres - Harmoni                JEMBATAN GANTUNG   \n50  Koridor 3      Kalideres - Harmoni                      TAMAN KOTA   \n51  Koridor 3      Kalideres - Harmoni                        INDOSIAR   \n52  Koridor 3      Kalideres - Harmoni                        JELAMBAR   \n53  Koridor 3      Kalideres - Harmoni                        GROGOL 1   \n54  Koridor 3      Kalideres - Harmoni                 RS.SUMBER WARAS   \n55  Koridor 3      Kalideres - Harmoni                      PASAR BARU   \n56  Koridor 4  Dukuh Atas - Pulogadung                    DUKUH ATAS 2   \n57  Koridor 4  Dukuh Atas - Pulogadung                         HALIMUN   \n58  Koridor 4  Dukuh Atas - Pulogadung                    PASAR RUMPUT   \n59  Koridor 4  Dukuh Atas - Pulogadung                       MANGGARAI   \n          ...                      ...                             ...   \n\n               lokasi_halte dibangun_tahun  \\\n0           TERMINAL BLOK M           2003   \n1      JL. SISINGAMANGARAJA           2003   \n2         JL. JEND SUDIRMAN           2003   \n3         JL. JEND SUDIRMAN           2003   \n4         JL. JEND SUDIRMAN           2003   \n5         JL. JEND SUDIRMAN           2003   \n6         JL. JEND SUDIRMAN           2003   \n7         JL. JEND SUDIRMAN           2003   \n8         JL. JEND SUDIRMAN           2003   \n9         JL. JEND SUDIRMAN           2003   \n10           JL. MH THAMRIN           2003   \n11           JL. MH THAMRIN           2003   \n12           JL. MH THAMRIN           2003   \n13        JL. MERDEKA BARAT           2003   \n14           JL. GAJAH MADA           2003   \n15           JL. GAJAH MADA           2003   \n16           JL. GAJAH MADA           2003   \n17           JL. GAJAH MADA           2003   \n18           JL. GAJAH MADA           2003   \n19              JL.STASIUN            2003   \n20      TERMINAL PULOGADUNG  2004 dan 2005   \n21  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n22  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n23  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n24  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n25           JL.R. SUPRAPTO  2004 dan 2005   \n26           JL.R. SUPRAPTO  2004 dan 2005   \n27           JL.R. SUPRAPTO  2004 dan 2005   \n28           JL.R. SUPRAPTO  2004 dan 2005   \n29           JL.R. SUPRAPTO  2004 dan 2005   \n30           JL.R. SUPRAPTO  2004 dan 2005   \n31        JL.BUNDARAN SENEN  2004 dan 2005   \n32            JL.SENEN RAYA  2004 dan 2005   \n33                  JL.KIWI  2004 dan 2005   \n34                      NaN  2004 dan 2005   \n35              JL.PEJAMBON  2004 dan 2005   \n36         JL.MERDEKA TIMUR  2004 dan 2005   \n37               JL.PERWIRA  2004 dan 2005   \n38                JL.JUANDA  2004 dan 2005   \n39                JL.JUANDA  2004 dan 2005   \n40       JL.MERDEKA SELATAN  2004 dan 2005   \n41       JL.MERDEKA SELATAN  2004 dan 2005   \n42               JL.KWITANG  2004 dan 2005   \n43        TERMINAL KALIDRES  2004 dan 2005   \n44            JL.DAAN MOGOT  2004 dan 2005   \n45            JL.DAAN MOGOT  2004 dan 2005   \n46            JL.DAAN MOGOT  2004 dan 2005   \n47            JL.DAAN MOGOT  2004 dan 2005   \n48            JL.DAAN MOGOT  2004 dan 2005   \n49            JL.DAAN MOGOT  2004 dan 2005   \n50            JL.DAAN MOGOT  2004 dan 2005   \n51            JL.DAAN MOGOT  2004 dan 2005   \n52            JL.DAAN MOGOT  2004 dan 2005   \n53             JL.KYAI TAPA  2004 dan 2005   \n54             JL.KYAI TAPA  2004 dan 2005   \n55               JL.SOETOMO  2004 dan 2005   \n56           JL.DUKUH BAWAH           2006   \n57            JL.GALUNGGUNG           2006   \n58            JL.GALUNGGUNG           2006   \n59       TERMINAL MANGGARAI           2006   \n                        ...            ...   \n\n                                          keterangan  \n0                                            PELICAN  \n1              JPO BETON / EKSISTING ( RAMP,TANGGA )  \n2                JPO BAJA / EKSISTING ( RAMP SEMUA )  \n3              JPO BETON / EKSISTING ( RAMP SEMUA )   \n4              JPO BETON / EKSISTING ( RAMP SEMUA )   \n5              JPO BETON / EKSISTING ( RAMP SEMUA )   \n6        JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )  \n7                JPO BAJA / EKSISTING ( RAMP SEMUA )  \n8              JPO BETON / EKSISTING ( RAMP SEMUA )   \n9               JPO BETON / EKSISTING ( RAMP SEMUA )  \n10            JPO BETON / EKSISTING ( TANGGA SEMUA )  \n11            JPO BETON / EKSISTING ( TANGGA SEMUA )  \n12              JPO BETON / EKSISTING ( RAMP SEMUA )  \n13                                           PELICAN  \n14            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n15             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n16             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n17             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n18                                           PELICAN  \n19                                           PELICAN  \n20                                           PELICAN  \n21        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n22               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n23               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n24        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n25        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n26            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n27             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n28            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n29             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n30      JPO BAJA / PEMBANGUNAN BARU ( TANGGA SEMUA )  \n31                                           PELICAN  \n32               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n33                                           PELICAN  \n34                                           PELICAN  \n35                                           PELICAN  \n36             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n37                                           PELICAN  \n38                                           PELICAN  \n39                                           PELICAN  \n40                                           PELICAN  \n41                                           PELICAN  \n42                                           PELICAN  \n43                                           PELICAN  \n44               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n45               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n46     JPO BAJA / PEMB BARU TH 2010 ( RAMP, TANGGA )  \n47               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n48       JPO BAJA / PEMBANGUNAN BARU ( RAMP, SEMUA )  \n49              JPO BAJA / EKSISTING ( RAMP SEMUA )   \n50            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n51      JPO BAJA / PEMBANGUNAN BARU ( RAMP, TANGGA )  \n52      JPO BETON / EKSISTING ( TANGGA BETON SEMUA )  \n53  JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )   \n54   JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )  \n55               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n56               SKY WOLK / PEMABNGUNAN BARU/PELICAN  \n57                                           PELICAN  \n58              JPO BETON / EKSISTING ( RAMP SEMUA )  \n59                                           PELICAN  \n                                                 ...  \n\n[210 rows x 6 columns]"
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Now, I'd like to know how many shelters in every lines"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tj['koridor'].value_counts()",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": "Koridor 2     23\nKoridor 9     23\nKoridor 8     20\nKoridor 1     20\nKoridor 10    18\nKoridor 6     18\nKoridor 4     17\nKoridor 5     17\nKoridor 11    15\nKoridor 12    13\nKoridor 7     13\nKoridor 3     13\ndtype: int64"
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "I have the result but it didn't sort well"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tj['koridor'].value_counts().sort_index()",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": "Koridor 1     20\nKoridor 10    18\nKoridor 11    15\nKoridor 12    13\nKoridor 2     23\nKoridor 3     13\nKoridor 4     17\nKoridor 5     17\nKoridor 6     18\nKoridor 7     13\nKoridor 8     20\nKoridor 9     23\ndtype: int64"
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "This is better but should be better"
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "I need to modify the original csv file, replace `Koridor 1` with `Koridor 01` and so on"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod = pd.read_csv('/home/za/dev/github/hackjak2015/transjakarta/data/processed-data-lokasi-busway-jakarta-beserta-keterangan-per-februari-2013-modified.csv')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod",
     "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>koridor</th>\n      <th>rute_koridor</th>\n      <th>nama_halte</th>\n      <th>lokasi_halte</th>\n      <th>dibangun_tahun</th>\n      <th>keterangan</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                TERMINAL BLOK M</td>\n      <td>         TERMINAL BLOK M</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>1 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                MESJID AL-AZHAR</td>\n      <td>    JL. SISINGAMANGARAJA</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP,TANGGA )</td>\n    </tr>\n    <tr>\n      <th>2 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>               BUNDARAN SENAYAN</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>3 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                        GELORA </td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>4 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                          POLDA</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>5 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                         BENHIL</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>6 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                          KARET</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>      JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>7 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                     SETIA BUDI</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>8 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                     DUKUH ATAS</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>            JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>9 </th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                         TOSARI</td>\n      <td>       JL. JEND SUDIRMAN</td>\n      <td>          2003</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                    BUNDARAN HI</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>           JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                        SARINAH</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>           JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                             BI</td>\n      <td>          JL. MH THAMRIN</td>\n      <td>          2003</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                          MONAS</td>\n      <td>       JL. MERDEKA BARAT</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td> HARMONI CENTRAL BUSWAY ( HCB )</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                    SAWAH BESAR</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                   MANGGA BESAR</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                          OLIMO</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                         GLODOK</td>\n      <td>          JL. GAJAH MADA</td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td> Koridor 01</td>\n      <td>           Blok M - Kota</td>\n      <td>                   STASIUN KOTA</td>\n      <td>             JL.STASIUN </td>\n      <td>          2003</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>            TERMINAL PULOGADUNG</td>\n      <td>     TERMINAL PULOGADUNG</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         BERMIS</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                        POLUMAS</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                           ASMI</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                    PEDONGKELAN</td>\n      <td> JL.PERINTIS KEMERDEKAAN</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>    CEMPAKA TIMUR (Cempaka Mas)</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>       JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>      RUMAH SAKIT ISLAM (Yarsi)</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>        CEMPAKA TENGAH (LIPPO )</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>           PASAR CEMPAKA  PUTIH</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                   RAWA SELATAN</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          GALUR</td>\n      <td>          JL.R. SUPRAPTO</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BAJA / PEMBANGUNAN BARU ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          SENEN</td>\n      <td>       JL.BUNDARAN SENEN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         ATRIUM</td>\n      <td>           JL.SENEN RAYA</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          RSPAD</td>\n      <td>                 JL.KIWI</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                            NaN</td>\n      <td>                     NaN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                          DEPLU</td>\n      <td>             JL.PEJAMBON</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                       GAMBIR 1</td>\n      <td>        JL.MERDEKA TIMUR</td>\n      <td> 2004 dan 2005</td>\n      <td>            JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>             ISTIQLAL (Perwira)</td>\n      <td>              JL.PERWIRA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                         JUANDA</td>\n      <td>               JL.JUANDA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                     PECENONGAN</td>\n      <td>               JL.JUANDA</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                      BALAIKOTA</td>\n      <td>      JL.MERDEKA SELATAN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                       GAMBIR 2</td>\n      <td>      JL.MERDEKA SELATAN</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td> Koridor 02</td>\n      <td>    Harmoni - Pulogadung</td>\n      <td>                        KWITANG</td>\n      <td>              JL.KWITANG</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>             TERMINAL KALIDERES</td>\n      <td>       TERMINAL KALIDRES</td>\n      <td> 2004 dan 2005</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                        PESAKIH</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                      SUMUR BOR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     RAWA BUAYA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>    JPO BAJA / PEMB BARU TH 2010 ( RAMP, TANGGA )</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                  JEMBATAN BARU</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       DISPENDA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>      JPO BAJA / PEMBANGUNAN BARU ( RAMP, SEMUA )</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>               JEMBATAN GANTUNG</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>             JPO BAJA / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     TAMAN KOTA</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>           JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       INDOSIAR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BAJA / PEMBANGUNAN BARU ( RAMP, TANGGA )</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       JELAMBAR</td>\n      <td>           JL.DAAN MOGOT</td>\n      <td> 2004 dan 2005</td>\n      <td>     JPO BETON / EKSISTING ( TANGGA BETON SEMUA )</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                       GROGOL 1</td>\n      <td>            JL.KYAI TAPA</td>\n      <td> 2004 dan 2005</td>\n      <td> JPO BETON / EKSISTING ( Halte Bangun Thn 2007 ) </td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                RS.SUMBER WARAS</td>\n      <td>            JL.KYAI TAPA</td>\n      <td> 2004 dan 2005</td>\n      <td>  JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td> Koridor 03</td>\n      <td>     Kalideres - Harmoni</td>\n      <td>                     PASAR BARU</td>\n      <td>              JL.SOETOMO</td>\n      <td> 2004 dan 2005</td>\n      <td>              JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td> Koridor 04</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                   DUKUH ATAS 2</td>\n      <td>          JL.DUKUH BAWAH</td>\n      <td>          2006</td>\n      <td>              SKY WOLK / PEMABNGUNAN BARU/PELICAN</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td> Koridor 04</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                        HALIMUN</td>\n      <td>           JL.GALUNGGUNG</td>\n      <td>          2006</td>\n      <td>                                          PELICAN</td>\n    </tr>\n    <tr>\n      <th>58</th>\n      <td> Koridor 04</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                   PASAR RUMPUT</td>\n      <td>           JL.GALUNGGUNG</td>\n      <td>          2006</td>\n      <td>             JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>59</th>\n      <td> Koridor 04</td>\n      <td> Dukuh Atas - Pulogadung</td>\n      <td>                      MANGGARAI</td>\n      <td>      TERMINAL MANGGARAI</td>\n      <td>          2006</td>\n      <td>                                          PELICAN</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    </tr>\n  </tbody>\n</table>\n<p>210 rows \u00d7 6 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": "       koridor             rute_koridor                      nama_halte  \\\n0   Koridor 01            Blok M - Kota                 TERMINAL BLOK M   \n1   Koridor 01            Blok M - Kota                 MESJID AL-AZHAR   \n2   Koridor 01            Blok M - Kota                BUNDARAN SENAYAN   \n3   Koridor 01            Blok M - Kota                         GELORA    \n4   Koridor 01            Blok M - Kota                           POLDA   \n5   Koridor 01            Blok M - Kota                          BENHIL   \n6   Koridor 01            Blok M - Kota                           KARET   \n7   Koridor 01            Blok M - Kota                      SETIA BUDI   \n8   Koridor 01            Blok M - Kota                      DUKUH ATAS   \n9   Koridor 01            Blok M - Kota                          TOSARI   \n10  Koridor 01            Blok M - Kota                     BUNDARAN HI   \n11  Koridor 01            Blok M - Kota                         SARINAH   \n12  Koridor 01            Blok M - Kota                              BI   \n13  Koridor 01            Blok M - Kota                           MONAS   \n14  Koridor 01            Blok M - Kota  HARMONI CENTRAL BUSWAY ( HCB )   \n15  Koridor 01            Blok M - Kota                     SAWAH BESAR   \n16  Koridor 01            Blok M - Kota                    MANGGA BESAR   \n17  Koridor 01            Blok M - Kota                           OLIMO   \n18  Koridor 01            Blok M - Kota                          GLODOK   \n19  Koridor 01            Blok M - Kota                    STASIUN KOTA   \n20  Koridor 02     Harmoni - Pulogadung             TERMINAL PULOGADUNG   \n21  Koridor 02     Harmoni - Pulogadung                          BERMIS   \n22  Koridor 02     Harmoni - Pulogadung                         POLUMAS   \n23  Koridor 02     Harmoni - Pulogadung                            ASMI   \n24  Koridor 02     Harmoni - Pulogadung                     PEDONGKELAN   \n25  Koridor 02     Harmoni - Pulogadung     CEMPAKA TIMUR (Cempaka Mas)   \n26  Koridor 02     Harmoni - Pulogadung       RUMAH SAKIT ISLAM (Yarsi)   \n27  Koridor 02     Harmoni - Pulogadung         CEMPAKA TENGAH (LIPPO )   \n28  Koridor 02     Harmoni - Pulogadung            PASAR CEMPAKA  PUTIH   \n29  Koridor 02     Harmoni - Pulogadung                    RAWA SELATAN   \n30  Koridor 02     Harmoni - Pulogadung                           GALUR   \n31  Koridor 02     Harmoni - Pulogadung                           SENEN   \n32  Koridor 02     Harmoni - Pulogadung                          ATRIUM   \n33  Koridor 02     Harmoni - Pulogadung                           RSPAD   \n34  Koridor 02     Harmoni - Pulogadung                             NaN   \n35  Koridor 02     Harmoni - Pulogadung                           DEPLU   \n36  Koridor 02     Harmoni - Pulogadung                        GAMBIR 1   \n37  Koridor 02     Harmoni - Pulogadung              ISTIQLAL (Perwira)   \n38  Koridor 02     Harmoni - Pulogadung                          JUANDA   \n39  Koridor 02     Harmoni - Pulogadung                      PECENONGAN   \n40  Koridor 02     Harmoni - Pulogadung                       BALAIKOTA   \n41  Koridor 02     Harmoni - Pulogadung                        GAMBIR 2   \n42  Koridor 02     Harmoni - Pulogadung                         KWITANG   \n43  Koridor 03      Kalideres - Harmoni              TERMINAL KALIDERES   \n44  Koridor 03      Kalideres - Harmoni                         PESAKIH   \n45  Koridor 03      Kalideres - Harmoni                       SUMUR BOR   \n46  Koridor 03      Kalideres - Harmoni                      RAWA BUAYA   \n47  Koridor 03      Kalideres - Harmoni                   JEMBATAN BARU   \n48  Koridor 03      Kalideres - Harmoni                        DISPENDA   \n49  Koridor 03      Kalideres - Harmoni                JEMBATAN GANTUNG   \n50  Koridor 03      Kalideres - Harmoni                      TAMAN KOTA   \n51  Koridor 03      Kalideres - Harmoni                        INDOSIAR   \n52  Koridor 03      Kalideres - Harmoni                        JELAMBAR   \n53  Koridor 03      Kalideres - Harmoni                        GROGOL 1   \n54  Koridor 03      Kalideres - Harmoni                 RS.SUMBER WARAS   \n55  Koridor 03      Kalideres - Harmoni                      PASAR BARU   \n56  Koridor 04  Dukuh Atas - Pulogadung                    DUKUH ATAS 2   \n57  Koridor 04  Dukuh Atas - Pulogadung                         HALIMUN   \n58  Koridor 04  Dukuh Atas - Pulogadung                    PASAR RUMPUT   \n59  Koridor 04  Dukuh Atas - Pulogadung                       MANGGARAI   \n           ...                      ...                             ...   \n\n               lokasi_halte dibangun_tahun  \\\n0           TERMINAL BLOK M           2003   \n1      JL. SISINGAMANGARAJA           2003   \n2         JL. JEND SUDIRMAN           2003   \n3         JL. JEND SUDIRMAN           2003   \n4         JL. JEND SUDIRMAN           2003   \n5         JL. JEND SUDIRMAN           2003   \n6         JL. JEND SUDIRMAN           2003   \n7         JL. JEND SUDIRMAN           2003   \n8         JL. JEND SUDIRMAN           2003   \n9         JL. JEND SUDIRMAN           2003   \n10           JL. MH THAMRIN           2003   \n11           JL. MH THAMRIN           2003   \n12           JL. MH THAMRIN           2003   \n13        JL. MERDEKA BARAT           2003   \n14           JL. GAJAH MADA           2003   \n15           JL. GAJAH MADA           2003   \n16           JL. GAJAH MADA           2003   \n17           JL. GAJAH MADA           2003   \n18           JL. GAJAH MADA           2003   \n19              JL.STASIUN            2003   \n20      TERMINAL PULOGADUNG  2004 dan 2005   \n21  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n22  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n23  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n24  JL.PERINTIS KEMERDEKAAN  2004 dan 2005   \n25           JL.R. SUPRAPTO  2004 dan 2005   \n26           JL.R. SUPRAPTO  2004 dan 2005   \n27           JL.R. SUPRAPTO  2004 dan 2005   \n28           JL.R. SUPRAPTO  2004 dan 2005   \n29           JL.R. SUPRAPTO  2004 dan 2005   \n30           JL.R. SUPRAPTO  2004 dan 2005   \n31        JL.BUNDARAN SENEN  2004 dan 2005   \n32            JL.SENEN RAYA  2004 dan 2005   \n33                  JL.KIWI  2004 dan 2005   \n34                      NaN  2004 dan 2005   \n35              JL.PEJAMBON  2004 dan 2005   \n36         JL.MERDEKA TIMUR  2004 dan 2005   \n37               JL.PERWIRA  2004 dan 2005   \n38                JL.JUANDA  2004 dan 2005   \n39                JL.JUANDA  2004 dan 2005   \n40       JL.MERDEKA SELATAN  2004 dan 2005   \n41       JL.MERDEKA SELATAN  2004 dan 2005   \n42               JL.KWITANG  2004 dan 2005   \n43        TERMINAL KALIDRES  2004 dan 2005   \n44            JL.DAAN MOGOT  2004 dan 2005   \n45            JL.DAAN MOGOT  2004 dan 2005   \n46            JL.DAAN MOGOT  2004 dan 2005   \n47            JL.DAAN MOGOT  2004 dan 2005   \n48            JL.DAAN MOGOT  2004 dan 2005   \n49            JL.DAAN MOGOT  2004 dan 2005   \n50            JL.DAAN MOGOT  2004 dan 2005   \n51            JL.DAAN MOGOT  2004 dan 2005   \n52            JL.DAAN MOGOT  2004 dan 2005   \n53             JL.KYAI TAPA  2004 dan 2005   \n54             JL.KYAI TAPA  2004 dan 2005   \n55               JL.SOETOMO  2004 dan 2005   \n56           JL.DUKUH BAWAH           2006   \n57            JL.GALUNGGUNG           2006   \n58            JL.GALUNGGUNG           2006   \n59       TERMINAL MANGGARAI           2006   \n                        ...            ...   \n\n                                          keterangan  \n0                                            PELICAN  \n1              JPO BETON / EKSISTING ( RAMP,TANGGA )  \n2                JPO BAJA / EKSISTING ( RAMP SEMUA )  \n3              JPO BETON / EKSISTING ( RAMP SEMUA )   \n4              JPO BETON / EKSISTING ( RAMP SEMUA )   \n5              JPO BETON / EKSISTING ( RAMP SEMUA )   \n6        JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )  \n7                JPO BAJA / EKSISTING ( RAMP SEMUA )  \n8              JPO BETON / EKSISTING ( RAMP SEMUA )   \n9               JPO BETON / EKSISTING ( RAMP SEMUA )  \n10            JPO BETON / EKSISTING ( TANGGA SEMUA )  \n11            JPO BETON / EKSISTING ( TANGGA SEMUA )  \n12              JPO BETON / EKSISTING ( RAMP SEMUA )  \n13                                           PELICAN  \n14            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n15             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n16             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n17             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n18                                           PELICAN  \n19                                           PELICAN  \n20                                           PELICAN  \n21        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n22               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n23               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n24        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n25        JPO BAJA / PEMBANGUNAN BARU ( RAMP SEMUA )  \n26            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n27             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n28            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n29             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n30      JPO BAJA / PEMBANGUNAN BARU ( TANGGA SEMUA )  \n31                                           PELICAN  \n32               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n33                                           PELICAN  \n34                                           PELICAN  \n35                                           PELICAN  \n36             JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n37                                           PELICAN  \n38                                           PELICAN  \n39                                           PELICAN  \n40                                           PELICAN  \n41                                           PELICAN  \n42                                           PELICAN  \n43                                           PELICAN  \n44               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n45               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n46     JPO BAJA / PEMB BARU TH 2010 ( RAMP, TANGGA )  \n47               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n48       JPO BAJA / PEMBANGUNAN BARU ( RAMP, SEMUA )  \n49              JPO BAJA / EKSISTING ( RAMP SEMUA )   \n50            JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n51      JPO BAJA / PEMBANGUNAN BARU ( RAMP, TANGGA )  \n52      JPO BETON / EKSISTING ( TANGGA BETON SEMUA )  \n53  JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )   \n54   JPO BETON / EKSISTING ( Halte Bangun Thn 2007 )  \n55               JPO BAJA / EKSISTING ( RAMP SEMUA )  \n56               SKY WOLK / PEMABNGUNAN BARU/PELICAN  \n57                                           PELICAN  \n58              JPO BETON / EKSISTING ( RAMP SEMUA )  \n59                                           PELICAN  \n                                                 ...  \n\n[210 rows x 6 columns]"
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Let's take a look again"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod['koridor']",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": "0     Koridor 01\n1     Koridor 01\n2     Koridor 01\n3     Koridor 01\n4     Koridor 01\n5     Koridor 01\n6     Koridor 01\n7     Koridor 01\n8     Koridor 01\n9     Koridor 01\n10    Koridor 01\n11    Koridor 01\n12    Koridor 01\n13    Koridor 01\n14    Koridor 01\n...\n195    Koridor 11\n196    Koridor 11\n197    Koridor 12\n198    Koridor 12\n199    Koridor 12\n200    Koridor 12\n201    Koridor 12\n202    Koridor 12\n203    Koridor 12\n204    Koridor 12\n205    Koridor 12\n206    Koridor 12\n207    Koridor 12\n208    Koridor 12\n209    Koridor 12\nName: koridor, Length: 210, dtype: object"
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod['koridor'].value_counts().sort_index()",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": "Koridor 01    20\nKoridor 02    23\nKoridor 03    13\nKoridor 04    17\nKoridor 05    17\nKoridor 06    18\nKoridor 07    13\nKoridor 08    20\nKoridor 09    23\nKoridor 10    18\nKoridor 11    15\nKoridor 12    13\ndtype: int64"
      }
     ],
     "prompt_number": 9
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "OK, this is really better"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod.shape",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 10,
       "text": "(210, 6)"
      }
     ],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod = pd.read_csv('/home/za/dev/github/hackjak2015/transjakarta/data/processed-data-lokasi-busway-jakarta-beserta-keterangan-per-februari-2013-modified.csv')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 12
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod['dibangun_tahun']",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": "0     2003\n1     2003\n2     2003\n3     2003\n4     2003\n5     2003\n6     2003\n7     2003\n8     2003\n9     2003\n10    2003\n11    2003\n12    2003\n13    2003\n14    2003\n...\n195    2011\n196    2011\n197    2012\n198    2012\n199    2012\n200    2012\n201    2012\n202    2012\n203    2012\n204    2012\n205    2012\n206    2012\n207    2012\n208    2012\n209    2012\nName: dibangun_tahun, Length: 210, dtype: int64"
      }
     ],
     "prompt_number": 14
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "So now we have `dibangun_pada` data in int64 data type"
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Now, I'd like to know how many shelter in Koridor X which is built on Y year"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod[['koridor', 'dibangun_tahun']]",
     "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>koridor</th>\n      <th>dibangun_tahun</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>1 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>2 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>3 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>4 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>5 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>6 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>7 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>8 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>9 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>58</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>59</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th></th>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n  </tbody>\n</table>\n<p>210 rows \u00d7 2 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 16,
       "text": "       koridor  dibangun_tahun\n0   Koridor 01            2003\n1   Koridor 01            2003\n2   Koridor 01            2003\n3   Koridor 01            2003\n4   Koridor 01            2003\n5   Koridor 01            2003\n6   Koridor 01            2003\n7   Koridor 01            2003\n8   Koridor 01            2003\n9   Koridor 01            2003\n10  Koridor 01            2003\n11  Koridor 01            2003\n12  Koridor 01            2003\n13  Koridor 01            2003\n14  Koridor 01            2003\n15  Koridor 01            2003\n16  Koridor 01            2003\n17  Koridor 01            2003\n18  Koridor 01            2003\n19  Koridor 01            2003\n20  Koridor 02            2005\n21  Koridor 02            2005\n22  Koridor 02            2005\n23  Koridor 02            2005\n24  Koridor 02            2005\n25  Koridor 02            2005\n26  Koridor 02            2005\n27  Koridor 02            2005\n28  Koridor 02            2005\n29  Koridor 02            2005\n30  Koridor 02            2005\n31  Koridor 02            2005\n32  Koridor 02            2005\n33  Koridor 02            2005\n34  Koridor 02            2005\n35  Koridor 02            2005\n36  Koridor 02            2005\n37  Koridor 02            2005\n38  Koridor 02            2005\n39  Koridor 02            2005\n40  Koridor 02            2005\n41  Koridor 02            2005\n42  Koridor 02            2005\n43  Koridor 03            2005\n44  Koridor 03            2005\n45  Koridor 03            2005\n46  Koridor 03            2005\n47  Koridor 03            2005\n48  Koridor 03            2005\n49  Koridor 03            2005\n50  Koridor 03            2005\n51  Koridor 03            2005\n52  Koridor 03            2005\n53  Koridor 03            2005\n54  Koridor 03            2005\n55  Koridor 03            2005\n56  Koridor 04            2006\n57  Koridor 04            2006\n58  Koridor 04            2006\n59  Koridor 04            2006\n           ...             ...\n\n[210 rows x 2 columns]"
      }
     ],
     "prompt_number": 16
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "tjmod[tjmod['koridor'] == 'Koridor 01']",
     "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>koridor</th>\n      <th>rute_koridor</th>\n      <th>nama_halte</th>\n      <th>lokasi_halte</th>\n      <th>dibangun_tahun</th>\n      <th>keterangan</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                TERMINAL BLOK M</td>\n      <td>      TERMINAL BLOK M</td>\n      <td> 2003</td>\n      <td>                                     PELICAN</td>\n    </tr>\n    <tr>\n      <th>1 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                MESJID AL-AZHAR</td>\n      <td> JL. SISINGAMANGARAJA</td>\n      <td> 2003</td>\n      <td>       JPO BETON / EKSISTING ( RAMP,TANGGA )</td>\n    </tr>\n    <tr>\n      <th>2 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>               BUNDARAN SENAYAN</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>         JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>3 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                        GELORA </td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>       JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>4 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                          POLDA</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>       JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>5 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                         BENHIL</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>       JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>6 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                          KARET</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td> JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>7 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                     SETIA BUDI</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>         JPO BAJA / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>8 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                     DUKUH ATAS</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>       JPO BETON / EKSISTING ( RAMP SEMUA ) </td>\n    </tr>\n    <tr>\n      <th>9 </th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                         TOSARI</td>\n      <td>    JL. JEND SUDIRMAN</td>\n      <td> 2003</td>\n      <td>        JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                    BUNDARAN HI</td>\n      <td>       JL. MH THAMRIN</td>\n      <td> 2003</td>\n      <td>      JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                        SARINAH</td>\n      <td>       JL. MH THAMRIN</td>\n      <td> 2003</td>\n      <td>      JPO BETON / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                             BI</td>\n      <td>       JL. MH THAMRIN</td>\n      <td> 2003</td>\n      <td>        JPO BETON / EKSISTING ( RAMP SEMUA )</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                          MONAS</td>\n      <td>    JL. MERDEKA BARAT</td>\n      <td> 2003</td>\n      <td>                                     PELICAN</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td> HARMONI CENTRAL BUSWAY ( HCB )</td>\n      <td>       JL. GAJAH MADA</td>\n      <td> 2003</td>\n      <td>      JPO BAJA / EKSISTING ( RAMP, TANGGA ) </td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                    SAWAH BESAR</td>\n      <td>       JL. GAJAH MADA</td>\n      <td> 2003</td>\n      <td>       JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                   MANGGA BESAR</td>\n      <td>       JL. GAJAH MADA</td>\n      <td> 2003</td>\n      <td>       JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                          OLIMO</td>\n      <td>       JL. GAJAH MADA</td>\n      <td> 2003</td>\n      <td>       JPO BAJA / EKSISTING ( TANGGA SEMUA )</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                         GLODOK</td>\n      <td>       JL. GAJAH MADA</td>\n      <td> 2003</td>\n      <td>                                     PELICAN</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td> Koridor 01</td>\n      <td> Blok M - Kota</td>\n      <td>                   STASIUN KOTA</td>\n      <td>          JL.STASIUN </td>\n      <td> 2003</td>\n      <td>                                     PELICAN</td>\n    </tr>\n  </tbody>\n</table>\n<p>20 rows \u00d7 6 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 17,
       "text": "       koridor   rute_koridor                      nama_halte  \\\n0   Koridor 01  Blok M - Kota                 TERMINAL BLOK M   \n1   Koridor 01  Blok M - Kota                 MESJID AL-AZHAR   \n2   Koridor 01  Blok M - Kota                BUNDARAN SENAYAN   \n3   Koridor 01  Blok M - Kota                         GELORA    \n4   Koridor 01  Blok M - Kota                           POLDA   \n5   Koridor 01  Blok M - Kota                          BENHIL   \n6   Koridor 01  Blok M - Kota                           KARET   \n7   Koridor 01  Blok M - Kota                      SETIA BUDI   \n8   Koridor 01  Blok M - Kota                      DUKUH ATAS   \n9   Koridor 01  Blok M - Kota                          TOSARI   \n10  Koridor 01  Blok M - Kota                     BUNDARAN HI   \n11  Koridor 01  Blok M - Kota                         SARINAH   \n12  Koridor 01  Blok M - Kota                              BI   \n13  Koridor 01  Blok M - Kota                           MONAS   \n14  Koridor 01  Blok M - Kota  HARMONI CENTRAL BUSWAY ( HCB )   \n15  Koridor 01  Blok M - Kota                     SAWAH BESAR   \n16  Koridor 01  Blok M - Kota                    MANGGA BESAR   \n17  Koridor 01  Blok M - Kota                           OLIMO   \n18  Koridor 01  Blok M - Kota                          GLODOK   \n19  Koridor 01  Blok M - Kota                    STASIUN KOTA   \n\n            lokasi_halte  dibangun_tahun  \\\n0        TERMINAL BLOK M            2003   \n1   JL. SISINGAMANGARAJA            2003   \n2      JL. JEND SUDIRMAN            2003   \n3      JL. JEND SUDIRMAN            2003   \n4      JL. JEND SUDIRMAN            2003   \n5      JL. JEND SUDIRMAN            2003   \n6      JL. JEND SUDIRMAN            2003   \n7      JL. JEND SUDIRMAN            2003   \n8      JL. JEND SUDIRMAN            2003   \n9      JL. JEND SUDIRMAN            2003   \n10        JL. MH THAMRIN            2003   \n11        JL. MH THAMRIN            2003   \n12        JL. MH THAMRIN            2003   \n13     JL. MERDEKA BARAT            2003   \n14        JL. GAJAH MADA            2003   \n15        JL. GAJAH MADA            2003   \n16        JL. GAJAH MADA            2003   \n17        JL. GAJAH MADA            2003   \n18        JL. GAJAH MADA            2003   \n19           JL.STASIUN             2003   \n\n                                     keterangan  \n0                                       PELICAN  \n1         JPO BETON / EKSISTING ( RAMP,TANGGA )  \n2           JPO BAJA / EKSISTING ( RAMP SEMUA )  \n3         JPO BETON / EKSISTING ( RAMP SEMUA )   \n4         JPO BETON / EKSISTING ( RAMP SEMUA )   \n5         JPO BETON / EKSISTING ( RAMP SEMUA )   \n6   JPO BAJA / PEMB BARU SPONSOR ( RAMP SEMUA )  \n7           JPO BAJA / EKSISTING ( RAMP SEMUA )  \n8         JPO BETON / EKSISTING ( RAMP SEMUA )   \n9          JPO BETON / EKSISTING ( RAMP SEMUA )  \n10       JPO BETON / EKSISTING ( TANGGA SEMUA )  \n11       JPO BETON / EKSISTING ( TANGGA SEMUA )  \n12         JPO BETON / EKSISTING ( RAMP SEMUA )  \n13                                      PELICAN  \n14       JPO BAJA / EKSISTING ( RAMP, TANGGA )   \n15        JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n16        JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n17        JPO BAJA / EKSISTING ( TANGGA SEMUA )  \n18                                      PELICAN  \n19                                      PELICAN  \n\n[20 rows x 6 columns]"
      }
     ],
     "prompt_number": 17
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor1 = tjmod[tjmod['koridor'] == 'Koridor 01'][['koridor', 'dibangun_tahun']]",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 24
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor1",
     "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>koridor</th>\n      <th>dibangun_tahun</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>1 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>2 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>3 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>4 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>5 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>6 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>7 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>8 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>9 </th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td> Koridor 01</td>\n      <td> 2003</td>\n    </tr>\n  </tbody>\n</table>\n<p>20 rows \u00d7 2 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 25,
       "text": "       koridor  dibangun_tahun\n0   Koridor 01            2003\n1   Koridor 01            2003\n2   Koridor 01            2003\n3   Koridor 01            2003\n4   Koridor 01            2003\n5   Koridor 01            2003\n6   Koridor 01            2003\n7   Koridor 01            2003\n8   Koridor 01            2003\n9   Koridor 01            2003\n10  Koridor 01            2003\n11  Koridor 01            2003\n12  Koridor 01            2003\n13  Koridor 01            2003\n14  Koridor 01            2003\n15  Koridor 01            2003\n16  Koridor 01            2003\n17  Koridor 01            2003\n18  Koridor 01            2003\n19  Koridor 01            2003\n\n[20 rows x 2 columns]"
      }
     ],
     "prompt_number": 25
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "How to count `dibangun_tahun`? "
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "This one is for `Koridor 02`"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor2 = tjmod[tjmod['koridor'] == 'Koridor 02'][['koridor','dibangun_tahun']]",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 26
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor2",
     "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>koridor</th>\n      <th>dibangun_tahun</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>20</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td> Koridor 02</td>\n      <td> 2005</td>\n    </tr>\n  </tbody>\n</table>\n<p>23 rows \u00d7 2 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 27,
       "text": "       koridor  dibangun_tahun\n20  Koridor 02            2005\n21  Koridor 02            2005\n22  Koridor 02            2005\n23  Koridor 02            2005\n24  Koridor 02            2005\n25  Koridor 02            2005\n26  Koridor 02            2005\n27  Koridor 02            2005\n28  Koridor 02            2005\n29  Koridor 02            2005\n30  Koridor 02            2005\n31  Koridor 02            2005\n32  Koridor 02            2005\n33  Koridor 02            2005\n34  Koridor 02            2005\n35  Koridor 02            2005\n36  Koridor 02            2005\n37  Koridor 02            2005\n38  Koridor 02            2005\n39  Koridor 02            2005\n40  Koridor 02            2005\n41  Koridor 02            2005\n42  Koridor 02            2005\n\n[23 rows x 2 columns]"
      }
     ],
     "prompt_number": 27
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "This one is for `Koridor 03`"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor3 = tjmod[tjmod['koridor'] == 'Koridor 03'][['koridor','dibangun_tahun']]",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 28
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor3",
     "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>koridor</th>\n      <th>dibangun_tahun</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>43</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td> Koridor 03</td>\n      <td> 2005</td>\n    </tr>\n  </tbody>\n</table>\n<p>13 rows \u00d7 2 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 29,
       "text": "       koridor  dibangun_tahun\n43  Koridor 03            2005\n44  Koridor 03            2005\n45  Koridor 03            2005\n46  Koridor 03            2005\n47  Koridor 03            2005\n48  Koridor 03            2005\n49  Koridor 03            2005\n50  Koridor 03            2005\n51  Koridor 03            2005\n52  Koridor 03            2005\n53  Koridor 03            2005\n54  Koridor 03            2005\n55  Koridor 03            2005\n\n[13 rows x 2 columns]"
      }
     ],
     "prompt_number": 29
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": "Let's write a function"
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "def koridor_year(koridor):\n    return tjmod[tjmod['koridor'] == koridor][['koridor', 'dibangun_tahun']]",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 58
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor4 = koridor_year(koridor='Koridor 04')",
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 59
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor4",
     "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>koridor</th>\n      <th>dibangun_tahun</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>56</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>58</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>59</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>60</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>61</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>62</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>63</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>64</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>65</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>66</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>67</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>68</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>69</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>70</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>71</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n    <tr>\n      <th>72</th>\n      <td> Koridor 04</td>\n      <td> 2006</td>\n    </tr>\n  </tbody>\n</table>\n<p>17 rows \u00d7 2 columns</p>\n</div>",
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 60,
       "text": "       koridor  dibangun_tahun\n56  Koridor 04            2006\n57  Koridor 04            2006\n58  Koridor 04            2006\n59  Koridor 04            2006\n60  Koridor 04            2006\n61  Koridor 04            2006\n62  Koridor 04            2006\n63  Koridor 04            2006\n64  Koridor 04            2006\n65  Koridor 04            2006\n66  Koridor 04            2006\n67  Koridor 04            2006\n68  Koridor 04            2006\n69  Koridor 04            2006\n70  Koridor 04            2006\n71  Koridor 04            2006\n72  Koridor 04            2006\n\n[17 rows x 2 columns]"
      }
     ],
     "prompt_number": 60
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor4['dibangun_tahun']",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 61,
       "text": "56    2006\n57    2006\n58    2006\n59    2006\n60    2006\n61    2006\n62    2006\n63    2006\n64    2006\n65    2006\n66    2006\n67    2006\n68    2006\n69    2006\n70    2006\n71    2006\n72    2006\nName: dibangun_tahun, dtype: int64"
      }
     ],
     "prompt_number": 61
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "kor4['dibangun_tahun'].value_counts()",
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 62,
       "text": "2006    17\ndtype: int64"
      }
     ],
     "prompt_number": 62
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": "",
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}