How to query comparing strings pandas

Question

I just seccessfully did the following query:

df2.query('Neighborhood == "Not assigned"')

The result was the rows witch the value for the column "Neighborhood" was "Not assigned". (in my case zero)

I'm tryind to do this query now:

df2.query('Postal Code == "M5A"')

But I'm getting invalid syntax.

BENY · Accepted Answer · 2020-06-16 22:06:53Z

11

Adding

df2.query('`Postal Code` == "M5A"')

answered Jun 16, 2020 at 22:06

BENY

324k22 gold badges176 silver badges250 bronze badges

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

2 Comments

Solved! But where is ` on the keyboard

@bakun left to number 1 ~

NYC Coder · Accepted Answer · 2020-06-16 22:07:11Z

6

Try using backticks:

df2.query('`Postal Code` == "M5A"')

answered Jun 16, 2020 at 22:07

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges