Overwrite table data with 'Yes' or 'No' according to the logical index
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Smithy
el 1 de Sept. de 2022
Comentada: Stephen23
el 2 de Sept. de 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';
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1113580/image.png)
0 comentarios
Respuesta aceptada
Abderrahim. B
el 1 de Sept. de 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 )
Hope this helps
2 comentarios
Ver también
Categorías
Más información sobre Get Started with MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!