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

1. xlsx to csv： 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() 2. csv to xlsx： import pandas as pd def csv_to_xlsx_pd(): csv = pd.read_csv('1.csv', encoding='utf-8'