【py模板】xlsx转csv

import numpy as np
import pandas as pd

def xlsx_to_csv():
    data_xls = pd.read_excel('cupHaveHead1.xlsx',index_col=0)
    data_xls.to_csv('cupHaveHead1.csv', encoding='utf-8')
    data_xls = pd.read_excel('cup22test.xlsx',index_col=0)
    data_xls.to_csv('cup22test.csv', encoding='utf-8')

if __name__=='__main__':
    xlsx_to_csv()

train = pd.read_csv('cupHaveHead1.csv')
test=pd.read_csv('cup22test.csv')