Average of Column Values with Condition
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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!
0 comentarios
Respuestas (2)
Image Analyst
el 1 de Dic. de 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.
Jeff Miller
el 1 de Dic. de 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
0 comentarios
Ver también
Categorías
Más información sobre Clocks and Timers en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!