如何使用pandas阅读Excel文件时克服u200d Unicode

Question

excel文件包含印度语数据。正在读取excel文件，但在显示内容时，它会在其间显示\u200d。我需要避免它来做进一步的数据处理。请帮忙

Answer 1

试试这个

s = 'This is some \u200d text that has to be cleaned\u200d! it\u200d annoying!'
s.encode('ascii', 'ignore')

output :

This is some  text that has to be cleaned! it annoying!'