用python解析特殊json格式

3条回答

网友

1楼 · 编辑于 2024-04-27 03:22:53

除了右括号]前的最后一个逗号外，FlickrAPI返回的整个对象是valid json。在

假设逗号仅仅是一个复制粘贴错误（example evidence表明是这样），那么内置的json module仍然不能按原样使用。这是因为即使像"116 deg 16' 10.20\" E"这样的字符串是valid json，python的json模块也会抱怨一个ValueError，因为双引号"没有被充分引用：

>>> import json
>>> json.loads('{"a": "2"}')
{u'a': u'2'}
>>> json.loads('{"a": "2\""}')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python2.7/json/__init__.py", line 338, in loads
    return _default_decoder.decode(s)
  File "/usr/lib/python2.7/json/decoder.py", line 365, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/usr/lib/python2.7/json/decoder.py", line 381, in raw_decode
    obj, end = self.scan_once(s, idx)
ValueError: Expecting , delimiter: line 1 column 10 (char 9)

解决方案是添加另一个转义反斜杠：

^{pr2}$

对于完整的jsonFlickrApi响应，可以使用^{} module添加额外的反斜杠：

>>> import re
>>> response = """jsonFlickrApi({ "photo": { "id": "8566959299", "secret": "141af38562", "server": "8233", "farm": 9, "camera": "Apple iPhone 4S", 
...     "exif": [
...       { "tagspace": "JFIF", "tagspaceid": 0, "tag": "JFIFVersion", "label": "JFIFVersion", 
...         "raw": { "_content": 1.01 } },
...       { "tagspace": "JFIF", "tagspaceid": 0, "tag": "ResolutionUnit", "label": "Resolution Unit", 
...         "raw": { "_content": "inches" } },
...       { "tagspace": "JFIF", "tagspaceid": 0, "tag": "XResolution", "label": "X-Resolution", 
...         "raw": { "_content": 72 }, 
...         "clean": { "_content": "72 dpi" } },
...       { "tagspace": "JFIF", "tagspaceid": 0, "tag": "YResolution", "label": "Y-Resolution", 
...         "raw": { "_content": 72 }, 
...         "clean": { "_content": "72 dpi" } },
...       { "tagspace": "GPS", "tagspaceid": 0, "tag": "GPSLatitudeRef", "label": "GPS Latitude Ref", 
...         "raw": { "_content": "North" } },
...       { "tagspace": "GPS", "tagspaceid": 0, "tag": "GPSLatitude", "label": "GPS Latitude", 
...         "raw": { "_content": "39 deg 56' 44.40\"" }, 
...         "clean": { "_content": "39 deg 56' 44.40\" N" } },
...       { "tagspace": "GPS", "tagspaceid": 0, "tag": "GPSLongitudeRef", "label": "GPS Longitude Ref", 
...         "raw": { "_content": "East" } },
...       { "tagspace": "GPS", "tagspaceid": 0, "tag": "GPSLongitude", "label": "GPS Longitude", 
...         "raw": { "_content": "116 deg 16' 10.20\"" }, 
...         "clean": { "_content": "116 deg 16' 10.20\" E" } }
...     ] }, "stat": "ok" })"""
>>> quoted_resp = re.sub('deg ([^"]+)"', r'deg \1\\"', response[14:-1])

然后，可以在对json.loads的调用中使用引用的响应，然后可以轻松地访问新生成的字典结构中所需的数据：

>>> photodict = json.loads(quoted_resp)
>>> for meta in photodict['photo']['exif']:                                                                                                               
...     if meta["tagspace"] == "GPS" and meta["tag"] == "GPSLongitude":
...         print(meta["clean"]["_content"])
... 
116 deg 16' 10.20" E

网友

2楼 · 编辑于 2024-04-27 03:22:53

如果将整个字符串看作jsonFlickrApi(XXX)，XXX是一个标准的JSON字符串。使用json库，XXX可以转换为python字典，然后很容易地进行解析。在

网友

3楼 · 编辑于 2024-04-27 03:22:53

您不会说您是否使用了flickrapi；我认为不是，因为如果您使用的是flickrapi之类的API，那么处理JSON响应就很简单了。在

import flickrapi

api_key = '88341066e8f0a40516599d28d8170627'   # from flickr's API explorer
secret = 'sssshhhh'
flickr = flickrapi.FlickrAPI(api_key, secret, format='parsed-json')
response = flickr.photos.getExif(photo_id='8566959299')
lat_long = {exif['tag']: exif['clean']['_content']
                    for exif in response['photo']['exif']
                        if exif['tag'] in (u'GPSLongitude', u'GPSLatitude')}

>>> from pprint import pprint
>>> pprint(lat_long)
{u'GPSLatitude': u'39 deg 56\' 44.40" N',
 u'GPSLongitude': u'116 deg 16\' 10.20" E'}

但是继续假设您没有使用API，您看到的响应格式实际上是JSONP，它比Python更适合Javascript。但是，您可以请求JSON表示形式的响应，该响应没有封闭的jsonFlickrApi()函数包装器。通过在请求的查询参数中指定format=json&nojsoncallback=1来完成此操作。使用requests库可以很容易地请求和解析JSON响应，但是如果您不能使用requests，那么使用urllib2.urlopen()和{}组合使用也可以

^{pr2}$

相关问题更多 >

编程相关推荐

热门问题

热门文章