pandas：csv-excel文件相互转换

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')