How to plot time and date (x-axis) on predicted model?

Question

Ali 2019-2-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/445700-how-to-plot-time-and-date-x-axis-on-predicted-model

评论： Ali 2019-3-12

ResultsA.xlsx

I want to display time and date as shown in figure 1.After training the model i get the predicted values.The data file(.xlsx) is also attached.I want to plot Actual and Predicted values along with time on x-axis.I tried below code but didnt worked

table1=readtable('ResultsA.xlsx');
X=('Date')
Y=('Actual')
K=('Pred')
plot(table1.(X),table1.(Y));
hold on
t1=datetime(2016,11,19,04,21,0); %'dd.MM.yyyy HH:mm:ss'                   
t2=datetime(2016,11,20,18,00,0);
xlim([t1 t2])
plot(YPred)
hold off

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Naman Bhaia 2019-2-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/445700-how-to-plot-time-and-date-x-axis-on-predicted-model#answer_362990

在 MATLAB Online 中打开

Hey Ali,

I tried running your code and with minimal change I got the date as the X- axis labels. Check if this is what you were looking for.

table1=readtable('ResultsA.xlsx');
X=('Date');
Y=('Actual');
K=('Pred');
plot(table1.(X),table1.(Y),'b');
hold on
plot(table1.(X),table1.(K),'r');
t1=datetime(2016,11,19,04,21,0); %'dd.MM.yyyy HH:mm:ss'                   
t2=datetime(2016,11,20,18,00,0);
xlim([t1 t2])
hold off