目标:把str类型的时间,以一天为准,建立开始和结束的时间戳,主要应用在企业微信的日程规范当中
数据如下图所示:

image.png
# 1、新建 end_time,即date的后一天
def time_end(data):
start_time = data['date']
start_time = datetime.datetime.strptime(start_time, '%Y-%m-%d')
end_time = start_time + dateutil.relativedelta.relativedelta(days = 1)
end_time = str(end_time)[:10]
return end_time
data['end_time'] = data.apply(time_end, axis = 1)
# 2、开始时的 时间戳
def start_unix(data):
start_time = datetime.datetime.strptime(data, '%Y-%m-%d')
a = start_time.timetuple()
b = time.mktime(a)
c = int(b)
return c
data['start_time'] = data['start_time'].apply(start_unix)
# 3、结束时的 时间戳
def end_unix(data):
end_time = datetime.datetime.strptime(data, '%Y-%m-%d')
a = end_time.timetuple()
b = time.mktime(a)
c = int(b)
return c
data['end_time'] = data['end_time'].apply(start_unix)
print(data[['start_time', 'end_time']])
结果如下图所示:

image.png