statrefs home‎ > ‎Main‎ > ‎Methods‎ > ‎

Data Management


"Practical Data Cleaning: 19 Essential Tips to Scrub Your Dirty Data"
by Lee Baker (Ph.D.)

Importing data from Excel

Importing data from .csv, .txt, .rtf, or tab-delimited file

Importing data from MS Access using ODBC

Stacking and unstacking data (in R, 'wide' to 'long' format)

Using Visual Basic for Applications (VBA) in MS Excel to reformat data

Recoding variables

Creating a subset of a data file

Joins (inner, outer; left, right)


sqldf home page