Why does my PyCharm refuse to open CSV and Excel files through pandas?

Question

It keeps saying it can't read some char code

Answer 1

pd.read_csv('data.csv', encoding='utf8') here you can try different encoding values
or
pd.read_csv('data.csv', engine='python')

Answer 2

Thanks. I have tried changing the encoding to utf8 but it still keeps popping the same error. I'll try setting the engine to Python and I hope it works.