# Interpolate among Datasets so one set matches the other

42 visualizzazioni (ultimi 30 giorni)
Stelios Fanourakis il 29 Ott 2019
Commentato: Image Analyst il 26 Lug 2020
Hi
I have two datasets with different dimensions. Needs to be matched somehow and one dimension needs to be interpolated to fit the dimension of the second data set
My first dataset is X,Y (2D) and my second dataset is only Y (1D). I need to somehow combine those two datasets. Like trying to plug in the Y axis data from the second dataset to the first set which is 2D. So, the X axis from the first set will be interpolated to match the data of the new Y axis data (second set). Am I clear?
##### 2 CommentiMostra NessunoNascondi Nessuno
the cyclist il 29 Ott 2019
When you say "datasets" do you mean the actual MATLAB dataset variable type? If not, how are your data stored? Can you upload a MAT file with the actual data (or a small, representative sample)?
Stelios Fanourakis il 30 Ott 2019
Datasets are two different excel files. Both they have the same X axis but are changed in Y axis. I want to plug in the Y values of the second set to the first one and interpolate. E.g. if the Y values are in Newtons and there are thickness changes of a material vertically (compressive forces) for every X there is a Y value (Newton) caused the deformation or the change in thickness (shape). For different Y values (second set of excel data), needs to interpolate the appropriate forces.

Accedi per commentare.

### Risposte (2)

the cyclist il 30 Ott 2019
% Data from your file that has both x and y
x1 = [2 3 5];
y1 = [1 2 3];
% Data from your file that has only y
y2 = [1.5 2.5];
% Interpolate the set of x data in based on the above.
x2 = interp1(y1,x1,y2)
Here is a simple example using the interp1 function. I'm not certain if this is what you mean.
If you look at that documentation page, note that the use of "x" and "y" variables are swapped compared to what is written here, because the normal convention is that y is dependent on x, but that is not what you have described in your question.
If this doesn't do what you want, or if it is unclear, then I suggest you actually load your data from Excel into MATLAB, save to a *.mat file, and upload those data here.
##### 9 CommentiMostra 7 commenti meno recentiNascondi 7 commenti meno recenti
MOHD UWAIS il 21 Lug 2020
if x1 = [-3 -2 -1 0 1 2 3 4];
y1 = [9 4 1 0 1 4 9 16];
y2 = [8];
how we can calculate "x2 = interp1(y1,x1,y2)".
i.e. here we will get two values of x1 correspond to single value of y2. pls explain to it.
thanks
the cyclist il 21 Lug 2020
You should really open a new question, rather than burying this as a comment on an 8-month-old question.
But, since I happened to see it ...
You'll need to separate your problem into two different "branches" of y, because the sample points must be unique. So, you'll need to do one interpolation with, for example, the values of y>=0, and another with y<0.

Accedi per commentare.

MOHD UWAIS il 26 Lug 2020
Actually my problem is to find the fwhm(s) of large number of curve like following. So i require the interpolation values of x corresponding to average y values to write the code (because x values do not lie exactly y data points in average of y) . There are exist two values of x correspondinfg to single average value of y in a one curve (therfore sample point is not unique).
i looking forwrd.
Thank YOU.
##### 1 CommentoMostra -1 commenti meno recentiNascondi -1 commenti meno recenti
Image Analyst il 26 Lug 2020
but you still posted your question here, as an answer to Stelios's question. Why?
We look forward to answering your question when you post it as your own question, not here in Stelios's thread. In the meantime, check out the find() function, like index=find(signal < threshold).

Accedi per commentare.

### Categorie

Scopri di più su Interpolation in Help Center e File Exchange

### Community Treasure Hunt

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

Start Hunting!

Translated by