How to replace a string with another string in specific table columns

Question

012786534 2019-10-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/487900-how-to-replace-a-string-with-another-string-in-specific-table-columns

编辑： Guillaume 2019-10-28

Hello,

Im trying to replace all [] with '-99' only in the columns that begin with Q_ in the table t below. How would I do that with an index ? Its important that I dont use the variables names.

% data
Q_x = {'1'; '[]'; '3'};
a = {'A'; 'B'; 'C'};
o = {'A'; '[]'; 'C'};
Q_y = {'1'; '[]'; '3'};
t = table(Q_x, a, o, Q_y)
all_vars = t.Properties.VariableNames;
index = find(strncmp(all_vars, 'Q_', 2));

Thank you,

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Daniel M 2019-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/487900-how-to-replace-a-string-with-another-string-in-specific-table-columns#answer_398600

在 MATLAB Online 中打开

t{:,index} = regexprep(t{:,index},'\[\]','-99')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Guillaume 2019-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/487900-how-to-replace-a-string-with-another-string-in-specific-table-columns#answer_398599

编辑：Guillaume 2019-10-28

在 MATLAB Online 中打开

One easy way:

missinglocs = ismissing(t, '[]'); 
newt = fillmissing(t, 'constant', '-99', 'DataVariables', startsWith(t.Properties.VariableNames, 'Q_'), 'MissingLocations', missinglocs)