Find average of of rows across various conditional columns

1 次查看（过去 30 天）
Tanaya Chatterjee
Tanaya Chatterjee 2021-11-8
评论： 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
20 968,20 512,40 1 3 1 10,09
22 968,00 528,90 1 3 1 5,83
22 943,90 772,50 1 3 1 4,61
33 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更早的评论
Tanaya Chatterjee
Tanaya Chatterjee 2021-11-18
编辑：Tanaya Chatterjee 2021-11-18
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
Adam Danz
Adam Danz 2021-11-18
This looks like it could be helpful but you'd need to attach the Raw_Subj file for us to look at and play around with the table.

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by