Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

I am trying to print out shape of a Dataframe to a excel file.

Given below is what I have achieved thus far:

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)
The above throws an error
AttributeError: 'int' object has no attribute 'to_excel'
                file_shape is integer. It does not have to_excel attribute. to_excel is attribute of df.
– pnv
                Apr 2, 2019 at 6:48
                @pnv, yes I am trying to figure how could I have this value added to the excel file using to_excel attribute..
– scott martin
                Apr 2, 2019 at 6:55
                @scott  For that you can make a column having the shape of the dataframe, and then write just that column to the excel file.
– GadaaDhaariGeek
                Apr 2, 2019 at 6:56
Try the following:
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)
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.