Can one save the filename as a variable in 'readtable'?
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
alpedhuez
am 28 Nov. 2020
Kommentiert: alpedhuez
am 29 Nov. 2020
Suppose I use
T=readtable('texas,csv')
I want to save the name of the file (texas) as a variable. Please advise.
Akzeptierte Antwort
Image Analyst
am 29 Nov. 2020
See the FAQ:
Adapting it would go something like this:
% Specify the folder where the files live.
myFolder = pwd; % or 'C:\Users\yourUserName\Documents\My Pictures';
% Check to make sure that folder actually exists. Warn user if it doesn't.
if ~isfolder(myFolder)
errorMessage = sprintf('Error: The following folder does not exist:\n%s\nPlease specify a new folder.', myFolder);
uiwait(warndlg(errorMessage));
myFolder = uigetdir(); % Ask for a new one.
if myFolder == 0
% User clicked Cancel
return;
end
end
% Get a list of all files in the folder with the desired file name pattern.
filePattern = fullfile(myFolder, '*.csv'); % Change to whatever pattern you need.
theFiles = dir(filePattern);
for k = 1 : length(theFiles)
baseFileName = theFiles(k).name;
fullFileName = fullfile(theFiles(k).folder, baseFileName);
fprintf(1, 'Now reading %s\n', fullFileName);
% Now do whatever you want with this file name,
% such as reading it in with readtable() or csvread().
data{k} = readtable(fullFileName);
end
fprintf('Done processing %d CSV files.\n', length(theFiles));
Results are in a cell array.
It needs to be a cell array because the data in the files might not all be the same size.
Weitere Antworten (1)
Ameer Hamza
am 28 Nov. 2020
Bearbeitet: Ameer Hamza
am 28 Nov. 2020
you can save char arrays in a variable and then concatenate it with the extension using [] operator.
filename = 'texas';
T = readtable([T '.csv'])
5 Kommentare
Ameer Hamza
am 29 Nov. 2020
Are you trying to name the variables named like texas, iowa, etc. For example
filename = 'texas';
texas = readtable([T '.csv'])
This is not a good coding approach: https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval
Siehe auch
Kategorien
Mehr zu Debugging and Analysis finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!