MATLAB Answers

Average of Column Values with Condition

22 views (last 30 days)
Jennifer Holifield
Jennifer Holifield on 1 Dec 2020
Answered: Jeff Miller on 1 Dec 2020
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!


Sign in to comment.

Answers (2)

Image Analyst
Image Analyst on 1 Dec 2020
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 Comment

Jennifer Holifield
Jennifer Holifield on 1 Dec 2020
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.

Sign in to comment.

Jeff Miller
Jeff Miller on 1 Dec 2020
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


Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by