如何使用python在JSON数据中添加方括号

所以我有如下所示的json数据：

"responses":[
{
  "ResponseID" : "R_1mhpDCQzIOlVfPT",
  "ResponseSet" : "Default Response Set",
  "IPAddress" : "",
  "StartDate" : "2016-08-04 11:52:36",
  "EndDate" : "2016-08-04 11:52:53",
  "RecipientLastName" : "",
  "RecipientFirstName" : "",
  "RecipientEmail" : "",
  "ExternalDataReference" : "",
  "Finished" : "1",
  "Status" : "1",
  "Q5" : "",
  "Q6" : "",
  "Q7" : "",
  "Q8" : "",
  "Q9" : "",
  "Q10" : "",
  "Q11" : "",
  "Q12" : "",
  "LocationLatitude" : "33.414794921875",
  "LocationLongitude" : "-111.90930175781",
  "LocationAccuracy" : "-1"
},

我基本上想把所有的Q都放在json的Questions数组中。输出应如下所示：

"responses":[
{
  "ResponseID" : "R_1mhpDCQzIOlVfPT",
  "ResponseSet" : "Default Response Set",
  "IPAddress" : "",
  "StartDate" : "2016-08-04 11:52:36",
  "EndDate" : "2016-08-04 11:52:53",
  "RecipientLastName" : "",
  "RecipientFirstName" : "",
  "RecipientEmail" : "",
  "ExternalDataReference" : "",
  "Finished" : "1",
  "Status" : "1",
  "Questions" : [
     "Q5" : "",
     "Q6" : "",
     "Q7" : "",
     "Q8" : "",
     "Q9" : "",
     "Q10" : "",
     "Q11" : "",
     "Q12" : ""
   ],
  "LocationLatitude" : "33.414794921875",
  "LocationLongitude" : "-111.90930175781",
  "LocationAccuracy" : "-1"
}

我怎么能做到这一点并将其应用于 100 多个回复。这是我到目前为止所拥有的：

for filename in os.listdir('C:/Users/john/Desktop/Q/QD'):
if filename.endswith(".json") :
    print(filename)
    with open(filename, encoding="utf8") as data_file:
        data = json.load(data_file)
        for i in data['responses']:
            for j in i:
                if j.startswith('Q'):
                    print(j)
        input("Press enter to continue...")

这段代码所做的只是加载数据，基本上循环访问文件夹中的每个文件，并将所有问题打印到控制台中。我将如何附加"问题"字段并添加方括号？

这是一个工作示例：

for filename in os.listdir('C:/Users/john/Desktop/Q/QD'):
    if filename.endswith(".json"):
        with open(filename, encoding="utf8") as data_file:
            data = json.loads(data_file)
            for response in data['responses']:
                questions = {}
                for key in list(response.keys()):
                    if key.startswith('Q'):
                        questions[key] = response[key]
                        del response[key]
                response['Questions'] = questions
                print(response)

几点注意事项：

我正在使用 python3
我正在使用list(response.keys())来生成密钥的副本，如果没有，则当您在迭代时更改字典时，del将出错。
神奇的只是将您的问题保存在临时questions字典中，并在稍后出现在响应中。
只是一个意见，你比我更了解输入，但是当键以"Q"开头时，startswith可能会给你带来问题，比如"数量"等

我是 Python 的菜鸟，不得不首先与验证 JSON 作斗争，但这样的事情会起作用吗？

给定输入：

{
    "responses": [{
        "ResponseID": "R_1mhpDCQzIOlVfPT",
        "ResponseSet": "Default Response Set",
        "IPAddress": "",
        "StartDate": "2016-08-04 11:52:36",
        "EndDate": "2016-08-04 11:52:53",
        "RecipientLastName": "",
        "RecipientFirstName": "",
        "RecipientEmail": "",
        "ExternalDataReference": "",
        "Finished": "1",
        "Status": "1",
        "Q5": "",
        "Q6": "",
        "Q7": "",
        "Q8": "",
        "Q9": "",
        "Q10": "",
        "Q11": "",
        "Q12": "",
        "LocationLatitude": "33.414794921875",
        "LocationLongitude": "-111.90930175781",
        "LocationAccuracy": "-1"
    }]
}

使用此代码：

import json
def main():
    f = open('test.json')
    a = json.load(f)
    print a.keys()
    qs = []
    for k in a[u'responses'][0]:
        if 'Q' in k:
            qs.append((k, a[u'responses'][0][k]))
            del k
    a[u'responses'][0]['questions'] = qs
    print a
if __name__ == "__main__":
    main()

给出以下输出：

{u'responses': [{u'Q5': u'', u'Q7': u'', u'Q6': u'', u'Q9': u'', u'Q8': u'', u'ResponseID': u'R_1mhpDCQzIOlVfPT', u'LocationLatitude': u'33.414794921875', u'RecipientLastName': u'', 'questions': [(u'Q5', u''), (u'Q7', u''), (u'Q6', u''), (u'Q9', u''), (u'Q8', u''), (u'Q11', u''), (u'Q10', u''), (u'Q12', u'')], u'Status': u'1', u'StartDate': u'2016-08-04 11:52:36', u'EndDate': u'2016-08-04 11:52:53', u'RecipientEmail': u'', u'Finished': u'1', u'Q11': u'', u'Q10': u'', u'Q12': u'', u'IPAddress': u'', u'RecipientFirstName': u'', u'LocationAccuracy': u'-1', u'LocationLongitude': u'-111.90930175781', u'ExternalDataReference': u'', u'ResponseSet': u'Default Response Set'}]}

您需要根据用例对其进行调整。

顺便说一下，我正在使用Python 2.7。老实说，以前的解决方案看起来要优雅得多。我正在发布更多内容以尝试帮助和学习。随时指出我的错误！

相关内容

最新更新

热门标签：