
Filtering by Multiple Conditions in R
Advanced filtering conditions can be specified using logical operators like AND, OR, and NOT. This post shows how to filter data by multiple criteria in the R environment.

The Fundamentals of Filtering in R
Filtering is the process of selecting rows or columns from a data set based on specific criteria. In this post, I provide a primer on how to subset data by a single condition in the R environment…

Parsing data into pieces
Merging data from different sources is easy to do when you have a common unique identifier…

Question(able) Format: Missing ≠ No
Being able to distinguish missing responses from ‘no’ responses is an important but often overlooked issue in survey design and analysis…

Visualizing Data with Data Bars
Data bars are a powerful yet underused built-in Excel feature for quickly visualizing large amounts of data…

Simplify Excel Formulas Using Named Ranges
A named range is a feature in Excel that allows you to easily reference individual cells or groups of cells within a workbook using a descriptive name…