Looking for help to Interpolate a column of data in a timeseries data set

I have been doing a pressure experiemnt on a CAARC building model that has resulted in a rather large data set.

Unfortunately one of my pressure taps ended up breaking on the model in a position that was rediculously hard to get to, and as such the data from that point was rendered useless.

The model has 240 pressure taps so its not the end of the world, though im hoping that there is a way for me to interpolate the the pressure at that point on the model from the surrounding taps.

Unfortunately the files are ~ 29mb so as such I cannot upload them so I have put them on google docs.

https://drive.google.com/drive/folders/11f0JbAAxPEX2doo-X3eZ4uwt-KTNzcUi?usp=sharing

I am looking to interpolate pressure tap 105 which sits in column 106 in the data sets as can be seen in the attached screenshot, I have also atached a diagram of the pressure tap locations and the distances between the pressure tap locations

Z_PreTap=fliplr([90:90:810,855]); % Heights of each level of pressure tubes

X_PreTap_side=[15,30:30:120]; % Streamwise coordinates of pressure tubes on side faces

If anyone can help I would be incredibly appreciative.

Answer 1

[darova]

I uploaded your data and tried to visualize it

% first column - time
Z = data{:,2:end};
Z1 = Z(1:600:end,1:3:end);                    % reduce data a bit 
[X,Y] = meshgrid(1:size(Z1,2),1:size(Z1,1));
surf(X,Y,Z1);

I see this

What needs to be interpolated?

[Imran Joseph]

So, what the data shows is the pressure experienced by the building over as can be seen in the attached image.

As mentioned in the post, the tap that produced the data for column PR106 broke during testing. And as such you can see the white pressure visual in the Image on the Left face.

I need a way to interpolate the potential data on that column.

In the attachments on the original post, tap 105 (~:106) sits between tap 100 (~:101)and 110 (~:111) and to the right of tap 104 (~:105).

How would I interpolate column data from those 3 points to get useful data on tap 105.

[darova]

This what i get from data you attached

[Imran Joseph]

Thanks for trying to help Daravo, though I think you have missed what im trying to do.

As per the Tap locations I want to be able to potentialy do the following.

1. Delete the current data for PR105 (~:106)
2. Use the Data from the surrounding highlighted locations to interpolate the new data (not sure if griddedinterpolant() or interp2 would be better)
3. Replace the New data into PR105 (~:106)

The Taps are 90mm apart from eachother in height and 30mm apart in width though not sure if that helps make it easier.

[darova]

What about griddata()?

[Imran Joseph]

Thank you so much darova, you are an absolute life saver.

Turns out the peice of code that helped the most was the Z0(5,5) = nan;

It made all of the difference by getting matlab to just ignore the column. I had no idea that that was possible.