创建并写入csv文件
import csv
csvFile=open("C:/Users/hasee/Desktop/wikispider/test.csv",'w',newline='')
try:
writer=csv.writer(csvFile)
writer.writerow(('number','number plus 2','number times 2'))
for i in range(10):
writer.writerow((i,i+2,i*2))
finally:
csvFile.close()
writerow/writerows整行添加数据
方法1:单行写入
with open('xxxx.csv','w',newlines='') as f:
writer = csv.writer(f) #创建初始化写入对象
writer.writerow(['color','red']) # 一行一行写入 ['color','red']
# 在windows里,csv保存得到的文件是每空一行储存一条数据,使用newlines=''可保证存储存的数据不空行。
方法2:多行写入
with open('xxxx.csv','w') as f:
writer = csv.writer(f)
writer.writerows([('color','red'),('size','big'),('male','female')]) #多行写入
str类型的日期转换为时间戳
import time
# 字符类型的时间
t = '2020-04-23 16:30:00'
# 转为时间数组
time_array = time.strptime(t, "%Y-%m-%d %H:%M:%S")
print(time_array) # time.struct_time(tm_year=2020, tm_mon=4, tm_mday=23, tm_hour=16, tm_min=30, tm_sec=0, tm_wday=3, tm_yday=114, tm_isdst=-1)
# timeArray可以调用tm_year等
print(time_array.tm_year, time_array.tm_hour) # 2020 16
# 转为时间戳
time_stamp = int(time.mktime(time_array))
print(time_stamp) # 1587630600
别的也没啥说的
ok,那就这样吧~
欢迎各位大佬留言吐槽,也可以深入交流~