Skip to content

A super-simple SQL code generator for lazy R programmers

License

Notifications You must be signed in to change notification settings

mattjcamp/coderr

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

41 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Coder

coderr helps you write SQL code in a way that presents a clear workflow.

Here is an example that aggregates earthquake information from the built-in quakes dataset.:

library(sqldf)
library(coderr)

code_sql_sample("quakes") %>%
code_sql_group_by(aggregator.cols = "avg(mag) AS mag_mean",
                  group.by.cols = c("stations")) %>%
code_sql_select(select.cols = c("stations", "mag_mean"),
                filters = c("stations < 15"),
                order.by.cols = c("stations")) %>%
sqldf()

This calculates earthquake magnitude means by station and then presents only stations with station names with a value less than 15.

coderr is used in large scale statistical programming projects where data is stored on remote large scale databases. There's also more to it than that - check out the code and tests to see more.

About

A super-simple SQL code generator for lazy R programmers

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages