如何将Excel公式转换为Python/伪代码

Question

我正在尝试将列CB的Excel公式转换为伪代码，然后我可以将其添加到我的Python脚本中。我已经查看了Excel的结构化参考文档，但仍然没有得到一些东西。

=IF(CA2="NO",IF(OR(I2="X", I2="D", I2="V",I2="VE",I2="0.2 PCT ANNUAL CHANCE FLOOD HAZARD", 
I2="AREA NOT INCLUDED"), "UnMapped",IF(LEFT(R2,3)="NON","UnMod","Modernized")),IF(OR(BJ2="X", 
BJ2="D", BJ2="V",BJ2="VE",BJ2="0.2 PCT ANNUAL CHANCE FLOOD HAZARD", BJ2="AREA NOT INCLUDED"),
"UnMapped",IF(LEFT(BK2,3)="NON","UnMod","Modernized")))    

在第一次IF(OR...)声明之后，我陷入了如何处理"UnMapped"的困境。这是我到目前为止的伪代码：

IF CA = "NO":
IF (I2="X" OR I2="V" OR I2="V" OR I2="VE" OR I2="0.2 PCT ANNUAL CHANCE FLOOD HAZARD" OR I2="AREA NOT INCLUDED"):
IF (LEFT(R2,3)="NON" OR LEFT(R2,3)="NON" OR LEFT(R2,3)="Modernized"):
ELSE IF (BJ2="X" OR BJ2="V" OR BJ2="V" OR BJ2="VE" OR BJ2="0.2 PCT ANNUAL CHANCE FLOOD HAZARD" OR BJ2="AREA NOT INCLUDED"): 
IF (LEFT(BK2,3)="NON" OR LEFT(BK2,3)="UnMod" OR LEFT(BK2,3)="Modernized"):

"未映射"应该去哪里？

Answer 1

我想这可能是你要找的：

if CA2=="NO":
if (I2=="X" OR I2=="V" OR I2=="V" OR I2=="VE" OR I2=="0.2 PCT ANNUAL CHANCE FLOOD HAZARD" OR I2=="AREA NOT INCLUDED"):
return "UnMapped"
elif (LEFT(R2,3)=="NON"):
return "UnMod"
else:
return "Modernized"
elif(BJ2=="X" OR BJ2=="V" OR BJ2=="V" OR BJ2=="VE" OR BJ2=="0.2 PCT ANNUAL CHANCE FLOOD HAZARD" OR BJ2=="AREA NOT INCLUDED"):
return "UnMapped"
elif(LEFT(BK2,3)=="NON"):
return "UnMod"
else:
return "Modernized"