knitr::opts_chunk$set( collapse = TRUE, comment = "#>" ) library(dplyr) library(tidypredict)
binomialfamily models. That is akin to running
predict(model, type = "response")
contr.treatment) are supported.
wt ~ mpg + am
mutate(mtcars, newam = paste0(am))and then
wt ~ mpg + newam
wt ~ mpg + as.factor(am)
wt ~ mpg + as.character(am)
library(tidypredict) library(dplyr) df <- mtcars %>% mutate(char_cyl = paste0("cyl", cyl)) %>% select(wt, char_cyl, am) model <- glm(am ~ wt + char_cyl, data = df, family = "binomial")
It returns a SQL query that contains the coefficients (
model$coefficients) operated against the correct variable or categorical variable value. In most cases the resulting SQL is one short
CASE WHEN statement per coefficient. It appends the
offset field or value, if one is provided.
binomial models, the sigmoid equation is applied. This means that the target SQL database type will need to support the exponent function.
library(tidypredict) tidypredict_sql(model, dbplyr::simulate_mssql())
tidypredict_to_column() if the results are the be used or previewed in
df %>% tidypredict_to_column(model) %>% head(10)
The parser reads several parts of the
glm object to tabulate all of the needed variables. One entry per coefficient is added to the final table. Other variables are added at the end. Some variables are not required for every parsed model. For example,
offset is listed because it's part of the formula (call) of the model, if there were no offset in a given model, that line would not exist.
pm <- parse_model(model) str(pm, 2)
The output from
parse_model() is transformed into a
dplyr, a.k.a Tidy Eval, formula. All categorical variables are operated using
From there, the Tidy Eval formula can be used anywhere where it can be operated.
tidypredict provides three paths:
mutate(df, !! tidypredict_fit(model))
tidypredict_to_column(model)to a piped command set
tidypredict_to_sql(model)to retrieve the SQL statement
The same applies to the prediction interval functions.
tidypredict results is easy. The
tidypredict_test() function automatically uses the
lm model object's data frame, to compare
tidypredict_interval() to the results given by
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.