NaNs when reading from table

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

% T=readmatrix('Pilot1_Drive2.csv');
% T1=T(133:204,1:56);
% x = T1(:,4) ; 
% y = T1(:,3) ;

Answer 1

[Sudhakar Shinde]

As there are empty fields within your csv file, MATLAB read it as NAN(not a number).

Thought could be:

1. Create a data in csv sheet effectively without any empty field to not get Nan's.

or

2. After reading file i.e 'readmatrix' function, Nan can be replaced with zeroes or empty ('').

[Abdulkarim Almukdad]

Thanks for your answer.

I don't care about the empty cells as you can see from my code, I only want to read the numbers from 133 to 204 and all the cells there contain numbers. However, those numbers are being read as NaN in matlab when I use readtable or readmatrix functions.