Matrix

Some network data sets are created or received in the form of a matrix.

A matrix can be directed or undirected. In this example, we will import a directed network.

First open a blank NodeXL template.

Next open the matrix workbook in the same instance of Excel (just drag it into the title bar of the current NodeXL Excel instance).

Here is a simple asymmetric matrix with weights for tie strengths.

To import this matrix, switch back to NodeXL and select the Data>Import>From Open Matrix Workbook:
2015-NodeXL-Matrix Import

A matrix may or may not have labels (row and column headers) and the user should define what their data set looks like.

The matrix may represent a directed or undirected network (if it is undirected the matrix must be symmetrical!).

This results in data appearing in the Edges worksheet of NodeXL:
2015-NodeXL-Matrix Edges

This can then be visualized as a network where the edge weights are used to set the thickness of the lines connecting two nodes:

There is a new version of NodeXL (v.79) available.

Please help build visibility for NodeXL on Digg by digging this link.

Many network analysts store their data in the form of a matrix in which each entity in the network is repeated as row and column headings. Whenever two entities have a relationship a value is entered in the cell at the intersection of their row and column. The same data can be represented in the form of an “edge list” in which each pair of entities are represented by the pairs of their names in a single line. Node lists can be more compact, particularly when netwrks are relatively sparse. Matrices are a very popular form of data format for network analysts, however, and with the latest release of NodeXL, the add-in now supports the use of this data format.

http://www.codeplex.com/NodeXL/Release/ProjectReleases.aspx

NodeXL Version 1.0.1.79 (2009/3/22)

* You can now import a graph that is stored as an adjacency matrix in another Excel workbook. In the Excel Ribbon, go to NodeXL, Graph, Import, From Open Matrix Workbook.

* You can also export a NodeXL graph to a new Excel workbook as an adjacency matrix. Go to NodeXL, Graph, Export, To New Matrix Workbook.

* The term “Tie Strength” has been replaced with “Edge Weight.”

* Bug fix: Certain sequences could lead to an assertion. The assertion message started with “at ExcelUtil.TryGetSelectedTableRange(…” One such sequence that caused this: Use Excel’s table filtering to filter the Edges table, select the Vertices worksheet, and click Read Worksheet. Another such sequence: Filter the Edges table, select the Vertices worksheet, and click Calculate Graph Metrics.

* Bug fix: Vertex tooltips in the graph pane, which can be added to the graph with the Tooltips column in the Vertices worksheet, were partially obscured by the mouse cursor.

M	T	W	T	F	S	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Your Cart