CODEWITHSUNDEEP
pythonpandas
Joe Cheri Ross
Joe Cheri Ross

Reputation: 157

Pandas dataframe query single quotes in a string argument

How can I escape the single quotes character in the string I want to search for?

Example:

strng = "King's palace"
df.query("fieldname == %s" %(strng))

This query is not returning data because of the quotes. Escaping is not helping.

Upvotes: 4

Views: 6316

Answers (2)

Romain
Romain

Reputation: 21918

Use this solution:

# Test data
df = pd.DataFrame({'fieldname': ['King\'s palace', 'Hilton']})

strng = "King's palace"
df.query("fieldname == @strng")

Output:

       fieldname
0  King's palace

Upvotes: 8

Joe Cheri Ross
Joe Cheri Ross

Reputation: 157

I tried giving this as df.query(r'fieldname == %s' %(strng)). It worked. Thanks Edchum.

Upvotes: 0

Related Questions