R 或 PostgreSQL 中的最小可变性检查 [英] Minimum variability check in R or PostgreSQL
本文介绍了R 或 PostgreSQL 中的最小可变性检查的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的数据集包含温度值.我想进行最小可变性检查.我想检查 3 个连续的温度值是否相对于每个定义的阈值 (.05) 没有变化,然后用最后三个观测值的平均值替换它们.
My Data-set contains temperature values. I want to preform minimum variability check. I would like to check if 3 successive temperature values do not changed with respect to a per-defined threshold (.05), then replacing them with mean value of last three observations.
推荐答案
WITH A as (
SELECT ambtemp,
date_trunc('hour', dt)+
CASE WHEN date_part('minute', dt) >= 6
THEN interval '6 minutes'
ELSE interval '0 minutes'
END as t
FROM temm),
B as(
SELECT ambtemp,t,
max(ambtemp::float(23)) OVER (PARTITION BY t) as max_temp,
min(ambtemp::float(23)) OVER (PARTITION BY t) as min_temp
FROM A)
SELECT *
FROM B
WHERE (max_temp - min_temp) <= 0.5
这篇关于R 或 PostgreSQL 中的最小可变性检查的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文