Converting HH:MM:SS into decimal days to make a time series
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
emily bristow
am 12 Dez. 2020
Kommentiert: emily bristow
am 12 Dez. 2020
I need to make a timeseries across three days (7th June - 9th June 2010) - I'm unsure how to include both the time and days across the x-axis?
I think I need to convert into decimal days but I'm unsure on how to do this and combine both days and time.
Seperate timeseries plots need to be made for the mean phosphate and nitrate concentrations in surface and bottom waters, again I'm not sure how to do this!
Any help will be grateful, the excel sheet is attached.
1 Kommentar
Akzeptierte Antwort
Cris LaPierre
am 12 Dez. 2020
Bearbeitet: Cris LaPierre
am 12 Dez. 2020
Use a datetime. When you plot, your data type is honored. You can use xtickformat to format how the data appears.
% Define date and time formats for import
opts = detectImportOptions("CTD12-17.xlsx");
% nice, but not necessary
opts.VariableNamingRule = "preserve";
opts = setvartype(opts,"Time","duration");
opts = setvaropts(opts,"Time","InputFormat","hh:mm:ss","DurationFormat","hh:mm:ss");
% Set datetime format for Date + Time
opts = setvartype(opts,"Date_TimeCombined","datetime");
opts = setvaropts(opts,"Date_TimeCombined","InputFormat","dd/MM/yy HH:mm:ss");
% Load data
data = readtable("CTD12-17.xlsx",opts)
%Plot
plot(data.("Date + Time Combined"),data.("Bottom Water Mean N+N"))
3 Kommentare
Cris LaPierre
am 12 Dez. 2020
Ah, because the Date+Time column format is incorrect. I specified it as MM/dd/yy but it is actually dd/MM/yy. I've updated and rerun my original post.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!