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!

回答(2 个)

Arif Hoq
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

Mathieu NOE
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

类别

Help CenterFile Exchange 中查找有关 Environment and Settings 的更多信息

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by