How to merge data in excel files?

Question

shazwani amran 2013-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/71347-how-to-merge-data-in-excel-files

below is sample data from an excel file that I need to merge.

  1    1   2     3    3    4    4    4
2           4.4             7.1
5            5.2            5.5
          3.9            6.5            4.3

the above data need to be merge according to the first row which have same value to become like this:

    2     3     4
2   4.4         7.1
5         5.2   5.5
9         6.5   4.3

I'm really appreciate someone that can help me.thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Iman Ansari 2013-4-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/71347-how-to-merge-data-in-excel-files#answer_81651

编辑：Iman Ansari 2013-4-9

在 MATLAB Online 中打开

Hi

Data=xlsread('name.xlsx');
Data(isnan(Data))=0;
for i=1:4
    Output(:,i)=[i; sum(Data([false true true true],Data(1,:)==i),2)];
end

2 个评论
显示无隐藏无

shazwani amran 2013-4-21

在 MATLAB Online 中打开

 Hi, how if the data was like below. is it possible for me to merge them? 
  5    5   8     7    7    9    9    9 .....(and so on)
2           4.4             7.1
5            5.2            5.5
          3.9            6.5            4.3
after importing the excel file that contained data like above, the data need to be merge according to the first row which have same value to become like this:
    8     7     9
2   4.4         7.1
5         5.2   5.5
9         6.5   4.3

Iman Ansari 2013-4-21

在 MATLAB Online 中打开

clear
Data=xlsread('name.xlsx');
Data(isnan(Data))=0;
n=nnz(diff(Data(1,:),1,2))+1;
Idx=[1 find(diff(Data(1,:),1,2))+1];
for i=1:n
    Output(:,i)=[Data(1,Idx(i)); sum(Data(2:4,Data(1,:)==Data(1,Idx(i))),2)];
end