【pandas实战】时间差计算
客户需求:输出log时间,如何快速计算时间差
构建随机时间列表
import random import time from datetime import datetime import pandas as pd def strTimeProp(start, end, prop, frmt): stime = time.mktime(time.strptime(start, frmt)) etime = time.mktime(time.strptime(end, frmt)) ptime = stime + prop * (etime - stime) return int(ptime) def randomDate(start, end, frmt='%Y-%m-%d %H:%M:%S'): return time.strftime(frmt, time.localtime(strTimeProp(start, end, random.random(), frmt))) def randomDateList(start, end, n, frmt='%Y-%m-%d %H:%M:%S'): return [randomDate(start, end, frmt) for _ in range(n)] start = '2018-06-02 12:12:12' end = '2018-11-01 00:00:00' lenth = 10 timelst=randomDateList(start, end, lenth) print(timelst)
['2018-07-21 10:07:12', '2018-06-19 16:15:31', '2018-09-02 02:45:07', '2018-07-02 21:56:11', '2018-07-15 04:07:49', '2018-08-08 00:25:15', '2018-07-12 13:39:38', '2018-09-17 08:09:44', '2018-10-18 05:39:34', '2018-08-04 18:12:25']
构建dataframe,计算时差
-------------------------------
********厚德达理,励志勤工********
-------------------------------