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
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
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 … Continue reading Web-scraping Final Fantasy VII with Python & Beautiful Soup
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. … Continue reading Data Deities 01 – Nadieh Bremer
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 … Continue reading ‘For’ loops in python tutorial
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 … Continue reading A quick introduction