calculate data based on previous values and replace it at negative and zeros values
显示 更早的评论
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 个评论
Image Analyst
2018-7-4
编辑：Image Analyst
2018-7-4
Not the average of the data on each side of the bad data? Just on the previous side? OK, but average how many on the previous side only? This is easy to do with conv() and logical indexing, so just try it. Even easier if you have the Image Processing Toolbox. Let me know if you can't figure it out.
KSSV
2018-7-4
Your data has negative values in the first index also i.e 1:17 values are negative..with what you want to replace them?
MUKESH KUMAR
2018-7-4
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
[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') ;
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
2018-7-4
2018-7-4
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
