Perform Calculations on Data in A Table and Create a New Table
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Isabelle Museck
le 29 Mar 2024
Commenté : Isabelle Museck
le 29 Mar 2024
I have Time (from 0-20 secodns in increments of 0.05sec) and Accerometer Data recorded at each 0.05 second interval in a Table and I need to calculate the average standard deviation of the accelrometer data in one second and put it in a new table. Im not sure of the most effiecient way to do this. Any help would be greatly appreciated!
Ex of Data in Table -T
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1655346/image.png)
Réponse acceptée
Steven Lord
le 29 Mar 2024
I'd likely turn your Time column into a duration array (using the seconds function) then convert your table into a timetable using table2timetable. Once you've done that you can use retime on the timetable to change it to a secondly basis (using the newTimeStep input argument value 'secondly') with @std as the aggregation method (that is in fact the example given for the function handle syntax.)
You could use the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page as an example, just using 'secondly' and @std instead of 'hourly' and 'mean'.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!