MATLAB Answers

Extracting Data above a specifc year

2 views (last 30 days)
JMG
JMG on 15 Jul 2021
Commented: JMG on 15 Jul 2021
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

dpb
dpb on 15 Jul 2021
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.
  1 Comment
JMG
JMG on 15 Jul 2021
Oh perfect thank you for the help!

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!