Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **Example RAW Data**
- ╔═══════════╦══════════╦═════════════╦═════════════════╗
- ║ Timestamp ║ DensityX ║ WaveLngth ║ Temp (K) ║
- ╠═══════════╬══════════╬═════════════╬═════════════════╣
- ║ 1 ║ 0.1 ║ 2 ║ 200 ║
- ║ 2 ║ 0.9 ║ 3 ║ 150 ║
- ║ 3 ║ -0.5 ║ 1 ║ 175 ║
- ║ 4 ║ 0 ║ 6 ║ 154 ║
- ║ 5 ║ 1 ║ 8 ║ 155 ║
- ║ 6 ║ 1.3 ║ 1.5 ║ 220 ║
- ║ 7 ║ -0.5 ║ 3.4 ║ 250 ║
- ║ 8 ║ 0.2 ║ 2 ║ 255 ║
- ║ 9 ║ 0.1 ║ 1 ║ 180 ║
- ╚═══════════╩══════════╩═════════════╩═════════════════╝
- **Processed Data**
- ╔═════════╦══════╦════╦══════╦═════╦════╦════╦════════╦═════════╗
- ║ Pattern ║ I1 ║ I2 ║ I3 ║ I4 ║ O1 ║ O2 ║ Class ║ Used TS ║
- ╠═════════╬══════╬════╬══════╬═════╬════╬════╬════════╬═════════╣
- ║ 1 ║ 0.1 ║ 2 ║ 0.9 ║ 3 ║ 0 ║ 1 ║ Down ║ 1 to 5 ║
- ║ 2 ║ 0.9 ║ 3 ║ -0.5 ║ 1 ║ -1 ║ -1 ║ Up ║ 2 to 6 ║
- ║ 3 ║ -0.5 ║ 1 ║ 0 ║ 6 ║ -1 ║ -1 ║ Up ║ 3 to 7 ║
- ║ 4 ║ 0 ║ 6 ║ 1 ║ 8 ║ 1 ║ 0 ║ Stable ║ 4 to 8 ║
- ║ 5 ║ 1 ║ 8 ║ 1.3 ║ 1.5 ║ 1 ║ 0 ║ Stable ║ 5 to 9 ║
- ╚═════════╩══════╩════╩══════╩═════╩════╩════╩════════╩═════════╝
- **Reciprocal normalization**
- Every value is processed to its reciprocal (x=1/x). Calculated values for density x would be:
- ╔═══════════╦════════════════════╗
- ║ Timestamp ║ Reciprocal Density ║
- ╠═══════════╬════════════════════╣
- ║ 1 ║ 10 ║
- ║ 2 ║ 1.111111111 ║
- ║ 3 ║ -2 ║
- ║ 4 ║ #DIV/0! ║
- ║ 5 ║ 1 ║
- ║ 6 ║ 0.769230769 ║
- ║ 7 ║ -2 ║
- ║ 8 ║ 5 ║
- ║ 9 ║ 10 ║
- ╚═══════════╩════════════════════╝
- The starting point was Timestamp 1 where the Delta equals 0.
- For each timestamp the delta percentage is calculated evaluating the previous value. So calculating the time series delta percentages would turn out to:
- ╔═══════════╦═══════════════════╗
- ║ Timestamp ║ "Delta Density X" ║
- ╠═══════════╬═══════════════════╣
- ║ 1 ║ 0 ║
- ║ 2 ║ 0.9 ║
- ║ 3 ║ -0.555555556 ║
- ║ 4 ║ 0 ║
- ║ 5 ║ #DIV/0! ║
- ║ 6 ║ 1.3 ║
- ║ 7 ║ -0.384615385 ║
- ║ 8 ║ -0.4 ║
- ║ 9 ║ 0.5 ║
- ╚═══════════╩═══════════════════╝
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement