引入第三方库
import pandas as pd
data = pd.read_excel(‘0412.xls’,index_col=0)
data.to_csv(‘0412.csv’,encoding=‘utf-8’)
如果出现下面这个错误
ImportError: Install xlrd >= 1.0.0 for Excel support
是你没装全库
pip install pandas
pip install xlrd
引入第三方库
import pandas as pd
data = pd.read_excel(‘0412.xls’,index_col=0)
data.to_csv(‘0412.csv’,encoding=‘utf-8’)
如果出现下面这个错误
ImportError: Install xlrd >= 1.0.0 for Excel support
是你没装全库
pip install pandas
pip install xlrd