MATLAB: Problem in importing data

data importexcel

Hello All,

I am trying to import data from excel file to matlab. But, matlab is recognizing the numbers as NaN.

How can I solve it?

I am attaching the excel file containing all data.

Thanks, Majbah

Best Answer

At row 11919 you have a divide by zero in Excel and that's giving you a nan in the array. The rest of the array elements are the correct numbers though.

Related Solutions

MATLAB: Problem in importing textfiles

MATLAB only recognizes the period character as the decimal radix, so you will need to change that comma character before converting to numeric. To achieve this when reading the file with MATLAB, you could do something like this:

fid = fopen('temp.txt');
C = textscan(fid, '%s%s%s');
fclose(fid);
C = [C{:}];
hdr = C(1,:);
dat = regexprep(C(2:end,:),',','.');
dat = cellfun(@(s)sscanf(s,'%f'),dat);

MATLAB: Problem with import data

There is something strange going on with that data-file, but if the file is a simple tab-delimited text-file (attached), then this code will import and plot that data:

fid = fopen('distortion.txt','rt');
M = cell2mat(textscan(fid,'%f%f%f%f%f','HeaderLines',1));
fclose(fid);
plot(M(:,5),M(:,1))

Best Answer

Related Solutions

MATLAB: Problem in importing textfiles

MATLAB: Problem with import data

Related Question