2023-01-22 09:15 AM
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.)