Want to convert hourly Data into Daily Mean

My Data Has hourly recording from date 27th March 2013 to 30 Jan 2015 the Data for 28th March 2013 to 29th Jan 2015 has data for every hour and i.e. daily records are 24 in numbers where as for 27th of March 2013 the data is recorded from 06:00:00 HRS to 23:00:00 Hrs and similarly for 30th Jan 2015 the recorded data is from 00:00:00 HRS to 05:00:00 HRS.

Please help me getting the daily average for the data with single date 1st column.

Answer 1

[Azzi Abdelmalek]

%--------------Example----------------------------------
d=datenum('28-03-2013 07:00:00','dd-mm-yyyy HH:MM:SS'):1/24:datenum('30-01-2015 05:00:00','dd-mm-yyyy HH:MM:SS')  
M=[d' randi(10000,size(d'))]
%--------------------------The code--------------------
f=datevec(d)
g=f(:,1:3)
s,ii,jj]=unique(g,'rows')
v=accumarray(jj,(1:numel(jj))',[],@mean)
dates=datestr(d(ii))
out=[cellstr(datestr(d(ii)))  num2cell(v)]

[Bikiran Das]

Thanks Azzi for the Help

[Bikiran Das]

I am attaching my Data File and Date in the comment i am unable to match the time matrix created for 24 horus interval from the mentioned date to Data matrix i have

[Azzi Abdelmalek]

What about nan values?

[Azzi Abdelmalek]

load DATA
load time
d=datenum(time)
M=[d  Data]
f=datevec(d)
g=f(:,1:3)
[s,ii,jj]=unique(g,'rows')
v=accumarray(jj,(1:numel(jj))',[],@(x) {nanmean(Data(x,:),1)});
dates=datestr(d(ii))
out=[cellstr(datestr(d(ii)))  num2cell(v)]

[Bikiran Das]

thanks Azzi