How to plot Date time series in MATLAB?
9 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ali
el 15 de Feb. de 2019
Comentada: Peter Perkins
el 21 de Feb. de 2019
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 comentarios
Peter Perkins
el 17 de Feb. de 2019
You have dates like xx-yy-zz. That's kind of ambiguous. You'll want to provide a format.
Respuesta aceptada
Ricardo MF
el 15 de Feb. de 2019
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 comentarios
Ricardo MF
el 15 de Feb. de 2019
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)
Más respuestas (2)
Ricardo MF
el 15 de Feb. de 2019
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
el 17 de Feb. de 2019
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 comentarios
Peter Perkins
el 21 de Feb. de 2019
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.
Ver también
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!