I only want to include the observations that have observations through the whole timeframe.

4 次查看（过去 30 天）

Hnor 2021-7-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/883889-i-only-want-to-include-the-observations-that-have-observations-through-the-whole-timeframe

评论： dpb 2021-7-26

I have 979588 x 12 table with US stocks from 1963 - 2011. It's a total of 6411 different stocks. I want to remove all the stocks that have not been listed the entire time. The first column is an identification number for the specific stock called permno. If sum(permno == 10000) is 588, where 10000 is the identification number, it means the stock with id 10000 has been listed the whole time. So I want to remove all the stocks that don't meet the criteria: sum(permno == 10000) is 588. How do I go about this?

2 个评论
显示无隐藏无

dpb 2021-7-22

Need more info on how the table is organized --

Hnor 2021-7-22

The table is organized as follows:

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

dpb 2021-7-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/883889-i-only-want-to-include-the-observations-that-have-observations-through-the-whole-timeframe#answer_751899

在 MATLAB Online 中打开

NFULL=588;     % the full file number -- use variables instead of "magic numbers" in code
tSave=groupfilter(tTable,'Permnoco',@(x)numel(x)==NFULL,'Permnoco');

You didn't tell us what the variable name is for the table; substitute that in for "tTable" above.

The variable name according to the above image is 'Permnoco' not 'permno'; obviously also use the correct name inside the table.

See doc groupfilter for details on the syntax.

6 个评论
显示 4更早的评论隐藏 4更早的评论

Peter Perkins 2021-7-26

There's probably a half dozen simple-ish ways to do this, but kudos to dpd for spotlighting the relatively new groupfilter. Exactly what it is aimed at!