처음에는 다음 데이터 프레임이 있고 그룹 별 및 집계를 수행하여 겹치는 시간 범위를 연결합니다. 최종 데이터 프레임에 다른 열을 추가하고 싶습니다.이 열은 겹치는 행의 데이터를 연결하여 형성됩니다.
df['newid']=(df['START']-df['END'].shift()).dt.total_seconds().gt(0).cumsum()
print (df.to_string(index=False))
ELEMENT TEXT START END newid
OLT2227-LT3-PON0-ONT03 USECASE1 - ALARM1 -NO OVERLAP 2021-01-19 18:00:00 2021-01-19 19:00:00 0
OLT2227-LT3-PON0-ONT03 USECASE1 - ALARM2 - NO OVERLAP 2021-01-19 19:10:00 2021-01-19 20:00:12 1
OLT2227-LT3-PON0-ONT05 USECASE2 - ALARM1 - Fully Contained 2021-01-19 18:00:00 2021-01-19 23:00:00 1
OLT2227-LT3-PON0-ONT05 USECASE2 - ALARM2 - Fully Contained 2021-01-19 19:00:00 2021-01-19 20:00:12 1
OLT2227-LT3-PON0-ONT10 USECASE3 - ALARM1 - START-END-RELATION 2021-01-19 22:00:00 2021-01-19 22:30:00 2
OLT2227-LT3-PON0-ONT10 USECASE3 - ALARM2 - START-END-RELATION 2021-01-19 22:30:00 2021-01-19 23:00:12 2
OLT2227-LT3-PON0-ONT21 USECASE3-ALARM1 2021-01-19 22:00:00 2021-01-19 22:10:00 2
OLT2227-LT3-PON0-ONT21 USECASE3-ALARM2-NO-END 2021-01-19 22:15:00 2042-01-19 20:00:12 3
OLT2227-LT3-PON0-ONT4 USECASE-4 2021-01-19 17:30:00 2042-01-19 20:00:12 3
OLT2227-LT3-PON0-ONT4 USECASE-4 2021-01-19 20:00:00 2021-01-19 23:00:00 3
OLT2227-LT3-PON0-ONT99 USECASE-5 2021-01-19 17:30:00 2021-01-19 22:00:00 3
OLT2227-LT3-PON0-ONT99 USECASE-5 2021-01-19 20:00:00 2042-01-19 20:00:12 3
newdf=df.groupby(['newid','ELEMENT']).agg({'START':'min','END':'max'}).reset_index(level=1)
print (newdf.to_string(index=False))
ELEMENT START END
OLT2227-LT3-PON0-ONT03 2021-01-19 18:00:00 2021-01-19 19:00:00
OLT2227-LT3-PON0-ONT03 2021-01-19 19:10:00 2021-01-19 20:00:12
OLT2227-LT3-PON0-ONT05 2021-01-19 18:00:00 2021-01-19 23:00:00
OLT2227-LT3-PON0-ONT10 2021-01-19 22:00:00 2021-01-19 23:00:12
OLT2227-LT3-PON0-ONT21 2021-01-19 22:00:00 2021-01-19 22:10:00
OLT2227-LT3-PON0-ONT21 2021-01-19 22:15:00 2042-01-19 20:00:12
OLT2227-LT3-PON0-ONT4 2021-01-19 17:30:00 2042-01-19 20:00:12
OLT2227-LT3-PON0-ONT99 2021-01-19 17:30:00 2042-01-19 20:00:12
보시다시피 마지막 데이터 프레임에서는 ELEMENT, START 및 END 열만 얻습니다. 그러나 내가 얻고 싶은 것은 집계 과정에서 TEXT 열을 연결하는 데이터 프레임입니다.
ELEMENT START END TEXT
OLT2227-LT3-PON0-ONT03 2021-01-19 18:00:00 2021-01-19 19:00:00 USECASE1 - ALARM1 -NO OVERLAP
OLT2227-LT3-PON0-ONT03 2021-01-19 19:10:00 2021-01-19 20:00:12 USECASE1 - ALARM2 - NO OVERLAP
OLT2227-LT3-PON0-ONT05 2021-01-19 18:00:00 2021-01-19 23:00:00 USECASE2 - ALARM1 - Fully Contained; USECASE2 - ALARM2 - Fully Contained
OLT2227-LT3-PON0-ONT10 2021-01-19 22:00:00 2021-01-19 23:00:12 USECASE3 - ALARM1 - START-END-RELATION; USECASE3 - ALARM2 - START-END-RELATION
OLT2227-LT3-PON0-ONT21 2021-01-19 22:00:00 2021-01-19 22:10:00 USECASE3-ALARM1
OLT2227-LT3-PON0-ONT21 2021-01-19 22:15:00 2042-01-19 20:00:12 USECASE3-ALARM2-NO-END
OLT2227-LT3-PON0-ONT4 2021-01-19 17:30:00 2042-01-19 20:00:12 USECASE-4 ; USECASE-4
OLT2227-LT3-PON0-ONT99 2021-01-19 17:30:00 2042-01-19 20:00:12 USECASE-5 ; USECASE-5
누구든지 도와 주시겠습니까?
메소드를 집계 할 수 있습니다 str.join
.
(df.groupby(['newid','ELEMENT'])
.agg({'START': 'min', 'END':'max', 'TEXT': ' ; '.join})
.reset_index(1))
출력 (TEXT 열만) :
USECASE1 - ALARM1 -NO OVERLAP
USECASE1 - ALARM2 - NO OVERLAP
USECASE2 - ALARM1 - Fully Contained ; USECASE2 - ALARM2 - Fully Contained
USECASE3 - ALARM1 - START-END-RELATION ; USECASE3 - ALARM2 - START-END-RELATION
USECASE3-ALARM1
USECASE3-ALARM2-NO-END
USECASE-4 ; USECASE-4
USECASE-5 ; USECASE-5
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다