opts = detectImportOptions Pass method when there is no variable Naming when reading more than 100 files

Background: Using opts = detectImportOptions, some file data are missing out of more than 100 files
Purpose: How to write after skipping the 25th file VariableName2 and skipping

path = pwd;
list = dir(path);
S = dir(fullfile(path, ‘*.csv’));

for k = 1:numel(S)
F = fullfile(S(k).folder,S(k).name);
opts = detectImportOptions(fullfile(S(k).folder,S(k).name),"VariableNamingRule","preserve",ImportErrorRule="omitrow",MissingRule="omitrow");
% There is no VariableName2 due to the omission of some file data among more than 100 files,

opts.SelectedVariableNames = {‘VariableName1’, ‘VariableName2’};
% Error occurs because there is no VariableName2

opts.MissingRule = ‘omitrow’;
T = readtable(F,opts,"ReadVariableNames",true);

filename = getfield(S,{k},’name’);
writematrix(filename,’naming.csv’,’Delimiter’,’,’,’QuoteStrings’,’all’,’WriteMode’,’append’);
writematrix(matrix_data,’myData.csv’,’Delimiter’,’,’,’QuoteStrings’,’all’,’WriteMode’,’append’);

endBackground: Using opts = detectImportOptions, some file data are missing out of more than 100 files
Purpose: How to write after skipping the 25th file VariableName2 and skipping

path = pwd;
list = dir(path);
S = dir(fullfile(path, ‘*.csv’));

opts.SelectedVariableNames = {‘VariableName1’, ‘VariableName2’};
% Error occurs because there is no VariableName2

opts.MissingRule = ‘omitrow’;
T = readtable(F,opts,"ReadVariableNames",true);

end Background: Using opts = detectImportOptions, some file data are missing out of more than 100 files
Purpose: How to write after skipping the 25th file VariableName2 and skipping

path = pwd;
list = dir(path);
S = dir(fullfile(path, ‘*.csv’));

opts.SelectedVariableNames = {‘VariableName1’, ‘VariableName2’};
% Error occurs because there is no VariableName2

opts.MissingRule = ‘omitrow’;
T = readtable(F,opts,"ReadVariableNames",true);

end opts = detectimportoptions, variablenaming, pass MATLAB Answers — New Questions

Cart

Cart