The ultimate reference guide to data wrangling with Python and R
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
Python filled in some python join objectives Oct 2, 2016

Anxious to start? Data Wrangling with pandas (Python) | Data Wrangling with data.table (R)


Data science is 90% cleaning the data and 10% complaining about cleaning the data.

In the realm of data wrangling, data.table from R and pandas from Python dominate. This repo is meant to be a comprehensive, easy to use reference guide on how to do common operations with data.table and pandas, including a cross-reference between them as well as speed comparisons.

Files & Data

This repo consists of three primary directories:

The Python and R directories each contain three similarly structured files:

The wrangle files make use of four datasets in the Data directory:

These datasets are small for illustrative purposes. If you'd like to test speed comparisons between pandas and data.table, you can use the make_data.R file to generate large versions of these datasets.

Call for contributions

I'd like to encourage contributions for this project - it's well suited for it. Also note that I'm much more comfortable using data.table than pandas, so it's likely I've done some suboptimal wrangling in pandas.


If you'd like to contact me regarding bugs, questions, or general consulting, feel free to drop me a line -