Comparison with other tools# Comparison with R / R libraries Quick reference Base R plyr reshape / reshape2 Comparison with SQL Copies vs. in place operations SELECT WHERE GROUP BY JOIN UNION LIMIT pandas equivalents for some SQL analytic and aggregate functions UPDATE DELETE Comparison with spreadsheets Data structures Data input / output Data operations String processing Merging Other considerations Comparison with SAS Data structures Data input / output Data operations String processing Merging Missing data GroupBy Other considerations Comparison with Stata Data structures Data input / output Data operations String processing Merging Missing data GroupBy Other considerations