MATLAB Answers

xlsread: NaN is not recognized as Numeric Data

42 views (last 30 days)
chris_andreas
chris_andreas on 23 Jun 2016
Commented: brian zhang on 17 Jul 2020 at 16:16
I like to import data from the file 'test.csv' (see attachment) into matlab. I use following code:
[Data, Time] = xlsread('test.csv')
Problem: The numeric data that is returned doesn't include the NaN data from the first rows. It looks like that xlsread doesn't include the NaN data if the whole row consists only of NaN Data. For my routine the NaN data from the first rows needs to be returned also.
Thx for your help. Chris

  1 Comment

brian zhang
brian zhang on 17 Jul 2020 at 16:16
try to convert data to string you will get NaN not a number. I bet convert back to number will not be 'NaN'. Logic return will be 0 which is an error.

Sign in to comment.

Accepted Answer

chris_andreas
chris_andreas on 4 Jul 2016
Hi! I found a solution: With the function "importdata" the data is imported the "right" way.

  0 Comments

Sign in to comment.

More Answers (2)

dpb
dpb on 23 Jun 2016
My release of Excel doesn't have NaN as a numeric entity; suspect it's not being returned because it isn't numeric. Look at the alternate outputs of xlsread, text, and raw. You'll likely have to process the raw text array.

  0 Comments

Sign in to comment.


Muhammad Usman  Saleem
Muhammad Usman Saleem on 23 Jun 2016
convert this csv file into excel. Then try to read
xlsread('test.csv')
or you have another option if NAN values are not read by xlsread. Change in csv file NaN value with arbitary value like -999999 then try to read them. After then you can change this value with NaN as
find(data=-999999)=nan;
tell me please

  0 Comments

Sign in to comment.

Tags


Translated by