Data Laboratory and CSV File

[mhalsahm]

Dear everyone
I am importing a CSV file using the Data Laboratory, the columns as followed (Source, Target, Label) the format is (separator = Comma, As table = Edges table, Charset = UTF-8).
My CSV table is look like this.

Source, Target, Label
NF1, NF2, Missense_nonsense
NF1, NF2, Splicing
NF1, NF2, Small_Deletion
NF1, NF2, Small_Insertions
NF1, NF2, Small_Indels
NF1, NF2, Gross_Deletions
NF1, NF2, Gross_Insertions
NF1, NF2, Comples_Rearrangements

The problem is with the labels; the Gephi uses only the first label which is Missense_nonsense and adding 8 to the weight because there is 8 links. So in other word all the links merged together, but I want the links to be separated because each labels mean something in my network.
How can I solve this problem?

Regards
Mo

[eduramiba]

Hi,
Gephi does not support multiple edges with the same source and target, so only one of the labels can be in the edge.

Eduardo

[seinecle]

Hi,

The solution to your problem might be either to find a software which supports multiple edges between nodes (however your visualization will be very cluttered), or more probably to rethink your data in a way that fits the constraints of "one edge per pair of nodes".

=> if your edges are dynamic, with attributes varying through time, then Gephi does support it.
This means that you have a unique edge between NF1 and NF2, but the value of this edge (Small_Deletion, Small Insertion, etc.) is changing through time. For example, NF1, NF2 has the value "Small Deletion on March 1, 2012 then the value "Small Insertion" on March 2, 2012. Gephi is one of the only software which supports this type of dynamic visualization.

=> if a single edge has multiple values (without being dynamic), as your example can suggest, then you can create the edge and add the values as as many attributes (check the data laboratory: each column corresponds to an attribute. You can add as many columns / attributes as you want).

Best,

Clement

[ajay978]

Hi,
Is there a way to define edges with weights and multiple time intervals in csv file.
For e.g

Source;Target;Label;weight;Time Interval
1;2;"Edge from A to B";"2";"<[1992-02-26,1992-02-27]>"
1;3;"Edge from C to A";"3";"<[1992-02-27,1992-02-28]>"
5;6;"Edge from D to E";"2";"<[1992-02-26,1992-02-27]>"
5;6;"Edge from D to E";"5";"<[1992-02-27,1992-02-28]>"
1;4;"Edge from D to A";"5";"<[1992-02-28,1992-02-29]>"
2;3;"Edge from A to B";"6";"<[1992-02-26,1992-02-27]>"
2;5;"Edge from C to A";"2";"<[1992-02-27,1992-02-28]>"
5;6;"Edge from D to E";"20";"<[1992-02-28,1992-02-29]>"

I think it can be done in xml format by defining spells but then i have to write a program to convert csv to xml.

thanks
Ajay