python向excel写入数据

python向excel写入数据

代码

# -*- coding: cp936 -*-
import re
import xlwt
book = xlwt.Workbook()
sheet = book.add_sheet('sheetname',cell_overwrite_ok = True)
sheet.write(1,0,"training loss")
sheet.write(2,0,"validation loss")
sheet.write(3,0,"validation accuracy")
sheet.write(4,0,"run time")

f = open(r"C:\Users\flm\Desktop\新建文本文档 (2).txt","r").read()

#提取time
reg0 = r'30 took (.{8})'
wordreg0 = re.compile(reg0)
wordreglist0 = re.findall(wordreg0,f)
length = len(wordreglist0)
for i in range(length):
    sheet.write(4,i+1,wordreglist0[i])
	
#提取training loss
reg1 = r'training loss:		(.{8})'
wordreg1 = re.compile(reg1)
wordreglist1 = re.findall(wordreg1,f)
length = len(wordreglist1)
for i in range(length):
    sheet.write(1,i+1,wordreglist1[i])

#提取validation loss
reg2 = r'validation loss:		(.{8})'
wordreg2 = re.compile(reg2)
wordreglist2 = re.findall(wordreg2,f)
length = len(wordreglist2)
for i in range(length):
    sheet.write(2,i+1,wordreglist2[i])

#提取validation accuracy
reg3 = r'validation accuracy:		(.{7})'
wordreg3 = re.compile(reg3)
wordreglist3 = re.findall(wordreg3,f)
length = len(wordreglist3)
for i in range(length):
    sheet.write(3,i+1,wordreglist3[i])  
    
book.save('bookname.xls')

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值