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](https://stackoverflow.com/a/4842965/15095934) this should find all empty lists and delete them — Shadow Edwards, Aug 17 '21 at 04:19
[Find and delete all empty lists](https://stackoverflow.com/a/4842965/15095934) — Shadow Edwards, Aug 17 '21 at 04:20

score 2 · Answer 1 · answered Aug 17 '21 at 03:44

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 '21 at 03:44

Anurag Dabas

score 2 · Accepted Answer · answered Aug 17 '21 at 03:46

2

Try astype with bool, since [] will return False

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

answered Aug 17 '21 at 03:46

BENY

2 Answers2