{ "metadata": { "name": "", "signature": "sha256:49d6947f9ecba00c357a707d7e9c520d821365dc84b96fbf007dbefc9f0818e8" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "import urllib, urllib2\n", "param = {'where':'1=1','outFields':'*','f':'json'}\n", "url = 'http://coagisweb.cabq.gov/arcgis/rest/services/public/APD_Incidents/MapServer/0/query?' + urllib.urlencode(param)\n", "rawreply = urllib2.urlopen(url).read()" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "rawreply[0]" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 2, "text": [ "'{'" ] } ], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "type(rawreply)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 3, "text": [ "str" ] } ], "prompt_number": 3 }, { "cell_type": "code", "collapsed": false, "input": [ "import simplejson\n", "reply = simplejson.loads(rawreply)\n", "print reply[\"features\"][0][\"attributes\"][\"date\"]\n", "print reply[\"features\"][0][\"attributes\"][\"CVINC_TYPE\"]" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "1405468800000\n", "LARCENY ALL OTHER\n" ] } ], "prompt_number": 4 }, { "cell_type": "code", "collapsed": true, "input": [ "print len(reply[\"features\"])\n", "#reply[\"features\"][:3]\n", "reply[\"features\"][2:5]" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "24440\n" ] }, { "metadata": {}, "output_type": "pyout", "prompt_number": 5, "text": [ "[{u'attributes': {u'CVINC_TYPE': u'THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE',\n", " u'CV_BLOCK_ADD': u'4300 BLOCK ZUNI RD SE',\n", " u'OBJECTID': 1396553,\n", " u'date': 1405555200000L},\n", " u'geometry': {u'x': -11866271.569699999, u'y': 4173822.9486000016}},\n", " {u'attributes': {u'CVINC_TYPE': u'BURGLARY/BREAKING AND ENTERING',\n", " u'CV_BLOCK_ADD': u'1200 BLOCK DICKERSON DR SE',\n", " u'OBJECTID': 1396554,\n", " u'date': 1405468800000L},\n", " u'geometry': {u'x': -11868874.981800001, u'y': 4173046.724200003}},\n", " {u'attributes': {u'CVINC_TYPE': u'THEFT FROM A BUILDING',\n", " u'CV_BLOCK_ADD': u'1300 BLOCK VALLEY VIEW DR SW',\n", " u'OBJECTID': 1396555,\n", " u'date': 1405555200000L},\n", " u'geometry': {u'x': -11882344.039, u'y': 4170566.8716999963}}]" ] } ], "prompt_number": 5 }, { "cell_type": "code", "collapsed": false, "input": [ "count = 0\n", "myformateddata=[]\n", "while (count < len(reply[\"features\"])):\n", " mydict={}\n", " for key, value in reply[\"features\"][count][\"attributes\"].iteritems():\n", " mydict[key]= value\n", " myformateddata.append(mydict)\n", " count = count + 1" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 6 }, { "cell_type": "code", "collapsed": false, "input": [ "from pandas import DataFrame as df\n", "myFrame = df(data=myformateddata)\n", "len(myFrame)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 7, "text": [ "24440" ] } ], "prompt_number": 7 }, { "cell_type": "code", "collapsed": false, "input": [ "myFrame" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
CVINC_TYPECV_BLOCK_ADDOBJECTIDdate
0 LARCENY ALL OTHER 7800 BLOCK CENTRAL AVE E 1396551 1.405469e+12
1 SHOPLIFTING 7800 BLOCK CENTRAL AV E 1396552 1.405555e+12
2 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE 4300 BLOCK ZUNI RD SE 1396553 1.405555e+12
3 BURGLARY/BREAKING AND ENTERING 1200 BLOCK DICKERSON DR SE 1396554 1.405469e+12
4 THEFT FROM A BUILDING 1300 BLOCK VALLEY VIEW DR SW 1396555 1.405555e+12
5 AUTO BURGLARY 1500 BLOCK GIBSON BLVD SE 1396556 1.405469e+12
6 BURGLARY/BREAKING AND ENTERING 2000 BLOCK SOUTHERN AVE SE 1396557 1.405469e+12
7 VAGRANCY, BEGGING OR LOITERING 2100 BLOCK CENTRAL AV E 1396558 1.405555e+12
8 COMMERCIAL BURGLARY 1400 BLOCK BROADWAY BL SE 1396559 1.405555e+12
9 DRIVING WHILE INTOXICATED 7600 BLOCK MONTGOMERY BL NE 1396560 1.405642e+12
10 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 7000 BLOCK NATALIE JANAE LN NE 1396561 1.405642e+12
11 AUTO BURGLARY 4800 BLOCK SPRING VALE RD NW 1396562 1.405469e+12
12 THEFT FROM A BUILDING 9500 BLOCK CANDELARIA RD NE 1396563 1.405469e+12
13 THEFT FROM A MOTOR VEHICLE UNIT BLOCK HOTEL CI NE 1396564 1.405555e+12
14 SIMPLE ASSAULT/BATTERY 13100 BLOCK CENTRAL AV E 1396565 1.405555e+12
15 SHOPLIFTING 3500 BLOCK COORS BLVD SW 1396566 1.405642e+12
16 AGGRAVATED ASSAULT 3300 BLOCK RIO PLATA DR SW 1396567 1.405555e+12
17 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE 3900 BLOCK 11TH ST NW 1396568 1.405555e+12
18 DRIVING WHILE INTOXICATED 800 BLOCK RIO GRANDE BLVD NW 1396569 1.405555e+12
19 DISORDERLY CONDUCT 200 BLOCK LOMAS BLVD NW 1396570 1.405469e+12
20 AUTO BURGLARY 1300 BLOCK OJO SARCO ST SW 1396571 1.405642e+12
21 SHOPLIFTING 1400 BLOCK RENAISSANCE BL NE 1396572 1.405555e+12
22 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 100 BLOCK UNION SQUARE ST SE 1396573 1.405642e+12
23 BURGLARY/BREAKING AND ENTERING 1000 BLOCK MOUNTAIN RD NW 1396574 1.405555e+12
24 DISORDERLY CONDUCT 3800 BLOCK CENTRAL AV E 1396575 1.405555e+12
25 AUTO BURGLARY 900 BLOCK LOUISIANA BL NE 1396576 1.405555e+12
26 AUTO BURGLARY 2000 BLOCK MENAUL BLVD NE 1396577 1.405642e+12
27 AUTO THEFT 500 BLOCK ORTIZ DR SE 1396578 1.405469e+12
28 THEFT FROM A BUILDING 9100 BLOCK COPPER AV NE 1396579 1.405469e+12
29 AUTO THEFT 3900 BLOCK MONTGOMERY BLVD NE 1396580 1.405469e+12
...............
24410 CREDIT CARD/ATM FRAUD 6100 BLOCK FLOR DE RIO NW 1420961 1.420502e+12
24411 AUTO THEFT 5300 BLOCK MONTGOMERY BLVD NE 1420962 1.420502e+12
24412 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE 1200 BLOCK SILVER AVE SW 1420963 1.420502e+12
24413 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 3000 BLOCK QUAIL POINTE DR NW 1420964 1.420502e+12
24414 FRAUD 2800 BLOCK MADISON ST NE 1420965 1.420502e+12
24415 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 1200 BLOCK SILVER AVE SW 1420966 1.420502e+12
24416 AUTO BURGLARY 6000 BLOCK TOPKE PL NE 1420967 1.420502e+12
24417 AUTO THEFT 500 BLOCK 4TH ST NW 1420968 1.420502e+12
24418 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 4200 BLOCK COE DR NE 1420969 1.420502e+12
24419 AUTO THEFT 3000 BLOCK EUBANK BLVD NE 1420970 1.420502e+12
24420 WEAPONS VIOLATION 100 BLOCK DEPUTY DEAN MIERA DR SW 1420971 1.418774e+12
24421 EMBEZZLEMENT, MISAPPROPRIATION 1600 BLOCK VALLEY RD SW 1420972 1.414454e+12
24422 AUTO THEFT 2000 BLOCK SHIPMAN RD SW 1420973 1.416787e+12
24423 LARCENY ALL OTHER 9900 BLOCK CLEARWATER ST NW 1420974 1.417565e+12
24424 DISORDERLY CONDUCT 4500 BLOCK BROADWAY BLVD SE 1420975 1.417565e+12
24425 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 200 BLOCK SUNNYSLOPE ST SW 1420976 1.417565e+12
24426 COMMERCIAL BURGLARY 8800 BLOCK 2ND ST NW 1420977 1.417565e+12
24427 DRUG/NARCOTICS VIOLATIONS 200 BLOCK WILLOW RD NW 1420978 1.418429e+12
24428 LARCENY ALL OTHER 2200 BLOCK CAMPANA CT SW 1420979 1.418342e+12
24429 SHOPLIFTING 5600 BLOCK EDITH BLVD NE 1420980 1.418342e+12
24430 DRUG/NARCOTICS VIOLATIONS 1000 BLOCK LA VEGA DR SW 1420981 1.417997e+12
24431 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 6000 BLOCK ISLETA BLVD SW 1420982 1.417997e+12
24432 POSSESSION OF DRUG PARAPHERNALIA N/A 1420983 1.417133e+12
24433 POSSESSION OF DRUG PARAPHERNALIA 2600 BLOCK COORS BLVD NW 1420984 1.418602e+12
24434 SIMPLE ASSAULT/BATTERY 500 BLOCK MUSCATEL AVE NE 1420985 1.417910e+12
24435 EMBEZZLEMENT, MISAPPROPRIATION 600 BLOCK VINEYARD RD NE 1420986 1.419034e+12
24436 AUTO THEFT 3200 BLOCK ISLETA BLVD SW 1420987 1.418947e+12
24437 AUTO THEFT 300 BLOCK DEL AKER RD NW 1420988 1.419034e+12
24438 AUTO THEFT 300 BLOCK EL PUEBLO RD NW 1420989 1.418774e+12
24439 LARCENY ALL OTHER 6000 BLOCK BECK RD SW 1420990 1.410912e+12
\n", "

24440 rows \u00d7 4 columns

\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 8, "text": [ " CVINC_TYPE \\\n", "0 LARCENY ALL OTHER \n", "1 SHOPLIFTING \n", "2 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE \n", "3 BURGLARY/BREAKING AND ENTERING \n", "4 THEFT FROM A BUILDING \n", "5 AUTO BURGLARY \n", "6 BURGLARY/BREAKING AND ENTERING \n", "7 VAGRANCY, BEGGING OR LOITERING \n", "8 COMMERCIAL BURGLARY \n", "9 DRIVING WHILE INTOXICATED \n", "10 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "11 AUTO BURGLARY \n", "12 THEFT FROM A BUILDING \n", "13 THEFT FROM A MOTOR VEHICLE \n", "14 SIMPLE ASSAULT/BATTERY \n", "15 SHOPLIFTING \n", "16 AGGRAVATED ASSAULT \n", "17 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE \n", "18 DRIVING WHILE INTOXICATED \n", "19 DISORDERLY CONDUCT \n", "20 AUTO BURGLARY \n", "21 SHOPLIFTING \n", "22 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "23 BURGLARY/BREAKING AND ENTERING \n", "24 DISORDERLY CONDUCT \n", "25 AUTO BURGLARY \n", "26 AUTO BURGLARY \n", "27 AUTO THEFT \n", "28 THEFT FROM A BUILDING \n", "29 AUTO THEFT \n", "... ... \n", "24410 CREDIT CARD/ATM FRAUD \n", "24411 AUTO THEFT \n", "24412 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE \n", "24413 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "24414 FRAUD \n", "24415 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "24416 AUTO BURGLARY \n", "24417 AUTO THEFT \n", "24418 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "24419 AUTO THEFT \n", "24420 WEAPONS VIOLATION \n", "24421 EMBEZZLEMENT, MISAPPROPRIATION \n", "24422 AUTO THEFT \n", "24423 LARCENY ALL OTHER \n", "24424 DISORDERLY CONDUCT \n", "24425 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "24426 COMMERCIAL BURGLARY \n", "24427 DRUG/NARCOTICS VIOLATIONS \n", "24428 LARCENY ALL OTHER \n", "24429 SHOPLIFTING \n", "24430 DRUG/NARCOTICS VIOLATIONS \n", "24431 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "24432 POSSESSION OF DRUG PARAPHERNALIA \n", "24433 POSSESSION OF DRUG PARAPHERNALIA \n", "24434 SIMPLE ASSAULT/BATTERY \n", "24435 EMBEZZLEMENT, MISAPPROPRIATION \n", "24436 AUTO THEFT \n", "24437 AUTO THEFT \n", "24438 AUTO THEFT \n", "24439 LARCENY ALL OTHER \n", "\n", " CV_BLOCK_ADD OBJECTID date \n", "0 7800 BLOCK CENTRAL AVE E 1396551 1.405469e+12 \n", "1 7800 BLOCK CENTRAL AV E 1396552 1.405555e+12 \n", "2 4300 BLOCK ZUNI RD SE 1396553 1.405555e+12 \n", "3 1200 BLOCK DICKERSON DR SE 1396554 1.405469e+12 \n", "4 1300 BLOCK VALLEY VIEW DR SW 1396555 1.405555e+12 \n", "5 1500 BLOCK GIBSON BLVD SE 1396556 1.405469e+12 \n", "6 2000 BLOCK SOUTHERN AVE SE 1396557 1.405469e+12 \n", "7 2100 BLOCK CENTRAL AV E 1396558 1.405555e+12 \n", "8 1400 BLOCK BROADWAY BL SE 1396559 1.405555e+12 \n", "9 7600 BLOCK MONTGOMERY BL NE 1396560 1.405642e+12 \n", "10 7000 BLOCK NATALIE JANAE LN NE 1396561 1.405642e+12 \n", "11 4800 BLOCK SPRING VALE RD NW 1396562 1.405469e+12 \n", "12 9500 BLOCK CANDELARIA RD NE 1396563 1.405469e+12 \n", "13 UNIT BLOCK HOTEL CI NE 1396564 1.405555e+12 \n", "14 13100 BLOCK CENTRAL AV E 1396565 1.405555e+12 \n", "15 3500 BLOCK COORS BLVD SW 1396566 1.405642e+12 \n", "16 3300 BLOCK RIO PLATA DR SW 1396567 1.405555e+12 \n", "17 3900 BLOCK 11TH ST NW 1396568 1.405555e+12 \n", "18 800 BLOCK RIO GRANDE BLVD NW 1396569 1.405555e+12 \n", "19 200 BLOCK LOMAS BLVD NW 1396570 1.405469e+12 \n", "20 1300 BLOCK OJO SARCO ST SW 1396571 1.405642e+12 \n", "21 1400 BLOCK RENAISSANCE BL NE 1396572 1.405555e+12 \n", "22 100 BLOCK UNION SQUARE ST SE 1396573 1.405642e+12 \n", "23 1000 BLOCK MOUNTAIN RD NW 1396574 1.405555e+12 \n", "24 3800 BLOCK CENTRAL AV E 1396575 1.405555e+12 \n", "25 900 BLOCK LOUISIANA BL NE 1396576 1.405555e+12 \n", "26 2000 BLOCK MENAUL BLVD NE 1396577 1.405642e+12 \n", "27 500 BLOCK ORTIZ DR SE 1396578 1.405469e+12 \n", "28 9100 BLOCK COPPER AV NE 1396579 1.405469e+12 \n", "29 3900 BLOCK MONTGOMERY BLVD NE 1396580 1.405469e+12 \n", "... ... ... ... \n", "24410 6100 BLOCK FLOR DE RIO NW 1420961 1.420502e+12 \n", "24411 5300 BLOCK MONTGOMERY BLVD NE 1420962 1.420502e+12 \n", "24412 1200 BLOCK SILVER AVE SW 1420963 1.420502e+12 \n", "24413 3000 BLOCK QUAIL POINTE DR NW 1420964 1.420502e+12 \n", "24414 2800 BLOCK MADISON ST NE 1420965 1.420502e+12 \n", "24415 1200 BLOCK SILVER AVE SW 1420966 1.420502e+12 \n", "24416 6000 BLOCK TOPKE PL NE 1420967 1.420502e+12 \n", "24417 500 BLOCK 4TH ST NW 1420968 1.420502e+12 \n", "24418 4200 BLOCK COE DR NE 1420969 1.420502e+12 \n", "24419 3000 BLOCK EUBANK BLVD NE 1420970 1.420502e+12 \n", "24420 100 BLOCK DEPUTY DEAN MIERA DR SW 1420971 1.418774e+12 \n", "24421 1600 BLOCK VALLEY RD SW 1420972 1.414454e+12 \n", "24422 2000 BLOCK SHIPMAN RD SW 1420973 1.416787e+12 \n", "24423 9900 BLOCK CLEARWATER ST NW 1420974 1.417565e+12 \n", "24424 4500 BLOCK BROADWAY BLVD SE 1420975 1.417565e+12 \n", "24425 200 BLOCK SUNNYSLOPE ST SW 1420976 1.417565e+12 \n", "24426 8800 BLOCK 2ND ST NW 1420977 1.417565e+12 \n", "24427 200 BLOCK WILLOW RD NW 1420978 1.418429e+12 \n", "24428 2200 BLOCK CAMPANA CT SW 1420979 1.418342e+12 \n", "24429 5600 BLOCK EDITH BLVD NE 1420980 1.418342e+12 \n", "24430 1000 BLOCK LA VEGA DR SW 1420981 1.417997e+12 \n", "24431 6000 BLOCK ISLETA BLVD SW 1420982 1.417997e+12 \n", "24432 N/A 1420983 1.417133e+12 \n", "24433 2600 BLOCK COORS BLVD NW 1420984 1.418602e+12 \n", "24434 500 BLOCK MUSCATEL AVE NE 1420985 1.417910e+12 \n", "24435 600 BLOCK VINEYARD RD NE 1420986 1.419034e+12 \n", "24436 3200 BLOCK ISLETA BLVD SW 1420987 1.418947e+12 \n", "24437 300 BLOCK DEL AKER RD NW 1420988 1.419034e+12 \n", "24438 300 BLOCK EL PUEBLO RD NW 1420989 1.418774e+12 \n", "24439 6000 BLOCK BECK RD SW 1420990 1.410912e+12 \n", "\n", "[24440 rows x 4 columns]" ] } ], "prompt_number": 8 }, { "cell_type": "code", "collapsed": false, "input": [ "import os\n", "#os.getcwd()" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 9 }, { "cell_type": "code", "collapsed": false, "input": [ "from pandas import ExcelWriter\n", "writer = ExcelWriter('CrimeIncidents.xlsx')\n", "myFrame.to_excel(writer,'Sheet1',index=False)\n", "writer.save()" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 10 }, { "cell_type": "code", "collapsed": false, "input": [ "myFrame[\"CVINC_TYPE\"].value_counts()" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 30, "text": [ "AUTO BURGLARY 3879\n", "VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 2601\n", "SHOPLIFTING 2557\n", "BURGLARY/BREAKING AND ENTERING 2539\n", "AUTO THEFT 1985\n", "LARCENY ALL OTHER 1920\n", "DRIVING WHILE INTOXICATED 1463\n", "FRAUD 1162\n", "THEFT FROM A BUILDING 794\n", "THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE 745\n", "DRUG/NARCOTICS VIOLATIONS 691\n", "COMMERCIAL BURGLARY 627\n", "AGGRAVATED ASSAULT 565\n", "EMBEZZLEMENT, MISAPPROPRIATION 323\n", "CREDIT CARD/ATM FRAUD 314\n", "DISORDERLY CONDUCT 312\n", "ROBBERY 250\n", "COUNTERFEITING/FORGERY 241\n", "DISTURBANCE 233\n", "SIMPLE ASSAULT/BATTERY 232\n", "THEFT FROM A MOTOR VEHICLE 199\n", "INTIMINDATION 154\n", "LIQ LAWS-SELL, TRANS, POSS, MANUF, FURNISH 123\n", "POSSESSION OF DRUG PARAPHERNALIA 118\n", "WEAPONS VIOLATION 86\n", "PROSTITUTION 75\n", "VAGRANCY, BEGGING OR LOITERING 58\n", "SHOOTING 49\n", "THEFT FROM COIN OPERATED MACHINE OR DEVICE 38\n", "ARSON 27\n", "MURDER AND NONNEGLIGENT MANSLAUGHTER 20\n", "WORTHLESS CHECKS 11\n", "DRUNKENNESS 10\n", "PURSE SNATCHING 10\n", "EXTORTION/BLACKMAIL 8\n", "PICK POCKETING 6\n", "WIRE FRAUD 6\n", "LOUD PARTY 5\n", "IMPERSONATION 4\n", "dtype: int64" ] } ], "prompt_number": 30 }, { "cell_type": "code", "collapsed": false, "input": [ "import matplotlib.pyplot as plt\n", "incidentType=myFrame[\"CVINC_TYPE\"].value_counts()[:5]\n", "incidentType.plot(kind='barh',rot=0)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 11, "text": [ "" ] }, { "metadata": {}, "output_type": "display_data", "png": "iVBORw0KGgoAAAANSUhEUgAAAkgAAAD7CAYAAACR32tdAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XucHXV9//HXGyEIhEoDBaoCQRBRsBLwh1CNHGjl4gUV\nbAGruPVWW6VF8YbaJq1KrRdEUattFdAqtQqiYLXWsmPBEiyShYRbBLJEFBVFbUBUCp/fH/M9ZDI5\n5+xsdk5mJryfj8c8MtfvvOe7uznfnfmcs4oIzMzMzGydLZoOYGZmZtY2HiCZmZmZlXiAZGZmZlbi\nAZKZmZlZiQdIZmZmZiUeIJmZmZmVbNl0ADMbTJI/g8PMbJYiQnW04ztIZi0WEa2flixZ0niGzSGj\nczpn26cu5KyTB0hmNifT09NNR5hRFzKCc9bNOevVlZx18QDJzMzMrMQDJDObk4mJiaYjzKgLGcE5\n6+ac9epKzrqo7md2ZlYPSeGfTzOz6iQRLtI2szbIsqzpCDPqQkZwzro5Z726krMuHiCZmZmZlfgR\nm1lL+RGbmdns+BGbmZmZ2Rh5gGRmc9KFuoQuZATnrJtz1qsrOeviPzVi1mJSLXeKzWo1OTnZdASz\nsXMNkllL5X+LzT+f1jaq/U86mNXFNUhmZmZmY+QBkpnNUdZ0gAqypgNUlDUdoJKu1KI4Z726krMu\nHiCZmZmZlbgGyaylXINk7eQaJGsv1yCZmZmZjZEHSNZKkp4n6QFJjyus60m6uLTfuZKOl3ShpOWS\nviPpZ2l+uaRDJM2TdFbatkrSRZIeNeCcy9Ixt0n6UZq/WtIekqYlLRiURdKEpDsL51wuaV9JCyXd\nW1r/V4X5+wvzrxlnf45X1nSACrKmA1SUNR2gkq7UojhnvbqSsy7+HCRrq5OAS9K/S0fsF0BExHEA\nkg4DXh8Rz+nvIOm9wHbAPhERkiaAC4GnrNdQxCFp/5cAB0XEnxfaKD9TiNL8+cX90zELgZsjYlHp\n2L9J29cO2GZmZi3gO0jWOpLmkw9eXgOcUOWQIfNI2haYAF7b/8NmEXEu8CtJR4xob9Az7GHnGbb/\nQ0Sv6QAV9JoOUFGv6QCV9Hq9piNU4pz16krOuvgOkrXRc4GvRsSa9OjqwIi4eiPb2htYExF3l9Zf\nBewHXDrgmEEVqAImJd2flucDNxS2nyDpaYXjD03ze0lanuYvj4hTZnsBZma26XmAZG10EvD+NP+5\ntHw1w9/StbFvqZnNcQH0IuIuWPcor7D9XwY8YgO4ZW6P0SaAhWl+B+AA1t1lyNK/TS/317Ulz6Dl\nctam8wxbngJObVGeQcvr16L07yr017VpeWpqilNPPbU1eYYtuz83frk/Pz09Te0iwpOn1kzAAuAe\nYBpYDawBbkvb9ie/C1Pc/4vA4sJyD7i4sLwd8GNgfum4bwCHD8nwEuDs0rrVwIJB5yEfxZw9oJ2F\nwIoR17p2hr4IiA5Mky3IsDlk7EpOYnJyMrrAOevVhZz5sKae1yPXIFnbvAD4ZEQsjIg9I2J3YLWk\nxcAq4JGS9gWQtAfwJPJfuweKiHuA84AzJW2RjjsZ2CYiJocc9hCuJ9oYvaYDVNBrOkBFvaYDVNKV\nWhTnrFdXctbFj9isbU4E3lVadwFwYkRcJulFwDmSHg7cB7wsItYW9o00FZ0OvBdYJekB8tqh54/I\nMKiNQctRmC/WIAH8KfCDAceNatPMzFrCn6Rt1lLd+STtjPbf+chof0boRk4xOTnZibsJWZY5Z426\nkNOfpG1mZmY2Rr6DZNZS3bmDZA8t/lts1l6+g2RmZmY2Rh4gmdkcZU0HqCBrOkBFWdMBKunK3+Ry\nznp1JWddPEAyMzMzK3ENkllLuQbJ2sk1SNZeddYg+XOQzFrNn1lpZtYEP2Iza7G6PjJ/nNPk5GTj\nGTaHjF3K2ZVaFOesV1dy1sUDJDMzM7MS1yCZtZSk8M+nmVl1/hwkMzMzszHyAMnM5qQLdQldyAjO\nWTfnrFdXctbFAyQzMzOzEtcgmbWUa5DMzGbHNUhmZmZmY+QBkpnNSRfqErqQEZyzbs5Zr67krIsH\nSGZmZmYlrkEyaynXIJmZzY5rkMzMzMzGyAMkM5uTLtQldCEjOGfdnLNeXclZFw+QzMzMzEpcg2TW\nUq5BMjObHdcgmZmZmY2RB0hmNiddqEvoQkZwzro5Z726krMuHiCZmZmZlbgGyaylXINkZjY7rkEy\nMzMzGyMPkMxsTrpQl9CFjOCcdXPOenUlZ122bDqAmQ0n1XKn2MwAP7K22XANkllLSQrwz6dZPeQB\n0kOAa5DMzMzMxsgDJDObo6zpABVkTQeoKGs6QEVZ0wEqypoOUElXanu6krMuHiCZmZmZlbgGyayl\nXINkVifXID0UuAbJzMzMbIw6MUCSdL+k5ZKmJH1b0qFpfU/SxaV9z5V0fJrPJN2YjrtC0hMK+82X\n9PeSbk5tXiXp5WnbQkkrRuS5SNIVpXVLJd2ecq6QdJyknSWtlrRLYb8PS3pzYfkqSfMkTUu6Nh1/\nraRjB1z/tZIulDS/kPPetK0/vahw3AGSHpB0VCnr3YX5Z0q6SdLu6RpOK/Tj7ZLmpeWdJK0uHPdY\nSZek/rtK0qWSFo/os7NSeyqsm0jX9sTCupWSdk/z/T65VtJ1kt4uaesh7ff7qD+9Ma3PJP1PYb8n\nS5qUdGRh37Xp+2S5pPMkHSbp56X2jqjwtViR5nup359dOO8lkg5L81tKOkPSqkL7bxnWd+2XNR2g\ngqzpABVlTQeoKGs6QEVZ0wEq6UptT1dy1qUTAyTgFxGxKCIOAE4H/nbEvsG65xIBvDAd9zHg7wr7\n/RPwk4jYOyIOAo4GFswURNIOwP7APEl7ls57ZkQsAp4P/ANwJ/Au4L3p2AOBpwHvSct7ArdHxK/T\n8b10/AuADw64/t8B/hf4k8K2m9O2/vTPhW0nAZekf8t9hKTfAz4AHB0Ra0p9B/B/wEsH9MHDgS8D\nH03992TgFOAxQ/psC+BY4HrgsNLm24G3lrMV5nvpug9O7X9s0DlY10f96d2Fbb8l6ejizhHxtf6+\nwFXk3yeLIuIlgIBvlNq7tHSeQV+Lma6rf23vAHYF9k/nXwxsNaQdMzNrQFcGSEWPAO7aiOOWAXsB\nSNoL+H8R8bb+xoj4celFdZjjgIuBzwEnlrYptXUzcB+wE/lAaS9JhwMfAl4dEfen/Y8Gvlo+ntHX\neEX/OkZJd2qOA14FHFG+8yLp6SnbsyJidXFT+jfIB0+vTQOcoj8CvhkRl/RXRMR1EXHekDg94Brg\nE6w/WAvyAdx+kvYZdT0RcU+6luelQWpVQT5AfesM+5WfWVd5hj3qa3EN8DNJv79eo9K2wMuBU9LA\nmIi4OyL+usL5WqrXdIAKek0HqKjXdICKek0HqKjXdIBKer1e0xEq6UrOunRlgLRNegxxA/CPwNtn\ncWz/he5oYGWa34/8BWxjnAh8FvhXNrwzk59QOgi4H/hx+mujfwpcANwYEZcXdj2KdQMkAZPpMU0G\n/OWAdh8GHFm4DsgHX8VHQU9N638XuCUivp/ae1bhmIcDXwCeGxGrRlzrGuBy4GTWv7OzH3D1iOPK\nTiLvs4uBZ6br6HsAeDcw4yOmiFgLrAYeO2DzNqV++IPCtiuAX0vqMbzqubx+cam94t3CYV+LsjOA\nt5XW7Q2sSQM+MzNrqa4MkO5NjzUeTz7Q+VRaP9OLnYBPS7oVWAK8btBxkt6SXgS/NyqE8lqivSNi\nWUTcSv6iu1/hXK+VtBK4Eviz/p9ij4hrgBXARwptzQMeHRHThUy9iHgi8ETgQ+luA6QXf+AOYDfg\no4VYt5QeBX0zrT+J/C4X6d/iYO7XwDfJ72SMEuSPM9/A+t8rQeEOi6QvKK+7uqDcQLrOY4CL06Dg\nSvKvIYU2PgMcImnhDHmKx5TdW+qHz5W2v4MNByujXFZqr3+XbdTXYj0RcRlAYdAKG37vTaTvvTWS\nHj2LfC2SNR2ggqzpABVlTQeoKGs6QEVZ0wEq6UptT1dy1qUrA6QHRcQyYCdJOwE/AX6ztMsC4Mf9\n3clrSx5DXnP0hrT+BuBJ/YLhiDgj1YL8xgyn/0NggfLC69XAQtYNPPo1SPuT1yAtLRYkk98peaCw\nvJj87syga7wV+CHQLyq/N+XbA/gl8NxRIdPdjeOBJSnn2cBRkrYrZPlD4GBJp5dPX8pyMzAFnFBY\nfR1wYGGf5wMTDK7hOgrYAViZsiymdOctPXJ8H/DmDQ9f77q2J+/zUXe9BomImAS2AQ6Z5bFls/pa\nAO9k/buBtwC794u7I+Lc1N7PGfjzOAEsTdNZrP8ffublzW55qmV5ur5c7M/1X+CzLPPyLJenpqbm\ndPw4lrMsY+nSpUxMTDAxMUGtIqL1E7C2ML8vefGzgK2BW4F907Y9gGlg+7Q8CRyU5h8O3AbsnpY/\nS/7itUVa3ga4O80vBFYMyPHfwFMKywvJi6QhfwU7rbDtIvLBGYUsBxaW3wMcWVheDeyY5ncmHyD9\n1oDrP4C82Fkjch4JfKW07lzgxcX2yAeXK4GXlq8BOAc4Ps0/IfXr6kJffQd4TqH9pwOTA7J8Bjih\nsLxturZtyF/9z07rtwJuBn5Q+BoV+2Q++Z3Dc2b6Himtf7Dfye9krQEuHbZPWu6R3/Ga6Xtx4Nei\nfDx5/dttwNPT8t+lr8fWaflhwE396y4cFxCePHmqZSJs85e+ztQxbUk39B9rQP5idHLqiF8pf1v7\nOemdVfcBL4u8VqUvACLil5I+QF7r8iryx0vvAW6W9BPgXtbdYQJ4nKTvFpY/AOwWEVc+2HDEtKSf\nSTo4nScK+/8N+Qv6Z4Zc02Fs+MhnUtL95IOFN0XEncVrSOecknQz+R2gZaQapEIbnwAWkdcYFV2Q\nrvtThT75aXp3139JunPANfT3u17St1O7RMS96S3sZ0o6i3zAs5ZSbVh6RHgU8MpC/l9Iuhx4TvF8\nEXFf+vqcNaBPRH535cLyOQq2KfXDVyJivbqmiPiKpB8NOX69XUk1SIV1b4+ICxn9tdig75J3kg+Y\n+96armOlpLXk33vnkj+2MzOzFvAnaTcg1Zp8LCKeNePO9pClznySdkb73y2U0f6M4Jx1y1iXs72f\npJ1lWSfeIdaFnKrxk7S7cgdpsxIRt7P+u8rMzMysRXwHyaylunMHyawL2nsHyepT5x2kzr2LzczM\nzGzcPEAysznKmg5QQdZ0gIqypgNUlDUdoKKs6QCVdOXzhbqSsy4eIJmZmZmVuAbJrKVcg2RWJ9cg\nPRS4BsnMzMxsjDxAMms1efLkqZapvbpS29OVnHXxAMmsxer6yPxxTpOTk41n2BwyOuf4c5rNhmuQ\nzFpKUvjn08ysOtcgmZmZmY2RB0hmNiddqEvoQkZwzro5Z726krMuHiCZmZmZlbgGyaylXINkZjY7\nrkEyMzMzGyMPkMxsTrpQl9CFjOCcdXPOenUlZ108QDIzMzMrcQ2SWUu5BsnMbHZcg2RmZmY2Rh4g\nmdmcdKEuoQsZwTnr5pz16krOuniAZGZmZlbiGiSzlnINkpnZ7LgGyczMzGyMPEAysznpQl1CFzKC\nc9bNOevVlZx18QDJzMzMrMQ1SGYt5RokM7PZcQ2SmZmZ2Rh5gGRmc9KFuoQuZATnrJtz1qsrOevi\nAZKZmZlZiWuQzFpKkn84zcbAr3ubrzprkLasoxEzGxf/R25Wr1peO+0hwI/YzGyOsqYDVJA1HaCi\nrOkAFWVNB6goazpAJV2p7elKzrp4gGRmZmZW4hoks5bKa5D882lWL7kGaTPmz0EyMzMzGyMPkMxs\njrKmA1SQNR2goqzpABVlTQeoKGs6QCVdqe3pSs66eIBkrSLprZJWSrpG0nJJB0vKJB1U2GehpBWF\n5adJulLSDWl6RWHbUkm3p7ZWSHpOYf1pA85/d+Ec96bj+tNfFebvL8yfImlJvz1J56ZzzkvLO0la\nXTjHYyVdIulmSVdJulTS4nH0p5mZbRy/zd9aQ9KhwLOARRFxn6QFwNbkhTgDiwYk7Qp8GnhuRExJ\n2hH4d0nfi4h/S8edGRFnStoXuEzSzsPaK62/OSIWlbb/TTrv2uI2SUtKx/4f8FLgo6W8Dwe+DLwu\nIi5J6/YDngxcNiRTy/WaDlBBr+kAFfWaDlBRr+kAFfWaDlBJr9drOkIlXclZF99BsjbZFfhxRNwH\nEBF3RcQdaduwortXA+dExFQ65ifAG4E3F/ZR2nYj+cBlpzFkL2YM4APAayWVf8b+CPhmf3CUcl0X\nEeeNKZOZmW0ED5CsTb4G7CbpJkkflvT0tF7Ap/uPtMjvwPTv1jwB+HapnW8D+5Ubl/QU4P6IuLNi\nnr0Kj9HOnuW1rAEuB05m/TtL+wFXz7KtlsuaDlBB1nSAirKmA1SUNR2goqzpAJV0pbanKznr4kds\n1hoRcU+qNVoMHA58VtKbyQcYL4yIqwEk7QFcUjh01Fs6RX4n50XAWuCEWUS6ZcAjtqoC+Fvgi+QD\nuuL6B/NK+gKwN7AqIo7fsJkJYGGa3wE4gHWPDbL0b9PLzLDdy9WXp1qWp+vLg/ozLaUX+/5jIy/P\nvDw1NdWqPH1ZljE9PU3d/DlI1lqSjgdeAmwPvD4ivp3WLwQujognSno78EBELCkcdwSwJCIOS7VB\nayPizFLbS4C7I+J9pfVrI2L74jmGZFsbEduX2lubap3OScdeKOnTwBXAaRGxp6SXAk+PiInCsQcB\n742Iw0vn8OcgmdXOn4O0OfPnINlmSdI+kh5bWLUIuG2Gwz4MTEh6UmpjR+BdwLuLTdcadDgNmH8n\n8PrC+vOBp/bfTZdsN+5gZmY2Ox4gWZvMB86VdJ2ka4B9gaVpW/lXvgCIiB8ALwL+UdINwDeBj0dE\n+bHWIG+T9N00rRmw76hfMwdt2+DYiLievCaqv3wv8GzgVZJukfTfwFuBt484V8tlTQeoIGs6QEVZ\n0wEqypoOUFHWdIBKulLb05WcdXENkrVGqjF66oBNh5f2mwZ+p7B8GXDwkDb/esT6DbZFxG8MOsew\n/QadJyL+uLTt+NLyTeQfZ2BmZi3lGiSzlnINktk4uAZpc+YaJDMzM7Mx8gDJzOYoazpABVnTASrK\nmg5QUdZ0gIqypgNU0pXanq7krIsHSGZmZmYlrkEyaynXIJmNg2uQNmeuQTIzMzMbIw+QzFpNnjx5\nqnVqn67U9nQlZ108QDJrsYho/TQ5Odl4hs0ho3NuupxmVbgGyaylJIV/Ps3MqnMNkpmZmdkYeYBk\nZnPShbqELmQE56ybc9arKznr4gGSmZmZWYlrkMxayjVIZmaz4xokMzMzszHyAMnM5qQLdQldyAjO\nWTfnrFdXctbFAyQzMzOzEtcgmbWUa5DMzGbHNUhmZmZmY+QBkpnNSRfqErqQEZyzbs5Zr67krIsH\nSGZmZmYlrkEyaynXIJmZzY5rkMzMzMzGyAMkM5uTLtQldCEjOGfdnLNeXclZFw+QzMzMzEpcg2TW\nUq5BMjObHdcgmZmZmY2RB0hmNiddqEvoQkZwzro5Z726krMuHiCZmZmZlbgGyaylXINkZjY7ddYg\nbVlHI2Y2HlItP+dmNoR/CbFh/IjNrNWiA9NkCzJsDhmdc9PnbIeu1PZ0JWddPEAyMzMzK3ENkllL\nSYo2/ZZrtvmRH7FtZvw5SGZmZmZj5AGSmc1R1nSACrKmA1SUNR2goqzpABVlTQeopCu1PV3JWZeR\nAyRJl0o6srTuVEkfSfM7SbpP0p+U9pmW9PnC8gsknZPmJyTdKelqSaskfVXSoaXjR7W7oLRuQtLZ\naf5xkjJJyyVdL+ljaX1P0gOSXlY47oC07rQZ+mAi7fd7hXXPS+uOm2vmtHyypBWSrk39clpaf66k\n49P8PElnSfpO6reLJD0qbVsoaUXpHEsL7RwiaVmhX5YMuM5RffS6AXmenbJOSbpO0itncz2Ffe8u\nX0PK8vOUtz8dkbbdX1q/+/CvHkjaRdJnJN0i6SpJ/y3peQPOc72kd5SOHfU1vbaQ4ZCU/97Cuqsl\nbdX/Wkt6S2Fb8RpOkbRkpu9DMzPbtGa6g3Q+cGJp3QnAZ9L8HwBfBU4acOyBkh6f5osPeQM4PyIO\njIh9gHcBF0rat7DPsHYHPSwuvh3hg8D7ImJRRDwBOLuw30rgDwvLJwHXDGmz3P4K1u+Hk4Cp0n6z\nzQyApGOAvwCeERG/AxwC/LywX3/fM4DtgH1Sv10EXDhD7v6x5wGviIhFwH7Avw7Zf1gfrdempK2A\njwHPjogDgANIv6rN4no26IuSb6SvY3+6NK3/RWn9mmEdIEnk/ZRFxF4R8WTyr+OjC7v9V+qXA4Hj\nJR1U2Dbqa9orZFiW1t9cWHdgRNzXv76IOKO/rXQNZ9N5vaYDVNBrOkBFvaYDVNRrOkBFvaYDVNLr\n9ZqOUElXctZlpgHSBcCzJG0J+W/5wCMj4vK0/UTgbcDO/bsZSQDvA96alosFUyouR0QG/APwysI+\nw9odpt/ersD3Cm2vLOS5Ddha0s7phfMo4CulbMNcBhwsaUtJ84G9yAcOxWNnm7nvdOC0iPhByvzr\niPin9S5O2haYAF7b/+TAiDgX+FX/zsoMfgvotx8RccOQ/ar20fbkn6F1V2rzvohYVfF6qhbP1VFk\ndwTwq4j4h/6KiFgTER8q7xgRvyQf9O5VWD3qa+oPKDIz24yNHCBFxF3At4BnplUnAp8FkLQbsHNE\nXAN8nvzOUtHnyO8i7cXMrgb2rdjuKO8HLpX0b8ofBT6itP3z5HcFDk3n/FXFdgP4D/IBw7HAl4ob\n55h5P+DbI7YL2BtYExF3l7ZdlY4fdhem/yL+fuAmSRdKeqWkrUecb8Y+St8XXwJuS4+vXpgGVDNd\nj4D3FB+Rjci+uPQobc+0ftvCugtGXEc/y9Uz7JMHyx+DHgxcl5ZHfU0FTKYMVxTW71XIdnZh381c\n1nSACrKmA1SUNR2goqzpABVlTQeopCu1PV3JWZcqRdrFx2wnpOX+fL/O6HNs+BjifuA95HcUZnqM\nVcwxU7tDpbsqj0/H9YBlkuax7kXqc+SPkE4qXEdVn03HnVg4tn9dG525olH9N+oTz/p3m94OPBn4\nGvBC8sdGZVX7SKnNVwC/Rz6Afj3wiZFXsC7P64uPyBg+gLis9ChtdVpffDx1/JBji+dbF1z6UKqZ\n+lZh9WJJU8B3gYsi4rq0ftTXtPiIrVg/d0sh2ymDMpiZWTdU+VMjXwLeL2kRsG1ELE/rTwJ2kfSi\ntPzbkvaKiFvScgCfIh8grWS0RcD1FdsdKSLuAM4BzklFv/sVtv1Q0q+B3yevk/ndKm2mY/9H0v7A\nPRHxHa3/JyDmkvk68sHL5LBTA7cAu0uaX7qLdBBwMfmjrt8sHbcjcGsh/63ARyX9I3CnpN+MiJ8O\nuM5BfTTwRT49wlwp6VPAauCPK1zPpryjch3w4CAqIl4jaUfyO299l0XEc9Lj40lJZ0XEd5nj92F9\nJoCFaX4H8nKvXlrO0r9ennm517I8o5aZYXsblnstyzNqmUrb+3dH+nU2m3K51+s1ev7ZLPe1KU+W\nZUxPT1O7iJhxAv6FvD5jSVreB7ixtM9S4C/T/GpgQZr/U2AN8Im0PAGcXTjuMOAO4HEV292xtP3B\n9oCjga3S/K7A94GdyX8iLk7rDwWOTfNLyOtlAF4DvHrAtZfbPyzNn0P+4jvXzMeQv2DvkpbnAS8r\nnOO4NP8+8lqtLdLyycC3Cm3+D3B4ml8A3ATsmZafVdjv8cCPSB8SWlhfpY/617wd+R2U/rG/D1xb\n8XqOL513bfp3IbCinGXA12PtgHWPAr4+ZP9lwKsKy7sDqwedBzg19XHl7+/C9gfzD/taD7uGYh+X\n1geEJ0+exjYRtnlJX1PqmKp+DtL5wBNZ98jlRDZ8B9UFbPiON4CPAw8rLAdwQqrTuAl4M/kg4KaK\n7V4r6btpel9qL9K2ZwAr0iOTr5I/zvlRcZ+IuCIiijVE/WP3BX48IH/x2K9GxDdK2+eUOSK+AnwI\n+LqkleT1O9sPyHE68EtglaRV5AOV5xe2nwz8Zarr+U9gaax7LPUiSTelbZ8E/ih9Iw27zmF91J8X\n8AZJN6Y2l5APBKpcz6DzDpov1yAdN2Cfvt8G/m/AeoDnAYdJulXSlcC5wBvL15x8lHwQPJvv72HX\nUlw36ppHreuIrOkAFWRNB6goazpARVnTASrKmg5QSVdqe7qSsy7+UyOJpIuB50fEsBdaaylJrwZu\ni4hLms5SJ3XmT41ktP/t1BntzwjOWbeM0Tnb8adGsizrxFvou5BTNf6pEQ+QzFqqOwMks65qxwDJ\n6lPnAMl/asTMzMysxAMkM5ujrOkAFWRNB6goazpARVnTASrKmg5QSVdqe7qSsy4eIJmZmZmVuAbJ\nrKVcg2Q2bq5B2ty4BsnMzMxsjDxAMrM5ypoOUEHWdICKsqYDVJQ1HaCirOkAlXSltqcrOetS5U+N\nmFljHgJ/69bMrIVcg2TWUpIGfOC5mZkN4xokMzMzszHyAMnM5qQLdQldyAjOWTfnrFdXctbFAyQz\nMzOzEtcgmbWUa5DMzGbHNUhmZmZmY+QBkpnNSRfqErqQEZyzbs5Zr67krIsHSGZmZmYlrkEyaynX\nIJmZzY5rkMzMzMzGyAMkM5uTLtQldCEjOGfdnLNeXclZFw+QzMzMzEpcg2TWUq5BMjObHdcgmZmZ\nmY2RB0hmNiddqEvoQkZwzro5Z726krMuHiCZmZmZlbgGyaylXINkZjY7rkEyMzMzGyMPkMxsTrpQ\nl9CFjOCcdXPOenUlZ108QDIzMzMrcQ2SWUu5BsnMbHbqrEHaso5GzGw8pFp+zs3MOm9T/8LoR2xm\nrRYdmCZbkGFzyOicztn2qcmcm54HSGZmZmYlrkEyaylJ0dRvTmZm7aJKj9j8OUhmZmZmY+QBkpnN\nUdZ0gAqypgNUlDUdoKKs6QAVZU0HqChrOkBFWdMBNikPkMzMzMxKPECyOZH0PEkPSHpcYV1P0sWl\n/c6VdLykCyUtl/QdST9L88slHSJpnqSz0rZVki6S9Kgh552WdG069lpJx6b1CyWtKO27VNJphRy3\npuOulrRE0xX1AAAJgElEQVS4sN+Wks5I5+7nekth+90j+uEsSber8L58SROS7kztXC/pzyRtLekG\nSfsX9nuDpI9W6e926jUdoIJe0wEq6jUdoKJe0wEq6jUdoKJe0wEq6jUdYJPyAMnm6iTgkvTvKAFE\nRBwXEYuAlwOXRcSiNC0DzgC2A/aJiH2Ai4ALR7TXS229APjgTOcuzL8+Hfc64COF/d4B7Arsn7Yv\nBrYqtbMBSVsAxwLXA4eV9j8/tfU0YAnwCODU/nnTAPBPgDeNyG9mZpuYB0i20STNB54CvAY4ocoh\nQ+aRtC0wAby2//HREXEu8CtJR8zQ3iOAuzbi3MuAvQrnfzlwSkT8Op3/7oj46xnahfzXqmuAT7Dh\nQFGprbuAW4E9IuLfgTskvQR4P7AkIn5e4TwtlTUdoIKs6QAVZU0HqChrOkBFWdMBKsqaDlBR1nSA\nTcoDJJuL5wJfjYg1wJ2SDpxDW3sDayKi/BjrKmC/AfsLmEyP0zLgbRtxzqOBlaXz37MR7ZwEfBa4\nGHimpIdtEFbaA3gMcEtadSrwTmDHiPj0RpzTzMzGyH9qxObiJPI7IACfS8tXM/zDezb2Q30GHdd/\nxHaXpMcA/ylpvwrnFvAeSWcAewBPHbSzpAngL4AdgUMj4ntD9psHHAOcGhH3SLqSfOD15XSuEyQ9\nHdiX/NHeXQARcYek/yQfVI0wASxM8zsAB7CuDiBL/3p55uVey/KMWmaG7W1Y7rUsz6hlZtjehuVe\ny/KMWmaG7eNahizL6PV6D84X109PT1O7iPDkadYTsAC4B5gGVgNrgNvStv2By0v7fxFYXFjuARcX\nlrcDfgzMLx33DeDwAedfDSwoLC8DngzMB24v7ftB4MVp/hzguDT/GuCLaX7bIedfAeye5tcOyPEc\n4O6UZzXwQ+Cf07YJ4INp/iDyu0fzC8eeAxw/oo8DwpMnT548QVSR9qOOyY/YbGO9APhkRCyMiD0j\nYndgdXpX2CrgkZL2hQcfLz0JmBrWWOSPts4DzkxFz0g6GdgmIiaHHKa0387AnuQDtLvJ63sOT9sW\nAEcBl5ePi4gPAbtJOjQifgF8HPiQpK3TsQ8D5s3QDycBL0t9sGfK8QxJ25TO9W3yu0V/PkN7HZQ1\nHaCCrOkAFWVNB6goazpARVnTASrKmg5QUdZ0gE3Kj9hsY50IvKu07gLgxIi4TNKLgHMkPRy4j3wQ\nsbawb6Sp6HTgvcAqSQ8ANwDPH5FhUtL95O80e1NE3JnWnwx8WNKZaXlpRKwunbvvHeTvLjsaeCvw\ndmClpLXAvcC5wPfTvttK+m7h2I8ARwKvfLDhiF9Iupz8zlL5Gv8O+Jaks9KArJzFzMxawn+Lzayl\n/LfYzMz6/LfYzMzMzBrnAZKZzVHWdIAKsqYDVJQ1HaCirOkAFWVNB6goazpARVnTATYpD5DMzMzM\nSlyDZNZSrkEyM+tzDZKZmZlZ4zxAMrM5ypoOUEHWdICKsqYDVJQ1HaCirOkAFWVNB6goazrAJuUB\nkpmZmVmJPyjSrNVqeZRuZmaz5AGSWYv5TRRmZs3wIzYzm5PiX9Vuqy5kBOesm3PWqys56+IBkpmZ\nmVmJPwfJrKUkhX8+zcyq8+cgmZmZmY2RB0hmNiddqEvoQkZwzro5Z726krMuHiCZ2ZxMTU01HWFG\nXcgIzlk356xXV3LWxQMkM5uTn/3sZ01HmFEXMoJz1s0569WVnHXxAMnMzMysxAMkM5uT6enppiPM\nqAsZwTnr5pz16krOuvht/mYtJck/nGZms1TX2/w9QDIzMzMr8SM2MzMzsxIPkMzMzMxKPEAyaxlJ\nR0u6UdJ3JL2pBXmmJV0rabmkb6V1CyT9h6RVkr4maYfC/qen7DdKOnKMuT4h6YeSVhTWzTqXpIMk\nrUjbPrAJMi6VdHvqz+WSjmkyY2p/N0mTkq6TtFLSn6f1bevPYTlb1aeSHi7pSklTkq6X9Ldpfdv6\nc1jOVvVnav9hKcvFaXn8fRkRnjx5askEPAy4GVgIbAVMAY9vONNqYEFp3buBN6b5NwHvSvNPSJm3\nStdwM7DFmHItBhYBKzYyV78G81vAwWn+34Cjx5xxCfC6Afs2kjG1uStwQJqfD9wEPL6F/TksZxv7\ndNv075bAMuBpbevPETnb2J+vAz4NfCktj70vfQfJrF0OBm6OiOmIuA/4F+C5DWcCKL8r5FjgvDR/\nHvC8NP9c4PyIuC8ipsn/czp4HIEi4jLgp3PI9RRJvw1sHxHfSvt9snDMuDLChv3ZWMaU8wcRMZXm\n7wZuAB5F+/pzWE5oX5/+Is3OI//F56e0rD9H5IQW9aekRwPPBP6pkGvsfekBklm7PAr4bmH5dta9\nADQlgK9LukrSK9K6XSLih2n+h8Auaf6R5Jn7NnX+2eYqr/8emybvKZKukfTxwqOBVmSUtJD8rteV\ntLg/CzmXpVWt6lNJW0iaIu+3yYi4jhb255Cc0K7+fD/wBuCBwrqx96UHSGbt0sbP3XhqRCwCjgFe\nLWlxcWPk96tH5W7kmirkasrfA3sCBwB3AO9rNs46kuYDFwB/ERFri9va1J8p5+fJc95NC/s0Ih6I\niAOARwNPl3R4aXsr+nNAzh4t6k9JzwZ+FBHLGXxXa2x96QGSWbt8D9itsLwb6//Ws8lFxB3p3zuB\nL5A/MvuhpF0B0q3rH6Xdy/kfndZtKrPJdXta/+jS+rHmjYgfRUL+yKD/CLLRjJK2Ih8cfSoiLkqr\nW9efhZz/3M/Z1j5N2X4OfBk4iBb254CcT25Zf/4ucKyk1cD5wBGSPsUm6EsPkMza5SrgsZIWSpoH\nnAB8qakwkraVtH2a3w44EliRMr0k7fYSoP+C+iXgREnzJO0JPJa8MHJTmVWuiPgB8L+SniJJwIsL\nx4xF+s+87/nk/dloxtTux4HrI+KswqZW9eewnG3rU0k79R9LSdoGeAawnPb158Cc/YFH0mh/RsRb\nImK3iNgTOBG4NCJezKboy42tKPfkydN4JvJHWTeRFxee3nCWPcnfETIFrOznARYAXwdWAV8Ddigc\n85aU/UbgqDFmOx/4PvBr8rqtP96YXOS/2a9I2z445owvJS8OvRa4Jv0HvUuTGVP7TyOv75gifyFf\nDhzdwv4clPOYtvUp8ETg6pTzWuANG/tz01DOVvVn4RyHse5dbGPvS/+pETMzM7MSP2IzMzMzK/EA\nyczMzKzEAyQzMzOzEg+QzMzMzEo8QDIzMzMr8QDJzMzMrMQDJDMzM7MSD5DMzMzMSv4/E6AYBzsm\nE2UAAAAASUVORK5CYII=\n", "text": [ "" ] } ], "prompt_number": 11 }, { "cell_type": "code", "collapsed": false, "input": [ "#print myFrame[(myFrame.date>1420930000000)]\n", "import datetime\n", "import time\n", "myDate=datetime.datetime(2015,1,10)\n", "#myDate.isoformat()\n", "milli=time.mktime(myDate.timetuple()) * 1000+ myDate.microsecond / 1000\n", "print len(myFrame[(myFrame.date>milli)])\n", "print milli" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "20\n", "1.4208732e+12\n" ] } ], "prompt_number": 14 }, { "cell_type": "code", "collapsed": false, "input": [ "myFrame[(myFrame.date>milli)]" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
CVINC_TYPECV_BLOCK_ADDOBJECTIDdate
17579 DRIVING WHILE INTOXICATED 9000 BLOCK CENTRAL SW 1414130 1.420934e+12
17585 AUTO BURGLARY 4400 BLOCK THE 25 WAY NE 1414136 1.420934e+12
17605 EMBEZZLEMENT, MISAPPROPRIATION 4300 BLOCK NANDINA CT NW 1414156 1.420934e+12
17620 DISTURBANCE 900 BLOCK SAN PEDRO DR NE 1414171 1.420934e+12
17621 AUTO THEFT 3300 BLOCK WELLESLEY CT NE 1414172 1.420934e+12
17624 AUTO BURGLARY 3300 BLOCK WELLESLEY NE 1414175 1.420934e+12
17636 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 1200 BLOCK CHELWOOD PARK BL NE 1414187 1.420934e+12
17637 AUTO BURGLARY 1600 BLOCK PENNSYLVANIA ST NE 1414188 1.420934e+12
17643 AUTO THEFT 5800 BLOCK HARPER DR NE 1414194 1.420934e+12
17747 DISTURBANCE 3100 BLOCK CENTRAL AVE E 1414298 1.420934e+12
17748 SHOPLIFTING 2200 BLOCK Q ST NE 1414299 1.420934e+12
17749 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 8500 BLOCK VISTA CLARA LN SW 1414300 1.420934e+12
17750 DISORDERLY CONDUCT 900 BLOCK LOUISIANA BL NE 1414301 1.420934e+12
17759 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE 600 BLOCK CHAMA ST SE 1414310 1.420934e+12
17760 COMMERCIAL BURGLARY 3300 BLOCK COLUMBIA DR. NE 1414311 1.420934e+12
17761 DISORDERLY CONDUCT 1000 BLOCK LOUISIANA BLVD SE 1414312 1.420934e+12
17765 SHOPLIFTING 6600 BLOCK MENAUL BL NE 1414316 1.420934e+12
17766 DRUG/NARCOTICS VIOLATIONS 6600 BLOCK MENAUL BL NE 1414317 1.420934e+12
17778 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI 1800 BLOCK ZENA LONA CT NE 1414329 1.420934e+12
17779 AGGRAVATED ASSAULT 1100 BLOCK CENTRAL SE 1414330 1.420934e+12
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 15, "text": [ " CVINC_TYPE \\\n", "17579 DRIVING WHILE INTOXICATED \n", "17585 AUTO BURGLARY \n", "17605 EMBEZZLEMENT, MISAPPROPRIATION \n", "17620 DISTURBANCE \n", "17621 AUTO THEFT \n", "17624 AUTO BURGLARY \n", "17636 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "17637 AUTO BURGLARY \n", "17643 AUTO THEFT \n", "17747 DISTURBANCE \n", "17748 SHOPLIFTING \n", "17749 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "17750 DISORDERLY CONDUCT \n", "17759 THEFT OF MOTOR VEHICLE PARTS OR ACCESSORIE \n", "17760 COMMERCIAL BURGLARY \n", "17761 DISORDERLY CONDUCT \n", "17765 SHOPLIFTING \n", "17766 DRUG/NARCOTICS VIOLATIONS \n", "17778 VANDALISM, MALICIOUS MISCHIEF, GRAFFITI \n", "17779 AGGRAVATED ASSAULT \n", "\n", " CV_BLOCK_ADD OBJECTID date \n", "17579 9000 BLOCK CENTRAL SW 1414130 1.420934e+12 \n", "17585 4400 BLOCK THE 25 WAY NE 1414136 1.420934e+12 \n", "17605 4300 BLOCK NANDINA CT NW 1414156 1.420934e+12 \n", "17620 900 BLOCK SAN PEDRO DR NE 1414171 1.420934e+12 \n", "17621 3300 BLOCK WELLESLEY CT NE 1414172 1.420934e+12 \n", "17624 3300 BLOCK WELLESLEY NE 1414175 1.420934e+12 \n", "17636 1200 BLOCK CHELWOOD PARK BL NE 1414187 1.420934e+12 \n", "17637 1600 BLOCK PENNSYLVANIA ST NE 1414188 1.420934e+12 \n", "17643 5800 BLOCK HARPER DR NE 1414194 1.420934e+12 \n", "17747 3100 BLOCK CENTRAL AVE E 1414298 1.420934e+12 \n", "17748 2200 BLOCK Q ST NE 1414299 1.420934e+12 \n", "17749 8500 BLOCK VISTA CLARA LN SW 1414300 1.420934e+12 \n", "17750 900 BLOCK LOUISIANA BL NE 1414301 1.420934e+12 \n", "17759 600 BLOCK CHAMA ST SE 1414310 1.420934e+12 \n", "17760 3300 BLOCK COLUMBIA DR. NE 1414311 1.420934e+12 \n", "17761 1000 BLOCK LOUISIANA BLVD SE 1414312 1.420934e+12 \n", "17765 6600 BLOCK MENAUL BL NE 1414316 1.420934e+12 \n", "17766 6600 BLOCK MENAUL BL NE 1414317 1.420934e+12 \n", "17778 1800 BLOCK ZENA LONA CT NE 1414329 1.420934e+12 \n", "17779 1100 BLOCK CENTRAL SE 1414330 1.420934e+12 " ] } ], "prompt_number": 15 } ], "metadata": {} } ] }