Extracted data added into one column, how can data be assign into different columns

Hi,

I used the code below to extract the specific column from the different csv files and merge into one csv file. What I was expecting that data will be put into the order column 1, column 2, column 3 but that is not the case instead all the columns extracted has been put into 1 column what is the way to put the extracted data into different columns. I am attaching screenshots and putting the code below.

Code:

folder = fullfile('C:','Users','muhammad','Desktop','Velocity');

files = dir( fullfile(folder, '*.csv') );

for ii = 1:length(files)

data = readmatrix(fullfile(files(ii).folder,files(ii).name), 'NumHeaderLines', 1)

res = data(:,3);

end

Answer 1

[Ameer Hamza]

You can define res as matrix and fill its different columns

folder = fullfile('C:','Users','muhammad','Desktop','Velocity');
files = dir( fullfile(folder, '*.csv') );
for ii = 1:length(files)
     data = readmatrix(fullfile(files(ii).folder,files(ii).name), 'NumHeaderLines', 1)
     res(:,ii) = data(:,3); 
end

Following version is more efficient but requires a bit of code

folder = fullfile('C:','Users','muhammad','Desktop','Velocity');
files = dir( fullfile(folder, '*.csv') );
res = cell(size(files));
for ii = 1:length(files)
     data = readmatrix(fullfile(files(ii).folder,files(ii).name), 'NumHeaderLines', 1)
     res{ii} = data(:,3); 
end
res = [res{:}];

[muhammad choudhry]

Thanks a lot hamza!

[Ameer Hamza]

I am glad to be of help!