A Simple Pandas Trick to Check Columns and Assign Scores

Introduction

Hello, I'm PiPi. A few days ago I asked a Pandas question in the Python Silver group, and I'm sharing the solution here.

The previous article by Kelly and Yu Liang provided an approach and code; this article explores an alternative method.

Implementation

The contributor "Strawberry Freeze" offered the following solution:

# 只判断 ABCDE 列是否在行存在
df1_cols = df1.columns.drop('score')

# 如果存在则赋值为 score 列, 否则为0
df1[df1_cols] = df1[df1_cols].apply(lambda x: pd.Series(x.index.isin(x.name.split(',')) * 1), axis=1) * df1[['score']].values

During implementation there were minor issues, but they were not serious.

After modifications, problems persisted, as shown below.

Sometimes, without hands‑on practice, it's hard to gauge the difficulty of the process.

Conclusion

This article addresses a basic Pandas problem, providing detailed analysis and code to help readers solve it smoothly.

Thanks to the questioner and contributors for their ideas and code explanations.

Tip: When asking questions in groups, consider data sanitization, share small demo files, include reproducible code, attach error screenshots, and if the code exceeds 50 lines, share a .py file.