Labels appear in the Id column and the Label column remains empty

140 Views Asked by At

Importing nodes, the labels appear in the Id column and the Label column remains empty:

Wrong ID column

1

There are 1 best solutions below

2
Yannis P. On

Your error comes from the fact that you are not using a separate field id for each node, a field that should be added before any other fields. Gephi is automatically an id for your nodes and tries to map the edges to the existing ids. As this seems to fail, Gephi appends at the nodes tables the ids it cannot find basically every node in your edge list.

An improved approach should use thhe following spreadsheet for the nodes:

id  label
1   social media 
2   mobile money technology 
3   social media equity
4   justice for employees
5   five-factor model
6   the global belief in a just world
7   justice for the self
8   consumer personality
9   empowerment 
10  brand advocacy
11  stimulus-organism-response theory
12  hotel satisfaction
13  mobile money agent
14  africa
15  continuous usage

and the next one for the edges:

Source  Target
8   8
8   5
8   1
8   3
2   14
2   15
2   9
2   13
2   2
2   11
10  12
10  4
10  7
10  10
10  6

Here is how the Data Laboratory looks.

Nodes

Nodes

Edges

Edges

I improvised a bit but I hope this will work for you. It seems imho close to what you wanted to achieve.

A very good and detailed tutorial for importing CSVs for nodes and edges can be found here.

NOTE: In the import you are showing in your comments, you seem to connect eg consumer personality to itself. Gephi does not allow it right now and will pop up a message after the imports, saying that 3 self-loops were removed.