How to import data correctly from the attatched .csv file?

Question

Prabhanshu Chandra 2020-9-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591571-how-to-import-data-correctly-from-the-attatched-csv-file

评论： Prabhanshu Chandra 2020-9-10

opts = detectImportOptions('Compare for L100 and L150\Result_R-970_W-10um_C-LRL-C_Model.csv','TrimNonNumeric',true,'NumHeaderLines',1);
T2 = readtable('Compare for L100 and L150\Result_R-970_W-10um_C-LRL-C_Model.csv',opts);
T2.Properties.VariableNames={'freq','Z'};

I am using this code to import data from the attached file into a table, however the 2nd column in file is Real + j Imaginart value and this code is only saving Real part into Z and not saving the entire complex part into Z. How can I rectify that?

Note:

Even if we manage to get the complex part into a single column, I think matlab may take it as a string because A+iB is not valid in MATLAB. MATLAB syntax for complex number is A+Bi

Even if we manage to delimit at +/- sign same syntax problem still exist.

Edit: I am also adding another file format(TAB limited .txt) with same data, please show code to extract from that format as well.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-9-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591571-how-to-import-data-correctly-from-the-attatched-csv-file#answer_492505

编辑：Ameer Hamza 2020-9-10

在 MATLAB Online 中打开

Try textscan()

f = fopen('Result_R-640_W-10um_C-LRL-C_Model.csv');
data = textscan(f, '%f GHz,%f %s j%f', 'HeaderLines', 12);
fclose(f);
s = cellfun(@(x) 2*(x=='+')-1, data{3});
t = table(data{1}, data{2}+s.*data{4}*1i, 'VariableNames', {'freq','Z'});