使用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()