我需要拆分json数据

Question

我想用以下更改修改当前的JSON文件:

我想编辑"Vs"列，并将该数据分成两列。我想把它分成两列，分别命名为team 1和team 2，在'vs'后面分割数据。

我该如何使用python脚本?

输入:JSON数据(这是样例数据)

[
{
"Match No": "1",
"Date": "17-10-21",
"Vs": "Sri Lanka vs Ireland",
"Rounds": "1st",
"Group": "Group A"
},

Required Output: JSON data

[
{
"Match No": "1",
"Date": "17-10-21",
"Team1": "Sri Lanka",
"Team2": "Ireland",
"Rounds": "1st",
"Group": "Group A"
},

Answer 1

所以，我使用库json来序列化您的输入。然后你只需要循环遍历json数组中的每个对象，并从数据中创建一个新的json对象。我希望你能理解校长的话。

import json
input = """
[
{
"Match No": "1",
"Date": "17-10-21",
"Vs": "Sri Lanka vs Ireland",
"Rounds": "1st",
"Group": "Group A"
}
]
"""
result = json.loads("""
[
]
""")
for o in json.loads(input):
teams = o["Vs"].split(" vs ")
result.append({
"Match No": o["Match No"],
"Date": o["Date"],
"Team 1": teams[0],
"Team 2": teams[1],
"Rounds": o["Rounds"],
"Group": o["Group"]
})

print(result)