Hi,
I have an excel file with multiple rows of data.
The columns are:
ID - SCORE - DEPARTMENT - SPECIALIZATION - SUBJECT_ID - Subject Name
Now it is possible that a subject can be part of multiple SPECIALIZATIONS, so it will repeat itself in multiple rows.
It is also possible that a DEPARTMENT has mulriple SPECIALIZATIONS, so Department name will repeat multiple times in rows.
LAstly, a Specialization will contain multiple Subjects, so the Specialization will repeat in multiple rows too.
Now, in this case, I would like the edges to be drawn between the Department ---> Specialization ---> Subject
Some kind of network graph.
For this, what will I need to do to create the EDGE CSV file?
I read that I may need to add the Source and Target columns. But will I have to add the source target values manually? I have like 5000 rows of dummy data.
Any help is greatly appreciated. Very Very new to Gephi, so pardon if I sound ignorant
Question about Excel Import and Edges
- eduramiba
- Gephi Code Manager
- Posts:1064
- Joined:22 Mar 2010 15:30
- Location:Madrid, Spain [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Question about Excel Import and Edges
With normal spreadsheet import no, one row is always one node/edge.
But probably this plugin https://marketplace.gephi.org/plugin/ex ... o-network/ is useful for this (download from Tools - Plugins in Gephi 0.9.1).
But probably this plugin https://marketplace.gephi.org/plugin/ex ... o-network/ is useful for this (download from Tools - Plugins in Gephi 0.9.1).
-
- Posts:2
- Joined:29 Aug 2016 19:54 [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
Re: Question about Excel Import and Edges
Hi,
Thanks a lot for your reply.
The Excel import plugin did help.
Although I was only able to generate links between two columns. WAs not able to generate multiple cross linkings across three columns.
Guess I might need to try it a few times if I am missing anything.
Thanks a lot for your reply.
The Excel import plugin did help.
Although I was only able to generate links between two columns. WAs not able to generate multiple cross linkings across three columns.
Guess I might need to try it a few times if I am missing anything.