Count occurrences of dates in an excel file

Question

Zekeftw 2016-8-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300532-count-occurrences-of-dates-in-an-excel-file

编辑： Andrei Bobrov 2016-8-23

Orders.xlsx

Hi,

The attached excel file contains a list of dates. I need help counting the number of occurrences for each date then sum them for each week. Where the week is counted from Sun - Sat.

For example, for the week of 5/1/15 John placed 21 orders.

Thanks

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2016-8-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300532-count-occurrences-of-dates-in-an-excel-file#answer_232578

编辑：Andrei Bobrov 2016-8-23

在 MATLAB Online 中打开

[~,~,dc] = xlsread('Orders.xlsx');       % T = readtable('Orders.xlsx');
z = dc(2:end,:);                         % z = table2cell(T);
t = cellfun(@ischar,z);                  % t = ~cellfun(@isempty,z);
nd = weekday(datenum(z(t),'dd.mm.yy'));
ds = datenum(z(t),'dd.mm.yy');
ddf = diff([nd ds]);
lo = [true;ddf(:,1) < 0 | abs(ddf(:,2)) > 7];
i0 = double(t);
i0(t) = lo;
i1 = cumsum(i0).*t + 1;
i2 = ones(size(i1,1),1) * (1:3);
out = accumarray([i1(:),i2(:)],1);
out = out(2:end,:);

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

请先登录，再进行评论。

Answer 2

KSSV 2016-8-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300532-count-occurrences-of-dates-in-an-excel-file#answer_232511

在 MATLAB Online 中打开

[num,txt,raw] = xlsread('Orders.xlsx') ;
dates = txt(:,1) ;
d =  {'30-06-2016'} ;
% d = {'05-01-2015'} ;
idx = strcmp(dates,d) ;
count = length(find(idx==1));

2 个评论
显示无隐藏无

Zekeftw 2016-8-23

Hi Dr. Siva Srinivas Kolukula,

Thanks for your response.

Looks like I stated my original post wrong. Your code seems to compare the dates to the the date stored in d. I actually need to count all that fall between 05-01-2016 and 05-07-2016, etc

I will use your code as a starting point.

Peter Perkins 2016-8-23

Your question is not quite clear to me, but you may find that converting your dates to datetime and using the week function is the way to go. Hope this helps.

请先登录，再进行评论。