Постановка задачи.

Имеется 80 моторов, каждый из которых живет определенное число циклов. Каждый цикл происходит снятие информации с датчиков S1 – S21 и происходит переустановка настроечных параметров Setting1 – Setting2.

Необходимо:

Провести анализ предоставленных данных по 80 моторам (файл Data_80.csv). Сделать предположение о выходе из строя мотора на основании имеющихся данных датчиков. Далее на основании дополнительно предоставленных данных по 20 моторам (файл Data_Add_20.csv) сделать предположения о выходе мотора из строя на следующем цикле.


train <- read.csv("D:/Dropbox/work/test1/Data_80.csv", sep=";", dec=',')
         id            cycle             s1             s10           s11             s12       
 Engine_69:  362   Min.   :  1.0   Min.   :518.7   Min.   :1.3   Min.   :46.86   Min.   :518.7  
 Engine_67:  313   1st Qu.: 51.0   1st Qu.:518.7   1st Qu.:1.3   1st Qu.:47.35   1st Qu.:520.9  
 Engine_2 :  287   Median :101.0   Median :518.7   Median :1.3   Median :47.52   Median :521.5  
 Engine_64:  283   Mean   :105.5   Mean   :518.7   Mean   :1.3   Mean   :47.54   Mean   :521.4  
 Engine_17:  276   3rd Qu.:153.0   3rd Qu.:518.7   3rd Qu.:1.3   3rd Qu.:47.71   3rd Qu.:521.9  
 Engine_56:  275   Max.   :362.0   Max.   :518.7   Max.   :1.3   Max.   :48.53   Max.   :523.4  
 (Other)  :14342                                                                                
      s13            s14            s15             s16            s17             s18      
 Min.   :2388   Min.   :8100   Min.   :8.325   Min.   :0.03   Min.   :388.0   Min.   :2388  
 1st Qu.:2388   1st Qu.:8133   1st Qu.:8.415   1st Qu.:0.03   1st Qu.:392.0   1st Qu.:2388  
 Median :2388   Median :8141   Median :8.440   Median :0.03   Median :393.0   Median :2388  
 Mean   :2388   Mean   :8144   Mean   :8.443   Mean   :0.03   Mean   :393.2   Mean   :2388  
 3rd Qu.:2388   3rd Qu.:8149   3rd Qu.:8.466   3rd Qu.:0.03   3rd Qu.:394.0   3rd Qu.:2388  
 Max.   :2389   Max.   :8294   Max.   :8.585   Max.   :0.03   Max.   :399.0   Max.   :2388  
                                                                                            
      s19            s2             s20             s21              s3             s4      
 Min.   :100   Min.   :641.2   Min.   :38.16   Min.   :22.91   Min.   :1571   Min.   :1382  
 1st Qu.:100   1st Qu.:642.3   1st Qu.:38.70   1st Qu.:23.22   1st Qu.:1586   1st Qu.:1402  
 Median :100   Median :642.6   Median :38.83   Median :23.30   Median :1590   Median :1408  
 Mean   :100   Mean   :642.7   Mean   :38.81   Mean   :23.29   Mean   :1591   Mean   :1409  
 3rd Qu.:100   3rd Qu.:643.0   3rd Qu.:38.94   3rd Qu.:23.37   3rd Qu.:1594   3rd Qu.:1415  
 Max.   :100   Max.   :644.5   Max.   :39.43   Max.   :23.61   Max.   :1615   Max.   :1441  
                                                                                            
       s5              s6              s7              s8             s9          setting1         
 Min.   :14.62   Min.   :21.60   Min.   :549.9   Min.   :2388   Min.   :9022   Min.   :-8.600e-03  
 1st Qu.:14.62   1st Qu.:21.61   1st Qu.:552.8   1st Qu.:2388   1st Qu.:9053   1st Qu.:-1.400e-03  
 Median :14.62   Median :21.61   Median :553.4   Median :2388   Median :9061   Median : 0.000e+00  
 Mean   :14.62   Mean   :21.61   Mean   :553.4   Mean   :2388   Mean   :9065   Mean   : 9.989e-06  
 3rd Qu.:14.62   3rd Qu.:21.61   3rd Qu.:554.0   3rd Qu.:2388   3rd Qu.:9070   3rd Qu.: 1.500e-03  
 Max.   :14.62   Max.   :21.61   Max.   :556.1   Max.   :2389   Max.   :9245   Max.   : 8.700e-03  
                                                                                                   
    setting2       
 Min.   :-6.0e-04  
 1st Qu.:-3.0e-04  
 Median : 0.0e+00  
 Mean   : 6.2e-08  
 3rd Qu.: 3.0e-04  
 Max.   : 6.0e-04  
                   
