Python can read a csv file but the content is wrong, but it can be opened with excel alone. How to solve it?

Question

Convert csv file to xlsx file but cannot read it, displaying various errors

This is when excel is opened

This is read using Python
This is the error when reading using Python after changing to xlsx

Answer 1

Pay close attention to see if there is any problem when reading 编码, resulting in uneven separation

Answer 2

You need to explain your mistakes clearly, such as printing them out, so others can help you!

Answer 3

There is no problem converting to utf-8 encoding, Chinese will be displayed correctly, please check the encoding