combining different csv files from a folder into one matrix
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Michel Nieuwoudt
am 22 Mai 2019
Kommentiert: Michel Nieuwoudt
am 22 Mai 2019
Hello, I have 800 files with 1554rows and 2columns so (1554x2) , that I'd like to read from a folder and then combine them into a large matrix of 1554x801. The first column is common to each file, and so I'd like to set only the first column in the final matrix as the same column of all the files, and then the subsequent columns as the second column of each of the 800 files. I hope this makes sense.
Example:
A.csv=[1 2; 4 5] and B.csv=[1 8 ;4 7], C.csv=[1 6;4 10]
I'd like to combine these into
Combined=[1 2 8 6; 4 5 7 10]
Would anyone possibly have a code for this? I'm new to Matlab and have tried a number of codes that merge files. but they stack them horizontally so I get
[1 2;4 5;1 8;4 7;1 6;4 10].
Thank you!
0 Kommentare
Akzeptierte Antwort
Stephen23
am 22 Mai 2019
Bearbeitet: Stephen23
am 22 Mai 2019
"Is theremaybe a way to list the filenames in the same order, then add them afterwards as the top row to the table?"
O = {'ReadVariableNames',false};
D = '.'; % path to the directory where the files are saved.
S = dir(fullfile(D,'*.csv'));
for k = 1:numel(S)
U = readtable(fullfile(D,S(k).name),O{:});
[~,N] = fileparts(S(k).name);
U.Properties.VariableNames = {'time',N};
if k==1
T = U;
else
T = join(T,U);
end
end
Giving (the test files are attached to this answer):
>> T
T =
time A B C
____ _ _ __
1 2 8 6
4 5 7 10
>> T.B
ans =
8
7
Weitere Antworten (1)
KSSV
am 22 Mai 2019
csvfiles = dir('*.csv') ;
iwant = zeros(1554,801) ;
for i = 1:length(csvfiles)
data = csvread(csvfiles(i).name) ;
if i == 1
iwant(:,1:2) = data ;
else
iwant(:,i+1) = data(:,2) ;
end
end
8 Kommentare
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!