【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，计算时差