How to get number of occurrence in a list with gaps?

Good morning;

I have a list of dates like below:

1/1/2019

1/1/2019

2/1/2019

4/1/2019

4/1/2019

7/1/2019

7/1/2019

7/1/2019

I would like to generate a list with dates and number of occurrence. the output must be :

1/1/2019 2

2/1/2019 1

3/1/2019 0

4/1/2019 2

5/1/2019 0

6/1/2019 0

7/1/2019 3

I've been using "awk" to do that, but it doesn't give a good results with the "gaps" in the dates list

is there a way to do that with matlab?, I'm not very good at it.

[madhan ravi]

Upload your data file. Which version of MATLAB are you using?

[Redouane Ch]

the file is attached, I'm using matlab 2016a

Answer 1

[Bruno Luong]

(EDIT for R2016a, not supported for strings.)

% dummy test data
d={'1/1/2019'
'1/1/2019'
'2/1/2019'
'4/1/2019'
'4/1/2019'
'7/1/2019'
'7/1/2019'
'7/1/2019'}

dn=datenum(d,'dd/mm/yyyy');
count=accumarray(dn-min(dn)+1,1);
date=datestr(min(dn)+(0:size(count,1)-1)','dd/mm/yyyy');
T=table(date,count)

returns result in table

T =

  7×2 table

       date       count
    __________    _____

    01/01/2019      2  
    02/01/2019      1  
    03/01/2019      0  
    04/01/2019      2  
    05/01/2019      0  
    06/01/2019      0  
    07/01/2019      3  

[Redouane Ch]

thank you for you response, but there's a "Dimensions of matrices being concatenated are not consistent" error for dates 10/10/2019 and on because of the dimension

also when I use:

load 'file1.dat'

d=file1(:,1);

it doesn't take all the date. Thank you

[Bruno Luong]

Sorry LOAD is your command not mine And 'file1.dat' is your file.

[Redouane Ch]

file1.dat is the file i'm using, it is attached as .txt

I'm using "load", isn't that correct?

[Bruno Luong]

This is unrelated question, please post in the new thread if you have issue of loading your data from file.

[Redouane Ch]

Thank you for your response :)

[Redouane Ch]

your suggestion works fine for me, but the results start from the first line of data.

if our file starts with "2/1/2019" it will not show "1/1/2019 0"

[Bruno Luong]

Yes that's how it supposes to work since 1/1/2019 is not belong to any gap.

Without any specification, how should the filling code decides to add counting from 1/1/2019 and not from 1/1/2000, or 1/1/1900?

If you want the code to makes the count from whatever the date, replace

min(dn) 

occurences by

datenum('1/1/2019',...)