How to remove illegal characters so a dataframe can write to Excel

by

Based on Haipeng Su’s answer, I added a function that does this:

dataframe = dataframe.applymap(lambda x: x.encode('unicode_escape').
                 decode('utf-8') if isinstance(x, str) else x)

Basically, it escapes the unicode characters if they exist. It worked and I can now write to Excel spreadsheets again!

More Related Contents:

  1. Export from pandas to_excel without row names (index)?
  2. How do I melt a pandas dataframe?
  3. Pandas bar plot changes date format
  4. Show DataFrame as table in iPython Notebook
  5. Make Pandas DataFrame apply() use all cores?
  6. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  7. After rename column get keyerror
  8. Trouble installing Pandas on new MacBook Air M1
  9. collect() or toPandas() on a large DataFrame in pyspark/EMR
  10. Python/Pandas: counting the number of missing/NaN in each row
  11. Kalman filter with varying timesteps
  12. pandas dataframe group and sort by weekday
  13. Standard implementation of vectorize_sequences
  14. Merge two data frames based on common column values in Pandas
  15. Suppress output of object when plotting in IPython
  16. Pandas: convert date in month to the 1st day of next month
  17. Getting Colorbar instance of scatter plot in pandas/matplotlib
  18. All possible combinations of columns in dataframe -pandas/python
  19. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  20. Download history stock prices automatically from yahoo finance in python
  21. Pandas & AWS Lambda
  22. Scrape tables into dataframe with BeautifulSoup
  23. How is a Pandas crosstab different from a Pandas pivot_table?
  24. How can I draw scatter trend line on matplot? Python-Pandas
  25. Plot pandas dataframe containing NaNs
  26. How can I left justify text in a pandas DataFrame column in an IPython notebook
  27. concise way of flattening multiindex columns
  28. Using in operator with Pandas series [duplicate]
  29. Grouped seaborn.barplot from a wide pandas.DataFrame
  30. Does Pandas calculate ewm wrong?

Leave a Comment