Renaming headers in Table

49 次查看（过去 30 天）
Jake Bowd
Jake Bowd 2020-7-16
评论： Fangjun Jiang 2020-7-16
Hi,
I want to make a table from an array by using the array2table function. This works perfectly fine for my datasets whereby table headers do not match. But on occassion I have it whereby the data will have headers that are the same. I.e.
'ground_force_px' 'ground_force_py' 'ground_force_pz' 'ground_force_vx' 'ground_force_vy' 'ground_force_vz'
'ground_force_px' 'ground_force_py' 'ground_force_pz' 'ground_force_vx' 'ground_force_vy' 'ground_force_vz'
Is there a way whereby I can to convert from array2table whilst keeping these header names the same ?
Many thanks,
  5 个评论
显示 3更早的评论
Jake Bowd
Jake Bowd 2020-7-16
My structure looks like:
data textdata colheaders
1x290 cell 13x290 cell 295x290 double
I wish to make a table using 'data' for the data and 'colheaders' for the table headers.
I have a problem. There are repetitions in 'colheaders', which are:
'ground_force_px' 'ground_force_py' 'ground_force_pz' 'ground_force_vx' 'ground_force_vy' 'ground_force_vz'
'ground_force_px' 'ground_force_py' 'ground_force_pz' 'ground_force_vx' 'ground_force_vy' 'ground_force_vz'
and I receive the following error message:
Duplicate table variable name: 'ground_force_px'.
Question: Can I either delete the colheaders that repeat themselves along with the corresponding data, or can I rename the any colheaders that repeat?
The reason why most work is that there are no repeats of 'colheaders'. However for this particular visit, there are repeats. As such preventing from creating a table.
Fangjun Jiang
Fangjun Jiang 2020-7-16
See note under Steven's answer. "duplicated headers" is the keyword here. Look back your question, you will see why three MVPs couldn't guess it right.

请先登录，再进行评论。

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

采纳的回答

Steven Lord
Steven Lord 2020-7-16
I'm not sure I see the problem.
A = magic(6)
V = ["ground_force_px", "ground_force_py", "ground_force_pz", ...
"ground_force_vx", "ground_force_vy", "ground_force_vz"];
T = array2table(A, 'VariableNames', V)
If you mean you want to have a table where two of the variable names are the same, that's not allowed.
V2 = V;
V2(6) = V2(2);
T2 = array2table(A, 'VariableNames', V2) % Will error
  7 个评论
显示 5更早的评论
Steven Lord
Steven Lord 2020-7-16
As of release R2019b table variable names don't have to be valid MATLAB identifiers. This means table arrays created with variable names that have gone through genvarname are not necessarily the same as one whose names have gone through matlab.lang.makeUniqueStrings.
A = magic(3);
V = {'hocus pocus', 'abracadabra', 'hocus pocus'};
G = genvarname(V);
T1 = array2table(A, 'VariableNames', G)
U = matlab.lang.makeUniqueStrings(V);
T2 = array2table(A, 'VariableNames', U)
Fangjun Jiang
Fangjun Jiang 2020-7-16
good point! I see the difference.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by