import pandas as pd def csv_to_xlsx_pd():
#csv文件名，假若csv文件中含有中文则需加上encoding=‘gb18030‘
csv = pd.read_csv(‘test.csv‘, encoding=‘gb18030‘, engine=‘python‘, index_col=0)
csv.to_excel(‘test.xlsx‘, sheet_name=‘data‘)
if __name__ == ‘__main__‘: csv_to_xlsx_pd()
原文：https://www.cnblogs.com/bobbycheng/p/11911763.html