As I have said before, I don’t believe their are truly “best practices”, sometimes there are “best known practices”, or “best known practices for a given context”. But, there are often times when it is clear something is a bad practice. And through the school of hard knocks, I’ve learned from attempting some practices that I thought were good, but turned out to be bad. So here is what I have learned.
Often I run into situations where it makes sense to do analysis of a lot of database data in an Excel spreadsheet, but due to the amount of processing the spreadsheet requires when updating, it takes a long time for the spreadsheet to “Refresh All”.
One solution to this problem is to automate the spreadsheet so it refreshes every night. The following is a small Python script that can do this using the Python for Windows Extension:
While Carleton College has a good guide about the differences that new students will likely see between the two, and there is an excellent blog article about why Python 3 hasn’t been more widely adopted, and the official Python site tries to explain the differences between the two versions; I have not been able to find any guides on how to write code that will automatically work in Python 3.x and the latest version of 2.x. This is surprising, because one of the ways to get past the “gravity” of Python 2, is for people to learn to code in a manner that works for both 2 & 3. So I decided to write a short guide myself.