How to collapse rows of a table?

5 次查看（过去 30 天）
JFz
JFz 2015-8-24
评论： JFz 2015-8-24
Hi,
I have a table with 3 columns but many rows. Some rows are the same on column 1 and 2 but but not on column 3. Since column 3 are numbers, how to collapse the table with rows that have the same col 1 and col2 and average on col 3?
For example, the table is
Symbol Date Price
NFLX 7/28/2015 100
NFLX 7/28/2015 101
AAPL 7/28/2015 150
I would like to make it as two rows:
NFLX 7/28/2015 105
AAPL 7/28/2015 150
How to do that?
Thanks for any help!
Jennifer

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

采纳的回答

Sean de Wolski
Sean de Wolski 2015-8-24
T = table({'NFLX';'NFLX';'AAPL'},datetime([2015;2015;2015],[7;7;7],[28;28;28]),[100;101;150] ,'VariableNames',{'Symbol' 'Date' 'Price'})
% Dates have to be made numeric
T.Date = datenum(T.Date)
% Group fun
varfun(@mean,T,'GroupingVariables',{'Symbol','Date'})
  2 个评论
JFz
JFz 2015-8-24
Thanks! You are so quick! Let me try it.
JFz
JFz 2015-8-24
Sean, Thank you so much! It works like a charm!
Jennifer

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Language Fundamentals 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by