How do you get rid of the VariableNamingRule warning when you do want it set to modify ?
133 ビュー (過去 30 日間)
古いコメントを表示
Hi, I have the following code:
opts = detectImportOptions(fullfile(file_B_path, file_B_name)); % Detects import of table
opts = setvartype(opts, 'ID', 'string'); % Sets ID to string datatype
opts = setvartype(opts, 'RvCCompliance', 'string'); % Sets RvC Compliance to string datatype
---> opts.VariableNamingRule = 'modify';
file_B = readtable(fullfile(file_B_path, file_B_name),opts); % Imports table
and I keep getting the following warning:
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before
creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
I know that variablenamingrule is set to modify, in fact, I want it to be set to modify. Why wont adding the line with the pointer get rid of this messege ?
0 件のコメント
採用された回答
dpb
2023 年 6 月 16 日
It's annoying to be constantly nagged, agreed. But, setting it explicitly doesn't affect whether it is generated or not as you've discovered.
But, while a pain to have to do every time use readtable, it's relatively simple to fix...
opts = detectImportOptions(fullfile(file_B_path, file_B_name)); % Detects import of table
opts = setvartype(opts, 'ID', 'string'); % Sets ID to string datatype
opts = setvartype(opts, 'RvCCompliance', 'string'); % Sets RvC Compliance to string datatype
w=warning('off','MATLAB:table:ModifiedAndSavedVarnames'); % turn off annoying warning, save state
file_B = readtable(fullfile(file_B_path, file_B_name),opts); % Imports table
warning(w); % reset warning level
Since 'modify' is the default state for the name preservation property, it doesn't need to be set in the options struct and makes no difference if it is (as you've seen).
3 件のコメント
Peter Perkins
2023 年 7 月 17 日
Santiago, this warning is a known issue that is left over from the days before VariableNamingRule. For now, the work-around is what dpb suggests.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Characters and Strings についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!