We made a comparison of various Pandas functions for indexing, vectorization and filtering. We benchmarked and compared their performance. For example, we found out that using a vectorized function to transform data is 82000x faster than using a for-loop with iloc[]. Check out the blog post with more details on various Pandas optimizations here: https://medium.com/bigdatarepublic/advanced-pandas-optimize-speed-and-memory-a654b53be6c2