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?

Community · Accepted Answer · 2017-05-23 11:59:49Z

8

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, 2017 at 11:59

CommunityBot

11 silver badge

answered Mar 17, 2015 at 15:59

Zenadix

16.4k5 gold badges29 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related