过滤器JSON数组在python

Question

又是我。我有一个大的一行JSON数组，我得到一个url的响应。

它看起来像这样:

[{"completed":"XXXXXXXXX","flow":"XXXXXX","process":"XXXXX","step":"XXXXXXX","thingname":"INEEDTHISFORLATER"},{"completed":"XXXXXXXXXX","flow":"XXXXXXXX","process":"XXXXXXX","step":"XXXXXXXX","thingname":"INEEDTHISFORLATER"}]

我需要过滤行，这样我只提取"INEEDTHISFORLATER"并保存到一个新文件。

我对pandas做了很多尝试，但都没有成功，因为它显然是一行的。

谢谢你的帮助!

Answer 1

您可以使用json包来处理您的情况

import json
s = '[{"completed":"XXXXXXXXX","flow":"XXXXXX","process":"XXXXX","step":"XXXXXXX","thingname":"INEEDTHISFORLATER"},{"completed":"XXXXXXXXXX","flow":"XXXXXXXX","process":"XXXXXXX","step":"XXXXXXXX","thingname":"INEEDTHISFORLATER"}]'
obj = json.loads(s)
with open('file.txt', "w") as file:
for item in obj:
file.write(item['thingname'] + "n")

file.txt:

INEEDTHISFORLATER
INEEDTHISFORLATER