-
ggplot2 geom_bar Labeling
In educational data analysis, I am constantly looking at counts and proportions. I’ve found the easiest way to display these results with categorical variables like demographics is to use stacked bar charts and especially 100% stacked charts. Read More…
-
Connecting to MS SQL Server in R
There are dozens of ways to connect to an MS SQL Server database in R. You can use a number of packages, and within those packages, there are various methods for connecting and running SQL queries via an R script. Read More…
-
Can I Write SQL in R Markdown?
Hello! This is my very first post; just a quick test as to how a SQL snippet shows in a markdown file and on a website. See below. select personID , endYear , grade , ROW_NUMBER() over (partition by personID order by endYear, case when grade = 'KG' then '00' else grade end) as rowNum from #enroll3 Read More…