Name a variable using an already existing variable

1 次查看（过去 30 天）
Marcel-Maximilian
Marcel-Maximilian 2022-10-26
编辑： Stephen23 2022-10-30
Ran in:
Hello,
I am working on a project consisting of different tables containing data from different patients. They are stored in different excel sheets name PPMI001i, PPMI002i, PPMI003i, and so forth. I am working on a script to let it run all the data processing I want to do with the data of one patient. To do that i assigned a global variable.
global Nr
Nr = "PPMI002i";
After that i want to extract the date from the right sheet, using readtable.
T = readtable('BSA_Daten_Test.xlsx',opts,'sheet',Nr)
Unrecognized function or variable 'opts'.
However, I would like "T" to be named after my first variable, so it does not get overwritten when I change "Nr".
I hope someone can help me with this Question.
Thank you in advance! :)
  1 个评论
Stephen23
Stephen23 2022-10-30
编辑：Stephen23 2022-10-30
"However, I would like "T" to be named after my first variable..."
... which forces you into writing slow, complex, inefficient, obfuscated, insecure code:
https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval
"...so it does not get overwritten when I change "Nr"."
The standard simple and efficient approach is to use indexing. You should use indexing too.
https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

请先登录，再进行评论。

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

采纳的回答

Jan
Jan 2022-10-26
Creating names of variables dynamically is one of the question, asked most frequently by beginners in this forum. The experts give always the same answer: Don't do this. See: TUTORIAL: Why and how to avoid Eval .
Do not store useful information in the name of the variable, but as data. This makes it easy to use this information later on. Solutions:
T.Data = readtable('BSA_Daten_Test.xlsx',opts,'sheet',Nr)
T.Patient = Nr;
Sometimes dynamic field names help also, but this makes it harder to procerss the data usually:
T.(Nr) = readtable('BSA_Daten_Test.xlsx',opts,'sheet',Nr)
The above methods allows you to create arrays:
T(1).Data = readtable('BSA_Daten_Test.xlsx',opts,'sheet',Nr)
T(1).Patient = Nr;
T(2).Data = readtable('BSA_Daten_Test.xlsx',opts,'sheet', anotherNr)
T(2).Patient = anotherNr;
This is an advantage when processing a group of patient: You can simply run a loop over all data, which works in genereal without knowing the list of names in advance. This is not possible, if the data are kept in variables called PPMI002i, PPMI003i, PPMI004r, ...
  3 个评论
显示 1更早的评论
Matt J
Matt J 2022-10-26
编辑：Matt J 2022-10-26
For example,
for i = 1:8
T{i} = readtable('BSA_Daten_Test.xlsx',opts,'sheet',i);
end

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by