Icon

Day3_​S2_​Feature_​Factory_​Lite

1 · Read and Order

Read the S1 output, parse timestamps, sort by pump then time.

Step 1 · Read and prepare


  1. Read day03_s1.csv with CSV Reader
  2. Parse the timestamp with String to Date&Time
  3. Sort by pump then time with Sorter

2 · Smooth and Flag

Rolling mean per pump, then a quality rule on the result.

Step 2 · Smooth per pump


  1. Loop per pump with Group Loop Start
  2. Rolling mean with Moving Aggregator, collect with Loop End
  3. Flag with Rule Engine

3 · RMS, Crest, Kurtosis

Unpivot the sensors, compute one formula per feature, pivot back.

Step 3 · Feature factory


  1. Unpivot sensors with Unpivot, loop per column
  2. RMS / crest / kurtosis with Math Formula, Moving Aggregator
  3. Collect with Loop End x2, pivot back with Pivot
  4. Write day03_s2.csv with CSV Writer

6 · AR-on-Self Limitation

Keep the old lag-1 model to show why it under-reacts.

Step 6 · The limitation, kept


  1. Lag the signal 1 step with Lag Column
  2. Fit on the reference period with Linear Regression Learner
  3. Score the residual with Regression Predictor, Numeric Scorer

หมายเหตุ

AR ทำได้แค่นี้ เศษเหลือขาวก็จริง แต่การเสื่อมหายไปกับแบบจำลอง

Explore before you decide

Profile the data and justify the 24h window before it gets locked.

Explore · Justify the 24h window


  1. Profile the aligned table with Statistics
  2. Per-pump 24h kurtosis probe, label normal/degraded with Rule Engine
  3. Decision picture: kurtosis by period with Box Plot
  4. After the fact: do RMS/crest/kurtosis agree? Linear Correlation, Box Plot
Node 1Day 3 locked constants5 constants
Variable Creator
Node 2Read CSVday03_s1.csv
CSV Reader
Node 19Write CSVday03_s2.csv
CSV Writer
Node 3Parse timestampyyyy-MM-ddTHH:mm
String to Date&Time
Node 4Sort rowspump+time
Sorter
Node 5Explore: per pump24h kurtosis probe
Group Loop Start
Node 6Explore: kurtosiskurtosis, win 24h
Moving Aggregator
Node 7Explore: collectstack pump kurtosis
Loop End
Node 20Read 2024H1 ref34752 rows
CSV Reader
Node 21Parse timestampyyyy-MM-dd HH:mm:ss
String to Date&Time
Node 24Lag bearing_temp_c(-1)AR-on-self input
Lag Column
Node 25AR-on-self, 2024H1temp ~ temp(-1)
Linear Regression Learner
Node 22Sort by pump+timepump_id,timestamp
Sorter
Node 23Lag temp(-1)AR train input
Lag Column
Node 28Score AR (blind)R2/MAE/RMSE
Numeric Scorer
EX Node 29Profile day03_s1n/miss/range/mean/SD
Statistics
Node 26AR-on-self, all rowsmodel, full stream
Regression Predictor
Node 27AR residualactual - AR pred
Math Formula
EX Node 31DECISION: 24h windownormal vs degraded
Box Plot
Node 10Loop per sensor2 sensor cols
Group Loop Start
EX Node 32Correlation checkrms, crest, kurtosis
Linear Correlation
EX Node 30Explore: labelnormal/degraded
Rule Engine
Node 8Loop per pumpgroup = pump_id
Group Loop Start
Node 1324h window statsmean/max/kurt, 24h
Moving Aggregator
Node 9Unpivot sensors2 sensor cols
Unpivot
Node 14RMS, 24h windowsqrt(mean value_sq)
Math Formula
Node 11Square valueColumnValues^2
Math Formula
EX Node 33Plot RMS spreadRMS by pump_id
Box Plot
Node 12Absolute value|ColumnValues|
Math Formula
Node 17Collect pumpsstack pump tables
Loop End
Node 18Pivot back to widecol naming fixed
Pivot
Node 15Crest factormax(|value|) / rms
Math Formula
Node 16Collect sensorsstack sensor rows
Loop End

Nodes

Extensions

Links