pandas best practices (6/10): Using string methods

This video covers the following topics: searching strings, math with booleans, value counts, dropna parameter.

NEW TO PANDAS? Watch my introductory series (30+ videos):

DOWNLOAD the dataset and notebook:

SUBSCRIBE to learn data science with Python:

JOIN the "Data School Insiders" community and receive exclusive rewards:

LET'S CONNECT!

[DavidsonLoops]

I love your teaching style. You know you're good when even a noob understands exactly what's going on

[vishalaggarwal]

If we want to display the rows containing "Frisk" in search_type column??
I have tried " but got error--> ValueError: cannot index with vector containing NA / NaN values

and can you explain the error please!!

[TheGautamj]

I have a doubt here -

if the value_counts() for ‘Protective Frisk’ in search_type is 161, how are we getting 2922 and 274 as False and True when we do ri.frisk.value_counts()
Should we not get 161 for True? Unable to wrap my head around this.

Would be grateful if someone could explain. Thank you.

[markarmon]

I have a question. What if one of the search_type data have more than one "frisk" strings, like {Inventory, Protective Frisk Frisk}, does this code {ri["frisk"] = works?

[mountainscott]

Much faster than using pd.Series.isin()!