Find average of of rows across various conditional columns

1 次查看（过去 30 天）

Tanaya Chatterjee 2021-11-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1581684-find-average-of-of-rows-across-various-conditional-columns

评论： Adam Danz 2021-11-18

I have a datasets for each participants where there are 7 columns as shown below.

TRIAL  X  Y  dist_loc_code  dist_type_code  soa_code  sacc_amp
968,20  512,40  1  3  1  10,09 
968,00  528,90  1  3  1  5,83 
943,90  772,50  1  3  1  4,61 
989,00  520,20  1  3  1  5,77 

First, I want to sort the data for each according to the condtions: dist_loc_code, dist_type_code and soa_code.

Then, I want to average the sacc_amp of each of the combination of the conditons across rows.

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

Tanaya Chatterjee 2021-11-18

编辑：Tanaya Chatterjee 2021-11-18

在 MATLAB Online 中打开

It was a numeric matrix.

And thank you for your help.

I tried the following codes using Matlab documentations and examples. This worked for me!

Raw = readmatrix ( 'Raw_Subj.xlsx', 'Sheet', 'Sheet1')  % load the xlsx file as a matrix, 'Sheet1' spreadsheet
[K, ~, G] = unique(Raw(:, 4:6), 'rows');            %find unique condition combo for 4,5,6th columns)
sacamp    = [K, accumarray(G,Raw(:, 7), [], @mean)]         %for each unique combo, find mean of sacc amp