MATLAB Answers

How to check whether a column exist in a table?

576 ビュー (過去 30 日間)
Alon Rozen
Alon Rozen 2016 年 11 月 24 日
コメント済み: AusPollen 2021 年 5 月 23 日
Hi all,
I search for this question in the web and found the following solution: Suppose I have a table named 'My_Table' and want to check if it contains a column (field) named 'My_Column'. The code:
Exist_Column = strmatch('My_Column',My_Table.Properties.VariableNames)
should result in logical that answer the question. I checked it and it works. However, the Matlab editor commented that 'strmatch' is not a recommended function to use because it is about to be removed in future version and suggest instead the use of either 'strncmp' or 'validatestring'. Problem is that both do not return a logical and more steps are required to get the answer.
So, my question is: what is the simplest recommended way to determine if a certain column name exist in a table?
Thanks,
Alon
  1 件のコメント
Carlos Aguilar
Carlos Aguilar 2017 年 12 月 31 日
Just came across to this question. An anonymous function will also do the job (and will be reusable within the scope):
isTableCol = @(t, thisCol) ismember(thisCol, t.Properties.VariableNames);

サインインしてコメントする。

採用された回答

KSSV
KSSV 2016 年 11 月 24 日
Exist_Column = strcmp('My_Column',My_Table.Properties.VariableNames)
val = Exist_Column(Exist_Column==1) ;
  5 件のコメント
Gabriel Blanco
Gabriel Blanco 2019 年 6 月 25 日
Bonjour Nic!

サインインしてコメントする。

その他の回答 (1 件)

jkr
jkr 2019 年 5 月 14 日
sum(ismember(mx.Properties.VariableNames,'NameYouWantToCheck'))
returns 1 if found, 0 if not
  1 件のコメント
AusPollen
AusPollen 2021 年 5 月 23 日
Nice! although you don't need to sum if you switch the ismember arguments, ie. use ismember('My_Column',My_Table.Properties.VariableNames)

サインインしてコメントする。

製品

Community Treasure Hunt

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

Start Hunting!

Translated by