Average over repetitions in Excel table
% Read Excel work sheet and average the data over unnecessary factors (repetitions).
% 'IndepVaribles' lists all the reserved factors, which will remain in the output.
% Those columns not included in as 'IndepVaribles' are considered as 'repetitions'.
% Data columns will be automatically detected (Search for columns containing numerical data from the last column).
%
% Example:
% IndepVariables={'Subj','Target'}; XlsFName = 'data.xlsx';
% NewXlsCell=ReadXlsAverageAcrossRep(XlsFName, IndepVariables);
% Input Excel sheet :
% --------------------------------------------------------------------
% Subj Target FName data1 data2 data3
% F01 p R001 2 2 2
% F01 p R002 1 1 1
% F01 t R004 3 3 3
% F01 t R006 2 2 2
% F03 k R039 1 1 1
% F03 k R042 2 2 2
% F03 k R053 3 3 3
% --------------------------------------------------------------------
%
% Output Excel sheet :
% --------------------------------------------------------------------
% Subj Target data1 data2 data3
% F01 p 1.5 1.5 1.5
% F01 t 2.5 2.5 2.5
% F03 k 2 2 2
% --------------------------------------------------------------------
引用格式
Wei-Rong Chen (2024). Average over repetitions in Excel table (https://www.mathworks.com/matlabcentral/fileexchange/50467-average-over-repetitions-in-excel-table), MATLAB Central File Exchange. 检索时间: .
MATLAB 版本兼容性
平台兼容性
Windows macOS Linux类别
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- MATLAB > Data Import and Analysis > Data Preprocessing >
标签
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 |