Groupby Date and Categorical Column on Tables

7 次查看（过去 30 天）
Furqan Hashim
Furqan Hashim 2020-8-28
评论： Furqan Hashim 2020-8-29
Suppose that I have 5 columns in my table as Stock, Date, Open, High, Low, Close. Stock is a string column and Date is in Date format. Suppose that same stock can repeat on same day.
How can I count of unique stocks on each Day? That would be table with number of unique stock counts against each date.
Given that each stock can have mutiple observation on same day how can I group by both Date and Stock to get average Open price for each stock on each day.
  23 个评论
显示 21更早的评论
Adam Danz
Adam Danz 2020-8-29
编辑：Adam Danz 2020-8-29
Right, but that function only has 1 input and it's the correct input but the error message you shared was "Not enough input arguments", which doesn't occur on my end.
From this point I think your options are
  1. Install the updates to your current release and try again.
  2. Use a different machine / installation of matlab / or maybe even a newer release. If the updates didn't fix the problem, something seems to be wrong locally since none of these issues occur on my vs of r2017b update 9.
  3. Make a tech support request and point to this thread within the request so they can see what troubleshooting you've already done.
I would be interested in hearing the final solution and cause of the problem if you get to the bottom of this. Note that the error you reported in the answer below also doesn't match the error I got on the demo data in r2017b (update 9). So something's fishy.
Furqan Hashim
Furqan Hashim 2020-8-29
Adam Thanks a lot for the help! Much appreciated.

请先登录，再进行评论。

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

回答（1 个）

Mohammad Sami
Mohammad Sami 2020-8-29
Perhaps you can try the alternative below.
if true
[G,tabout] = findgroups(data(:,{'Stock','Date'}));
tabout.avgOpen = splitapply(@mean,data.Open,G);
end
  4 个评论
显示 2更早的评论
Adam Danz
Adam Danz 2020-8-29
编辑：Adam Danz 2020-8-29
The only difference between your and my versions is the update #9. You could easily update your version for free by pressing the little bell icon in the upper right of the main window. I can't promise that will affect this problem but it's a good idea to get the updates anyway.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

产品


版本

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by