Calculating the median for each column based on unique values in 1st column

Question

Thomas Webber 2020-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/561875-calculating-the-median-for-each-column-based-on-unique-values-in-1st-column

回答： Thomas Webber 2020-7-9

Hi all,

I've been search for a solution to this for a while now, and while i can find various ways that get me close, I cant seem to work out exactly what I want. I have a table of various sound metrics for some recordings. The table is 384744x5 with the 1st column being the start time of the recording (duplicated 24 times), and the other 4 are different values. Each file has 24 values taken from it and i want to produce a median value for each column, 2:5 for the 24 values. Ideally the output will be a 16031x5 table with column 1 being unique values of the start time, and columns 2-5 the median values.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Thomas Webber 2020-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/561875-calculating-the-median-for-each-column-based-on-unique-values-in-1st-column#answer_463334

在 MATLAB Online 中打开

I think I have managed to solve this problem.

Where UTC is the column of variables to group medians by, RMS, ZeroPEak, PeakPEak and SEL are columns to find median of.

omedian = @(x) median(x,'omitnan');
medianByRec = varfun(omedian,Filtered,'GroupingVariables','UTC',...
                      'InputVariables',{'RMS','ZeroPeak', 'PeakPeak', 'SEL'})