How to import data correctly from the attatched .csv file?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Prabhanshu Chandra
le 10 Sep 2020
Commenté : Prabhanshu Chandra
le 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 commentaires
Réponse acceptée
Ameer Hamza
le 10 Sep 2020
Modifié(e) : Ameer Hamza
le 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!