MATLAB: Why am i getting this error and what are the steps to correct it

data import

when importing data from a csv file. im getting the error as "Undefined function 'tabularTextDatastore' for input arguments of type 'cell'". And this is my first line "ds=tabularTextDatastore({'Ban_390_Feb.csv'},'TreatAsMissing','NA')";

Best Answer

ds=tabularTextDatastore('Ban_390_Feb.csv','TreatAsMissing','NA')

Related Solutions

MATLAB: After using the datastore function, how to change the value in the ‘csv’

The datastore cannot reflect the changed values because it simply reads the data from the file into a table.

If you want to store the changed values, you want to write the modified table back out.

Example:

while hasdata(ds)
    [T, info] = read(ds);
    T.DateValue(T.DateValue < 1997) = 0;
    filename = ['newfolder/newfile_', num2str(info.Offset), '.txt'];
    writetable(T, filename);
end
newds = datastore('newfolder/*.txt');

While this may not be the most efficient, it certainly will work.

Hope that helps.

MATLAB: TabularTextDataStore wont store more than 20000 rows

The amount of data returned on each call to the read method of a TabularTextDatastore is controlled by the value of the ReadSize property.

If you want to read more than 20,000 rows on each call to read (20,000 is the default value), then you can adjust the value of ReadSize like so:

trainSet = tabularTextDatastore("data\trainingSet.csv");
trainSet.ReadSize = 60000; % You can adjust this value to your liking.
trainSet.TreatAsMissing = 'na';
trainSetR = read(trainSet)

Best Answer

Related Solutions

MATLAB: After using the datastore function, how to change the value in the ‘csv’

MATLAB: TabularTextDataStore wont store more than 20000 rows

Related Question