Check for missing entry in data points with certain rule

3 次查看（过去 30 天）

显示更早的评论

Poulomi Ganguli 2017-9-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/355409-check-for-missing-entry-in-data-points-with-certain-rule

编辑： Poulomi Ganguli 2017-9-6

QYrly.mat

在 MATLAB Online 中打开

Hello,

I have a matrix of time series as attached, in which the first column is the year, 2nd month, 3rd is day, 4th and 5th columns are the values. Currently, I have attached a sample of only the year 1960, likewise I have years till 2000 with values. I want to check whether there is atleast 6-months of data entry and at least 20-days entries for each month. If this satisfy this rule certain calculation will be performed, otherwise it will move to next year. I tried the code in foll.way, however, it is giving me time series of only January instead of January to December.

[unqMonth,~,Month_ID] = unique(QYrly(:,2));
Monly = size(unqMonth,1)>=6; % Check for atleast 6-months of data entry
Dly = histc(QYrly(:,2),unqMonth)>=20;  % Checks for atleast 20 days entries for each month
Qout = QYrly(ismember(Month_ID,find(Monly)) & ismember(Month_ID,find(Dly)),:);

Any help?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Poulomi Ganguli 2017-9-6

编辑：Poulomi Ganguli 2017-9-6

在 MATLAB Online 中打开

Ok I solved it using a simple loop:

if (Monly==1 & any(Dly ~= 0))
QOut = QYrly;
else QOut = [];
end

请先登录，再进行评论。

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

回答（0 个）

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

类别

MATLAB Language Fundamentals Matrices and Arrays

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by