How to import data with string, missing data,and numeric values?

6 次查看（过去 30 天）
Danupon Subanapong
Danupon Subanapong 2018-11-14
评论： madhan ravi 2018-11-14
Hi!! I would like to ask for your help. I have to a number of import text data. Inside these text files, there are strings, numeric values, and missing data. I have been seeking for how to import these files. I tried importdata, but it only imports data from row no.1 to the missing data row. I will attach the example of input file as well. Please check it.

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

采纳的回答

madhan ravi
madhan ravi 2018-11-14
编辑：madhan ravi 2018-11-14
fid=fopen('Example_of_input3.txt');
f=textscan(fid,'%s', 'delimiter','\n');
fclose(fid);
celldisp(f)
  4 个评论
显示 2更早的评论
Danupon Subanapong
Danupon Subanapong 2018-11-14
Thank you so much. Your answer is very helpful. I have one last question. I have been trying to convert the character array f{1}{4:end} to numeric array. I try to use for loop as shown below. But it takes very long time to process. Can you please suggest some alternative for faster solution?
A=zeros(12000,5);
for i=4:end
A(i,:)=str2num(string(f{1}{i})
end
madhan ravi
madhan ravi 2018-11-14
Anytime :) , see my previous comment just use indexing loop is not needed , search indexing cell array in internet and read slowly you will understand

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by