Decrease Data Entry Errors with Drop Down Menus
Whenever you manually enter data, you leave room for errors. One way to decrease the number of data entry errors is to use drop-down menus…
Three Ways to Split Delimited Strings in Excel
Excel makes it easy to split text strings that contain multiple pieces of information into two or more columns. Read on to learn how…
Select Columns by Name in R
When analyzing a data set, sometimes you want to select columns (or variables) by name. This post shares several methods for selecting columns from a data frame by name in the R environment…
Select Columns of a Specific Type in R
When analyzing a data set, sometimes you only want to include columns with a certain data type…
Removing Extra Spaces in a (Text) String
Extra spaces in text data are a common problem. This post shares three ways to remove (all) unwanted spaces in a text string in R…
Apply a Process to Multiple Data Sets
Data processing can be streamlined in the R environment when data files have the same variables and general structure…