一.日期时间处理:
.S4G`@q%Q0 datetime库51Testing软件测试网f&a:o+HUo0H t
c
>>> import datetime51Testing软件测试网.D}4`Q+X5_
W5CI+U
>>> datetime.datetime.now()
#当前时间51Testing软件测试网"xmS#H2L@H
datetime.datetime(2016, 4, 16, 12, 53, 43, 104000)
"M4NF0O*J0>>> datetime.datetime.today() #当前时间51Testing软件测试网;R3N1qk~/qA.DH*~|
datetime.datetime(2016, 4, 16, 12, 54, 6, 647000)51Testing软件测试网L8FE8o3xwS
>>>
datetime.datetime.strftime(datetime.datetime.now(),'%Y-%m-%d')51Testing软件测试网`![;OV5xJ9X
'2016-04-16'#时间转换成指定格式字符串
;nT Xvb*D0>>>
datetime.datetime.strftime(datetime.datetime.now(),'%Y%m%d%H%M%S')51Testing软件测试网-^o5^3ki
'20160416125604''#时间转换成指定格式字符串,常用的时间戳
1{0s~5B!g2u,]Q@%X'y.f0>>> datetime.datetime.strptime('2015-03-12',"%Y-%m-%d %H:%M:%S")
3uR6P9GU0#字符串转成日期51Testing软件测试网;p"H9E4zVS
>>>
datetime.datetime.strptime('2015-03-12',"%Y-%m-%d")
8b8\s#o]BZe0datetime.datetime(2015, 3, 12, 0, 0)51Testing软件测试网]5BC*d;b-M5j
?g
d1MM$p^i P1m$w*U0#日期相加减
,f)u1d"X4Ij;L0>>> datetime.datetime.now()+datetime.timedelta(days=2)51Testing软件测试网3C*]'TH6|,wAx
datetime.datetime(2016, 4, 18, 13, 0, 47, 197000)51Testing软件测试网(G.[na1dC Q
>>> datetime.datetime.now()+datetime.timedelta(hours=2)51Testing软件测试网(bR+`~;C/f#E$N
datetime.datetime(2016, 4, 16, 15, 1, 11, 417000)51Testing软件测试网i|2{ Vx
#日期的格式化,51Testing软件测试网0{` W\1C;C;qd
>>> d=datetime.datetime.now()51Testing软件测试网,cO |hq1HO:f#A
>>> print d.strftime('%a')
w5~m}&f;x-g5`N0Sat #星期简写
wxA,@qV(Wx
Y0>>> print d.strftime('%A')
&y&]Fzr}#V9]0Saturday #月份简写
0A3]1^{JfH0>>> print d.strftime('%B')51Testing软件测试网%D
|6p']wE8yiK.c
April51Testing软件测试网8i
r&VvZ
su
>>> print d.strftime('%w')
'e
K,T"R/b{qs3g l[ EM06 #星期几51Testing软件测试网4Ob:M7ti0FAw5v
>>> print d.strftime('%W')51Testing软件测试网$pC y6h'qf
15#当前周在一年的第几周51Testing软件测试网JC8oE!on
>>> print d.strftime('%p')
a2G#]S#MkP!mt$q
~ T]0PM51Testing软件测试网 AP"b5[j}
|
calendar库:日历月历
0aE\ [!^uAb!~4hQ0import calendar51Testing软件测试网
u-S_)o3q
calendar.prmonth(1999, 12)
s#KL5A3A@_5~i0 51Testing软件测试网'UvN!w p\
二.操作excel
LJ8]2M0w7@J0需要安装使用xlrd库,51Testing软件测试网5piL4c[*V9O;_
>>> import xlrd
/M%n%?qUp0>>> xls=xlrd.open_workbook('e://test.xls')51Testing软件测试网aWq4G4_}TV;c
>>> table=xls.sheets()[0]
q'gj _*c5r!h(Y-uO8?3r
j0>>> table.cell(0,0).values()
5b)DYi3o+q8qJ:PR0>>> table.row_values(1)51Testing软件测试网h)l|N8r^ Md|
[4.0, 5.0, 6.0]#第二行数据,list
Gof3^*f!R0#编辑打印每一行数据
8]+]
Er2g k9f0>>> for i in range(table.nrows):51Testing软件测试网@%t.jG;}-w
print table.row_values(i)
Ft Dl"m2?0[1.0, 2.0, 3.0]
0iODbFoN0[4.0, 5.0, 6.0]
k,LSSV1z t$C0 51Testing软件测试网&s-Kfmd'S
三.操作xml51Testing软件测试网
BN4mJ:g.g
>>> import xml.dom.minidom as xmldom
R(A:D.Jph0>>> dom=xmldom.parse('test.xml')
&R7h4M1~8~;O+\ p0>>> root = dom.documentElement51Testing软件测试网 @I@qN
M
>>>idnode=root.getElementsByTagName('id')#根据元素名字获取元素,如果得到多个元素可根据下标来获取具体的元素
W;{!@&do0>>>childs=idnode.childNodes #获取子元素集合51Testing软件测试网 R6RU3nraj
>>>idnode[0].getAttribute('attrname')#获取元素属性
k%Yc!w Z)feA0
e El+am4n` D(y0四.操作csv文件51Testing软件测试网x(T\:y/Z+kU(y+Z%@_
import csv
_}B
J(@"qz0>>>read = csv.reader(file('your.csv', 'rb'))51Testing软件测试网Ei ]R$l
|f
>>> for line in read:51Testing软件测试网"t9h{B:y6}6f
for i in line:
[%zu8Z\S8KWxA0 print i51Testing软件测试网b7`%HxXW"Is[
写csv文件51Testing软件测试网z:},Jz*rN+}
KN
csvfile = file('csv_test.csv', 'wb')51Testing软件测试网&V#OHuG+A
writer = csv.writer(csvfile)51Testing软件测试网 o:XzGfj*w
writer.writerow(['姓名', '年龄', '电话'])51Testing软件测试网1ER;_6v8Wi*uF
data = [……]#可以直接写list
"urqy,h0writer.writerows(data)
:EIz*mz#]7Dva0csvfile.close()51Testing软件测试网i&RW-j@2`
(QPZ UZ}0
d%_Vj9|/qRb0五.操作sqlite3
@6gv$\h6V i0B/m0Sqlite是一种轻量级的数据库,sqlite3在目前的Python2.5以上版本已经集成
r4fMz4clK#E e&K0>>> import sqlite3
.o&Kjgc+}"gw0>>> sqlite3.connect('test1.db') #如果不存在,则新建,创建后则会生成*.db文件
i2e0^\*h5qA0<sqlite3.Connection object at 0x02C27E30>51Testing软件测试网@ e^;_s!o'm
>>> conn=sqlite3.connect('test1.db')51Testing软件测试网;J%|/m\
xqrcWu
>>> cur=conn.cursor() #创建一个游标51Testing软件测试网)l%^,})Y%h8}9y
>>> cur.execute('create table mytable(id integer,value text)')
#\G+m1{ai
q'H0>>> cur.execute("INSERT INTO mytable(id,value)
values(1,'feiyu')")
C;D'\ X6G%~ Sj0<sqlite3.Cursor object at 0x02C6D060>
u]E.b.p,d!Aw0>>> conn.commit() #提交事务51Testing软件测试网&msRq,D)u,Rpp
>>> result=cur.execute('select * from mytable')
x(K3To@]_L;m0>>> print result.fetchall() #获取查询结果中所有的行51Testing软件测试网[#J;A_ da/eE
[(1, u'feiyu')]
7GJj'o$HQA0>>>Conn.Close() #关闭连接
j"LQ[0S&_2B)n"yH0