How do you pronounce `tbl`

May 6, 2018 @jdlong James (JD) Long

@jdlong wrote:

I'm presenting on dplyr this week and I'm trying to make sure I have my naming sorted out before I start infecting people with my ideas.

flights_db <- tbl(con, "flights")

in the above example, flights_db is (I think) a tbl... although if I try to look up its class I get:

class(flights_db)
[1] "tbl_dbi"  "tbl_sql"  "tbl_lazy" "tbl"  

so is it a tbl or is it a tbl_dbi?

The thing we call a 'Tibble' is of the following class:

[1] "tbl_df"     "tbl"        "data.frame"

So what is the name for the thing returned by the function tbl? And how do we pronounce it? It's this pointer thing that is lazy evaluated and points to a a table on the DB.

And related: once we run a tbl though a pipe flow, we end up with an object that is a pointer to an unevaluated blob of SQL. Is that blob also a tbl or does it get a different name? In other words, what do we call my_tbl in the example below:

flights_db %>% 
  group_by(dest) %>%
  summarise(delay = mean(dep_time)) ->
my_tbl

Posts: 5

Participants: 2

Read full topic

Previous Article
Equivalent of JupyterHub with Rstudio (Cloud?)
Equivalent of JupyterHub with Rstudio (Cloud?)

@vnijs wrote: Berkeley has what looks like a really great setup for their data s...

Next Article
Balance of predictor variables in partial least squares regression
Balance of predictor variables in partial least squares regression

@Ranae wrote: I am using partial least squares regression (PLS) to model the rel...