Importing data into UCINET

Post date: Feb 21, 2015 10:20:14 PM

There are many ways to enter data into UCINET. If your data are in a compressed format, such as a nodelist or an edgelist, the easiest thing to do is typically to enter the data in Excel and then cut and paste from Excel into the DL Editor. Here is an example of a nodelist:

For detailed instructions on how to read a nodelist, see this document.

And here are the same data expressed as an edgelist:

For multiple relations, there is the edgelist23 format. The third column gives the relation:

(It is also possible to add a 4th column giving the strength of tie.)

A limitation of the dl editor is that, for data are organized as matrices, the editor can only handle one matrix. If you have multiple matrices, each one representing a different relation, you need to use the the matrix editor, which uses multiple tabs for multiple relations:

Note that when you save, if all of the tabs have the same dimensions and node labels, all matrices will be written to the same ucinet dataset. But if the different tabs contain data with different dimensions or labels, then only the currently visible tab will be saved.

Importing

Instead of cutting and pasting, you can also go to File|Open and open a variety of file types, including UCINET, Excel, CSV, GraphML (matrix editor only).

Command line interface (matrix algebra)

The matrix editor is available in the command line interface (CLI) by typing Edit. In addition, you can import Excel files by typing something like

->mydata = loadexcel('mydata.xls')

This creates a UCINET dataset called mydata from an excel file called mydata.xls