Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.
Cannot retrieve contributors at this time
Creating a network from a table of entities and their attributes
last modified: 2018-07-17
Presentation of the plugin
It converts a spreadsheet or a csv file into a network.
This plugin enables you to:
Start from a data table in Excel or csv format
In the data table, nodes are the entities listed in column A
Nodes' attributes must be listed in columns B, C, D, etc.
Connections will be created between nodes, when they have identical attributes.
Attributes can have values, stored in columns right next to the attribute.
2. The output
Figure 2. Resulting network
Installing the plugin
Figure 3. Choose the menu Tools then Plugins
Figure 4. Click on the tab Available Plugins
Figure 5. Install the plugin then restart Gephi
Opening the plugin
Figure 6. Open the plugin via the menu File - Import
Using the plugin
Figure 8. A file without headers
Figure 9. A file with headers
Figure 10. Parameter for weight
Figure 11. Confirmation panel
How is the similarity computed, exactly?
We use the cosine similarity. Sounds complicated, but it is not. Check here.
The source code for the cosine calculation is in this file, at this place.
FAQ / special notes on the plugin
1. Excel files should be .xlsx, not .xls
Because they represent two slightly different files formats, and the plugin supports only .xlsx
2. csv files are ok.
If you select a csv file, you will be asked to indicate the field delimiter and optionally the text delimiter.
Figure 12. When a csv file is selected
3. You can’t use numerical values in the attributes
Figure 13. Age is a numerical attribute
This is too bad. If there is enough demand for it I’ll add this feature, which is not trivial.
4. Each entity should appear only on one line
Figure 14. An entity appearing twice
David appears on lines 2 and 5 (because he made two purchases). Only the latest line where David appears (line 5) will be taken into account.
Press h to open a hovercard with more details.