输出数组中满足条件元素的坐标 :(第一维坐标array,第二维坐标array)
1、输出数组中满足条件元素的坐标例子
limvalue = pd.read_excel(io=io, sheet_name=sheet_name).values #提取数据
chosen_index=np.where(limvalue==0) #输出满足条件(出现 0)元素的坐标 :(第一维坐标array,第二维坐标array)
print(chosen_index)
结果:
(array([ 55, 55, 55, 55, 55, 55, 55, 55, 55, 55, 55,
55, 55, 55, 55, 55, 55, 55, 373, 373, 373, 373,
373, 373, 373, 373, 373, 373, 373, 373, 373, 373, 373,
373, 373, 373, 433, 433, 433, 433, 433, 433, 433, 433,
433, 433, 433, 433, 433, 433, 433, 433, 433, 433, 454,
454, 454, 454, 454, 454, 454, 454, 454, 454, 454, 454,
454, 454, 454, 454, 454, 454, 1254, 1254, 1254, 1254],
dtype=int64), array([ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
17, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
16, 17, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15, 16, 17, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17, 10, 11, 12, 13], dtype=int64))
2、进一步挑选:删除重复数
chosen_index=chosen_index[0] #选取行坐标
chosen_index=list(set(list(chosen_index))) # 利用set() 函数创建一个无序不重复元素集合
print('\n结果出现 0 的行序号:',chosen_index)
#set是无序集合,python不保证其中元素的次序。打印结果取决于其内部存储结构和输出方式。
结果:
结果出现 0 的行序号: [1254, 454, 433, 373, 55]