none
Removing Null values before staggered data values w/o removing entire rows RRS feed

  • Question

  • I'm working with data where a driver makes a run through a particular section of road each day. The raw data has a date/time, gps coordinates, and a speed but are all aggregated into a single .csv file.

     

    DateTime               Lat     Long     Speed

    12/25/18 9:00:01    xxx      xxx          25

    12/25/18 9:00:02    xxx      xxx          26

    ...

    12/26/18 9:00:01    xxx      xxx          24

    12/26/18 9:00:02    xxx      xxx          23

    ...

     

    I've managed to create a new column for each date with the speed data filling the rows but there are many "null" cells I cannot remove.

     

    Elapsed Time        12/25/18     12/26/18          ...          ...

    0                                25               null

    1                                26               null

    ...

    72                             null               24

    73                             null               23

    ...

     

    My goal is to collapse the data by shifting my data set up into a shared "elapsed time" like so:

    Elapsed Time        12/25/18     12/26/18          ...          ...

    0                                25                24

    1                                26                23

    ...

     

    I expect each run to take a different amount of time +/- 10 seconds and don't mine having null values after the data set but I need each column to run the data I have wrt the same elapsed time counter. Any suggestions?

    Monday, December 31, 2018 11:36 PM

Answers