导读 | JSON(JavaScript Object Notation)是一种轻量级的数据交换格式。
它基于ECMAScript的一个子集,易于阅读和编写。 Python3 中可以使用json模块来对JSON数据进行编码。 |
d1 = [{"id" : 1,"name" : "Number1","age" : 11},{"id" : 2,"name" : "Number2","age" : 22},{"id" : "3","name" : "Number3","age" : 33}] d2 = {"persons" :[{"id" : 1,"name" : "Number1","age" : 11},{"id" : "2","name" : "Number2","age" : 22},{"id" : 3,"name" : "Number3","age" : 33}]} d3 = {"code" : 200, "persons" :[{"id" : 1,"name" : "Number1","age" : 11},{"id" : True,"name" : "Number2","age" : 22},{"id" : 3,"name" : "Number3","age" : 33}]}
## 获取 json 数组或json 对象的 key 列表
def get_json_keys(json_str,json_keys = []): if isinstance(json_str,list): for json_obj in json_str: for key in json_obj.keys(): if key not in json_keys: json_keys.append(key) elif isinstance(json_str,dict): for key in json_str.keys(): if key not in json_keys: json_keys.append(key) return json_keys
## 将json 数组中相同的 key – value值进行合并
def get_key_values(json_str,json_keys): target_json = {} for key in json_keys: key_values = [] for json_obj in json_str: if isinstance(json_obj,dict): key_values.append(json_obj[key]) target_json[key] = key_values return target_json
## 主方法
def analyse_json(json_str): target_json = {} json_keys = [] if isinstance(json_str,list): json_keys = get_json_keys(json_str,json_keys) target_json = get_key_values(json_str,json_keys) elif isinstance(json_str,dict): json_keys = get_json_keys(json_str,json_keys) for key in json_keys: if not isinstance(json_str[key],list) and not isinstance(json_str[key],dict): target_json[key] = json_str[key] else: target_json[key] = analyse_json(json_str[key]) return target_json print(analyse_json(d1)) print(analyse_json(d2)) print(analyse_json(d3))
输出:
{'id': [1, 2, '3'], 'name': ['Number1', 'Number2', 'Number3'], 'age': [11, 22, 33]} {'persons': {'id': [1, '2', 3], 'name': ['Number1', 'Number2', 'Number3'], 'age': [11, 22, 33]}} {'code': 200, 'persons': {'id': [1, True, 3], 'name': ['Number1', 'Number2', 'Number3'], 'age': [11, 22, 33]}}
原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/121984.html