Average of Column Values with Condition

1 次查看（过去 30 天）
Jennifer Holifield
Jennifer Holifield 2020-12-1
回答： Jeff Miller 2020-12-1
Hello, all!
I'm currently trying to bin a large CTD data file and I know I must use a for loop to create the average values, but I'm not sure how to implement it. For example, I have about 100 lines of data for depth "2" that are 2.3455, 2.3434, 2.4532 and so on. I have this for depth 2 meters - 751 meters. I would like to average all the values together that begin with the same number (all of the "2"s, "3"s, etc.). Thanks in advance!

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

回答（2 个）

Image Analyst
Image Analyst 2020-12-1
Why not just set up edges and take the histogram? Then take the center bin value and multiply it by the count?
If you can't figure it out, let me know.
  1 个评论
Jennifer Holifield
Jennifer Holifield 2020-12-1
To be honest, im not sure what you mean by setting up the edges. I am familiar with taking the histogram, but I'm stuck on how to limit it to similar values.

请先登录，再进行评论。

Jeff Miller
Jeff Miller 2020-12-1
if your data are in a table, maybe you can use grpstats something like this:
tbl.IntDepth = trunc(tbl.depth); % assuming depth values like 2.3455, etc
avgs = grpstats(tbl,'IntDepth','mean','DataVars',{'depth'}); % to get the average depth within each range

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by