How do I import multiple CSV files from a directory as tables in the workspace?
44 次查看(过去 30 天)
显示 更早的评论
Hi!
I have 17 csv files in a directory names as 0000,0001,0002, and so on. I want to import all these csv files as table in the workspace. How can I do that?
Thanks in advance for the help!
0 个评论
回答(2 个)
Arif Hoq
2022-10-26
Try this:
% Get a list of all files in the folder with the desired file name pattern.
myFolder='\\msint82\redirect$\4136\Desktop\a20220729';
filePattern = fullfile(myFolder, '*.csv'); % Change to whatever pattern you need.
fileList = dir(filePattern);
for k = 1 : length(fileList)
% Read in this table.
baseFileName = fileList(k).name;
fullFileName = fullfile(fileList(k).folder, baseFileName);
thisTable = readtable(fullFileName,'VariableNamingRule','preserve');
end
0 个评论
Mathieu NOE
2022-10-26
hello
try this
%% read multiple csv files
P = pwd; % currrent directory
S = dir(fullfile(P,'*.csv')); % get list of files in directory
for k = 1:numel(S)
F = fullfile(S(k).folder, S(k).name);
T{k} = readtable(F); % cell array of tables
end
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!