How to plot unequal time series with same x-axis

10 views (last 30 days)
Hi everyone,
I required to plot two unequal time series data on one plot with two y-axis. For first times series: x-axis is time dd/mm/yyyy and y-axis a veriable data length is 485 by 2. While, the second time series x-axis is time (dd/mm/yyyy) and y-axis is another varibale (data length: 60 by 2) . I tried but it didn't work:
(dataset also attached for reference)
clear all
clc
T = readtable('data.csv')
R_t=T(:,1);
R_wl=T(:,2);
R_wv=T(:,3);
E_t=T(:,4);
E_m=T(:,5);
plot(R_t,R_wl)
plot(R_t,R_wl,'-o',E_t,E_m,'-x')

Accepted Answer

Simon Chan
Simon Chan on 16 Jan 2022
You may try the following:
T = readtable('data.csv'); % Read csv file as entire table
TT2 = table2timetable(T(:,4:5)); % Extract the 4th and 5th columns as TT2
TT1 = table2timetable(T(:,1:3)); % Convert 1st to 3rd column to TT1
TT3 = outerjoin(TT1,TT2); % Perform outerjoin
%
yyaxis left
plot(TT3.Var1,TT3.Var2,'c--'); % Plot data from Column 2 of csv file
yyaxis right
plot(TT3.Var1,TT3.Var5,'b+') % Plot data from Column 5 of the csv file

More Answers (1)

Seth Furman
Seth Furman on 23 Sep 2022 at 20:23
Plotting multirate data is now easier with stackedplot, which now supports multiple timetable inputs.
T = readtable("https://in.mathworks.com/matlabcentral/answers/uploaded_files/864145/data.csv")
T = 485×5 table
Var1 Var2 Var3 Var4 Var5 __________ ______ _______ __________ ____ 10/11/1987 358.71 2.7064 05/08/1983 3 26/11/1987 356.51 2.2161 30/08/1983 3 12/12/1987 354.01 1.708 04/10/1983 3 04/05/1988 352.22 1.5115 17/05/1984 3 05/06/1988 356.84 2.3481 10/08/1988 3.5 24/08/1988 361 2.9182 11/11/1988 4.9 11/10/1988 360.69 3.133 29/03/1990 3 27/10/1988 360.66 3.1278 29/08/1990 3 12/11/1988 360.11 2.8967 18/12/1991 4 28/11/1988 358.16 2.2832 21/07/1992 3.2 15/01/1989 350.99 1.1689 25/10/1992 3.5 24/01/1989 349.6 0.93675 09/09/1993 3.3 09/02/1989 346.99 0.66119 28/01/1994 3.8 16/05/1989 347.54 0.7748 28/01/1996 3.2 28/09/1989 360.33 2.6684 11/08/1996 3 01/12/1989 351.61 1.1023 29/07/1997 3.7
TT1 = table2timetable(T(:,1:3))
TT1 = 485×2 timetable
Var1 Var2 Var3 __________ ______ _______ 10/11/1987 358.71 2.7064 26/11/1987 356.51 2.2161 12/12/1987 354.01 1.708 04/05/1988 352.22 1.5115 05/06/1988 356.84 2.3481 24/08/1988 361 2.9182 11/10/1988 360.69 3.133 27/10/1988 360.66 3.1278 12/11/1988 360.11 2.8967 28/11/1988 358.16 2.2832 15/01/1989 350.99 1.1689 24/01/1989 349.6 0.93675 09/02/1989 346.99 0.66119 16/05/1989 347.54 0.7748 28/09/1989 360.33 2.6684 01/12/1989 351.61 1.1023
TT2 = table2timetable(T(:,4:5))
TT2 = 485×1 timetable
Var4 Var5 __________ ____ 05/08/1983 3 30/08/1983 3 04/10/1983 3 17/05/1984 3 10/08/1988 3.5 11/11/1988 4.9 29/03/1990 3 29/08/1990 3 18/12/1991 4 21/07/1992 3.2 25/10/1992 3.5 09/09/1993 3.3 28/01/1994 3.8 28/01/1996 3.2 11/08/1996 3 29/07/1997 3.7
sp = stackedplot(TT1,TT2);

Tags

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!