how to select data in rows based on date in column

1 次查看（过去 30 天）

deepika suryadevara 2019-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/440180-how-to-select-data-in-rows-based-on-date-in-column

评论： Peter Perkins 2019-1-23

Analysing climatic data for which Ihave to select certain (period) colums staring from the particular date in excel. Dealing with 3000 rows and 365 columns. Please help me

2 个评论
显示无隐藏无

Kevin Chng 2019-1-17

在 MATLAB Online 中打开

1) Ensure the relevant column is in datetime dataset

%Ensure the PredictionTable.Time is in datatime datatype.

2) then you could

% get Year 2016 data out for training
tr = timerange('2015-01-01' , '2015-12-31');
PredictionTable_2015 = PredictionTable(PredictionTable.Time(tr),:);