Python pandas 将逗号分隔值列表转换为数据框

Question

我有一个字符串列表，如下所示:

["Name: Alice, Department: HR, Salary: 60000", "Name: Bob, Department: Engineering, Salary: 45000"]

我想将此列表转换成如下所示的 DataFrame:

Name | Department | Salary
--------------------------
Alice | HR | 60000

Bob | Engineering | 45000

最简单的方法是什么？我的直觉是将数据放入 CSV 并使用正则表达式“^.*:”分隔标题，但必须有更简单的方法

Answer 1

通过一些字符串处理，您可以获得字典列表并将其传递给 DataFrame 构造函数:

lst = ["Name: Alice, Department: HR, Salary: 60000", 
       "Name: Bob, Department: Engineering, Salary: 45000"]
pd.DataFrame([dict([kv.split(': ') for kv in record.split(', ')]) for record in lst])
Out: 
    Department   Name Salary
0           HR  Alice  60000
1  Engineering    Bob  45000