Python json.loads shows ValueError: Extra data -


i getting data json file "new.json", , want filter data , store new json file. here code:

import json open('new.json') infile:     data = json.load(infile) item in data:     iden = item.get["id"]     = item.get["a"]     b = item.get["b"]     c = item.get["c"]     if c == 'xyz' or  "xyz" in data["text"]:         filename = 'abc.json'     try:         outfile = open(filename,'ab')     except:         outfile = open(filename,'wb')     obj_json={}     obj_json["id"] = iden     obj_json["val_a"] =     obj_json["val_b"] = b

and getting error, traceback is:

  file "rtfav.py", line 3, in <module>     data = json.load(infile)   file "/usr/lib64/python2.7/json/__init__.py", line 278, in load     **kw)   file "/usr/lib64/python2.7/json/__init__.py", line 326, in loads     return _default_decoder.decode(s)   file "/usr/lib64/python2.7/json/decoder.py", line 369, in decode     raise valueerror(errmsg("extra data", s, end, len(s))) valueerror: data: line 88 column 2 - line 50607 column 2 (char 3077 - 1868399)

can me?

here sample of data in new.json, there 1500 more such dictionaries in file

{     "contributors": null,      "truncated": false,      "text": "@homeshop18 #dreamjob professional rafter",      "in_reply_to_status_id": null,      "id": 421584490452893696,      "favorite_count": 0,      "source": "<a href=\"https://mobile.twitter.com\" rel=\"nofollow\">mobile web (m2)</a>",      "retweeted": false,      "coordinates": null,      "entities": {         "symbols": [],          "user_mentions": [             {                 "id": 183093247,                  "indices": [                     0,                      11                 ],                  "id_str": "183093247",                  "screen_name": "homeshop18",                  "name": "homeshop18"             }         ],          "hashtags": [             {                 "indices": [                     12,                      21                 ],                  "text": "dreamjob"             }         ],          "urls": []     },      "in_reply_to_screen_name": "homeshop18",      "id_str": "421584490452893696",      "retweet_count": 0,      "in_reply_to_user_id": 183093247,      "favorited": false,      "user": {         "follow_request_sent": null,          "profile_use_background_image": true,          "default_profile_image": false,          "id": 2254546045,          "verified": false,          "profile_image_url_https": "https://pbs.twimg.com/profile_images/413952088880594944/rcdr59oy_normal.jpeg",          "profile_sidebar_fill_color": "171106",          "profile_text_color": "8a7302",          "followers_count": 87,          "profile_sidebar_border_color": "bcb302",          "id_str": "2254546045",          "profile_background_color": "0f0a02",          "listed_count": 1,          "profile_background_image_url_https": "https://abs.twimg.com/images/themes/theme1/bg.png",          "utc_offset": null,          "statuses_count": 9793,          "description": "rafter. rafting do. me aur mera tablet.  technocrat of future",          "friends_count": 231,          "location": "",          "profile_link_color": "473623",          "profile_image_url": "http://pbs.twimg.com/profile_images/413952088880594944/rcdr59oy_normal.jpeg",          "following": null,          "geo_enabled": false,          "profile_banner_url": "https://pbs.twimg.com/profile_banners/2254546045/1388065343",          "profile_background_image_url": "http://abs.twimg.com/images/themes/theme1/bg.png",          "name": "jayy",          "lang": "en",          "profile_background_tile": false,          "favourites_count": 41,          "screen_name": "jzayypsingh",          "notifications": null,          "url": null,          "created_at": "fri dec 20 05:46:00 +0000 2013",          "contributors_enabled": false,          "time_zone": null,          "protected": false,          "default_profile": false,          "is_translator": false     },      "geo": null,      "in_reply_to_user_id_str": "183093247",      "lang": "en",      "created_at": "fri jan 10 10:09:09 +0000 2014",      "filter_level": "medium",      "in_reply_to_status_id_str": null,      "place": null }

as can see in following example, json.loads (and json.load) not decode multiple json object.

>>> json.loads('{}') {} >>> json.loads('{}{}') # == json.loads(json.dumps({}) + json.dumps({})) traceback (most recent call last):   file "<stdin>", line 1, in <module>   file "c:\python27\lib\json\__init__.py", line 338, in loads     return _default_decoder.decode(s)   file "c:\python27\lib\json\decoder.py", line 368, in decode     raise valueerror(errmsg("extra data", s, end, len(s))) valueerror: data: line 1 column 3 - line 1 column 5 (char 2 - 4)

if want dump multiple dictionaries, wrap them in list, dump list (instead of dumping dictionaries multiple times)

>>> dict1 = {} >>> dict2 = {} >>> json.dumps([dict1, dict2]) '[{}, {}]' >>> json.loads(json.dumps([dict1, dict2])) [{}, {}]

Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more