[itschekkers]

Ya, completely agree with this (having also used both extensively). dplyr can also connect to remote SQL server so data don't have to be local. Maybe pandas does this now too but in my experience SQL connections were generally more painful in python

[Analog24]

This is what SQLAlchemy is for. It's one of the best ORMs out there and makes interacting with a SQL server a breeze.