开云体育

ctrl + shift + ? for shortcuts
© 2025 Groups.io
  1. Ucinet
  2. Topics

Question on edgelist to matrix

 

If one converts an edgelist to a matrix, the rows and columns (nodes/actors) with all zero cells are eliminated from the produced matrix. ?what is the easiest?way to repopulate those absent?rows and columns to make up the whole original?matrix? ?so far I have been doing it by hand.? Is there an automated way in UCINet?
Thanks much.

Jeffrey Broadbent
Professor Emeritus,?
Department of Sociology
Fellow, Institute on the Environment
University of Minnesota
Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte
 

开云体育

One way to do it is to add the missing nodes to the original edgelist as a tie of node to itself. For example, john is missing from this edgelist:

?

Bill Terry

Terry Bob

Tina Bill

?

So I add John to the bottom:

?

Bill Terry

Terry Bob

Tina Bill

John John

?

(actually, you don’t even need the second John – this would work tooJ

?

Bill Terry

Terry Bob

Tina Bill

John

?

?

?

?

?

From: [email protected] <[email protected]> On Behalf Of Jeffrey Broadbent via groups.io
Sent: Thursday, February 3, 2022 16:12
To: [email protected]
Subject: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

If one converts an edgelist to a matrix, the rows and columns (nodes/actors) with all zero cells are eliminated from the produced matrix. ?what is the easiest?way to repopulate those absent?rows and columns to make up the whole original?matrix? ?so far I have been doing it by hand.? Is there an automated way in UCINet?

Thanks much.

?

Jeffrey Broadbent
Professor Emeritus,?

Department of Sociology

Fellow, Institute on the Environment
University of Minnesota

Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte
 

Hi. how do i convert edge list into a matrix. something like this into a matrix ? does ucinet takes this form as a valid input to compute centrality? or it is mandatory to convert into matrix form?
Source Target Type? Weight
1 299 Undirected 1
2 87 Undirected 1
3 423 Undirected 1
4 424 Undirected 1
5 425 Undirected 1
6 426 Undirected 1
7 427 Undirected 1

 

开云体育

Hi, paste your data into the dl editor (4th button from left on the toolbar). Click into the “type” column and choose edit it delete it. change the data format to edgelist1, the select undirected. Also click ‘Ignore first row’. In other words, make it look like this:

?

?

When you press save, the data will be converted into a ucinet dataset which you can use to perform analyses like centrality.

?

steve

?

From: [email protected] <[email protected]> On Behalf Of neha21gaur via groups.io
Sent: Friday, February 4, 2022 05:01
To: [email protected]
Subject: Re: [ucinet] Question on edgelist to matrix

?

Hi. how do i convert edge list into a matrix. something like this into a matrix ? does ucinet takes this form as a valid input to compute centrality? or it is mandatory to convert into matrix form?

Source

Target

Type?

Weight

1

299

Undirected

1

2

87

Undirected

1

3

423

Undirected

1

4

424

Undirected

1

5

425

Undirected

1

6

426

Undirected

1

7

427

Undirected

1
 

If the edge list is numbered, do you have to add in the missing nodes at their proper numbered place, or can you add them at the bottom as you did with John?

Jeffrey Broadbent
Professor Emeritus,?
Department of Sociology
Fellow, Institute on the Environment
University of Minnesota
Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte



On Thu, Feb 3, 2022 at 3:20 PM Steve Borgatti <sborgatti@...> wrote:

One way to do it is to add the missing nodes to the original edgelist as a tie of node to itself. For example, john is missing from this edgelist:

?

Bill Terry

Terry Bob

Tina Bill

?

So I add John to the bottom:

?

Bill Terry

Terry Bob

Tina Bill

John John

?

(actually, you don’t even need the second John – this would work tooJ

?

Bill Terry

Terry Bob

Tina Bill

John

?

?

?

?

?

From: [email protected] <[email protected]> On Behalf Of Jeffrey Broadbent via
Sent: Thursday, February 3, 2022 16:12
To: [email protected]
Subject: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

If one converts an edgelist to a matrix, the rows and columns (nodes/actors) with all zero cells are eliminated from the produced matrix. ?what is the easiest?way to repopulate those absent?rows and columns to make up the whole original?matrix? ?so far I have been doing it by hand.? Is there an automated way in UCINet?

Thanks much.

?

Jeffrey Broadbent
Professor Emeritus,?

Department of Sociology

Fellow, Institute on the Environment
University of Minnesota

Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte
 

开云体育

I assume that by ‘numbered’ you mean that the node names are numerical ids. As far as ucinet is concerned, these are just names. So, you can add the missing nodes anywhere. Where they end up in the matrix is determined by the ‘sort alphabetically’ checkbox:

?

?

If that is checked off, then no matter what order things were input, the matrix will be sorted from smaller id to larger id.

?

Just give it a try and see what if it does what you want it to.

?

steve

?

From: [email protected] <[email protected]> On Behalf Of Jeffrey Broadbent via groups.io
Sent: Friday, February 4, 2022 16:56
To: [email protected]
Subject: Re: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

If the edge list is numbered, do you have to add in the missing nodes at their proper numbered place, or can you add them at the bottom as you did with John?

?

Jeffrey Broadbent
Professor Emeritus,?

Department of Sociology

Fellow, Institute on the Environment
University of Minnesota

Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte

?

?

On Thu, Feb 3, 2022 at 3:20 PM Steve Borgatti <sborgatti@...> wrote:

One way to do it is to add the missing nodes to the original edgelist as a tie of node to itself. For example, john is missing from this edgelist:

?

Bill Terry

Terry Bob

Tina Bill

?

So I add John to the bottom:

?

Bill Terry

Terry Bob

Tina Bill

John John

?

(actually, you don’t even need the second John – this would work tooJ

?

Bill Terry

Terry Bob

Tina Bill

John

?

?

?

?

?

From: [email protected] <[email protected]> On Behalf Of Jeffrey Broadbent via
Sent: Thursday, February 3, 2022 16:12
To: [email protected]
Subject: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

If one converts an edgelist to a matrix, the rows and columns (nodes/actors) with all zero cells are eliminated from the produced matrix. ?what is the easiest?way to repopulate those absent?rows and columns to make up the whole original?matrix? ?so far I have been doing it by hand.? Is there an automated way in UCINet?

Thanks much.

?

Jeffrey Broadbent
Professor Emeritus,?

Department of Sociology

Fellow, Institute on the Environment
University of Minnesota

Email: broad001@...




“The world is much more interesting than any one discipline.”? – Edward Tufte
 

Hi Steve,?

I did as you suggested but unfortunately, the eigen vector centrality measures are completely out of the range, for example, for node number 1 it is something like 20.something like this:

? ? ? 1? ? ? 2? ? ? 3?
? ? ? ? ? ?Eigenv Pct Va Cum Pc?
? ? ? ? ? ? ?alue riance? ? ? t?
? ? ? ? ? ?------ ------ ------?
? ? ? ? ?1 20.049? 5.067? 5.067?
? ? ? ? ?2? 7.832? 1.979? 7.046?
? ? ? ? ?3? 5.775? 1.459? 8.505?
? ? ? ? ?4? 3.447? 0.871? 9.376?
? ? ? ? ?5? 3.162? 0.799 10.175?
? ? ? ? ?6? ? ? 3? 0.758 10.934?
? ? ? ? ?7? ? ? 3? 0.758 11.692?
? ? ? ? ?8? ? ? 3? 0.758 12.450?
? ? ? ? ?9? 2.767? 0.699 13.149?
? ? ? ? 10? 2.709? 0.685 13.834?
? ? ? ? 11? 2.709? 0.685 14.518?
? ? ? ? 12? 2.709? 0.685 15.203?
? ? ? ? 13? 2.558? 0.646 15.849?
? ? ? ? 14? 2.499? 0.632 16.481?

Seems completely odd, I also want to know how can i calculate network level and cluster level measures?

Thanks, Aakanksha
 

开云体育

Aakanksha, if you like, send me your data (sborgatti@...) and I will see if there is anything wrong. If you send the ucinet dataset, don’t forget to include both the ##h and ##d files. Or send the edgelist.

?

steve

?

From: [email protected] <[email protected]> On Behalf Of neha21gaur via groups.io
Sent: Monday, February 7, 2022 04:46
To: [email protected]
Subject: Re: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

Hi Steve,?

I did as you suggested but unfortunately, the eigen vector centrality measures are completely out of the range, for example, for node number 1 it is something like 20.something like this:

? ? ? 1? ? ? 2? ? ? 3?

? ? ? ? ? ?Eigenv Pct Va Cum Pc?

? ? ? ? ? ? ?alue riance? ? ? t?

? ? ? ? ? ?------ ------ ------?

? ? ? ? ?1 20.049? 5.067? 5.067?

? ? ? ? ?2? 7.832? 1.979? 7.046?

? ? ? ? ?3? 5.775? 1.459? 8.505?

? ? ? ? ?4? 3.447? 0.871? 9.376?

? ? ? ? ?5? 3.162? 0.799 10.175?

? ? ? ? ?6? ? ? 3? 0.758 10.934?

? ? ? ? ?7? ? ? 3? 0.758 11.692?

? ? ? ? ?8? ? ? 3? 0.758 12.450?

? ? ? ? ?9? 2.767? 0.699 13.149?

? ? ? ? 10? 2.709? 0.685 13.834?

? ? ? ? 11? 2.709? 0.685 14.518?

? ? ? ? 12? 2.709? 0.685 15.203?

? ? ? ? 13? 2.558? 0.646 15.849?

? ? ? ? 14? 2.499? 0.632 16.481?

Seems completely odd, I also want to know how can i calculate network level and cluster level measures?

Thanks, Aakanksha
 

开云体育

What you have shown are the eigenvalues not the eigenvector scores. Scroll down further to see the centrality values.


On 7 Feb 2022, at 19:18, Steve Borgatti <sborgatti@...> wrote:

?

Aakanksha, if you like, send me your data (sborgatti@...) and I will see if there is anything wrong. If you send the ucinet dataset, don’t forget to include both the ##h and ##d files. Or send the edgelist.

?

steve

?

From: [email protected] <[email protected]> On Behalf Of neha21gaur via groups.io
Sent: Monday, February 7, 2022 04:46
To: [email protected]
Subject: Re: [ucinet] Question on edgelist to matrix

?

CAUTION: External Sender

?

Hi Steve,?

I did as you suggested but unfortunately, the eigen vector centrality measures are completely out of the range, for example, for node number 1 it is something like 20.something like this:

? ? ? 1? ? ? 2? ? ? 3?

? ? ? ? ? ?Eigenv Pct Va Cum Pc?

? ? ? ? ? ? ?alue riance? ? ? t?

? ? ? ? ? ?------ ------ ------?

? ? ? ? ?1 20.049? 5.067? 5.067?

? ? ? ? ?2? 7.832? 1.979? 7.046?

? ? ? ? ?3? 5.775? 1.459? 8.505?

? ? ? ? ?4? 3.447? 0.871? 9.376?

? ? ? ? ?5? 3.162? 0.799 10.175?

? ? ? ? ?6? ? ? 3? 0.758 10.934?

? ? ? ? ?7? ? ? 3? 0.758 11.692?

? ? ? ? ?8? ? ? 3? 0.758 12.450?

? ? ? ? ?9? 2.767? 0.699 13.149?

? ? ? ? 10? 2.709? 0.685 13.834?

? ? ? ? 11? 2.709? 0.685 14.518?

? ? ? ? 12? 2.709? 0.685 15.203?

? ? ? ? 13? 2.558? 0.646 15.849?

? ? ? ? 14? 2.499? 0.632 16.481?

Seems completely odd, I also want to know how can i calculate network level and cluster level measures?

Thanks, Aakanksha

1 - 9 of 9