reshaping data so that I can take sum of every 3 columns

3 次查看（过去 30 天）
Neesha
Neesha 2015-10-30
评论： Neesha 2015-11-2
Hi All,
I have a dataset something similar to following
Name Location Nickname saleCost
rest1 east Reast1 [5, 7, 9 , 2, 5, 1, 9, 11, 1]
rest4 south Rsouth4 [12, 9, 2, 3, 5, 10, 11, 4, 4]
rest3 east Reast3 [20, 2, 2, 3, 20, 30, 1, 3, 7]
rest9 west Rwest9 [1, 9, 3, 33, 22, 10, 6, 6, 8]
Note that saleCost is a dataset as well and as number of columns which are multiple of 3.
I want to add up every 3 columns so my resultant dataset is as follow
Name Location Nickname saleCost
rest1 east Reast1 [21, 8, 21]
rest4 south Rsouth4 [23, 17, 19]
rest3 east Reast3 [24, 53, 11]
rest9 west Rwest9 [13, 65, 20]
I tried using reshape() but could not use it correctly. WHat are my options?
Thanks

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

采纳的回答

Kelly Kearney
Kelly Kearney 2015-10-30
When you say you have a dataset, do you mean a dataset array? I'm assuming so for the moment:
Your data:
tmp = {...
'Name' 'Location' 'Nickname' 'saleCost'
'rest1' 'east' 'Reast1' [5, 7, 9 , 2, 5, 1, 9, 11, 1]
'rest4' 'south' 'Rsouth4' [12, 9, 2, 3, 5, 10, 11, 4, 4]
'rest3' 'east' 'Reast3' [20, 2, 2, 3, 20, 30, 1, 3, 7]
'rest9' 'west' 'Rwest9' [1, 9, 3, 33, 22, 10, 6, 6, 8]};
D = cell2dataset(tmp);
Reshape:
D.saleCost = reshape(sum(reshape(D.saleCost', 3, []),1), [], size(D.saleCost,1))'
D =
Name Location Nickname saleCost
'rest1' 'east' 'Reast1' 21 8 21
'rest4' 'south' 'Rsouth4' 23 18 19
'rest3' 'east' 'Reast3' 24 53 11
'rest9' 'west' 'Rwest9' 13 65 20
Pretty much the same as Jelin's answer, but all in one command. Note that this applies to the entire array saleCost; you shouldn't need to loop over rows.

更多回答（1 个）

Jacky Jo
Jacky Jo 2015-10-30
Is that you want..
saleCost=[5, 7, 9 , 2, 5, 1, 9, 11, 1;...
12, 9, 2, 3, 5, 10, 11, 4, 4;...
20, 2, 2, 3, 20, 30, 1, 3, 7;...
1, 9, 3, 33, 22, 10, 6, 6, 8];
saleCost=reshape( reshape(saleCost',[],3) ,3,[]);
saleCost=reshape(sum(saleCost,1),3,[])'
  2 个评论
Neesha
Neesha 2015-10-30
Let me try what is the result. I do not want to lose context info i have as i have shown in resultant set.
Neesha
Neesha 2015-10-30
It did not work, first line created all in one row with bunch of data added with default values. Also as i tried to execute second row, it ran into memory error

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by