can some one help me prepare the data in such a format so i can run the further code.

i have downloaded a source code want to intimate the same result. the data is actually in .tsv format i have converted in txt n uploaded. i have to read this file and after reading file, i am suppose to run below mentioned code to create the biadjacency matrix. thanks in advance

bi = zeros(2901,801);
for i=1:length(matador.num)
    x=find(strcmp(proteins,matador.txt(i,4))==1);
    y=find(chemicals==matador.num(i,1));
    bi(x,y)= 1;
end

[naadiya khudabux]

waiting for guidance

Answer 1

[Walter Roberson]

mattab = readtable('matador.txt');

[uprot, ~, protidx] = unique(mattab.protein_name);
[uchem, ~, chemidx] = unique(mattab.chemical_id);
bi = accumarray([protidx, chemidx], 1);

spy(bi);

No loop required.

This might not give the table in the same order as your proteins and chemicals order. The order that will be used is alphanumeric sort order for protein name, and increasing numeric for chemical ID.

[naadiya khudabux]

actually,i want create the adjacency matrix of proteins_id and chemical_id. with 2901*801 dimension.

[Walter Roberson]

>> size(bi)
ans =
        2901         801

It already does that.