Linear Regression – Predicting a new employee’s ‘Salary’ from their ‘Years of Experience’

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?

KAGGLE – Who was likely to survive the Titanic? (With Python & Seaborn)

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.

VBA Code for ‘Last Week’s Saturday’ – & other dates!

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 …

Quickly Comment/Uncomment code in VBA

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 …

How to run an SQL Query in Excel with 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 …

Web-scraping Final Fantasy VII with Python & Beautiful Soup

Over the last week I've been figuring out how to web scrape, using some handy tutorials from the internet (mostly this one from Data Science Dojo). I've learnt a lot about Python and Beautiful Soup, and I'm here to share some of that sweet, sweet knowledge with you today! I'm a big fan of video …

Data Deities 01 – Nadieh Bremer

Data Deities is a segment on GirlvsData where I take a moment to have a bit of a ramble about people I find inspiring in the Data Science industry.   Today's 'Data Deity' is Amsterdam-based Nadieh Bremer, the visualization designer and artist behind Visual Cinnamon and one half of the artistic visualization duo Data Sketch|es. …

‘For’ loops in python tutorial

I'm currently teaching myself how to web scrape with python. Once I've worked out all the kinks in that, I'll upload something on here to show you some tips and tricks on how it works, and where I went wrong/right along the way. In the meantime, I've been trying to figure out how to use …

A quick introduction

Hello World! My name is Brooke, and I'm currently at the beginning of my journey into the world of Analytics and Data Science. I'm starting this blog as a place for me to document my journey and connect with other people to help me learn and grow! Here's a couple of things you can expect …