Extracting Data above a specifc year
1 view (last 30 days)
Show older comments
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!
0 Comments
Accepted Answer
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.
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!