python - 使用 Python 从 json 字典中获取元素

Question

我有一个我想用 Python 读取的以下 json，并在每次迭代中将 table_name 和 column_filter 保存在一个变量中。我的json就像：

import json
dict_config = json.loads('''
    {
        "normal" : [
            {
                "table_name": "TABLE1",
                "column_filter": "TIME_TS"
            },
            {
                "table_name": "TABLE2",
                "column_filter": "TIME_DATE_TS"
            }
        ],
        "normal2" : [
            {
                "table_name": "TABLE3",
                "column_filter": "SOMETHING_TS"
            },
            {
                "table_name": "TABLE4",
                "column_filter": "DOCUMENT_TS"
            }
        ]
    }
''')

for each in dict_config.keys():
    for xx in dict_config[each]
        ...
        table_name=...
        column_filter=.....

如何轻松地将 table_name 和 column_filter 的值存储在 normal,normal2,... 元素中？所以在每次迭代中我都想得到 table_name & column_filter

标签： pythonjsonpython-3.x

Answer 1

您几乎是正确的，只需正确索引

for each in dict_config:
    for xx in dict_config[each]:
        table_name=xx['table_name']
        column_filter=xx['column_filter']
        print(table_name, column_filter)