[R] adjacency list to non-symmetric matrix

Sebastian Haunss sebastian.haunss at uni-bremen.de
Tue Feb 5 10:07:26 CET 2013

Dear R community,

is there an easy way to convert an adjacency list (or a data-frame) to a non-symmetric matrix?

The adjacency list has the following form:

person group
1 Sam a
2 Sam b
3 Sam c
4 Greg a
5 Tom b
6 Tom c
7 Tom d
8 Mary b
9 Mary d

I need the data in a matrix with persons as rows and groups as columns:

a b c d
Sam 1 1 1 0
Greg 1 0 0 0
Tom 0 1 1 1
Mary 0 1 0 1

I know that there are several possibilities in some of the network packages to convert adjacency lists to symmetric or sparse matrices, but I couldn't find a way to coerce them into affiliation matrices.

kind regards


PD Dr. Sebastian Haunss
SfB 597 - Transformations of the State
Universität Bremen
Linzer Str. 9a
28359 Bremen
T: +49-(0)421-218-56654

Recently published:
Haunss, Sebastian (2012), “Gewalt und Gewaltlosigkeit in sozialen Bewegungen”, Forschungsjournal Soziale Bewegungen 25(4): 6–16.
Leifeld, Philip, and Sebastian Haunss (2012), “Political Discourse Networks and the Conflict over Software Patents in Europe”, European Journal of Political Research 51(3): 382–409.

More information about the R-help mailing list