# coding: utf-8 # In[1]: import urllib, urllib2 param = {'where':'1=1','outFields':'*','f':'json'} url = 'http://coagisweb.cabq.gov/arcgis/rest/services/public/APD_Incidents/MapServer/0/query?' + urllib.urlencode(param) rawreply = urllib2.urlopen(url).read() # In[2]: rawreply[0] # In[3]: type(rawreply) # In[4]: import simplejson reply = simplejson.loads(rawreply) print reply["features"][0]["attributes"]["date"] print reply["features"][0]["attributes"]["CVINC_TYPE"] # In[5]: print len(reply["features"]) #reply["features"][:3] reply["features"][2:5] # In[6]: count = 0 myformateddata=[] while (count < len(reply["features"])): mydict={} for key, value in reply["features"][count]["attributes"].iteritems(): mydict[key]= value myformateddata.append(mydict) count = count + 1 # In[7]: from pandas import DataFrame as df myFrame = df(data=myformateddata) len(myFrame) # In[8]: myFrame # In[9]: import os #os.getcwd() # In[10]: from pandas import ExcelWriter writer = ExcelWriter('CrimeIncidents.xlsx') myFrame.to_excel(writer,'Sheet1',index=False) writer.save() # In[30]: myFrame["CVINC_TYPE"].value_counts() # In[11]: import matplotlib.pyplot as plt incidentType=myFrame["CVINC_TYPE"].value_counts()[:5] incidentType.plot(kind='barh',rot=0) # In[14]: #print myFrame[(myFrame.date>1420930000000)] import datetime import time myDate=datetime.datetime(2015,1,10) #myDate.isoformat() milli=time.mktime(myDate.timetuple()) * 1000+ myDate.microsecond / 1000 print len(myFrame[(myFrame.date>milli)]) print milli # In[15]: myFrame[(myFrame.date>milli)]
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question