将带有嵌套列表的字典转换为特定的pandas df结构

Question

如何将dictionary转换为"期望输出";下面?

我有一个dictionary嵌套列表作为值:

dictionary = {'Person1': ['a', 1, 'b', 2], 'Person2': ['c', 3, 'd', 4]}   #(the dict is longer than this, this is just an example)

所需输出:

3

通过压缩pair和在列表推导中解成对列表的值将字典更改为元组列表，并传递给DataFrame构造函数:

L = [(k, *x) for k, v in dictionary.items() for x in zip(v[::2], v[1::2])]
df = pd.DataFrame(L, columns=['name','letter','value'])
print (df)
name letter  value
0  Person1      a      1
1  Person1      b      2
2  Person2      c      3
3  Person2      d      4