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

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?

score 5 · Accepted Answer · edited May 23 '17 at 11:59

5

The answer is here. Let df be your DataFrame.

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

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

edited May 23 '17 at 11:59

Community

1
1

answered Mar 17 '15 at 15:59

Zenadix

11,375
3
21
39

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

1 Answers1

Related