Extracting Data above a specifc year

Hello I am trying to figure out the best way to keep only the data from the year 1981 and up. I was thinking of doing something like this:
load('dataFC21.mat');
dataFC21.Year=year(dataFC21.Date);
[g,id]=findgroups(dataFC21.Year);
idx=(id>=1981);
dataFC21=dataFC21(idx,:);
Except that this isnt working. If someone could tell me what the issue with my code is or suggest a better method that would be great thanks!

 Accepted Answer

idx isn't the year; it's an index into the array by year.
Simply
yrWant=1981;
dWant=dataFC21(dataFC21.Year>=yrWant,:);
will return those rows presuming that dataFC21.Year is indeed the calendar year and is a double.

More Answers (0)

Products

Release

R2021a

Tags

Asked:

JMG
on 15 Jul 2021

Commented:

JMG
on 15 Jul 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!