Articles by Pete Talbert

COVID-19 New York Times plots

April 11, 2020 | Pete Talbert

The New York Times has produced some really great maps and plots in its efforts to track the coronavirus in the U.S. One plot in particular that caught my attention is the histogram (actually more like a bar plot) of new cases with a 7-day average l...
[Read more...]

Connecting to MAMP install of MySQL in R

March 10, 2020 | Pete Talbert

In the course of doing a web dev tutorial (namely Tania Rascia’s great post on building a simple CRUD app) I had to install MAMP. This gives you a local server environment consisting of Apache, MySQL, and PHP. Since I work with databases so often, I... [Read more...]

Learning bash

March 4, 2020 | Pete Talbert

Hello all! So I just bought a used MacBook Pro in order to learn Linux, bash, shell scripting, etc. This post is just to test that I can write bash code in an .Rmd file and it will show on my blog correctly. ls ## 2018-11-13-can-i-write-sql-in-r-mar... [Read more...]

For loops for quick summaries in R

February 27, 2020 | Pete Talbert

Because I often work with categorical data, I find myself making lots of quick, sorted counts of variables in a dataset. I find that this is a really common technique to get to know a dataset you’re working with; I’ve also noticed David Robinson do it often in ...
[Read more...]


November 23, 2019 | Pete Talbert

I am a data analyst in the Twin Cities, specializing in the K-12, higher education, and non-profit sectors. I have worked in the field for over four years, and know both the database and analytical/visualization components deeply. I work hard to unders... [Read more...]

Consulting Services

November 23, 2019 | Pete Talbert

Hello all! I have not posted on this site since March, and I feel terrible about it. I know no one reads this, but personally it was a goal of mine to keep my skills up-to-date by forcing myself to blog about them. All that being said, I have spent ... [Read more...]

Window Functions in SQL vs. R

March 1, 2019 | Pete Talbert

Both MS SQL Server and R’s dplyr package offer window functions for different operations on a dataset. What are window functions? Window functions operate on a set of rows or “window” and return a value for each row, whether that’s something like a ... [Read more...]

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)