Saving a pandas dataframe in excel with utf-8 encoding

Question

Simply want to set the encoding of an excel workbook for saving data. All data is stored in a pandas dataframe.

Code below:

file_name = "bobs_burgers"

with pd.ExcelWriter(r".\Exported_data\{file_name}.xlsx".format(file_name = file_name),
                        engine="xlsxwriter",
                        options={'encoding':'utf-8'}) as writer:

data_table.to_excel(writer, sheet_name = "characters", index = False)

I receive the error below

TypeError: Workbook.init() got an unexpected keyword argument 'encoding'

Using google to search for this, I have found that the majority of comments about encoding using ExcelWriter always has input of options.

How to set the encode to utf-8 for exported pandas tables?

Mohsen_Fatemi · Accepted Answer · 2024-02-11 05:13:33Z

0

According to the ExcelWriter documentation from pandas version 2 the **kwargs was removed from this class. So in order to pass options to ExcelWriter, you need to pass it to engine_kwargs as a key like this :

engine_kwargs = {'options':{'encoding':'utf-8'}}

Here is the modified version of your code :

file_name = "bobs_burgers"

with pd.ExcelWriter(r".\Exported_data\{file_name}.xlsx".format(file_name = file_name),
                        engine="xlsxwriter",
                        engine_kwargs = {'options':{'encoding':'utf-8'}}) as writer:

data_table.to_excel(writer, sheet_name = "characters", index = False)

answered Feb 11, 2024 at 5:13

Mohsen_Fatemi

3,4212 gold badges21 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Saving a pandas dataframe in excel with utf-8 encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related