Perform Calculations on Data in A Table and Create a New Table

Question

Isabelle Museck 2024-3-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2100581-perform-calculations-on-data-in-a-table-and-create-a-new-table

评论： Isabelle Museck 2024-3-29

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Isabelle Museck 2024-3-29

I meant the std deviation per second not average std deviation

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2024-3-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2100581-perform-calculations-on-data-in-a-table-and-create-a-new-table#answer_1433411

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'.