I have an excel sheet wher column a is test case, column b is either yes or No, column c is name of

I have an excel sheet where column a is test case, column b is either yes or No, column c is name of function associated with test cases. I am executing the test case through that excel and saving the result in our repository (QC KIND OF REPOSITORY)and now I want to create another column in my excel with status as pass or fail based on execution. (If the test case is passed, it should write pass or if it is fail, it should write fail. dynamically). Please and please  help and important thing is this should be in PYTHON.

I am attaching the excel  for reference