Suggestion.... fixing impossible data
Posted: Fri 03 Nov 2023 9:37 pm
My 2022 year is littered with 0's for pressure.
I'm not looking for 100% accuracy but is it possible to drop the zeros and calculate the average from the day before and the day after?
We have the create missing script - but I imagine a script, something that would average the values from the day before and the day after that would understand impossible values (such as minus rain or zero pressure) and replace the 0 with an average?
Obviously there would be warnings to confirm the changes, sadly I'm not competent enough to write a script but for the amature in me it would be a lovely feature to have to sanitize my data.
I'm not looking for 100% accuracy but is it possible to drop the zeros and calculate the average from the day before and the day after?
We have the create missing script - but I imagine a script, something that would average the values from the day before and the day after that would understand impossible values (such as minus rain or zero pressure) and replace the 0 with an average?
Obviously there would be warnings to confirm the changes, sadly I'm not competent enough to write a script but for the amature in me it would be a lovely feature to have to sanitize my data.