How can I take out months rows from each year.

g

Answer 1

[Hiro Yoshino]

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.

[Image Analyst]

Then

yourTable = yourTable(~idx, :); % Extract all rows EXCEPT rows identified by idx.

[Megan Mirkhanian]

I am trying to get all the data to run in line 4 but it shoes an error

Answer 2

[Hiro Yoshino]

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

[Megan Mirkhanian]

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]

[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.