MATLAB Answers

How can I take out months rows from each year.

1 view (last 30 days)
Megan Mirkhanian
Megan Mirkhanian on 9 Feb 2020
Edited: Megan Mirkhanian on 10 Feb 2020
g

  0 Comments

Sign in to comment.

Answers (2)

Hiro Yoshino
Hiro Yoshino on 10 Feb 2020
d = ['190101'; '190201'; '190301']; % sample data
d_datetime = datetime(d, 'InputFormat', 'yyMMdd'); % change format to datetime
[y,m,d] = ymd(d_datetime); % break it into pieces
idx = m == 1 | m == 2; % extract the indices corresponding to Jan and Feb. You can add " | m == 12 " to extract December!
Please take a look at this. I belive this is applicable to your problem.

  2 Comments

Image Analyst
Image Analyst on 10 Feb 2020
Then
yourTable = yourTable(~idx, :); % Extract all rows EXCEPT rows identified by idx.
Megan Mirkhanian
Megan Mirkhanian on 10 Feb 2020
I am trying to get all the data to run in line 4 but it shoes an error

Sign in to comment.


Hiro Yoshino
Hiro Yoshino on 10 Feb 2020
Edited: Hiro Yoshino on 10 Feb 2020
I guess your date is not read as string.
tableData = readtable('yourExcel.xlsx');
tableData.Time = string(tableData.Time);
Then you can start from
d_datetime = datetime(tableData.Time, 'InputFormat', 'yyMMdd'); % change format to datetime

  2 Comments

Megan Mirkhanian
Megan Mirkhanian on 10 Feb 2020
So I need the precipitation data for the month, so when I run it, it only shows month numbers, ex: it shows 1,1,1,1,1,1 then 2,2,2,2 and no info on precip. Sorry, if this all sounds confusing.
Hiro Yoshino
Hiro Yoshino on 10 Feb 2020
[y,m,d] = ymd(d_datetime); % break it into pieces
idx = m == 1 | m == 2; % extract the indices corresponding to Jan
Do not forget these lines!! Good luck! almost there.

Sign in to comment.

Sign in to answer this question.


Translated by