csv到没有重复值的嵌套json

Name,Age,Country
John,25,USA
Emily,30,Canada

[
  {
    "Name": "John",
    "Age": 25,
    "Country": "USA"
  },
  {
    "Name": "Emily",
    "Age": 30,
    "Country": "Canada"
  }
]

import csv
import json

csv_data = """
Name,Age,Country
John,25,USA
Emily,30,Canada
"""

def csv_to_json(csv_data):
    rows = csv_data.strip().split('\n')
    headers = rows[0].split(',')
    result = []
    for row in rows[1:]:
        values = row.split(',')
        record = {}
        for i in range(len(headers)):
            record[headers[i]] = values[i]
        result.append(record)
    return json.dumps(result, indent=2)

json_data = csv_to_json(csv_data)
print(json_data)

[
  {
    "Name": "John",
    "Age": "25",
    "Country": "USA"
  },
  {
    "Name": "Emily",
    "Age": "30",
    "Country": "Canada"
  }
]