將多個串列組合成具有不同縮進級別的JSON檔案

**編輯：我需要列印機資料的鍵：值對位于該列印機名稱的“主題/標志”下。

我正在嘗試獲取 的輸出wmic printer list brief并將其轉換為 JSON 檔案，以便日后存盤和決議。到目前為止，我已將其轉換為帶有/format:csv標志的CSV 格式，并且已將其獲取到我可以通過并將該 CSV 資料轉換為串列的位置。問題是json的格式。如何格式化所有資料都位于“名稱”的“標志”下的 json？我知道我沒有像我應該的那樣解釋這個，但我很難過。這是我希望它看起來像的一個例子，

{
    "Adobe PDF": {
        "Node": "____________",
        "Location": "____________",
    "PrinterState": "____________",
    "PrinterStatus": "____________",
    "ShareName": "____________",
    "SystemName": "____________"
    }
    "OneNote for Windows 10": {
        "Node": "____________",
        "Location": "____________",
    "PrinterState": "____________",
    "PrinterStatus": "____________",
    "ShareName": "____________",
    "SystemName": "____________"
    }
}

另一方面，如何清理和壓縮此 python 代碼以使其更高效并占用更少空間？

蟒蛇代碼：

import csv
import json

Node = []
Location = []
Name = []
PrinterState = []
PrinterStatus = []
ShareName = []
SystemName = []


csvfile = getprinters()
reader = [row for row in csv.reader(csvfile.decode('utf-8').splitlines())]
for i in reader:
if i == []:
    continue
else:
    item1 = i[0]
    item2 = i[1]
    item3 = i[2]
    item4 = i[3]
    item5 = i[4]
    item6 = i[5]
    item7 = i[6]
    Node.append(item1)
    Location.append(item2)
    Name.append(item3)
    PrinterState.append(item4)
    PrinterStatus.append(item5)
    ShareName.append(item6)
    SystemName.append(item7)

開始 CSV：

Node,Location,Name,PrinterState,PrinterStatus,ShareName,SystemName
COMPUTERNAME,,Adobe PDF,0,3,,COMPUTERNAME
COMPUTERNAME,,OneNote for Windows 10,0,3,,COMPUTERNAME
COMPUTERNAME,,OneNote (Desktop),0,3,,COMPUTERNAME
COMPUTERNAME,,Microsoft XPS Document Writer,0,3,,COMPUTERNAME
COMPUTERNAME,,Microsoft Print to PDF,0,3,,COMPUTERNAME
COMPUTERNAME,http://12.345.6.789:0000/,HP###### (HP Officejet Pro 8610),0,3,,COMPUTERNAME
COMPUTERNAME,,Fax,0,3,,COMPUTERNAME

示例串列：

['Node', 'COMPUTERNAME', 'COMPUTERNAME', 'COMPUTERNAME', 'COMPUTERNAME', 'COMPUTERNAME','COMPUTERNAME', 'COMPUTERNAME']

uj5u.com熱心網友回復：

讀取 csv 檔案，使用csv.DictReader. 創建一個 dict 并將該 dict 轉儲到 JSON 中。在dict將成為JSON物件。

import csv
import json

with open('start.csv') as f:
    rdr =  csv.DictReader(f)
    data = {row.get('Name'):row for row in rdr} # use row.pop('Name') if you want to remove Name key from row

with open('export.json', 'w') as f:
    json.dump(data, f, indent=4)

輸出export.json：

{
    "Adobe PDF": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "Adobe PDF",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "OneNote for Windows 10": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "OneNote for Windows 10",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "OneNote (Desktop)": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "OneNote (Desktop)",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "Microsoft XPS Document Writer": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "Microsoft XPS Document Writer",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "Microsoft Print to PDF": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "Microsoft Print to PDF",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "HP###### (HP Officejet Pro 8610)": {
        "Node": "COMPUTERNAME",
        "Location": "http://12.345.6.789:0000/",
        "Name": "HP###### (HP Officejet Pro 8610)",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    },
    "Fax": {
        "Node": "COMPUTERNAME",
        "Location": "",
        "Name": "Fax",
        "PrinterState": "0",
        "PrinterStatus": "3",
        "ShareName": "",
        "SystemName": "COMPUTERNAME"
    }
}

標籤：Python json 列表 文件 微信

上一篇：組合函式

下一篇：從串列中回傳最大序列