Automatically load a csv file from a folder
3 次查看(过去 30 天)
显示 更早的评论
I have a database (Male_Data_Dhort_QT). Within the database I have a column called FileName which (as you assumed) has names of files that I have stored in a folder called ECGData. I have a line that randomly selects a filename.
random_MaleShortName = datasample(Male_Data_ShortQT.FileName,1)
I get a 1x1 categorical result with the name of the file.
I want to create a function that automatically gets that value and searches for the file in the ECGData folder. I'd highly appreciate any help. Thanks
4 个评论
Image Analyst
2021-3-5
What is your definition of "automatic"? And of "manual". If you have to have a line of code read in the file, is that automatic? Do you need some sort of timer that periodically gets a random filename from the database?
What is the database? Is it an actual database where you use the Database Toolbox? Or is your database just a folder of files, or a table of values?
And not sure why the filename is a categorical variable instead of a string or character array. What are the categories?
回答(1 个)
Walter Roberson
2021-3-5
编辑:Walter Roberson
2021-3-5
EEGDIR = '/Users/roberson/Plan9/Dhort/ECGData';
tries = 42;
found = true;
for trynum = 1 : tries
random_MaleShortName = datasample(Male_Data_ShortQT.FileName,1);
filename = fullfile(EEGDIR, string(random_MaleShortName)+".csv");
if exist(filename); found = true; break; end
fprintf('Oh, missing file "%s"\n', filename);
end
if ~found
fprintf('Bummer! No file found in %d tries! Giving up!\n', tries);
return;
end
%at this point filename refers to a file that has been verified to exist.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!