JSON数据提取

最新推荐文章于 2025-10-31 09:04:01 发布

原创最新推荐文章于 2025-10-31 09:04:01 发布 · 1.9k 阅读

CC 4.0 BY-SA版权

这篇博客介绍了如何使用Python的json库来加载和操作JSON数据。通过示例代码展示了如何解析JSON字符串，获取对象的键值，包括嵌套结构的数据，并给出了简单的JSON操作练习。

import json
s = json.loads(’{“name”:“test”, “type”:{“name”:“seq”, “parameter”:[“1”, “2”]}}’)
print (s)
print (s.keys())
print (s[“name”])
print (s[“type”][“name”])
print (s[“type”][“parameter”][1])

json练习

>>> x='''{"subjects":[{"rate":"8.9","cover_x":2000,"title":"绿皮书","url":"https:\/\/movie.douban.com\/subject\/27060077\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2549177902.jpg","id":"27060077","cover_y":3167,"is_new":false},{"rate":"7.4","cover_x":1372,"title":"风中有朵雨做的云","url":"https:\/\/movie.douban.com\/subject\/26728669\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2552522615.jpg","id":"26728669","cover_y":1920,"is_new":false},{"rate":"7.7","cover_x":1440,"title":"告诉蜜蜂","url":"https:\/\/movie.douban.com\/subject\/27110448\/","playable":false,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2550440855.jpg","id":"27110448","cover_y":2133,"is_new":true},{"rate":"7.6","cover_x":674,"title":"幸运儿彼尔","url":"https:\/\/movie.douban.com\/subject\/30259071\/","playable":false,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2552539542.jpg","id":"30259071","cover_y":999,"is_new":true},{"rate":"6.9","cover_x":7142,"title":"飞驰人生","url":"https:\/\/movie.douban.com\/subject\/30163509\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2542973862.jpg","id":"30163509","cover_y":10000,"is_new":false},{"rate":"6.8","cover_x":1000,"title":"老师·好","url":"https:\/\/movie.douban.com\/subject\/27663742\/","playable":true,"cover":"https://img1.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2551352209.jpg","id":"27663742","cover_y":1400,"is_new":false},{"rate":"7.9","cover_x":1786,"title":"流浪地球","url":"https:\/\/movie.douban.com\/subject\/26266893\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2545472803.jpg","id":"26266893","cover_y":2500,"is_new":false},{"rate":"7.8","cover_x":1165,"title":"过春天","url":"https:\/\/movie.douban.com\/subject\/27191431\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2549537782.jpg","id":"27191431","cover_y":1653,"is_new":false},{"rate":"8.7","cover_x":3300,"title":"小偷家族","url":"https:\/\/movie.douban.com\/subject\/27622447\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2530599636.jpg","id":"27622447","cover_y":4659,"is_new":false},{"rate":"7.3","cover_x":1968,"title":"蚁人2：黄蜂女现身","url":"https:\/\/movie.douban.com\/subject\/26636712\/","playable":true,"cover":"https://img1.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2529389608.jpg","id":"26636712","cover_y":2756,"is_new":false},{"rate":"5.7","cover_x":1071,"title":"阳台上","url":"https:\/\/movie.douban.com\/subject\/27135473\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2546828235.jpg","id":"27135473","cover_y":1500,"is_new":false},{"rate":"6.4","cover_x":960,"title":"疯狂的外星人","url":"https:\/\/movie.douban.com\/subject\/25986662\/","playable":true,"cover":"https://img1.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2541901817.jpg","id":"25986662","cover_y":1359,"is_new":false},{"rate":"7.2","cover_x":2050,"title":"毒液：致命守护者","url":"https:\/\/movie.douban.com\/subject\/3168101\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2537158013.jpg","id":"3168101","cover_y":2910,"is_new":false},{"rate":"7.6","cover_x":6750,"title":"海王","url":"https:\/\/movie.douban.com\/subject\/3878007\/","playable":true,"cover":"https://img1.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2541280047.jpg","id":"3878007","cover_y":10000,"is_new":false},{"rate":"8.7","cover_x":2200,"title":"蜘蛛侠：平行宇宙","url":"https:\/\/movie.douban.com\/subject\/26374197\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2542867516.jpg","id":"26374197","cover_y":3123,"is_new":false},{"rate":"8.4","cover_x":640,"title":"盗梦特攻队","url":"https:\/\/movie.douban.com\/subject\/30272143\/","playable":false,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2527836922.jpg","id":"30272143","cover_y":922,"is_new":false},{"rate":"8.7","cover_x":3000,"title":"波西米亚狂想曲","url":"https:\/\/movie.douban.com\/subject\/5300054\/","playable":false,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2549558913.jpg","id":"5300054","cover_y":4418,"is_new":false},{"rate":"8.1","cover_x":1429,"title":"无名之辈","url":"https:\/\/movie.douban.com\/subject\/27110296\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2539661066.jpg","id":"27110296","cover_y":2000,"is_new":false},{"rate":"9.0","cover_x":1080,"title":"我不是药神","url":"https:\/\/movie.douban.com\/subject\/26752088\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2519070834.jpg","id":"26752088","cover_y":1512,"is_new":false},{"rate":"7.1","cover_x":1080,"title":"一出好戏","url":"https:\/\/movie.douban.com\/subject\/26985127\/","playable":true,"cover":"https://img3.doubanio.com\/view\/photo\/s_ratio_poster\/public\/p2529571873.jpg","id":"26985127","cover_y":1512,"is_new":false}]}'''
>>> type(x)
<class 'str'>
>>> import json
>>> s=json.loads(x)
>>> type(x)
<class 'str'>
>>> type(s)
<class 'dict'>
>>> print (s.keys())
dict_keys(['subjects'])
>>> datas=s['subjects']
>>> for i in result['subjects']:
	print(i['title'],i['rate'],i['url'])

	
Traceback (most recent call last):
  File "<pyshell#38>", line 1, in <module>
    for i in result['subjects']:
NameError: name 'result' is not defined
>>> for i in s['subjects']:
	print(i['title'],i['rate'],i['url'])

	
绿皮书 8.9 https://movie.douban.com/subject/27060077/
风中有朵雨做的云 7.4 https://movie.douban.com/subject/26728669/
告诉蜜蜂 7.7 https://movie.douban.com/subject/27110448/
幸运儿彼尔 7.6 https://movie.douban.com/subject/30259071/
飞驰人生 6.9 https://movie.douban.com/subject/30163509/
老师·好 6.8 https://movie.douban.com/subject/27663742/
流浪地球 7.9 https://movie.douban.com/subject/26266893/
过春天 7.8 https://movie.douban.com/subject/27191431/
小偷家族 8.7 https://movie.douban.com/subject/27622447/
蚁人2：黄蜂女现身 7.3 https://movie.douban.com/subject/26636712/
阳台上 5.7 https://movie.douban.com/subject/27135473/
疯狂的外星人 6.4 https://movie.douban.com/subject/25986662/
毒液：致命守护者 7.2 https://movie.douban.com/subject/3168101/
海王 7.6 https://movie.douban.com/subject/3878007/
蜘蛛侠：平行宇宙 8.7 https://movie.douban.com/subject/26374197/
盗梦特攻队 8.4 https://movie.douban.com/subject/30272143/
波西米亚狂想曲 8.7 https://movie.douban.com/subject/5300054/
无名之辈 8.1 https://movie.douban.com/subject/27110296/
我不是药神 9.0 https://movie.douban.com/subject/26752088/
一出好戏 7.1 https://movie.douban.com/subject/26985127/
>>>

参考：https://blog.youkuaiyun.com/super_man_1995/article/details/81265230