I am having a question regarding to the workflow from post 2 in that thread
is it possible to get a new timestamp every time, when the values changes from Loiter to Auto?
Perhaps I can use Lag Column and moving Agrregation. For that purpose? But if so… I haven’t found a way doing so
this sounds like you would need to loop this. Can you make me an example where you have the loiter/Auto column and how you want to have those timestamps assigned than?
super thanks for your help and I am very sorry for my late response! Please find attached a picture how I would like to have the solution. The timestamp should use milliseconds and append in a new column.
Not sure I understand. You want create artificial timestamp when change occurs? And within same auto/loiter group have same timestamp value? Your picture is a bit confusing…
I am very sorry for the confusion. Let me explain.
I am reading Log Files from a Drone and use these files for Deep Learning. The Drone is creating – every time when LiPo gets plugged in a Timestamp. That timestamp starts, when the Drone has a 3D Fix Position.
For the Deep learning approach, I only need the Timestamp for some maneuvers and not for the hole flight. That means that every time when the Values in Column Batch changes from loiter** to Auto** it should generate a new Timestamp in milliseconds.
I know that the Timestamp is supposed to be unique. But for Decision Trees and some other Algorithm’s, I perhaps get better results, when the training-data knows, how long one maneuverer has been taken. I tried to implement that with moving aggration and lag column, but I was unlucky.
ok. Not sure what you are doing. Creating Timestamps to calculate maneuver duration? You really need timestamp or duration in some unit is sufficient (millisecond for example)? Anyways can you give example with timestamps? So “08-05-1988 12:00:00.001” and not 001,002,003…
timestamp for joining: Like IMU and GPS readings (already done)
Duration for the maneuver
Yes. 001 was just not the correct writing. 08-05-1988 12:00:00.001 will work fine
The only thing is…
Your workflow continuous with the timestamp, even the values in column batch has been changed. What I want is, that when the value is changing – then creating a new timestamp. So that I can see for instance: auto 1 took 20 seconds, auto 2 took 5 Seconds.
here is modified workflow. Used Group Loop Start to get desired output. Probably there are other ways to determine maneuver duration and sure there is way to optimize process but leave that to you.