I wanted to combine 100 csv files for plotting in Matlab. All the files have same number of columns and rows. Can anyone help?

2 次查看（过去 30 天）
Md Sadiq
Md Sadiq 2024-3-12
评论： Voss 2024-3-13
I Used the following code.But it is not working
csvFiles = dir('*.csv') ;
N = length(csvFiles) ;
for i = 1:N
T = readtable(csvFiles(i).name) ;
end

请先登录，再回答此问题。

采纳的回答

Voss
Voss 2024-3-12
your_folder = 'folder where the csv files are'; % absolute or relative path
csvFiles = dir(fullfile(your_folder,'*.csv')) ;
names = fullfile({csvFiles.folder},{csvFiles.name});
N = length(csvFiles);
for i = 1:N
csvFiles(i).data = readtable(names{i});
end
% this works only if the tables read from the files all
% have the same set of column names in the same order:
T = vertcat(csvFiles.data);
  7 个评论
显示 5更早的评论
Md Sadiq
Md Sadiq 2024-3-13
Hello,
The data in column 10-17 (for the attached picture) are temperature in celcius unit.How I can convert these data in Farenheit unit? In excel,it's easy.But my number of rows exceed excel limit.So,I need to convert them in Matlab for plotting the temperature in Farenheit unit.Can you help?

请先登录，再进行评论。

更多回答（1 个）

Mathieu NOE
Mathieu NOE 2024-3-12
maybe this ?
here I wanted to do a vertical concatenation - up to you to change that portion of the code
also , if processing the files must absolutely be done with correctly sorted files , please consider using this Fex submission :
Natural-Order Filename Sort - File Exchange - MATLAB Central (mathworks.com)
fileDir = pwd; % current directory (or specify which one is the working directory)
outfile = 'OUT.dat'; % output file name
S = dir(fullfile(fileDir,'*.csv')); % get list of data files in directory
S = natsortfiles(S); % sort file names into natural order , see :
%(https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort)
out_data = [];
for k = 1:length(S)
filename = S(k).name; %
out = readmatrix( fullfile(fileDir, filename)); %
[m,n] = size(out);
if (m<1) | (n<1)
disp([' Warning : File :' filename ' is empty !'])
else
out_data = [out_data; out]; % vertical concatenation
end
end
% store out_data in excel file
writematrix(out_data,fullfile(fileDir,outfile),"Delimiter","tab");

类别

在 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!

Translated by