readtable disfigures the CSV file header

7 次查看（过去 30 天）
emjey
emjey 2023-5-11
回答： Stephen23 2023-5-11
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?

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2023-5-11
Ran in:
data = readtable('headerFile.csv','ReadVariableNames', true, 'VariableNamingRule','preserve')
data = 4×4 table
ID par_1 (mol) par_2 (meter^3) par_3 (kg/L) __ ___________ _______________ ____________ 1 4 5 11 2 3 6 10 3 2 7 9 4 1 8 8

更多回答（1 个）

Mathieu NOE
Mathieu NOE 2023-5-11
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

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by