MATLAB Answers

I have daily data from 1969 to 2018. I want to remove the rows corresponding to 29-02 day from the matrix. How should I proceed?

1 view (last 30 days)
Subhra Maity
Subhra Maity on 13 Mar 2020
Edited: Subhra Maity on 15 Mar 2020
I have daily data from 1969 to 2018. I want to remove the rows corresponding to 29-02 day from the matrix. How should I proceed?. Is there any in built function for this?

More Answers (1)

Alex Mcaulley
Alex Mcaulley on 13 Mar 2020
Edited: Alex Mcaulley on 13 Mar 2020
Another option:
[~,~,raw] = xlsread('sample.xlsx');
raw(contains(raw(:,1),'29/02'),:) = [];

  1 Comment

Subhra Maity
Subhra Maity on 15 Mar 2020
thanks.. it also does the same. only '29/02' should be changed to '29-02' as per the date format in excel file. :)

Sign in to comment.

Sign in to answer this question.


Translated by