Python:将CSV文件的多列转换为嵌套Json

import csv
import json

def csv_to_nested_json(csv_file):
    with open(csv_file, 'r') as file:
        reader = csv.DictReader(file)
        rows = list(reader)

    nested_json = {}
    for row in rows:
        current_dict = nested_json
        for key, value in row.items():
            keys = key.split('.')
            for k in keys[:-1]:
                if k not in current_dict:
                    current_dict[k] = {}
                current_dict = current_dict[k]
            current_dict[keys[-1]] = value

    return json.dumps(nested_json)

csv_file = 'data.csv'
nested_json = csv_to_nested_json(csv_file)
print(nested_json)

person.name.first,person.name.last,person.age
John,Doe,30
Jane,Smith,25

{
  "person": {
    "name": {
      "first": "John",
      "last": "Doe"
    },
    "age": "30"
  }
}