Delete a cell in an array chosen by a criterion?

Question

Thor 2013-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59410-delete-a-cell-in-an-array-chosen-by-a-criterion

Dear all, I have a cell-array of 9*365. In each cell is a vector of 3*365. First I want to delete every 6th and 7th cell in each row. Then I want to delete them by a criterion in the vector. The third column in every vector stands for the trading volume of a stock. If all rows of this column are zero, then the cell should be deleted. How can I delete the cells? Thank you very much!

7 个评论
显示 5更早的评论隐藏 5更早的评论

Thor 2013-1-22

Dear all, I am sorry. I misdescribed it. I have a cell array of 9*365. The nine is for different years and the 365 is for every day in a year. First I want to delete every 6th and 7th cell in each year(for me this means in each row of the cell array). Because I want to delete the weekends. Then in every cell is a 270-288*3 matrix! Not a vector! The rows could differ because I don't have for every day, the same points of the intra-day stock prices. The third column of the matrix is the trading volume. If all values in this column are zero, then the whole matrix should be deleted. Thank you!

Azzi Abdelmalek 2013-1-22

Your matrices are 3x365 or 365x3?

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2013-1-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59410-delete-a-cell-in-an-array-chosen-by-a-criterion#answer_71968

编辑：Azzi Abdelmalek 2013-1-22

在 MATLAB Online 中打开

% If your marices are 365x3

x(:,6:6:end)=[];   % x is your cell array
x(:,6:6:end)=[];
[n,m]=size(x); 
for k=1:n
  for l=1:m
      v=x{k,l};
      if ~any(v(:,3))
          x{k,l}=[]
      end
  end
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2013-1-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/59410-delete-a-cell-in-an-array-chosen-by-a-criterion#answer_71984

在 MATLAB Online 中打开

years = 2002:2010;           % 9 years
ndy = 337 + eomday(years,2); % days in years 
data = cell(1,numel(years)); % create your cell-array
for jj = 1:numel(data)
    data{jj} = cell(ndy(jj),1);
    c = randperm(ndy(jj));
    b = c(1:randi(20));
    for ii = 1:ndy(jj)
        k = randi([270,288]);
        data{jj}{ii} = randi([40,1000],k,2);
        if any(ismember(b,ii))
            data{jj}{ii}(:,3) = 0;
        else
            data{jj}{ii}(:,3) = randi([40,1000],k,1);
        end
    end
end
% solution
for jj = 1:numel(years)
    data{jj} = data{jj}...
                  (~ismember(weekday(datenum(years(jj),1,(1:ndy(jj))')),[1,7]));
    for ii = 1:numel(data{jj})
        if all(~data{jj}{ii}(:,3))
            data{jj}{ii} = [];
        end
    end
end