# How can I get adjacency matrix from the interconnection pairs?

3 views (last 30 days)
Jay Vaidya on 31 Dec 2019
Commented: Jay Vaidya on 3 Jan 2020
​I have the matrix (matrix.xlsx) as attached below. This matrix.xlsx has all interconnection between nodes and corresponding weights. I want to construct an adjacency matrix from this. I know this could be easy when we use the below code:​
Graph = digraph(matrix(:,1),matrix(:,2),matrix(:,3));
plot(Graph)
B = full(A);
But I always get the B matrix to be SizeX^2 x SizeY^2.
Lets say SizeX = 51 and SizeY = 51 (as in this case). Then the order of the fig c matrix must be 51x51 with the data values filled by corresponding weights. But if I use the above method I get the order of fig c matrix to be 2601x2601 (=51*51x51*51). I am unable to get the below part fixed. Please suggest me some solutions. Thanks in advance. I have attached the matrix.xlsx file below.
##### 2 CommentsShowHide 1 older comment
Jay Vaidya on 3 Jan 2020
Hi Mr. Gambhir,
My goal is to make the color map below:
Also, I made the new thread that for this, please let me know if you can help here.

### Categories

Find more on Modify Image Colors in Help Center and File Exchange

R2019b

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by