Change value based on the values of another column

38 次查看(过去 30 天)
I have a table with 2 columns and 6000 rows each. Sample values in the 1st column is like:
-0.00554
-0.00503
-0.00406
-0.00406
-0.00316
-0.00274
-0.00274
0
0
0
0
0
0
0.00233
0.00452
0.00552
0.00715
0.00831
0
0
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
0
0
0
0.00552
0.00715
0.00831
0.00715
0.00831
0
0
0
0
0
-0.00406
-0.00316
The corresponding values in the 2nd column will be starting from 1,2,3, etc. until the positive value changes again to negative value in the 1st column. To be more specific, 1st column will be having values starting with -ve sign followed by 0s and +ve values. So, the -ve value will be changing to +ve and again back to -ve. Once the -ve value show up again, the count on the 2nd column should start from 1 again. Please help me wih this.

采纳的回答

Star Strider
Star Strider 2022-8-5
Another approach —
v = [-0.00554
-0.00503
-0.00406
-0.00406
-0.00316
-0.00274
-0.00274
0
0
0
0
0
0
0.00233
0.00452
0.00552
0.00715
0.00831
0
0
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
0
0
0
0.00552
0.00715
0.00831
0.00715
0.00831
0
0
0
0
0
-0.00406
-0.00316];
sv = sign(v);
sv(sv>=0) = 1; % Adjust 'sign' Vector
pn = [0 strfind(sv.', [1 -1]) numel(v)]; % +vn To -ve Transition Indices
for k = 1:numel(pn)-1
idx = [pn(k) pn(k+1)-1]+1; % Index Range
Col2(idx(1):idx(2)) = (idx(1) : idx(2)) - (idx(1)-1); % Create Column #2 (As Row Vector)
end
Result = [v, Col2(:)] % Full Matrix
Result = 42×2
-0.0055 1.0000 -0.0050 2.0000 -0.0041 3.0000 -0.0041 4.0000 -0.0032 5.0000 -0.0027 6.0000 -0.0027 7.0000 0 8.0000 0 9.0000 0 10.0000
ResultMtx = [Result(1:10,:) Result(11:20,:) Result(21:30,:) Result(31:40,:)] % Display (Remove Later)
ResultMtx = 10×8
-0.0055 1.0000 0 11.0000 -0.0001 1.0000 0.0055 11.0000 -0.0050 2.0000 0 12.0000 -0.0001 2.0000 0.0072 12.0000 -0.0041 3.0000 0 13.0000 -0.0001 3.0000 0.0083 13.0000 -0.0041 4.0000 0.0023 14.0000 -0.0001 4.0000 0.0072 14.0000 -0.0032 5.0000 0.0045 15.0000 -0.0001 5.0000 0.0083 15.0000 -0.0027 6.0000 0.0055 16.0000 -0.0001 6.0000 0 16.0000 -0.0027 7.0000 0.0072 17.0000 -0.0001 7.0000 0 17.0000 0 8.0000 0.0083 18.0000 0 8.0000 0 18.0000 0 9.0000 0 19.0000 0 9.0000 0 19.0000 0 10.0000 0 20.0000 0 10.0000 0 20.0000
ResultEnd = Result(41:end,:) % Display (Remove Later)
ResultEnd = 2×2
-0.0041 1.0000 -0.0032 2.0000
.
  10 个评论
Krishna
Krishna 2022-8-8
编辑:Krishna 2022-8-8
@Star Strider Consider this as my table. The previous one was wrong. Sorry. The relationship between input2 and output is, when input2 value changes to a -ve from +ve value within the subset, output will again count from 0. The difference is found from input1 alone.
Input1 input2 Output
1 -0.0103 0
3 -0.0105 2
5 -0.0091 4
7 -0.0082 6
10 -0.0073 9
11 -0.0059 10
15 -0.0054 14
20 -0.0027 19
21 0 20
22 0 21
23 0 22
24 0 23
25 -0.0059 24
26 -0.0054 25
27 -0.002723 26
35 0 34
36 0.0023 35
38 0.0068 37
40 0.0100 39
41 0 40
42 -0.0030 0
43 -0.0026 1
44 -0.0062 2
......
Star Strider
Star Strider 2022-8-8
The values for ‘Input1’ are different, and I do not understand how either it or ‘Output’ are incremented.
I just do not see any sort of pattern here that lends itself to being coded.

请先登录,再进行评论。

更多回答(2 个)

dpb
dpb 2022-8-5
编辑:dpb 2022-8-5
If there's always at least one zero before the new -ive value excepting the initial element, then
ix=find(diff(sign([0;x]))==-1);
will locate the beginng line of each section.
Or, actually, on reflection,
ix=find(diff(sign([0;x]))<0);
will find a transition from either 0 to -ive or +ive to -ive
  2 个评论
Krishna
Krishna 2022-8-5
There is no 0 at some cases. new -ve value is also present immediately after a +ve value.
Krishna
Krishna 2022-8-5
I'm running this code inside a loop as depicted below:
for k = 1:rows
ix = find(diff(table.first_column([0;k]))<0);
if(ix < 0)
table.second_column(k) = 1;
end
end
But, while running this code, I'm getting an error like:
"Array indices must be positive integers or logical values."

请先登录,再进行评论。


Andrei Bobrov
Andrei Bobrov 2022-8-5
v = [-0.00554
-0.00503
-0.00406
-0.00406
-0.00316
-0.00274
-0.00274
0
0
0
0
0
0
0.00233
0.00452
0.00552
0.00715
0.00831
0
0
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
-9.00000000000000e-05
0
0
0
0.00552
0.00715
0.00831
0.00715
0.00831
0
0
0
0
0
-0.00406
-0.00316];
s = sign(v);
p = diff([0;s]) == -1 & s == -1;
i = accumarray(cumsum(p),1);
x = ones(size(p));
x(p) = x(p) - [ 0;i(1:end-1)];
out = cumsum(x);

类别

Help CenterFile Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by