How to consolidate rows with same value, while adding their cells?

Question

Ethan 2013-11-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/105837-how-to-consolidate-rows-with-same-value-while-adding-their-cells

编辑： Azzi Abdelmalek 2013-11-12

I have NOAA climate data reported every 15 minutes and need to consolidate it into daily info. I want to add cells at the end of a row together that have the same date, and make a new matrix with the 'summed' and consolidated info. Here is a rough example of what I want to do:

FROM:

[date, precip
2/1,    4
2/1,    5
2/1,    6
2/2,    2
2/2,    3
2/2,    1
2/2,    4]

TO:

[date, precip
2/1,    15
2/2,    10]

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

请先登录，再进行评论。

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

Answer 1

Doug Hull 2013-11-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/105837-how-to-consolidate-rows-with-same-value-while-adding-their-cells#answer_114990

在 MATLAB Online 中打开

clear
d = {'date', 'precip'; '2/1', 4; '2/1', 5; '2/1', 6; '2/2', 2; '2/2', 3; '2/2', 1; '2/2',4}
dates  = {d{2:end,1}};
amount = [d{2:end,2}];
[uniqueDates, firstInd, allInd] = unique(dates);
for i = 1:numel(firstInd)
    totalRain(i) = sum(amount(allInd == i));
end
disp(uniqueDates)
disp(totalRain)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Azzi Abdelmalek 2013-11-12

编辑：Azzi Abdelmalek 2013-11-12

Ethan commented

Thanks a bunch! working like a charm.

请先登录，再进行评论。

Answer 2

Azzi Abdelmalek 2013-11-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/105837-how-to-consolidate-rows-with-same-value-while-adding-their-cells#answer_114991

编辑：Azzi Abdelmalek 2013-11-12

在 MATLAB Online 中打开

s = { '2/1', 4; '2/1', 5; '2/1', 6; '2/2', 2; '2/2', 3; '2/2', 1; '2/2',4}
[a,b,c]=unique(s(:,1),'stable')
out=[a num2cell(accumarray(c,cell2mat(s(:,2))))]