How to query pandas data frame where field having dot in field name

Asked Apr 06 '20 at 09:07

Active Apr 06 '20 at 09:07

Viewed 31 times

from pandas.io.json import json_normalize

record = {'a': {'b': 1, 'c': 2}}
df = json_normalize(record)
print(df.query("a.b == 1"))

Printing below error: File "C:\Python37\lib\site-packages\pandas\core\computation\scope.py", line 194, in resolve
raise compu.ops.UndefinedVariableError(key, is_local)
pandas.core.computation.ops.UndefinedVariableError: name 'a' is not defined

asked Apr 06 '20 at 09:07

kishore

use a backtick : ```df.query("`a.b`==1")``` – sammywemmy Apr 06 '20 at 09:08
@sammywemmy: I tried that. but getting SyntaxError: invalid syntax – kishore Apr 06 '20 at 18:56
and getting `pandas.core.computation.ops.UndefinedVariableError: name 'a_' is not defined` error (pandas==0.25.3) – kishore Apr 06 '20 at 19:10
working fine in pandas==1.0.3 – kishore Apr 06 '20 at 19:21

How to query pandas data frame where field having dot in field name

0 Answers0