MATLAB: How to create a tabularTextDatastore with multiple files in subfolders

datastoreMATLAB

This is my first attempt at datastores. I have a folder with multiple sub-folders, each subfolder currently contains 1 csv file (though they might contain more in the future).

I create the object using the following code:

ds = tabularTextDatastore( '~/data/folder_with_subfolders/*' );

This generates the following error: Error using tabularTextDatastore (line 93). Not enough input arguments.

I have tried a number of different things:

instead of the wildcard, I included the 'IncludeSubfolders', true name/value pair;
tried adding headers to the CSV file in case that was needed for creating column names;
renamed the file to a simple name.csv (currently the files are automatically generated from a database);
specified the .csv FileExtensions option…

The documentation shows how to create a datastore from one csv file, but that is not my use case… What am I missing? Thanks!

Best Answer

What shows up for

which -all tabularTextDatastore

In your release, line 93 should be a comment, with there not being any executable code until about line 120.

Related Solutions

MATLAB: Fullfile to contain multiply file extension

Try:

filePatternCSV = fullfile(handles.sourceFolder, '*.csv'); 
csvFiles = dir(filePatternCSV); 
filePatternXLS = fullfile(handles.sourceFolder, '*.xls'); 
xlsFiles = dir(filePatternXLS);
filePatternODS = fullfile(handles.sourceFolder, '*.ods'); 
odsFiles = dir(filePatternODS);
allFiles= vertcat(csvFiles,xlsFiles,odsFiles);

MATLAB: Datetime format using tabularTextDatastore

Looks like you set the 'SelectedFormats' property to match the variables.

TabularTextDatastore Properties
...  
SelectedFormats — Formats of selected variables
cell array of character vectors
Formats of the selected variables to read, specified as a cell array of character 
vectors, where each character vector contains one conversion specifier. The variables 
to read are indicated by the SelectedVariableNames property. The number of character 
vectors in SelectedFormats must match the number of variables to read.
You can use the same conversion specifiers that the textscan function accepts, 
including specifiers that skip literal text. However, you cannot use a conversion 
specifier that skips a field. That is, the conversion specifier cannot include 
an asterisk character (*).

Best Answer

Related Solutions

MATLAB: Fullfile to contain multiply file extension

MATLAB: Datetime format using tabularTextDatastore

Related Question