Importing csv file with scientific notation
20 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Adolf Krige
il 23 Lug 2019
Commentato: Adolf Krige
il 23 Lug 2019
I am having a lot of trouble importing my csv files, I have tried: importdata, dlmread and textscan. Just cant seem to get it working.
I have 100+ files, so changing them manually is tricky
when using importdata the result end up as a cell aray: {' - 6 . 5 9 9 4 8 E - 0 0 1 , - 4 . 8 6 2 2 6 E + 0 0 4 , - 6 . 5 9 9 4 8 E - 0 0 1 , 3 . 8 2 3 7 5 E + 0 0....'}
1 Commento
Guillaume
il 23 Lug 2019
The main problem with your file is that it is encoded in UTF-16LE (16-bit unicode little endian), which matlab doesn't officially support for reading and writing.
Is there any chance that you can change the settings of whichever software is writing these files so that it is written with a different encoding (UTF8 would be a lot better)?
Risposta accettata
Guillaume
il 23 Lug 2019
Modificato: Guillaume
il 23 Lug 2019
Unfortunately, none of the high-level functions work with UTF16, so you have to go low-level. Even then, you'll get a warning that the encoding is not supported. As of R2019a, I'm not aware of instances where it's not decoded properly, but: here be dragons. If you can change the setting of your exporting tool.
fid = fopen('test.csv', 'rt', 'n', 'UTF16LE'); %Issues a warning that UTF16 is not supported
data = textscan(fid, repmat('%f', 1, 12), 'Delimiter', ',', 'HeaderLines', 6); %Same warning again
data = [data{:}]
fclose(fid);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import and Export in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!