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 import error: found rows with empty source or target columns #1489

Closed
kristinara opened this issue May 14, 2016 · 9 comments
Closed

csv import error: found rows with empty source or target columns #1489

kristinara opened this issue May 14, 2016 · 9 comments
Assignees
@eduramiba
Labels
Data Laboratory Fix Committed Spreadsheet
Milestone
0.9.2

Comments

@kristinara
Copy link

Hello:

I updated to Gephi 0.9.1 from Gephi 0.8.2. Machine is IOS with El Captain version 10.11.4.

In the old version, I was able to import .csv files with source and target columns (target columns would contain empty cells because in some cases the source didn't have a connection). I didn't have any problem uploading my file and running analysis.

After the update, I now receive an error that says "found rows with empty source and/or target columns. The source column is not empty. Target column is empty in some rows because the source might doesn't have a connection in that particular instance. Again this issue did not occur with the old version of Gephi.

Best,
Kristina
@eduramiba
Copy link
Member

Yeah, this is validated now as it was an old problem.
Not sure why you would have rows with an empty source or target.

@eduramiba eduramiba self-assigned this May 17, 2016
@eduramiba
Copy link
Member

The related commit is 4276594

@pabloivan
Copy link

pabloivan commented May 23, 2016 •
edited
Loading

Had the same error when working with metabolic networks represented as a reaction graph. Some of my nodes will be isolated from the network and this is OK. In fact, Cytoscape imports and represent these nodes, creating a node attribute "isSingleNode=yes" in these cases. I think this is an issue that should be rolled back to what it was.

@eduramiba
Copy link
Member

We could just actually remove this validation in the wizard.

@eduramiba eduramiba added this to the 0.9.2 milestone May 23, 2016
@ishalev
Copy link

ishalev commented Oct 21, 2016

I receive this error intermittently even when no source or target rows are empty. I believe that when exporting to a CSV in Excel, rows that were once populated, eg at the end of a spreadsheet, but which were eliminated, are still being seen by the validator in Gephi and detected as empty.

@eduramiba
Copy link
Member

@ishalev Make sure when you export from excel to CSV you don't have empty cells, as excel will export them to CSV as rows that look like ,,,,,

@ishalev
Copy link

ishalev commented Oct 26, 2016 •
edited by mbastian
Loading

Yes, that solves the immediate problem, thanks for the suggestion.

I'd like for gephi to detect the empty rows and not import them, or for the
wizard not to fail if it detects empty rows. The current approach ensures
that a human has to perform a maintenance/cleanup task that is trivial to
automate.

On Sat, Oct 22, 2016 at 10:50 AM, Eduardo Ramos [email protected]
wrote:

@ishalev https://github.com/ishalev Make sure when you export from
excel to CSV you don't have empty cells, as excel will export them to CSV
as rows that look like ,,,,,

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#1489 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/AGe0Gvn5muQrOlNVEzNRPCQuDvLs1AEDks5q2iLBgaJpZM4Iet3h
.

@eduramiba
Copy link
Member

@ishalev We could do that (show as warnings on import) once spreadsheet import is migrated to import API. See #1282

@malcolmlangford
Copy link

It has been impossible to delete the rows in the Excel file. I have tried everything that is advised on this problem but I am still sitting with a million+ rows in my Excel sheet, and thus the .csv file. Is there another way to solve this problem in Gelphi? Can we specify a range in Gelphi, like in Stata?

eduramiba added a commit that referenced this issue Dec 30, 2016
@eduramiba
Uploading hotfix updates for 0.9.1:
1a3bc4a 
Based on commit 6b041a4

#1526 NullPointerException on Modularity Statistics with gexf with kind / parallel nodes
#1633 Gephi 0.9.1 freezes for dynamical graphs
#1636 Ranking operation not working (node color and size)
#1640 taken screenshot will be overwritten
#1454 Suddenly not importing all of my edges
#1489 CSV import error: found rows with empty source or target columns
#1251 Multiple edges won't be merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@eduramiba eduramiba

Labels
Data Laboratory Fix Committed Spreadsheet
Projects
None yet
Milestone
0.9.2
Development

No branches or pull requests
5 participants
@eduramiba @pabloivan @ishalev @kristinara @malcolmlangford