TypeError: Unsupported type <class 'numpy.dtype'> in write()

Question

So i am reading a .xlsx file and i need to check how many variables in the xlsx file belong to each datatype in pandas and finally export it to excel.

So here is the code :

sheet = pd.read_excel(r"D:\Users\850034535\AnacondaProjects\Jupyter Project\Sample.xlsx",sheetname=2)
alldtypes = sheet.dtypes.value_counts()
alldtypes_df = list_of_all_variables.to_frame()
alldtypes_df.to_excel('123.xlsx')

This code gives an error: " TypeError: float() argument must be a string or a number, not 'numpy.dtype' "

So then i converted the dataframe to str type, so now an additional line of code was added :

 alldtypes_df = alldtypes_df.applymap(str)

But still it is showing me the same error and the error given in the title.

Any suggestions would be much appreciated.

jezrael · Accepted Answer · 2018-03-12 11:37:16Z

2

It seems need convert index to strings:

alldtypes_df.index = alldtypes_df.index.astype(str)

answered Mar 12, 2018 at 11:37

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

explorer_x Over a year ago

Worked Flawlessly, Thanks a lot!!

jezrael Over a year ago

@explorer_x - Glad can help!

Collectives™ on Stack Overflow

TypeError: Unsupported type <class 'numpy.dtype'> in write()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related