One thing you're likely to discover when developing a robust approach for automatic updates is that you might have to come up with a way of scrapping the previous update and replacing it with the latest one. At least that's what I came to painfully realize a month after I fully coded my PowerPoint slides … Continue reading How do I only delete certain slides in a presentation?
A few of you asked me if there was anything specific in the separate saving procedure I would call at the end of my PowerPoint slides consolidation routine as well as what my reasoning for its inclusion in the code in the first place was. Well, I had several requirements: (1) The date when the … Continue reading How do I quickly save a presentation under a new name and file extension?
As a reporting analyst, part of my responsibilities involved compiling the monthly review slide deck for senior management Whilst it was not a difficult task, it was a pretty boring and time consuming one. Every month, I had to to compile 10 decks, each consisting of 70 slides, which had to be updated to show … Continue reading How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?
We'll be using the oldie but goldie Boston Housing dataset, which you can find attached here - BostonHousing to try and predict the median value of a home, indicated by the MEDV variable. The other variables defined in the dataset are: # CRIM per capita crime rate by town # ZN proportion of residential land zoned for lots … Continue reading How do I run linear regression with Python?
Contrary to what you might think - running a linear regression (be it in Python, R, SPSS or Excel) is not rocket science! What's trickier is the outcome interpretation, so let's first have a bit of review of what linear regression is all about! Regression analysis is a method of supervised learning used to predict … Continue reading How do I interpret linear regression?