How to Filter Excel Data with Pandas: A Step‑by‑Step Guide

Hello, I'm PiPi.

1. Introduction

A few days ago a member of the Python community asked a question about using pandas to process Excel data. The original spreadsheet contains mixed Chinese and English column names, but the task is to extract rows where the "DEPT" column equals "德语系" and the "CERT_ID_F" column has a length of 10 characters.

The raw data (fields omitted for brevity) looks like this:

2. Implementation

After several attempts, the correct code was produced:

import pandas as pd

df = pd.read_excel("借阅记录.xlsx")
df1 = df[(df['DEPT'] == '德语系') & (df['CERT_ID_F'].str.len() == 10)]
print(df1)

Running the script yields the following filtered result:

This output satisfies the original request and demonstrates how to combine column value matching with string‑length filtering in pandas.

3. Conclusion

The article presented a concrete pandas solution for the Excel filtering problem, including the full code and resulting data. It illustrates a practical technique that can be adapted to similar data‑cleaning tasks.