Line plot for irregular timeseries data
1 view (last 30 days)
Show older comments
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');
0 Comments
Accepted Answer
Chunru
on 6 Dec 2021
Edited: Chunru
on 9 Dec 2021
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');
8 Comments
Chunru
on 9 Dec 2021
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.
More Answers (0)
See Also
Categories
Find more on Title in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!