Skip to main content
 首页 » 编程设计

python:csv 到 json 创建以逗号分隔的元素

2025年01月19日9mfryf

我能够将 csv 转换为 json 文件。现在,我可以通过字段名称创建 JSON 文件,请参阅当前输出部分。

“team_members”字段中有多个名称,以','分隔。如何通过 python 将 team_members 名称转换为元素?

数据:(演示.csv)

id,team_name,team_members 
123,Biology,"Ali Smith, Jon Doe" 
234,Math,Jane Smith  
345,Statistics ,"Matt P, Albert Shaw" 
456,Chemistry,"Andrew M, Matt Shaw, Ali Smith" 
678,Physics,"Joe Doe, Jane Smith, Ali Smith " 

Python 代码:

import csv 
import json 
 
csvfile = open('files/csv/input/demo.csv', 'r') 
jsonfile = open('files/csv/input/demo.csv', 'w') 
 
fieldnames = ("id", 
              "team_name", 
              "team_members") 
reader = csv.DictReader( csvfile) # without headers 
# reader = csv.DictReader( csvfile, fieldnames) # with headers 
for row in reader: 
    json.dump(row, jsonfile) 
    jsonfile.write('\n') 

当前输出:给出带有字段的 json 文件

{"id": "123", "team_name": "Biology", "team_members": "Ali Smith, Jon Doe"} 
{"id": "234", "team_name": "Math", "team_members": "Jane Smith "} 
{"id": "345", "team_name": "Statistics ", "team_members": "Matt P, Albert Shaw"} 
{"id": "456", "team_name": "Chemistry", "team_members": "Andrew M, Matt Shaw, Ali Smith"} 
{"id": "678", "team_name": "Physics", "team_members": "Joe Doe, Jane Smith, Ali Smith "} 

需要的最终输出:

{"id": "123", "team_name": "Biology", "team_members": ["Ali Smith", "Jon Doe"]} 
{"id": "234", "team_name": "Math", "team_members": ["Jane Smith"]}, 
{"id": "345", "team_name": "Statistics ", "team_members": ["Matt P", "Albert Shaw"]} 
{"id": "456", "team_name": "Chemistry", "team_members": ["Andrew M", "Matt Shaw", "Ali Smith"]} 
{"id": "678", "team_name": "Physics", "team_members": ["Joe Doe", "Jane Smith", "Ali Smith "]}  

请您参考如下方法:

您可能需要查看 string.split 来为您解决这个问题:

row['team_members'] = row['team_members'].split(', ') 

这将用逗号分隔的数组替换 “team_members” 字段。