Adding successive cells in a columns

Hi,

I have a table (1x7921). I want to add successive columns. For example add column 1:16, 17:32, 32: 48 etc.

Is there a code that I can used to successively add specific range of columns?

[Walter Roberson]

Could you confirm that you have a table() object that has 7921 variables but only one row?

[Isaac Ahenkorah]

Hi Walter,

See below my data in excel format. I want to add each coloured column separately by just importing the data to Matlab using a code that can loop around and add each successive column.

[Walter Roberson]

Row 1 is not numeric. You then have 15 numeric rows after that that are to be added to give the yellow result. Then you add the next 16 entries to give the green result. Are you sure you want the yellow to have only 16 numeric entries added together? And as madhan points out, there would be one extra row left over, with a group ending at 7920 . Are you sure you want the last group to be only one number by itself?

It would make a lot more sense to discard that non-numeric first row and add groups of 16 after that.

[Isaac Ahenkorah]

Thanks Walter,

I have removed the non-numeric data in the first row. Also, I have filtered the data and I now have a total of 7920 rows, which will be divisible by 16.

Any suggestion on how to such each group of coloured data?

Answer 1

[Walter Roberson]

sum(reshape(table2array(YourTable), 16, []))

but having a table object with only one row and 7921 variables is not at all common. It would be far more likely that you have a numeric vector, in which case

sum(reshape(YourVector, 16, []))

[madhan ravi]

It would result in an error since 7921 is not divisible by 16.

[Walter Roberson]

Good point. But 7920 is divisible by 16, and the user shows a text entry in the first row, so it is plausibly 7920 rows of numeric values.

Answer 2

[madhan ravi]

Assuming after sir Walter’s comment:

 T = TabLe{:, :};
 n = numel(TabLe);
 t = [TabLe, nan(1, 16 - mod(n, 16))];
 Wanted = sum(reshape(t, [], 16), 'omitnan') % nansum() for older versions

[Isaac Ahenkorah]

Thanks Ravi,

I will try your suggession.

See below my data in excel format. I want to add each coloured column separately by just importing the data to Matlab and use a code that can loop around and add each successive column.

[madhan ravi]

Both sir Walter’s answer and my answer should work , once you read the data using readtable()

Answer 3

[Isaac Ahenkorah]

Thanks Walter and Ravi,

I think both suggestions from you works really well. Much appreciated.

Regards,

Isaac