JSON Processing Using Python -

-

i'm trying download json file, save file, , iterate through json file in order extract information , save variables. i'm going format message in csv format send data system. problem json data. appears dictionary within list , i'm not sure how process it.

here's json:

[ {   "ipaddress" : "",   "feeddescription" : "botted node feed",   "bnfeedversion" : "1.1.4",   "generatedts" : "2013-08-01 12:00:10.360+0000",   "count" : 642903,   "firstdiscoveredts" : "2013-07-21 19:07:20.627+0000",   "lastdiscoveredts" : "2013-08-01 00:34:41.052+0000",   "threattype" : "bn",   "confidence" : 82,   "discoverymethod" : "spamtrap",   "indicator" : true,   "supportingdata" : {     "behavior" : "spamming",     "botnetname" : null,     "spamtrapdata" : {       "uniquesubjectcount" : 88     },     "p2pdata" : {       "connect" : null,       "port" : null     }   } }, {   "ipaddress" : "",   "feeddescription" : "botted node feed",   "bnfeedversion" : "1.1.4",   "generatedts" : "2013-08-01 12:00:10.360+0000",   "count" : 28,   "firstdiscoveredts" : "2013-07-19 03:19:08.622+0000",   "lastdiscoveredts" : "2013-08-01 01:44:04.009+0000",   "threattype" : "bn",   "confidence" : 40,   "discoverymethod" : "spamtrap",   "indicator" : true,   "supportingdata" : {     "behavior" : "spamming",     "botnetname" : null,      "spamtrapdata" : {       "uniquesubjectcount" : 9     },     "p2pdata" : {       "connect" : null,       "port" : null     }   } }, {   "ipaddress" : "",   "feeddescription" : "botted node feed",   "bnfeedversion" : "1.1.4",   "generatedts" : "2013-08-01 12:00:10.360+0000",   "count" : 160949,   "firstdiscoveredts" : "2013-07-16 18:52:33.881+0000",   "lastdiscoveredts" : "2013-08-01 03:14:59.452+0000",   "threattype" : "bn",   "confidence" : 82,    "discoverymethod" : "spamtrap",   "indicator" : true,   "supportingdata" : {     "behavior" : "spamming",     "botnetname" : null,     "spamtrapdata" : {       "uniquesubjectcount" : 3     },      "p2pdata" : {       "connect" : null,        "port" : null     }   }  } ]

my code:

download = 'https:url.bnfeed20130801.json'  request = requests.get(download, verify=false) out  = open(filename, 'w') row in request:     if row.strip():          column in row:                  out.write(column)     else:         continue out.close() time.sleep(4) jsonrequest = request.json()  item in jsonrequest:      print jsonrequest[0]['ipaddress']      print jsonrequest[item]['ipaddress'] --i tried

when above prints same ip on , on again. i've put in print statement testing purposes only. once figure out to access different elements of json store in variables , use these variables accordingly. appreciated.

thanks in advance help. i'm using python 2.6 on linux.

you iterating on list of dicts, try item['ipaddress'].


Comments

Post a Comment

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

-
the current version of mozilla firefox 23.0.1, version not support play mp3 shoutcast streams tcp port different 80 (most common 8000 shoutcast 1.9.8). i use flash when mp3 support not available in html5 audio, way detect is: try{ var = document.createelement('audio'); r = !!(a.canplaytype && !!a.canplaytype("audio/mpeg; codecs=mp3").replace(/^no$/,'')) }catch(e){ r = false; } the support mp3 shoutcast streams in firefox added in version 24 . a.canplaytype("audio/mpeg; codecs=mp3") = in chrome , firefox, chrome support, firefox not support, due current code detect not work firefox. the current version of jquery support ie 6 1.10.2, version not has .browser i think "stylized" way testing features , not querying browsers / versions, notwithstanding here see hard not violate "principle". what "stylized" way of detect mp3 icy support without navigator.useragent in firefox? ther...
Read more

web - SVG not rendering properly in Firefox -

-
i have problem svg renderring in firefox. whilst works in safari, chrome or in ie, doesn't work in firefox. inspecting element seems layers there, background visible if it's z-index higher z-index of others. rendered in firefox: svg logo in firefox link original source file: svg file thanks help. ps: used sketch 3 export svg. if helps somehow. you're experiencing bug 995813 . i fixed bug time ago change still making way through release process example display correctly firefox 31 onwards released on 22 july 2014. in meantime if move fill="white" <mask> element child <use> element work around firefox bug.
Read more

java - JavaFX 2 slider labelFormatter not being used -

-
i have following code not label slider "foo50", etc... 1 expect setlabelformatter call, instead seems have no effect (the slider labelled 50, 100, etc , println's dont run). there missing? not implemented in default 2.2 skin? using oracle java 7 package javafxbugtest; import javafx.application.application; import javafx.scene.*; import javafx.scene.control.*; import javafx.stage.*; import javafx.util.stringconverter; public class javafxbugtest extends application { @override public void start(final stage primarystage) { slider cp = new slider(); cp.setlabelformatter(new stringconverter<double>() { @override public string tostring(double t) { system.out.println("nope?"); return "foo" + t.tostring(); } @override public double fromstring(string string) { system.out.println("he...
Read more