将csv转换为具有按值排序的嵌套对象的json

import csv
import json

def csv_to_json(csv_file):
    # 读取CSV文件
    with open(csv_file, 'r') as file:
        reader = csv.DictReader(file)
        rows = list(reader)

    # 构建嵌套对象
    nested_obj = {}
    for row in rows:
        nested_obj[row['key']] = row['value']

    # 按值排序
    sorted_obj = dict(sorted(nested_obj.items(), key=lambda x: x[1]))

    # 转换为JSON
    json_data = json.dumps(sorted_obj, indent=4)

    return json_data

# 示例用法
csv_file = 'data.csv'
json_data = csv_to_json(csv_file)
print(json_data)

key,value
key1,10
key2,5
key3,20

{
    "key2": "5",
    "key1": "10",
    "key3": "20"
}