Change Variable Names of a Table

Question

Tobias Pfeifer 2021-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775957-change-variable-names-of-a-table

评论： Steven Lord 2021-3-17

Hi,

i have a Table, that consists of temperature data measured with a specific amount of sensors. Now i want to change the Variable Names of the columns with the sensor data to Sensor 1.......Sensor n. The first 3 columns should not be renamed. I want to create a code that gets the number of the sensors and renames them itself. This code should be usable for different measurement without the need to rewrite the code. Thanks in advance!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Fangjun Jiang 2021-3-17

nice assignment

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2021-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/775957-change-variable-names-of-a-table#answer_650667

在 MATLAB Online 中打开

Variable names exist in the properties of the table.

tblName.Properties.VariableNames

Use indexing to set just the names you want. For example, consider the folowing code for renaming 5 sensors starting at variable 4.

% Create table of 5 rows, 10 variables
A=array2table(rand(5,10))
A = 5×10 table
      Var1        Var2        Var3       Var4       Var5       Var6        Var7         Var8       Var9       Var10 
    ________    ________    ________    _______    _______    _______    _________    ________    _______    _______

    0.087249      0.9872     0.10918    0.73819    0.29765    0.15232      0.79646     0.40895    0.19119    0.71244
     0.42075    0.071006     0.95593    0.76589    0.78594    0.86312      0.13858     0.23522    0.94558    0.59231
      0.5377     0.70569    0.011251    0.44339     0.3339    0.54552    0.0070234     0.40979    0.39547    0.29689
     0.18404     0.86838     0.76226    0.86665    0.25129     0.8476     0.060897    0.070054    0.14161    0.27797
     0.11394      0.1903     0.54479    0.14489    0.99445    0.91203     0.077083     0.73749    0.91161     0.5621
% Create variable names for 5 sensors
n=5;
sNames = "Sensor " + (1:n);
% rename variables starting at Var4, and including n continguous variables.
A.Properties.VariableNames(4:4+n-1)=sNames
A = 5×10 table
      Var1        Var2        Var3      Sensor 1    Sensor 2    Sensor 3    Sensor 4     Sensor 5     Var9       Var10 
    ________    ________    ________    ________    ________    ________    _________    ________    _______    _______

    0.087249      0.9872     0.10918    0.73819     0.29765     0.15232       0.79646     0.40895    0.19119    0.71244
     0.42075    0.071006     0.95593    0.76589     0.78594     0.86312       0.13858     0.23522    0.94558    0.59231
      0.5377     0.70569    0.011251    0.44339      0.3339     0.54552     0.0070234     0.40979    0.39547    0.29689
     0.18404     0.86838     0.76226    0.86665     0.25129      0.8476      0.060897    0.070054    0.14161    0.27797
     0.11394      0.1903     0.54479    0.14489     0.99445     0.91203      0.077083     0.73749    0.91161     0.5621