calculate average column in multiple files

3 次查看（过去 30 天）

viet le 2019-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/439978-calculate-average-column-in-multiple-files

编辑： viet le 2019-1-17

Capture.PNG

I have 10 .xls files (name file1.xls, file2.xls...) in a folder, each has 10 columns (Ai, Bi, Ci,...). Now I want to create one .xls file that calculate average of column A, B, C... (A=A1+A2+...+A10/10); (B=B1+B2+...+B10)......

A1, A2, A3 ... A10 have various length as well as Bi, Ci, Di......

example (attached)

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

请先登录，再进行评论。

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

采纳的回答

madhan ravi 2019-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/439978-calculate-average-column-in-multiple-files#answer_356582

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

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

viet le 2019-1-16

编辑：viet le 2019-1-16

thanks. but I was wondering how to import just one column

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by