Gephi forums

Re: Data preparation to show correlation beetween classes and keywords

2017-10-01T19:26:46+01:00

Are you still using 0.9.1? 0.9.2 is newer and more stable and friendly but you will have to change the extension from txt to csv (no changes required to the file).

4 million should work but you might need to increase gephi memory limit in gephi.conf

Statistics:Posted by eduramiba — 01 Oct 2017 19:26

Re: Data preparation to show correlation beetween classes and keywords

2017-10-01T18:38:03+01:00

Ahhh thanks!!
As .txt file without BOM it is working.

Now I can test a bit.

Thanks again!

Another question... I have about ~4 million keywords for this 10 classes. Are they too many, or could it work?

Statistics:Posted by Chazu1989 — 01 Oct 2017 18:38

Re: Data preparation to show correlation beetween classes and keywords

2017-10-01T17:39:08+01:00

Hi,
Try to use .csv (or even .xlsx) extension. Also never include the BOM.

Statistics:Posted by eduramiba — 01 Oct 2017 17:39

Re: Data preparation to show correlation beetween classes and keywords

2017-10-01T17:12:51+01:00

Thanks for your fast reply.

But I'm a "little" bit confused:

The keywords shouldn't have a connection among each other but only to the classes.
So I have created the following two files.

Nodes.txt as UTF8 with BOM

Edges.txt

Edges.txt as UTF8 with BOM

Nodes.txt

But if I want to import the edges table, I am getting the error message: Edges table needs a 'Source' and 'Target' column with nodes ids

Statistics:Posted by Chazu1989 — 01 Oct 2017 17:12

Re: Data preparation to show correlation beetween classes and keywords

2017-10-01T16:25:58+01:00

You can use spreadsheet import and name your classes and keywords columns as source and target.

https://gephi.org/users/supported-graph ... readsheet/

Statistics:Posted by eduramiba — 01 Oct 2017 16:25

Data preparation to show correlation beetween classes and keywords

2017-10-01T15:41:40+01:00

I'm totally new to Gephi and I have already problems ... at first with the data preparation.

I have the following data (sample):

What I want to do is to show a correlation between the keywords and the classes. So actually it should be a simple task but I don't get it.

Classes are from 0 to 10 and an individual keyword can occur multiple times and can be connected to different classes.

For example:
"Keyword 1" can have a connection to "Class 1" and "Class 6"
"Keyword 2" can have a connection to "Class 2"
"Keyword 4" cann have a connection to "Class 8", "Class 6" and "Class 2" and so one.

What I want to do, is to show the classes as nodes and the keywords around them. They are connected with a line which has a different thickness depending on the number of connections of the respective keyword with the class.

Example with paint

I am totally lost I hope anyone can help me with that.

Statistics:Posted by Chazu1989 — 01 Oct 2017 15:41