calculate data based on previous values and replace it at negative and zeros values

3 次查看（过去 30 天）

MUKESH KUMAR 2018-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408672-calculate-data-based-on-previous-values-and-replace-it-at-negative-and-zeros-values

评论： MUKESH KUMAR 2018-7-4

sample.xls

there is different data in the column in excel (REACTIVE_Y_PH), which has some negative and zeros values also, these values should be replaced by calculating the average of previous data and replace them.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Image Analyst 2018-7-4

What were the "last" 5 values when the first few are to be replaced? There are no elements at indexes -4 to 0. Or did you mean the "last" ones at the other end of the array, like from vec(end-4:end)?

MUKESH KUMAR 2018-7-4

编辑：MUKESH KUMAR 2018-7-4

No, previous values of the column before that value, Like in the image, first 15 values in the second column are negative so make them positive and at 16th row '0' that will be replaced by previous 5 values average((11.5+9.2+9.2+6.9+4.6)/5).Similarly do for next values

请先登录，再进行评论。

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

回答（1 个）

KSSV 2018-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408672-calculate-data-based-on-previous-values-and-replace-it-at-negative-and-zeros-values#answer_327395

在 MATLAB Online 中打开

[num,txt,raw] = xlsread('sample.xls') ;
data = cell2mat(cellfun(@str2num,txt(:,2),'un',0)) ;
%%fill negative and zeros 
idx = data<=0 ;
data(idx) = NaN ;
data = fillmissing(data,'previous') ;