1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
# quantile and median don't change without warning
Code
translate_sql(quantile(x, 0.75, na.rm = TRUE), window = FALSE)
Output
<SQL> PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY `x`)
---
Code
translate_sql(quantile(x, 0.75, na.rm = TRUE), vars_group = "g")
Output
<SQL> PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY `x`) OVER (PARTITION BY `g`)
---
Code
translate_sql(median(x, na.rm = TRUE), window = FALSE)
Output
<SQL> PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY `x`)
---
Code
translate_sql(median(x, na.rm = TRUE), vars_group = "g")
Output
<SQL> PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY `x`) OVER (PARTITION BY `g`)
|
