How to plot Date time series in MATLAB?
9 次查看(过去 30 天)
显示 更早的评论
I am facing difficulties in plotting my time series data.The data file is also attached.I write code like this but doesnt work.
data3=readtable ('PRICE_AND_DEMAND_Jan.csv')
Date_Time = data3(:,2);
datecell=table2cell(Date_Time);
load = data3(:,3);
A = table2array(load)
p=datenum(datecell);
plot(datenum(datecell), A)
datetick('x', 'dd-mmm-yyyy HH:MM:SS')
% datetick('x', 'dd-mmm-yyyy HH:MM:SS')
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/204231/image.png)
3 个评论
Peter Perkins
2019-2-17
You have dates like xx-yy-zz. That's kind of ambiguous. You'll want to provide a format.
采纳的回答
Ricardo MF
2019-2-15
Try it:
data3=readtable ('PRICE_AND_DEMAND_Jan.csv')
Date_Time = data3(:,2);
datecell=table2cell(Date_Time);
load = data3(:,3);
A = table2array(load)
formatIn='dd-mm-yy HH:MM'
p=datenum(datecell,formatIn);
plot(p, A)
datetick('x', 'dd-mmm-yyyy HH:MM')
set(gca,'XTickLabel',datestr(p),'XMinorGrid','on')
grid
5 个评论
Ricardo MF
2019-2-15
Still with a problem to 'calibrate' the x axes but the code 'works'.
clear all
close all
data3=readtable ('PRICE_AND_DEMAND_Jan.csv')
Date_Time = data3(:,2);
datecell=table2cell(Date_Time);
load = data3(:,3);
A = table2array(load)
formatIn='dd-mm-yy HH:MM'
p=datenum(datevec(datecell,formatIn));
plot(p,A)
datetick('x', 'dd-mmm-yyyy HH:MM')
set(gca,'XTick',p([1 size(p,1)/4 size(p,1)/2 (size(p,1)/4)*3 end]),'XTickLabel',datestr(p),'XMinorGrid','on','FontSize',7)
grid
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/204233/image.jpeg)
更多回答(2 个)
Ricardo MF
2019-2-15
Are you running the entire code or assuming you already 'uploaded' the variables? The problem is with the format of your variable Date_Time that for some reason converted to a 'char' vector. Instead mine's not. When I convert to datecell, I do not have problems with datenum or datevec. Maybe this problem is related to the version of matlab as questioned by madhan ravi.
![MA2.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/204297/MA2.png)
Peter Perkins
2019-2-17
In something as recent as R2018b, stay away from datenum and datetick if possible. (Also, hardly ever does one need table2cell, brace subscripting would have done the same thing, but you don't want to do that thing anyway.)
Try this:
>> t = readtable('PRICE_AND_DEMAND_Jan.csv','Format','%s%{dd-MM-yy HH:mm}D%f%f%s');
>> t.REGION = categorical(t.REGION);
>> t.PERIODTYPE = categorical(t.PERIODTYPE);
>> head(t)
ans =
8×5 table
REGION SETTLEMENTDATE TOTALDEMAND RRP PERIODTYPE
______ ______________ ___________ _____ __________
NSW1 01-01-19 00:30 7457.6 66.95 TRADE
NSW1 01-01-19 01:00 7243.2 69.33 TRADE
NSW1 01-01-19 01:30 6918.6 72.8 TRADE
NSW1 01-01-19 02:00 6676.6 70.31 TRADE
NSW1 01-01-19 02:30 6513.2 66.98 TRADE
NSW1 01-01-19 03:00 6400 63.87 TRADE
NSW1 01-01-19 03:30 6317.4 62.2 TRADE
NSW1 01-01-19 04:00 6242.1 50.22 TRADE
>> plot(t.SETTLEMENTDATE,t.TOTALDEMAND);
![untitled.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/204523/untitled.png)
4 个评论
Peter Perkins
2019-2-21
You are going to need to post something more than that. That is not MATLAB code. In recent versions of MATLAB, all you need to do it set xlim with datetimes.
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!