Dropping dataframe rows based on conditional

Question

I have a DataFrame below:

data = [['tommy', 'manny'], ['krishan', 'sony'],
       ['nick', 'nady'], ['julie', 'stephen']

df = pd.DataFrame(data, columns =['First_Name', 'Last_Name'])

I would like to drop off rows if their 'Last_Name' column has a len() of < 5. Which in this case, rows containing Krishan and Nick would be dropped. But I'm unable to do it, any advices? Thank you.

Methods tried:

I have tried this code and other similar variations but it didn't work.

df.drop(df[len(df['Last_Name']) < 5].index, inplace = True)

BrokenBenchmark · Accepted Answer · 2022-12-22 20:34:52Z

1

You can use .str.len():

df = df[df["Last_Name"].str.len() >= 5]

This outputs:

  First_Name Last_Name
0      tommy     manny
3      julie   stephen

answered Dec 22, 2022 at 20:34

BrokenBenchmark

19.4k7 gold badges26 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

Dropping dataframe rows based on conditional

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related