清空筛选条件
清空筛选条件

replace values in an array based on previous values

3 次查看（过去 30 天）
Vanessa
Vanessa 2017-7-27
评论： Vanessa 2017-7-27
Hello everyone!!
I have a dataset with two columns.
  1. TEL_TYPE which take values 'P','A','D','N'
  2. PORT_FLAG which take values 'N','S'.
I have the below sequence which being repeated (not with steady number of 'P' in the middle)
TEL_TYPE : A P P P P D
PORT_FLAG : N N N S N N
I want to find when the PORT_FLAG='S' and then the PORT_FLAG where TEL_TYPE='D' to have the value 'S' so in the above example the result will be:
TEL_TYPE : A P P P P D
PORT_FLAG : N N N S N s
How can I achieve this? Thank you!
Vanessa
  1 个评论
Adam
Adam 2017-7-27
What is the purpose of finding the PORT_FLAG == 'S'? Are there occurrences of 'D' in TEL_TYPE that you don't want to change PORT_FLAG to 'S' for?

请先登录，再进行评论。

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

回答（1 个）

Image Analyst
Image Analyst 2017-7-27
Here's one way, assuming they're character arrays:
TEL_TYPE = ['A' 'P' 'P' 'P' 'P' 'D' 'P' 'D' 'P' 'P']
PORT_FLAG = ['N' 'N' 'N' 'S' 'N' 'N' 'S' 'N' 'N' 'S']
% Find 'S's
sLocations = find(PORT_FLAG == 'S')
for k = 1 : length(sLocations)
index = sLocations(k);
firstDLocation = index + find(TEL_TYPE(index:end) == 'D', 1, 'first') - 1
if ~isempty(firstDLocation)
PORT_FLAG(firstDLocation) = 's'
end
end
PORT_FLAG % Display in command window.
Note I lengthened the arrays to make sure it worked for not only the first instance of S.

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by