MATLAB: How to skip last n rows while reading a csv file using readtable

csvMATLABreadtable

I have a csv file that I want to read as table in MATLAB using readtable command. However, I know that last few lines are corrupted or not reliable and I want to skip them. How can I do that using readtable. Note that a similar function is available in python's panda package for read.csv by supplying skipfooter.

Best Answer

I was overthinking. It is very simple to do actually.

T= readtable(csvfile,'PreserveVariableNames',true);
n_skip = 5;
T = T(1:end-n_skip,:);

Related Solutions

MATLAB: Is textscan ever better than readtable

readtable internally calls textscan, but does a lot of work before to automatically detect the format of the file and after to split the data into variables of the correct type. So, a properly designed call to textscan and direct conversion to a table is always going to be faster than going through readtable.

What little you may lose in speed (file i/o is probably dominant anyway, so processing speed may not be critical), you make up for it by the flexibility of readtable. readtable is simply textscan on steroid (and it gets better with each release) so unless it is demonstrably slower I would always use it.

Note that early readtable wasn't as good at the autodetection. As said it gradually improved with each release since R2013b. The introduction of the import options in R2016b really makes it powerful.

MATLAB: How to read a CSV file with header

The better way was use the textscan function with ";" delimiter and after replace the "," by "." before the conversion of string to number.

fileID = fopen(filename,'r');
startRow = 10;
dataArray = textscan(fileID,'%s%s%s',inf,'Delimiter',';',...
    'HeaderLines', startRow-1,'ReturnOnError', false);
fclose(fileID);
dataArray{1,2} = strrep(dataArray{1,2},',','.');
dataArray{1,3} = strrep(dataArray{1,3},',','.');

Best Answer

Related Solutions

MATLAB: Is textscan ever better than readtable

MATLAB: How to read a CSV file with header

Related Question