Appending data to end of column in Table (for Loop)
18 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
MILLER BIGGELAAR
am 22 Okt. 2022
Kommentiert: MILLER BIGGELAAR
am 22 Okt. 2022
Hey guys,
Currently I have 14 .csv files in which I need certain values from ( a column of data ).
the values are all for the same variable and are the maximum temperatures for days in a month ( I have a range from 09/2021 - 10/2022)
What I would like is to collect data from each table into a single nx1 table.
My current for loop works correctly except that it overrides each iteration with the next.
code is as follows:
clear
clc
range = 'D10:D39';
t1 = datetime(2021,09,01);
t2 = datetime(2022,10,01);
t = t1:calmonths(1):t2;
t = convertStringsToChars(string(yyyymmdd(t)));
t = cellfun(@(S) S(1:end-2), t, 'Uniform',0);
for i = 1:length(t);
filename = convertCharsToStrings(append('IDCJDW7021.', t(i), '.csv'));
T = readtable(filename,'Range',range,'ReadVariableNames',false);
end
anythign above the for loop is working fine and besides the data overwrite problem, the for loop is operational.
Will I need to create a table prior to the for loop with the designated size?
Thanks in advance!
Miller
0 Kommentare
Akzeptierte Antwort
VBBV
am 22 Okt. 2022
T{i} = readtable(filename,'Range',range,'ReadVariableNames',false);
You can use cell arrays instead
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Creating and Concatenating Matrices 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!