This is the code
# show table elements
import xlrd
import numpy as np
arr=[]
z=np.zeros((11, 8))
workbook = xlrd.open_workbook('t.xlsx')
for s in workbook.sheets():
for r in range(1,s.nrows):
for c in range(1,s.ncols):
x=s.cell(r,c).value
arr.append(x)
z[r][c]=int( s.cell(r,c).value)
z= np.delete(z,0, 1)
z= np.delete(z,0, 0)
_0=z[0]
_1=z[1]
_2=z[2]
_3=z[3]
_4=z[4]
_5=z[5]
_6=z[6]
_7=z[7]
_8=z[8]
_9=z[9]
#Discernability Matrix.....
disc=[]
def Disc(fir,sec):
for i in range(len(fir)):
if(fir[i]!=sec[i]):
disc.append(chr(i+65))
return list(disc)
#print(Disc(z[0],z[3]))
ArrOfDisc=[]
for i in range(1):
for j in range(i,10):
d=Disc(z[i],z[j])
ArrOfDisc.append(d)
#print(d)
print(ArrOfDisc )
this is the data set:
0 1 1 1 1 1 1 0
1 0 1 1 0 0 0 0
2 1 1 0 1 1 0 1
3 1 1 1 1 0 0 1
4 0 1 1 0 0 1 1
5 1 0 1 1 0 1 1
6 1 0 1 1 1 1 1
7 1 1 1 0 0 0 0
8 1 1 1 1 1 1 1
9 1 1 1 1 0 1 1
and this is the output
[[], ['A', 'D', 'E', 'F'], ['A', 'D', 'E', 'F', 'C', 'F', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G', 'B', 'E', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G', 'B', 'E', 'G', 'B', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G', 'B', 'E', 'G', 'B', 'G', 'D', 'E', 'F'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G', 'B', 'E', 'G', 'B', 'G', 'D', 'E', 'F', 'G'], ['A', 'D', 'E', 'F', 'C', 'F', 'G', 'E', 'F', 'G', 'A', 'D', 'E', 'G', 'B', 'E', 'G', 'B', 'G', 'D', 'E', 'F', 'G', 'E', 'G']]
and this is the expected output:
[[], ['A', 'D', 'E', 'F'], ['C', 'F', 'G'], [ 'E', 'F', 'G'], [ 'A', 'D', 'E', 'G'], [ 'B', 'E', 'G'], [ 'B', 'G'], [ 'D', 'E', 'F'], [ 'G'], ['E', 'G']]
What I have tried:
i am trying to get the expected output