1 Topic by karennew (edited by karennew 2024-09-29 20:37:22)

  • karennew
  • Member
  • Offline

Hello,
I have a question concerning changing a time format to R friendly (as.POSIXct).
geometry dash breeze
When exporting kinematic time points from Kinovea into an XML spreadsheet, time column data is printed out in the following format: 0:00:02:886 (693). If I have understood this correctly as a beginner in R, I have to first be able to write a code that isolates away "(693)" from the code, then adding also the current date, because isnt as.POSIXct format specifically as example: ("1971-05-14 11:25:15")?

2 Reply by joan

  • joan
  • joan
  • Admin
  • Offline

Hi,
Do you really need a date-time format or just something numerical to do arithmetic on?
What version of Kinovea are you using? Recent versions will always export the time column in numerical format which R should be happy with (although I'm not familiar with it let me know if it really requires a date-time). If your time units inside Kinovea is set to time code or time code + frame number it will be automatically converted to seconds for spreadsheet export.