Publications by Rsquared Academy Blog
Quick Guide: R & SQLite
Introduction This is the first post in the series R & Databases. You can find the links to the other two posts of this series below: Data Wrangling with dbplyr SQL for Data Science – Part 1 SQL for Data Science – Part 2 In this post, we will learn to: connect to a SQLite database from R display database information list tables in the datab...
4638 sym R (5828 sym/25 pcs)
Data Wrangling with dbplyr
Introduction This is the second post in the series R & Databases. You can find the links to the first post of this series below: Quick Guide: R & SQLite In this post, we will learn to query data from a database using dplyr. Libraries, Code & Data We will use the following libraries in this post: DBI RSQLite dbplyr dplyr All the data sets use...
2155 sym R (5757 sym/8 pcs)
SQL for Data Science – Part 1
Introduction This is the third post in the series R & Databases. You can find the links to the other two posts of this series below: Quick Guide: R & SQLite Data Wrangling with dbplyr SQL for Data Science – Part 2 In this post, we will learn to: select single column multiple columns distinct values in a column limit the number of records r...
5540 sym R (10052 sym/15 pcs)
SQL for Data Science – Part 2
Introduction This is the fourth post in the series R & Databases. You can find the links to the other two posts of this series below: Quick Guide: R & SQLite Data Wrangling with dbplyr SQL for Data Science – Part 1 In this post, we will learn to aggregate data order data and group data Libraries, Code & Data We will use the following librar...
1881 sym R (4533 sym/8 pcs)
Introducing olsrr
I am pleased to announce the olsrr package, a set of tools for improved output from linear regression models, designed keeping in mind beginner/intermediate R users. The package includes: comprehensive regression output variable selection procedures heteroskedasticiy, collinearity diagnostics and measures of influence various plots and underlyin...
4124 sym R (5323 sym/8 pcs) 4 img
RFM Analysis in R
We are pleased to announce the rfm package, a set of tools for recency, frequency and monetary value analysis, designed keeping in mind beginner/intermediate R users. It can handle: transaction level data customer level data Installation # Install release version from CRAN install.packages("rfm") # Install development version from GitHub # ins...
7252 sym R (1854 sym/16 pcs) 20 img 2 tbl
Descriptive/Summary Statistics with descriptr
We are pleased to introduce the descriptr package, a set of tools for generating descriptive/summary statistics. Installation # Install release version from CRAN install.packages("descriptr") # Install development version from GitHub # install.packages("devtools") devtools::install_github("rsquaredacademy/descriptr") Shiny App descriptr includ...
4610 sym R (41500 sym/29 pcs) 20 img
Logistic regression in R using blorr package
We are pleased to introduce the blorr package, a set of tools for building and validating binary logistic regression models in R, designed keeping in mind beginner/intermediate R users. The package includes: comprehensive regression output variable selection procedures bivariate analysis, model fit statistics and model validation tools various p...
8609 sym R (20112 sym/24 pcs) 22 img
Getting Help in R
Introduction In this post, we will learn about the different methods of getting help in R. Often, we get stuck while doing some analysis as either we do not know the correct function to use or its syntax. It is important for anyone who is new to R to know the right place to look for help. There are two ways to look for help in R: built in help s...
5114 sym R (2724 sym/10 pcs) 18 img
Binning Data with rbin
We are happy to introduce the rbin package, a set of tools for binning/discretization of data, designed keeping in mind beginner/intermediate R users. It comes with two RStudio addins for interactive binning. Installation # Install release version from CRAN install.packages("rbin") # Install development version from GitHub # install.packages("d...
3522 sym R (10654 sym/12 pcs) 8 img