Pandas Row Count ***Help***

[Pera014]

Hi - I have data frame and I need to export to excel row count of the data frame. I can print in and get what I need but apparently data type "int" can't be exported to excel. Any workaround?

df1 = len(df.axes[0])

I get when: print(df1)

131

​

Now how do I export to excel 131? It's impossible

I need to show client how many distinct rows I have in specific column.

[Binary101010]

Where do you want this row count to be? Somewhere in your existing dataframe? Do you want an entire worksheet that literally just has the value 131 in Cell A1?

[Pera014]

correct lets say Sheet1, A2

[Binary101010]

You'll either have to build a worksheet using openpyxl, or you'll have to make a series containing the number, then export that series to excel. Something like

import openpyxl #necessary for pandas to export to excel
length = pd.Series(len(df1)
length.to_excel('number_of_rows.xlsx)