Adding a string in front of every variable in a table

4 次查看（过去 30 天）

显示更早的评论

BA 2022-9-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1808775-adding-a-string-in-front-of-every-variable-in-a-table

评论： Eric Sofen 2022-9-21

采纳的回答： Voss

Ztable.xlsx

I was looking to make a script that added a string in front of every variable in my table.

For example, I want to add "Table_" in front of every variable in the table I've attached to this post.

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

请先登录，再进行评论。

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

采纳的回答

Voss 2022-9-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1808775-adding-a-string-in-front-of-every-variable-in-a-table#answer_1057340

% read the table
t = readtable('Ztable.xlsx','VariableNamingRule','preserve');
% modify the variable names
t.Properties.VariableNames = strcat('Table_',t.Properties.VariableNames);
% save the table
writetable(t,'Ztable_modified.xlsx')

2 个评论
显示无隐藏无

BA 2022-9-20

Thank you!

Eric Sofen 2022-9-21

Or using the string data type...

t.Properties.VariableNames = "Table_" + t.Properties.VariableNames;

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

产品

MATLAB

版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by