Today I Learned

Here you’ll find posts related to things I’ve learned recently.

Notes on date and time data types in PostgreSQL

til

notes

links

sql

postgresql

A scratchpad of concepts and code examples I collected while learning about the dates and times data types

Collin K. Berke, Ph.D.

Notes on identifying explicit and implicit missing values

til

notes

links

data wrangling

Highlights from the DSLC book club discussion of Chapter 18: Missing values from R4DS

Collin K. Berke, Ph.D.

Notes on the use and management of GitHub projects

til

notes

links

productivity

project management

github

Learning how to take project management to the next level

Collin K. Berke, Ph.D.

Notes on link blogs and more frequent blog posting

til

notes

links

quotes

blogging

Some notes, quotes, and links about writing more and sharing your work

Collin K. Berke, Ph.D.

Use `list2env()` or `glue::glue_data()` to use a set of elements from a tibble in a string

til

base r

data wrangling

Need an easy way to access a set of elements from a tibble for string interpolation? Here’s two examples

Collin K. Berke, Ph.D.

Separate character strings into rows and columns using `tidyr` functions

til

tidyr

data wrangling

Need to separate strings? Use the separate_* family of functions

Collin K. Berke, Ph.D.

Summarize logical vectors to calculate numeric summaries

til

data wrangling

logical vectors

summary statistics

Need proportion and count summaries from a logical vector? Use mean() and sum()

Collin K. Berke, Ph.D.

Use `base::dput()` to easily create and save objects

productivity

vim

testing

data wrangling

Need to create and store an object quickly, use this trick

Collin K. Berke, Ph.D.

Combine plots using `patchwork`

data visualization

Need to add two or more plots together? Use the patchwork package

Collin K. Berke, Ph.D.

Using `base::tempdir()` for temporary data storage

data wrangling

workflow

productivity

Need to store data in a place that’s not persistent, use a temporary directory

Collin K. Berke, Ph.D.

Calculating correlations with `corrr`

data analysis

exploratory analysis

data visualization

Use the corrr package to calculate and visualize correlations

Collin K. Berke, Ph.D.

Edit an older unpushed commit

git

GitHub

Use git rebase to edit previous commit messages

Collin K. Berke, Ph.D.

Find and replace in Vim

vim

neovim

productivity

Improving productivity by using Vim’s :substitute command

Collin K. Berke, Ph.D.