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

Data Management



e-book

"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)


Merge



sqldf home page http://sqldf.googlecode.com