- 论坛徽章:
- 0
|
Excel公式转换为Python代码提示错误: raise KeyError(key) KeyError: '网络分类一级',麻烦帮忙看看什么问题。
# =IF(U2="集客","是",IF(OR(AE2=" ",AE2="",AE2=","),"否","是")) U "网络分类一级" AE '业务影响分类标签'
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: '网络分类一级'
|
|