Andrade

Automate boring emails with PythonPhoto by Onlineprinters on UnsplashDo you know what most office jobs have in common? In most of them, you have to send emails regularly.It doesn't matter if you’re a programmer, data scientist, or engineer, chances are you have to read and respond to emails on a daily basis. This activity doesn’t add any value to our profession, yet it stops our workflow and takes our valuable time.The solution? Automate it with Python!In this guide, I’ll show you how to automate sending emails with…

Here are 3 tools that are better than Excel, VBA, and Power QueryImage via Shutterstock under license to Frank AndradeIf you’re an advanced Excel user probably you’ve used VBA to create macros and automate repetitive tasks or used Power Query to clean and transform data.They’re good tools, but when it comes to creating custom automation and working with large data at a fast speed, Microsoft Excel isn’t enough.Here’s when you need a programming language like Python.Python has hundreds of libraries that make data…

A guide to creating spreadsheets and saving data to Google Sheets with Python.Image via Shutterstock under license to Frank AndradeDid you know Google Sheets can be used as a lightweight database?Google Sheets is a cloud-based spreadsheet application that can store data in a structured way just like most database management systems. You can also edit and delete data with a couple of clicks and, on top of that, access your data online.Although Google Sheets has limitations such as the numbers of cells you can use (up to 10…