readtable disfigures the CSV file header
Afficher commentaires plus anciens
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?
Réponse acceptée
Plus de réponses (1)
Mathieu NOE
le 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
Catégories
En savoir plus sur Spreadsheets dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!