filtering data from table
13 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
anouar atmn
am 9 Apr. 2021
Beantwortet: Walter Roberson
am 10 Apr. 2021
Hi I got a question,
I got a table (56688x3), it contains data from 2014 to 2020. I need to make a new table from the data of 2018.
% reading csv file to a table without header
KNMI = readtable('uurgeg_215_2011-2020.txt','ReadRowNames',true);
% Fill missing data
[KNMItable,missingIndices2] = fillmissing(KNMI,"constant",0);
% Rearranging Table with needed data
Time = datetime(KNMItable.YYYYMMDD,'ConvertFrom','yyyymmdd');
Temperatuur = KNMItable.T;
GlobalStraling = KNMItable.Q;
TQTable = table(Time, Temperatuur, GlobalStraling);
%% My attempt
TQTable2018 = Time(timerange('2018-01-01', '2018-12-31'), :); % spring time data
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 10 Apr. 2021
Close.
TQTable = timetable(Time, Temperatuur, GlobalStraling);
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables 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!