pandas: AttributeError: 'function' object has no attribute 'contains'

Question

I have the following code to check if the value of certain column contains the given string:

my_df[my_df.name.str.contains('Mike')]

However, when I tried to make it work for all letter cases like:

my_df[my_df.name.str.lower.contains('mike')]

I got the following error:

AttributeError: 'function' object has no attribute 'contains'

What should be the correct way to call the lower() function, so I can make sure the match is case insensitive? Thanks!

Joe T. Boka · Accepted Answer · 2017-01-24 06:06:00Z

5

You can use the boolean parameter case. It's set to True by default, which is case sensitive. Thus, you should set it to False. Pandas Documentation

my_df[my_df.name.str.contains('Mike', case=False)]

edited Jan 24, 2017 at 6:06

answered Jan 24, 2017 at 5:56

Joe T. Boka

6,5896 gold badges33 silver badges49 bronze badges

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

Comments

bzimor · Accepted Answer · 2017-01-24 05:57:00Z

1

Use this:

my_df[my_df.name.str.contains('Mike', flags=re.IGNORECASE)]

Source: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.contains.html

answered Jan 24, 2017 at 5:57

bzimor

1,6262 gold badges16 silver badges26 bronze badges

Collectives™ on Stack Overflow

pandas: AttributeError: 'function' object has no attribute 'contains'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related