How to import data correctly from the attatched .csv file?
2 ビュー (過去 30 日間)
古いコメントを表示
Prabhanshu Chandra
2020 年 9 月 10 日
コメント済み: 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 件のコメント
採用された回答
Ameer Hamza
2020 年 9 月 10 日
編集済み: Ameer Hamza
2020 年 9 月 10 日
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'});
3 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Tables についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!