使用pandas实现csv/excel sheet互相转换的方法

import pandas as pd def xlsx_to_csv_pd(): data_xls = pd.read_excel('1.xlsx', index_col=0) data_xls.to_csv('1.csv', encoding='utf-8') if __name__ == '__main__': xlsx_to_csv_pd()

import pandas as pd def csv_to_xlsx_pd(): csv = pd.read_csv('1.csv', encoding='utf-8') csv.to_excel('1.xlsx', sheet_name='data') if __name__ == '__main__': csv_to_xlsx_pd()