Command prompt is available on almost every single version of Windows. It's an oft-forgotten and undervalued tool for a huge range of automation processes, one of which I'll be outlining today.
This is the second day of the 5 Day Data Challenge on Kaggle and today we are plotting a numeric value on a histogram in Python. Check it out below, or click this link if you’d prefer to read my code on the Gist website instead. Thanks!
When it comes to Data Science, I'm always shooting to be the very best, like no one ever was, so what's a better dataset to analyse than this POKEMON dataset from Kaggle! Today is the first day of the 5 Day Data Challenge on Kaggle and we are reading in and summarizing a .csv in Python. Check it out below, or click this link if you'd prefer to read my code on the Gist website instead. Thanks!
This is my first Kaggle submission, including data cleaning, feature selection and visualisations to make some first impressions on what the data story is telling us about who is most likely to survive. I'll be making some other submissions soon including testing out a few different Machine Learning classifiers to make predictions.
These codes come in handy for me all of the time - Whenever I need to automatically save a report with the Week Ending Date, or if I need to calculate something from a SQL query that needs a specific date, I chuck one of these codes. I thought it might come in handy for … Continue reading VBA Code for ‘Last Week’s Saturday’ – & other dates!
Unfortunately, there's no shortcut for commenting/uncommenting blocks of code in VBA - but there are a couple of handy buttons you can add to your toolbar to save you from going through and adding/removing apostrophes from every. single. line! Just follow these steps to turn on the toolbar buttons: In your Excel workbook, if you … Continue reading Quickly Comment/Uncomment code in VBA
I've been making a lot of reports and dashboards combining my love of SQL and Excel lately, so I've put together a neat guide of fully customizable, ultra-commented VBA code to show you how to make a VBA Macro do your SQL bidding. Check it out, and let me know what you think in the … Continue reading How to run an SQL Query in Excel with VBA