Python Pandas: How can I search for a string in a column? [duplicate]

Question

I have a DataFrame like this:

col1,col2
Sam,NL
Man,NL-USA
ho,CA-CN

And I would like to select the rows whose second column contains the word 'NL', which is something like SQL like command. Does anybody know about a similar command in Python Pandas?

Answer 1

The answer is here. Let df be your DataFrame.

df[df['col2'].str.contains('NL')]

This will select all the records that contain 'NL'.