Vlookups are a very powerful excel formula and they are used a lot to blend & match data in excel. In this example I am going to show you how you can do a Vlookup in python in a few lines of code. Why? Excel vlookups over complex strings and large datasets are very compute […]
Pandas Tutorials
Python Web Scraping Tutorial For Beginners
Introduction to web scraping In a ideal world you wouldn’t need to scrape the web, but the world is far from ideal, websites are far from well structured and in order to gather the data we need it’s likely you’ll have to scrape. I currently find myself having to extract information from the web almost […]
Upload a Big CSV file into Big Query
Big query is a really good, cheap, quick (insert superlative) platform to query and visualise data. It has a simple connector into DataStudio which is great to use in reporting as it’s very sharable. Big Query has its limits and one of them is getting data into it. To upload directly within the interface there […]