Instruction: Illustrate with an example how you would update a DataFrame's column values based on logical conditions involving other columns.
Context: This question assesses the candidate's ability to perform complex, condition-based data manipulations within a DataFrame, a critical skill for data analysis and transformation tasks.