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

2 vues (au cours des 30 derniers jours)
MUKESH KUMAR le 4 Juil 2018
Commenté : MUKESH KUMAR le 4 Juil 2018
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 commentaires
MUKESH KUMAR le 4 Juil 2018
Modifié(e) : MUKESH KUMAR le 4 Juil 2018
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

Connectez-vous pour commenter.

Réponses (1)

KSSV le 4 Juil 2018
[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') ;
  1 commentaire
MUKESH KUMAR le 4 Juil 2018
please consider my last comment also,thanks for your support

Connectez-vous pour commenter.


En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by