ValueError: arrays must all be same length

将字典数据导出到excle时出错ValueError: arrays must all be same length

#tmp为不规则字典数据

tmp={
'a':['1','2','3','4'],
'b':['1','2','3'],
'c':['1','2','3','4','5'],
'd':['1','2','3','4'],
}

writer = pd.ExcelWriter(r'E:\Projects\PythonProjects\demo1\output.xlsx')
df1 = pd.DataFrame(tmp)
df1.to_excel(writer, sheet_name='cx')
writer.save()

文档这样写

Two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). Arithmetic operations align on both row and column labels. Can be thought of as a dict-like container for Series objects. The primary pandas data structure.

行与列需要对齐

不规则数据可以使用pandas.DataFrame.from_dict()

writer = pd.ExcelWriter(r'E:\Projects\PythonProjects\demo1\output.xlsx')
df1 = pd.DataFrame.from_dict(tmp, orient='index')
df1.to_excel(writer, sheet_name='cx')
writer.save()