python24小时12小时转换_修复了24小时到12小时格式不一致的问题

break_notes end_time pay_rate start_time015-1823:0010.010:00118.30-19.0023:0012.018:0024PM-5PM22:3014.012:0033-418:0010.009:0044-4.10PM23:0020.009:00515-1723:0010.011:00611-1316:0010.010:00'''

import pandas as pd

import datetime

import numpy as np

work_shifts = pd.read_csv('work_shifts.csv')

break_shifts = work_shifts['break_notes'].str.extract('(?P[\d\.]+)?\D*(?P[\d\.]+)?')

print(work_shifts)

for i in range(len(break_shifts['start'])):

if '.' not in break_shifts['start'][i]:

break_shifts['start'][i] = break_shifts['start'][i] + ':00'

else:

break_shifts['start'][i] = break_shifts['start'][i].replace('.',':')

for i in range(len(break_shifts['end'])):

if '.' in str(break_shifts['end'][i]):

break_shifts['end'][i] = break_shifts['end'][i].replace('.',':')

elif '.' not in str(break_shifts['end'][i]):

break_shifts['end'][i] = break_shifts['end'][i] + ':00'

for i in range(len(break_shifts['end'])):

break_shifts['end'][i] = datetime.datetime.strptime(break_shifts['end'][i], '%H:%M').time()

break_shifts['start'][i] = datetime.datetime.strptime(break_shifts['start'][i], '%H:%M').time()

work_shifts[['start_break','end_break']] = break_shifts[['start', 'end']]

for i in range(len(work_shifts['end_time'])):

work_shifts['end_time'][i] = datetime.datetime.strptime(work_shifts['end_time'][i], '%H:%M').time()

for i in range(len(work_shifts['start_time'])):

work_shifts['start_time'][i] = datetime.datetime.strptime(work_shifts['start_time'][i], '%H:%M').time()

print(work_shifts)