# independent components
train2 <- train[,c('cycle','s9','s11')]
pairs(train2)


ds <- split(train,train$id)
sp <- split(train$cycle,train$id)
s9sp <- split(train$s9,train$id)

plot(train$cycle,train$s9,pch='.')
for(i in c(1:10)) {
  lines(sp[[i]],s9sp[[i]])
}

fault_id <- unique(train$id[train$s9 > 9100])
fault_id
 [1] Engine_10 Engine_11 Engine_13 Engine_14 Engine_17 Engine_18 Engine_2  Engine_21 Engine_25 Engine_26
[11] Engine_27 Engine_3  Engine_34 Engine_35 Engine_38 Engine_4  Engine_40 Engine_41 Engine_47 Engine_48
[21] Engine_5  Engine_50 Engine_51 Engine_52 Engine_53 Engine_54 Engine_55 Engine_56 Engine_60 Engine_63
[31] Engine_64 Engine_68 Engine_70 Engine_71 Engine_79 Engine_80 Engine_9 
80 Levels: Engine_1 Engine_10 Engine_11 Engine_12 Engine_13 Engine_14 Engine_15 Engine_16 ... Engine_9
length(fault_id)
[1] 37
plot(train$cycle,train$s9,pch='.')
for(id in fault_id) {
  lines(sp[[id]],s9sp[[id]])
}


#suppose
train$fault <- 0
train$fault[train$s9 > 9100] <- 1
plot(train$cycle,train$s9,pch='.',col = train$fault+1)

# predict
data <- ds[[1]]
#df <- data[1:i,]
predict_next_cycle <- function(df) {
  if(nrow(df) == 1) return(9050)
  if(nrow(data) < 5) return(data$s9[nrow(df)-1])
  model <- glm('s9 ~ exp(cycle)',data = df[-nrow(df),])
  return(predict(model, newdata = df[nrow(df),]))
}
predict_s9 <- function(data) {
  sapply(c(1:nrow(data)), function(i) predict_next_cycle(data[1:i,]))
}
prediction_s9 <- lapply(ds,predict_s9)
prediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleading
train$prediction <- unsplit(prediction_s9, train$id)

