json数组取值(python解析json数组)

json文件

{"tasks": [{"name": "allen", "params": {"ftpDatasourceId": 2,"targetConfig": {"database": "ods", "description": "", "table": "allen_keep_moving"}, "basePath": "/allen_keep_moving/$[yyyyMMdd-1]" }}]}

import json
"""python中读取文件中的内容，并更修改"""
with open("idp_backend.json",'rb') as f:
    # 获取json文件对象
    loads = json.loads(f.read())
    # 逐个遍历数组中的对象，更改数组中对应对象的值
    for item in loads['tasks']:
        item['name'] = "allen"
        item['params']['targetConfig']['table'] = "allen_keep_moving"
        item['params']['basePath'] ="/allen_keep_moving/$[yyyyMMdd-1]"
    # 写入到目标文件    
    with open("json_value_change","w") as f:
        json.dump(loads,f)
        print("-------文件加载success----------")

总结：json文件是我们数据开发路上一直需要接触的数据类型，熟练掌握开发方法，能帮助我们更熟练上手数据开发的工作。