I have two matrices. Column 1 of Matrix A and Column 2 of Matrix B both correspond to time (seconds).
Matrix a= [34.2 2; 34.5 4; 34.7 1; 35.0 3; 35.2 2; 35.6 4; 35.7 1; 35.9 3]
Matrix b= [0.2 34.2; 0.1 34.3; 0.3 34.3; 0.1 34.4; 0.6 34.5;0.2 34.6; 0.1 34.7; 0.4 34.8; 0.8 34.9; 0.6 35.0; 0.3 35.1; 0.2 35.2; 0.4 35.3; 0.6 35.3; 0.1 35.4; 0.7 35.5;0.2 35.6; 0.2 35.7; 0.8 35.8; 0.7 35.9; 0.8 36.0]
I want to extract certain rows of Matrix B based on Matrix A. In general I want to extract only between the times where Matrix A column 2 have the values 2 and 4. Value 2 indicates the time I want to begin extracting from Matrix B and the value for indicates the last time I want to extract from Matrix B. In the end I want something like this.
Matrix c= [0.2 34.2; 0.1 34.3; 0.3 34.3; 0.1 34.4; 0.6 34.5;0.2 35.2; 0.4 35.3; 0.6 35.3; 0.1 35.4; 0.7 35.5;0.2 35.6] *Here we only extracted from 34.2s to 34.5s & 35.2s to 35.6s
Can someone help me create a code to do this. Any help would be much appreciated.
