[SOLVED] Working with CSV's

[eduramiba]

The fix is now commited https://github.com/gephi/gephi/commit/1 ... a37b11e552 and an update should be available soon

Eduardo

[panklam]

I am having a problem maintaining column labels during import. My CSV column labels are:

Nodes / ID / CityState / Latitude/ Longitude / Network / Color / Organization / Short Name

When I import this into Gephi, these are preserved, but Gephi has added columns to the left and right:

Nodes / ID / Label

wherein the content of this Nodes column is the same as the ID column.

(I used to have the column "Short Name" named "Label" but this caused the import to use the contents of those cells as the "Nodes")

Is there something I need to do to keep my own column names intact so that I can get proper results from the edges data?

thanks \

patti

[eduramiba]

Hi,
The 'Nodes' column is a fake column necessary because nodes table is a tree-table (for nodes hierarchy). And it just always show the Node's id and label.

Label column is mandatory (and id), and they will always appear first. You should be able to name your short name column 'Label' and import the values there.

Eduardo

[kamila88]

Hi,
My problem is:
I import spreadsheet with edges (source;taget;type) and then Gephi create nodes. I want to update label to this nodes with another spreadsheet (id;label) and I want to update only nodes witch are created ealier I don't want new ones. In second spreadsheet I have more nodes than I need, so is it possibility to update only existing nodes?

[Loofy_09]

Nice post!