Label Excel Rows by Keywords with Pandas: A Quick Python Guide

1. Introduction

The author received a question in a Python community about processing Excel data with pandas. The task is to examine column A for specific brand keywords and write a label into column C: if the cell contains any of ['吉利','奔驰','福特'] label it as "汽车品牌" (automobile brand); if it contains any of ['NIKE','李宁','安踏'] label it as "运动品牌" (sports brand).

2. Implementation

A concise solution is provided using pandas to read the Excel file, a custom function to perform the keyword matching, and the apply method to generate the new column.

import pandas as pd

df = pd.read_excel("测试数据.xlsx", names=["A", "B"])

def match_word(word):
    for w in ('吉利', '奔驰', '福特'):
        if w in word:
            return "汽车品牌"
    for w in ('NIKE', '李宁', '安踏'):
        if w in word:
            return "运动品牌"
    else:
        return None

df["res"] = df["A"].apply(lambda x: match_word(x))
print(df)

The function checks each keyword list sequentially and returns the appropriate label; if no keyword matches, it returns None. Running the script produces the expected labeling in the new column.

3. Conclusion

This short guide shows how pandas can be leveraged to perform keyword‑based classification directly on Excel data, offering a practical example for data‑processing tasks in Python.