finding the mean based on a specific value in other column
2 次查看(过去 30 天)
显示 更早的评论
How do I find the mean of the temperature at the 6th Month of the year?
0 个评论
回答(2 个)
Vilém Frynta
2022-11-29
编辑:Vilém Frynta
2022-11-29
Find months that == 6 with function find(). Then use index of this function to get the temperatures. Then use mean() on these temperatures.
Example:
% Creating random table to work with (similar to your table)
T = table();
T.Day = [1:1:17]';
T.Month = [1 2 3 4 4 5 6 6 6 6 7 8 9 10 11 11 12]';
T.Temperature = randi([29 32],17,1)
% Find position of all rows where Month == 6
idx = find(T.Month==6)
% Use idx to get all the temperatures
idxTemperature = T.Temperature(idx)
% Calculate mean
meanTemperature = mean(idxTemperature)
Edit: added an example
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!