python字典转为数据框_将字典列转换为数据框

我有一个csv文件，该文件的一列具有我感兴趣的结果，而另一个具有索引：

,Province, Constituency Name, Party Affiliation, segments

0,Ben Slimane, Ain Tizgha, UND, "{'UND': {""I don't know yet"": 16, 'No': 3, 'Yes': 5, 'total': 24, 'intention_rate': 20.83}, 'ABS': {""I don't know yet"": 1, 'No': 10, 'Yes': 1, 'total': 12, 'intention_rate': 8.33}, 'PJD': {""I don't know yet"": 1, 'Yes': 3, 'total': 4, 'intention_rate': 75}}"

1,Ben Slimane, Ain Tizgha, ABS, "{'UND': {""I don't know yet"": 16, 'No': 3, 'Yes': 5, 'total': 24, 'intention_rate': 20.83}, 'ABS': {""I don't know yet"": 1, 'No': 10, 'Yes': 1, 'total': 12, 'intention_rate': 8.33}, 'PJD': {""I don't know yet"": 1, 'Yes': 3, 'total': 4, 'intention_rate': 75}}"

2,Ben Slimane, Ain Tizgha, PJD, "{'UND': {""I don't know yet"": 16, 'No': 3, 'Yes': 5, 'total': 24, 'intention_rate': 20.83}, 'ABS': {""I don't know yet"": 1, 'No': 10, 'Yes': 1, 'total': 12, 'intention_rate': 8.33}, 'PJD': {""I don't know yet"": 1, 'Yes': 3, 'total': 4, 'intention_rate': 75}}"

3,Ben Slimane, Ahlaf, UND, "{'UND': {""I don't know yet"": 16, 'No': 3, 'Yes': 5, 'total': 24, 'intention_rate': 20.83}, 'ABS': {""I don't know yet"": 1, 'No': 10, 'Yes': 1, 'total': 12, 'intention_rate': 8.33}, 'PJD': {""I don't know yet"": 1, 'Yes': 3, 'total': 4, 'intention_rate': 75}}"

4,Ben Slimane, Ahlaf, A