How do I find a single value by corresponding data in 2 different tables?
4 views (last 30 days)
So I have a MATLAB code in which I have a row vector of 1x25 obtained through experiments. The data in this vector is a normalised signal from 1 to 0, for different timesteps starting from 5ns to 235ns, and increasing in timesteps of 10. I have another table of 226x15 obtained through a model, in which there are 226 timesteps with an increment of 1 and the 15 corresponds to the sizes of diameters, starting from 10nm and increasing in steps of 10. The values in this table are also of normalised signals.
The task I have at hand is to link the values of normalised signal in the 1x25 vector with the values of the signals in the 226x15 double for a given timestep and find out to which values of diameters do the normalised values in the 1x25 correspond the most. Through this I have to find a single value of diameter which says that this diameter was more prevalent for a particular signal.
How do I approach this task?
Eric Sofen on 17 Mar 2022
It sounds like you are trying to align these two things based on time? If so, check out the synchronize method of timetable. There are a bunch of different synchronization options, but it sounds like the 'nearest' method will do the trick.