Summation of every nth column

Hello everyone,

I've imported xlsx file containing some data related to energy consumption, It was sampled in 15 minutes rate.

I want to convert this table to hourly values, in order to make hourly values I need to sum every 4 columns and store that data in a new matrix that sizes [8760x1], I want all the data be in series (just one column).

The data are for full year, so i expect to get 8760 (hours in a year) rows , and 1 column.

Thanks in advance.

Answer 1

[Jan]

S = size(LoadProfile);
X = reshape(LoadProfile, S(1), 4, S(2) / 4);
X = reshape(sum(X, 2), S(1), S(2) / 4).';
Result = X(:);

[Adnan Jayyousi]

Hey Jan,

Thanks for your reply,

It works, there's little fix that i needed to make, because I wanted that all the data fit in one column

i.e 8760 Rows :)

Any way, this is the correction and it works fine (think so) :)

%%

S = size(LoadProfile);

X = reshape(LoadProfile, S(1), 4, S(2) / 4);

X = reshape(sum(X, 2), S(1), S(2) / 4).';

Result = X(1,:); %% Fit into 1 column

Result = Result' %% Transpose

%%

Thanks !

[Jan]

Are you sure? This

Result = X(1,:)

crops the first row from the matrix X. My code uses X(:) to convert all elements of X into a column.