Adjacency list on an excel spreadsheet

[DenisL]

Hi,

Here's my problem.

I am currently working on a my Phd thesis and I want to get a graph visualizing relation between 55 french officers during their carreers. I already code their carreers files in a big excel files. From this table, I manage to get a other table where I can see where and when did they meet during their carrers.
Lines are monthes in a unit, and columns are officers. Something like that:

Unit, Month, officer1, officer2, officer3, officer4, ...
3RI, Oct-52, 0 , 1 , 1 , 0
3RI, Nov-52,1 , 1 , 1 , 1

It means that in october 52, officers 2 and 3 are in the 3d régiment d'infanterie. Officer 1, 2 and 3, in november 3.

Working a little bit further, I manage to get something like that:

2,3
1,2,3,4

In http://gephi.github.io/users/supported- ... sv-format/, it seems to look like a mixed adjacency list.
Here is my main problem. I don't know how should I name the columns. The two first ones are Source,Target. But what about the others ("3" and "4" in the 2d line)? Is it only possible to do that? Same question with a adjacency table... The "Cvs Format" and "Spreadsheet (Excel) page is not clear on this point but I must confess I am not a native English speaker nor a databases specialist...

An other point.
I want to get an non oriented graph. So:
1,2,3 does'nt mean 1->2, 2->3
but
1-2, 2-3 and 3-1

Is it possible with a Type column specifying "Undirected"? Or something else?


Thanks per advance to anyone helpful... and sorry for my English...

Denis

[borisgorelik]

Take a look at the "Mixed" example in the link you have mentioned. It is almost identical to the example you posted here. You don't have to name the columns, just list the connections and save them in a CSV file.
Next, when you open the file you will see dialog similar to this: http://imgur.com/M4O8LQy

Simply select "Undirected" and you are done. Make sure to save the graph in gephi format after you modify the it, perform calculations and the such.