Overwrite table data with 'Yes' or 'No' according to the logical index

1 vue (au cours des 30 derniers jours)
Smithy
Smithy le 1 Sep 2022
Commenté : Stephen23 le 2 Sep 2022
Hello everybody,
I would like to overwrite the table data if the logical index of row is true.
Logical index will be True if sampleinput.TEST_ITEM1 is'TV'
In case of True, the sampleinput.TEST_LOAD1 need to be changed with 'Yes'.
and False, the sampleinput.TEST_LOAD1 need to be changed with 'No'.
Please give me some help.
load sample1
idx = sampleinput.TEST_ITEM1 == "TV";
sampleinput.TEST_LOAD1(idx) = 'Yes';
idx = sampleinput.TEST_ITEM1 ~= "TV";
sampleinput.TEST_LOAD1(idx) = 'No';

Réponse acceptée

Abderrahim. B
Abderrahim. B le 1 Sep 2022
Hi!
Maybe this:
load sample1.mat
sampleinputarr = string(sampleinput.Variables) ;
tvIdx = sampleinputarr(:,1) == "TV" ;
sampleinputarr(tvIdx, 2) = "Yes" ;
sampleinputarr(~tvIdx, 2) = "No" ;
newTbl = array2table(sampleinputarr, "VariableNames", sampleinput.Properties.VariableNames )
newTbl = 11×2 table
TEST_ITEM1 TEST_LOAD1 __________ __________ "TV" "Yes" "TV" "Yes" "TV" "Yes" "TT" "No" "TV" "Yes" "TV" "Yes" "TV" "Yes" "TV" "Yes" "TL" "No" "TL" "No" "TL" "No"
Hope this helps
  2 commentaires
Smithy
Smithy le 1 Sep 2022
Thank you very mcuh. it works really well.
Abderrahim. B
Abderrahim. B le 1 Sep 2022
My pleasure!

Connectez-vous pour commenter.

Plus de réponses (1)

Stephen23
Stephen23 le 1 Sep 2022
Modifié(e) : Stephen23 le 1 Sep 2022
Simpler:
S = load('sample1.mat');
T = S.sampleinput
T = 11×2 table
TEST_ITEM1 TEST_LOAD1 __________ __________ {'TV'} {'NaN'} {'TV'} {'NaN'} {'TV'} {'NaN'} {'TT'} {'NaN'} {'TV'} {'NaN'} {'TV'} {'NaN'} {'TV'} {'NaN'} {'TV'} {'NaN'} {'TL'} {'NaN'} {'TL'} {'NaN'} {'TL'} {'NaN'}
X = strcmpi(T.TEST_ITEM1,'TV');
T.TEST_LOAD1(:) = {'No'};
T.TEST_LOAD1(X) = {'Yes'}
T = 11×2 table
TEST_ITEM1 TEST_LOAD1 __________ __________ {'TV'} {'Yes'} {'TV'} {'Yes'} {'TV'} {'Yes'} {'TT'} {'No' } {'TV'} {'Yes'} {'TV'} {'Yes'} {'TV'} {'Yes'} {'TV'} {'Yes'} {'TL'} {'No' } {'TL'} {'No' } {'TL'} {'No' }
  2 commentaires
Smithy
Smithy le 2 Sep 2022
Thank you very much for your answer. It is really good
Stephen23
Stephen23 le 2 Sep 2022
@Smithy: remember that you can vote for my answer if you liked it!

Connectez-vous pour commenter.

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Tags

Produits


Version

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by