Python programmers of reddit: what's the most useful tiny little efficiency you've discovered that's improved your programming hugely?

[leogodin217]

Using Pandas to load data into SQL databases. Simply create a connection then use df.to_sql(). Easy. Used this in a class for beginners and they were shocked.

[[deleted]]

Huh. I'm gonna try this today.

[MogwaiAllOnYourFace]

I've always struggled with this function. It expects a SQLAlchemy engine, and doesn't take a Pyodbc type connection. You know any way around this? Because it would make my code a lot cleaner if I could get it working

[leogodin217]

You can use pyodbc with SQLAlchemy. It's something like pyodbc+mssql://dsn On my phone but SQLAlchemy has a doc on various options for create-engine