How to Query Excel with Pandas and Fix the Common NumExpr Warning

1. Introduction

A user asked a question about processing data with Pandas, which is shared here as a tutorial.

2. Implementation

Kelly suggested using the name column as an index and then applying loc to retrieve specific rows. The code example is:

df = pd.read_excel('0.xlsx')
print(df.loc[df["姓名"] == "张三", "身高"].values)

A warning may appear:

UserWarning: Pandas requires version '2.7.3' or newer of 'numexpr' (version '2.7.1' currently installed).

The cause is that the installed numexpr package is older than the required version. The fix is to upgrade the package:

pip install numexpr --upgrade --user

After upgrading, the warning disappears and the console output is clean.

3. Summary

The article covered using Pandas to process Excel data, demonstrated how to set an index and locate rows, and provided a straightforward solution to the numexpr warning, offering a reusable approach for similar data‑processing tasks.