求助求助Python raise KeyError(key)，如何處理？

c159

Excel公式轉(zhuǎn)換為Python代碼提示錯(cuò)誤： raise KeyError(key)  KeyError: '網(wǎng)絡(luò)分類一級(jí)'，麻煩幫忙看看什么問題。

# =IF(U2="集客","是",IF(OR(AE2=" ",AE2="",AE2=","),"否","是")) U "網(wǎng)絡(luò)分類一級(jí)" AE '業(yè)務(wù)影響分類標(biāo)簽'

Python：
def zygj(a,b):
    if "集客" in a or b is np.nan or b != ",":
        return "是"
    else:
        return "否"
zxlb["是否重要故障"] = zxlb.apply(lambda x:zygj(x['網(wǎng)絡(luò)分類一級(jí)'],x['業(yè)務(wù)影響分類標(biāo)簽']))


運(yùn)行錯(cuò)誤提示：
  File "<ipython-input-61-7cbf31871cef>", line 7, in <module>
    zxlb["是否重要故障"] = zxlb.apply(lambda x:zygj(x['網(wǎng)絡(luò)分類一級(jí)'],x['業(yè)務(wù)影響分類標(biāo)簽']))

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py", line 7548, in apply
    return op.get_result()

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\apply.py", line 180, in get_result
    return self.apply_standard()

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\apply.py", line 271, in apply_standard
    results, res_index = self.apply_series_generator()

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\apply.py", line 300, in apply_series_generator
    results = self.f(v)

  File "<ipython-input-61-7cbf31871cef>", line 7, in <lambda>
    zxlb["是否重要故障"] = zxlb.apply(lambda x:zygj(x['網(wǎng)絡(luò)分類一級(jí)'],x['業(yè)務(wù)影響分類標(biāo)簽']))

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\series.py", line 882, in __getitem__
    return self._get_value(key)

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\series.py", line 989, in _get_value
    loc = self.index.get_loc(label)

  File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\range.py", line 358, in get_loc
    raise KeyError(key)

KeyError: '網(wǎng)絡(luò)分類一級(jí)'

ddd010

用

1. get

復(fù)制代碼

方法，最好設(shè)置一個(gè)默認(rèn)值。