使用Python将CSV行中的特定文本解析为新列

我有一个csv文件,该文件在我想提取到新列的字段中具有文本块。例如,我的csv如下所示:

house, paint, status-text house1, green, this house is nice it gets a status of result: PASS this is good house2, red, this house is not too nice it gets a status of result: FAIL this is bad house3, blue, this house is the best it gets a status of result: PASS this is great,

我想运行一个简单的正则表达式将(结果:PASS)或(结果:FAIL)拉出到新列中,因此CSV现在看起来像下面:

house, paint, status-text, status house1, green, this house is nice it gets a status of result: PASS this is good, PASS house2, red, this house is not too nice it gets a status of result: FAIL this is bad, FAIL house3, blue, this house is the best it gets a status of result: PASS this is great, PASS

我当时正在考虑使用Pandas数据框,但不确定如何解析(PASS / FAIL)并将其移至3行的自己的列中,并可能将其缩放到数百行。如何作为一个小样本来完成此操作的任何示例将不胜感激。