将数据帧的输出保存到ex时发生Python错误

Question

我正在尝试将数据框的形状打印到excel文件中。你知道吗

以下是我迄今为止所取得的成就：

file_shape = df.shape[0] <<-- This saves the count of rows to a variable
writer = pd.ExcelWriter(output, engine='xlsxwriter')
file_shape.to_excel(writer, startrow=0, merge_cells=False, sheet_name="Summary", index=False)

上面的抛出一个错误

AttributeError: 'int' object has no attribute 'to_excel'

Answer 1

请尝试以下操作：

file_shape = df.shape[0] # <<  This saves the count of rows to a variable
df['file_shape'] = file_shape
writer = pd.ExcelWriter(output, engine='xlsxwriter')
df.to_excel(writer, startrow=0, merge_cells=False, sheet_name="Summary", index=False)