Grow your data science skills at posit::conf(2024)

August 12th-14th in Seattle

There’s a point in every data wranglers’ career in which their full dataset can no longer fit into just CSV files, and the journey to database-world begins. I reached this point about two years ago, when I transitioned from ecological research to the world of eCommerce fraud prevention. My calls to read_csv became scarcer as I came to rely more and more on databases. In this talk, I’ll demonstrate how I use R and SQL to access database tables, and how I incorporate both into my daily workflow, aided by features in RStudio IDE. I’ll also discuss our company’s “riskiconn” package for handling database connections and queries, which includes customizations to simplify day-to-day data querying.

View Materials

Subscribe to more inspiring open-source data science content.

We love to celebrate and help people do great data science. By subscribing, you'll get alerted whenever we publish something new.