Stack Overflow
Stack Overflow

Questions tagged [dbplyr]

dbplyr: A 'dplyr' Back End for Databases

A back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.

377 questions
-1
votes
1 answer

filter on two sets of dates in dataframe

I am using DBPLYR to access a database. However, I would like to filter on two sets of dates. I know how to do this in SQL but not in dplyr or dbplyr. The SQL code for this would be (start_date between date '2017-01-01' and date '2017-03-31') or…
Jeremy R. Johnson
  • 285
  • 4
  • 13
-1
votes
1 answer

Renaming a Summarised Column inside Redshift dplyr operations

I am using dplyr to do certain operations in Redshift so I don't load the data in memory. data <- tbl(conn, "customers") %>% filter(age >= 18) subset <- data %>% filter(eye_color != "brown") %>% group_by(gender, method, age, region) %>% …
Minh
  • 2,180
  • 5
  • 23
  • 50
1 2 3
…
25
26