Python raise KeyError(key),如何处理?

510 阅读1分钟

Excel公式转换为Python代码提示错误: raise KeyError(key)  KeyError: '网络分类一级',麻烦帮忙看看什么问题。

\
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['网络分类一级'],x['业务影响分类标签']))\
\
\
运行错误提示:\
  File "<ipython-input-61-7cbf31871cef>", line 7, in <module>\
    zxlb["是否重要故障"] = zxlb.apply(lambda x:zygj(x['网络分类一级'],x['业务影响分类标签']))\
\
  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['网络分类一级'],x['业务影响分类标签']))\
\
  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: '网络分类一级'*

以上就是本次分享的全部内容,现在想要学习编程的小伙伴欢迎关注Python技术大本营,获取更多技能与教程。

101.png