如何从带有逗号分隔行的CSV列中创建唯一的键/值JSON文件(在Python中)

Question

我有一个CSV文件，该文件由一个列组成，列中每一行都有逗号分隔的值:示例：

Area,Contact Number,Contact,Service,Category
"Bonanza, Gordondale, Knopcik, Pouce Coupe, Progress, Valhalla North, Valhalla South, Wapiti",1-866-694-9111,911 Industrial Response,Ambulance Oilfield,Emergency Services
"Alderson, Astotin, Bonanza, Crossfield, Gordondale, Hayter, Knopcik, Pouce Coupe, Progress, Provost Czar Metiskow, Redwater, Valhalla North, Valhalla South, Viking Consort Esther Hamilton Lake, Wapiti",1-800-661-3822,Alberta Central Air (ACA) - Medivac Flight Services,Air Ambulance,Emergency Services

如何仅将CSV的AREA列转换为具有唯一键的JSON :value对？期望输出的示例：

{
    "Bonanza": "Bonanza",
    "Gordondale": "Gordondale",
    "Pouce Coupe": "Pouce Coupe",
    "Progress": "Progress",
    "Valhalla North": "Valhalla North",
    "Valhalla Sorth": "Valhalla Sorth",
    "Wapiti": "Wapiti",
    "Knopcik": "Knopcik"
}

Answer 1

考虑到你的文件的结构，也许把它装进熊猫并从那里开始就更容易了。

import pandas as pd
set_values = pd.read_csv('untitled1.txt').Area.str.split(',').explode().str.strip().unique().tolist()
dict(zip(set_values,set_values))

输出

{'Bonanza': 'Bonanza',
 'Gordondale': 'Gordondale',
 'Knopcik': 'Knopcik',
 'Pouce Coupe': 'Pouce Coupe',
 'Progress': 'Progress',
 'Valhalla North': 'Valhalla North',
 'Valhalla South': 'Valhalla South',
 'Wapiti': 'Wapiti',
 'Alderson': 'Alderson',
 'Astotin': 'Astotin',
 'Crossfield': 'Crossfield',
 'Hayter': 'Hayter',
 'Provost Czar Metiskow': 'Provost Czar Metiskow',
 'Redwater': 'Redwater',
 'Viking Consort Esther Hamilton Lake': 'Viking Consort Esther Hamilton Lake'}