Help! Affinities file in Excel doesn't work in Gephi

Get help with your data
Post Reply [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
breezy68
Posts:1
Joined:25 Apr 2013 17:10
[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
Help! Affinities file in Excel doesn't work in Gephi

Post by breezy68 » 25 Apr 2013 17:17

Greetings,

I am a new user and I have a couple of questions.

I have an excel file of affinities between different cities. However, when I go to transport it into Gephi, it does not open.
What could be the cause of this problem?

Secondly, how does one interpret the graph in Gephi, based on the following data?

Hope anyone can help.

Thanks!
Attachments
International Experience Dataset.xlsx
(94.8KiB)Downloaded 235 times

admin
Gephi Community Manager
Posts:964
Joined:09 Dec 2009 14:41
[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: Help! Affinities file in Excel doesn't work in Gephi

Post by admin » 25 Apr 2013 17:25

Hi,

Gephi doesn't support .XLSX files. More info: https://gephi.org/users/supported-graph ... readsheet/

User avatar
seinecle
Gephi Community Support
Posts:546
Joined:08 Feb 2010 16:55
Location:Lyon, France
Contact:

Re: Help! Affinities file in Excel doesn't work in Gephi

Post by seinecle » 26 Apr 2013 11:49

Hi,

Your values are organized in matrix, so this network format might be adapted: https://gephi.org/users/supported-graph ... dl-format/

Best,

Clement

Post Reply
[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
[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