Home Wiki Blog Forum GEXF.net

Gephi forums

Community support

trouble reading in this csv

Get help with your data

trouble reading in this csv

Postby Priya70 » 31 Jan 2014 01:48

Hi ,
I'm pretty new to gephi but have gone through all the tutorials and cannot understand why it throws an error while importing
the edge file. I am attaching both( nodes file and edge file). ALso is there a way to read in a "distance matrix" into Gephi directly from a table?

thanks,
Priya
Attachments
dist_tpc_norm_cosine_edges.csv
(1.17 MiB) Downloaded 25 times
dist_tpc_norm_cosine_nodes.csv
(994 Bytes) Downloaded 23 times
Priya70
 
Posts: 1
Joined: 31 Jan 2014 01:37

Re: trouble reading in this csv

Postby seinecle » 04 Feb 2014 18:16

Hi,
If you open your csv file for edges using a text editor instead of Excel (I personally like Notepad++ on PC), you'll see that the weights are not formatted as they should:

Source, Target, Type, Id, Label, Weight
1, 2, undirected, 1, , 6.029434609400752265e-03
1, 3, undirected, 2, , 1.284227388931058478e-02
1, 4, undirected, 3, , 2.909325024332898302e-02
1, 5, undirected, 4, , 1.542636897557385645e-01
1, 6, undirected, 5, , 9.635722734894547337e-03

That's due to how excel converts to csv I suppose? You'd need of course something like:
1, 2, undirected, 1, , 0.006029434609400752265
1, 3, undirected, 2, , 0.01284227388931058478
etc...

Best,
Clement
http://www.clementlevallois.net
Gephi tutorials and personalized trainings: http://www.clementlevallois.net/training.html
Join the Gephi Facebook group for help and support: https://www.facebook.com/groups/gephi/
User avatar
seinecle
Gephi Community Support
 
Posts: 541
Joined: 08 Feb 2010 17:55
Location: Lyon, France


Return to Data Import / Export

Who is online

Users browsing this forum: No registered users and 0 guests

sports medicine portsmouth nh where to buy metronidazole