MATLAB: Importing csv file into matlab

csvreaddata uploading

Hi,

I am having error while using csv read for the following file.

num = csvread (FileName,2,0);
Error using dlmread (line 143)
Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1, field number 57) ==>
N,N,N,N,N,N,N,Y,N,N\n

Is there a way to read the following sheet into matlab.

Thanks…!!!!

Best Answer

csvread() is unable to read files with text, with the possible exception of header rows and maybe leading columns of text -- definitely not text at the end of lines.

If you have R2013b or later, I suggest you use

datatab = readtable('matlab_upload.csv', 'headerlines', 1);

Related Solutions

MATLAB: Csvread: Trouble reading ‘Numeric’ field from file

datacell = textscan( regexprep( fileread('test.csv'), '\$', '0' ), '%f%f', 'delimiter', ',', 'HeaderLines', 1);
Duration = datacell{1};
Input = datacell{1};
YourTable = table(Duration, Input);

MATLAB: Loop to read files

To read all csv files one by one

files = dir('*.csv');
table_data = cell(1, numel(files));
for i=1:numel(files)
    filename = files(i).name;
    table_data{i} = readtable(filename);
end

To only read these specific files

range = 2010:1:2020;
table_data = cell(1, numel(range));
for i = 1:numel(range)
    filename = sprintf('data_%d.csv', range(i));
    table_data{i} = readtable(filename);
end

Best Answer

Related Solutions

MATLAB: Csvread: Trouble reading ‘Numeric’ field from file

MATLAB: Loop to read files

Related Question