Overwrite table data if the logical index of row is true.

1 次查看（过去 30 天）
Smithy
Smithy 2022-8-26
评论： Smithy 2022-8-26
Hello everybody,
I would like to overwrite the table data if the logical index of row is true.
Logical index will be ture if sampleinput.TEST_ITEM1 is'TV'
Then, the sampleinput.TEST_LOAD1 need to be changed with sampleinput.TEST_LOAD0
If sampleinput.TEST_ITEM1 is not 'TV' and then keep sampleinput.TEST_LOAD1 data.
Please give me some help.
load sample
k = contains(sampleinput.TEST_ITEM1,'TV'); % logical indexing
sampleinput.TEST_LOAD1(k) = sampleinput.TEST_LOAD0(k);

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

采纳的回答

Chunru
Chunru 2022-8-26
Ran in:
load(websave("sample.mat", "https://www.mathworks.com/matlabcentral/answers/uploaded_files/1108480/sample.mat"))
sampleinput
sampleinput = 11×3 table
TEST_ITEM1 TEST_LOAD0 TEST_LOAD1 __________ __________ __________ {'TV'} 110 {'355'} {'TV'} 550 {'355'} {'TV'} 220 {'355'} {'TT'} 660 {'355'} {'TV'} 330 {'355'} {'TV'} 770 {'355'} {'TV'} 440 {'355'} {'TV'} 880 {'355'} {'TL'} NaN {'355'} {'TL'} NaN {'355'} {'TL'} NaN {'355'}
idx = sampleinput.TEST_ITEM1 == "TV";
sampleinput.TEST_LOAD1(idx) = cellstr(string(sampleinput.TEST_LOAD0(idx)))
sampleinput = 11×3 table
TEST_ITEM1 TEST_LOAD0 TEST_LOAD1 __________ __________ __________ {'TV'} 110 {'110'} {'TV'} 550 {'550'} {'TV'} 220 {'220'} {'TT'} 660 {'355'} {'TV'} 330 {'330'} {'TV'} 770 {'770'} {'TV'} 440 {'440'} {'TV'} 880 {'880'} {'TL'} NaN {'355'} {'TL'} NaN {'355'} {'TL'} NaN {'355'}

更多回答（0 个）

类别

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

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by