SQLAlchemy for MySQL and PandasRunning SQL queries and loading the results directly into a Pandas dataframe with SQLAlchemy (read_sql_query()). Using this approach, the 4.5+ seconds it took in Eric’s example to grab data, analyze the data, and return the data was reduced to about 1.5 seconds. Impressive gains for just switching out the connection/management method.ERIC BROWN

Get a Data Science Job in 6 Months, GuaranteedWith 1-on-1 mentorship, career coaching, and personalized support, you’ll gain the skills and experience you need to get hired in a new role with Springboard’s Data Science Career Track. The average reported salary increase was $23k. Launch your new career with Springboard. Apply today →SPRINGBOARDsponsor

Sending Emails With PythonFind out how to send plain-text and HTML messages, add files as attachments, and send personalized emails to multiple people using Python. Covers talking directly to an SMTP server and how to use the APIs of a transactional email service like Sendgrid (which is what we do for PyCoder’s Weekly).REAL PYTHON

The Rise of Python for Embedded Systems ContinuesObviously these folks have a horse in the race here, but it’s cool to see that Python is getting traction in the embedded programming space. I’d definitely prefer to write my IoT logic in Python than in C, if the performance constraints allow it.ZERYNTH.COM

Using Pip in a Conda EnvironmentWhat you can do to avoid breakage when using Conda and Pip together in the same Python environment. From personal (workshop) experience I know that this is something that new Pythonistas run into.ANACONDA.COM

All Things Being Equal: “is” vs “==”To test equality, Python allows one to use “==” to test for values and “is” to test for identity. Find out the difference between the two in this easy to understand beginner’s article.HARLIN SERITT • Shared by Ricky White