python - 遍历python中的列表列表

Question

我正在从 API 中读取以下 json 中的嵌套字典

{
 "result": [{
               "short_description": "I am getting bluescreen error",
               "sys_id": "39b5f8c2376ede007520021a54990e5c",
               "opened_at": "2016-04-04 05:19:53",
               "number":"INC0258523"
             },
             {
               "short_description": "laptop crashed with a blue screen",
               "sys_id": "da0095380f43d200a4f941fce1050eeb",
               "opened_at":"2016-04-25 06:33:52",
               "number":"INC0259067"
             }, 
             {
               "short_description": "Laptop not booting",
               "sys_id": "ecf9c9b00f43d200a4f941fce1050e17",
               "opened_at": "2016-04-25 06:07:16",
               "number": "INC0259061"
             }]
}

我需要根据两个起始日期和两个日期过滤数据。 opened_at 是包含日期信息的值。

目前我的尝试如下

    url = "http://ip:port/api"

    response = urllib.urlopen(url)
    data = json.loads(response.read())
    print type(data)
    pattern = 'opened_at'
    element = '2016-04-25 06:33:19'
    with open('D:/Output.csv', 'wb') as f:  
        w = csv.DictWriter(f, data['result'][0].keys()) 
        w.writeheader()
        print type(data['result'])
        for key in data['result']:
            for v, val in data['result'].items():
                if v == pattern and val == element:
                    w.writerow(v)

运行代码时出现以下错误

AttributeError: 'list' object has no attribute 'items'

我知道 data['result'] 的类型是一个列表。任何帮助将不胜感激。谢谢!

Answer 1

data['result'] 是一个字典列表，您应该像下面这样对其进行迭代:

for d in data['result']:
    for k, v in d.items():