Имеется 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)