NaNs when reading from table

12 次查看（过去 30 天）
Abdulkarim Almukdad
Abdulkarim Almukdad 2020-10-22
评论： Abdulkarim Almukdad 2020-10-22
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) ;

请先登录，再回答此问题。

回答（1 个）

Sudhakar Shinde
Sudhakar Shinde 2020-10-22
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 ('').
  1 个评论
Abdulkarim Almukdad
Abdulkarim Almukdad 2020-10-22
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by