logical indexing within groups
조회 수: 4 (최근 30일)
이전 댓글 표시
I have a panel data set such that N observations occur over t-time periods. I've created a unique id number for each N-observation which repeats over t-time periods. See photo for example.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/166254/image.png)
Next, I'd like to extract all the individuals such that hsClass==5 & hsClass<5.
Normally a table (table name is panel1) indexing could be achieved by
rows = panel1.hsClass==5 & panel1.hsClass<5;
panel2 = panel1(rows,:);
However, this results in a table with zero rows. In my case I want the indexing to be performed over the grouping variable (G). How can this be done?
댓글 수: 2
답변 (1개)
Walter Roberson
2017년 7월 24일
[uG, ~, Gidx] = unique(panel1.G);
group_has_a_5 = accumarray(Gidx, panel1.hsclass == 5) >= 1;
row_mask = ismember(panel1.G, uG(group_has_a_5) );
panel2 = panel1(row_mask,:);
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Matrix Indexing에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!