Drop rows with missing values with pandas dropna // Python pandas dropna, subset, axis, thresh

[@ziggle314]

Great presentation! You showed how really versatile dropna with its different parameter options. Thank you.

[@KimberlyFessel]

Thank you! Glad you liked it, and yes, I totally agree. Many of these pandas methods and functions are super versatile. My main goal for this Pandas Tips series is to show how you can enhance the basic pandas commands to perform lots of useful tasks.

[@henry-zh3rv]

I have a dataset that has [x] in two rows. I have tried different ways to remove these rows but none have worked. I have also tried replacing the values with NaN and tried the dropna function but this has not worked. Does anyone know how I can drop these rows?

[@KimberlyFessel]

Hi there - say you have a dataframe called df and the column with those values is called "col", you could probably do something like this: df = df[df["col"] != "[x]"]
That overwrites your current dataframe with a dataframe that excludes rows with "[x]" values in the "col" column.

[@minhnguyen-om1cb]

What a great video! Thank you so much for your explanation!

[@KimberlyFessel]

Thank you! You are most welcome and thanks for stopping by ☺

[@MS-dc2tt]

Thank you! You explained it very well

[@KimberlyFessel]

Glad it was helpful! Cheers! 😀

[@jas0609]

Thank you! 👍

[@KimberlyFessel]

Most welcome - cheers! 😄

[@easyprogramminglessons2943]

Mam, im also programmer. I have subscribed your channel

[@KimberlyFessel]

Cheers! 😃

[@farhodomonov]

💯

[@yellowmathboard]

Wow such a nice way to present this topic in data science. Thank you !!

[@KimberlyFessel]

Glad you liked it! 😄

[@Kiki-g3g]

She's back! Thank you!

[@KimberlyFessel]

Awwww yeah! Most welcome 😁