Count occurrences of dates in an excel file
조회 수: 2 (최근 30일)
이전 댓글 표시
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개)
Andrei Bobrov
2016년 8월 23일
편집: Andrei Bobrov
2016년 8월 23일
[~,~,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
KSSV
2016년 8월 23일
[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
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.
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!