cancel
Showing results for 
Search instead for 
Did you mean: 

Redundant time labels in CSV file with sensor data recorded at different frequencies. How to interpret?

MRahm.8
Associate

I have recorded hours of movement data using all three accelerometers (and gyro) of ST SensorTile.box sensor.

In my custom application from expert mode, I set the ODR of LSM6DSOX on 208Hz, LIS3DHH on 1100Hz, and LIS2DW12 on 1600Hz. Output was set to save on SD card only.

Now I have difficulty interpreting timely data that it recorded on the SD card.

Here's a few lines of the CSV file:

```

dd/mm/yyyy,hh:mm:ss.ms,accX[mg],accY[mg],accZ[mg],gyroX[mdps],gyroY[mdps],gyroZ[mdps],accX[mg],accY[mg],accZ[mg],accX[mg],accY[mg],accZ[mg],

13/05/2022,09:06:17.100,-63,-1000,-171,28,-47,3,-98,-978,-153,-70,-980,-196

13/05/2022,09:06:17.101,-63,-1000,-171,28,-47,3,-101,-981,-167,-70,-978,-195

13/05/2022,09:06:17.102,-63,-1000,-171,28,-47,3,-97,-980,-164,-70,-978,-195

13/05/2022,09:06:17.102,-72,-990,-174,28,-47,3,-99,-980,-162,-72,-980,-193

13/05/2022,09:06:17.105,-72,-990,-174,35,-53,6,-101,-978,-154,-73,-979,-190

13/05/2022,09:06:17.106,-72,-990,-174,35,-53,6,-101,-977,-153,-73,-979,-190

13/05/2022,09:06:17.107,-73,-984,-169,35,-53,6,-96,-982,-157,-72,-978,-190

13/05/2022,09:06:17.108,-73,-984,-169,35,-53,6,-96,-975,-158,-72,-978,-190

13/05/2022,09:06:17.109,-73,-984,-169,35,-53,6,-95,-974,-152,-72,-976,-190

13/05/2022,09:06:17.110,-73,-984,-169,35,-53,6,-102,-977,-157,-72,-976,-190

13/05/2022,09:06:17.112,-71,-984,-166,35,-53,6,-99,-976,-154,-70,-977,-191

13/05/2022,09:06:17.113,-71,-984,-166,41,-53,9,-100,-975,-162,-70,-977,-191

13/05/2022,09:06:17.114,-71,-984,-166,41,-53,9,-94,-976,-153,-71,-977,-189

13/05/2022,09:06:17.115,-71,-984,-166,41,-53,9,-99,-974,-156,-69,-977,-188

13/05/2022,09:06:17.115,-71,-984,-166,41,-53,9,-99,-976,-157,-69,-978,-187

13/05/2022,09:06:17.116,-73,-982,-167,41,-53,9,-96,-976,-156,-69,-978,-187

13/05/2022,09:06:17.117,-73,-982,-167,41,-53,9,-93,-976,-150,-69,-978,-187

13/05/2022,09:06:17.119,-73,-982,-167,51,-62,10,-96,-976,-151,-71,-979,-184

13/05/2022,09:06:17.120,-73,-982,-167,51,-62,10,-93,-982,-148,-67,-980,-188

13/05/2022,09:06:17.120,-73,-982,-167,51,-62,10,-95,-979,-148,-67,-980,-188

13/05/2022,09:06:17.121,-74,-984,-163,51,-62,10,-97,-980,-145,-68,-979,-184

13/05/2022,09:06:17.122,-74,-984,-163,51,-62,10,-100,-982,-150,-69,-978,-182

13/05/2022,09:06:17.123,-74,-984,-163,51,-62,10,-96,-977,-154,-71,-979,-182

13/05/2022,09:06:17.124,-74,-984,-163,51,-62,10,-96,-976,-154,-67,-979,-187

13/05/2022,09:06:17.126,-69,-986,-159,51,-62,10,-93,-980,-151,-69,-981,-182

13/05/2022,09:06:17.127,-69,-986,-159,56,-65,9,-95,-979,-143,-66,-980,-181

13/05/2022,09:06:17.128,-69,-986,-159,56,-65,9,-99,-980,-143,-68,-981,-180

13/05/2022,09:06:17.129,-69,-986,-159,56,-65,9,-97,-980,-141,-68,-981,-180

13/05/2022,09:06:17.129,-69,-986,-159,56,-65,9,-100,-982,-147,-68,-983,-179

13/05/2022,09:06:17.130,-69,-986,-159,56,-65,9,-98,-980,-147,-66,-985,-180

```

On the one hand, the time labels do not match with the maximum requested output data rate of 1600Hz. On the other hand, there are redundant time labels with different recorded data for example at: 13/05/2022,09:06:17.102.

How should I interpret the above file correctly? (BTW. I'm trying to read it in Matlab. and do further processing there.)

0 REPLIES 0