An implementation of common higher order functions with syntactic sugar for anonymous function. Provides also a link to ‘dplyr’ for common transformations on data frames to work around non standard evaluation by default.
devtools::install_github("wahani/dat")
install.packages("dat")
R CMD check
. And you don’t like that.dplyr
is not respecting the class of the object it operates on; the class attribute changes on-the-fly.dplyr
nor data.table
are playing nice with S4, but you really, really want a S4 data.table or tbl_df.rlist
and purrr
.dplyr
The examples are from the introductory vignette of dplyr
. You still work with data frames: so you can simply mix in dplyr features whenever you need them. The functions filtar
, mutar
and sumar
are R CMD check
friendly replacements for the corresponding versions in dplyr
. For select
you can use extract
. The function names are chosen so that they are similar but do not conflict with dplyr
s function names - so dplyr
can be savely attached to the search path.
library("nycflights13")
library("dat")
filtar
can be used as a replacement for filter
and slice
. When you reference a variable in the data itself, you can indicate this by using a one sided formula.
filtar(flights, ~ month == 1 & day == 1)
filtar(flights, 1:10)
And for sorting:
filtar(flights, ~ order(year, month, day))
## # A tibble: 336,776 x 19
## year month day dep_time sched_dep_time dep_delay arr_time
## <int> <int> <int> <int> <int> <dbl> <int>
## 1 2013 1 1 517 515 2 830
## 2 2013 1 1 533 529 4 850
## 3 2013 1 1 542 540 2 923
## 4 2013 1 1 544 545 -1 1004
## 5 2013 1 1 554 600 -6 812
## 6 2013 1 1 554 558 -4 740
## 7 2013 1 1 555 600 -5 913
## 8 2013 1 1 557 600 -3 709
## 9 2013 1 1 557 600 -3 838
## 10 2013 1 1 558 600 -2 753
## # ... with 336,766 more rows, and 12 more variables: sched_arr_time <int>,
## # arr_delay <dbl>, carrier <chr>, flight <int>, tailnum <chr>,
## # origin <chr>, dest <chr>, air_time <dbl>, distance <dbl>, hour <dbl>,
## # minute <dbl>, time_hour <dttm>
You can use characters, logicals, regular expressions and functions to select columns. Regular expressions are indicated by a leading “^”. Character are simply passed to dplyr::select_
.
flights %>%
extract(c("year", "month", "day")) %>%
extract("year:day") %>%
extract("^day$") %>%
extract(is.numeric)
The main difference between mutate
and mutar
is that you use a ~
instead of =
.
mutar(
flights,
gain ~ arr_delay - dep_delay,
speed ~ distance / air_time * 60
)
Grouping data is handled within mutar
:
mutar(flights, n ~ n(), by = "month")
sumar(flights, delay ~ mean(dep_delay, na.rm = TRUE), by = "month")
You can also provide additional arguments to a formula. This is especially helpful when you want to pass arguments from a function to such expressions. The additional augmentation can be anything which you can use to select columns (character, regular expression, function) or a named list where each element is a character.
sumar(
flights,
.n ~ mean(.n, na.rm = TRUE) | "^.*delay$",
x ~ mean(x, na.rm = TRUE) | list(x = "arr_time"),
by = "month"
)
## # A tibble: 12 x 4
## month dep_delay arr_delay arr_time
## <int> <dbl> <dbl> <dbl>
## 1 1 10.036665 6.1299720 1523.155
## 2 2 10.816843 5.6130194 1522.207
## 3 3 13.227076 5.8075765 1509.743
## 4 4 13.938038 11.1760630 1500.704
## 5 5 12.986859 3.5215088 1502.685
## 6 6 20.846332 16.4813296 1467.994
## 7 7 21.727787 16.7113067 1455.944
## 8 8 12.611040 6.0406524 1495.368
## 9 9 6.722476 -4.0183636 1503.549
## 10 10 6.243988 -0.1670627 1519.899
## 11 11 5.435362 0.4613474 1522.722
## 12 12 16.576688 14.8703553 1505.252
Using this package you can create S4 classes to contain a data frame (or a data.table) and use the interface to dplyr
. Both dplyr
and data.table
do not support integration with S4. The main function here is mutar
which is generic enough to link to subsetting of rows and cols as well as mutate and summarise. In the background dplyr
s ability to work on a data.table
is being used.
library("data.table")
setClass("DataTable", "data.table")
DataTable <- function(...) {
new("DataTable", data.table::data.table(...))
}
setMethod("[", "DataTable", mutar)
dtflights <- do.call(DataTable, nycflights13::flights)
dtflights[1:10, "year:day"]
dtflights[n ~ n(), by = "month"]
dtflights[n ~ n(), sby = "month"]
dtflights %>%
filtar(~month > 6) %>%
mutar(n ~ n(), by = "month") %>%
sumar(n ~ first(n), by = "month")
Inspired by rlist
and purrr
some low level operations on vectors are supported. The aim here is to integrate syntactic sugar for anonymous functions. Furthermore the functions should support the use of pipes.
map
and flatmap
as replacements for the apply functionsextract
for subsettingreplace
for replacing elements in a vectorWhat we can do with map:
map(1:3, ~ .^2)
flatmap(1:3, ~ .^2)
map(1:3 ~ 11:13, c) # zip
dat <- data.frame(x = 1, y = "")
map(dat, x ~ x + 1, is.numeric)
What we can do with extract:
extract(1:10, ~ . %% 2 == 0) %>% sum
extract(1:15, ~ 15 %% . == 0)
l <- list(aList = list(x = 1), aAtomic = "hi")
extract(l, "^aL")
extract(l, is.atomic)
What we can do with replace:
replace(c(1, 2, NA), is.na, 0)
replace(c(1, 2, NA), rep(TRUE, 3), 0)
replace(c(1, 2, NA), 3, 0)
replace(list(x = 1, y = 2), "x", 0)
replace(list(x = 1, y = 2), "^x$", 0)
replace(list(x = 1, y = "a"), is.character, NULL)