Change Variable Names of a Table

26 次查看（过去 30 天）
Tobias Pfeifer
Tobias Pfeifer 2021-3-17
评论： 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!

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

采纳的回答

Cris LaPierre
Cris LaPierre 2021-3-17
Ran in:
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
  2 个评论
Tobias Pfeifer
Tobias Pfeifer 2021-3-17
Thank you very much for the quick response!
Steven Lord
Steven Lord 2021-3-17
As of release R2020a there's a function named renamevars for renaming table and timetable variables.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by