Using @range in timetable when having NaN's

3 次查看（过去 30 天）
Robert
Robert 2017-9-12
评论： Robert 2017-9-14
Hi,
I am trying to calculate daily mean and daily range from a timetable:
'25-Feb-2008 00:00:00' 29.1580000000000
'25-Feb-2008 00:30:00' 29.1350000000000
'25-Feb-2008 01:00:00' 29.1400000000000
'25-Feb-2008 01:30:00' 29.1350000000000
'25-Feb-2008 02:00:00' 28.9070000000000
...
By using:
Dmean=retime(Tabla,'Daily',@nanmean);
Drange=retime(Tabla,'Daily',@range);
It works fine, for @nanmean, for days with data and some NaN's, or the entire day with only NaN's.
But this doesn't work for @range, do you know of any range function to use in timetable that works similar to nanmean?
I also tried:
[s,l]=retime(Tabla,'Daily',@bounds)
But received this error: Error using timetable/retime Too many output arguments.
And this:
retime(Tabla,'Daily',@bounds)
But received this error:
Error using timetable/retime (line 103)
Aggregation method 'bounds' returned value that did not have exactly one row.
Suggestions are welcome. Thanks!
  4 个评论
显示 2更早的评论
Robert
Robert 2017-9-12
Replacing NaNs with a number will help when full days (at minutes time steps) happen, but will affect the days that have some data and NaNs (mean calculation). I appreciate your suggestions.

请先登录，再进行评论。

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

采纳的回答

Peter Perkins
Peter Perkins 2017-9-14
Robert, it's not clear what you are looking for, or what you mean by "doesn't work". As KSSV says, range ignores NaNs, so it's not clear what problem you are running into.
If you are doing aggregation with synchronize, you can write your own function to do whatever you want. You could easily write a v ersion of range that did NOT ignore NaNs, for example.
  1 个评论
Robert
Robert 2017-9-14
Thanks, I am using this function now:
function y = nanrange(x)
y = range(x);
if isempty(y)
y = nan;
end

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Preprocessing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by