Line plot for irregular timeseries data

1 次查看（过去 30 天）

显示更早的评论

vignesh mohan 2021-12-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1604145-line-plot-for-irregular-timeseries-data

评论： vignesh mohan 2021-12-9

采纳的回答： Chunru

在 MATLAB Online 中打开

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');

采纳的回答

Chunru 2021-12-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1604145-line-plot-for-irregular-timeseries-data#answer_848655

编辑：Chunru 2021-12-9

在 MATLAB Online 中打开

book.xlsx

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 个评论
显示 6更早的评论隐藏 6更早的评论

Chunru 2021-12-9

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 2021-12-9