在转换之前, 事先需要将 CSV 文件另存为此格式
- import pandas as pd
- def csv_to_xlsx_pd():
- CSV = pd.read_csv(r'C:\Users\Jery\Desktop\guazi1.csv', encoding='utf-8')
- CSV.to_excel(r'C:\Users\Jery\Desktop\guazi1.xlsx', sheet_name='data')
- if __name__ == '__main__':
- csv_to_xlsx_pd()
若转换出现 ModuleNotFoundError: No module named 'openpyxl'
请先在 cmd 里 pip install openpyxl
- import pandas as pd
- import openpyxl
- def csv_to_xlsx_pd():
- CSV = pd.read_csv(r'C:\Users\Jery\Desktop\guazi1.csv', encoding='utf-8')
- CSV.to_excel(r'C:\Users\Jery\Desktop\guazi1.xlsx', sheet_name='data')
- if __name__ == '__main__':
- csv_to_xlsx_pd()
来源: http://www.bubuko.com/infodetail-3044762.html