[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 583: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 639: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4516: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3262)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4516: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3262)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4516: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3262)
Gephi forums •Gephi is dropping Edges when I import from CSV file.
Page 1 of 1

Gephi is dropping Edges when I import from CSV file.

Posted: 16 Mar 2017 03:39
by EllieUser
Gephi is dropping Edges when I import from CSV file.

While most edges import correctly, some nodes appear on the visualisation as unconnected to other nodes.

When I check the ID it is clear that these nodes should be connected to other nodes (they are targets), and when I check the data table I can see that the relevant Edges have not been imported from the CSV file. They are present in the CSV file.

It is while importing the Edge CSV file that some edges go missing. I am very concerned about this, because there could be other edges dropped that I have not detected.

I have tried on Mac and Microsoft and the same Edges are dropped each time.

This suggests two things:
There is an error with Gephi.

There is a problem with my data formatting, but I can’t see what the problem could be? What could be going wrong? Why could some edges be dropped, and others imported correctly? These nodes appear amongst the data – not at the start or the end - and when viewed as text the CSV looks perfectly uniform and correctly formatted.

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 16 Mar 2017 09:40
by xptrxptr
Several times I compared results obtained by Gephi with other network software.
And I found out that results of Gephi are different from results obtained by Ucinet, Visone or Pajek.
But I was not able to found out what is the reason - networks are larger so I could not see
from the picture that some edges are simply missing?
Could that be the reason: Gephi does not import data correctly?
If that is the case, I am really angry - that, means that all analyses that I have done so far with Gephi are wrong?

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 16 Mar 2017 16:40
by eduramiba
Hi,
What kind of CSV import are you using? There might be some bug in the import. Can you send me the file you are trying to import? Send it to eduardo.ramos [at] gephi.org

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 22 May 2017 14:04
by simone.caiello
Hi!

I am facing an analogous problem:

I should import 16.973 records (edges) but I can get finally only 2.544... and I don't understand why :(

Thank you for your help,

Simone

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 22 May 2017 14:54
by eduramiba
Please try with the latest nightly build: https://github.com/gephi/gephi/#nightly-builds

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 04 Aug 2017 12:33
by StuckenB
Hi!

I was having trouble with the same problem. Trying the nighttly build (Gephi 0.9.2-SNAPSHOT 201708032001) fixed it, but now I can't export the edges anymore. I'm getting a warning "java.lang.NullPointerException" and a broken csv file with only the first row in it. Any ideas?

Thank you for your help
Kim

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 04 Aug 2017 13:00
by eduramiba
Can you post the whole stack trace please?

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 17 Aug 2017 17:35
by eduramiba
StuckenB wrote:
04 Aug 2017 12:33
Hi!

I was having trouble with the same problem. Trying the nighttly build (Gephi 0.9.2-SNAPSHOT 201708032001) fixed it, but now I can't export the edges anymore. I'm getting a warning "java.lang.NullPointerException" and a broken csv file with only the first row in it. Any ideas?

Thank you for your help
Kim
Can you post the whole stack trace please?

Re: Gephi is dropping Edges when I import from CSV file.

Posted: 22 Aug 2017 23:08
by rodutty
I had what I thought was a similar issue, but I think it was just how I was thinking about my data. I had a CSV with multiple edges with different attributes existing between the same two nodes. When I imported from a CSV, Gephi would read the attribute for the first one correctly, then increment the edge weight for subsequent edges between the same nodes, even if the attributes were different. I guess I had expected that edges with different attributes would be added as new edges, rather than losing that additional data. In my case, I added an "Id" column to my edges table with unique values for each edge, and it seems to have solved the issue for me. Hopefully this approach might help some of you? Good luck!