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!
The Business Challenge: We need to know which salary to assign to a person depending on how many years of experience they have in the business. We have a prospective employee with 5 years of experience, and we need to know how much we should pay them. Based on the data we have about 30 employees; their Years of Experience and their Salary, can we predict an employee's Salary only given their Years of Experience?
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