import xlwt
hr_book = xlwt.Workbook(encoding='ascii')
hr_sheet = hr_book.add_sheet('HR_title', cell_overwrite_ok=True)
with open('/Users/zhangpengxu/Desktop/gps_20161101', 'r') as title:
bl=0
hrtitle = title.readline()
bl=bl+1
hrtitle_list = hrtitle.split()
i = 0
j = 0
for hl in hrtitle_list:
hr_sheet.write(i, j, hl)
j = j + 1
hr_book.save('/Users/zhangpengxu/Desktop/gps_20161101.xls')
import xlwt
import time
hr_book = xlwt.Workbook(encoding='ascii')
hr_sheet = hr_book.add_sheet('HR_title', cell_overwrite_ok=True)
bl=0
i=0
with open('C:\\Users\\97216\\Desktop\\python\\11-1\\gps_20161101', 'r') as file:
try:
while True:
text_line = file.readline()
if text_line:
bl += 1
text_line_list = text_line.split(",")
j = 0
for hl in text_line_list:
hr_sheet.write(i, j, hl)
j = j + 1
i+=1
if bl%60000==0:
hr_book.save('C:\\Users\\97216\\Desktop\\python\\11-1\\gps_'+str(bl-59999)+'_'+str(bl)+'.xls')
i = 0
time.sleep(1)
else:
break
finally:
file.close()
import datetime
import time
import pymssql
import decimal
start_time=datetime.datetime.now()
conn = pymssql.connect('localhost','sa','P@ssw0rd','chengdu' )
if conn:
print("连接成功!")
cursor = conn.cursor()
sql = "INSERT INTO Track_Data (DriverId,OrderId,Time,Longitude,Latitude) VALUES (%s,%s,%s,%s,%s)"
bl=0
with open('C:\\Users\\97216\\Desktop\\python\\11-1\\gps_20161101', 'r') as file:
try:
while True:
text_line = file.readline()
if text_line:
bl += 1
text_line_list = text_line.split(",")
cursor.execute(sql, (text_line_list[0],text_line_list[1],int(text_line_list[2]),text_line_list[3],text_line_list[4].strip("\n")))
conn.commit()
if bl%50000==0:
time.sleep(1)
print('已完成插入SQLsever'+str(bl)+'行数据'+'正在插入'+str(bl)+'至'+str(bl+50000)+'行数据')
finally:
print("读取完毕")
file.close()
end_time = datetime.datetime.now()
speed = end_time - start_time
print(speed)
import xlwt
import time
hr_book = xlwt.Workbook(encoding='ascii')
hr_sheet = hr_book.add_sheet('HR_title', cell_overwrite_ok=True)
bl=0
i=0
with open('C:\\Users\\97216\\Desktop\\python\\11-1\\gps_20161101', 'r') as file:
try:
while True:
text_line = file.readline()
if text_line:
bl += 1
text_line_list = text_line.split(",")
j = 0
for hl in text_line_list:
hr_sheet.write(i, j, hl)
j = j + 1
i+=1
if bl%60000==0:
hr_book.save('C:\\Users\\97216\\Desktop\\python\\11-1\\gps_'+str(bl-59999)+'_'+str(bl)+'.xls')
i = 0
time.sleep(1)
else:
break
finally:
file.close()