python - 如何查找两列之间的所有日期和时间，例如 .. Datetime1 和 Datetime2 。如何在 Python 或 Excel 中执行此操作

Question

这是我想在中间的每个小时列出的问题。

Issue Reported                               Issue Resolved

01-12-19 05:00:00                           02-12-19  07:00:00

07-12-19 08:00:00                          07-12-19  11:00:00

我希望结果是：

[                      
01-12-19 06:00:00,                            
01-12-19 07:00:00,                         
01-12-19 08:00:00,                      
01-12-19 09:00:00,                                   
---                                               
02-12-19 05:00:00,                                    
02-12-19 06:00:00                                       
                ]                                                 
 [                       
 07-12-19 09:00:00                                                      
 07-12-19 10:00:00
                                       ]                             

标签： pythonexcel

Answer 1

result_total = []
for i in range(0,1241): z = pd.to_datetime(df.Issue_Reported[i]) result_total.append(z + pd.to_timedelta(np.arange(df.FAULTY_HOURS[i]), ' H')) 打印(result_total)

HERE FAULTY_HOURS是没有。ISSUE REPORTED 和 ISSUE RESOLVED 之间的小时数