将多个列表组合成具有不同缩进级别的JSON文件

Question

**edit:我需要打印机数据的键值对放在"主题/标志"下;

我试图获得wmic printer list brief的输出，并将其转换为JSON文件，以便在以后的日期存储和解析。到目前为止，我已经把它变成了CSV格式的/format:csv标志，并得到了它，我可以通过并把CSV数据转换成一个列表。问题是json的格式。我怎么能格式化json其中所有的数据是在"名称"的"标志"下?我知道我没有像我应该的那样解释这件事，但我被难住了。下面是我想让它看起来像的一个例子

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

另一个注意事项，我如何清理和压缩这段python代码，使其更有效，占用更少的空间?

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']

Answer 1

读取csv文件，带csv.DictReader。创建一个字典并将该字典转储到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"
}
}