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技术大本营,获取更多技能与教程。