tidyquery
tidyquery copied to clipboard
ianmcook
Query R data frames with SQL
In SQL, `NULL`s are not typed. But in R, `NA`s are typed. By default, `NA` is logical, and there are other variants `NA_real_`, `NA_character_`, and `NA_integer_`. This can cause problems...
~~This is now enabled by https://github.com/r-lib/rlang/pull/897~~
Support Apache Arrow `Table` and `RecordBatch` objects (which inherit class `ArrowTabular`) and `Dataset` objects (which inherit class `Dataset` and `ArrowObject`)
I was trying to use the function show_dplyr but I got the following error message: Error: Subqueries are not supported Error: OVER clauses are not supported Error: Joins of three...
See https://github.com/xiaodaigh/disk.frame/issues/196
Use the new `keep` argument to `full_join()` in https://github.com/tidyverse/dplyr/issues/4589 to preserve the join key columns from both the left and right tables, allowing qualified references to these columns in other...
After the fix to https://github.com/tidyverse/dplyr/issues/4206 is on CRAN, use it to enable cross joins by specifying `by = character()`.
Look into using functions from the tidyselect package including `poke_vars()`, `peek_vars()`, `scoped_vars()`, `with_vars()`, and `has_vars()` to implement some of the logic around aliases in `query()` more cleanly. These functions could...
cross join does not work in query() functions Syntax like this does not work. df1 and df2 are two simple dataframes . `query (' select * from df1 cross join...
