CSV alternative to excel IF statement in python Read column and create a new one with numpy where or

Basic knowledge of Python.
Install the required libraries:
We'll use the pandas library for reading and manipulating CSV data and the numpy library for conditional operations.
Let's start by loading a CSV file into a Pandas DataFrame.
Suppose you have a CSV file with a column named 'Score,' and you want to create a new column, 'Result,' based on a condition. For example, if the score is greater than or equal to 50, the result is 'Pass,' otherwise 'Fail.'
Now, the DataFrame will have a new column, 'Result,' with 'Pass' or 'Fail' based on the specified condition.
ChatGPT