avoid replacing numbers with nans when importing data from dat file
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
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)
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!