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

Question

Neesha 2015-10-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/251920-reshaping-data-so-that-i-can-take-sum-of-every-3-columns

评论： Neesha 2015-11-2

采纳的回答： Kelly Kearney

在 MATLAB Online 中打开

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

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

请先登录，再进行评论。

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

Answer 1

Kelly Kearney 2015-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/251920-reshaping-data-so-that-i-can-take-sum-of-every-3-columns#answer_197961

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Neesha 2015-11-2

Perfect, thanks a lot! It is dataset , not an array but it does work for me...

请先登录，再进行评论。

Answer 2

Jacky Jo 2015-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/251920-reshaping-data-so-that-i-can-take-sum-of-every-3-columns#answer_197955

在 MATLAB Online 中打开

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 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 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

请先登录，再进行评论。