Turning data in time domain into percentage

Question

Jake Bowd 2019-10-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484274-turning-data-in-time-domain-into-percentage

评论： Peter Perkins 2019-10-15

matlab.mat

Hi,

I am looking to turn a table of data (namely the 'mot1' table in the .mat file attached) into percentages, Does anyone have suggestions?

Best wishes,

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

Peter Perkins 2019-10-15

Jake, not sure if this would make your data easier to manage, but it's possible to use mergevars to put, for example, all the pelvis variables into one (inner) table inside of your mot1 table. You'd end up with an outer table that had fewer variables, each of which was itself a table.

请先登录，再进行评论。

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

Answer 1

Adam Danz 2019-10-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/484274-turning-data-in-time-domain-into-percentage#answer_395418

在 MATLAB Online 中打开

I'm guessing your time column represent a portion of the day (ie, hh:mm) and it's that column that you want to turn into a percentage.

datestr(mot1.time(1:5))
ans =
  5×8 char array
    ' 6:36 AM'
    ' 6:47 AM'
    ' 7:00 AM'
    ' 7:12 AM'
    ' 7:23 AM'

in which case, they already are a percentage. Do you want to scale them from 0:100 instead of 0:1? It may be better to leave them in their original form if you want to use them as datetime values. But here's how to scale them to 0:100

mot1.time = mot1.time*100    % or mot1.time = round(mot1.time*10)
mot1.time(1:5)
ans =
         27.5
       28.333
       29.167
           30
       30.833

If you want actual '%' symbols you'd have to convert them to strings | char arrays

mot1.time = strcat(num2str(round(mot1.time*100)),'%')
%or 
mot1.time = cellstr(strcat(num2str(round(mot1.time*100)),'%'))

But again, they would be virtually worthless in that form if you're planning on using them for analysis.

If you need them as lables, you can always add an additional column to the table.

2 个评论
显示无隐藏无

Jake Bowd 2019-10-9

Hi Adam,

I should have said. The time column is the length of a recording, and in each file the time length of the recordings with be different and so I would like to standardise the time column to be out of 100 (and so when I plot the graphs, each x axis is out of 100). In fact, once done for the time column I would be making all the other columns the same length as the newly modified time column.

essentially, I am looking at human movement and wish to analyse the stance phase of each gait cycle.

I hope this clarifies it?

Adam Danz 2019-10-9

编辑：Adam Danz 2019-10-10

"The time column is the length of a recording"

Does that mean mot1.time are durations? In minutes? They appear to be montonically increasing as if they are time stamps (in what units?).

"in each file the time length of the recordings [will] be different and so I would like to standardise the time column to be out of 100"

Is the file you attached file #1? This file starts at mot1.time(1) = 0.275. In order to normalize it I'd need to know that max time across all files, if I'm understanding it correctly.

"once done for the time column I would be making all the other columns the same length as the newly modified time column."

I didn't understand this one.

Maybe an example would help explain the goal.

请先登录，再进行评论。