python读取excel快慢_python – 更快速地将Excel文件读取到pandas数...

正如其他人所说,csv阅读速度更快.因此,如果您在Windows上并拥有Excel,则可以调用vbscript将Excel转换为csv然后读取csv.我尝试了下面的脚本,花了大约30秒.

# create a list with sheet numbers you want to process

sheets = map(str,range(1,6))

# convert each sheet to csv and then read it using read_csv

df={}

from subprocess import call

excel='C:\Users\rsignell\OTT_Data_All_stations.xlsx'

for sheet in sheets:

csv = 'C:\Users\rsignell\test' + sheet + '.csv'

call(['cscript.exe', 'C:\Users\rsignell\ExcelToCsv.vbs', excel, csv, sheet])

df[sheet]=pd.read_csv(csv)

这里有一小段python用于创建ExcelToCsv.vbs脚本：

#write vbscript to file

vbscript="""if WScript.Arguments.Count < 3 Then

WScript.Echo "Please specify the source and the destination files. Usage: ExcelToCsv "

Wscript.Quit

End If

csv_format = 6

Set objFSO = CreateObject("Scripting.FileSystemObject")

src_file = objFSO.GetAbsolutePathName(Wscript.Arguments.Item(0))

dest_file = objFSO.GetAbsolutePathName(WScript.Arguments.Item(1))

worksheet_number = CInt(WScript.Arguments.Item(2))

Dim oExcel

Set oExcel = CreateObject("Excel.Application")

Dim oBook

Set oBook = oExcel.Workbooks.Open(src_file)

oBook.Worksheets(worksheet_number).Activate

oBook.SaveAs dest_file, csv_format

oBook.Close False

oExcel.Quit

""";

f = open('ExcelToCsv.vbs','w')

f.write(vbscript.encode('utf-8'))

f.close()