Count number business days per month

Question

Ana 2014-4-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127326-count-number-business-days-per-month

编辑： Azzi Abdelmalek 2014-4-26

dates.mat

Good evening,

I have a set of data like the one shown in the figure below (but the complete set of data goes until 2013), which represent already the business days in that month.

I would want a column that counts the number of days per month and gives me, for instance, 22 in row 1 (for January), 19 in row 2 (for February) and so on.

Thank you!!

2 个评论
显示无隐藏无

Azzi Abdelmalek 2014-4-26

编辑：Azzi Abdelmalek 2014-4-26

date is numeric or char? and instead of posting an image, copy and past your data,in away we could use it

Ana 2014-4-26

Numeric!

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2014-4-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/127326-count-number-business-days-per-month#answer_134706

编辑：Azzi Abdelmalek 2014-4-26

在 MATLAB Online 中打开

n=max(0,fix(log10(data)+1)-6)
b=fix(data./10.^n)
c=unique(b);
f=histc(b,c);
q=uint8(rem(c/100,1)*100);
p=arrayfun(@(x) datestr(datenum(num2str(x),'mm'),'mmm'),q,'un',0);
out=[p num2cell(f)]