如何將此格式的csv檔案轉換為json檔案？-有解無憂

CSV 檔案看起來像這樣，我有 id 和標簽。但是有些標簽可能有多個值，每個值占一列，所以有些標簽可能有多個列。

id,tags
403744,[""]
403745,["phsecurity"]
403750,["unit-testing","testing","boolean"]
403757,[""]
403759,["object-oriented","architectural-patterns"]

我嘗試使用此 python 代碼進行轉換：

import csv
import json


# Function to convert a CSV to JSON
# Takes the file paths as arguments
def make_json(csvFilePath, jsonFilePath):

    # create a dictionary
    data = {}

    # Open a csv reader called DictReader
    with open(csvFilePath, encoding='utf-8') as csvf:
        csvReader = csv.DictReader(csvf)

        # Convert each row into a dictionary
        # and add it to data
        for rows in csvReader:

            # Assuming a column named 'No' to
            # be the primary key
            key = rows['id']
            data[key] = rows

    # Open a json writer, and use the json.dumps()
    # function to dump data
    with open(jsonFilePath, 'w', encoding='utf-8') as jsonf:
        jsonf.write(json.dumps(data, indent=4))

# Driver Code


# Decide the two file paths according to your
# computer system
csvFilePath = r'aaa.CSV'
jsonFilePath = r'bbb.json'

# Call the make_json function
make_json(csvFilePath, jsonFilePath)

但是它給出的格式如下： { "403744": { "id": "403744", "tags": "[""]" }, "403745": { "id": "403745", "tags" : "["phsecurity"]" }, "403750": { "id": "403750", "tags": "["unit-testing"", "null": ["testing", "boolean]" ] }

這不是正確的 json 格式。就像我想在標簽中添加“測驗”和“布爾”一樣。您還可以看到，它也將“[”或“]”放入值中。有人知道如何修復它嗎？謝謝

uj5u.com熱心網友回復：

最好的方法是更改??輸入檔案的生成方式。但如果不可能，此腳本將嘗試決議它并保存 Json 檔案：

import json
from ast import literal_eval

data = []
with open("input.csv", "r") as f_in:
    for line in map(str.strip, f_in):
        if line == "":
            continue
        line = list(map(str.strip, line.split(",", maxsplit=1)))
        data.append(line)

# skip header:
data = data[1:]


data = {key: {"id": key, "tags": literal_eval(tags)} for key, tags in data}
print(data)

with open("output.json", "w") as f_out:
    json.dump(data, f_out, indent=4)

將創建output.json：

{
    "403744": {
        "id": "403744",
        "tags": [
            ""
        ]
    },
    "403745": {
        "id": "403745",
        "tags": [
            "phsecurity"
        ]
    },
    "403750": {
        "id": "403750",
        "tags": [
            "unit-testing",
            "testing",
            "boolean"
        ]
    },
    "403757": {
        "id": "403757",
        "tags": [
            ""
        ]
    },
    "403759": {
        "id": "403759",
        "tags": [
            "object-oriented",
            "architectural-patterns"
        ]
    }
}

轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/497251.html

標籤：json CSV

上一篇：如何將湯轉換為資料框

下一篇：Flutter上的Supabase沒有正確回傳回應