Draw a graph from an incidence matrix in Excel

Question

I am trying to study the social network of the center where I am working. I have done a compilation of relation between personal from programed meeting, formal working team, etc. to analyze structural relevant positions. I recapitulated all these information in a matrix of incidence: a square symmetric matrix which entries are related with the time two persons stay together. This matrix is in Excel.

I am looking for free software which draws a graph from the incidence matrix via importation of Excel file.

Any help?

Thank you in advance

Answer 1

So it looks like R can generated the graph youre looking for via graph.incidence in the igraph package, which can be found in CRAN. To get the incidence matrix, you can just do:

x=read.csv("C:/yourfilenale.csv")
matrix.pickaname <- as.matrix(x)

Though, it seems that this solution only works if the .csv is only the data, no headers. If you still have string values in the file, it gets imported as a data.frame.