我想提取具有特定键值对的JSON对象

Question

我有一个来自API的JSON响应，如下所示：

"get_result_by_result_id": [{
    "data": {
        "date_trunc": "2022-09-06T00:00:00+00:00",
        "project": "Smoothy Finance",
        "usd_volume": 42307.09145419092
    },
     
}, {
    "data": {
        "date_trunc": "2022-09-30T00:00:00+00:00",
        "project": "curve",
        "usd_volume": 40548.688138892685
    },
     
},  {
    "data": {
        "date_trunc": "2022-09-14T00:00:00+00:00",
        "project": " kyber",
        "usd_volume": 13800038.727002844
    },
     
},]

我想提取响应中具有"kyber“值的所有对象如下：

"common_objects": [{
        "data": {
            "date_trunc": "2022-09-14T00:00:00+00:00",
            "project": " kyber",
            "usd_volume": 13800038.727002844
        },
         
    }, {
        "data": {
            "date_trunc": "2022-09-07T00:00:00+00:00",
            "project": " kyber",
            "usd_volume": 24518356.073168807
        },},]

我该怎么做？

Answer 1

我认为您的json已经损坏了，所以我对它做了一些编辑，下面是您可以这样做的方法：

data = [{
    'data': {
        'date_trunc': '2022-09-06T00:00:00+00:00',
        'project': 'Smoothy Finance',
        'usd_volume': 42307.09145419092
    }

}, {
    'data': {
        'date_trunc': '2022-09-30T00:00:00+00:00',
        'project': 'curve',
        'usd_volume': 40548.688138892685
    }

},  {
    'data': {
        'date_trunc': '2022-09-14T00:00:00+00:00',
        'project': ' kyber',
        'usd_volume': 13800038.727002844
    }

}]

clear_data = []
for data in data:
    if(data['data']['project'] == ' kyber'):
        clear_data.append(data)

print(clear_data)