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

2018 11 14
1 个回答
回答已采纳
更新时间：2018 11 14
9 次查看（30 天）

0 个投票

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

0 个投票

fid=fopen('Example_of_input3.txt');
f=textscan(fid,'%s', 'delimiter','\n');
fclose(fid);
celldisp(f)

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Danupon Subanapong
Danupon Subanapong 2018-11-14
Thank you so much for your answer. It works. However, I have one more question. How to extract numeric array and strings from f?
madhan ravi
madhan ravi 2018-11-14
f{1}{1:3} %others
f{1}{4:end} %numeric
Anytime :) make sure to accept the answer if you got the answer to your question
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

产品

版本

R2018a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by