Finding Corresponding Data at Events

I have a matrix with data in one column and corresponding time intervals in the next column. Another matrix has event times. I am wanting to get the data from the first matrix that corresponds to the event time. I feel like this is simple, but I am having issues choosing the right way to go about this. The data is continuous so I want to make sure that I am getting a good approximation of the data when event times are between intervals.

4 comentarios

per isakson
per isakson el 2 de Abr. de 2016
Editada: per isakson el 2 de Abr. de 2016
How is "the event time" related to "time intervals" ? Show smalls samples of the two matricies.
Muhammad Usman Saleem
Muhammad Usman Saleem el 2 de Abr. de 2016
please post your both matrix?
Krispy Scripts
Krispy Scripts el 4 de Abr. de 2016
In first column of matrix1 is frequency data and in the second column is regular intervals of time that correspond to the frequency data. Matrix2 is time points of events that correspond to the time from matrix1. I want to take the frequency data points from matrix1 based on the events that are happening in matrix2.
Krispy Scripts
Krispy Scripts el 4 de Abr. de 2016
The time stamps in column 2 of matrix1 and event times in matrix2 are directly related

Iniciar sesión para comentar.

 Respuesta aceptada

Star Strider
Star Strider el 5 de Abr. de 2016
There are only three rows that exactly correspond:
D1 = load('Heath Robinson Matrix1.mat');
D2 = load('Heath Robinson Matrix2.mat');
M1 = D1.Matrix1;
M2 = D2.matrix2;
[CommonTimes, ia, ib] = intersect(M1(:,2),M2);
DesiredResult = M1(ia,:)
DesiredResult =
0.0027084 0.045775
-0.083389 0.23977
0.051537 0.25477

4 comentarios

Krispy Scripts
Krispy Scripts el 5 de Abr. de 2016
I am looking to take data points from matrix1 for every event happening in matrix2. So its a continuous data set and I need the corresponding data point in matrix1 based on matrix2 time events
Star Strider
Star Strider el 5 de Abr. de 2016
Those in my Answer are the only ones that exactly correspond, since that is what you stated you wanted in your Question.
If you have different criteria, you need to state them specifically in terms that are possible to code. We can’t guess what you’re thinking.
Krispy Scripts
Krispy Scripts el 6 de Abr. de 2016
My apologies, I did not ask correctly. I accepted this as an answer because you did what I asked.
Would you mind taking a look at this question again that I posted here:
My apologies again and thank you for the help you already gave.
Star Strider
Star Strider el 6 de Abr. de 2016
My pleasure.
I left a Comment requesting further clarification, since it’s still not clear to me.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Preguntada:

el 2 de Abr. de 2016

Comentada:

el 6 de Abr. de 2016

Community Treasure Hunt

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

Start Hunting!

Translated by