如何使用python将csv文件中的数据转换为字典格式

Question

我有一个CSV文件，如下图所示：

我想用字典的格式，像这样：

{'Alcolohol - related liver disease': 'Jaundice Yellow Eye, pain, swelling,', 
 'Acquired Capillary Haemangioma of Eyelid': 'Raised red or blue lesion,', 
 'Acquired Immuno Deficiency Syndrome': 'Flu-like illness,', 
 'Acute encephalitis syndrome': 'Headache, fever, confusion, stiff neck, 
  vomiting,', .......... and so on}

尝试在CSV文件中使用此选项

Answer 1

您可能需要检查key（疾病）是否已分配，以及append是否已将value（症状）分配给list

≈ 数据库非规范化

import csv
csv_reader = csv.reader(open('./file.csv', 'r'))
next(csv_reader)  # skip header

disease_dict = {}
for row in csv_reader:
    disease, symptoms = row[0], row[1]
    if disease not in disease_dict:
        disease_dict[disease] = []
    disease_dict[disease].append(symptoms)

print(disease_dict)

附言。 要以您的格式打印词典，请执行以下操作：

for key in disease_dict:
    print(key, *disease_dict[key])