logical indexing within groups
6 次查看(过去 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!