Problem with direct calculation on table with std and "omitnan"
15 次查看(过去 30 天)
显示 更早的评论
Since R2023a, it is possible to perform calculations directly on tables (and timetables) without extracting their data by indexing.
I want use std directly on a numeric table where I can have nan.
For example :
load patients
T = table(Age,Height,Weight,Systolic,Diastolic)
mean(T,"omitnan")
It's fine.
But why there is a problem with std(T,"omitnan") ?
% Applying the function 'std' to the variable 'Age' generated an error.
I can use std(T{:,:},"omitnan") or std(T.Variables,"omitnan") but I lost the possibility to work directly with my table.
Did I miss something ?
Do you have any suggestion ?
Thank you in advance.
SAINTHILLIER Jean Marie
0 个评论
采纳的回答
Star Strider
2023-5-17
Example —
load patients
T = table(Age,Height,Weight,Systolic,Diastolic)
S = varfun(@(x)std(x,'omitnan'),T)
.
3 个评论
Keith Goatman
2024-8-13,9:15
I too was caught out by the inconsistent behaviour of mean and std on tables in 2024a. The answer above works around it but it doesn't explain why they should behave differently.
更多回答(1 个)
Steven Lord
2024-8-13,17:39
This looks like a bug to me. It seems that std for table arrays assumes that if you're passing the missingflag input that you've also specified the normalization option or weights. But specifying just the data and the missingflag input is a supported syntax for a double array input and so probably should be supported for a table array input.
A workaround is to specify the default normalization option (0) in the std call as the second input.
load patients
T = table(Age,Height,Weight,Systolic,Diastolic);
mean(T,"omitnan")
std(T, 0, "omitnan")
% check
std(T.Age, "omitnan")
I'll report this to the development staff.
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!