Data from a table

[testinggephi]

Hello,

I searched for a solution to this seemingly common problem. I read about adjacency list and concatenating data from rows. I have a table with organizations and people. How do I create edges from this kind of a table?

Code: Select all

Org Name| Person ID
---------------------- ---
Org A | 100
Org A | 101
Org A | 102
Org B | 100
Org B | 200
Org C | 300

I guess depending on the format the edges should look like this:

Code: Select all

100 -> 101
100 -> 102
101 -> 100
101 -> 102
102 -> 100
102 -> 101
100 -> 200

or:
100; 101; 102
100; 200

Is there a standard way of doing this? What's the best format for such a data? Thanks for your help.

[admin]

A CSV format encoding an edge list is enough for that: http://gephi.org/users/supported-graph- ... sv-format/

[testinggephi]

admin, thanks for reply.

First, I don't know why my message got posted in the specifications sub-forum, I thought I had posted in the data import/export sub-forum.

Second, I had gone through that csv thread before, but I don't see how I can convert that kind of a table in to edges format. It is a big table, and it would be cumbersome and could lead to inaccuracies if we were to do it by hand. There must be some kind of script that could convert such data. (SQL, python, awk, etc)