Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

CSV Edges file not importing because Gephi does not detect Source and Target columns #2178

Closed
helenacaecilia opened this issue Mar 15, 2020 · 3 comments
Closed

CSV Edges file not importing because Gephi does not detect Source and Target columns #2178

helenacaecilia opened this issue Mar 15, 2020 · 3 comments
Assignees
@mbastian
Labels
Fix Committed Spreadsheet
Milestone
0.9.3

Comments

@helenacaecilia
Copy link

Expected Behavior

I expect to see the data from the edges spreadsheet (source;target;type) in the Edges tab of the Data Laboratory in Gephi after importing this through the "Import Spreadsheet" function.

Current Behavior

Hi all!

I am trying to make a network visualization in Gephi for my master’s thesis, but my Edges files won’t import. The Nodes file works fine, but the Edges file won’t import because Gephi does not detect the Source and Target. The csv file contains different columns (Source, Target, Type and Weight), and the source and target columns have ids of the nodes. I tried the same thing using a csv file with just the source and target columns. Either way, Gephi tells me that "Edges Table needs a Source and Target column with node ids,” while I do have columns with those exact names.

Is there anyone who could help me out? I would be so grateful! 



Possible Solution

I heard that spaces can cause issues, but I cannot detect any in my Edges file.

Your Environment

  • Version used: Gephi 0.9.2
    Gephi
@eduramiba
Copy link
Member

Hi,
Please make sure there are no leading spaces or tabs before the Source or Target column names, they should be trimmed.

@nicoleeesim
Copy link

Hi, I faced this problem as well. This resource has helped me greatly: http://forum-gephi.org/viewtopic.php?t=2763

I used Notepad++ to change the encoding to UTF 8 and imported the files again
image

@mbastian mbastian added this to the 0.9.3 milestone Oct 26, 2021
mbastian added a commit that referenced this issue Dec 23, 2021
@mbastian
Small fix for issue #2178
488e7d4
@mbastian mbastian self-assigned this Dec 23, 2021
@gskarp gskarp mentioned this issue Mar 28, 2022
Closed
@zelucasccp
Copy link

zelucasccp commented Apr 8, 2022 •
edited
Loading

For those who still have this problem, I managed to solve it by simply opening the file in a notepad, the "Source" and "Target" columns were in this format: ....,"""Source""","""Target" "",.....
Then I left it with just one quote on each side and saved the file again and it worked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mbastian mbastian

Labels
Fix Committed Spreadsheet
Projects
None yet
Milestone
0.9.3
Development

No branches or pull requests
5 participants
@eduramiba @mbastian @nicoleeesim @helenacaecilia @zelucasccp