I usually use pandas as exploratory data tool and then rewrite code using numpy because pandas needs much more memory and is lot slower.