averaging selected columns and saving to a new file

3 次查看（过去 30 天）
Giru Mishra
Giru Mishra 2018-5-29
评论： Ameer Hamza 2018-5-30
I have a data file with 1st column - time, 2nd column measurement and third one error. I want to average 1st column, 2nd column and 3rd column corresponding to same time over the whole file and make a new file with such values. Also by same time I mean same number before decimal e.g.
4500.34
4500.25
4500.68
3700.57
3700.45
3700.98
so on....
So in above case, 4500.34 4500.25 4500.68 will be considered with same time and 3700.57 3700.45 3700.98 with same time. Now I want to average 1st,2n,3rd columns of same time and make one new point and so on for all same time.
Please help

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

采纳的回答

Ameer Hamza
Ameer Hamza 2018-5-29
You can try this, here x is the matrix name containing 3 columns
[unique_time, ~, index_unique] = unique(floor(x(:,1)));
measurement_average = accumarray(index_unique, x(:,2), [], @mean);
error_average = accumarray(index_unique, x(:,3), [], @mean);
result = [unique_time measurement_average error_average];
  10 个评论
显示 8更早的评论
Giru Mishra
Giru Mishra 2018-5-30
Dear Ameer... thanks for your reply. I will try that way.. Also, I want just squares of error points associated with measurements under same time and then divide by number of those points.
Ameer Hamza
Ameer Hamza 2018-5-30
@Giru You are welcome. Yes, the line posted in the comment will take the average of square values under same time.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by