How to count count number of times change occured

1 Ansicht (letzte 30 Tage)
Mekala balaji
Mekala balaji am 23 Nov. 2017
Bearbeitet: Mekala balaji am 27 Nov. 2017
Hi,
I have below time series data:
Time(sec) V1 V2
1 0 1
2 0 1
3 1 1
4 1 1
5 1 1
6 2 0
7 2 0
8 0 0
9 0 1
10 0 1
11 0 0
12 0 0
13 0 0
14 0 1
15 0 1
16 0 1
17 0 1
18 0 1
19 0 0
20 0 0
Chage count:
when a variable current row value is different from previous row value, then count as 1 for a particular variable, and delta in the corresponding row. For example:
For variale1(V1):Compare the data in row3(in V1 column) is different from row2, I count it as 1 in row1 under V1 column and take the delta of (row3 &row2 values for V1 column, 1-0=1), same as row 6 value is different from row5,then count it as 2(under change count), and delta is (2-1)=1, so on~
Desired Output:
Time V1(change count) V1 (Delta) V2(change Count) V2 (Delta)
1
2
3 1 1
4
5
6 2 1 1 -1
7
8 3 -2
9 2 1
10
11 3 -1
12
13
14 4 1
15
16
17
18
19 5 -1
20
Many thanks in advance~

Antworten (1)

Adam
Adam am 23 Nov. 2017
Bearbeitet: Adam am 23 Nov. 2017
v1 = [0 0 1 1 1 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0]';
v1Delta = [0; diff( v1 )];
v1ChangeCount = v1Delta;
v1ChangeCount( v1Delta ~= 0 ) = 1:nnz( v1Delta );
I don't know what kind of structure your data is in, but that at least calculates the answer for e.g. v1 with 0s where there is no other number since you can't have empty space in a vector. You can replace them with Nans if you prefer.
  1 Kommentar
Mekala balaji
Mekala balaji am 27 Nov. 2017
Bearbeitet: Mekala balaji am 27 Nov. 2017
My data is array(double), because each data point is one second, I want to note after each change occurred how long the data is constant before next change occured. For example: In the above example you illustrated, the first change occured in 3rd row(at 3 seconds) and I want to know how many seconds before next chaged occured(next change here occured in 6th row) 6th second, and the data constant is for 3seconds(row3~row5), and so on for all the changes,

Melden Sie sich an, um zu kommentieren.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by