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
![Smile :)](./images/smilies/icon_e_smile.gif)