Jan-09-2020, 03:28 PM
Hi,
I have data (data frame) as below. There Some duplicate entries with in same day, and want to keep last entry based on specified columns.
Desired output.
I have data (data frame) as below. There Some duplicate entries with in same day, and want to keep last entry based on specified columns.
Name Category Mode data_updated status A B Normal st_NK_20200112_01 STRY N L STD st_NK_20200112_01 SJK_check P Y Normal st_NK_20200112_01 SPL_check N L STD st_NK_20200113_00 SJK_check N L STD st_NK_20200113_01 SJK_check A B Normal st_NK_20200113_01 STRY A B Normal st_NK_20200113_02 STRY A B Normal st_NK_20200113_03 STRYI want to keep last entry based column1, column2, column5.
Desired output.
Name Category Mode data_updated status P Y Normal st_NK_20200112_01 SPL_check N L STD st_NK_20200113_01 SJK_check A B Normal st_NK_20200113_03 STRYI could not find any method, kindly help.