I need to fill a column data with a specific value

2021 3 1
1 个回答
回答已采纳
更新时间：2021 3 2
2 次查看（30 天）

0 个投票

I have data set
X=[1:1100];
first I need to make this one 'nan', then need to fill this data set with a specific values
A B
830 4.992
839 5.009
845 5.02
784 4.886
753 4.832
750 4.827
676 4.755
666 4.752
720 4.792
868 5.078
856 5.041
776 4.865
569 4.773
609 4.742
625 4.755
% so here A is the position in data line 1:1100, I need to fill above data set (X) with accordingly with (B=Sea level)

请先登录，再回答此问题。

 采纳的回答

KSSV
KSSV 2021-3-1

1 个投票

Let data be your m*2 data.
x = data(:,1) ;
y = data(:,2) ;
y0 = y ;
% idx = A your indices which should be nan
y(idx) = NaN ;
x(idx) = [] ;
% use interp1 to get the NaN values
y(idx) = interp1(x(~idx),y(~idx),x(idx))
% plot
plot(x,y0,'r',x,y,'b')
legend('original','interpolated')
Also have a look on fillmissing.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Thank you very much for your kind answer. But its not clear to me.
I have a data set tide= [1100,2] =(number, tide) , number is from 1 to 1100.
I just need to extract some specific tide values according to the number positon like (what is tide at
601 626 652 681 711 742 991 1036 601 616 631 647 781 796 811 ) from this data set, and then the rest of the data shoul be nan.
then the final out put also should have the same size like A, but only perticular tide values and rest with nan.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by