File: complete.tbl_lazy.Rd

package info (click to toggle)
r-cran-dbplyr 2.3.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 2,376 kB
  • sloc: sh: 13; makefile: 2
file content (42 lines) | stat: -rw-r--r-- 1,429 bytes parent folder | download | duplicates (2)
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/verb-expand.R
\name{complete.tbl_lazy}
\alias{complete.tbl_lazy}
\title{Complete a SQL table with missing combinations of data}
\usage{
\method{complete}{tbl_lazy}(data, ..., fill = list())
}
\arguments{
\item{data}{A lazy data frame backed by a database query.}

\item{...}{Specification of columns to expand. See \link[tidyr:expand]{tidyr::expand} for
more details.}

\item{fill}{A named list that for each variable supplies a single value to
use instead of NA for missing combinations.}
}
\value{
Another \code{tbl_lazy}. Use \code{\link[=show_query]{show_query()}} to see the generated
query, and use \code{\link[=collect.tbl_sql]{collect()}} to execute the query
and return data to R.
}
\description{
Turns implicit missing values into explicit missing values. This is a method
for the \code{\link[tidyr:complete]{tidyr::complete()}} generic.
}
\examples{
\dontshow{if (rlang::is_installed("tidyr", version = "1.0.0")) (if (getRversion() >= "3.4") withAutoprint else force)(\{ # examplesIf}
df <- memdb_frame(
  group = c(1:2, 1),
  item_id = c(1:2, 2),
  item_name = c("a", "b", "b"),
  value1 = 1:3,
  value2 = 4:6
)

df \%>\% tidyr::complete(group, nesting(item_id, item_name))

# You can also choose to fill in missing values
df \%>\% tidyr::complete(group, nesting(item_id, item_name), fill = list(value1 = 0))
\dontshow{\}) # examplesIf}
}