python removing empty list inside a dataframe

Question

Ive tried a lot of combination how to remove this empty list from a dataframe, but it didnt work.

index_names = self.df[self.df['stopwords'].len()==0].index
self.df.drop(index_names, inplace=True)

dataframe called df['stopwords'] and it looks like this

goal is to delete the entire row of a dataframe with [] list

enter link description here this should find all empty lists and delete them — Shadow Edwards
– Shadow Edwards, Commented Aug 17, 2021 at 4:19

BENY · Accepted Answer · 2021-08-17 03:46:41Z

2

Try astype with bool, since [] will return False

df = df[df['stopwords'].astype(bool)]

answered Aug 17, 2021 at 3:46

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anurag Dabas · Accepted Answer · 2021-08-17 03:44:38Z

2

IIUC:

try if they are actual list object:

self.df.loc[~df['stopwords'].map(lambda x:not x)]

else if they are strings then use:

self.df.loc[df['stopwords'].ne('[]')]

answered Aug 17, 2021 at 3:44

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges