- Create a data in csv sheet effectively without any empty field to not get Nan's.
NaNs when reading from table
71 views (last 30 days)
When I read the data attached matlab shows the numbers from row 133 until 204 as NaNs. everything workds fine if I edit the numbers from excel by using text to columns function from excel because the numbers are placed in the first column rather than being distributed on the columns. Moreover, I'm looking for a way to read the the numbers from line 133 until the cell that contains (0 0 0 0 0 0 0) which is in this case its the row number 205. The file is in DAT format but since matlab website doesn't accept that format I had to convert it to csv.
I have used the below code
% x = T1(:,4) ;
% y = T1(:,3) ;
Sudhakar Shinde on 22 Oct 2020
As there are empty fields within your csv file, MATLAB read it as NAN(not a number).
Thought could be:
2. After reading file i.e 'readmatrix' function, Nan can be replaced with zeroes or empty ('').