python - 从数组长度不等的字典中创建数据框

Question

我有一本字典 - {'Car': ['a', 'b'], 'Bike': ['q', 'w', 'e']}我想生成这样的数据框 -

S.no. | vehicle | model
1     | Car     | a
2     | Car     | b
2     | Bike     | q
2     | Bike     | w
2     | Bike     | e

我试过 df = pd.DataFrame(vDict)但我得到 ValueError: arrays must all be same length错误。请帮忙？

Answer 1

用:

pd.Series(dct, name='model').explode().rename_axis(index='vehicle').reset_index()