Drop Rows if value of subset is [] from dtype Object

Question

my DataFrame looks like that:

I found this but it didn´t work for me. Drop rows containing empty cells from a pandas DataFrame

i tried

df_model['Zustand'].replace("[]", np.nan, inplace=True)

df_model.dropna(subset=['Zustand'], inplace=True)

"[]" is dtype Object. I am not sure how to deal with it.

Greets Daniele

Does my answer help? Happy to assist further – wwnde May 01 '20 at 11:09 — wwnde, May 01 '20 at 11:09

score 0 · Answer 1 · answered May 01 '20 at 10:43

0

If the column contains 'list' objects:

df_model['Zustand'].apply(lambda x: np.nan if len(x)==0 else x)
df_model.dropna(subset=['Zustand'], inplace=True)

answered May 01 '20 at 10:43

arpitrathi

157
1
7

wwnde · Answer 2 · 2020-05-01T11:08:09.833

Let me use own data now that you didnt give me some

df_model=pd.DataFrame({'BildName':['D850', 'D876', 'D839','ETC'], 'Zustand':['Beto','kelo','[]','[]']})

Try

df_model['Zustand']=df_model['Zustand'].str.replace("\[\]", "")
df_model['Zustand'].replace('', np.nan, inplace=True)
df_model.dropna(subset=['Zustand'], inplace=True)

or apply mask

m=df_model.Zustand.str.contains('\[\]')

Change as you wanted

df_model.loc[m,'Zustand']=np.nan
df_model.dropna(inplace=True)

Drop Rows if value of subset is [] from dtype Object

2 Answers2