{ "metadata": { "name": "", "signature": "sha256:8b005a09f584f532230cff31f5731009c9db224bcc95578669ba151e43dba64d" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "%pylab inline\n", "\n", "import requests\n", "import pandas as pd\n", "import json" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Populating the interactive namespace from numpy and matplotlib\n" ] } ], "prompt_number": 47 }, { "cell_type": "heading", "level": 1, "metadata": {}, "source": [ "Pegando dados de IPTU" ] }, { "cell_type": "code", "collapsed": false, "input": [ "r = requests.get('http://localhost:5000/api/v1/receita/series?code=1.1.1.2.02.02')" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 60 }, { "cell_type": "heading", "level": 1, "metadata": {}, "source": [ "Lendo com o Pandas" ] }, { "cell_type": "code", "collapsed": false, "input": [ "iptu_data = pd.read_json(r.content, orient='split')\n", "iptu_data\n" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | date | \n", "predicted | \n", "outcome | \n", "
---|---|---|---|
1.1.1.2.02.02 | \n", "2008-01-31 | \n", "11130250.00 | \n", "3167489.73 | \n", "
1.1.1.2.02.02 | \n", "2008-02-29 | \n", "11130250.00 | \n", "41884378.39 | \n", "
1.1.1.2.02.02 | \n", "2008-03-31 | \n", "11130250.00 | \n", "19903620.92 | \n", "
1.1.1.2.02.02 | \n", "2008-04-30 | \n", "11130250.00 | \n", "64613.71 | \n", "
1.1.1.2.02.02 | \n", "2008-05-31 | \n", "11130250.00 | \n", "14464750.89 | \n", "
1.1.1.2.02.02 | \n", "2008-06-30 | \n", "11130250.00 | \n", "8737740.83 | \n", "
1.1.1.2.02.02 | \n", "2008-07-31 | \n", "11130250.00 | \n", "8492051.76 | \n", "
1.1.1.2.02.02 | \n", "2008-08-31 | \n", "11130250.00 | \n", "7530991.91 | \n", "
1.1.1.2.02.02 | \n", "2008-09-30 | \n", "11130250.00 | \n", "8511892.31 | \n", "
1.1.1.2.02.02 | \n", "2008-10-31 | \n", "11130250.00 | \n", "8034572.04 | \n", "
1.1.1.2.02.02 | \n", "2008-11-30 | \n", "11130250.00 | \n", "7352505.98 | \n", "
1.1.1.2.02.02 | \n", "2008-12-31 | \n", "11130250.00 | \n", "2385657.25 | \n", "
1.1.1.2.02.02 | \n", "2009-01-31 | \n", "9658333.33 | \n", "2593514.14 | \n", "
1.1.1.2.02.02 | \n", "2009-02-28 | \n", "9658333.33 | \n", "40073958.82 | \n", "
1.1.1.2.02.02 | \n", "2009-03-31 | \n", "9658333.33 | \n", "24757364.15 | \n", "
1.1.1.2.02.02 | \n", "2009-04-30 | \n", "9658333.33 | \n", "9130559.95 | \n", "
1.1.1.2.02.02 | \n", "2009-05-31 | \n", "9658333.33 | \n", "8704293.56 | \n", "
1.1.1.2.02.02 | \n", "2009-06-30 | \n", "9658333.33 | \n", "8616544.57 | \n", "
1.1.1.2.02.02 | \n", "2009-07-31 | \n", "9658333.33 | \n", "8205692.90 | \n", "
1.1.1.2.02.02 | \n", "2009-08-31 | \n", "9658333.33 | \n", "8241502.81 | \n", "
1.1.1.2.02.02 | \n", "2009-09-30 | \n", "9658333.33 | \n", "8914428.63 | \n", "
1.1.1.2.02.02 | \n", "2009-10-31 | \n", "9658333.33 | \n", "7459573.92 | \n", "
1.1.1.2.02.02 | \n", "2009-11-30 | \n", "9658333.33 | \n", "7944754.76 | \n", "
1.1.1.2.02.02 | \n", "2009-12-31 | \n", "9658333.33 | \n", "2599253.10 | \n", "
1.1.1.2.02.02 | \n", "2010-01-31 | \n", "13566560.83 | \n", "2753238.97 | \n", "
1.1.1.2.02.02 | \n", "2010-02-28 | \n", "13566560.83 | \n", "47258818.00 | \n", "
1.1.1.2.02.02 | \n", "2010-03-31 | \n", "13566560.83 | \n", "29053461.29 | \n", "
1.1.1.2.02.02 | \n", "2010-04-30 | \n", "13566560.83 | \n", "11760049.21 | \n", "
1.1.1.2.02.02 | \n", "2010-05-31 | \n", "13566560.83 | \n", "11284328.61 | \n", "
1.1.1.2.02.02 | \n", "2010-06-30 | \n", "13566560.83 | \n", "11343547.25 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
1.1.1.2.02.02 | \n", "2012-07-31 | \n", "17812900.00 | \n", "13242414.40 | \n", "
1.1.1.2.02.02 | \n", "2012-08-31 | \n", "0.00 | \n", "0.00 | \n", "
1.1.1.2.02.02 | \n", "2012-09-30 | \n", "17812900.00 | \n", "12946746.04 | \n", "
1.1.1.2.02.02 | \n", "2012-10-31 | \n", "0.00 | \n", "0.00 | \n", "
1.1.1.2.02.02 | \n", "2012-11-30 | \n", "17812900.00 | \n", "3301884.68 | \n", "
1.1.1.2.02.02 | \n", "2012-12-31 | \n", "0.00 | \n", "0.00 | \n", "
1.1.1.2.02.02 | \n", "2013-01-31 | \n", "20151379.08 | \n", "6745689.99 | \n", "
1.1.1.2.02.02 | \n", "2013-02-28 | \n", "20151379.08 | \n", "66634953.69 | \n", "
1.1.1.2.02.02 | \n", "2013-03-31 | \n", "20151379.08 | \n", "31290497.04 | \n", "
1.1.1.2.02.02 | \n", "2013-04-30 | \n", "20151379.08 | \n", "25986455.04 | \n", "
1.1.1.2.02.02 | \n", "2013-05-31 | \n", "20151379.08 | \n", "15906872.74 | \n", "
1.1.1.2.02.02 | \n", "2013-06-30 | \n", "20151379.08 | \n", "15158176.60 | \n", "
1.1.1.2.02.02 | \n", "2013-07-31 | \n", "20151379.08 | \n", "15079791.91 | \n", "
1.1.1.2.02.02 | \n", "2013-08-31 | \n", "20151379.08 | \n", "15309971.76 | \n", "
1.1.1.2.02.02 | \n", "2013-09-30 | \n", "20151379.08 | \n", "14477768.05 | \n", "
1.1.1.2.02.02 | \n", "2013-10-31 | \n", "20151379.08 | \n", "13300353.58 | \n", "
1.1.1.2.02.02 | \n", "2013-11-30 | \n", "20151379.08 | \n", "12041239.04 | \n", "
1.1.1.2.02.02 | \n", "2013-12-31 | \n", "20151379.08 | \n", "4866685.85 | \n", "
1.1.1.2.02.02 | \n", "2014-01-31 | \n", "21182784.83 | \n", "6135690.03 | \n", "
1.1.1.2.02.02 | \n", "2014-02-28 | \n", "21182784.83 | \n", "73935150.06 | \n", "
1.1.1.2.02.02 | \n", "2014-03-31 | \n", "21182784.83 | \n", "33736279.60 | \n", "
1.1.1.2.02.02 | \n", "2014-04-30 | \n", "21182784.83 | \n", "20122174.97 | \n", "
1.1.1.2.02.02 | \n", "2014-05-31 | \n", "21182784.83 | \n", "17609334.69 | \n", "
1.1.1.2.02.02 | \n", "2014-06-30 | \n", "21182784.83 | \n", "17352023.64 | \n", "
1.1.1.2.02.02 | \n", "2014-07-31 | \n", "21182784.83 | \n", "17700197.04 | \n", "
1.1.1.2.02.02 | \n", "2014-08-31 | \n", "21182784.83 | \n", "18426293.49 | \n", "
1.1.1.2.02.02 | \n", "2014-09-30 | \n", "21182784.83 | \n", "18025453.89 | \n", "
1.1.1.2.02.02 | \n", "2014-10-31 | \n", "21182784.83 | \n", "16974893.62 | \n", "
1.1.1.2.02.02 | \n", "2014-11-30 | \n", "21182784.83 | \n", "15358597.20 | \n", "
1.1.1.2.02.02 | \n", "2014-12-31 | \n", "21182784.83 | \n", "10474.98 | \n", "
108 rows \u00d7 3 columns
\n", "