Gephi

How to import time interval data (hh:mm:ss) into Gephi data sheet

Asked by Clarence Lui

I have tried to import time interval data into Gephi for dynamic graphs. Following the instructions in the Gephi manual, I have been able to import the date section (yyyy-mm-dd) into the data sheet, but not the time section (hh:mm:ss). My original date and time format was already in the format, e.g. 2010-10-13T16:41:35Z in an Excel file.

Hope someone can help explain the procedure for importing time interval data into Gephi.

Thanks.

Question information

Language:
English Edit question
Status:
Solved
For:
Gephi Edit question
Assignee:
No assignee Edit question
Solved by:
Eduardo Ramos
Solved:
Last query:
Last reply:
Revision history for this message
Sébastien Heymann (sebastien.heymann) said : 		#1

Hi, do you use a GEXF file? There is a manual for it, but no manual for Gephi itself. I'm not sure that we support timestamps in Spreadsheet import.

Revision history for this message
Eduardo Ramos (eduramiba) said : 		#2

Hi,
The right syntax for timestamps is 2010-10-13T16:41:35 (and optionally include milliseconds with 2010-10-13T16:41:35.xxx)
A file like this works for me:

Id,Label,TimeInterval
1,1,"<[2010-10-13T16:41:35, 2010-10-13T16:46:35]>"

Notice the double quotes because the comma character is the column separator.

Revision history for this message
Clarence Lui (cwklui) said : 		#3

Thank you for your suggestion. It worked using your suggested format.

What would be the format to use if I want to import only the start time and there is no end time?

I have tried 1,1,"<[2010-10-13T16:41:35, 0000-00-00T00:00:00]>", or
1,1,"<[2010-10-13T16:41:35, ]>", or
1,1,"<[2010-10-13T16:41:35]>", or
1,1,"<[2010-10-13T16:41:35, infinity]>", but they did not work.

I want to have <[2010-10-13T16:41:35, infinity]> in the TimeInterval column of the Data Table.

Hope you can give my some ideas to try.
Thanks.

Revision history for this message
Best Eduardo Ramos (eduramiba) said : 		#4

Hi,
"Infinity" needs an upper case first letter. That should work.
El 25/05/2012 04:55, "Clarence Lui" <email address hidden>
escribió:

> Question #198168 on Gephi changed:
> https://answers.launchpad.net/gephi/+question/198168
>
> Status: Answered => Open
>
> Clarence Lui is still having a problem:
> Thank you for your suggestion. It worked using your suggested format.
>
> What would be the format to use if I want to import only the start time
> and there is no end time?
>
> I have tried 1,1,"<[2010-10-13T16:41:35, 0000-00-00T00:00:00]>", or
> 1,1,"<[2010-10-13T16:41:35, ]>", or
> 1,1,"<[2010-10-13T16:41:35]>", or
> 1,1,"<[2010-10-13T16:41:35, infinity]>", but they did not work.
>
> I want to have <[2010-10-13T16:41:35, infinity]> in the TimeInterval
> column of the Data Table.
>
> Hope you can give my some ideas to try.
> Thanks.
>
> --
> You received this question notification because you are a member of
> Gephi Team, which is an answer contact for Gephi.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~gephi.team
> Post to : <email address hidden>
> Unsubscribe : https://launchpad.net/~gephi.team
> More help : https://help.launchpad.net/ListHelp
>

Revision history for this message
Sébastien Heymann (sebastien.heymann) said : 		#5

I opened an issue to support both: https://github.com/gephi/gephi/issues/631

Revision history for this message
Clarence Lui (cwklui) said : 		#6

Hi,

I have tried Eduardo's suggestion and it worked.

Thanks.

Revision history for this message
Clarence Lui (cwklui) said : 		#7

Thanks Eduardo Ramos, that solved my question.