I want to access an excel file with 500 by 2 matrix and check the connected nodes(bidirectional) in that matrix and the output will be a matrix with 1 represent connection otherwise 0.When I run this code,the error is"Maximum variable size exceeded"

Question

SUNANNA S S 2017-3-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329529-i-want-to-access-an-excel-file-with-500-by-2-matrix-and-check-the-connected-nodes-bidirectional-in

评论： Guillaume 2017-3-24

twitnet.csv

clc;
A = csvread('twitnet');
numnode = max(A(:));
adj = zeros(numnode,numnode); 
fromlist = A(:,1);
tolist = A(:,2);
fromtoidx = sub2ind([numnode,numnode], fromlist, tolist);  
adj(fromtoidx) = 1;
tofromidx = sub2ind([numnode,numnode], tolist, fromlist);  
adj(tofromidx) = 1;

5 个评论
显示 3更早的评论隐藏 3更早的评论

SUNANNA S S 2017-3-24

Sir, For eg: A group has six nodes, i.e., a, b, c, d, e, and f .The links of the nodes are ab, ac, ad, ae, ba, bc, bd, bf, be,cd, cf, da, dc, df, ea, ed, ef, and fe. The unique nodes of both followees and followers are a, b, c, d, e, and f . So, I want a 6 by 6 matrix x in which, a is connected to b, c, d, and e; therefore, x12 = x13 = x14 = x15 = 1. By contrast, a is not connected to a and f, therefore x11 = x16 = 0. All the other cells are assigned values using the same method. Thanks

Guillaume 2017-3-24

See also i-am-a-beginner-in-matlab-so-could-anyone-please-help-me-to-create-an-adjacency-matrix-based-on-th which seems to be the same question as this.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2017-3-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329529-i-want-to-access-an-excel-file-with-500-by-2-matrix-and-check-the-connected-nodes-bidirectional-in#answer_258456

编辑：Jan 2017-3-13

The values in tolist and fromlist are larger than the length of the input numnode. The file has 1000 rows, but only the first 500 are populated. Then using e.g. the indices 1937235 and 2589158 must fail.

We cannot guess, what you want to achieve based on the failing code only. So please edit the question and add more details.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

SUNANNA S S 2017-3-24

Sir, I had tried to get a n by n adjacency matrix in which n denotes the unique number of nodes in the dataset. For eg: A group has six nodes, i.e., a, b, c, d, e, and f .The links of the nodes are ab, ac, ad, ae, ba, bc, bd, bf, be,cd, cf, da, dc, df, ea, ed, ef, and fe. The unique nodes of both followees and followers are a, b, c, d, e, and f . So, I want a 6 by 6 matrix x in which, a is connected to b, c, d, and e; therefore, x12 = x13 = x14 = x15 = 1. By contrast, a is not connected to a and f, therefore x11 = x16 = 0. All the other cells are assigned values using the same method. Thanks

请先登录，再进行评论。