How so subset observations in a matrix?

조회 수: 1 (최근 30일)
Prerna Mishra
Prerna Mishra 2022년 7월 25일
답변: KSSV 2022년 7월 25일
I have a matrix that has the follwing columns:
[GVKEY FYEAR SALE ASSET]
FYEAR ranges from 2005-2019 and there are many GVKEYs which are basically identifiers. I want to keep only those GVKEYS(observations) for which I have the entire 2005-2019 observations, as some may have only sub ranges like 2007-2009.
How do I do this?

채택된 답변

Githin George
Githin George 2022년 7월 25일
편집: Githin George 2022년 7월 25일
Hi Prerna,
My understanding is that you want to filter out the rows of a matrix for those GVKEYs having observations from 2005-2019. I would like to make the assumption that the year range is continuous. You could try out the following piece of code.
keys = unique(data(:,1))
for i=1:numel(keys)
keyData = data(data==keys(i),:)
% from here you can compare with keyData length or compare the year
% array to the 2nd column and based on that modify values in the actual
% data array.
col2 = sort(keyData(:,2))
flag = isequal(col2,2005:2019)
if(flag == 0)
data(data==keys(i),:) = []
end
end
I Hope this helps.
  댓글 수: 7
Prerna Mishra
Prerna Mishra 2022년 7월 25일
Thanks so much!
Prerna Mishra
Prerna Mishra 2022년 7월 25일
A follow up, if i want to filter rows where column 7 begins with 31, how would I do that?

댓글을 달려면 로그인하십시오.

추가 답변 (1개)

KSSV
KSSV 2022년 7월 25일
idx = FYEAR >= 2007 & FYEAR <= 2009 ;
iwant_FYEAR = FYEAR(idx) ;
iwant_GVKEYS = GVKEYS(idx) ;

카테고리

Help CenterFile Exchange에서 Creating and Concatenating Matrices에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by