sg data smoothing(polynomial smoothing)
For some data with much the noise, it is usually necessary to smooth the data to reduce the noise.
For example, a set of noisy data as below, use the sg() function to polynomial smooth the data
A |
|
1 |
=file("sgdata.xlsx").xlsimport@w() |
2 |
=A1.(~(1)) |
3 |
=A1.(~(2)) |
4 |
=sg(A3,1,15).conj() |
5 |
=canvas() |
6 |
=A5.plot("NumericAxis","name":"x") |
7 |
=A5.plot("NumericAxis","name":"y","location":2) |
8 |
=A5.plot("Line","markerStyle":0,"axis1":"x","data1":A2,"axis2":"y", "data2":A3) |
9 |
=A5.plot("Line","markerStyle":0,"lineColor":-65536,"axis1":"x","data1":A2,"axis2":"y", "data2":A4) |
10 |
=A5.draw@p(600,600) |
A1 Read the data as a secondary sequence
A2 The sequence number
A3 Original data
A4 Perform 15-point linear smoothing on A3 data (n=1,m=15), and return the smoothed data, as the red line in the figure. In sg(A,n,m,d), taking no derivative when the parameter d is omitted means smoothing only; d=1, indicating the smoothing result of the first derivative, which can eliminate the constant term error; d=2 Second derivative smooth, can eliminate the linear error
A5-A10 Draw the data before and after smoothing and observe the smoothing result. If the result is not good, the value of n, m, d can be adjusted until it is good.
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL