将键值对从单元格提取到新列中

Question

我有一个Pandas数据框，其中一列中的单元格通常如下所示：

[{'source_name': 'mitre-attack', 'external_id': 'T1156', 'url': 'https://attack.mitre.org/techniques/T1156'}, {'url': 'https://researchcenter.paloaltonetworks.com/2017/04/unit42-new-iotlinux-malware-targets-dvrs-forms-botnet/', 'description': 'Claud Xiao, Cong Zheng, Yanhui Jia. (2017, April 6). New IoT/Linux Malware Targets DVRs, Forms Botnet. Retrieved February 19, 2018.', 'source_name': 'amnesia malware'}]

如何（在本例中）将键“external\u id”的值“T1156”提取到名为t\u id的新列中

Answer 1

很简单，试着这样做：

df['t_id'] = df['external_id']