train$predict_fault <- as.integer(train$prediction > 9100)
library(caret)
挼㸷攼㸰攼㸳昼㸰昼㸳攼㸷攼㹡攼㸰 昼㸲昼㸰攼㸵攼㸱昼㸳攼㸵攼㹣攼㹥攼㸳攼㹥 攼㹦攼㸰攼㹡攼㸵昼㸲攼㸰: lattice
挼㸷攼㸰攼㸳昼㸰昼㸳攼㸷攼㹡攼㸰 昼㸲昼㸰攼㸵攼㸱昼㸳攼㸵攼㹣攼㹥攼㸳攼㹥 攼㹦攼㸰攼㹡攼㸵昼㸲攼㸰: ggplot2
Registered S3 methods overwritten by 'ggplot2':
  method         from 
  [.quosures     rlang
  c.quosures     rlang
  print.quosures rlang
Registered S3 method overwritten by 'dplyr':
  method           from
  print.rowwise_df     
Registered S3 method overwritten by 'data.table':
  method           from
  print.data.table     

confusionMatrix(xtab)
 1.0000          
         Neg Pred Value : 0.3710          
             Prevalence : 0.9294          
         Detection Rate : 0.8096          
   Detection Prevalence : 0.8096          
      Balanced Accuracy : 0.9356          
                                          
       'Positive' Class : 0               
                                          
plot(train$cycle,train$s9,pch='.',col = train$predict_fault+1)


# test
test <- read.csv('D:/Dropbox/work/test1/Data_Add_20.csv',sep = ';', dec = ',')
plot(test$cycle,test$s9,pch='.')


#suppose
test$fault <- 0
test$fault[test$s9 > 9100] <- 1
plot(test$cycle,test$s9,pch='.',col = test$fault+1)


dst <- split(test,test$id)
prediction_s9t <- lapply(dst,predict_s9)
prediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleadingprediction from a rank-deficient fit may be misleading
test$prediction <- unsplit(prediction_s9t, test$id)

test$predict_fault <- as.integer(test$prediction > 9100)
library(caret)
confusionMatrix(xtabt)
Confusion Matrix and Statistics

   
       0    1
  0 3624    0
  1  273  154
                                          
               Accuracy : 0.9326          
                 95% CI : (0.9244, 0.9401)
    No Information Rate : 0.962           
    P-Value [Acc > NIR] : 1               
                                          
                  Kappa : 0.5023          
 Mcnemar's Test P-Value : <2e-16          
                                          
            Sensitivity : 0.9299          
            Specificity : 1.0000          
         Pos Pred Value : 1.0000          
         Neg Pred Value : 0.3607          
             Prevalence : 0.9620          
         Detection Rate : 0.8946          
   Detection Prevalence : 0.8946          
      Balanced Accuracy : 0.9650          
                                          
       'Positive' Class : 0               
                                          
plot(test$cycle,test$s9,pch='.',col = test$predict_fault+1)

LS0tDQp0aXRsZTogItCd0LDQtNC10LbQvdC+0YHRgtGMINC80L7RgtC+0YDQvtCyIg0Kb3V0cHV0OiBodG1sX25vdGVib29rDQotLS0NCiMg0J/QvtGB0YLQsNC90L7QstC60LAg0LfQsNC00LDRh9C4Lg0K0JjQvNC10LXRgtGB0Y8gODAg0LzQvtGC0L7RgNC+0LIsINC60LDQttC00YvQuSDQuNC3INC60L7RgtC+0YDRi9GFINC20LjQstC10YIg0L7Qv9GA0LXQtNC10LvQtdC90L3QvtC1INGH0LjRgdC70L4g0YbQuNC60LvQvtCyLiDQmtCw0LbQtNGL0Lkg0YbQuNC60Lsg0L/RgNC+0LjRgdGF0L7QtNC40YIg0YHQvdGP0YLQuNC1INC40L3RhNC+0YDQvNCw0YbQuNC4INGBINC00LDRgtGH0LjQutC+0LIgUzEg4oCTIFMyMSDQuCDQv9GA0L7QuNGB0YXQvtC00LjRgiDQv9C10YDQtdGD0YHRgtCw0L3QvtCy0LrQsCDQvdCw0YHRgtGA0L7QtdGH0L3Ri9GFINC/0LDRgNCw0LzQtdGC0YDQvtCyIFNldHRpbmcxIOKAkyBTZXR0aW5nMi4NCg0KIyMg0J3QtdC+0LHRhdC+0LTQuNC80L46IA0K0J/RgNC+0LLQtdGB0YLQuCDQsNC90LDQu9C40Lcg0L/RgNC10LTQvtGB0YLQsNCy0LvQtdC90L3Ri9GFINC00LDQvdC90YvRhSDQv9C+IDgwINC80L7RgtC+0YDQsNC8ICjRhNCw0LnQuyBEYXRhXzgwLmNzdikuINCh0LTQtdC70LDRgtGMINC/0YDQtdC00L/QvtC70L7QttC10L3QuNC1INC+INCy0YvRhdC+0LTQtSDQuNC3INGB0YLRgNC+0Y8g0LzQvtGC0L7RgNCwINC90LAg0L7RgdC90L7QstCw0L3QuNC4INC40LzQtdGO0YnQuNGF0YHRjyDQtNCw0L3QvdGL0YUg0LTQsNGC0YfQuNC60L7Qsi4g0JTQsNC70LXQtSDQvdCwINC+0YHQvdC+0LLQsNC90LjQuCDQtNC+0L/QvtC70L3QuNGC0LXQu9GM0L3QviDQv9GA0LXQtNC+0YHRgtCw0LLQu9C10L3QvdGL0YUg0LTQsNC90L3Ri9GFINC/0L4gMjAg0LzQvtGC0L7RgNCw0LwgKNGE0LDQudC7IERhdGFfQWRkXzIwLmNzdikg0YHQtNC10LvQsNGC0Ywg0L/RgNC10LTQv9C+0LvQvtC20LXQvdC40Y8g0L4g0LLRi9GF0L7QtNC1INC80L7RgtC+0YDQsCDQuNC3INGB0YLRgNC+0Y8g0L3QsCDRgdC70LXQtNGD0Y7RidC10Lwg0YbQuNC60LvQtS4NCg0KDQoNCmBgYHtyfQ0KDQp0cmFpbiA8LSByZWFkLmNzdigiRDovRHJvcGJveC93b3JrL3Rlc3QxL0RhdGFfODAuY3N2Iiwgc2VwPSI7IiwgZGVjPScsJykNCnN1bW1hcnkodHJhaW4pDQoNCiMgaW5kZXBlbmRlbnQgY29tcG9uZW50cw0KdHJhaW4yIDwtIHRyYWluWyxjKCdjeWNsZScsJ3M5JywnczExJyldDQpwYWlycyh0cmFpbjIpDQoNCmRzIDwtIHNwbGl0KHRyYWluLHRyYWluJGlkKQ0Kc3AgPC0gc3BsaXQodHJhaW4kY3ljbGUsdHJhaW4kaWQpDQpzOXNwIDwtIHNwbGl0KHRyYWluJHM5LHRyYWluJGlkKQ0KDQpwbG90KHRyYWluJGN5Y2xlLHRyYWluJHM5LHBjaD0nLicpDQpmb3IoaSBpbiBjKDE6MTApKSB7DQogIGxpbmVzKHNwW1tpXV0sczlzcFtbaV1dKQ0KfQ0KZmF1bHRfaWQgPC0gdW5pcXVlKHRyYWluJGlkW3RyYWluJHM5ID4gOTEwMF0pDQpmYXVsdF9pZA0KbGVuZ3RoKGZhdWx0X2lkKQ0KDQpwbG90KHRyYWluJGN5Y2xlLHRyYWluJHM5LHBjaD0nLicpDQpmb3IoaWQgaW4gZmF1bHRfaWQpIHsNCiAgbGluZXMoc3BbW2lkXV0sczlzcFtbaWRdXSkNCn0NCg0KI3N1cHBvc2UNCnRyYWluJGZhdWx0IDwtIDANCnRyYWluJGZhdWx0W3RyYWluJHM5ID4gOTEwMF0gPC0gMQ0KcGxvdCh0cmFpbiRjeWNsZSx0cmFpbiRzOSxwY2g9Jy4nLGNvbCA9IHRyYWluJGZhdWx0KzEpDQoNCiMgcHJlZGljdA0KZGF0YSA8LSBkc1tbMV1dDQojZGYgPC0gZGF0YVsxOmksXQ0KcHJlZGljdF9uZXh0X2N5Y2xlIDwtIGZ1bmN0aW9uKGRmKSB7DQogIGlmKG5yb3coZGYpID09IDEpIHJldHVybig5MDUwKQ0KICBpZihucm93KGRhdGEpIDwgNSkgcmV0dXJuKGRhdGEkczlbbnJvdyhkZiktMV0pDQogIG1vZGVsIDwtIGdsbSgnczkgfiBleHAoY3ljbGUpJyxkYXRhID0gZGZbLW5yb3coZGYpLF0pDQogIHJldHVybihwcmVkaWN0KG1vZGVsLCBuZXdkYXRhID0gZGZbbnJvdyhkZiksXSkpDQp9DQpwcmVkaWN0X3M5IDwtIGZ1bmN0aW9uKGRhdGEpIHsNCiAgc2FwcGx5KGMoMTpucm93KGRhdGEpKSwgZnVuY3Rpb24oaSkgcHJlZGljdF9uZXh0X2N5Y2xlKGRhdGFbMTppLF0pKQ0KfQ0KcHJlZGljdGlvbl9zOSA8LSBsYXBwbHkoZHMscHJlZGljdF9zOSkNCg0KdHJhaW4kcHJlZGljdGlvbiA8LSB1bnNwbGl0KHByZWRpY3Rpb25fczksIHRyYWluJGlkKQ0KDQp0cmFpbiRwcmVkaWN0X2ZhdWx0IDwtIGFzLmludGVnZXIodHJhaW4kcHJlZGljdGlvbiA+IDkxMDApDQp4dGFiIDwtIHRhYmxlKHRyYWluJHByZWRpY3RfZmF1bHQsIHRyYWluJGZhdWx0KQ0KbGlicmFyeShjYXJldCkNCmNvbmZ1c2lvbk1hdHJpeCh4dGFiKQ0KcGxvdCh0cmFpbiRjeWNsZSx0cmFpbiRzOSxwY2g9Jy4nLGNvbCA9IHRyYWluJHByZWRpY3RfZmF1bHQrMSkNCg0KIyB0ZXN0DQp0ZXN0IDwtIHJlYWQuY3N2KCdEOi9Ecm9wYm94L3dvcmsvdGVzdDEvRGF0YV9BZGRfMjAuY3N2JyxzZXAgPSAnOycsIGRlYyA9ICcsJykNCnBsb3QodGVzdCRjeWNsZSx0ZXN0JHM5LHBjaD0nLicpDQoNCiNzdXBwb3NlDQp0ZXN0JGZhdWx0IDwtIDANCnRlc3QkZmF1bHRbdGVzdCRzOSA+IDkxMDBdIDwtIDENCnBsb3QodGVzdCRjeWNsZSx0ZXN0JHM5LHBjaD0nLicsY29sID0gdGVzdCRmYXVsdCsxKQ0KDQpkc3QgPC0gc3BsaXQodGVzdCx0ZXN0JGlkKQ0KcHJlZGljdGlvbl9zOXQgPC0gbGFwcGx5KGRzdCxwcmVkaWN0X3M5KQ0KDQp0ZXN0JHByZWRpY3Rpb24gPC0gdW5zcGxpdChwcmVkaWN0aW9uX3M5dCwgdGVzdCRpZCkNCg0KdGVzdCRwcmVkaWN0X2ZhdWx0IDwtIGFzLmludGVnZXIodGVzdCRwcmVkaWN0aW9uID4gOTEwMCkNCnh0YWJ0IDwtIHRhYmxlKHRlc3QkcHJlZGljdF9mYXVsdCwgdGVzdCRmYXVsdCkNCmxpYnJhcnkoY2FyZXQpDQpjb25mdXNpb25NYXRyaXgoeHRhYnQpDQpwbG90KHRlc3QkY3ljbGUsdGVzdCRzOSxwY2g9Jy4nLGNvbCA9IHRlc3QkcHJlZGljdF9mYXVsdCsxKQ0KDQpgYGANCg==