How to Resolve a Common Pandas Lookup Issue with Simple Loops

1. Introduction

The author, known as Pipi, shares a basic Pandas question that was raised in a Python discussion group, illustrating the problem with a screenshot.

2. Implementation

One contributor, Kelly, suggested a solution shown in the following image, and another contributor, Yu Liang, offered an alternative using a double for‑loop, also illustrated with a screenshot.

The complete code implementing the double for‑loop solution is shown below:

df = pd.read_excel("3.xlsx", header=None)

for i in range(2, len(df.columns)):
    for j in range(1, len(df.index)):
        if df.iloc[0, i] in df.iloc[j, 0]:
            df.iloc[j, i] = df.iloc[j, 1]

df = df.rename(columns=df.iloc[0]).drop(df.index[0])
print(df)

3. Conclusion

The article summarizes that the Pandas issue was successfully addressed by providing clear explanations and the exact code, helping the community members resolve the problem efficiently.