How to find substring in dataframe in python

Question

I would like to find a substring "sam" in the dataframe "df1". For example:

df1 = pd.DataFrame({'a': [1, 'sam right'], 'b': [7, 8]})
df2 = pd.DataFrame({'a': [1, 2], 'b': [3, 4]})
print(df1)
print(df2)
result = df1.str.contains("sam")
print("Result",result)
if result:
  print('*********Element exists in Dataframe************')
else:
  print('*********Element does not exists in Dataframe************')

output gives error as below. Please help.

 return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'str'. Did you mean: 'std'?

Feitan · Accepted Answer · 2021-12-13 01:51:12Z

1

Your line

result = df1.str.contains("sam")

Is close to be fine. First you can convert the DataFrame to a string:

df1.__str__()

And then check if "sam" is in the string

result = "sam" in df1.__str__()

edited Dec 13, 2021 at 1:51

answered Dec 13, 2021 at 1:30

Feitan

846 bronze badges

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

Comments

AfterFray · Accepted Answer · 2021-12-13 01:29:12Z

1

Try this :

result = df1['a'].str.contains("sam")
if result.any():
    print('Element exists in Dataframe')
else:
  print('Element does not exists in Dataframe')
Element exists in Dataframe

answered Dec 13, 2021 at 1:29

AfterFray

1,8814 gold badges19 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to find substring in dataframe in python

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