Select rows having not empty list in pandas

Question

I have the following dataset (name of columns are just an example):

Col1 Col2 Col3 Col4
12   321    42  []
31   42     542 [stop]
65   64     41  []
754  76     431 [python]

How can I select rows having not empty list in Col4 (i.e. second and fourth rows in the above sample)?

BENY · Accepted Answer · 2020-07-06 00:00:20Z

1

Check with

subdf=df[df.Col4.astype(bool)].copy()

answered Jul 6, 2020 at 0:00

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

Derek Eden · Accepted Answer · 2020-07-06 00:27:57Z

1

could do something like this:

df[df['Col4'].astype(str) != '[]']

this just converts the column to strings to make it easier to compare an empty list

or:

df[df['Col4'].str.len() != 0]

answered Jul 6, 2020 at 0:04

Derek Eden

4,6584 gold badges22 silver badges39 bronze badges

NYC Coder · Accepted Answer · 2020-07-06 00:04:20Z

0

You can check the length of the list:

df = df[df['Col4'].apply(lambda x: len(x)) > 0]

answered Jul 6, 2020 at 0:04

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges