我试图将数据框的单行分成两行。在数据框中,开始和结束列可用。我想根据条件拆分行。
我有一个如下所示的数据框:
symbol,start,end,size
ABC,2015-08-27 18:00:00,2015-08-28 05:00:00,12
ABC,2015-11-20 02:00:00,2015-11-20 06:00:00,5
ABC,2016-01-22 03:00:00,2016-01-22 06:00:00,4
PQR,2016-02-12 02:00:00,2016-02-12 06:00:00,5
PQR,2016-02-12 22:00:00,2016-02-13 03:00:00,6
PQR,2016-02-12 02:00:00,2016-02-12 07:00:00,6
健康)状况:
- 如果开始和结束是同一天,则无需执行任何操作。
- 如果开始和结束日期不同,则需要将其分成两行。
示例:让我们考虑如下行:
PQR,2016-02-12 22:00:00,2016-02-13 03:00:00,6
在上面的行中,start 包含第 12 日,end 包含第 13 日,因此需要将其分成两行,如下所示:
PQR,2016-02-12 22:00:00,2016-02-12 23:00:00,2
PQR,2016-02-12 00:00:00,2016-02-13 03:00:00,4
如果该行包含三天(如第 12 日开始和第 14 日结束),则需要将其拆分为三行。
预期输出为:
symbol,start,end,size
ABC,2015-08-27 18:00:00,2015-08-27 23:00:00,6
ABC,2015-08-28 00:00:00,2015-08-28 05:00:00,6
ABC,2015-11-20 02:00:00,2015-11-20 06:00:00,5
ABC,2016-01-22 03:00:00,2016-01-22 06:00:00,4
PQR,2016-02-12 02:00:00,2016-02-12 06:00:00,5
PQR,2016-02-12 22:00:00,2016-02-12 23:00:00,2
PQR,2016-02-12 00:00:00,2016-02-13 03:00:00,4
PQR,2016-02-12 02:00:00,2016-02-12 07:00:00,6