Cell/table Reformat

Question

Koen Nijssen 2016-6-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/289590-cell-table-reformat

回答： Pavithra Ashok Kumar 2016-6-15

I have a very specific formatting issue. Right now, I have used the readtable command to load a csv file into the workspace. It looks something like this:

A={'Country', 'Prod1', 'Prod2';
    'BE', '5', '8';
    'NL', '15', '9';
    'DE','13','18'};

However, I need it to look like this:

A={'Country','Product #', 'Amount';
    'BE', '1', '5';
    'BE', '2', '8';
    'NL', '1', '15';
    'NL', '2', '9'; ...}

Thanks for the help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Pavithra Ashok Kumar 2016-6-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/289590-cell-table-reformat#answer_225576

在 MATLAB Online 中打开

Hi

The "readtable" treats the entries in the first line of the file as variable names. So updating the first line of your .dat file should solve the issue. You can programmatically change the variable names by :

T.Properties.VariableNames{'Prod1'} = 'Product #';

Hope this helps.