python 处理上述json数据,要求返回[{"onwer":"李东南(50001824)","groups":['ShiBa', 'PengZhou']},{"onwer":"牛鹤澎(50002285)","groups":['ShiBa', 'SaiWenShi','PengZhou']},{"onwer":"史世民(50002508)","groups":['ShiBa', 'SaiWenShi','PengZhou']},]
时间: 2023-06-03 18:07:23 浏览: 44
下面是处理上述json数据的Python代码:
```python
import json
data = '''
[
{
"id": "50001824",
"name": "李东南",
"groups": [
{
"id": "ShiBa"
},
{
"id": "PengZhou"
}
]
},
{
"id": "50002285",
"name": "牛鹤澎",
"groups": [
{
"id": "ShiBa"
},
{
"id": "SaiWenShi"
},
{
"id": "PengZhou"
}
]
},
{
"id": "50002508",
"name": "史世民",
"groups": [
{
"id": "ShiBa"
},
{
"id": "SaiWenShi"
},
{
"id": "PengZhou"
}
]
}
]
'''
result = []
parsed_data = json.loads(data)
for item in parsed_data:
result.append({
"owner": item["name"] + "(" + item["id"] + ")",
"groups": [group["id"] for group in item["groups"]]
})
print(result)
```
输出结果为:
```
[
{"owner": "李东南(50001824)", "groups": ["ShiBa", "PengZhou"]},
{"owner": "牛鹤澎(50002285)", "groups": ["ShiBa", "SaiWenShi", "PengZhou"]},
{"owner": "史世民(50002508)", "groups": ["ShiBa", "SaiWenShi", "PengZhou"]}
]
```