csv转excel
import pandas as pd
csv_file=pd.read_csv('xxxx.csv', low_memory=False, encoding='utf-8')
csv_file.to_excel('xxxx.xlsx', index=False, encoding='gbk')
excel中的中文编码格式是
GBK
excel转csv
import pandas as pd
xlsx_file = pd.read_excel('F:/Code/xxxx.xlsx', index_col=0)
csv_file = xlsx_file.to_csv('F:/Code/xxx.csv', encoding='utf-8')