Some people on Telegram said the right approach is to pass either dtype or converters on pandas.read_excel(). It worked but in the end, it cannot 100% preserve the values.
Like this example:
Reading the data from query (initial)
RKAT ITS
Reading the same data from excel file (saved version)
RKAT _x0013_ ITS
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Some people on Telegram said the right approach is to pass either
dtype
orconverters
onpandas.read_excel()
. It worked but in the end, it cannot 100% preserve the values.Like this example:
Reading the data from query (initial)
RKAT ITS
Reading the same data from excel file (saved version)
RKAT _x0013_ ITS