Extracted data added into one column, how can data be assign into different columns
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Ameer Hamza
2020-11-30
编辑:Ameer Hamza
2020-11-30
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{:}];
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!