Code
db %>% count(g)
Output
<SQL>
SELECT `g`, COUNT(*) AS `n`
FROM `df`
GROUP BY `g`
Code
db %>% count(g, wt = x)
Output
<SQL>
SELECT `g`, SUM(`x`) AS `n`
FROM `df`
GROUP BY `g`
Code
db %>% count(g, sort = TRUE)
Output
<SQL>
SELECT `g`, COUNT(*) AS `n`
FROM `df`
GROUP BY `g`
ORDER BY `n` DESC
Code
db %>% add_count(g, sort = TRUE)
Output
<SQL>
SELECT `df`.*, COUNT(*) OVER (PARTITION BY `g`) AS `n`
FROM `df`
ORDER BY `n` DESC
Code
db %>% group_by(g) %>% add_count()
Output
<SQL>
SELECT `df`.*, COUNT(*) OVER (PARTITION BY `g`) AS `n`
FROM `df`
Code
lazy_frame(g = 1) %>% add_count(.drop = TRUE)
Condition
Error in `add_count()`:
! Argument `.drop` isn't supported on database backends.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.