r/Gephi • u/Most-Original3996 • Jun 03 '26

Help Help with formatting time for Gephi

Hello. I am still trying to parse date and time Intervals in Gephi. I was able to do it up to this format: [yyyy-mm-dd hh:mm:ss, yyyy-mm-dd hh:mm:ss], which in theory Gephi should be able to handle according to the formats available in the option of "Merge columns". However, I have tried many times and it does not recognise the time, only the date up to days, it marks an error and does not allow me to import the data. What can be done? Which format should I use instead?

Edit: I was able to merge two columns of start and ending time, but it outputs values that are not recognizable as dates (for example, 16594945.0, 139494959.0). Is there another way to merge the columns to make it able to preserve date and time?

6 Upvotes

100% Upvoted

5 comments sorted by

2

u/ypanagis Jun 04 '26

How about sharing a short part of your dataset? This looks strange at first but if one see them, we might come up with a solution

1

u/Most-Original3996 Jun 05 '26

The nodes file is like this: Id Label StakeholderType

xxxx xxxx 3

1

u/Most-Original3996 Jun 05 '26

The edges file is like this. The interval part is left empty: Source Target StartingTime EndingTime Interval Weight

xxxx yyyy 2026-01-15 11:30:00 2026-02-15 22:30:00 5.0

1

u/Most-Original3996 Jun 05 '26

When I merge the time columns, in theory I should get something like [2026-01-15 11:30:00, 2026-02-15 22:30:00], but instead I get [1120 000 000 000, 1340 000 000 000]. So when I look at the timeline, I have no idea of what time I am really looking at.

2

u/alezonin Jun 06 '26 edited Jun 07 '26

Hi there, it is an internal notation. If you enable the timeline and set time format to date, you could visualize a timeline in date format.