Writes d to an in-memory SQLite database and profiles it with
profile_query(). Use it to profile data that is already in R.
Arguments
- d
A data frame that holds every column of
field_types.- field_types
A named character vector of csdb field types, as in
profile_query(). Columns ofdthat it does not name are not written.- ...
Other arguments to
profile_query(). Do not giveconnection,sqlorfield_types.
Value
A csdb_profile, as profile_query() returns it. The query
selects every column of the in-memory table profile_data.
See also
Other profile functions:
profile_query(),
profile_table(),
read_profile(),
write_profile()
Examples
d <- data.frame(
day = as.Date("2024-01-01") + rep(0:3, each = 5),
cases = rep(c(2L, 7L, 9L, 12L), each = 5)
)
p <- profile_data(
d,
field_types = c(day = "DATE", cases = "INTEGER"),
columns = c(day = "full", cases = "full")
)
p$columns$day
#> $type
#> [1] "DATE"
#>
#> $sensitivity
#> [1] "full"
#>
#> $missing_share
#> [1] 0
#>
#> $days
#> [1] "2024-01-01" "2024-01-02" "2024-01-03" "2024-01-04"
#>
#> $n
#> [1] 5 5 5 5
#>
