您需要指定列分隔符，然后可以使用 * json. dumps（）* 提供所需的输出格式

import csv
import json

with open('forcebrute.csv') as data:
    print(json.dumps([d for d in csv.DictReader(data, delimiter=';')], indent=2))

• • 输出：**

[
  {
    "name": "Action-1",
    "price": "20",
    "profit": "5"
  },
  {
    "name": "Action-2",
    "price": "30",
    "profit": "10"
  },
  {
    "name": "Action-3",
    "price": "50",
    "profit": "15"
  },
  {
    "name": "Action-4",
    "price": "70",
    "profit": "20"
  },
  {
    "name": "Action-5",
    "price": "60",
    "profit": "17"
  }
]

您需要使用csv库中的Dictreader来读取CSV文件的内容，然后在使用json.dumps将数据转换为JSON之前将内容转换为列表。

import csv
import json

filename ="forcebrute.csv"

# Open the CSV file and read the contents into a list of dictionaries
with open(filename, 'r') as f:
   reader = csv.DictReader(f, delimiter=';')
   csv_data = list(reader)

# Convert the data to a JSON string and print it to the console
json_data = json.dumps(csv_data)
print(json_data)

一个简单的方法是使用Pandas，处理大的csv文件也相当快。它可能需要一些调整，但你明白了。

import pandas as pd
import json

df = pd.read_csv(filename, sep = ';')
data = json.dumps(df.to_dict('records'))