我有一个大约10000行的数据帧,并希望根据某些条件填充多列。你知道吗
如果操作系统包含“Windows Server”,那么平台使用服务器或包含('Windows 7 | Windows 10'),而不是平台使用“Workstation”
我尝试过的代码:
conditions = [
(dfADTM['Operating System'].str.contains('Windows Server')),
(dfADTM['Operating System'].str.contains('Windows 10|Windows 7|Windows XP')),
(dfADTM['Operating System'].str.contains('Cisco|SLES|OnTap|unknown'))]
choices = ['Server', 'Workstation', 'Network Appliance']
dfADTM['Platform AD'] = np.select(conditions, choices, default='Check')
print(dfADTM.head())
我面临的错误:
[Running] python -u "c:\Users\Abhinav Kumar\Desktop\weekly\code.py"
Traceback (most recent call last):
File "c:\Users\Abhinav Kumar\Desktop\weekly\code.py", line 36, in <module>
dfADTM['Platform AD'] = np.select(conditions, choices, default='Check')
File "C:\ProgramData\Anaconda3\lib\site-packages\numpy\lib\function_base.py", line 715, in select
'invalid entry {} in condlist: should be boolean ndarray'.format(i))
ValueError: invalid entry 0 in condlist: should be boolean ndarray
[Done] exited with code=1 in 7.725 seconds
你可以试试这个: `你知道吗
不是一种有效的方法,但可以完成工作
如果需要,可以删除或重置索引
相关问题 更多 >
编程相关推荐