Extracted data added into one column, how can data be assign into different columns
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
muhammad choudhry
le 30 Nov 2020
Commenté : Ameer Hamza
le 30 Nov 2020
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
0 commentaires
Réponse acceptée
Ameer Hamza
le 30 Nov 2020
Modifié(e) : Ameer Hamza
le 30 Nov 2020
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{:}];
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur File Operations dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!