How to fix: Error in graph.adjacency.densen Non-square matrix, Non-square matrix

Question

I am trying to do a network analysis and after some qualitative data about culture I want to see how my culture nodes are related to each other. To do this I created a csv file in Excel with 46 rows and columns, aka it is a squared matrix. I tried the following two sets of code to get a network output in R.

First attempt (did not work):

library(igraph)
my_data <- read.csv(file.choose(),header=TRUE, row.names=NULL)
my_matrix <- as.matrix(my_data)
my_first_network <- 
graph.adjacency(my_matrix,mode="undirected",diag=FALSE)
my_first_network
plot(my_first_network)

I got these errors:

Error in graph.adjacency.dense(adjmatrix, mode = mode, weighted = weighted, :
At structure_generators.c:274 : Non-square matrix, Non-square matrix
In addition:
Warning message:
In mde(x) : NAs introduced by coercion

Second attempt (also didn't work):

my_data <- read.csv(file.choose(),sep=",",header=TRUE)
nodelist <- names(my_data)[-1]
my_matrix <- as.matrix(my_data) [,-1]
rownames(my_matrix) <- colnames(my_matrix) <- nodelist
my_matrix
library(igraph)
g <- graph_from_adjacency_matrix(my_matrix, mode="undirected", 
weighted=NULL)
plot(g)

Got these errors:

Error in graph.adjacency.dense(adjmatrix, mode = mode, weighted = weighted, :
At structure_generators.c:274 : Non-square matrix, Non-square matrix

Could anybody help me by telling me what the problem is, how I can fix the code to get my network?

Thank you very much in advance

What do you mean @G5W ? Should I try and replace part of my code by that? Thank you :) — Lisanne Winter
No, Just run that code (after you have created my_matrix) and tell us the output. — G5W
[1] 61 1 # this is what I get right after I run dim(my_matrix) — Lisanne Winter
I edited my CSV document a little bit, I get this now when I run dim(my_matrix): [1] 45 0 — Lisanne Winter

JHJH JHJH · Accepted Answer · 2019-08-23T10:59:21

So like the error indicates: Non-square matrix, Non-square matrix the matrix isn't a square. The dim(my_matrix) [1] 45 0 tells the matrix is made up something like this:

 [1,]
 [2,]
 [3,]
 [4,]
 [5,]
 [..]

Could you show us the first rows of your .csv file? This can be done with head(my_data)

How to fix: Error in graph.adjacency.densen Non-square matrix, Non-square matrix

2 Answers