How to import data correctly from the attatched .csv file?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Prabhanshu Chandra
am 10 Sep. 2020
Kommentiert: Prabhanshu Chandra
am 10 Sep. 2020
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 Kommentare
Akzeptierte Antwort
Ameer Hamza
am 10 Sep. 2020
Bearbeitet: Ameer Hamza
am 10 Sep. 2020
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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!