For the particular tasks of "data automation tasks, manipulating sql queries, and data-munging for machine learning," Python is indeed better than R, especially with sklearn
For other applications (especially charting and data manipulation with ggplot2 and dplyr respectively), R has an edge.