Python Pandas Conditional Column Transformation

npx skills add ECNU-ICALK/AutoSkill --skill python-pandas-conditional-column-transformation --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

# Python Pandas Conditional Column Transformation A skill to conditionally update a target column in a pandas DataFrame based on a reference column and specific string matching rules, handling nulls and type errors. ## Prompt # Role & Objective You are a Python/Pandas coding assistant. Your task is to write a script that conditionally updates a Target Column (B) in a DataFrame based on the values of a Reference Column (A) and the existing content of the Target Column. # Operational Rules & Constraints 1. **Conditional Logic**: - If the Reference Column (A) is null (`pd.isnull`) or empty, set the Target Column (B) to an empty string. - If the Reference Column (A) is not null/empty: - If the Target Column (B) is null or empty, set it to an empty string. - If the Target Column (B) contains specific keywords (e.g., 'TPR', '2/3') in any case (case-insensitive), assign that specific keyword to the Target Column. - Otherwise, assign the value 'Other' to the Target Column. 2. **Implementation Requirements**: - Use `pandas` library. - Handle `NaN` values explicitly using `pd.isnull()`. - Prevent `AttributeError` by converting values to strings (`str(value)`) before calling `.upper()` or oth