How to average seconds data to minutes data?

I have a set of data with me. I want to average this seconds data into minutes average data.

I used following code, but I didn't get.

Z=xlsread('V.csv',-1);
nhours=1;
Ts=1;
data=[Z];
meanT=60;
data=rand(3600,1);
matrix=reshape(data,3600/Ts,nhours);
out=mean(matrix(1:meanT/Ts,:))

I want help and its urgent. Find the data file attached.

[Guillaume]

Well, for something urgent, you certainly haven't made much of an effort. Do you even understand the code you've written, particularly the line

data = rand(3600, 1)

where you replace what you've just read from the file by one column of random data?

why-your-question-is-not-urgent-or-an-emergency

[Kraunchaa]

Yes sir. I haven't done coding in my entire life. Now I started with it from yesterday evening. Suddenly need came. I am working on learning this slowly slowly. Thank you sir.

Answer 1

[Andrei Bobrov]

T = readtable('V.csv');
T.Var1 = datetime(T.Var1,'f','HH:mm:SS');
TT = table2timetable(T);
TT_out = retime(TT,'minutely','mean');

or

T = readtable('V.csv');
T.Var1 = datetime(T.Var1);
[~,~,~,hh,mm] = datevec(T.Var1);
[~,~,T.g] = unique([hh,mm],'rows');
T_out = varfun(@mean,T,'gr','g');
T_out = T_out(:,3:end);

[KL]

+1! @Kraunchaa: Just to mention, works on versions 16b or above. For the older ones please use table, datevec along with accumarray. There are examples on the forum already.

[Kraunchaa]

thank you sir...

Answer 2

[Guillaume]

Honestly, I doesn't look like you've made much effort. Nearly none of the line you've written make any sense. Particularly the one where you replace the whole of the content of the file you've read by random data.

It's very easy to do with timetables:

tt = table2timetable(readtable('V.csv', 'Format', '%{HH:mm:ss}D%f'));
tt_minutely = retime(tt, 'minutely', 'mean')

[Kraunchaa]

thank you sir..