BUG: query(engine='numexpr') not work correctly when column name is 'max' or 'min'. · Issue #50937 · pandas-dev/pandas (original) (raw)

Pandas version checks

• I have checked that this issue has not already been reported.
• I have confirmed this bug exists on the latest version of pandas.
• I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

import pandas as pd

df = pd.DataFrame({'max': [1, 2, 3]}) df.query('max == 1', engine='numexpr')

Empty DataFrame

df.query('max < 2', engine='numexpr')

TypeError: '<' not supported between instances of 'function' and 'int'

Issue Description

DataFrame.query(engine='numexpr') does not work correctly when column name is 'max' or 'min'.

Because numexpr seems to have 'max' and 'min' as built-in reduction function though it is not officially documented,
pydata/numexpr#120

These keywords should be checked in pandas like 'sum' and 'prod'.
So REDUCTIONS in pandas/core/computation/ops.py may need to be updated.

Expected Behavior

NumExprClobberingError should be raised.

import pandas as pd

df = pd.DataFrame({'max': [1, 2, 3]}) df.query('max == 1', engine='numexpr')

NumExprClobberingError: Variables in expression "(max) == (1)" overlap with builtins: ('max')

Installed Versions

``` INSTALLED VERSIONS ------------------ commit : 2e218d1python : 3.9.16.final.0 python-bits : 64 OS : Windows OS-release : 10 Version : 10.0.19044 machine : AMD64 processor : Intel64 Family 6 Model 142 Stepping 10, GenuineIntel byteorder : little LC_ALL : None LANG : None LOCALE : Japanese_Japan.932

pandas : 1.5.3
numpy : 1.22.3
pytz : 2022.7.1
dateutil : 2.8.2
setuptools : 66.1.1
pip : 22.3.1
Cython : None
pytest : None
hypothesis : None
sphinx : None
blosc : None
feather : None
xlsxwriter : None
lxml.etree : None
html5lib : None
pymysql : None
psycopg2 : None
jinja2 : 3.1.2
IPython : 8.8.0
pandas_datareader: None
bs4 : None
bottleneck : None
brotli : None
fastparquet : None
fsspec : None
gcsfs : None
matplotlib : None
numba : 0.56.3
numexpr : 2.8.4
odfpy : None
openpyxl : None
pandas_gbq : None
pyarrow : 10.0.1
pyreadstat : None
pyxlsb : None
s3fs : None
scipy : 1.7.3
snappy : None
sqlalchemy : None
tables : None
tabulate : None
xarray : None
xlrd : None
xlwt : None
zstandard : None
tzdata : None