使用特定列指定从字典写入CSV

Question

我有一个列表，我可以使用一些帮助写入csv文件。你知道吗

在一列中-我需要分类。这是冒号前面的单引号字段。在这之后，括号中的每个值都会出现在它自己的列中：

下面是打印列表本身的快照。。。你知道吗

defaultdict(<class 'list'>, {
    'Analyzers/Blood': ['Analyzers, Laboratory, Hematology, Coagulation', 'Analyzers, Laboratory, Hematology, Coagulation, Semiautomated', 'Flowmeters, Blood, Ultrasonic'],
    'LCD Display': ['Auxiliary Displays, Touchscreen'], 
    'Electronic Endoflator': ['Balances, Electronic', 'Carts, Storage/Transport, Electromechanical/Electronic Instrument/Equipment', 'Thermometer, Electronic, Traceable']
})

格式示例：

Analyzers/Blood | Analyzers | Laboratory | Hematology...(through Ultrasonic)

提前谢谢

Answer 1

更新了我错过了您的列表，可能有多个条目。你知道吗

试试这个：

dict_ = {
    'Analyzers/Blood': ['Analyzers, Laboratory, Hematology, Coagulation', 'Analyzers, Laboratory, Hematology, Coagulation, Semiautomated', 'Flowmeters, Blood, Ultrasonic'],
    'LCD Display': ['Auxiliary Displays, Touchscreen'], 
    'Electronic Endoflator': ['Balances, Electronic', 'Carts, Storage/Transport, Electromechanical/Electronic Instrument/Equipment', 'Thermometer, Electronic, Traceable']
}

with open("output.csv","w") as f:
    for k,v in dict_.items(): #py2 iteritems()
        items = [item.strip() for subv in v for item in subv.split(",")]
        f.write('|'.join([k]+list(set(items))))
        f.write('\n')

输出：

Analyzers/Blood|Blood|Ultrasonic|Coagulation|Flowmeters|Laboratory|Hematology|Analyzers|Semiautomated
LCD Display|Auxiliary Displays|Touchscreen
Electronic Endoflator|Storage/Transport|Traceable|Thermometer|Balances|Electromechanical/Electronic Instrument/Equipment|Carts|Electronic