Line plot for irregular timeseries data

Hello everyone i am new to matlab.

First i convert into datetime format.

1.my question is how to plot line graphs for irregular timeseries data.

2.How to set datetick format in x-axis.

i attached my excel file and code which i tried also.

some sample plot also i added

.

I hope i will get answer for this thank you advance

Plot(book.date,book.Nnuc)
datetick('x','dd-MM-yyyy HH:mm:ss','keepticks');

Answer 1

[Chunru]

a = readtable("book.xlsx");
idx = find(diff(a.date) > 1.2/24);  % find the location of large time gap
a.Nnuc(idx+1) = nan;              % use nan to remove the part
plot(a.date, a.Nnuc)
datetick('x');

[vignesh mohan]

chunru sir thank you but i want to remove the empty line how can i remove that?

[Chunru]

What empty line? Do you mean the flat part from ~4/15-4/16?

[vignesh mohan]

yea chunru sir. i want to remove flat part from that particular date 4/15,4/16

[Chunru]

See above on removing the flat part.

[vignesh mohan]

Thank you so much chunru sir It works fine and onething i want to know is if i want to plot for Nsatk means again i want to run this code a.Nnuc(idx+1) = nan; for Nsatk?isn't?

[vignesh mohan]

If i have a 15 min time intervel means what can i do for that sir?

idx = find(diff(a.date) > 1.2/24) can i add 15min instead of 24?

[Chunru]

Your current data has 1h interval except for some gap. The statement above 1.2/24 is to find the gap greater than 1.2h (datetime has a unit of 'day' so we need the division by 24).

If your normal time interval is 15 min and you expect a gap is larger than 15 min, you can cahnge 1.2/24 into 1.2*(15/60)/24 where 15/60/24 is to conversion from min to day. A factor of 1.2 is to check if the gap is 1.2*15min=18min.

[vignesh mohan]

Thank you so much sir