avoid replacing numbers with nans when importing data from dat file

3 次查看（过去 30 天）
Abdulkarim Almukdad
Abdulkarim Almukdad 2020-10-21
评论： Abdulkarim Almukdad 2020-10-21
I have a dat file that is mixed up with text and numbers. However, I only need the numbers from certian row to certian row (all the text and other numbers are not needed)
I have tried to use readtable function, but all the numbers I want to read are appearing as NaN. Moreover, when I convert the whole file to excel and deleted everything except my numbers then readed the file as xlsx it works but some variables appear in the following format ('123') thus matlab assume these are cells and an error appear saying that var1 and variablr 22 are double and array.
Therefore, how can I read directly from the dat file and avoid the issue of NaNs then avoid the cells and read the numbers or better to change the cell to regular double data that can be assigned to variables without errors.
  6 个评论
显示 4更早的评论
Ameer Hamza
Ameer Hamza 2020-10-21
编辑：Ameer Hamza 2020-10-21
When I import the file in R2020b, all columns are read correctly except column 22. You can read it as string
opts = detectImportOptions('data.csv');
opts.VariableTypes{22} = 'string';
T = readtable('data.csv', opts)
Abdulkarim Almukdad
Abdulkarim Almukdad 2020-10-21
it worked maybe because I have deleted the text, I have attached a new file that includes some of the text in the data

请先登录，再进行评论。

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

回答（0 个）

类别

在 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