Nov-13-2020, 12:59 PM
I have this data
How do I filter this df to return data where S_ID is NOT []
N.B I pulled this data from excel and loaded it into df
Quote:Active CreateDate CreateTime UserName S_ID
TRUE 2020-11-03 00:00:00 12:04:29 M001AE8 []
TRUE 2020-11-03 00:00:00 12:04:29 M001AE8 []
TRUE 2020-11-03 00:00:00 12:02:35 M001AF0 []
TRUE 2019-06-11 00:00:00 01:32:12 M017A70 []
TRUE 2020-10-22 00:00:00 09:09:06 S345678 ['S345678']
TRUE 2020-10-22 00:00:00 09:09:06 S567456 ['S567456']
TRUE 2020-03-16 00:00:00 07:41:05 S789077 ['S789077']
TRUE 2020-03-16 00:00:00 07:41:05 S123456 ['S123456']
TRUE 2014-07-05 00:00:00 06:38:59 SvcPcc []
TRUE 2014-07-05 00:00:00 06:38:59 SvcPcc []
TRUE 2020-07-27 00:00:00 12:15:24 SvcPcc []
How do I filter this df to return data where S_ID is NOT []
N.B I pulled this data from excel and loaded it into df