How to plot timeseries graph

1 次查看(过去 30 天)
emily bristow
emily bristow 2020-11-30
I have 7 months of dissolved oxygen data through a water column (March, April, May, June, July, August, November) I need to plot this as a timeseries but I'm unsure on where to start.
How do I plot the bottom water oxygen concnetrations against each month they were taken?
The excel file attatched is one example of the data.
  1 个评论
Mathieu NOE
Mathieu NOE 2020-12-8
hello
how are the data sampled ? I assume the attached xlsx file does not cover the entire 7 monthes ?
you want to plot each seperate month (one plot = one month ? )

请先登录,再进行评论。

回答(1 个)

Mathieu NOE
Mathieu NOE 2020-12-8
hello again
a sample code that can help you
% data format (7 columns)
% depth temp salin sig chl DO DO%
% -5 9,491 35,311 27,281 0,59 285,5 100,31
% assuming one data = one day
% how many days in each month :
% March : 31 , April : 30 , May : 31 , June : 30 , July : 31, August : 31 , November : 30
monthes = {'March','April','May','June','July','August','November'};
days_per_month = [31 30 31 30 31 31 30];
filename = "mar2014ctd2.xlsx"; % extended data length to cover the 7 month / 1 data per day range
C = readcell(filename);
[m,n] = size(C);
data = cell2mat(C(2:m,:)); % start at row index 2 to ignore header line
stop_index = 1; % init
%% plot
for ci = 1: length(days_per_month)
start_index = stop_index;
stop_index = start_index-1 + days_per_month(ci);
x_axis = 1:1:days_per_month(ci);
DO_extract = data(start_index:stop_index,6); % 6th column = DO
figure(ci), plot(x_axis,DO_extract,'*-');grid
title(monthes(ci));
xlabel('Days');
ylabel('DO');
end

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by