Hi,
when I export the Data-column from Gephi to Excel (Ctrl+A & Ctrl+c & Ctrl+v)......Excel can't handle the values!
I have this Data-column in Gephi....
...and I get that Excel-chart (check closeness)....
Excel shows me dates.....so if closeness is 1.8....Excel shows me 1.august!
Is it a problem by Gephi or Excel???
Maybe because the . (point) between 1 & 8....Excels needs a , (comma)?????
Maybe somebody know how to fix (in Excel)?
And how can I get the degree values to Excel??? Or is there only the screenshot???
Thanks & Greetings,
D-lam
Data export problem
- mbastian
- Gephi Architect
- Posts:728
- Joined:10 Dec 2009 10:11
- Location:San Francisco, CA [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: Data export problem
That is Excel problem. Excel has a data format for each cell, and find out its a data though it's a number.Is it a problem by Gephi or Excel???
If you right click on your cells, select "cell format" and force it to "Number".
Run the In/Out Degree statistics to have in and out degree columns.And how can I get the degree values to Excel???
-
- Posts:20
- Joined:04 May 2010 01:13 [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: Data export problem
Ahhhhh.....OK!!!
And than InDegree + OutDegree= Degree!!!!! Cool!
Excel: But when I change to numbers.....I get..... .....mhhhhhh ?????
Greetings,
D-lam
And than InDegree + OutDegree= Degree!!!!! Cool!
Excel: But when I change to numbers.....I get..... .....mhhhhhh ?????
Greetings,
D-lam