readtable disfigures the CSV file header
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
emjey
am 11 Mai 2023
Beantwortet: Stephen23
am 11 Mai 2023
I need to remove the units within brackets from my CSV file, attached.
ID par1 (mol) par2 (meter^3) par3 (kg/L)
1 4 5 11
2 3 6 10
3 2 7 9
4 1 8 8
here the basic code I tried
data = readtable('headerFile.csv','ReadVariableNames', true);
headerRow = data.Properties.VariableNames
readtable however messes up the header (raplaces special characters with '_') and instead of
{'ID'} {'par_1 (mol)'} {'par_2 (meter^3)'} {'par_3 (kg/L)'}
I get
headerRow =
1×4 cell array
Columns 1 through 4
{'ID'} {'par_1_mol_'} {'par_2_meter_3_'} {'par_3_kg_L_'}
What is the best way to extract the actual header?
0 Kommentare
Akzeptierte Antwort
Stephen23
am 11 Mai 2023
data = readtable('headerFile.csv','ReadVariableNames', true, 'VariableNamingRule','preserve')
0 Kommentare
Weitere Antworten (1)
Mathieu NOE
am 11 Mai 2023
hello
here you are :
headerRow = {'ID'} {'par_1 (mol)'} {'par_2 (meter^3)'} {'par_3 (kg/L)'}
data = readtable('headerFile.csv','ReadVariableNames', true,'VariableNamingRule' , 'preserve');
headerRow = data.Properties.VariableNames
0 Kommentare
Siehe auch
Kategorien
Mehr zu Structures 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!