I need to separate same first column data values and its corresponding second column value.
4 次查看(过去 30 天)
显示 更早的评论
I have two dimensional data, as shown in figure.
I need to separate same first coloumn (column 1) data values and its corresponding second column (column 2) value, into groups.
How can I do this ?
Thanks in advance.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/621833/image.jpeg)
2 个评论
the cyclist
2021-5-18
编辑:the cyclist
2021-5-18
When you say "separated", what specifically do you mean? How do you want the output organized?
Do you still need just one table, but with the values sorted? Or one table, but with an additional variable to define the unique values in column1? Or maybe you need a new table for every value in the first column?
采纳的回答
Adam Danz
2021-5-18
编辑:Adam Danz
2021-5-18
Another method using groupsummary
% Create demo table
g = repelem((1:2:9)',randi(4,5,1)+1,1);
T = table(g, rand(numel(g),1).*randi([2,8],numel(g),1), ...
'VariableNames', {'column1','column2'})
% Average column 2 for each group in column 1
Tstats = groupsummary(T,'column1','mean','column2')
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!